Model Electronic Approvals
| Object Name | Object Type | Layer Name |
|---|---|---|
| GOBEACC | SQL Table | Default |
| GTVZIPC | SQL Table | Default |
| NBRJLBD | SQL Table | Default |
| NBRJOBS | SQL Table | Default |
| NOBTRAN | SQL Table | Main Objects |
| NORCMNT | SQL Table | Default |
| NOREAER | SQL Table | Main Objects |
| NORROUT | SQL Table | Main Objects |
| NORTERN | SQL Table | Main Objects |
| NORTLBD | SQL Table | Main Objects |
| NORTRAN | SQL Table | Main Objects |
| NTRACAT | SQL Table | Default |
| NTRACLV | SQL Table | Default |
| NTRADFV | SQL Table | Default |
| NTRAGID | SQL Table | Default |
| NTRAGRP | SQL Table | Default |
| NTRALVL | SQL Table | Default |
| NTRAPFB | SQL Table | Default |
| NTRAPFD | SQL Table | Default |
| NTRAUBK | SQL Table | Default |
| NTRAUFD | SQL Table | Default |
| NTRAUFM | SQL Table | Default |
| NTRINST | SQL Table | Default |
| NTRLVID | SQL Table | Default |
| NTRPROX | SQL Table | Default |
| NTRROUT | SQL Table | Default |
| NTRRQUE | SQL Table | Default |
| NTRSALB | SQL Table | Default |
| NTVACAT | SQL Table | Default |
| NTVAGRP | SQL Table | Default |
| NTVAPTY | SQL Table | Default |
| PERJHIS | SQL Table | Default |
| PTRINST | SQL Table | Default |
| PTRLREA | SQL Table | Default |
| SPRTELE | SQL Table | Default |
Table GOBEACC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GOBEACC_PIDM | NUMBER(8,0) | No | * | ||
| GOBEACC_USERNAME | VARCHAR2(30) | No | * | ||
| GOBEACC_USER_ID | VARCHAR2(30) | No | |||
| GOBEACC_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GOBEACC_USERNAME | NTRPROX_PROXY_USER_ID | NTRPROX |
| GOBEACC_USERNAME | NTRPROX_USER_ID | NTRPROX |
| Index Name | Index Type | Column Name |
|---|---|---|
| GOBEACC_KEY_INDEX | Unique | GOBEACC_USERNAME |
| PK_GOBEACC | Unique | GOBEACC_PIDM |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBEACC_KEY_INDEX | SQL Index | S10B80.GENERAL | Rely On |
| PK_GOBEACC | SQL Index | S10B80.GENERAL | Rely On |
| NTRPROX | SQL Table | S10B80.POSNCTL | Join |
| GT_GOBEACC_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:32:08:000 | 04/02/2008 21:17:56:000 |
Table GTVZIPC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVZIPC_CODE | VARCHAR2(30) | No | * | ||
| GTVZIPC_CITY | VARCHAR2(50) | No | * | ||
| GTVZIPC_STAT_CODE | VARCHAR2(3) | Yes | * | ||
| GTVZIPC_NATN_CODE | VARCHAR2(5) | Yes | * | ||
| GTVZIPC_ACTIVITY_DATE | DATE | No | |||
| GTVZIPC_USER_ID | VARCHAR2(30) | No | |||
| GTVZIPC_CNTY_CODE | VARCHAR2(5) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GTVZIPC_CNTY_CODE | STVCNTY_CODE | STVCNTY |
| GTVZIPC_NATN_CODE | STVNATN_CODE | STVNATN |
| GTVZIPC_STAT_CODE | STVSTAT_CODE | STVSTAT |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVZIPC | Unique | GTVZIPC_CODE |
| PK_GTVZIPC | Unique | GTVZIPC_CITY |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GUBGISL | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVZIPC_ADD | SQL View | S10B80.BANINST1 | Use (select) |
| GTVZIPC_ADS | SQL View | S10B80.BANINST1 | Use (select) |
| INTERPRETZIPC | Oracle Package Cursor | S10B80.BANINST1.BWSKALOG | Use (select) |
| GTVZIPCC | Oracle Package Cursor | S10B80.BANINST1.GTKZIPC | Use (select)Rely On |
| P_GET_CITY_STATE_NATION | Oracle Package Procedure | S10B80.BANINST1.NOKEPAF | Use (select) |
| P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.FB_INVOICE_HEADER_RULES | Rely On |
| P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.FB_INVOICE_HEADER_RULES | Use (select)Rely On |
| F_SORXREF_CHK | Oracle Package Function | S10B80.BANINST1.SAKPCOM | Use (select) |
| F_SORXREF_VAL | Oracle Package Function | S10B80.BANINST1.SAKPCOM | Use (select) |
| GTVZIPC | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVZIPC | SQL Index | S10B80.GENERAL | Rely On |
| STVCNTY | SQL Table | S10B80.SATURN | Refer (no action) |
| STVNATN | SQL Table | S10B80.SATURN | Refer (no action) |
| STVSTAT | SQL Table | S10B80.SATURN | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:29:000 | 04/02/2008 21:17:57:000 |
Table NBRJLBD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NBRJLBD_PIDM | NUMBER(8,0) | No | * | ||
| NBRJLBD_POSN | VARCHAR2(6) | No | * | ||
| NBRJLBD_SUFF | VARCHAR2(2) | No | * | ||
| NBRJLBD_EFFECTIVE_DATE | DATE | No | |||
| NBRJLBD_COAS_CODE | VARCHAR2(1) | Yes | |||
| NBRJLBD_ACCI_CODE | VARCHAR2(6) | Yes | |||
| NBRJLBD_FUND_CODE | VARCHAR2(6) | Yes | |||
| NBRJLBD_ORGN_CODE | VARCHAR2(6) | Yes | |||
| NBRJLBD_ACCT_CODE | VARCHAR2(6) | Yes | |||
| NBRJLBD_PROG_CODE | VARCHAR2(6) | Yes | |||
| NBRJLBD_ACTV_CODE | VARCHAR2(6) | Yes | |||
| NBRJLBD_LOCN_CODE | VARCHAR2(6) | Yes | |||
| NBRJLBD_PROJ_CODE | VARCHAR2(8) | Yes | |||
| NBRJLBD_CTYP_CODE | VARCHAR2(2) | Yes | |||
| NBRJLBD_ACCT_CODE_EXTERNAL | VARCHAR2(60) | Yes | |||
| NBRJLBD_PERCENT | NUMBER(5,2) | No | |||
| NBRJLBD_ENCD_NUM | VARCHAR2(8) | Yes | |||
| NBRJLBD_ENCD_SEQ_NUM | NUMBER(4,0) | Yes | |||
| NBRJLBD_SALARY_ENCUMBRANCE | NUMBER(11,2) | Yes | |||
| NBRJLBD_SALARY_ENC_TO_POST | NUMBER(11,2) | No | |||
| NBRJLBD_FRINGE_ENCUMBRANCE | NUMBER(11,2) | Yes | |||
| NBRJLBD_FRINGE_ENC_TO_POST | NUMBER(11,2) | No | |||
| NBRJLBD_FUND_CODE_FRINGE | VARCHAR2(6) | Yes | |||
| NBRJLBD_ORGN_CODE_FRINGE | VARCHAR2(6) | Yes | |||
| NBRJLBD_ACCT_CODE_FRINGE | VARCHAR2(6) | Yes | |||
| NBRJLBD_PROG_CODE_FRINGE | VARCHAR2(6) | Yes | |||
| NBRJLBD_ACTV_CODE_FRINGE | VARCHAR2(6) | Yes | |||
| NBRJLBD_LOCN_CODE_FRINGE | VARCHAR2(6) | Yes | |||
| NBRJLBD_CHANGE_IND | VARCHAR2(1) | No | |||
| NBRJLBD_ACTIVITY_DATE | DATE | No | |||
| NBRJLBD_FRINGE_RESIDUAL | NUMBER(11,2) | Yes | |||
| NBRJLBD_FRINGE_RES_TO_POST | NUMBER(11,2) | Yes | |||
| NBRJLBD_USER_ID | VARCHAR2(30) | Yes | |||
| NBRJLBD_DATA_ORIGIN | VARCHAR2(30) | Yes | |||
| NBRJLBD_FUTURE_SALARY_ENC | NUMBER(17,2) | Yes | |||
| NBRJLBD_FUTURE_FRINGE_ENC | NUMBER(17,2) | Yes | |||
| NBRJLBD_FUTURE_FRINGE_RESIDUAL | NUMBER(17,2) | Yes | |||
| NBRJLBD_FUTURE_SAL_ENC_TO_POST | NUMBER(17,2) | Yes | |||
| NBRJLBD_FUTURE_FRG_ENC_TO_POST | NUMBER(17,2) | Yes | |||
| NBRJLBD_FUTURE_FRG_RES_TO_POST | NUMBER(17,2) | Yes | |||
| NBRJLBD_ENC_OVERRIDE_END_DATE | DATE | Yes | |||
| NBRJLBD_ENC_LAST_RECAST_DATE | DATE | Yes | |||
| NBRJLBD_ENC_LAST_CALC_DATE | DATE | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NBRJLBD_PIDM | NBREJOB_PIDM | NBREJOB |
| NBRJLBD_POSN | NBREJOB_POSN | NBREJOB |
| NBRJLBD_SUFF | NBREJOB_SUFF | NBREJOB |
| NBRJLBD_SUFF | PERJOBS_SUFF | PERJOBS |
| NBRJLBD_POSN | PERJOBS_POSN | PERJOBS |
| NBRJLBD_PIDM | PERJOBS_PIDM | PERJOBS |
| Index Name | Index Type | Column Name |
|---|---|---|
| NBRJLBD_KEY2_INDEX | NBRJLBD_FUND_CODE | |
| NBRJLBD_KEY2_INDEX | NBRJLBD_ORGN_CODE | |
| NBRJLBD_KEY2_INDEX | NBRJLBD_ACCT_CODE | |
| NBRJLBD_KEY2_INDEX | NBRJLBD_PROG_CODE | |
| NBRJLBD_KEY2_INDEX | NBRJLBD_ACTV_CODE | |
| NBRJLBD_KEY2_INDEX | NBRJLBD_LOCN_CODE | |
| NBRJLBD_KEY3_INDEX | NBRJLBD_SALARY_ENC_TO_POST | |
| NBRJLBD_KEY_INDEX | NBRJLBD_PIDM | |
| NBRJLBD_KEY_INDEX | NBRJLBD_POSN | |
| NBRJLBD_KEY_INDEX | NBRJLBD_SUFF | |
| NBRJLBD_KEY_INDEX | NBRJLBD_EFFECTIVE_DATE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NBRJLBD_KEY2_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NBRJLBD_KEY3_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NBRJLBD_KEY_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NBREJOB | SQL Table | S10B80.POSNCTL | Join |
| PERJOBS | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:30:10:000 | 04/02/2008 13:49:03:000 |
Table NBRJOBS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NBRJOBS_PIDM | NUMBER(8,0) | No | * | * | |
| NBRJOBS_POSN | VARCHAR2(6) | No | * | * | |
| NBRJOBS_SUFF | VARCHAR2(2) | No | * | * | |
| NBRJOBS_EFFECTIVE_DATE | DATE | No | * | * | |
| NBRJOBS_STATUS | VARCHAR2(1) | No | |||
| NBRJOBS_DESC | VARCHAR2(30) | Yes | |||
| NBRJOBS_ECLS_CODE | VARCHAR2(2) | No | |||
| NBRJOBS_PICT_CODE | VARCHAR2(2) | No | * | ||
| NBRJOBS_COAS_CODE_TS | VARCHAR2(1) | Yes | |||
| NBRJOBS_ORGN_CODE_TS | VARCHAR2(6) | No | * | ||
| NBRJOBS_SAL_TABLE | VARCHAR2(2) | Yes | * | ||
| NBRJOBS_SAL_GRADE | VARCHAR2(5) | Yes | * | ||
| NBRJOBS_SAL_STEP | NUMBER(3,0) | Yes | |||
| NBRJOBS_APPT_PCT | NUMBER(5,2) | No | |||
| NBRJOBS_FTE | NUMBER(6,3) | Yes | |||
| NBRJOBS_HRS_DAY | NUMBER(6,2) | No | |||
| NBRJOBS_HRS_PAY | NUMBER(6,2) | No | |||
| NBRJOBS_SHIFT | VARCHAR2(1) | No | |||
| NBRJOBS_REG_RATE | NUMBER(11,6) | Yes | |||
| NBRJOBS_ASSGN_SALARY | NUMBER(11,2) | No | |||
| NBRJOBS_FACTOR | NUMBER(3,1) | No | |||
| NBRJOBS_ANN_SALARY | NUMBER(11,2) | No | |||
| NBRJOBS_PER_PAY_SALARY | NUMBER(11,2) | No | |||
| NBRJOBS_PAYS | NUMBER(3,1) | No | |||
| NBRJOBS_PER_PAY_DEFER_AMT | NUMBER(11,2) | No | |||
| NBRJOBS_ACTIVITY_DATE | DATE | No | |||
| NBRJOBS_JCRE_CODE | VARCHAR2(5) | Yes | * | ||
| NBRJOBS_SGRP_CODE | VARCHAR2(6) | No | * | ||
| NBRJOBS_EMPR_CODE | VARCHAR2(4) | Yes | |||
| NBRJOBS_LGCD_CODE | VARCHAR2(4) | Yes | |||
| NBRJOBS_LOCN_CODE | VARCHAR2(6) | Yes | |||
| NBRJOBS_SCHL_CODE | VARCHAR2(6) | Yes | |||
| NBRJOBS_SUPERVISOR_PIDM | NUMBER(8,0) | Yes | |||
| NBRJOBS_SUPERVISOR_POSN | VARCHAR2(6) | Yes | |||
| NBRJOBS_SUPERVISOR_SUFF | VARCHAR2(2) | Yes | |||
| NBRJOBS_WKCP_CODE | VARCHAR2(4) | Yes | |||
| NBRJOBS_JBLN_CODE | VARCHAR2(6) | Yes | |||
| NBRJOBS_PERS_CHG_DATE | DATE | No | |||
| NBRJOBS_PCAT_CODE | VARCHAR2(4) | Yes | |||
| NBRJOBS_DFPR_CODE | VARCHAR2(4) | Yes | |||
| NBRJOBS_ENCUMBRANCE_HRS | NUMBER(6,2) | Yes | |||
| NBRJOBS_CONTRACT_NO | VARCHAR2(8) | Yes | |||
| NBRJOBS_STRS_ASSN_CODE | VARCHAR2(2) | Yes | |||
| NBRJOBS_STRS_PAY_CODE | VARCHAR2(2) | Yes | |||
| NBRJOBS_PERS_PAY_CODE | VARCHAR2(2) | Yes | |||
| NBRJOBS_TIME_ENTRY_METHOD | VARCHAR2(1) | No | |||
| NBRJOBS_TIME_ENTRY_TYPE | VARCHAR2(1) | No | |||
| NBRJOBS_TIME_IN_OUT_IND | VARCHAR2(1) | No | |||
| NBRJOBS_LCAT_CODE | VARCHAR2(2) | Yes | |||
| NBRJOBS_LEAV_REPT_METHOD | VARCHAR2(1) | No | |||
| NBRJOBS_PICT_CODE_LEAV_REPT | VARCHAR2(2) | No | * | ||
| NBRJOBS_USER_ID | VARCHAR2(30) | Yes | |||
| NBRJOBS_DATA_ORIGIN | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NBRJOBS_SGRP_CODE | NTRSALB_SGRP_CODE | NTRSALB |
| NBRJOBS_SAL_TABLE | NTRSALB_TABLE | NTRSALB |
| NBRJOBS_SAL_GRADE | NTRSALB_GRADE | NTRSALB |
| NBRJOBS_JCRE_CODE | PTRJCRE_CODE | PTRJCRE |
| NBRJOBS_ORGN_CODE_TS | PTVORGN_CODE | PTVORGN |
| NBRJOBS_PIDM | NBRBJOB_PIDM | NBRBJOB |
| NBRJOBS_POSN | NBRBJOB_POSN | NBRBJOB |
| NBRJOBS_SUFF | NBRBJOB_SUFF | NBRBJOB |
| NBRJOBS_EFFECTIVE_DATE | NBRBJOB_END_DATE | NBRBJOB |
| NBRJOBS_PIDM | PEBEMPL_PIDM | PEBEMPL |
| NBRJOBS_PICT_CODE | PTRCALN_PICT_CODE | PTRCALN |
| NBRJOBS_PICT_CODE_LEAV_REPT | PTRCALN_PICT_CODE | PTRCALN |
| NBRJOBS_ORGN_CODE_TS | POTPARM_ORGN_CODE_TS | POTPARM |
| NBRJOBS_PIDM | PERSNBL_PIDM | PERSNBL |
| NBRJOBS_SUFF | PERJLEV_SUFF | PERJLEV |
| NBRJOBS_POSN | PERJLEV_POSN | PERJLEV |
| NBRJOBS_PIDM | PERJLEV_PIDM | PERJLEV |
| Index Name | Index Type | Column Name |
|---|---|---|
| NBRJOBS_KEY2_INDEX | NBRJOBS_POSN | |
| NBRJOBS_KEY2_INDEX | NBRJOBS_SUFF | |
| NBRJOBS_KEY2_INDEX | NBRJOBS_PIDM | |
| NBRJOBS_KEY2_INDEX | NBRJOBS_EFFECTIVE_DATE | |
| NBRJOBS_KEY3_INDEX | NBRJOBS_PICT_CODE | |
| NBRJOBS_KEY3_INDEX | NBRJOBS_PIDM | |
| NBRJOBS_KEY3_INDEX | NBRJOBS_POSN | |
| NBRJOBS_KEY3_INDEX | NBRJOBS_SUFF | |
| NBRJOBS_KEY3_INDEX | NBRJOBS_EFFECTIVE_DATE | |
| NBRJOBS_KEY4_INDEX | NBRJOBS_EMPR_CODE | |
| NBRJOBS_KEY4_INDEX | NBRJOBS_POSN | |
| NBRJOBS_KEY4_INDEX | NBRJOBS_ECLS_CODE | |
| NBRJOBS_KEY5_INDEX | NBRJOBS_ORGN_CODE_TS | |
| NBRJOBS_KEY5_INDEX | NBRJOBS_COAS_CODE_TS | |
| NBRJOBS_KEY5_INDEX | NBRJOBS_PICT_CODE | |
| NBRJOBS_KEY5_INDEX | NBRJOBS_PIDM | |
| NBRJOBS_KEY6_INDEX | NBRJOBS_PICT_CODE_LEAV_REPT | |
| NBRJOBS_KEY6_INDEX | NBRJOBS_PIDM | |
| NBRJOBS_KEY6_INDEX | NBRJOBS_EFFECTIVE_DATE | |
| PK_NBRJOBS | Unique | NBRJOBS_PIDM |
| PK_NBRJOBS | Unique | NBRJOBS_POSN |
| PK_NBRJOBS | Unique | NBRJOBS_SUFF |
| PK_NBRJOBS | Unique | NBRJOBS_EFFECTIVE_DATE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NBRJOBS_KEY2_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NBRJOBS_KEY3_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NBRJOBS_KEY4_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NBRJOBS_KEY5_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NBRJOBS_KEY6_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| PK_NBRJOBS | SQL Index | S10B80.POSNCTL | Rely On |
| NBRBJOB | SQL Table | S10B80.POSNCTL | Join |
| NTRSALB | SQL Table | S10B80.POSNCTL | Refer (no action) |
| PEBEMPL | SQL Table | S10B80.PAYROLL | Join |
| PERJLEV | SQL Table | S10B80.PAYROLL | Join |
| PERSNBL | SQL Table | S10B80.PAYROLL | Join |
| POTPARM | SQL Table | S10B80.PAYROLL | Join |
| PTRCALN | SQL Table | S10B80.PAYROLL | Join |
| PTRJCRE | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVORGN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| ET_NBRJOBS_ADR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (delete,after,each row) |
| ET_NBRJOBS_AIR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (Insert,after,each row) |
| ET_NBRJOBS_AUR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (update,after,each row) |
| NT_NBRJOBS_DELETE_JFTE | SQL Trigger | S10B80.POSNCTL | Fire (delete,after,each row) |
| NT_NBRJOBS_INSERT_JFTE | SQL Trigger | S10B80.POSNCTL | Fire (Insert,after,each row) |
| NT_NBRJOBS_UPDATE_JFTE | SQL Trigger | S10B80.POSNCTL | Fire (update,after,each row) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:31:09:000 | 04/02/2008 13:49:04:000 |
Table NOBTRAN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NOBTRAN_TRANSACTION_NO | NUMBER(15,0) | No | * | * | |
| NOBTRAN_PIDM | NUMBER(8,0) | Yes | |||
| NOBTRAN_EFFECTIVE_DATE | DATE | Yes | |||
| NOBTRAN_ACAT_CODE | VARCHAR2(6) | No | * | ||
| NOBTRAN_TRANS_STATUS_IND | VARCHAR2(1) | No | |||
| NOBTRAN_SUBMITTOR_USER_ID | VARCHAR2(30) | Yes | |||
| NOBTRAN_CREATED_DATE | DATE | No | |||
| NOBTRAN_ORIGINATOR_USER_ID | VARCHAR2(30) | No | |||
| NOBTRAN_SUBMISSION_DATE | DATE | Yes | |||
| NOBTRAN_APPLY_IND | VARCHAR2(1) | No | |||
| NOBTRAN_APPLY_DATE | DATE | Yes | |||
| NOBTRAN_APPLY_USER_ID | VARCHAR2(30) | Yes | |||
| NOBTRAN_ACTIVITY_DATE | DATE | No | |||
| NOBTRAN_COMMENTS | RAW(1) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NOBTRAN_ACAT_CODE | NTVACAT_CODE | NTVACAT |
| NOBTRAN_TRANSACTION_NO | NORTRAN_TRANSACTION_NO | NORTRAN |
| Index Name | Index Type | Column Name |
|---|---|---|
| NOBTRAN_KEY1_INDEX | NOBTRAN_ACAT_CODE | |
| NOBTRAN_KEY2_INDEX | NOBTRAN_APPLY_IND | |
| NOBTRAN_KEY2_INDEX | NOBTRAN_APPLY_USER_ID | |
| NOBTRAN_KEY3_INDEX | NOBTRAN_TRANS_STATUS_IND | |
| NOBTRAN_KEY3_INDEX | NOBTRAN_SUBMISSION_DATE | |
| NOBTRAN_KEY_INDEX | NOBTRAN_PIDM | |
| PK_NOBTRAN | Unique | NOBTRAN_TRANSACTION_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NOBTRAN_KEY1_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NOBTRAN_KEY2_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NOBTRAN_KEY3_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NOBTRAN_KEY_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| PK_NOBTRAN | SQL Index | S10B80.POSNCTL | Rely On |
| NORTRAN | SQL Table | S10B80.POSNCTL | Join |
| NTVACAT | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NT_WFAIR_PAFCHANGE_INSERT | SQL Trigger | S10B80.POSNCTL | Fire (Insert,after,each row) |
| NT_WFAUR_PAFCHANGE_UPDATE | SQL Trigger | S10B80.POSNCTL | Fire (update,after,each row) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:30:38:000 | 04/02/2008 13:49:04:000 |
Table NORCMNT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NORCMNT_TRANSACTION_NO | NUMBER(15,0) | No | * | ||
| NORCMNT_SEQ_NO | NUMBER(6,0) | No | * | ||
| NORCMNT_COMMENTS | VARCHAR2(4000) | No | |||
| NORCMNT_ACTIVITY_DATE | DATE | No | |||
| NORCMNT_USER_ID | VARCHAR2(30) | Yes | |||
| NORCMNT_DATA_ORIGIN | VARCHAR2(30) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NORCMNT | Unique | NORCMNT_TRANSACTION_NO |
| PK_NORCMNT | Unique | NORCMNT_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NORCMNT | SQL Index | S10B80.POSNCTL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:31:41:000 | 04/02/2008 13:49:05:000 |
Table NOREAER| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NOREAER_TRANS_NO | NUMBER(15,0) | No | * | ||
| NOREAER_APTY_CODE | VARCHAR2(6) | No | * | ||
| NOREAER_SEQ_NO | NUMBER(6,0) | No | * | ||
| NOREAER_MSG_TYPE | VARCHAR2(1) | No | |||
| NOREAER_ERROR_MSG | VARCHAR2(150) | No | |||
| NOREAER_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NOREAER | Unique | NOREAER_TRANS_NO |
| PK_NOREAER | Unique | NOREAER_APTY_CODE |
| PK_NOREAER | Unique | NOREAER_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NOREAER | SQL Index | S10B80.POSNCTL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:29:25:000 | 04/02/2008 13:49:02:000 |
Table NORROUT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NORROUT_TRANSACTION_NO | NUMBER(15,0) | No | * | ||
| NORROUT_RECIPIENT_USER_ID | VARCHAR2(30) | Yes | * | ||
| NORROUT_ACTION_USER_ID | VARCHAR2(30) | Yes | |||
| NORROUT_ALVL_CODE | VARCHAR2(6) | No | * | ||
| NORROUT_ACTION_IND | VARCHAR2(1) | No | |||
| NORROUT_QUEUE_STATUS_IND | VARCHAR2(1) | No | |||
| NORROUT_STATUS_DATE_TIME | DATE | No | |||
| NORROUT_ACTIVITY_DATE | DATE | No | |||
| NORROUT_LEVEL_NO | NUMBER(5,2) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NORROUT_ALVL_CODE | NTRALVL_CODE | NTRALVL |
| NORROUT_ALVL_CODE | NTRLVID_ALVL_CODE | NTRLVID |
| NORROUT_TRANSACTION_NO | NOBTRAN_TRANSACTION_NO | NOBTRAN |
| NORROUT_RECIPIENT_USER_ID | NOBTRAN_ORIGINATOR_USER_ID | NOBTRAN |
| Index Name | Index Type | Column Name |
|---|---|---|
| NORROUT_KEY2_INDEX | NORROUT_RECIPIENT_USER_ID | |
| NORROUT_KEY2_INDEX | NORROUT_QUEUE_STATUS_IND | |
| NORROUT_KEY_INDEX | NORROUT_TRANSACTION_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NORROUT_KEY2_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NORROUT_KEY_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NOBTRAN | SQL Table | S10B80.POSNCTL | Join |
| NTRALVL | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NTRLVID | SQL Table | S10B80.POSNCTL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:29:15:000 | 04/02/2008 13:49:02:000 |
Table NORTERN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NORTERN_TRANSACTION_NO | NUMBER(15,0) | No | * | * | |
| NORTERN_APTY_CODE | VARCHAR2(6) | No | * | ||
| NORTERN_POSN | VARCHAR2(6) | No | * | ||
| NORTERN_SUFF | VARCHAR2(2) | No | * | ||
| NORTERN_EFFECTIVE_DATE | DATE | No | * | ||
| NORTERN_EARN_CODE | VARCHAR2(3) | No | * | ||
| NORTERN_HRS | NUMBER(6,2) | Yes | |||
| NORTERN_SPECIAL_RATE | NUMBER(12,6) | Yes | |||
| NORTERN_SHIFT | VARCHAR2(1) | No | |||
| NORTERN_CANCEL_DATE | DATE | Yes | |||
| NORTERN_ACTIVITY_DATE | DATE | No | |||
| NORTERN_APPLY_STATUS_IND | VARCHAR2(1) | No | |||
| NORTERN_DEEMED_HRS | NUMBER(6,2) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NORTERN_TRANSACTION_NO | NOBTRAN_TRANSACTION_NO | NOBTRAN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NORTERN | Unique | NORTERN_TRANSACTION_NO |
| PK_NORTERN | Unique | NORTERN_APTY_CODE |
| PK_NORTERN | Unique | NORTERN_POSN |
| PK_NORTERN | Unique | NORTERN_SUFF |
| PK_NORTERN | Unique | NORTERN_EFFECTIVE_DATE |
| PK_NORTERN | Unique | NORTERN_EARN_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NORTERN | SQL Index | S10B80.POSNCTL | Rely On |
| NOBTRAN | SQL Table | S10B80.POSNCTL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:30:28:000 | 04/02/2008 13:49:03:000 |
Table NORTLBD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NORTLBD_TRANSACTION_NO | NUMBER(15,0) | No | * | ||
| NORTLBD_APTY_CODE | VARCHAR2(6) | No | * | ||
| NORTLBD_POSN | VARCHAR2(6) | No | |||
| NORTLBD_SUFF | VARCHAR2(2) | No | |||
| NORTLBD_EFFECTIVE_DATE | DATE | No | |||
| NORTLBD_COAS_CODE | VARCHAR2(1) | Yes | |||
| NORTLBD_ACCI_CODE | VARCHAR2(6) | Yes | |||
| NORTLBD_FUND_CODE | VARCHAR2(6) | Yes | |||
| NORTLBD_ORGN_CODE | VARCHAR2(6) | Yes | |||
| NORTLBD_ACCT_CODE | VARCHAR2(6) | Yes | |||
| NORTLBD_PROG_CODE | VARCHAR2(6) | Yes | |||
| NORTLBD_ACTV_CODE | VARCHAR2(6) | Yes | |||
| NORTLBD_LOCN_CODE | VARCHAR2(6) | Yes | |||
| NORTLBD_PROJ_CODE | VARCHAR2(8) | Yes | |||
| NORTLBD_CTYP_CODE | VARCHAR2(2) | Yes | |||
| NORTLBD_ACCT_CODE_EXTERNAL | VARCHAR2(60) | Yes | |||
| NORTLBD_PERCENT | NUMBER(5,2) | No | |||
| NORTLBD_ACTIVITY_DATE | DATE | No | |||
| NORTLBD_APPLY_STATUS_IND | VARCHAR2(1) | No | |||
| NORTLBD_ENC_OVERRIDE_END_DATE | DATE | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NORTLBD_APTY_CODE | NTVAPTY_CODE | NTVAPTY |
| NORTLBD_TRANSACTION_NO | NOBTRAN_TRANSACTION_NO | NOBTRAN |
| Index Name | Index Type | Column Name |
|---|---|---|
| NORTLBD_KEY2_INDEX | NORTLBD_TRANSACTION_NO | |
| NORTLBD_KEY2_INDEX | NORTLBD_APTY_CODE | |
| NORTLBD_KEY2_INDEX | NORTLBD_POSN | |
| NORTLBD_KEY2_INDEX | NORTLBD_SUFF | |
| NORTLBD_KEY_INDEX | NORTLBD_FUND_CODE | |
| NORTLBD_KEY_INDEX | NORTLBD_ORGN_CODE | |
| NORTLBD_KEY_INDEX | NORTLBD_ACCT_CODE | |
| NORTLBD_KEY_INDEX | NORTLBD_PROG_CODE | |
| NORTLBD_KEY_INDEX | NORTLBD_ACTV_CODE | |
| NORTLBD_KEY_INDEX | NORTLBD_LOCN_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NORTLBD_KEY2_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NORTLBD_KEY_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| NOBTRAN | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NTVAPTY | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:30:01:000 | 04/02/2008 13:49:03:000 |
Table NORTRAN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NORTRAN_TRANSACTION_NO | NUMBER(15,0) | No | * | ||
| NORTRAN_APTY_CODE | VARCHAR2(6) | No | * | * | |
| NORTRAN_POSN | VARCHAR2(6) | Yes | |||
| NORTRAN_SUFF | VARCHAR2(2) | Yes | |||
| NORTRAN_AUFM_CODE | VARCHAR2(7) | No | * | * | |
| NORTRAN_AUBK_CODE | VARCHAR2(30) | No | * | * | |
| NORTRAN_AUFD_CODE | VARCHAR2(30) | No | * | * | |
| NORTRAN_VALUE | VARCHAR2(500) | Yes | |||
| NORTRAN_APPLY_STATUS_IND | VARCHAR2(1) | No | |||
| NORTRAN_ACTIVITY_DATE | DATE | No | |||
| NORTRAN_DISPLAY_SEQ_NO | NUMBER(5,2) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NORTRAN_APTY_CODE | NTRAPFD_APTY_CODE | NTRAPFD |
| NORTRAN_AUFM_CODE | NTRAPFD_AUFM_CODE | NTRAPFD |
| NORTRAN_AUBK_CODE | NTRAPFD_AUBK_CODE | NTRAPFD |
| NORTRAN_AUFD_CODE | NTRAPFD_AUFD_CODE | NTRAPFD |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NORTRAN | Unique | NORTRAN_TRANSACTION_NO |
| PK_NORTRAN | Unique | NORTRAN_APTY_CODE |
| PK_NORTRAN | Unique | NORTRAN_AUFM_CODE |
| PK_NORTRAN | Unique | NORTRAN_AUBK_CODE |
| PK_NORTRAN | Unique | NORTRAN_AUFD_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NORTRAN | SQL Index | S10B80.POSNCTL | Rely On |
| NTRAPFD | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:29:33:000 | 04/02/2008 13:49:02:000 |
Table NTRACAT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRACAT_ACAT_CODE | VARCHAR2(6) | No | * | * | |
| NTRACAT_APTY_CODE | VARCHAR2(6) | No | * | * | |
| NTRACAT_APTY_ENTRY_SEQ_NO | NUMBER(4,2) | No | |||
| NTRACAT_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRACAT_ACAT_CODE | NTVACAT_CODE | NTVACAT |
| NTRACAT_ACAT_CODE | NOBTRAN_ACAT_CODE | NOBTRAN |
| NTRACAT_APTY_CODE | NORTRAN_APTY_CODE | NORTRAN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRACAT | Unique | NTRACAT_ACAT_CODE |
| PK_NTRACAT | Unique | NTRACAT_APTY_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRACAT | SQL Index | S10B80.POSNCTL | Rely On |
| NOBTRAN | SQL Table | S10B80.POSNCTL | Join |
| NORTRAN | SQL Table | S10B80.POSNCTL | Join |
| NTVACAT | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:29:18:000 | 04/02/2008 13:49:02:000 |
Table NTRACLV| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRACLV_ACAT_CODE | VARCHAR2(6) | No | * | ||
| NTRACLV_ALVL_CODE | VARCHAR2(6) | No | * | ||
| NTRACLV_ACTION_IND | VARCHAR2(1) | No | |||
| NTRACLV_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRACLV_ACAT_CODE | NTVACAT_CODE | NTVACAT |
| NTRACLV_ALVL_CODE | NTRALVL_CODE | NTRALVL |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| F_CHK_ACAT | Oracle Package Function | S10B80.BANINST1.BWPKEPID | Use (select) |
| F_CHK_LAST_LEVEL | Oracle Package Function | S10B80.BANINST1.BWPKEPID | Use (select) |
| P_CHK_ROUT_APPLY_LEVEL | Oracle Package Procedure | S10B80.BANINST1.NOKEPCR | Use (select) |
| P_PRINT_DEFAULT_ROUTING | Oracle Package Procedure | S10B80.BANINST1.BWPKEPID | Use (select) |
| F_CHK_BELOW_ORIGINATOR | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Use (select) |
| F_CHK_ROUT_LEVELS | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Use (select) |
| F_OPEN_DEFAULT_ROUT_RC | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Use (select) |
| F_ROUT_FROM_NTRACAT | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Use (select) |
| NTRACLV | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NTRALVL | SQL Table | S10B80.POSNCTL | Join |
| NTVACAT | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:29:27:000 | 04/02/2008 13:49:02:000 |
Table NTRADFV| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRADFV_ACAT_CODE | VARCHAR2(6) | No | * | ||
| NTRADFV_APTY_CODE | VARCHAR2(6) | No | * | * | |
| NTRADFV_AUFM_CODE | VARCHAR2(7) | No | * | * | |
| NTRADFV_AUBK_CODE | VARCHAR2(30) | No | * | * | |
| NTRADFV_AUFD_CODE | VARCHAR2(30) | No | * | * | |
| NTRADFV_AUFD_DEFAULT | VARCHAR2(60) | Yes | |||
| NTRADFV_DEFAULT_OVERRIDE_IND | VARCHAR2(1) | No | |||
| NTRADFV_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRADFV_APTY_CODE | NTRAPFD_APTY_CODE | NTRAPFD |
| NTRADFV_AUFM_CODE | NTRAPFD_AUFM_CODE | NTRAPFD |
| NTRADFV_AUBK_CODE | NTRAPFD_AUBK_CODE | NTRAPFD |
| NTRADFV_AUFD_CODE | NTRAPFD_AUFD_CODE | NTRAPFD |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRADFV | Unique | NTRADFV_ACAT_CODE |
| PK_NTRADFV | Unique | NTRADFV_APTY_CODE |
| PK_NTRADFV | Unique | NTRADFV_AUFM_CODE |
| PK_NTRADFV | Unique | NTRADFV_AUBK_CODE |
| PK_NTRADFV | Unique | NTRADFV_AUFD_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRADFV | SQL Index | S10B80.POSNCTL | Rely On |
| NTRAPFD | SQL Table | S10B80.POSNCTL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:29:42:000 | 04/02/2008 13:49:02:000 |
Table NTRAGID| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRAGID_AGRP_CODE | VARCHAR2(8) | No | * | * | |
| NTRAGID_ORIGINATOR_USER_ID | VARCHAR2(30) | No | * | ||
| NTRAGID_ACTIVITY_DATE | DATE | No | |||
| NTRAGID_USER_ID | VARCHAR2(30) | Yes | |||
| NTRAGID_DATA_ORIGIN | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRAGID_AGRP_CODE | NTVAGRP_CODE | NTVAGRP |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRAGID | Unique | NTRAGID_AGRP_CODE |
| PK_NTRAGID | Unique | NTRAGID_ORIGINATOR_USER_ID |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRAGID | SQL Index | S10B80.POSNCTL | Rely On |
| NTVAGRP | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:30:42:000 | 04/02/2008 13:49:04:000 |
Table NTRAGRP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRAGRP_AGRP_CODE | VARCHAR2(8) | No | * | * | |
| NTRAGRP_ACAT_CODE | VARCHAR2(6) | No | * | * | |
| NTRAGRP_ACTIVITY_DATE | DATE | No | |||
| NTRAGRP_USER_ID | VARCHAR2(30) | Yes | |||
| NTRAGRP_DATA_ORIGIN | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRAGRP_ACAT_CODE | NTVACAT_CODE | NTVACAT |
| NTRAGRP_AGRP_CODE | NTVAGRP_CODE | NTVAGRP |
| NTRAGRP_AGRP_CODE | NTRAGID_AGRP_CODE | NTRAGID |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRAGRP | Unique | NTRAGRP_AGRP_CODE |
| PK_NTRAGRP | Unique | NTRAGRP_ACAT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRAGRP | SQL Index | S10B80.POSNCTL | Rely On |
| NTRAGID | SQL Table | S10B80.POSNCTL | Join |
| NTVACAT | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NTVAGRP | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:30:49:000 | 04/02/2008 13:49:04:000 |
Table NTRALVL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRALVL_CODE | VARCHAR2(6) | No | * | ||
| NTRALVL_DESC | VARCHAR2(30) | No | |||
| NTRALVL_LEVEL | NUMBER(5,2) | No | |||
| NTRALVL_SUPERUSER_IND | VARCHAR2(1) | No | |||
| NTRALVL_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRALVL | Unique | NTRALVL_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRALVL | SQL Index | S10B80.POSNCTL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:30:00:000 | 04/02/2008 13:49:03:000 |
Table NTRAPFB| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRAPFB_APTY_CODE | VARCHAR2(6) | No | * | * | |
| NTRAPFB_AUFM_CODE | VARCHAR2(7) | No | * | * | |
| NTRAPFB_AUBK_CODE | VARCHAR2(30) | No | * | * | |
| NTRAPFB_APPLY_SEQ_NO | NUMBER(4,2) | No | |||
| NTRAPFB_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRAPFB_AUFM_CODE | NTRAUBK_AUFM_CODE | NTRAUBK |
| NTRAPFB_AUBK_CODE | NTRAUBK_CODE | NTRAUBK |
| NTRAPFB_APTY_CODE | NTVAPTY_CODE | NTVAPTY |
| NTRAPFB_APTY_CODE | NTRACAT_APTY_CODE | NTRACAT |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRAPFB | Unique | NTRAPFB_APTY_CODE |
| PK_NTRAPFB | Unique | NTRAPFB_AUFM_CODE |
| PK_NTRAPFB | Unique | NTRAPFB_AUBK_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NTRAPFD | SQL Table | S10B80.POSNCTL | Refer (no action) |
| JOB_APPROVAL_TYPES_C | Oracle Package Cursor | S10B80.BANINST1.BWPKEPCR | Use (select) |
| P_DISP_ADDRTELE_BTNS | Oracle Package Procedure | S10B80.BANINST1.BWPKEPCR | Use (select) |
| P_GET_POSN_SUFF | Oracle Package Procedure | S10B80.BANINST1.NOKEDIT | Rely On |
| P_GET_POSN_SUFF | Oracle Package Procedure | S10B80.BANINST1.NOKEDIT | Use (select) |
| P_SELECTJOBBODY | Oracle Package Procedure | S10B80.BANINST1.BWPKEPCR | Use (select) |
| NTRAPFBC | Oracle Package Cursor | S10B80.BANINST1.NOKEPCR | Rely On |
| NTRAPFBC | Oracle Package Cursor | S10B80.BANINST1.NOKEPCR | Use (select)Rely On |
| P_VALIDATE_PERSON | Oracle Package Procedure | S10B80.BANINST1.BWPKEPCR | Use (select) |
| F_APTY_BLOCK_DEFINED | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Rely On |
| F_APTY_BLOCK_DEFINED | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Use (select) |
| F_FORM_EXIST_IN_ACAT | Oracle Package Function | S10B80.BANINST1.NOKEPAF | Use (select) |
| F_GET_POSN_SUFF | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Use (select) |
| F_MULTI_JOBS | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Use (select) |
| F_SPRIDEN_ID_IN_MIN_SEQNO | Oracle Package Function | S10B80.BANINST1.NOKEPAF | Use (select) |
| NTRAPFB | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRAPFB | SQL Index | S10B80.POSNCTL | Rely On |
| NTRACAT | SQL Table | S10B80.POSNCTL | Join |
| NTRAUBK | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NTVAPTY | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:31:12:000 | 04/02/2008 13:49:04:000 |
Table NTRAPFD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRAPFD_APTY_CODE | VARCHAR2(6) | No | * | * | |
| NTRAPFD_AUFM_CODE | VARCHAR2(7) | No | * | * | |
| NTRAPFD_AUBK_CODE | VARCHAR2(30) | No | * | * | |
| NTRAPFD_AUFD_CODE | VARCHAR2(30) | No | * | ||
| NTRAPFD_DISPLAY_SEQ_NO | NUMBER(5,2) | Yes | |||
| NTRAPFD_ACTIVITY_DATE | DATE | No | |||
| NTRAPFD_REQUIRED_IND | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRAPFD_APTY_CODE | NTRAPFB_APTY_CODE | NTRAPFB |
| NTRAPFD_AUFM_CODE | NTRAPFB_AUFM_CODE | NTRAPFB |
| NTRAPFD_AUBK_CODE | NTRAPFB_AUBK_CODE | NTRAPFB |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRAPFD | Unique | NTRAPFD_APTY_CODE |
| PK_NTRAPFD | Unique | NTRAPFD_AUFM_CODE |
| PK_NTRAPFD | Unique | NTRAPFD_AUBK_CODE |
| PK_NTRAPFD | Unique | NTRAPFD_AUFD_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRAPFD | SQL Index | S10B80.POSNCTL | Rely On |
| NTRAPFB | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:31:13:000 | 04/02/2008 13:49:04:000 |
Table NTRAUBK| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRAUBK_AUFM_CODE | VARCHAR2(7) | No | * | * | |
| NTRAUBK_CODE | VARCHAR2(30) | No | * | ||
| NTRAUBK_DESC | VARCHAR2(30) | No | |||
| NTRAUBK_EFFECTIVE_DATED_IND | VARCHAR2(1) | No | |||
| NTRAUBK_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRAUBK_AUFM_CODE | NTRAUFM_CODE | NTRAUFM |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRAUBK | Unique | NTRAUBK_AUFM_CODE |
| PK_NTRAUBK | Unique | NTRAUBK_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NTRAPFB | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NTRAUFD | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRAUBK | SQL Index | S10B80.POSNCTL | Rely On |
| NTRAUFM | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:30:21:000 | 04/02/2008 13:49:03:000 |
Table NTRAUFD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRAUFD_AUFM_CODE | VARCHAR2(7) | No | * | * | |
| NTRAUFD_AUBK_CODE | VARCHAR2(30) | No | * | * | |
| NTRAUFD_CODE | VARCHAR2(30) | No | * | * | |
| NTRAUFD_DESC | VARCHAR2(20) | No | |||
| NTRAUFD_FORMAT_IND | VARCHAR2(1) | No | |||
| NTRAUFD_ENTERABLE_IND | VARCHAR2(1) | No | |||
| NTRAUFD_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRAUFD_AUFM_CODE | NTRAUBK_AUFM_CODE | NTRAUBK |
| NTRAUFD_AUBK_CODE | NTRAUBK_CODE | NTRAUBK |
| NTRAUFD_AUFM_CODE | NTRAPFD_AUFM_CODE | NTRAPFD |
| NTRAUFD_AUBK_CODE | NTRAPFD_AUBK_CODE | NTRAPFD |
| NTRAUFD_CODE | NTRAPFD_AUFD_CODE | NTRAPFD |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRAUFD | Unique | NTRAUFD_AUFM_CODE |
| PK_NTRAUFD | Unique | NTRAUFD_AUBK_CODE |
| PK_NTRAUFD | Unique | NTRAUFD_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRAUFD | SQL Index | S10B80.POSNCTL | Rely On |
| NTRAPFD | SQL Table | S10B80.POSNCTL | Join |
| NTRAUBK | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:30:24:000 | 04/02/2008 13:49:03:000 |
Table NTRAUFM| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRAUFM_CODE | VARCHAR2(7) | No | * | ||
| NTRAUFM_DESC | VARCHAR2(30) | No | |||
| NTRAUFM_APPROVALS_IND | VARCHAR2(1) | No | |||
| NTRAUFM_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRAUFM | Unique | NTRAUFM_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NTRAUBK | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRAUFM | SQL Index | S10B80.POSNCTL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:30:25:000 | 04/02/2008 13:49:03:000 |
Table NTRINST| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRINST_APPROVALS_IND | VARCHAR2(1) | No | |||
| NTRINST_NBRJOBS_FUTURE_CHG_IND | VARCHAR2(1) | No | |||
| NTRINST_ACTIVITY_DATE | DATE | No | |||
| NTRINST_PROXY_SUPERUSER_IND | VARCHAR2(1) | No | |||
| NTRINST_BUDGET_ERROR_IND | VARCHAR2(1) | No | |||
| NTRINST_RETAIN_NHRFINC_IND | VARCHAR2(1) | No | |||
| NTRINST_COAS_CODE | VARCHAR2(1) | Yes | |||
| NTRINST_LOCATION_IND | VARCHAR2(1) | No | |||
| NTRINST_REJECT_WARNINGS_IND | VARCHAR2(1) | No | |||
| NTRINST_DISPLAY_WARNINGS_IND | VARCHAR2(1) | No | |||
| NTRINST_MAX_DOC_SEQ_NUM | NUMBER(4,0) | Yes | |||
| NTRINST_ACAT_CODE_TIME_ENTRY | VARCHAR2(6) | Yes | |||
| NTRINST_TE_RETURN_TO_EMPL_IND | VARCHAR2(1) | No | |||
| NTRINST_EA_ALT_LOGON_IND | VARCHAR2(1) | Yes | |||
| NTRINST_PROBATION_UNIT_IND | VARCHAR2(1) | No | |||
| NTRINST_ACAT_CODE_LEAV_REPT | VARCHAR2(6) | Yes | |||
| NTRINST_ENCUMBRANCE_RECAST_IND | VARCHAR2(1) | No | |||
| NTRINST_WEB_ALLOW_ALLJOBS_IND | VARCHAR2(1) | No | |||
| NTRINST_FLAT_AMT_PRORATE_TYPE | VARCHAR2(1) | No | |||
| NTRINST_JOB_INFO_PRORATE_TYPE | VARCHAR2(1) | No | |||
| NTRINST_ACAT_CODE_JOB_SALARY | VARCHAR2(6) | Yes | |||
| NTRINST_ACAT_CODE_DEFAULT_HRS | VARCHAR2(6) | Yes | |||
| NTRINST_ACAT_CODE_JOB_LD | VARCHAR2(6) | Yes | |||
| NTRINST_ACAT_CODE_JOB_COMBINED | VARCHAR2(6) | Yes | |||
| NTRINST_SP_ORGN_SECURITY_IND | VARCHAR2(1) | No | |||
| NTRINST_CMSC_CODE | VARCHAR2(20) | Yes | |||
| NTRINST_EA_DISPLAY_DURATION | NUMBER(3,0) | Yes | |||
| NTRINST_EA_ALERT_FLAG | NUMBER(3,0) | Yes | |||
| NTRINST_EA_USE_AGRP_IND | VARCHAR2(1) | No | |||
| NTRINST_ENC_FUTURE_FEED_IND | VARCHAR2(1) | No |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:30:53:000 | 04/02/2008 13:49:04:000 |
Table NTRLVID| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRLVID_ALVL_CODE | VARCHAR2(6) | No | * | * | |
| NTRLVID_USER_ID | VARCHAR2(30) | No | * | * | |
| NTRLVID_INACTIVE_IND | VARCHAR2(1) | No | |||
| NTRLVID_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRLVID_ALVL_CODE | NTRALVL_CODE | NTRALVL |
| NTRLVID_USER_ID | GOBEACC_USERNAME | GOBEACC |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRLVID | Unique | NTRLVID_ALVL_CODE |
| PK_NTRLVID | Unique | NTRLVID_USER_ID |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRLVID | SQL Index | S10B80.POSNCTL | Rely On |
| GOBEACC | SQL Table | S10B80.GENERAL | Join |
| NTRALVL | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:31:31:000 | 04/02/2008 13:49:05:000 |
Table NTRPROX| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRPROX_USER_ID | VARCHAR2(30) | No | * | ||
| NTRPROX_ALVL_CODE | VARCHAR2(6) | No | * | * | |
| NTRPROX_PROXY_USER_ID | VARCHAR2(30) | No | * | ||
| NTRPROX_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRPROX_ALVL_CODE | NTRALVL_CODE | NTRALVL |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRPROX | Unique | NTRPROX_USER_ID |
| PK_NTRPROX | Unique | NTRPROX_ALVL_CODE |
| PK_NTRPROX | Unique | NTRPROX_PROXY_USER_ID |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBEACC | SQL Table | S10B80.GENERAL | Join |
| PROXY_RECTYPE | Oracle Package Type | S10B80.BANINST1.NOKEPCR | Rely On |
| P_BUILD_PROXY_LIST | Oracle Package Procedure | S10B80.BANINST1.BWPKEPSM | Rely On |
| P_BUILD_PROXY_LIST | Oracle Package Procedure | S10B80.BANINST1.BWPKEPSM | Use (select) |
| P_DEL_NTRPROX | Oracle Package Procedure | S10B80.BANINST1.NOKEPCR | Rely On |
| P_DEL_NTRPROX | Oracle Package Procedure | S10B80.BANINST1.NOKEPCR | Use (delete) |
| P_DISPPROXYSETUP | Oracle Package Procedure | S10B80.BANINST1.BWPKEPAF | Rely On |
| P_INS_NTRPROX | Oracle Package Procedure | S10B80.BANINST1.NOKEPCR | Rely On |
| P_INS_NTRPROX | Oracle Package Procedure | S10B80.BANINST1.NOKEPCR | Use (Insert) |
| P_PRINT_APPR_LEVL | Oracle Package Procedure | S10B80.BANINST1.BWPKEPID | Rely On |
| P_PRINT_PROXY_SETUP | Oracle Package Procedure | S10B80.BANINST1.BWPKEPID | Rely On |
| P_PRINT_PROXY_SETUP | Oracle Package Procedure | S10B80.BANINST1.BWPKEPID | Use (select) |
| P_UPDATEPROXIES | Oracle Package Procedure | S10B80.BANINST1.BWPKEPAF | Rely On |
| F_OPEN_ALLOWED_ACATS | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Rely On |
| F_OPEN_NTRPROX | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Rely On |
| F_OPEN_NTRPROX | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Use (select) |
| NTRPROX | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRPROX | SQL Index | S10B80.POSNCTL | Rely On |
| NTRALVL | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:31:38:000 | 04/02/2008 13:49:05:000 |
Table NTRROUT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRROUT_ORIGINATOR_USER_ID | VARCHAR2(30) | No | |||
| NTRROUT_ACAT_CODE | VARCHAR2(6) | No | |||
| NTRROUT_RECIPIENT_USER_ID | VARCHAR2(30) | Yes | |||
| NTRROUT_ALVL_CODE | VARCHAR2(6) | No | * | ||
| NTRROUT_ACTION_IND | VARCHAR2(1) | No | |||
| NTRROUT_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRROUT_ALVL_CODE | NTRALVL_CODE | NTRALVL |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NTRALVL | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:29:56:000 | 04/02/2008 13:49:03:000 |
Table NTRRQUE| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRRQUE_ACAT_CODE | VARCHAR2(6) | No | |||
| NTRRQUE_APPR_SEQ_NO | NUMBER(3,0) | No | |||
| NTRRQUE_ACTION_IND | VARCHAR2(1) | No | |||
| NTRRQUE_USER_ID | VARCHAR2(30) | No | |||
| NTRRQUE_ACTIVITY_DATE | DATE | No | |||
| NTRRQUE_COAS_CODE | VARCHAR2(1) | Yes | |||
| NTRRQUE_ORGN_CODE | VARCHAR2(6) | Yes | |||
| NTRRQUE_POSN | VARCHAR2(6) | Yes | |||
| NTRRQUE_MANDATORY_APPR_IND | VARCHAR2(1) | Yes | |||
| NTRRQUE_APPR_POSN | VARCHAR2(6) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| NTRRQUE_KEY_INDEX | Unique | NTRRQUE_ACAT_CODE |
| NTRRQUE_KEY_INDEX | Unique | NTRRQUE_APPR_SEQ_NO |
| NTRRQUE_KEY_INDEX | Unique | NTRRQUE_POSN |
| NTRRQUE_KEY_INDEX | Unique | NTRRQUE_ORGN_CODE |
| NTRRQUE_KEY_INDEX | Unique | NTRRQUE_COAS_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| P_CREATE_ROUTING_QUEUE | Oracle Package Procedure | S10B80.BANINST1.PEKTECM | Rely On |
| P_CREATE_ROUTING_QUEUE | Oracle Package Procedure | S10B80.BANINST1.PEKTECM | Use (select)Rely On |
| P_NEXT_APPROVER | Oracle Package Procedure | S10B80.BANINST1.NOKMISC | Use (select) |
| NTRRQUE | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NTRRQUE_KEY_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:30:33:000 | 04/02/2008 13:49:03:000 |
Table NTRSALB| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTRSALB_TABLE | VARCHAR2(2) | No | * | * | |
| NTRSALB_GRADE | VARCHAR2(5) | No | * | * | |
| NTRSALB_IND | VARCHAR2(1) | No | |||
| NTRSALB_LOW | NUMBER(13,4) | No | |||
| NTRSALB_MIDPOINT | NUMBER(13,4) | No | |||
| NTRSALB_HIGH | NUMBER(13,4) | No | |||
| NTRSALB_ACTIVITY_DATE | DATE | No | |||
| NTRSALB_SGRP_CODE | VARCHAR2(6) | No | * | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTRSALB_SGRP_CODE | NTRSGRP_CODE | NTRSGRP |
| NTRSALB_TABLE | NTRSGRP_TABLE | NTRSGRP |
| NTRSALB_SGRP_CODE | NBBPOSN_SGRP_CODE | NBBPOSN |
| NTRSALB_TABLE | NBBPOSN_TABLE | NBBPOSN |
| NTRSALB_GRADE | NBBPOSN_GRADE | NBBPOSN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTRSALB | Unique | NTRSALB_SGRP_CODE |
| PK_NTRSALB | Unique | NTRSALB_TABLE |
| PK_NTRSALB | Unique | NTRSALB_GRADE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTRSALB | SQL Index | S10B80.POSNCTL | Rely On |
| NBBPOSN | SQL Table | S10B80.POSNCTL | Join |
| NTRSGRP | SQL Table | S10B80.POSNCTL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:31:15:000 | 04/02/2008 13:49:04:000 |
Table NTVACAT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTVACAT_CODE | VARCHAR2(6) | No | * | ||
| NTVACAT_DESC | VARCHAR2(30) | No | |||
| NTVACAT_ACTIVITY_DATE | DATE | No | |||
| NTVACAT_WEB_DESC | VARCHAR2(60) | Yes | |||
| NTVACAT_WEB_DISPLAY_SEQ_NO | NUMBER(3,0) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTVACAT | Unique | NTVACAT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NOBTRAN | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NTRACAT | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NTRACLV | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NTRAGRP | SQL Table | S10B80.POSNCTL | Refer (no action) |
| PTRLREA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| APPROVAL_RECTYPE | Oracle Package Type | S10B80.BANINST1.NOKEPAF | Rely On |
| ORIGINATOR_RECTYPE | Oracle Package Type | S10B80.BANINST1.NOKEPAF | Rely On |
| P_PRINT_PERS_IDNAME | Oracle Package Procedure | S10B80.BANINST1.BWPKEPCR | Rely On |
| NTVACAT_C | Oracle Package Cursor | S10B80.BANINST1.NB_NTVACAT | Rely On |
| NTVACAT_C | Oracle Package Cursor | S10B80.BANINST1.NB_NTVACAT | Use (select)Rely On |
| P_GET_EPAF | Oracle Package Procedure | S10B80.BANINST1.BWPCBREF | Rely On |
| P_GET_NTVACAT | Oracle Package Procedure | S10B80.BANINST1.BWPCBREF | Use (select) |
| P_PRINT_DEFAULT_ROUTING | Oracle Package Procedure | S10B80.BANINST1.BWPKEPID | Rely On |
| P_PRINT_ROUT_HEADER2 | Oracle Package Procedure | S10B80.BANINST1.BWPKEPID | Rely On |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_NB_EA_GROUP_CATEGORY | Use (Insert) |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.NB_NTVACAT | Rely On |
| F_GET_ACATDESC | Oracle Package Function | S10B80.BANINST1.BWPKEPLK | Use (select) |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.NB_NTVACAT | Rely On |
| F_GET_EPAF_DEFAULT | Oracle Package Function | S10B80.BANINST1.BWPCXCHN | Rely On |
| F_GET_NTVACAT_DESC | Oracle Package Function | S10B80.BANINST1.BWPCBREF | Rely On |
| F_OPEN_ALLOWED_ACATS | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Use (select) |
| NTVACAT | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTVACAT | SQL Index | S10B80.POSNCTL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:29:40:000 | 04/02/2008 13:49:02:000 |
Table NTVAGRP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTVAGRP_CODE | VARCHAR2(8) | No | * | ||
| NTVAGRP_DESC | VARCHAR2(30) | No | |||
| NTVAGRP_ACTIVITY_DATE | DATE | No | |||
| NTVAGRP_USER_ID | VARCHAR2(30) | Yes | |||
| NTVAGRP_DATA_ORIGIN | VARCHAR2(30) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTVAGRP | Unique | NTVAGRP_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NTRAGID | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NTRAGRP | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NTVAGRP_C | Oracle Package Cursor | S10B80.BANINST1.NB_NTVAGRP | Rely On |
| NTVAGRP_C | Oracle Package Cursor | S10B80.BANINST1.NB_NTVAGRP | Use (select)Rely On |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_NB_EA_GROUP_USER | Use (Insert) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_NB_EA_GROUP_CATEGORY | Use (Insert) |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.NB_NTVAGRP | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.NB_NTVAGRP | Rely On |
| NTVAGRP | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTVAGRP | SQL Index | S10B80.POSNCTL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:31:08:000 | 04/02/2008 13:49:04:000 |
Table NTVAPTY| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NTVAPTY_CODE | VARCHAR2(6) | No | * | * | |
| NTVAPTY_DESC | VARCHAR2(30) | No | |||
| NTVAPTY_ACTIVITY_DATE | DATE | No | |||
| NTVAPTY_WEB_DESC | VARCHAR2(60) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NTVAPTY_CODE | NOREAER_APTY_CODE | NOREAER |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_NTVAPTY | Unique | NTVAPTY_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NORTLBD | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NTRAPFB | SQL Table | S10B80.POSNCTL | Refer (no action) |
| P_ADDRTELE_DRIVER | Oracle Package Procedure | S10B80.BANINST1.BWPKEPCR | Rely On |
| P_GET_POSN_SUFF | Oracle Package Procedure | S10B80.BANINST1.BWPKEPDT | Rely On |
| P_JOB_BY_APTY | Oracle Package Procedure | S10B80.BANINST1.BWPKEPDT | Rely On |
| P_SAVE_NORTERN | Oracle Package Procedure | S10B80.BANINST1.BWPKEPDT | Rely On |
| P_SAVE_NORTLBD | Oracle Package Procedure | S10B80.BANINST1.BWPKEPDT | Rely On |
| P_SAVE_NORTRAN | Oracle Package Procedure | S10B80.BANINST1.BWPKEPDT | Rely On |
| P_WHICH_ADDRTELE | Oracle Package Procedure | S10B80.BANINST1.BWPKEPDT | Rely On |
| F_JOB_BY_APTY | Oracle Package Function | S10B80.BANINST1.BWPKEPDT | Rely On |
| P_PRINT_EPAF_ENTRIES | Oracle Package Procedure | S10B80.BANINST1.BWPKEPDT | Rely On |
| P_PRINT_NOREAER | Oracle Package Procedure | S10B80.BANINST1.BWPKEPUT | Rely On |
| P_PRINT_NOREAER | Oracle Package Procedure | S10B80.BANINST1.BWPKEPUT | Use (select) |
| F_APTY_DESC | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Rely On |
| NTVAPTY | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_NTVAPTY | SQL Index | S10B80.POSNCTL | Rely On |
| NOREAER | SQL Table | S10B80.POSNCTL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:29:06:000 | 04/02/2008 13:49:02:000 |
Table PERJHIS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PERJHIS_PIDM | NUMBER(8,0) | No | |||
| PERJHIS_POSN | VARCHAR2(6) | Yes | |||
| PERJHIS_SUFF | VARCHAR2(2) | Yes | |||
| PERJHIS_EFFECTIVE_DATE | DATE | Yes | |||
| PERJHIS_STATUS | VARCHAR2(1) | Yes | |||
| PERJHIS_ECLS_CODE | VARCHAR2(2) | Yes | * | ||
| PERJHIS_BEGIN_DATE | DATE | Yes | |||
| PERJHIS_END_DATE | DATE | Yes | |||
| PERJHIS_PAYID | VARCHAR2(2) | Yes | * | ||
| PERJHIS_SAL_TABLE | VARCHAR2(2) | Yes | |||
| PERJHIS_SAL_GRADE | VARCHAR2(5) | Yes | |||
| PERJHIS_SAL_STEP | NUMBER(3,0) | Yes | |||
| PERJHIS_HRS_DAY | NUMBER(6,2) | Yes | |||
| PERJHIS_REG_RATE | NUMBER(11,6) | Yes | |||
| PERJHIS_ASSGN_SALARY | NUMBER(11,2) | Yes | |||
| PERJHIS_ANN_SALARY | NUMBER(11,2) | Yes | |||
| PERJHIS_USER_ID | VARCHAR2(30) | No | |||
| PERJHIS_ACTIVITY_DATE | DATE | No | |||
| PERJHIS_JCRE_CODE | VARCHAR2(5) | Yes | |||
| PERJHIS_EMPR_CODE | VARCHAR2(4) | Yes | * | ||
| PERJHIS_LOCN_CODE | VARCHAR2(6) | Yes | * | ||
| PERJHIS_SCHL_CODE | VARCHAR2(6) | Yes | * | ||
| PERJHIS_SUPERVISOR_PIDM | NUMBER(8,0) | Yes | |||
| PERJHIS_SUPERVISOR_POSN | VARCHAR2(6) | Yes | |||
| PERJHIS_SUPERVISOR_SUFF | VARCHAR2(2) | Yes | |||
| PERJHIS_WKCP_CODE | VARCHAR2(4) | Yes | * | ||
| PERJHIS_JBLN_CODE | VARCHAR2(6) | Yes | * | ||
| PERJHIS_PERS_CHG_DATE | DATE | Yes | |||
| PERJHIS_DEFER_BAL | NUMBER(11,2) | Yes | |||
| PERJHIS_CONTRACT_TYPE | VARCHAR2(1) | Yes | |||
| PERJHIS_SALARY_ENCUMBRANCE | NUMBER(11,2) | Yes | |||
| PERJHIS_CONTRACT_BEGIN_DATE | DATE | Yes | |||
| PERJHIS_CONTRACT_END_DATE | DATE | Yes | |||
| PERJHIS_STEP_INCR_MON | VARCHAR2(2) | Yes | |||
| PERJHIS_STEP_INCR_DAY | VARCHAR2(2) | Yes | |||
| PERJHIS_COAS_CODE | VARCHAR2(1) | Yes | |||
| PERJHIS_ACCRUE_LEAVE_IND | VARCHAR2(1) | Yes | |||
| PERJHIS_CIVIL_SERVICE_IND | VARCHAR2(1) | Yes | |||
| PERJHIS_FRINGE_ENCUMBRANCE | NUMBER(11,2) | Yes | |||
| PERJHIS_DESC | VARCHAR2(30) | Yes | |||
| PERJHIS_COAS_CODE_TS | VARCHAR2(1) | Yes | |||
| PERJHIS_ORGN_CODE_TS | VARCHAR2(6) | Yes | |||
| PERJHIS_APPT_PCT | NUMBER(5,2) | Yes | |||
| PERJHIS_FTE | NUMBER(6,3) | Yes | |||
| PERJHIS_HRS_PAY | NUMBER(6,2) | Yes | |||
| PERJHIS_SHIFT | VARCHAR2(1) | Yes | |||
| PERJHIS_FACTOR | NUMBER(3,1) | Yes | |||
| PERJHIS_PER_PAY_SALARY | NUMBER(11,2) | Yes | |||
| PERJHIS_PAYS | NUMBER(3,1) | Yes | |||
| PERJHIS_PER_PAY_DEFER_AMT | NUMBER(11,2) | Yes | |||
| PERJHIS_SGRP_CODE | VARCHAR2(6) | Yes | |||
| PERJHIS_LGCD_CODE | VARCHAR2(4) | Yes | |||
| PERJHIS_PCAT_CODE | VARCHAR2(4) | Yes | |||
| PERJHIS_DFPR_CODE | VARCHAR2(4) | Yes | |||
| PERJHIS_ENCUMBRANCE_HRS | NUMBER(6,2) | Yes | |||
| PERJHIS_CAPTURE_DATE | DATE | Yes | |||
| PERJHIS_TOTAL_ENCUMBRANCE_HRS | NUMBER(6,2) | Yes | |||
| PERJHIS_TOTAL_CONTRACT_HRS | NUMBER(6,2) | Yes | |||
| PERJHIS_TIME_ENTRY_METHOD | VARCHAR2(1) | Yes | |||
| PERJHIS_TIME_ENTRY_TYPE | VARCHAR2(1) | Yes | |||
| PERJHIS_TIME_IN_OUT_IND | VARCHAR2(1) | Yes | |||
| PERJHIS_PROBATION_BEGIN_DATE | DATE | Yes | |||
| PERJHIS_PROBATION_END_DATE | DATE | Yes | |||
| PERJHIS_PROBATION_UNITS | NUMBER(3,0) | Yes | |||
| PERJHIS_LCAT_CODE | VARCHAR2(2) | Yes | |||
| PERJHIS_LEAV_REPT_METHOD | VARCHAR2(1) | Yes | |||
| PERJHIS_ELIGIBLE_DATE | DATE | Yes | |||
| PERJHIS_COMMENT_DATE | DATE | Yes | |||
| PERJHIS_COMMENT_USER_ID | VARCHAR2(30) | Yes | |||
| PERJHIS_COMMENT | VARCHAR2(1300) | Yes | |||
| PERJHIS_PICT_CODE_LEAV_REPT | VARCHAR2(2) | Yes | |||
| PERJHIS_DATA_ORIGIN | VARCHAR2(30) | Yes | |||
| PERJHIS_FUTURE_SALARY_ENC | NUMBER(17,2) | Yes | |||
| PERJHIS_FUTURE_FRINGE_ENC | NUMBER(17,2) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PERJHIS_JBLN_CODE | PTRJBLN_CODE | PTRJBLN |
| PERJHIS_ECLS_CODE | PTRECLS_CODE | PTRECLS |
| PERJHIS_PAYID | PTRPICT_CODE | PTRPICT |
| PERJHIS_WKCP_CODE | PTVWKCP_CODE | PTVWKCP |
| PERJHIS_LOCN_CODE | PTRLOCN_CODE | PTRLOCN |
| PERJHIS_EMPR_CODE | PTREMPR_CODE | PTREMPR |
| PERJHIS_SCHL_CODE | PTRSCHL_CODE | PTRSCHL |
| Index Name | Index Type | Column Name |
|---|---|---|
| PERJHIS_KEY_INDEX | PERJHIS_PIDM | |
| PERJHIS_KEY_INDEX | PERJHIS_POSN | |
| PERJHIS_KEY_INDEX | PERJHIS_SUFF | |
| PERJHIS_KEY_INDEX | PERJHIS_CAPTURE_DATE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| P_INS_PERJHIS | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (Insert) |
| P_UPD_PERJHIS_ENC_HRS | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (update) |
| PERJHIS | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PERJHIS_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PTRECLS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTREMPR | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRJBLN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRLOCN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRPICT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRSCHL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVWKCP | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:34:25:000 | 04/02/2008 13:49:08:000 |
Table PTRINST| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRINST_CODE | VARCHAR2(8) | No | * | ||
| PTRINST_COBRA_ADM_NAME | VARCHAR2(30) | No | |||
| PTRINST_COBRA_ADM_TITLE | VARCHAR2(30) | No | |||
| PTRINST_COBRA_INST_NAME | VARCHAR2(30) | No | |||
| PTRINST_COBRA_ADDRESS | VARCHAR2(30) | No | |||
| PTRINST_COBRA_CITY | VARCHAR2(50) | No | |||
| PTRINST_COBRA_STAT_CODE | VARCHAR2(3) | No | * | ||
| PTRINST_COBRA_PHONE_NO | VARCHAR2(12) | No | |||
| PTRINST_COBRA_CHECK_PAY_NAME | VARCHAR2(30) | No | |||
| PTRINST_COBRA_EXTEND_MONTHS | NUMBER(3,0) | No | |||
| PTRINST_COBRA_FIRST_B_GR_DAYS | NUMBER(3,0) | No | |||
| PTRINST_ACH_DEST_NO | VARCHAR2(10) | Yes | |||
| PTRINST_ACH_ORIG_NO | VARCHAR2(10) | Yes | |||
| PTRINST_ACH_DEST_NAME | VARCHAR2(23) | Yes | |||
| PTRINST_ACH_ORIG_NAME | VARCHAR2(23) | Yes | |||
| PTRINST_ACH_ACCT_NO | VARCHAR2(17) | Yes | |||
| PTRINST_ACH_STATUS | VARCHAR2(1) | Yes | |||
| PTRINST_FINANCE_DATE_IND | VARCHAR2(1) | Yes | |||
| PTRINST_ACCRUE_IND | VARCHAR2(1) | No | |||
| PTRINST_ECLS_SECURITY_IND | VARCHAR2(1) | No | |||
| PTRINST_ORGN_SECURITY_IND | VARCHAR2(1) | No | |||
| PTRINST_SALA_SECURITY_IND | VARCHAR2(1) | No | |||
| PTRINST_EMPR_SECURITY_IND | VARCHAR2(1) | No | |||
| PTRINST_EMP_TAX_FREE_COV_AMT | NUMBER(11,2) | No | |||
| PTRINST_DEP_TAX_FREE_COV_AMT | NUMBER(11,2) | No | |||
| PTRINST_ACTIVITY_DATE | DATE | No | |||
| PTRINST_TEMP_I9_LIMIT_DAYS | NUMBER(3,0) | No | |||
| PTRINST_ZIPC_CODE_COBRA | VARCHAR2(30) | Yes | |||
| PTRINST_ACH_FILE_NUMBER | NUMBER(4,0) | Yes | |||
| PTRINST_ACH_SHORT_ORIG_NAME | VARCHAR2(15) | Yes | |||
| PTRINST_NON_WORK_DAYS_GEN_IND | VARCHAR2(1) | No | |||
| PTRINST_BANK_CODE | VARCHAR2(9) | Yes | |||
| PTRINST_COMPANY_TYPE | VARCHAR2(1) | Yes | |||
| PTRINST_COMPANY_ID | VARCHAR2(9) | Yes | |||
| PTRINST_RECV_BANK_CODE | VARCHAR2(9) | Yes | |||
| PTRINST_DISPLAY_RATE_IND | VARCHAR2(1) | No | |||
| PTRINST_STRS_COUNTY_CODE | VARCHAR2(4) | Yes | |||
| PTRINST_STRS_COUNTY_DESC | VARCHAR2(40) | Yes | |||
| PTRINST_PERS_COUNTY_CODE | VARCHAR2(4) | Yes | |||
| PTRINST_PERS_COUNTY_DESC | VARCHAR2(40) | Yes | |||
| PTRINST_STRS_DISTRICT_CODE | VARCHAR2(3) | Yes | |||
| PTRINST_STRS_DISTRICT_DESC | VARCHAR2(40) | Yes | |||
| PTRINST_STRS_PERS_DATE | VARCHAR2(1) | Yes | |||
| PTRINST_FMLA_YEAR_IND | VARCHAR2(1) | Yes | |||
| PTRINST_FMLA_UNIT_IND | VARCHAR2(1) | Yes | |||
| PTRINST_SIN_IND | VARCHAR2(1) | Yes | |||
| PTRINST_MAX_YEAR_END_STMT | VARCHAR2(4) | Yes | |||
| PTRINST_FACULTY_IND | VARCHAR2(1) | Yes | |||
| PTRINST_PERFACT_CHANGE_IND | VARCHAR2(1) | No | |||
| PTRINST_WEB_CERTIFICATION_IND | VARCHAR2(1) | No | |||
| PTRINST_PERS_DISTRICT_CODE | VARCHAR2(3) | Yes | |||
| PTRINST_PERS_DISTRICT_DESC | VARCHAR2(40) | Yes | |||
| PTRINST_RANK_AUTO_APPR_IND | VARCHAR2(1) | No | |||
| PTRINST_ALVL_CODE_RANK | VARCHAR2(6) | Yes | * | ||
| PTRINST_TENURE_AUTO_APPR_IND | VARCHAR2(1) | No | |||
| PTRINST_ALVL_CODE_TENURE | VARCHAR2(6) | Yes | * | ||
| PTRINST_ACCRUE_LEAVE_METHOD | VARCHAR2(1) | No | |||
| PTRINST_ACCRUE_MAX_CALC_METHOD | VARCHAR2(1) | No | |||
| PTRINST_MIN_LEAV_DAY_INCREMENT | NUMBER(3,2) | Yes | |||
| PTRINST_ALLOW_EMPL_1PAY_IND | VARCHAR2(1) | No | |||
| PTRINST_ALVL_CODE_1PAY | VARCHAR2(6) | Yes | |||
| PTRINST_ATYP_CODE_1PAY | VARCHAR2(2) | Yes | |||
| PTRINST_TELE_CODE_1PAY | VARCHAR2(4) | Yes | |||
| PTRINST_ACAT_CODE_1PAY | RAW(1) | Yes | |||
| PTRINST_JCRE_CODE_1PAY | VARCHAR2(5) | Yes | |||
| PTRINST_TREA_CODE_1PAY | VARCHAR2(2) | Yes | |||
| PTRINST_DICD_CODE | VARCHAR2(3) | Yes | |||
| PTRINST_LEAVE_ROLL_ORDER | VARCHAR2(1) | No | |||
| PTRINST_SABB_AUTO_APPR_IND | VARCHAR2(1) | No | |||
| PTRINST_ALVL_CODE_SABB | VARCHAR2(6) | Yes | * | ||
| PTRINST_JOBS_LEAV_SYNC_IND | VARCHAR2(1) | No | |||
| PTRINST_DD_WEB_UPDATE_IND | VARCHAR2(1) | No | |||
| PTRINST_REVOKE_EW2_CONSENT_IND | VARCHAR2(1) | No | |||
| PTRINST_GRACE_ADD_MONTHS | NUMBER(2,0) | Yes | |||
| PTRINST_GRACE_ADD_DAYS | NUMBER(2,0) | Yes | |||
| PTRINST_FL_ORGN_SECURITY_IND | VARCHAR2(1) | No | |||
| PTRINST_EDIT_FACULTY_POSN_IND | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRINST_ALVL_CODE_RANK | NTRALVL_CODE | NTRALVL |
| PTRINST_ALVL_CODE_TENURE | NTRALVL_CODE | NTRALVL |
| PTRINST_ALVL_CODE_SABB | NTRALVL_CODE | NTRALVL |
| PTRINST_COBRA_STAT_CODE | STVSTAT_CODE | STVSTAT |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRINST | Unique | PTRINST_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRINST | SQL Index | S10B80.PAYROLL | Rely On |
| NTRALVL | SQL Table | S10B80.POSNCTL | Refer (no action) |
| STVSTAT | SQL Table | S10B80.SATURN | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:36:55:000 | 04/02/2008 13:49:11:000 |
Table PTRLREA| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRLREA_CODE | VARCHAR2(2) | No | * | * | |
| PTRLREA_DESC | VARCHAR2(30) | No | |||
| PTRLREA_STATUS | VARCHAR2(1) | No | |||
| PTRLREA_COBRA_ELIG_IND | VARCHAR2(1) | Yes | |||
| PTRLREA_ACTIVITY_DATE | DATE | No | |||
| PTRLREA_RET_WORK_ELIG_IND | VARCHAR2(1) | Yes | |||
| PTRLREA_SABB_LEAVE_IND | VARCHAR2(1) | No | |||
| PTRLREA_COMM_FULLFILL_IND | VARCHAR2(1) | No | |||
| PTRLREA_FAC_TRACKING_IND | VARCHAR2(1) | No | |||
| PTRLREA_ASSOC_ACAT_CODE | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRLREA_ASSOC_ACAT_CODE | NTVACAT_CODE | NTVACAT |
| PTRLREA_CODE | PEBEMPL_LREA_CODE | PEBEMPL |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRLREA | Unique | PTRLREA_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PERSABB | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PAVAPPL | SQL View | S10B80.BANINST1 | Use (select) |
| PEVEMPL | SQL View | S10B80.BANINST1 | Use (select) |
| PEVRTWK | SQL View | S10B80.BANINST1 | Use (select) |
| F_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
| PTRLREA_RECTYPE | Oracle Package Type | S10B80.BANINST1.POKRECS | Rely On |
| PTRLREAC | Oracle Package Cursor | S10B80.BANINST1.NOKPLIB | Use (select) |
| P_EDIT_LOA | Oracle Package Procedure | S10B80.BANINST1.NOKP2LB | Use (select) |
| P_EDIT_LV_DATES | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (select) |
| P_UPD_PERSABB_DECISION | Oracle Package Procedure | S10B80.BANINST1.NOKP2LB | Rely On |
| P_UPD_PERSABB_DECISION | Oracle Package Procedure | S10B80.BANINST1.NOKP2LB | Use (select) |
| F_PTRLREA_REC | Oracle Package Function | S10B80.BANINST1.POKRECS | Rely On |
| F_PTRLREA_REC | Oracle Package Function | S10B80.BANINST1.POKRECS | Use (select) |
| PTRLREA | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRLREA | SQL Index | S10B80.PAYROLL | Rely On |
| NTVACAT | SQL Table | S10B80.POSNCTL | Refer (no action) |
| PEBEMPL | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:33:09:000 | 04/02/2008 13:49:07:000 |
Table SPRTELE| This Object is |
|---|
| Light Imported |
| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SPRTELE_PIDM | NUMBER(8,0) | No | * | ||
| SPRTELE_SEQNO | NUMBER(3,0) | No | * | ||
| SPRTELE_TELE_CODE | VARCHAR2(4) | No | * | ||
| SPRTELE_ACTIVITY_DATE | DATE | No | |||
| SPRTELE_PHONE_AREA | VARCHAR2(6) | Yes | |||
| SPRTELE_PHONE_NUMBER | VARCHAR2(12) | Yes | |||
| SPRTELE_PHONE_EXT | VARCHAR2(10) | Yes | |||
| SPRTELE_STATUS_IND | VARCHAR2(1) | Yes | |||
| SPRTELE_ATYP_CODE | VARCHAR2(2) | Yes | |||
| SPRTELE_ADDR_SEQNO | NUMBER(2,0) | Yes | |||
| SPRTELE_PRIMARY_IND | VARCHAR2(1) | Yes | |||
| SPRTELE_UNLIST_IND | VARCHAR2(1) | Yes | |||
| SPRTELE_COMMENT | VARCHAR2(60) | Yes | |||
| SPRTELE_INTL_ACCESS | VARCHAR2(16) | Yes | |||
| SPRTELE_DATA_ORIGIN | VARCHAR2(30) | Yes | |||
| SPRTELE_USER_ID | VARCHAR2(30) | Yes | |||
| SPRTELE_CTRY_CODE_PHONE | VARCHAR2(4) | Yes |
| Creation Date | Analysis Date |
|---|---|
| 04/12/2008 23:59:09:000 | 04/13/2008 10:00:40:000 |
Link between NTRACAT and NTVACAT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRACAT and NTVACAT (FK1_NTRACAT_INV_NTVACAT_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRACAT | NTRACAT_ACAT_CODE | NTVACAT_CODE | NTVACAT | (1,1)-(0,n) |
Link between NTRACLV and NTVACAT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRACLV and NTVACAT (FK1_NTRACLV_INV_NTVACAT_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRACLV | NTRACLV_ACAT_CODE | NTVACAT_CODE | NTVACAT | (1,1)-(0,n) |
Link between NORROUT and NTRALVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NORROUT and NTRALVL (FK1_NORROUT_INV_NTRALVL_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NORROUT | NORROUT_ALVL_CODE | NTRALVL_CODE | NTRALVL | (1,1)-(0,n) |
Link between NTRROUT and NTRALVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRROUT and NTRALVL (FK1_NTRROUT_INV_NTRALVL_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRROUT | NTRROUT_ALVL_CODE | NTRALVL_CODE | NTRALVL | (1,1)-(0,n) |
Link between NORTLBD and NTVAPTY| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NORTLBD and NTVAPTY (FK1_NORTLBD_INV_NTVAPTY_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NORTLBD | NORTLBD_APTY_CODE | NTVAPTY_CODE | NTVAPTY | (1,1)-(0,n) |
Link between NTRAUFD and NTRAUBK| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRAUFD and NTRAUBK (FK1_NTRAUFD_INV_NTRAUBK_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRAUFD | NTRAUFD_AUFM_CODE | NTRAUBK_AUFM_CODE | NTRAUBK | (1,1)-(0,n) |
| NTRAUFD | NTRAUFD_AUBK_CODE | NTRAUBK_CODE | NTRAUBK | (1,1)-(0,n) |
Link between NTRAUBK and NTRAUFM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRAUBK and NTRAUFM (FK1_NTRAUBK_INV_NTRAUFM_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRAUBK | NTRAUBK_AUFM_CODE | NTRAUFM_CODE | NTRAUFM | (1,1)-(0,n) |
Link between NORTLBD and NOBTRAN| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NORTLBD and NOBTRAN (FK1_NORTLBD_INV_NOBTRAN_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NORTLBD | NORTLBD_TRANSACTION_NO | NOBTRAN_TRANSACTION_NO | NOBTRAN | (1,1)-(0,n) |
Link between NOBTRAN and NTVACAT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NOBTRAN and NTVACAT (FK1_NOBTRAN_INV_NTVACAT_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NOBTRAN | NOBTRAN_ACAT_CODE | NTVACAT_CODE | NTVACAT | (1,1)-(0,n) |
Link between NTRAGRP and NTVACAT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRAGRP and NTVACAT (FK1_NTRAGRP_INV_NTVACAT_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRAGRP | NTRAGRP_ACAT_CODE | NTVACAT_CODE | NTVACAT | (1,1)-(0,n) |
Link between NTRAGID and NTVAGRP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRAGID and NTVAGRP (FK1_NTRAGID_INV_NTVAGRP_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRAGID | NTRAGID_AGRP_CODE | NTVAGRP_CODE | NTVAGRP | (1,1)-(0,n) |
Link between NTRAGRP and NTVAGRP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRAGRP and NTVAGRP (FK1_NTRAGRP_INV_NTVAGRP_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRAGRP | NTRAGRP_AGRP_CODE | NTVAGRP_CODE | NTVAGRP | (1,1)-(0,n) |
Link between NTRAPFB and NTRAUBK| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRAPFB and NTRAUBK (FK1_NTRAPFB_INV_NTRAUBK_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRAPFB | NTRAPFB_AUFM_CODE | NTRAUBK_AUFM_CODE | NTRAUBK | (1,1)-(0,n) |
| NTRAPFB | NTRAPFB_AUBK_CODE | NTRAUBK_CODE | NTRAUBK | (1,1)-(0,n) |
Link between NTRAPFB and NTVAPTY| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRAPFB and NTVAPTY (FK1_NTRAPFB_INV_NTVAPTY_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRAPFB | NTRAPFB_APTY_CODE | NTVAPTY_CODE | NTVAPTY | (1,1)-(0,n) |
Link between NORTRAN and NTRAPFD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NORTRAN and NTRAPFD (FK1_NORTRAN_INV_NTRAPFD_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NORTRAN | NORTRAN_APTY_CODE | NTRAPFD_APTY_CODE | NTRAPFD | (1,1)-(0,n) |
| NORTRAN | NORTRAN_AUFM_CODE | NTRAPFD_AUFM_CODE | NTRAPFD | (1,1)-(0,n) |
| NORTRAN | NORTRAN_AUBK_CODE | NTRAPFD_AUBK_CODE | NTRAPFD | (1,1)-(0,n) |
| NORTRAN | NORTRAN_AUFD_CODE | NTRAPFD_AUFD_CODE | NTRAPFD | (1,1)-(0,n) |
Link between NTRAPFD and NTRAPFB| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRAPFD and NTRAPFB (FK1_NTRAPFD_INV_NTRAPFB_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRAPFD | NTRAPFD_APTY_CODE | NTRAPFB_APTY_CODE | NTRAPFB | (1,1)-(0,n) |
| NTRAPFD | NTRAPFD_AUFM_CODE | NTRAPFB_AUFM_CODE | NTRAPFB | (1,1)-(0,n) |
| NTRAPFD | NTRAPFD_AUBK_CODE | NTRAPFB_AUBK_CODE | NTRAPFB | (1,1)-(0,n) |
Link between NBRJOBS and NTRSALB| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NBRJOBS and NTRSALB (FK1_NBRJOBS_INV_NTRSALB_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NBRJOBS | NBRJOBS_SAL_TABLE | NTRSALB_TABLE | NTRSALB | (0,1)-(0,n) |
| NBRJOBS | NBRJOBS_SAL_GRADE | NTRSALB_GRADE | NTRSALB | (0,1)-(0,n) |
| NBRJOBS | NBRJOBS_SGRP_CODE | NTRSALB_SGRP_CODE | NTRSALB | (0,1)-(0,n) |
Link between NTRLVID and NTRALVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRLVID and NTRALVL (FK1_NTRLVID_INV_NTRALVL_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRLVID | NTRLVID_ALVL_CODE | NTRALVL_CODE | NTRALVL | (1,1)-(0,n) |
Link between NTRPROX and NTRALVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between NTRPROX and NTRALVL (FK1_NTRPROX_INV_NTRALVL_KEY) | POSNCTL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| NTRPROX | NTRPROX_ALVL_CODE | NTRALVL_CODE | NTRALVL | (1,1)-(0,n) |
Link between NTRAUFD and NTRAPFD| Objects list |
|---|
| scope-cursor : S10B80.BANINST1.BWPKEPDT.NORTRAN_FIELDSC
scope-cursor : S10B80.BANINST1.BWPKEPDT.NORTRAN_FIELDS_WOUT_TRANSC |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NTRAUFD and NTRAPFD | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NTRAUFD | NTRAPFD |
Link between NTRADFV and NTRAPFD| Objects list |
|---|
| scope-cursor : S10B80.BANINST1.BWPKEPDT.NORTRAN_FIELDSC
scope-cursor : S10B80.BANINST1.BWPKEPDT.NORTRAN_FIELDS_WOUT_TRANSC |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NTRADFV and NTRAPFD | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NTRADFV | NTRAPFD |
Link between NOBTRAN and NORTRAN| Objects list |
|---|
| scope-function : S10B80.BANINST1.BWPKEPDT.F_CHK_JOBS
scope-function : S10B80.BANINST1.NOKEPAF.F_GET_TRANS_EFF_DATE scope-procedure : S10B80.BANINST1.NOKEPAF.P_GET_ADDR_PRIORITY scope-procedure : S10B80.BANINST1.NOKEPAF.P_GET_TELE_PRIORITY scope-function : S10B80.BANINST1.NOKEPCR.F_MULTI_JOBS scope-procedure : S10B80.BANINST1.NOKEPCR.P_CHECK_DUP_TRANSACTION |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NOBTRAN and NORTRAN | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NOBTRAN | NORTRAN |
Link between GOBEACC and NTRPROX| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.BWPKEPID.P_PRINT_PROXY_SETUP
scope-procedure : S10B80.BANINST1.BWPKEPSM.P_BUILD_PROXY_LIST scope-function : S10B80.BANINST1.NOKEPCR.F_OPEN_NTRPROX |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between GOBEACC and NTRPROX | GENERAL |
| Link type | Between | And |
|---|---|---|
| Join | GOBEACC | NTRPROX |
Link between NTRACLV and NTRALVL| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.BWPKEPID.P_PRINT_DEFAULT_ROUTING
scope-function : S10B80.BANINST1.NOKEPCR.F_OPEN_DEFAULT_ROUT_RC |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NTRACLV and NTRALVL | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NTRACLV | NTRALVL |
Link between NTRLVID and GOBEACC| Objects list |
|---|
| scope-function : S10B80.BANINST1.BWPKEPID.F_OPEN_ROUTUSER_RC
scope-procedure : S10B80.BANINST1.BWPKOJSR.P_JSCRIPT_FILL_USRNAME_ARRAY |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NTRLVID and GOBEACC | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NTRLVID | GOBEACC |
Link between NTVAPTY and NOREAER| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.BWPKEPUT.P_PRINT_NOREAER |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NTVAPTY and NOREAER | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NTVAPTY | NOREAER |
Link between NTRAPFB and NTRACAT| Objects list |
|---|
| scope-function : S10B80.BANINST1.NOKEPAF.F_SPRIDEN_ID_IN_MIN_SEQNO
scope-function : S10B80.BANINST1.NOKEPAF.F_FORM_EXIST_IN_ACAT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NTRAPFB and NTRACAT | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NTRAPFB | NTRACAT |
Link between NORTERN and NOBTRAN| Objects list |
|---|
| scope-function : S10B80.BANINST1.NOKEPAF.F_GET_TRANS_EFF_DATE |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NORTERN and NOBTRAN | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NORTERN | NOBTRAN |
Link between NORROUT and NTRLVID| Objects list |
|---|
| scope-function : S10B80.BANINST1.NOKEPAF.F_EA_EDIT_SUPERUSER |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NORROUT and NTRLVID | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NORROUT | NTRLVID |
Link between NTRACAT and NOBTRAN| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.NOKEPAF.P_GET_ADDR_PRIORITY
scope-procedure : S10B80.BANINST1.NOKEPAF.P_GET_TELE_PRIORITY scope-function : S10B80.BANINST1.NOKEPCR.F_MULTI_JOBS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NTRACAT and NOBTRAN | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NTRACAT | NOBTRAN |
Link between NTRACAT and NORTRAN| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.NOKEPAF.P_GET_ADDR_PRIORITY
scope-procedure : S10B80.BANINST1.NOKEPAF.P_GET_TELE_PRIORITY |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NTRACAT and NORTRAN | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NTRACAT | NORTRAN |
Link between NORROUT and NOBTRAN| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.NOKEPCR.P_CHK_ORIGINATOR_IN_ROUT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NORROUT and NOBTRAN | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NORROUT | NOBTRAN |
Link between NTRAGRP and NTRAGID| Objects list |
|---|
| scope-function : S10B80.BANINST1.NOKEPCR.F_OPEN_ALLOWED_ACATS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between NTRAGRP and NTRAGID | POSNCTL |
| Link type | Between | And |
|---|---|---|
| Join | NTRAGRP | NTRAGID |
Link between PTRLREA and NTVACAT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRLREA and NTVACAT (FK1_PTRLREA_INV_NTVACAT_CODE) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRLREA | PTRLREA_ASSOC_ACAT_CODE | NTVACAT_CODE | NTVACAT | (0,1)-(0,n) |
Link between PTRINST and NTRALVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRINST and NTRALVL (FK1_PTRINST_INV_NTRALVL_CODE) | PAYROLL |
| Refer (no action) | Link Informative Foreign Key Between PTRINST and NTRALVL (FK2_PTRINST_INV_NTRALVL_CODE) | PAYROLL |
| Refer (no action) | Link Informative Foreign Key Between PTRINST and NTRALVL (FK3_PTRINST_INV_NTRALVL_CODE) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRINST | PTRINST_ALVL_CODE_RANK | NTRALVL_CODE | NTRALVL | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRINST | PTRINST_ALVL_CODE_TENURE | NTRALVL_CODE | NTRALVL | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRINST | PTRINST_ALVL_CODE_SABB | NTRALVL_CODE | NTRALVL | (0,1)-(0,n) |