Model Deductions
| Object Name | Object Type | Layer Name |
|---|---|---|
| GTVSDAX | SQL Table | Default |
| PARAPST | SQL Table | Default |
| PCRBENE | SQL Table | Default |
| PCRCPAY | SQL Table | Default |
| PCRDEDN | SQL Table | Default |
| PDRBCHS | SQL Table | Default |
| PDRBCOV | SQL Table | Default |
| PDRBDED | SQL Table | Default |
| PDRBEHS | SQL Table | Default |
| PDRBENE | SQL Table | Default |
| PDRBFLX | SQL Table | Default |
| PDRDEDN | SQL Table | Main Objects |
| PDRFBAL | SQL Table | Default |
| PDRFCLM | SQL Table | Default |
| PDRFLEX | SQL Table | Default |
| PDRPERS | SQL Table | Default |
| PDRXPID | SQL Table | Default |
| PEBEMPL | SQL Table | Default |
| PERDTOT | SQL Table | Default |
| PEREHIS | SQL Table | Default |
| PERJLEV | SQL Table | Default |
| PERJTOT | SQL Table | Default |
| PERPCRE | SQL Table | Default |
| PHR1042 | SQL Table | Default |
| PHRDEDN | SQL Table | Default |
| PHRDOCM | SQL Table | Default |
| PHREARN | SQL Table | Default |
| PHRHIST | SQL Table | Default |
| PHRJACR | SQL Table | Default |
| PHRJOBS | SQL Table | Default |
| PPRCOLR | SQL Table | Default |
| PTRBCAT | SQL Table | Default |
| PTRBCDN | SQL Table | Default |
| PTRBDAS | SQL Table | Default |
| PTRBDCA | SQL Table | Default |
| PTRBDCG | SQL Table | Default |
| PTRBDGM | SQL Table | Default |
| PTRBDLD | SQL Table | Default |
| PTRBDMC | SQL Table | Default |
| PTRBDPD | SQL Table | Default |
| PTRBDPG | SQL Table | Default |
| PTRBDPL | SQL Table | Default |
| PTRBDSG | SQL Table | Default |
| PTRCBEN | SQL Table | Default |
| PTRECBC | SQL Table | Default |
| PTRECLS | SQL Table | Default |
| PTRFBEN | SQL Table | Default |
| PTRLIFE | SQL Table | Default |
| PTRPICT | SQL Table | Default |
| PTVBDPG | SQL Table | Default |
| PTVBDTY | SQL Table | Default |
| PXRADDS | SQL Table | Default |
| PXRCALC | SQL Table | Default |
| PXREXEM | SQL Table | Default |
| PXRFSTA | SQL Table | Default |
| PXRGRAD | SQL Table | Default |
| PXRRDED | SQL Table | Default |
| PXRREPT | SQL Table | Default |
| PXRRERN | SQL Table | Default |
| PXRTXCD | SQL Table | Default |
| SPBPERS | SQL Table | Default |
| SPRIDEN | SQL Table | Default |
Table GTVSDAX| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSDAX_EXTERNAL_CODE | VARCHAR2(15) | No | * | ||
| GTVSDAX_INTERNAL_CODE | VARCHAR2(10) | No | * | ||
| GTVSDAX_REPORTING_DATE | DATE | Yes | |||
| GTVSDAX_TRANSLATION_CODE | VARCHAR2(15) | Yes | |||
| GTVSDAX_INTERNAL_CODE_SEQNO | NUMBER(2,0) | Yes | |||
| GTVSDAX_INTERNAL_CODE_GROUP | VARCHAR2(20) | No | |||
| GTVSDAX_DESC | VARCHAR2(30) | No | |||
| GTVSDAX_SYSREQ_IND | VARCHAR2(1) | Yes | |||
| GTVSDAX_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GTVSDAX_EXTERNAL_CODE | SARAPPD_APDC_CODE | SARAPPD |
| GTVSDAX_EXTERNAL_CODE | SORBCHR_BCHR_CODE | SORBCHR |
| GTVSDAX_EXTERNAL_CODE | SORTEST_TESC_CODE | SORTEST |
| GTVSDAX_EXTERNAL_CODE | SSBSECT_SSTS_CODE | SSBSECT |
| GTVSDAX_INTERNAL_CODE | SORPCOL_SBGI_CODE | SORPCOL |
| GTVSDAX_INTERNAL_CODE | SPRMEDI_MEDI_CODE | SPRMEDI |
| GTVSDAX_EXTERNAL_CODE | PERJTOT_EARN_CODE | PERJTOT |
| GTVSDAX_EXTERNAL_CODE | TBBDEPC_DTYP_CODE | TBBDEPC |
| GTVSDAX_EXTERNAL_CODE | TBRACCD_DETAIL_CODE | TBRACCD |
| GTVSDAX_EXTERNAL_CODE | SRBRECR_LEVL_CODE | SRBRECR |
| GTVSDAX_EXTERNAL_CODE | SARADAP_LEVL_CODE | SARADAP |
| GTVSDAX_EXTERNAL_CODE | SPRTELE_TELE_CODE | SPRTELE |
| GTVSDAX_EXTERNAL_CODE | STVATYP_CODE | STVATYP |
| GTVSDAX_EXTERNAL_CODE | SFRRSTS_RSTS_CODE | SFRRSTS |
| Index Name | Index Type | Column Name |
|---|---|---|
| GTVSDAX_KEY_INDEX | Unique | GTVSDAX_INTERNAL_CODE_GROUP |
| GTVSDAX_KEY_INDEX | Unique | GTVSDAX_INTERNAL_CODE |
| GTVSDAX_KEY_INDEX | Unique | GTVSDAX_EXTERNAL_CODE |
| GTVSDAX_KEY_INDEX | Unique | GTVSDAX_INTERNAL_CODE_SEQNO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GTVSDAX_KEY_INDEX | SQL Index | S10B80.GENERAL | Rely On |
| PERJTOT | SQL Table | S10B80.PAYROLL | Join |
| SARADAP | SQL Table | S10B80.SATURN | Join |
| SARAPPD | SQL Table | S10B80.SATURN | Join |
| SFRRSTS | SQL Table | S10B80.SATURN | Join |
| SORBCHR | SQL Table | S10B80.SATURN | Join |
| SORPCOL | SQL Table | S10B80.SATURN | Join |
| SORTEST | SQL Table | S10B80.SATURN | Join |
| SPRMEDI | SQL Table | S10B80.SATURN | Join |
| SPRTELE | SQL Table | S10B80.SATURN | Join |
| SRBRECR | SQL Table | S10B80.SATURN | Join |
| SSBSECT | SQL Table | S10B80.SATURN | Join |
| STVATYP | SQL Table | S10B80.SATURN | Join |
| TBBDEPC | SQL Table | S10B80.TAISMGR | Join |
| TBRACCD | SQL Table | S10B80.TAISMGR | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 10:35:14:000 | 04/02/2008 21:17:51:000 |
Table PARAPST| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PARAPST_PIDM | NUMBER(8,0) | No | * | ||
| PARAPST_PCLS_CODE | VARCHAR2(5) | Yes | |||
| PARAPST_POSN | VARCHAR2(6) | Yes | |||
| PARAPST_APPS_CODE | VARCHAR2(2) | No | * | ||
| PARAPST_APPS_DATE | DATE | No | |||
| PARAPST_COMMENT | LONG | Yes | |||
| PARAPST_ACTIVITY_DATE | DATE | No | |||
| PARAPST_REQ_NO | VARCHAR2(10) | Yes | |||
| PARAPST_APPL_DATE | DATE | No | |||
| PARAPST_SEQ_NO | VARCHAR2(3) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PARAPST_APPS_CODE | PTRAPPS_CODE | PTRAPPS |
| PARAPST_PIDM | PABAPPL_PIDM | PABAPPL |
| PARAPST_APPS_CODE | GTVSDAX_EXTERNAL_CODE | GTVSDAX |
| Index Name | Index Type | Column Name |
|---|---|---|
| PARAPST_KEY_INDEX | PARAPST_PIDM | |
| PARAPST_KEY_INDEX | PARAPST_REQ_NO | |
| PARAPST_KEY_INDEX | PARAPST_POSN | |
| PARAPST_KEY_INDEX | PARAPST_PCLS_CODE | |
| PARAPST_KEY_INDEX | PARAPST_APPL_DATE | |
| PARAPST_KEY_INDEX | PARAPST_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PAVAPST | SQL View | S10B80.BANINST1 | Use (select) |
| PAVREQ1 | SQL View | S10B80.BANINST1 | Use (select) |
| F_ADD_APPLICANT_FLAG | SQL Function | S10B80.BANINST1 | Use (select) |
| F_APPLICANT_ROWID | SQL Function | S10B80.BANINST1 | Use (select) |
| F_DISPOSITION_IND | SQL Function | S10B80.BANINST1 | Use (select) |
| F_SDAX_APPL_STAT | SQL Function | S10B80.BANINST1 | Use (select) |
| F_SDAX_APPL_STAT | Oracle Package Function | S10B80.BANINST1.PAKRECR | Use (select) |
| PARAPST | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PARAPST_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| GTVSDAX | SQL Table | S10B80.GENERAL | Join |
| PABAPPL | SQL Table | S10B80.PAYROLL | Join |
| PTRAPPS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:36:28:000 | 04/02/2008 13:49:10:000 |
Table PCRBENE| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PCRBENE_PIDM | NUMBER(8,0) | No | * | * | |
| PCRBENE_SEQ_NO | NUMBER(2,0) | No | * | ||
| PCRBENE_BENE_PIDM | NUMBER(8,0) | Yes | |||
| PCRBENE_BENE_LAST_NAME | VARCHAR2(60) | Yes | |||
| PCRBENE_BENE_FIRST_NAME | VARCHAR2(60) | Yes | |||
| PCRBENE_BENE_MI | VARCHAR2(60) | Yes | |||
| PCRBENE_BREL_CODE | VARCHAR2(1) | No | * | ||
| PCRBENE_SEX_IND | VARCHAR2(1) | Yes | |||
| PCRBENE_BIRTH_DATE | DATE | Yes | |||
| PCRBENE_COLLEGE_IND | VARCHAR2(1) | No | |||
| PCRBENE_ACTIVITY_DATE | DATE | No | |||
| PCRBENE_SURNAME_PREFIX | VARCHAR2(60) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PCRBENE_PIDM | PCBPERS_PIDM | PCBPERS |
| PCRBENE_BREL_CODE | PTRBREL_CODE | PTRBREL |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PCRBENE | Unique | PCRBENE_PIDM |
| PK_PCRBENE | Unique | PCRBENE_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PCRBENE | SQL Index | S10B80.PAYROLL | Rely On |
| PCBPERS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBREL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:32:49:000 | 04/02/2008 13:49:06:000 |
Table PCRCPAY| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PCRCPAY_PIDM | NUMBER(8,0) | No | |||
| PCRCPAY_TRANS_IND | VARCHAR2(1) | No | |||
| PCRCPAY_TRANS_DATE | DATE | No | |||
| PCRCPAY_CBEN_CODE | VARCHAR2(3) | Yes | |||
| PCRCPAY_PLAN | VARCHAR2(2) | Yes | |||
| PCRCPAY_AMOUNT | NUMBER(11,2) | No | |||
| PCRCPAY_COMMENTS | VARCHAR2(60) | Yes | |||
| PCRCPAY_DUE_DATE | DATE | Yes | |||
| PCRCPAY_HIST_IND | VARCHAR2(1) | No | |||
| PCRCPAY_CLOSE_IND | VARCHAR2(1) | No | |||
| PCRCPAY_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PCRCPAY_KEY_INDEX | PCRCPAY_PIDM | |
| PCRCPAY_KEY_INDEX | PCRCPAY_TRANS_IND | |
| PCRCPAY_KEY_INDEX | PCRCPAY_TRANS_DATE | |
| PCRCPAY_KEY_INDEX | PCRCPAY_CBEN_CODE | |
| PCRCPAY_KEY_INDEX | PCRCPAY_PLAN |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PCRCPAY_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:39:58:000 | 04/02/2008 13:49:14:000 |
Table PCRDEDN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PCRDEDN_PIDM | NUMBER(8,0) | No | * | ||
| PCRDEDN_SEQ_NO | NUMBER(2,0) | Yes | |||
| PCRDEDN_CBEN_CODE | VARCHAR2(3) | No | |||
| PCRDEDN_PLAN | VARCHAR2(2) | Yes | |||
| PCRDEDN_BEGIN_DATE | DATE | No | |||
| PCRDEDN_END_DATE | DATE | No | |||
| PCRDEDN_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PCRDEDN_PIDM | PCBPERS_PIDM | PCBPERS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PCRDEDN_KEY_INDEX | Unique | PCRDEDN_PIDM |
| PCRDEDN_KEY_INDEX | Unique | PCRDEDN_CBEN_CODE |
| PCRDEDN_KEY_INDEX | Unique | PCRDEDN_PLAN |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PCRDEDN_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PCBPERS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:39:17:000 | 04/02/2008 13:49:14:000 |
Table PDRBCHS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PDRBCHS_PIDM | NUMBER(8,0) | No | * | ||
| PDRBCHS_BDCA_CODE | VARCHAR2(3) | No | * | ||
| PDRBCHS_BENE_SEQ_NO | NUMBER(2,0) | No | * | ||
| PDRBCHS_BEGIN_DATE | DATE | Yes | |||
| PDRBCHS_END_DATE | DATE | Yes | |||
| PDRBCHS_OTHER_COV_IND | VARCHAR2(1) | Yes | |||
| PDRBCHS_CAPTURE_DATE | DATE | No | * | ||
| PDRBCHS_DELETED_IND | VARCHAR2(1) | No | |||
| PDRBCHS_USER_ID | VARCHAR2(30) | No | |||
| PDRBCHS_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PDRBCHS_KEY_INDEX | PDRBCHS_CAPTURE_DATE | |
| PDRBCHS_KEY_INDEX | PDRBCHS_USER_ID | |
| PK_PDRBCHS | Unique | PDRBCHS_PIDM |
| PK_PDRBCHS | Unique | PDRBCHS_BDCA_CODE |
| PK_PDRBCHS | Unique | PDRBCHS_BENE_SEQ_NO |
| PK_PDRBCHS | Unique | PDRBCHS_CAPTURE_DATE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PT_PDRBCOV_AUDIT_DELETES | SQL Trigger | S10B80.PAYROLL | Use (Insert) |
| PT_PDRBCOV_AUDIT_INSERTS | SQL Trigger | S10B80.PAYROLL | Use (Insert) |
| PT_PDRBCOV_AUDIT_UPDATES | SQL Trigger | S10B80.PAYROLL | Use (Insert) |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRBCHS_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PK_PDRBCHS | SQL Index | S10B80.PAYROLL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:37:55:000 | 04/02/2008 13:49:12:000 |
Table PDRBCOV| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PDRBCOV_PIDM | NUMBER(8,0) | No | * | * | |
| PDRBCOV_BDCA_CODE | VARCHAR2(3) | No | * | * | |
| PDRBCOV_BENE_SEQ_NO | NUMBER(2,0) | No | * | ||
| PDRBCOV_BEGIN_DATE | DATE | No | |||
| PDRBCOV_END_DATE | DATE | Yes | |||
| PDRBCOV_OTHER_COV_IND | VARCHAR2(1) | Yes | |||
| PDRBCOV_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PDRBCOV_PIDM | PDRBDED_PIDM | PDRBDED |
| PDRBCOV_BDCA_CODE | PDRBDED_BDCA_CODE | PDRBDED |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PDRBCOV | Unique | PDRBCOV_PIDM |
| PK_PDRBCOV | Unique | PDRBCOV_BDCA_CODE |
| PK_PDRBCOV | Unique | PDRBCOV_BENE_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRBENE | SQL Table | S10B80.PAYROLL | Join |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Join |
| PDVBCOV | SQL View | S10B80.BANINST1 | Use (select) |
| F_BENEFICIARY_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
| PDRBCOVC | Oracle Package Cursor | S10B80.BANINST1.BWPKDUPD | Use (select) |
| PDRBCOVC | Oracle Package Cursor | S10B80.BANINST1.BWPKDBCV | Use (select) |
| PDRBCOVCODEC | Oracle Package Cursor | S10B80.BANINST1.BWPKDBCV | Use (select) |
| PDRBDEDC | Oracle Package Cursor | S10B80.BANINST1.BWPKDBCV | Use (select) |
| PDRBDEDCOVERAGESC | Oracle Package Cursor | S10B80.BANINST1.BWPKDBCV | Use (select) |
| P_PRINTCOVEREDPERSONS | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Use (select) |
| P_REMOVEPDRBCOVENDDATE | Oracle Package Procedure | S10B80.BANINST1.BWPKDUPD | Use (update) |
| P_UPDATEDEDNPROCRECORDS | Oracle Package Procedure | S10B80.BANINST1.BWPKDUPD | Use (delete) |
| P_UPDATEPDRBCOVENDDATE | Oracle Package Procedure | S10B80.BANINST1.BWPKDUPD | Use (update) |
| PDRBCOV_REC | Oracle Package Variable | S10B80.BANINST1.BWPKDUPD | Rely On |
| PDRBCOV_REC | Oracle Package Variable | S10B80.BANINST1.BWPKDBCV | Rely On |
| P_OPENENROLLMENTFUNCDELBDED | Oracle Package Procedure | S10B80.BANINST1.BWPKDOFN | Use (delete) |
| F_UPDATECOVERAGE | Oracle Package Function | S10B80.BANINST1.BWPKDBCV | Use (Insert,update) |
| PDRBCOV | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PDRBCOV | SQL Index | S10B80.PAYROLL | Rely On |
| PDRBDED | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PT_PDRBCOV_AUDIT_DELETES | SQL Trigger | S10B80.PAYROLL | Fire (delete,after,each row) |
| PT_PDRBCOV_AUDIT_INSERTS | SQL Trigger | S10B80.PAYROLL | Fire (Insert,after,each row) |
| PT_PDRBCOV_AUDIT_UPDATES | SQL Trigger | S10B80.PAYROLL | Fire (update,after,each row) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:38:12:000 | 04/02/2008 13:49:12:000 |
Table PDRBDED| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PDRBDED_PIDM | NUMBER(8,0) | No | * | * | |
| PDRBDED_BDCA_CODE | VARCHAR2(3) | No | * | * | |
| PDRBDED_ADD_REPL_IND | VARCHAR2(1) | Yes | |||
| PDRBDED_ADD_REPL_EMPL | NUMBER(11,2) | Yes | |||
| PDRBDED_ADD_REPL_EMPR | NUMBER(11,2) | Yes | |||
| PDRBDED_ADD_REPL_TAX_BASE | NUMBER(11,2) | Yes | |||
| PDRBDED_ARR_STATUS | VARCHAR2(1) | Yes | |||
| PDRBDED_ARR_BALANCE | NUMBER(11,2) | Yes | |||
| PDRBDED_BOND_BALANCE | NUMBER(11,2) | Yes | |||
| PDRBDED_BEGIN_DATE | DATE | No | |||
| PDRBDED_END_DATE | DATE | Yes | |||
| PDRBDED_ACTIVITY_DATE | DATE | No | |||
| PDRBDED_ARR_RECOVER_MAX | NUMBER(11,2) | Yes | |||
| PDRBDED_ADD_REPL_PICT_CODE | VARCHAR2(2) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PDRBDED_PIDM | PEBEMPL_PIDM | PEBEMPL |
| PDRBDED_BDCA_CODE | PTRBDCA_CODE | PTRBDCA |
| PDRBDED_BDCA_CODE | PTRBDGM_BDCA_CODE | PTRBDGM |
| PDRBDED_BDCA_CODE | PTRBDPD_CODE | PTRBDPD |
| PDRBDED_BDCA_CODE | PTRBDPD_BDCA_CODE | PTRBDPD |
| PDRBDED_BDCA_CODE | PTRBDCG_BDCA_CODE | PTRBDCG |
| PDRBDED_BDCA_CODE | PTRBDCG_CODE | PTRBDCG |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PDRBDED | Unique | PDRBDED_PIDM |
| PK_PDRBDED | Unique | PDRBDED_BDCA_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PDRBDED | SQL Index | S10B80.PAYROLL | Rely On |
| PEBEMPL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDCG | SQL Table | S10B80.PAYROLL | Join |
| PTRBDGM | SQL Table | S10B80.PAYROLL | Join |
| PTRBDPD | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:38:48:000 | 04/02/2008 13:49:13:000 |
Table PDRBEHS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PDRBEHS_PIDM | NUMBER(8,0) | No | * | ||
| PDRBEHS_SEQ_NO | NUMBER(2,0) | No | * | ||
| PDRBEHS_BENE_PIDM | NUMBER(8,0) | Yes | |||
| PDRBEHS_BENE_LAST_NAME | VARCHAR2(60) | Yes | |||
| PDRBEHS_BENE_FIRST_NAME | VARCHAR2(60) | Yes | |||
| PDRBEHS_BENE_MI | VARCHAR2(60) | Yes | |||
| PDRBEHS_BREL_CODE | VARCHAR2(1) | No | |||
| PDRBEHS_SEX_IND | VARCHAR2(1) | Yes | |||
| PDRBEHS_BIRTH_DATE | DATE | Yes | |||
| PDRBEHS_COLLEGE_IND | VARCHAR2(1) | No | |||
| PDRBEHS_SSN | VARCHAR2(15) | Yes | |||
| PDRBEHS_CAPTURE_DATE | DATE | No | * | ||
| PDRBEHS_DELETED_IND | VARCHAR2(1) | No | |||
| PDRBEHS_USER_ID | VARCHAR2(30) | No | |||
| PDRBEHS_ACTIVITY_DATE | DATE | No | |||
| PDRBEHS_SURNAME_PREFIX | VARCHAR2(60) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PDRBEHS_KEY_INDEX | PDRBEHS_CAPTURE_DATE | |
| PDRBEHS_KEY_INDEX | PDRBEHS_USER_ID | |
| PK_PDRBEHS | Unique | PDRBEHS_PIDM |
| PK_PDRBEHS | Unique | PDRBEHS_SEQ_NO |
| PK_PDRBEHS | Unique | PDRBEHS_CAPTURE_DATE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PT_PDRBENE_AUDIT_DELETES | SQL Trigger | S10B80.PAYROLL | Use (Insert) |
| PT_PDRBENE_AUDIT_INSERTS | SQL Trigger | S10B80.PAYROLL | Use (Insert) |
| PT_PDRBENE_AUDIT_UPDATES | SQL Trigger | S10B80.PAYROLL | Use (Insert) |
| UT_PB_EMPLOYEEDELETEAPI | Oracle Package Procedure | S10B80.BANINST1.UT_PB_EMPLOYEE | Use (update) |
| PDRBEHS | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRBEHS_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PK_PDRBEHS | SQL Index | S10B80.PAYROLL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:40:12:000 | 04/02/2008 13:49:15:000 |
Table PDRBENE| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PDRBENE_PIDM | NUMBER(8,0) | No | * | * | |
| PDRBENE_SEQ_NO | NUMBER(2,0) | No | * | * | |
| PDRBENE_BENE_PIDM | NUMBER(8,0) | Yes | * | ||
| PDRBENE_BENE_LAST_NAME | VARCHAR2(60) | Yes | |||
| PDRBENE_BENE_FIRST_NAME | VARCHAR2(60) | Yes | |||
| PDRBENE_BENE_MI | VARCHAR2(60) | Yes | |||
| PDRBENE_BREL_CODE | VARCHAR2(1) | No | * | ||
| PDRBENE_SEX_IND | VARCHAR2(1) | Yes | |||
| PDRBENE_BIRTH_DATE | DATE | Yes | |||
| PDRBENE_COLLEGE_IND | VARCHAR2(1) | No | |||
| PDRBENE_ACTIVITY_DATE | DATE | No | |||
| PDRBENE_SSN | VARCHAR2(15) | Yes | |||
| PDRBENE_SURNAME_PREFIX | VARCHAR2(60) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PDRBENE_BREL_CODE | PTRBREL_CODE | PTRBREL |
| PDRBENE_PIDM | PDRBCOV_PIDM | PDRBCOV |
| PDRBENE_SEQ_NO | PDRBCOV_BENE_SEQ_NO | PDRBCOV |
| PDRBENE_BENE_PIDM | SPBPERS_PIDM | SPBPERS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PDRBENE | Unique | PDRBENE_PIDM |
| PK_PDRBENE | Unique | PDRBENE_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| SPRIDEN | SQL Table | S10B80.SATURN | Join |
| PDVBEN1 | SQL View | S10B80.BANINST1 | Use (select) |
| PDVBENE | SQL View | S10B80.BANINST1 | Use (select) |
| F_BENEFICIARY_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
| F_PAYROLL_BENEFICIARY_IND | SQL Function | S10B80.BANINST1 | Use (select) |
| PDRBENEC | Oracle Package Cursor | S10B80.BANINST1.BWPKDBCV | Use (select) |
| PDRBENENAMEC | Oracle Package Cursor | S10B80.BANINST1.BWPKDBCV | Use (select) |
| P_PRINTCOVEREDPERSONS | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Use (select) |
| PDRBENE_REC | Oracle Package Variable | S10B80.BANINST1.BWPKDBCV | Rely On |
| P_CREATE | Oracle Package Procedure | S10B80.BANINST1.PB_EMPLOYEE | Use (Insert) |
| P_DELETE | Oracle Package Procedure | S10B80.BANINST1.PB_EMPLOYEE | Use (delete) |
| P_GETDESCANDCOV | Oracle Package Procedure | S10B80.BANINST1.BWPKDBCV | Rely On |
| P_NAMETABLEROW | Oracle Package Procedure | S10B80.BANINST1.BWPKDBCV | Rely On |
| P_UPDATENAME | Oracle Package Procedure | S10B80.BANINST1.BWPKDBCV | Use (Insert,update,delete) |
| PDRBENE | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PDRBENE | SQL Index | S10B80.PAYROLL | Rely On |
| PDRBCOV | SQL Table | S10B80.PAYROLL | Join |
| PTRBREL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| SPBPERS | SQL Table | S10B80.SATURN | Join |
| PT_PDRBENE_AUDIT_DELETES | SQL Trigger | S10B80.PAYROLL | Fire (delete,after,each row) |
| PT_PDRBENE_AUDIT_INSERTS | SQL Trigger | S10B80.PAYROLL | Fire (Insert,after,each row) |
| PT_PDRBENE_AUDIT_UPDATES | SQL Trigger | S10B80.PAYROLL | Fire (update,after,each row) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:40:23:000 | 04/02/2008 13:49:15:000 |
Table PDRBFLX| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PDRBFLX_PIDM | NUMBER(8,0) | No | * | * | |
| PDRBFLX_FLEX_AMT | NUMBER(11,2) | Yes | |||
| PDRBFLX_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PDRBFLX_PIDM | PEBEMPL_PIDM | PEBEMPL |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PDRBFLX | Unique | PDRBFLX_PIDM |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PDRBFLX | SQL Index | S10B80.PAYROLL | Rely On |
| PEBEMPL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:32:38:000 | 04/02/2008 13:49:06:000 |
Table PDRDEDN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PDRDEDN_PIDM | NUMBER(8,0) | No | * | * | |
| PDRDEDN_BDCA_CODE | VARCHAR2(3) | No | * | * | |
| PDRDEDN_EFFECTIVE_DATE | DATE | No | * | * | |
| PDRDEDN_STATUS | VARCHAR2(1) | No | |||
| PDRDEDN_REF_NO | VARCHAR2(10) | Yes | |||
| PDRDEDN_AMOUNT1 | NUMBER(11,2) | Yes | |||
| PDRDEDN_AMOUNT2 | NUMBER(11,2) | Yes | |||
| PDRDEDN_AMOUNT3 | NUMBER(11,2) | Yes | |||
| PDRDEDN_AMOUNT4 | NUMBER(11,2) | Yes | |||
| PDRDEDN_OPT_CODE1 | VARCHAR2(2) | Yes | |||
| PDRDEDN_OPT_CODE2 | VARCHAR2(2) | Yes | |||
| PDRDEDN_OPT_CODE3 | VARCHAR2(2) | Yes | |||
| PDRDEDN_OPT_CODE4 | VARCHAR2(2) | Yes | |||
| PDRDEDN_OPT_CODE5 | VARCHAR2(2) | Yes | |||
| PDRDEDN_ACTIVITY_DATE | DATE | No | |||
| PDRDEDN_COVERAGE_DATE | DATE | Yes | |||
| PDRDEDN_BDCL_CODE | VARCHAR2(8) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PDRDEDN_BDCL_CODE | PTRBDCL_CODE | PTRBDCL |
| PDRDEDN_PIDM | PDRBDED_PIDM | PDRBDED |
| PDRDEDN_BDCA_CODE | PDRBDED_BDCA_CODE | PDRBDED |
| PDRDEDN_EFFECTIVE_DATE | PDRBDED_BEGIN_DATE | PDRBDED |
| PDRDEDN_BDCA_CODE | PTRBDPD_CODE | PTRBDPD |
| Index Name | Index Type | Column Name |
|---|---|---|
| PDRDEDN_KEY2_INDEX | PDRDEDN_BDCA_CODE | |
| PDRDEDN_KEY2_INDEX | PDRDEDN_OPT_CODE1 | |
| PDRDEDN_KEY2_INDEX | PDRDEDN_EFFECTIVE_DATE | |
| PK_PDRDEDN | Unique | PDRDEDN_PIDM |
| PK_PDRDEDN | Unique | PDRDEDN_BDCA_CODE |
| PK_PDRDEDN | Unique | PDRDEDN_EFFECTIVE_DATE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRDEDN_KEY2_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PK_PDRDEDN | SQL Index | S10B80.PAYROLL | Rely On |
| PDRBDED | SQL Table | S10B80.PAYROLL | Join |
| PTRBDCL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDPD | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:38:11:000 | 04/02/2008 13:49:12:000 |
Table PDRFBAL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PDRFBAL_PLAN_YEAR | NUMBER(4,0) | No | |||
| PDRFBAL_PIDM | NUMBER(8,0) | No | * | ||
| PDRFBAL_BDCA_CODE | VARCHAR2(3) | No | * | ||
| PDRFBAL_PLAN_CODE | VARCHAR2(2) | Yes | |||
| PDRFBAL_AMOUNT_AVAIL | NUMBER(11,2) | Yes | |||
| PDRFBAL_AMOUNT_SPENT | NUMBER(11,2) | Yes | |||
| PDRFBAL_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PDRFBAL_PIDM | PEBEMPL_PIDM | PEBEMPL |
| PDRFBAL_BDCA_CODE | PDRDEDN_BDCA_CODE | PDRDEDN |
| PDRFBAL_PIDM | PDRDEDN_PIDM | PDRDEDN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PDRFBAL_KEY_INDEX | Unique | PDRFBAL_PLAN_YEAR |
| PDRFBAL_KEY_INDEX | Unique | PDRFBAL_PIDM |
| PDRFBAL_KEY_INDEX | Unique | PDRFBAL_BDCA_CODE |
| PDRFBAL_KEY_INDEX | Unique | PDRFBAL_PLAN_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRFBAL_REC | Oracle Package Variable | S10B80.BANINST1.PDKLIBS | Rely On |
| P_UPDATEDEDNPROCRECORDS | Oracle Package Procedure | S10B80.BANINST1.BWPKDUPD | Use (Insert) |
| FLXSAMOUNTSC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select) |
| PDRFBALVIEWC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select)Rely On |
| PTRFLEXC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select) |
| P_INSERT_FLEX_BALANCE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_INSERT_FLEX_BALANCE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Use (Insert,select) |
| P_OPENENROLLMENTFUNCADDDEDN | Oracle Package Procedure | S10B80.BANINST1.BWPKDOFN | Use (Insert) |
| PDRFBAL | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRFBAL_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PDRDEDN | SQL Table | S10B80.PAYROLL | Join |
| PEBEMPL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:32:27:000 | 04/02/2008 13:49:06:000 |
Table PDRFCLM| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PDRFCLM_PIDM | NUMBER(8,0) | No | * | ||
| PDRFCLM_BDCA_CODE | VARCHAR2(3) | No | * | ||
| PDRFCLM_PLAN_CODE | VARCHAR2(2) | Yes | |||
| PDRFCLM_CLAIM_DATE | DATE | No | |||
| PDRFCLM_REF_NO | VARCHAR2(10) | Yes | |||
| PDRFCLM_CLAIM_AMT | NUMBER(11,2) | Yes | |||
| PDRFCLM_CLAIM_PAID | NUMBER(11,2) | Yes | |||
| PDRFCLM_ACTIVITY_DATE | DATE | No | |||
| PDRFCLM_PLAN_YEAR | NUMBER(4,0) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PDRFCLM_PIDM | PEBEMPL_PIDM | PEBEMPL |
| PDRFCLM_PIDM | PDRDEDN_PIDM | PDRDEDN |
| PDRFCLM_BDCA_CODE | PDRDEDN_BDCA_CODE | PDRDEDN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PDRFCLM_KEY_INDEX | Unique | PDRFCLM_PIDM |
| PDRFCLM_KEY_INDEX | Unique | PDRFCLM_BDCA_CODE |
| PDRFCLM_KEY_INDEX | Unique | PDRFCLM_PLAN_CODE |
| PDRFCLM_KEY_INDEX | Unique | PDRFCLM_CLAIM_DATE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRFCLM_REC | Oracle Package Variable | S10B80.BANINST1.PDKLIBS | Rely On |
| FLXSAMOUNTSC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select) |
| PDRFCLMBYDATEC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select)Rely On |
| PDRFCLM | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRFCLM_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PDRDEDN | SQL Table | S10B80.PAYROLL | Join |
| PEBEMPL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:33:51:000 | 04/02/2008 13:49:08:000 |
Table PDRFLEX| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PDRFLEX_PIDM | NUMBER(8,0) | No | |||
| PDRFLEX_BDCA_CODE | VARCHAR2(3) | No | |||
| PDRFLEX_PLAN_CODE | VARCHAR2(2) | Yes | |||
| PDRFLEX_STATUS | VARCHAR2(1) | No | |||
| PDRFLEX_START_DATE | DATE | No | |||
| PDRFLEX_END_DATE | DATE | Yes | |||
| PDRFLEX_AMOUNT1 | NUMBER(13,4) | Yes | |||
| PDRFLEX_AMOUNT2 | NUMBER(13,4) | Yes | |||
| PDRFLEX_AMOUNT3 | NUMBER(11,2) | Yes | |||
| PDRFLEX_AMOUNT4 | NUMBER(11,2) | Yes | |||
| PDRFLEX_LIF_OVR_UDR_AMT | NUMBER(11,2) | Yes | |||
| PDRFLEX_APPR_IND | VARCHAR2(1) | Yes | |||
| PDRFLEX_PROCESS_IND | VARCHAR2(1) | Yes | |||
| PDRFLEX_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PDRFLEX_KEY2_INDEX | PDRFLEX_APPR_IND | |
| PDRFLEX_KEY2_INDEX | PDRFLEX_PROCESS_IND | |
| PDRFLEX_KEY2_INDEX | PDRFLEX_STATUS | |
| PDRFLEX_KEY_INDEX | Unique | PDRFLEX_PIDM |
| PDRFLEX_KEY_INDEX | Unique | PDRFLEX_BDCA_CODE |
| PDRFLEX_KEY_INDEX | Unique | PDRFLEX_PLAN_CODE |
| PDRFLEX_KEY_INDEX | Unique | PDRFLEX_STATUS |
| PDRFLEX_KEY_INDEX | Unique | PDRFLEX_START_DATE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| P_CHECK_FLEX | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Use (select) |
| PDRFLEX | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRFLEX_KEY2_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PDRFLEX_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:35:09:000 | 04/02/2008 13:49:09:000 |
Table PDRPERS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PDRPERS_PIDM | NUMBER(8,0) | No | |||
| PDRPERS_COUNTY_CODE | VARCHAR2(4) | No | |||
| PDRPERS_DISTRICT_CODE | VARCHAR2(3) | No | |||
| PDRPERS_SSN | VARCHAR2(15) | No | |||
| PDRPERS_SERVICE_PERIOD | NUMBER(5,0) | Yes | |||
| PDRPERS_LAST_NAME | VARCHAR2(60) | Yes | |||
| PDRPERS_FIRST_NAME | VARCHAR2(60) | Yes | |||
| PDRPERS_MI | VARCHAR2(60) | Yes | |||
| PDRPERS_GROUP | NUMBER(5,0) | Yes | |||
| PDRPERS_ELIGIBLE_GRS | NUMBER(7,2) | Yes | |||
| PDRPERS_PAY_RATE | NUMBER(8,3) | Yes | |||
| PDRPERS_PAY_CODE | NUMBER(2,0) | Yes | |||
| PDRPERS_POST_TAX_AMT | NUMBER(6,2) | Yes | |||
| PDRPERS_CONT_CODE | NUMBER(2,0) | Yes | |||
| PDRPERS_EMPL_CONT_RATE | NUMBER(6,2) | Yes | |||
| PDRPERS_WORK_SCHEDULE | NUMBER(3,0) | Yes | |||
| PDRPERS_PRE_TAX_AMT | NUMBER(6,2) | Yes | |||
| PDRPERS_REPORT_IND | VARCHAR2(1) | No | |||
| PDRPERS_USERID | VARCHAR2(30) | No | |||
| PDRPERS_ACTIVITY_DATE | DATE | No | |||
| PDRPERS_BATCH_NO | VARCHAR2(3) | No | |||
| PDRPERS_SURVIVOR_AMT | NUMBER(3,2) | Yes | |||
| PDRPERS_EMPR_CONT_RATE | NUMBER(11,6) | Yes | |||
| PDRPERS_SURNAME_PREFIX | VARCHAR2(60) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PDRPERS_KEY_INDEX | PDRPERS_BATCH_NO | |
| PDRPERS_KEY_INDEX | PDRPERS_PIDM | |
| PDRPERS_KEY_INDEX | PDRPERS_GROUP | |
| PDRPERS_KEY_INDEX | PDRPERS_SERVICE_PERIOD | |
| PDRPERS_KEY_INDEX | PDRPERS_COUNTY_CODE | |
| PDRPERS_KEY_INDEX | PDRPERS_DISTRICT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRPERS_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:35:07:000 | 04/02/2008 13:49:09:000 |
Table PDRXPID| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PDRXPID_PIDM | NUMBER(8,0) | No | * | * | |
| PDRXPID_BDCA_CODE | VARCHAR2(3) | No | * | * | |
| PDRXPID_PICT_CODE | VARCHAR2(2) | No | * | * | |
| PDRXPID_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PDRXPID_PIDM | PDRBDED_PIDM | PDRBDED |
| PDRXPID_BDCA_CODE | PDRBDED_BDCA_CODE | PDRBDED |
| PDRXPID_PICT_CODE | PTRPICT_CODE | PTRPICT |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PDRXPID | Unique | PDRXPID_PIDM |
| PK_PDRXPID | Unique | PDRXPID_BDCA_CODE |
| PK_PDRXPID | Unique | PDRXPID_PICT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRCALNMAXENDDATEC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select) |
| PDRXPID | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PDRXPID | SQL Index | S10B80.PAYROLL | Rely On |
| PDRBDED | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRPICT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:40:09:000 | 04/02/2008 13:49:15:000 |
Table PEBEMPL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PEBEMPL_PIDM | NUMBER(8,0) | No | * | * | |
| PEBEMPL_EMPL_STATUS | VARCHAR2(1) | No | |||
| PEBEMPL_COAS_CODE_HOME | VARCHAR2(1) | Yes | |||
| PEBEMPL_ORGN_CODE_HOME | VARCHAR2(6) | No | * | ||
| PEBEMPL_COAS_CODE_DIST | VARCHAR2(1) | Yes | |||
| PEBEMPL_ORGN_CODE_DIST | VARCHAR2(6) | No | * | ||
| PEBEMPL_ECLS_CODE | VARCHAR2(2) | No | * | ||
| PEBEMPL_LCAT_CODE | VARCHAR2(2) | No | * | ||
| PEBEMPL_BCAT_CODE | VARCHAR2(2) | No | * | ||
| PEBEMPL_FIRST_HIRE_DATE | DATE | No | |||
| PEBEMPL_CURRENT_HIRE_DATE | DATE | No | |||
| PEBEMPL_ADJ_SERVICE_DATE | DATE | No | |||
| PEBEMPL_SENIORITY_DATE | DATE | No | |||
| PEBEMPL_LREA_CODE | VARCHAR2(2) | Yes | |||
| PEBEMPL_LOA_BEG_DATE | DATE | Yes | |||
| PEBEMPL_LOA_END_DATE | DATE | Yes | |||
| PEBEMPL_TREA_CODE | VARCHAR2(2) | Yes | * | ||
| PEBEMPL_TERM_DATE | DATE | Yes | |||
| PEBEMPL_I9_FORM_IND | VARCHAR2(1) | Yes | |||
| PEBEMPL_I9_DATE | DATE | Yes | |||
| PEBEMPL_I9_EXPIRE_DATE | DATE | Yes | |||
| PEBEMPL_ACTIVITY_DATE | DATE | No | |||
| PEBEMPL_WKPR_CODE | VARCHAR2(4) | Yes | * | ||
| PEBEMPL_FLSA_IND | VARCHAR2(1) | No | |||
| PEBEMPL_STGR_CODE | VARCHAR2(2) | Yes | * | ||
| PEBEMPL_DAYS_IN_CANADA | NUMBER(3,0) | Yes | |||
| PEBEMPL_1042_RECIPIENT_CD | VARCHAR2(2) | Yes | |||
| PEBEMPL_INTERNAL_FT_PT_IND | VARCHAR2(1) | No | |||
| PEBEMPL_DICD_CODE | VARCHAR2(3) | Yes | |||
| PEBEMPL_EGRP_CODE | VARCHAR2(4) | Yes | |||
| PEBEMPL_IPEDS_SOFT_MONEY_IND | VARCHAR2(1) | No | |||
| PEBEMPL_FIRST_WORK_DATE | DATE | Yes | |||
| PEBEMPL_LAST_WORK_DATE | DATE | Yes | |||
| PEBEMPL_CALIF_PENSION_IND | VARCHAR2(1) | Yes | |||
| PEBEMPL_NRSI_CODE | VARCHAR2(4) | Yes | * | ||
| PEBEMPL_SSN_LAST_NAME | VARCHAR2(20) | Yes | |||
| PEBEMPL_SSN_FIRST_NAME | VARCHAR2(15) | Yes | |||
| PEBEMPL_SSN_MI | VARCHAR2(15) | Yes | |||
| PEBEMPL_SSN_SUFFIX | VARCHAR2(4) | Yes | |||
| PEBEMPL_JBLN_CODE | VARCHAR2(6) | Yes | * | ||
| PEBEMPL_COLL_CODE | VARCHAR2(2) | Yes | * | ||
| PEBEMPL_CAMP_CODE | VARCHAR2(3) | Yes | * | ||
| PEBEMPL_USER_ID | VARCHAR2(30) | Yes | |||
| PEBEMPL_DATA_ORIGIN | VARCHAR2(30) | Yes | |||
| PEBEMPL_EW2_CONSENT_IND | VARCHAR2(1) | No | |||
| PEBEMPL_EW2_CONSENT_DATE | DATE | Yes | |||
| PEBEMPL_EW2_CONSENT_USER_ID | VARCHAR2(30) | Yes | |||
| PEBEMPL_IPEDS_PRIMARY_FUNCTION | VARCHAR2(3) | No | |||
| PEBEMPL_IPEDS_MED_DENTAL_IND | VARCHAR2(1) | No | |||
| PEBEMPL_ETAX_CONSENT_IND | VARCHAR2(1) | No | |||
| PEBEMPL_ETAX_CONSENT_DATE | DATE | Yes | |||
| PEBEMPL_ETAX_CONSENT_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PEBEMPL_BCAT_CODE | PTRBCAT_CODE | PTRBCAT |
| PEBEMPL_ECLS_CODE | PTRECLS_CODE | PTRECLS |
| PEBEMPL_JBLN_CODE | PTRJBLN_CODE | PTRJBLN |
| PEBEMPL_TREA_CODE | PTRTREA_CODE | PTRTREA |
| PEBEMPL_LCAT_CODE | PTVLCAT_CODE | PTVLCAT |
| PEBEMPL_NRSI_CODE | PTVNRSI_CODE | PTVNRSI |
| PEBEMPL_ORGN_CODE_HOME | PTVORGN_CODE | PTVORGN |
| PEBEMPL_ORGN_CODE_DIST | PTVORGN_CODE | PTVORGN |
| PEBEMPL_STGR_CODE | PTVSTGR_CODE | PTVSTGR |
| PEBEMPL_WKPR_CODE | PTRWKPR_CODE | PTRWKPR |
| PEBEMPL_COLL_CODE | STVCOLL_CODE | STVCOLL |
| PEBEMPL_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| PEBEMPL_PIDM | POTPARM_PIDM | POTPARM |
| PEBEMPL_PIDM | PERJLEV_PIDM | PERJLEV |
| Index Name | Index Type | Column Name |
|---|---|---|
| PEBEMPL_HOME_INDEX | PEBEMPL_ORGN_CODE_HOME | |
| PEBEMPL_HOME_INDEX | PEBEMPL_COAS_CODE_HOME | |
| PEBEMPL_HOME_INDEX | PEBEMPL_PIDM | |
| PEBEMPL_KEY2_INDEX | Unique | PEBEMPL_LCAT_CODE |
| PEBEMPL_KEY2_INDEX | Unique | PEBEMPL_PIDM |
| PEBEMPL_KEY3_INDEX | PEBEMPL_ECLS_CODE | |
| PK_PEBEMPL | Unique | PEBEMPL_PIDM |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PEBEMPL_HOME_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PEBEMPL_KEY2_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PEBEMPL_KEY3_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PK_PEBEMPL | SQL Index | S10B80.PAYROLL | Rely On |
| PERJLEV | SQL Table | S10B80.PAYROLL | Join |
| POTPARM | SQL Table | S10B80.PAYROLL | Join |
| PTRBCAT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRECLS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRJBLN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRTREA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRWKPR | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVLCAT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVNRSI | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVORGN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVSTGR | SQL Table | S10B80.PAYROLL | Refer (no action) |
| STVCAMP | SQL Table | S10B80.SATURN | Refer (no action) |
| STVCOLL | SQL Table | S10B80.SATURN | Refer (no action) |
| ET_PEBEMPL_ADR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (delete,after,each row) |
| ET_PEBEMPL_AIR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (Insert,after,each row) |
| ET_PEBEMPL_AUR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (update,after,each row) |
| PT_PEBEMPL_AR_LDI | SQL Trigger | S10B80.PAYROLL | Fire (Insert,update,delete,after,each row) |
| PT_PEBEMPL_AS_LDI | SQL Trigger | S10B80.PAYROLL | Fire (Insert,update,delete,after,all rows) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:36:46:000 | 04/02/2008 13:49:11:000 |
Table PERDTOT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PERDTOT_PIDM | NUMBER(8,0) | No | * | * | |
| PERDTOT_YEAR | NUMBER(4,0) | No | * | * | |
| PERDTOT_BDCA_CODE | VARCHAR2(3) | No | * | * | |
| PERDTOT_MONTH | NUMBER(2,0) | No | * | ||
| PERDTOT_EMPL_AMT | NUMBER(11,2) | Yes | |||
| PERDTOT_EMPR_AMT | NUMBER(11,2) | Yes | |||
| PERDTOT_APPL_GRS | NUMBER(11,2) | Yes | |||
| PERDTOT_ACTIVITY_DATE | DATE | No | |||
| PERDTOT_EMPR_CODE | VARCHAR2(4) | No | * | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PERDTOT_PIDM | PDRBDED_PIDM | PDRBDED |
| PERDTOT_BDCA_CODE | PDRBDED_BDCA_CODE | PDRBDED |
| PERDTOT_EMPR_CODE | PTREMPR_CODE | PTREMPR |
| PERDTOT_BDCA_CODE | PXRRDED_BDCA_CODE | PXRRDED |
| PERDTOT_EMPR_CODE | PXRREPT_EMPR_CODE | PXRREPT |
| PERDTOT_YEAR | PXRREPT_YEAR | PXRREPT |
| PERDTOT_PIDM | PXRREPT_PIDM | PXRREPT |
| PERDTOT_BDCA_CODE | PTRBDCA_CODE | PTRBDCA |
| PERDTOT_BDCA_CODE | PTRBDAS_BDCA_CODE | PTRBDAS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PERDTOT_KEY2_INDEX | PERDTOT_EMPR_CODE | |
| PERDTOT_KEY2_INDEX | PERDTOT_YEAR | |
| PERDTOT_KEY2_INDEX | PERDTOT_MONTH | |
| PERDTOT_KEY2_INDEX | PERDTOT_BDCA_CODE | |
| PK_PERDTOT | Unique | PERDTOT_PIDM |
| PK_PERDTOT | Unique | PERDTOT_YEAR |
| PK_PERDTOT | Unique | PERDTOT_EMPR_CODE |
| PK_PERDTOT | Unique | PERDTOT_BDCA_CODE |
| PK_PERDTOT | Unique | PERDTOT_MONTH |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PERDTOT_KEY2_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PK_PERDTOT | SQL Index | S10B80.PAYROLL | Rely On |
| PDRBDED | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDAS | SQL Table | S10B80.PAYROLL | Join |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Join |
| PTREMPR | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXRRDED | SQL Table | S10B80.PAYROLL | Join |
| PXRREPT | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:37:22:000 | 04/02/2008 13:49:11:000 |
Table PEREHIS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PEREHIS_PIDM | NUMBER(8,0) | No | |||
| PEREHIS_EFFECTIVE_DATE | DATE | No | |||
| PEREHIS_EMPL_STATUS | VARCHAR2(1) | Yes | |||
| PEREHIS_HOME_ORGN | VARCHAR2(6) | Yes | |||
| PEREHIS_ECLS_CODE | VARCHAR2(2) | Yes | * | ||
| PEREHIS_LCAT_CODE | VARCHAR2(2) | Yes | |||
| PEREHIS_BCAT_CODE | VARCHAR2(2) | Yes | * | ||
| PEREHIS_CURRENT_HIRE_DATE | DATE | Yes | |||
| PEREHIS_ADJ_SERVICE_DATE | DATE | Yes | |||
| PEREHIS_LREA_CODE | VARCHAR2(2) | Yes | |||
| PEREHIS_TREA_CODE | VARCHAR2(2) | Yes | * | ||
| PEREHIS_USER_ID | VARCHAR2(30) | No | |||
| PEREHIS_ACTIVITY_DATE | DATE | No | |||
| PEREHIS_TERM_DATE | DATE | Yes | |||
| PEREHIS_LOA_BEG_DATE | DATE | Yes | |||
| PEREHIS_LOA_END_DATE | DATE | Yes | |||
| PEREHIS_COAS_CODE_HOME | VARCHAR2(1) | Yes | |||
| PEREHIS_COAS_CODE_DIST | VARCHAR2(1) | Yes | |||
| PEREHIS_ORGN_CODE_DIST | VARCHAR2(6) | Yes | |||
| PEREHIS_FIRST_HIRE_DATE | DATE | Yes | |||
| PEREHIS_SENIORITY_DATE | DATE | Yes | |||
| PEREHIS_I9_FORM_IND | VARCHAR2(1) | Yes | |||
| PEREHIS_I9_DATE | DATE | Yes | |||
| PEREHIS_I9_EXPIRE_DATE | DATE | Yes | |||
| PEREHIS_WKPR_CODE | VARCHAR2(4) | Yes | |||
| PEREHIS_FLSA_IND | VARCHAR2(1) | Yes | |||
| PEREHIS_STGR_CODE | VARCHAR2(2) | Yes | |||
| PEREHIS_DAYS_IN_CANADA | NUMBER(3,0) | Yes | |||
| PEREHIS_1042_RECIPIENT_CD | VARCHAR2(2) | Yes | |||
| PEREHIS_INTERNAL_FT_PT_IND | VARCHAR2(1) | Yes | |||
| PEREHIS_DICD_CODE | VARCHAR2(3) | Yes | |||
| PEREHIS_EGRP_CODE | VARCHAR2(4) | Yes | |||
| PEREHIS_IPEDS_SOFT_MONEY_IND | VARCHAR2(1) | Yes | |||
| PEREHIS_FIRST_WORK_DATE | DATE | Yes | |||
| PEREHIS_LAST_WORK_DATE | DATE | Yes | |||
| PEREHIS_CALIF_PENSION_IND | VARCHAR2(1) | Yes | |||
| PEREHIS_NRSI_CODE | VARCHAR2(4) | Yes | |||
| PEREHIS_SSN_LAST_NAME | VARCHAR2(20) | Yes | |||
| PEREHIS_SSN_FIRST_NAME | VARCHAR2(15) | Yes | |||
| PEREHIS_SSN_MI | VARCHAR2(15) | Yes | |||
| PEREHIS_SSN_SUFFIX | VARCHAR2(4) | Yes | |||
| PEREHIS_JBLN_CODE | VARCHAR2(6) | Yes | |||
| PEREHIS_COLL_CODE | VARCHAR2(2) | Yes | |||
| PEREHIS_CAMP_CODE | VARCHAR2(3) | Yes | |||
| PEREHIS_DATA_ORIGIN | VARCHAR2(30) | Yes | |||
| PEREHIS_EW2_CONSENT_IND | VARCHAR2(1) | Yes | |||
| PEREHIS_EW2_CONSENT_DATE | DATE | Yes | |||
| PEREHIS_EW2_CONSENT_USER_ID | VARCHAR2(30) | Yes | |||
| PEREHIS_IPEDS_PRIMARY_FUNCTION | VARCHAR2(3) | No | |||
| PEREHIS_IPEDS_MED_DENTAL_IND | VARCHAR2(1) | No | |||
| PEREHIS_ETAX_CONSENT_IND | VARCHAR2(1) | No | |||
| PEREHIS_ETAX_CONSENT_DATE | DATE | Yes | |||
| PEREHIS_ETAX_CONSENT_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PEREHIS_BCAT_CODE | PTRBCAT_CODE | PTRBCAT |
| PEREHIS_TREA_CODE | PTRTREA_CODE | PTRTREA |
| PEREHIS_ECLS_CODE | PTRECLS_CODE | PTRECLS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PEREHIS_KEY_INDEX | PEREHIS_PIDM | |
| PEREHIS_KEY_INDEX | PEREHIS_EFFECTIVE_DATE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| F_CONCAT_EMPL_DATA | SQL Function | S10B80.BANINST1 | Use (select) |
| F_INCL_TERMINATED | SQL Function | S10B80.BANINST1 | Use (select) |
| P_GETBASICEMPDATA | Oracle Package Procedure | S10B80.BANINST1.PEKWEMP | Use (select) |
| P_GETEMPDATA | Oracle Package Procedure | S10B80.BANINST1.PEKDEGR | Use (select) |
| P_INSERT_EMPLOYEE_HISTORY | Oracle Package Procedure | S10B80.BANINST1.PB_EMPLOYEE | Use (Insert) |
| P_DELETE | Oracle Package Procedure | S10B80.BANINST1.DML_PEREHIS | Use (delete) |
| P_DELETE | Oracle Package Procedure | S10B80.BANINST1.PB_EMPLOYEE | Use (delete) |
| P_INSERT | Oracle Package Procedure | S10B80.BANINST1.DML_PEREHIS | Use (Insert)Rely On |
| P_UPDATE | Oracle Package Procedure | S10B80.BANINST1.DML_PEREHIS | Rely On |
| F_INCL_TERMINATED | Oracle Package Function | S10B80.BANINST1.PEKWEMP | Use (select) |
| PEREHIS | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PEREHIS_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBCAT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRECLS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRTREA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:34:48:000 | 04/02/2008 13:49:08:000 |
Table PERJLEV| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PERJLEV_PIDM | NUMBER(8,0) | No | * | * | |
| PERJLEV_POSN | VARCHAR2(6) | No | * | * | |
| PERJLEV_SUFF | VARCHAR2(2) | No | * | * | |
| PERJLEV_LEAV_CODE | VARCHAR2(4) | No | * | * | |
| PERJLEV_BEGIN_BALANCE | NUMBER(6,2) | No | |||
| PERJLEV_ACCRUED | NUMBER(6,2) | No | |||
| PERJLEV_TAKEN | NUMBER(6,2) | No | |||
| PERJLEV_DATE_AVAIL | DATE | No | |||
| PERJLEV_HRS_BANKED | NUMBER(6,2) | No | |||
| PERJLEV_USER_ID | VARCHAR2(30) | No | |||
| PERJLEV_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PERJLEV_LEAV_CODE | PTRLEAV_CODE | PTRLEAV |
| PERJLEV_PIDM | POTPARM_PIDM | POTPARM |
| PERJLEV_LEAV_CODE | PHRJACR_LEAV_CODE | PHRJACR |
| PERJLEV_SUFF | PHRJACR_SUFF | PHRJACR |
| PERJLEV_POSN | PHRJACR_POSN | PHRJACR |
| PERJLEV_PIDM | PHRJACR_PIDM | PHRJACR |
| PERJLEV_PIDM | PHRHIST_PIDM | PHRHIST |
| PERJLEV_POSN | PHRJOBS_POSN | PHRJOBS |
| PERJLEV_SUFF | PHRJOBS_SUFF | PHRJOBS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PERJLEV_LEAV_CODE_INDEX | PERJLEV_LEAV_CODE | |
| PK_PERJLEV | Unique | PERJLEV_PIDM |
| PK_PERJLEV | Unique | PERJLEV_POSN |
| PK_PERJLEV | Unique | PERJLEV_SUFF |
| PK_PERJLEV | Unique | PERJLEV_LEAV_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NBRBJOB | SQL Table | S10B80.POSNCTL | Join |
| NBRJOBS | SQL Table | S10B80.POSNCTL | Join |
| PEBEMPL | SQL Table | S10B80.PAYROLL | Join |
| PTRLVAC | SQL Table | S10B80.PAYROLL | Join |
| PTRLVAS | SQL Table | S10B80.PAYROLL | Join |
| PEVJLEV | SQL View | S10B80.BANINST1 | Use (select) |
| PEVPRF1 | SQL View | S10B80.BANINST1 | Use (select) |
| PERJLEV_RECTYPE | Oracle Package Type | S10B80.BANINST1.PEKRECS | Rely On |
| SUM_JLEV_BAL | Oracle Package Cursor | S10B80.BANINST1.PEKLEAV | Use (select) |
| PERJLEVC | Oracle Package Cursor | S10B80.BANINST1.BWPKEINF | Use (select) |
| P_GETLEAVEVALUE | Oracle Package Procedure | S10B80.BANINST1.PEKWEMP | Use (select) |
| P_UPD_JLEV_INFO | Oracle Package Procedure | S10B80.BANINST1.PEKLEAV | Use (update,select) |
| PERJLEV_REC | Oracle Package Variable | S10B80.BANINST1.BWPKEINF | Rely On |
| PERJLEV_BY_LEAVE_CODE | Oracle Package Cursor | S10B80.BANINST1.PEKLEAV | Use (select)Rely On |
| P_DEL_ZERO_BAL_LEAVE_RECS | Oracle Package Procedure | S10B80.BANINST1.PEKLEAV | Use (delete,select) |
| P_MAIN_ROLL | Oracle Package Procedure | S10B80.BANINST1.PEKLEAV | Rely On |
| P_MAIN_ROLL | Oracle Package Procedure | S10B80.BANINST1.PEKLEAV | Use (update,select) |
| P_UPD_LEAVE_BALANCE | Oracle Package Procedure | S10B80.BANINST1.PEKLEAV | Rely On |
| P_UPD_LEAVE_BALANCE | Oracle Package Procedure | S10B80.BANINST1.PEKLEAV | Use (Insert,select) |
| F_GET_JOB_LEAVE_ACCRUAL | Oracle Package Function | S10B80.BANINST1.PEKLEAV | Rely On |
| F_GET_JOB_LEAVE_ACCRUAL | Oracle Package Function | S10B80.BANINST1.PEKLEAV | Use (select) |
| F_PERJLEV_REC | Oracle Package Function | S10B80.BANINST1.PEKRECS | Rely On |
| PERJLEV | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PERJLEV_LEAV_CODE_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PK_PERJLEV | SQL Index | S10B80.PAYROLL | Rely On |
| PHRHIST | SQL Table | S10B80.PAYROLL | Join |
| PHRJACR | SQL Table | S10B80.PAYROLL | Join |
| PHRJOBS | SQL Table | S10B80.PAYROLL | Join |
| POTPARM | SQL Table | S10B80.PAYROLL | Join |
| PTRLEAV | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:38:55:000 | 04/02/2008 13:49:13:000 |
Table PERJTOT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PERJTOT_PIDM | NUMBER(8,0) | No | * | * | |
| PERJTOT_YEAR | NUMBER(4,0) | No | * | * | |
| PERJTOT_POSN | VARCHAR2(6) | No | * | * | |
| PERJTOT_SUFF | VARCHAR2(2) | No | * | * | |
| PERJTOT_EARN_CODE | VARCHAR2(3) | No | * | * | |
| PERJTOT_MONTH | NUMBER(2,0) | No | * | ||
| PERJTOT_HRS | NUMBER(6,2) | Yes | |||
| PERJTOT_GRS | NUMBER(11,2) | Yes | |||
| PERJTOT_ACTIVITY_DATE | DATE | No | |||
| PERJTOT_EMPR_CODE | VARCHAR2(4) | No | * | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PERJTOT_PIDM | NBRBJOB_PIDM | NBRBJOB |
| PERJTOT_POSN | NBRBJOB_POSN | NBRBJOB |
| PERJTOT_SUFF | NBRBJOB_SUFF | NBRBJOB |
| PERJTOT_EARN_CODE | PTREARN_CODE | PTREARN |
| PERJTOT_EMPR_CODE | PTREMPR_CODE | PTREMPR |
| PERJTOT_EARN_CODE | PXRRERN_EARN_CODE | PXRRERN |
| PERJTOT_YEAR | PXRREPT_YEAR | PXRREPT |
| PERJTOT_PIDM | PXRREPT_PIDM | PXRREPT |
| PERJTOT_EMPR_CODE | PXRREPT_EMPR_CODE | PXRREPT |
| Index Name | Index Type | Column Name |
|---|---|---|
| PERJTOT_KEY2_INDEX | PERJTOT_EMPR_CODE | |
| PERJTOT_KEY2_INDEX | PERJTOT_YEAR | |
| PERJTOT_KEY2_INDEX | PERJTOT_MONTH | |
| PERJTOT_KEY2_INDEX | PERJTOT_EARN_CODE | |
| PK_PERJTOT | Unique | PERJTOT_PIDM |
| PK_PERJTOT | Unique | PERJTOT_YEAR |
| PK_PERJTOT | Unique | PERJTOT_EMPR_CODE |
| PK_PERJTOT | Unique | PERJTOT_POSN |
| PK_PERJTOT | Unique | PERJTOT_SUFF |
| PK_PERJTOT | Unique | PERJTOT_EARN_CODE |
| PK_PERJTOT | Unique | PERJTOT_MONTH |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PERJTOT_KEY2_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PK_PERJTOT | SQL Index | S10B80.PAYROLL | Rely On |
| NBRBJOB | SQL Table | S10B80.POSNCTL | Refer (no action) |
| PTREARN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTREMPR | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXRREPT | SQL Table | S10B80.PAYROLL | Join |
| PXRRERN | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:40:03:000 | 04/02/2008 13:49:14:000 |
Table PERPCRE| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PERPCRE_YEAR | NUMBER(4,0) | No | |||
| PERPCRE_EMPR_CODE | VARCHAR2(4) | No | * | ||
| PERPCRE_PIDM | NUMBER(8,0) | No | * | ||
| PERPCRE_BDCA_CODE | VARCHAR2(3) | No | * | ||
| PERPCRE_BDPL_CODE | VARCHAR2(2) | Yes | |||
| PERPCRE_PENSION_CREDIT | NUMBER(11,2) | No | |||
| PERPCRE_CREDIT_OVERRIDE | NUMBER(11,2) | Yes | |||
| PERPCRE_PENSION_SERVICE | NUMBER(6,2) | No | |||
| PERPCRE_SERVICE_OVERRIDE | NUMBER(6,2) | Yes | |||
| PERPCRE_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PERPCRE_PIDM | PDRBDED_PIDM | PDRBDED |
| PERPCRE_BDCA_CODE | PDRBDED_BDCA_CODE | PDRBDED |
| PERPCRE_EMPR_CODE | PTREMPR_CODE | PTREMPR |
| Index Name | Index Type | Column Name |
|---|---|---|
| PERPCRE_KEY_INDEX | Unique | PERPCRE_YEAR |
| PERPCRE_KEY_INDEX | Unique | PERPCRE_EMPR_CODE |
| PERPCRE_KEY_INDEX | Unique | PERPCRE_PIDM |
| PERPCRE_KEY_INDEX | Unique | PERPCRE_BDCA_CODE |
| PERPCRE_KEY_INDEX | Unique | PERPCRE_BDPL_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PERPCRE_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PDRBDED | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTREMPR | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:31:51:000 | 04/02/2008 13:49:05:000 |
Table PHR1042| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PHR1042_YEAR | VARCHAR2(4) | No | * | ||
| PHR1042_PICT_CODE | VARCHAR2(2) | No | * | ||
| PHR1042_PAYNO | NUMBER(3,0) | No | * | ||
| PHR1042_PIDM | NUMBER(8,0) | No | * | ||
| PHR1042_SEQ_NO | NUMBER(2,0) | No | * | ||
| PHR1042_EMPR_CODE | VARCHAR2(4) | No | |||
| PHR1042_INCOME_CD | VARCHAR2(2) | No | |||
| PHR1042_COUNTRY_CD | VARCHAR2(2) | No | |||
| PHR1042_TAX_RATE | NUMBER(7,4) | No | |||
| PHR1042_EXEMPTION_CD | VARCHAR2(1) | No | |||
| PHR1042_GRADUATED_TAX_IND | VARCHAR2(1) | No | |||
| PHR1042_GROSS_INCOME_PAID | NUMBER(11,2) | Yes | |||
| PHR1042_WITHHOLDING_ALLOW | NUMBER(9,2) | Yes | |||
| PHR1042_US_FEDERAL_TAX | NUMBER(9,2) | Yes | |||
| PHR1042_ACTIVITY_DATE | DATE | Yes | |||
| PHR1042_BDCA_CODE | VARCHAR2(3) | No | |||
| PHR1042_ALLOWANCE_TAKEN | NUMBER(9,2) | Yes | |||
| PHR1042_INCOME_CD_SUB_TYPE | VARCHAR2(1) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PHR1042_SEQ_NO | PHRHIST_SEQ_NO | PHRHIST |
| PHR1042_PIDM | PHRHIST_PIDM | PHRHIST |
| PHR1042_PAYNO | PHRHIST_PAYNO | PHRHIST |
| PHR1042_PICT_CODE | PHRHIST_PICT_CODE | PHRHIST |
| PHR1042_YEAR | PHRHIST_YEAR | PHRHIST |
| Index Name | Index Type | Column Name |
|---|---|---|
| PHR1042_KEY_INDEX | Unique | PHR1042_YEAR |
| PHR1042_KEY_INDEX | Unique | PHR1042_PICT_CODE |
| PHR1042_KEY_INDEX | Unique | PHR1042_PAYNO |
| PHR1042_KEY_INDEX | Unique | PHR1042_PIDM |
| PHR1042_KEY_INDEX | Unique | PHR1042_SEQ_NO |
| PHR1042_KEY_INDEX | Unique | PHR1042_EMPR_CODE |
| PHR1042_KEY_INDEX | Unique | PHR1042_BDCA_CODE |
| PHR1042_KEY_INDEX | Unique | PHR1042_INCOME_CD |
| PHR1042_KEY_INDEX | Unique | PHR1042_COUNTRY_CD |
| PHR1042_KEY_INDEX | Unique | PHR1042_TAX_RATE |
| PHR1042_KEY_INDEX | Unique | PHR1042_EXEMPTION_CD |
| PHR1042_KEY_INDEX | Unique | PHR1042_GRADUATED_TAX_IND |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2006 | Use (select) |
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2007 | Use (select) |
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2 | Use (select) |
| PHR1042 | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PHR1042_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHRHIST | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:39:45:000 | 04/02/2008 13:49:14:000 |
Table PHRDEDN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PHRDEDN_YEAR | VARCHAR2(4) | No | * | ||
| PHRDEDN_PICT_CODE | VARCHAR2(2) | No | * | ||
| PHRDEDN_PAYNO | NUMBER(3,0) | No | * | ||
| PHRDEDN_PIDM | NUMBER(8,0) | No | * | * | |
| PHRDEDN_SEQ_NO | NUMBER(2,0) | No | * | ||
| PHRDEDN_EFFECTIVE_DATE | DATE | No | * | ||
| PHRDEDN_STATUS | VARCHAR2(1) | No | * | ||
| PHRDEDN_BDCA_CODE | VARCHAR2(3) | No | * | * | |
| PHRDEDN_EMPLOYEE_AMT | NUMBER(11,2) | Yes | |||
| PHRDEDN_EMPLOYER_AMT | NUMBER(11,2) | Yes | |||
| PHRDEDN_APPLICABLE_GROSS | NUMBER(11,2) | Yes | |||
| PHRDEDN_ARREAR_TAKEN | NUMBER(11,2) | Yes | |||
| PHRDEDN_ARREAR_RECOVERED | NUMBER(11,2) | Yes | |||
| PHRDEDN_ACTIVITY_DATE | DATE | No | |||
| PHRDEDN_EMPR_CODE | VARCHAR2(4) | No | * | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PHRDEDN_PIDM | PDRBDED_PIDM | PDRBDED |
| PHRDEDN_BDCA_CODE | PDRBDED_BDCA_CODE | PDRBDED |
| PHRDEDN_EMPR_CODE | PTREMPR_CODE | PTREMPR |
| PHRDEDN_BDCA_CODE | PTRBDGM_BDCA_CODE | PTRBDGM |
| PHRDEDN_BDCA_CODE | PTRBDCA_CODE | PTRBDCA |
| Index Name | Index Type | Column Name |
|---|---|---|
| PHRDEDN_KEY2_INDEX | PHRDEDN_PIDM | |
| PHRDEDN_KEY2_INDEX | PHRDEDN_YEAR | |
| PHRDEDN_KEY2_INDEX | PHRDEDN_PICT_CODE | |
| PHRDEDN_KEY2_INDEX | PHRDEDN_PAYNO | |
| PHRDEDN_KEY2_INDEX | PHRDEDN_SEQ_NO | |
| PHRDEDN_KEY2_INDEX | PHRDEDN_EMPR_CODE | |
| PHRDEDN_KEY3_INDEX | PHRDEDN_PIDM | |
| PHRDEDN_KEY3_INDEX | PHRDEDN_BDCA_CODE | |
| PHRDEDN_KEY3_INDEX | PHRDEDN_EFFECTIVE_DATE | |
| PK_PHRDEDN | Unique | PHRDEDN_YEAR |
| PK_PHRDEDN | Unique | PHRDEDN_PICT_CODE |
| PK_PHRDEDN | Unique | PHRDEDN_PAYNO |
| PK_PHRDEDN | Unique | PHRDEDN_PIDM |
| PK_PHRDEDN | Unique | PHRDEDN_SEQ_NO |
| PK_PHRDEDN | Unique | PHRDEDN_EMPR_CODE |
| PK_PHRDEDN | Unique | PHRDEDN_BDCA_CODE |
| PK_PHRDEDN | Unique | PHRDEDN_EFFECTIVE_DATE |
| PK_PHRDEDN | Unique | PHRDEDN_STATUS |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PAY_DEDN_TYPE | Oracle Package Type | S10B80.BANINST1.BWPKHSTB | Rely On |
| SUM_EMPLOYEE_AMT | Oracle Package Variable | S10B80.BANINST1.BWPKHSTB | Rely On |
| SUM_EMPLOYER_AMT | Oracle Package Variable | S10B80.BANINST1.BWPKHSTB | Rely On |
| GET_DEDN_SUMC | Oracle Package Cursor | S10B80.BANINST1.BWPKHSTB | Use (select) |
| GET_PAY_DEDNC | Oracle Package Cursor | S10B80.BANINST1.BWPKHSTB | Use (select) |
| F_VALID_EMPR_CODE | Oracle Package Function | S10B80.BANINST1.PX_RECORD_OF_EMPLOYMENT | Use (select) |
| F_VALID_EMPR_CODE | Oracle Package Function | S10B80.BANINST1.PX_MASS_ROE | Use (select) |
| PHRDEDN | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PHRDEDN_KEY2_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHRDEDN_KEY3_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PK_PHRDEDN | SQL Index | S10B80.PAYROLL | Rely On |
| PDRBDED | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Join |
| PTRBDGM | SQL Table | S10B80.PAYROLL | Join |
| PTREMPR | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:32:48:000 | 04/02/2008 13:49:06:000 |
Table PHRDOCM| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PHRDOCM_YEAR | VARCHAR2(4) | No | * | ||
| PHRDOCM_PICT_CODE | VARCHAR2(2) | No | * | ||
| PHRDOCM_PAYNO | NUMBER(3,0) | No | * | ||
| PHRDOCM_PIDM | NUMBER(8,0) | No | * | ||
| PHRDOCM_SEQ_NO | NUMBER(2,0) | No | * | ||
| PHRDOCM_DOC_TYPE | VARCHAR2(1) | No | * | ||
| PHRDOCM_PRIORITY | NUMBER(2,0) | No | * | ||
| PHRDOCM_DOC_NO | VARCHAR2(9) | No | * | ||
| PHRDOCM_DOC_DATE | DATE | No | |||
| PHRDOCM_NET | NUMBER(11,2) | Yes | |||
| PHRDOCM_BANK_CODE | VARCHAR2(9) | Yes | * | ||
| PHRDOCM_BANK_ACCT_NO | VARCHAR2(17) | Yes | |||
| PHRDOCM_ACCT_TYPE | VARCHAR2(1) | Yes | |||
| PHRDOCM_ACTIVITY_DATE | DATE | No | |||
| PHRDOCM_RECON_IND | VARCHAR2(1) | Yes | |||
| PHRDOCM_RECON_DATE | DATE | Yes | |||
| PHRDOCM_REISSUE_IND | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PHRDOCM_BANK_CODE | GXVDIRD_CODE_BANK_ROUT_NUM | GXVDIRD |
| Index Name | Index Type | Column Name |
|---|---|---|
| PHRDOCM_KEY2_INDEX | PHRDOCM_DOC_TYPE | |
| PHRDOCM_KEY2_INDEX | PHRDOCM_DOC_DATE | |
| PHRDOCM_KEY2_INDEX | PHRDOCM_YEAR | |
| PHRDOCM_KEY2_INDEX | PHRDOCM_PICT_CODE | |
| PHRDOCM_KEY2_INDEX | PHRDOCM_PAYNO | |
| PHRDOCM_KEY2_INDEX | PHRDOCM_PIDM | |
| PHRDOCM_KEY2_INDEX | PHRDOCM_SEQ_NO | |
| PHRDOCM_KEY3_INDEX | PHRDOCM_PIDM | |
| PHRDOCM_KEY3_INDEX | PHRDOCM_YEAR | |
| PHRDOCM_KEY3_INDEX | PHRDOCM_PICT_CODE | |
| PHRDOCM_KEY3_INDEX | PHRDOCM_PAYNO | |
| PHRDOCM_KEY3_INDEX | PHRDOCM_SEQ_NO | |
| PHRDOCM_KEY4_INDEX | PHRDOCM_DOC_NO | |
| PHRDOCM_KEY4_INDEX | PHRDOCM_DOC_DATE | |
| PK_PHRDOCM | Unique | PHRDOCM_YEAR |
| PK_PHRDOCM | Unique | PHRDOCM_PICT_CODE |
| PK_PHRDOCM | Unique | PHRDOCM_PAYNO |
| PK_PHRDOCM | Unique | PHRDOCM_PIDM |
| PK_PHRDOCM | Unique | PHRDOCM_SEQ_NO |
| PK_PHRDOCM | Unique | PHRDOCM_DOC_TYPE |
| PK_PHRDOCM | Unique | PHRDOCM_PRIORITY |
| PK_PHRDOCM | Unique | PHRDOCM_DOC_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PHRHIST | SQL Table | S10B80.PAYROLL | Join |
| PAY_DOCM_TYPE | Oracle Package Type | S10B80.BANINST1.BWPKHSTB | Rely On |
| PAY_SUM_TYPE | Oracle Package Type | S10B80.BANINST1.BWPKHSTB | Rely On |
| DOC_DATE | Oracle Package Variable | S10B80.BANINST1.BWPKHSTB | Rely On |
| GET_ADJS_DOCC | Oracle Package Cursor | S10B80.BANINST1.BWPKHSTB | Use (select) |
| P_GET_ORIGINAL_DATE | Oracle Package Procedure | S10B80.BANINST1.BWPKHSTB | Use (select) |
| F_CHECK_IF_ADJUSTED | Oracle Package Function | S10B80.BANINST1.BWPKHSTB | Use (select) |
| GET_PAY_DOCMC | Oracle Package Cursor | S10B80.BANINST1.BWPKHSTB | Use (select) |
| GET_PAY_SUMC | Oracle Package Cursor | S10B80.BANINST1.BWPKHSTB | Use (select) |
| PHRDOCMC | Oracle Package Cursor | S10B80.BANINST1.PHKLIBS | Use (select)Rely On |
| P_CHOOSEPAYSTUBYEAR | Oracle Package Procedure | S10B80.BANINST1.BWPKHSTB | Use (select) |
| P_DISPPAYSTUBDTL | Oracle Package Procedure | S10B80.BANINST1.BWPKHSTB | Rely On |
| P_VIEWDIRECTDEPOSIT | Oracle Package Procedure | S10B80.BANINST1.BWPKHPAY | Rely On |
| P_VIEWDIRECTDEPOSIT | Oracle Package Procedure | S10B80.BANINST1.BWPKHPAY | Use (select) |
| F_POSTING_DATE | Oracle Package Function | S10B80.BANINST1.POKLIBS | Use (select) |
| PHRDOCM | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PHRDOCM_KEY2_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHRDOCM_KEY3_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHRDOCM_KEY4_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PK_PHRDOCM | SQL Index | S10B80.PAYROLL | Rely On |
| GXVDIRD | SQL Table | S10B80.GENERAL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:35:26:000 | 04/02/2008 13:49:09:000 |
Table PHREARN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PHREARN_YEAR | VARCHAR2(4) | No | * | ||
| PHREARN_PICT_CODE | VARCHAR2(2) | No | * | ||
| PHREARN_PAYNO | NUMBER(3,0) | No | * | ||
| PHREARN_COAS_CODE_TS | VARCHAR2(1) | Yes | |||
| PHREARN_ORGN_CODE_TS | VARCHAR2(6) | No | * | ||
| PHREARN_TS_ROSTER_IND | VARCHAR2(1) | No | |||
| PHREARN_PIDM | NUMBER(8,0) | No | * | ||
| PHREARN_SEQ_NO | NUMBER(2,0) | No | * | ||
| PHREARN_POSN | VARCHAR2(6) | No | * | ||
| PHREARN_SUFF | VARCHAR2(2) | No | * | ||
| PHREARN_EFFECTIVE_DATE | DATE | No | * | ||
| PHREARN_EARN_CODE | VARCHAR2(3) | No | * | ||
| PHREARN_SHIFT | VARCHAR2(1) | No | |||
| PHREARN_GEN_IND | VARCHAR2(1) | No | |||
| PHREARN_HRS | NUMBER(6,2) | Yes | |||
| PHREARN_UPDATE_HRS | NUMBER(6,2) | Yes | |||
| PHREARN_RATE | NUMBER(12,6) | Yes | |||
| PHREARN_SPECIAL_RATE | NUMBER(12,6) | Yes | |||
| PHREARN_AMT | NUMBER(12,2) | Yes | |||
| PHREARN_ACTIVITY_DATE | DATE | No | |||
| PHREARN_TS_ENTRY_SEQ | NUMBER(2,0) | Yes | |||
| PHREARN_TS_PRINT_SEQ | NUMBER(2,0) | Yes | |||
| PHREARN_REDISTRIBUTION_IND | VARCHAR2(1) | Yes | |||
| PHREARN_DEEMED_HRS | NUMBER(6,2) | Yes | |||
| PHREARN_ACCRUE_SENIORITY_IND | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PHREARN_EARN_CODE | PTREARN_CODE | PTREARN |
| PHREARN_ORGN_CODE_TS | PTVORGN_CODE | PTVORGN |
| PHREARN_YEAR | PPRCOLR_VALUE_ATYP | PPRCOLR |
| PHREARN_PICT_CODE | PPRCOLR_PARM_NUMBER | PPRCOLR |
| PHREARN_PAYNO | PPRCOLR_TYPE | PPRCOLR |
| PHREARN_EARN_CODE | PTREERN_EARN_CODE | PTREERN |
| PHREARN_EFFECTIVE_DATE | PHRJOBS_EFFECTIVE_DATE | PHRJOBS |
| PHREARN_SUFF | PHRJOBS_SUFF | PHRJOBS |
| PHREARN_POSN | PHRJOBS_POSN | PHRJOBS |
| PHREARN_SEQ_NO | PHRJOBS_SEQ_NO | PHRJOBS |
| PHREARN_PIDM | PHRJOBS_PIDM | PHRJOBS |
| PHREARN_PAYNO | PHRJOBS_PAYNO | PHRJOBS |
| PHREARN_PICT_CODE | PHRJOBS_PICT_CODE | PHRJOBS |
| PHREARN_YEAR | PHRJOBS_YEAR | PHRJOBS |
| PHREARN_POSN | NBBPOSN_POSN | NBBPOSN |
| PHREARN_SEQ_NO | PHRHIST_SEQ_NO | PHRHIST |
| PHREARN_PIDM | PHRHIST_PIDM | PHRHIST |
| PHREARN_PAYNO | PHRHIST_PAYNO | PHRHIST |
| PHREARN_PICT_CODE | PHRHIST_PICT_CODE | PHRHIST |
| PHREARN_YEAR | PHRHIST_YEAR | PHRHIST |
| Index Name | Index Type | Column Name |
|---|---|---|
| PHREARN_KEY2_INDEX | PHREARN_PIDM | |
| PHREARN_KEY2_INDEX | PHREARN_YEAR | |
| PHREARN_KEY2_INDEX | PHREARN_PICT_CODE | |
| PHREARN_KEY2_INDEX | PHREARN_PAYNO | |
| PHREARN_KEY2_INDEX | PHREARN_SEQ_NO | |
| PHREARN_KEY3_INDEX | PHREARN_YEAR | |
| PHREARN_KEY3_INDEX | PHREARN_PICT_CODE | |
| PHREARN_KEY3_INDEX | PHREARN_PAYNO | |
| PHREARN_KEY3_INDEX | PHREARN_SEQ_NO | |
| PHREARN_KEY3_INDEX | PHREARN_EARN_CODE | |
| PHREARN_KEY_INDEX | Unique | PHREARN_YEAR |
| PHREARN_KEY_INDEX | Unique | PHREARN_PICT_CODE |
| PHREARN_KEY_INDEX | Unique | PHREARN_PAYNO |
| PHREARN_KEY_INDEX | Unique | PHREARN_GEN_IND |
| PHREARN_KEY_INDEX | Unique | PHREARN_PIDM |
| PHREARN_KEY_INDEX | Unique | PHREARN_SEQ_NO |
| PHREARN_KEY_INDEX | Unique | PHREARN_POSN |
| PHREARN_KEY_INDEX | Unique | PHREARN_SUFF |
| PHREARN_KEY_INDEX | Unique | PHREARN_EFFECTIVE_DATE |
| PHREARN_KEY_INDEX | Unique | PHREARN_EARN_CODE |
| PHREARN_KEY_INDEX | Unique | PHREARN_SHIFT |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PHVTTOT | SQL View | S10B80.BANINST1 | Use (select) |
| PAY_EARN_TYPE | Oracle Package Type | S10B80.BANINST1.BWPKHSTB | Rely On |
| GET_PAY_EARNC | Oracle Package Cursor | S10B80.BANINST1.BWPKHSTB | Use (select) |
| P_ACCRUE_SENIORITY_HOURS | Oracle Package Procedure | S10B80.BANINST1.PEKSNBL | Use (select) |
| F_ACCRUE_SENIORITY_IND | Oracle Package Function | S10B80.BANINST1.PEKSNBL | Rely On |
| F_ORDER_BY_PCLS | Oracle Package Function | S10B80.BANINST1.PEKSNBL | Rely On |
| PHREARN | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PHREARN_KEY2_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHREARN_KEY3_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHREARN_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| NBBPOSN | SQL Table | S10B80.POSNCTL | Join |
| PHRHIST | SQL Table | S10B80.PAYROLL | Join |
| PHRJOBS | SQL Table | S10B80.PAYROLL | Join |
| PPRCOLR | SQL Table | S10B80.PAYROLL | Join |
| PTREARN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTREERN | SQL Table | S10B80.PAYROLL | Join |
| PTVORGN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:32:08:000 | 04/02/2008 13:49:05:000 |
Table PHRHIST| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PHRHIST_YEAR | VARCHAR2(4) | No | * | * | |
| PHRHIST_PICT_CODE | VARCHAR2(2) | No | * | * | |
| PHRHIST_PAYNO | NUMBER(3,0) | No | * | * | |
| PHRHIST_PIDM | NUMBER(8,0) | No | * | * | |
| PHRHIST_SEQ_NO | NUMBER(2,0) | No | * | * | |
| PHRHIST_DISP | VARCHAR2(2) | No | |||
| PHRHIST_EVENT_DATE | DATE | Yes | |||
| PHRHIST_GROSS | NUMBER(11,2) | Yes | |||
| PHRHIST_NET | NUMBER(11,2) | Yes | |||
| PHRHIST_TYPE_IND | VARCHAR2(1) | No | |||
| PHRHIST_CALC_IND | VARCHAR2(1) | No | |||
| PHRHIST_PRINT_IND | VARCHAR2(1) | No | |||
| PHRHIST_ADJS_SEQ_NO | NUMBER(2,0) | Yes | |||
| PHRHIST_ADJS_DATE | DATE | Yes | |||
| PHRHIST_ADJ_BY_SEQ_NO | VARCHAR2(2) | Yes | |||
| PHRHIST_ADJ_BY_DATE | DATE | Yes | |||
| PHRHIST_ASSOC_SEQ_NO | NUMBER(2,0) | Yes | |||
| PHRHIST_ACTIVITY_DATE | DATE | No | |||
| PHRHIST_UI_WEEKS | NUMBER(5,3) | Yes | |||
| PHRHIST_UI_EXCEPTION_IND | VARCHAR2(1) | Yes | |||
| PHRHIST_UPDT_DATE | DATE | Yes | |||
| PHRHIST_POSTING_OVERRIDE_DATE | DATE | Yes | |||
| PHRHIST_USER_ID | VARCHAR2(30) | Yes | |||
| PHRHIST_COMMENT | VARCHAR2(2000) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PHRHIST_YEAR | PTRCALN_YEAR | PTRCALN |
| PHRHIST_PICT_CODE | PTRCALN_PICT_CODE | PTRCALN |
| PHRHIST_PAYNO | PTRCALN_PAYNO | PTRCALN |
| PHRHIST_PIDM | PEBEMPL_PIDM | PEBEMPL |
| PHRHIST_YEAR | PHRJOBS_YEAR | PHRJOBS |
| PHRHIST_PICT_CODE | PHRJOBS_PICT_CODE | PHRJOBS |
| PHRHIST_PAYNO | PHRJOBS_PAYNO | PHRJOBS |
| PHRHIST_SEQ_NO | PHRJOBS_SEQ_NO | PHRJOBS |
| PHRHIST_PIDM | PHRJOBS_PIDM | PHRJOBS |
| PHRHIST_SEQ_NO | PHRDOCM_SEQ_NO | PHRDOCM |
| PHRHIST_PAYNO | PHRDOCM_PAYNO | PHRDOCM |
| PHRHIST_PICT_CODE | PHRDOCM_PICT_CODE | PHRDOCM |
| PHRHIST_YEAR | PHRDOCM_YEAR | PHRDOCM |
| PHRHIST_PIDM | PHRDOCM_PIDM | PHRDOCM |
| Index Name | Index Type | Column Name |
|---|---|---|
| PHRHIST_KEY2_INDEX | PHRHIST_PIDM | |
| PHRHIST_KEY2_INDEX | PHRHIST_YEAR | |
| PHRHIST_KEY2_INDEX | PHRHIST_PICT_CODE | |
| PHRHIST_KEY2_INDEX | PHRHIST_PAYNO | |
| PHRHIST_KEY2_INDEX | PHRHIST_SEQ_NO | |
| PHRHIST_KEY3_INDEX | PHRHIST_DISP | |
| PHRHIST_KEY3_INDEX | PHRHIST_YEAR | |
| PHRHIST_KEY3_INDEX | PHRHIST_PICT_CODE | |
| PHRHIST_KEY3_INDEX | PHRHIST_PAYNO | |
| PHRHIST_KEY3_INDEX | PHRHIST_PRINT_IND | |
| PHRHIST_KEY4_INDEX | PHRHIST_YEAR | |
| PHRHIST_KEY4_INDEX | PHRHIST_PICT_CODE | |
| PHRHIST_KEY4_INDEX | PHRHIST_PAYNO | |
| PHRHIST_KEY4_INDEX | PHRHIST_SEQ_NO | |
| PHRHIST_KEY4_INDEX | PHRHIST_DISP | |
| PHRHIST_KEY5_INDEX | PHRHIST_UPDT_DATE | |
| PK_PHRHIST | Unique | PHRHIST_YEAR |
| PK_PHRHIST | Unique | PHRHIST_PICT_CODE |
| PK_PHRHIST | Unique | PHRHIST_PAYNO |
| PK_PHRHIST | Unique | PHRHIST_PIDM |
| PK_PHRHIST | Unique | PHRHIST_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PHRHIST_KEY2_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHRHIST_KEY3_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHRHIST_KEY4_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHRHIST_KEY5_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PK_PHRHIST | SQL Index | S10B80.PAYROLL | Rely On |
| PEBEMPL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PHRDOCM | SQL Table | S10B80.PAYROLL | Join |
| PHRJOBS | SQL Table | S10B80.PAYROLL | Join |
| PTRCALN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:33:58:000 | 04/02/2008 13:49:08:000 |
Table PHRJACR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PHRJACR_YEAR | VARCHAR2(4) | No | * | * | |
| PHRJACR_PICT_CODE | VARCHAR2(2) | No | * | * | |
| PHRJACR_PAYNO | NUMBER(3,0) | No | * | * | |
| PHRJACR_PIDM | NUMBER(8,0) | No | * | * | |
| PHRJACR_POSN | VARCHAR2(6) | No | * | ||
| PHRJACR_SUFF | VARCHAR2(2) | No | * | ||
| PHRJACR_EFFECTIVE_DATE | DATE | No | * | ||
| PHRJACR_LEAV_CODE | VARCHAR2(4) | No | * | * | |
| PHRJACR_CALC_GEN_IND | VARCHAR2(1) | No | |||
| PHRJACR_BANK_IND | VARCHAR2(1) | No | |||
| PHRJACR_USER_ID | VARCHAR2(30) | No | |||
| PHRJACR_ACTIVITY_DATE | DATE | No | |||
| PHRJACR_CURR_ACCR | NUMBER(6,2) | Yes | |||
| PHRJACR_CURR_TAKEN | NUMBER(6,2) | Yes | |||
| PHRJACR_MAX_HRS | NUMBER(6,2) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PHRJACR_LEAV_CODE | PTRLEAV_CODE | PTRLEAV |
| PHRJACR_PICT_CODE | PTRPICT_CODE | PTRPICT |
| PHRJACR_PIDM | PHRHIST_PIDM | PHRHIST |
| PHRJACR_PAYNO | PHRHIST_PAYNO | PHRHIST |
| PHRJACR_PICT_CODE | PHRHIST_PICT_CODE | PHRHIST |
| PHRJACR_YEAR | PHRHIST_YEAR | PHRHIST |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PHRJACR | Unique | PHRJACR_YEAR |
| PK_PHRJACR | Unique | PHRJACR_PICT_CODE |
| PK_PHRJACR | Unique | PHRJACR_PAYNO |
| PK_PHRJACR | Unique | PHRJACR_PIDM |
| PK_PHRJACR | Unique | PHRJACR_POSN |
| PK_PHRJACR | Unique | PHRJACR_SUFF |
| PK_PHRJACR | Unique | PHRJACR_EFFECTIVE_DATE |
| PK_PHRJACR | Unique | PHRJACR_LEAV_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PERJLEV | SQL Table | S10B80.PAYROLL | Join |
| PHRJOBS | SQL Table | S10B80.PAYROLL | Join |
| PTRCALN | SQL Table | S10B80.PAYROLL | Join |
| PTRLVAS | SQL Table | S10B80.PAYROLL | Join |
| PHRJACR_RECTYPE | Oracle Package Type | S10B80.BANINST1.PEKLEAV | Rely On |
| PHRJACRC | Oracle Package Cursor | S10B80.BANINST1.PEKLEAV | Use (select) |
| F_GET_JOB_LEAVE_ACCRUAL | Oracle Package Function | S10B80.BANINST1.PEKLEAV | Use (select) |
| PHRJACR | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PHRJACR | SQL Index | S10B80.PAYROLL | Rely On |
| PHRHIST | SQL Table | S10B80.PAYROLL | Join |
| PTRLEAV | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRPICT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:39:51:000 | 04/02/2008 13:49:14:000 |
Table PHRJOBS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PHRJOBS_YEAR | VARCHAR2(4) | No | * | * | |
| PHRJOBS_PICT_CODE | VARCHAR2(2) | No | * | * | |
| PHRJOBS_PAYNO | NUMBER(3,0) | No | * | * | |
| PHRJOBS_COAS_CODE_TS | VARCHAR2(1) | Yes | |||
| PHRJOBS_ORGN_CODE_TS | VARCHAR2(6) | No | * | ||
| PHRJOBS_TS_ROSTER_IND | VARCHAR2(1) | No | |||
| PHRJOBS_PIDM | NUMBER(8,0) | No | * | * | |
| PHRJOBS_SEQ_NO | NUMBER(2,0) | No | * | ||
| PHRJOBS_POSN | VARCHAR2(6) | No | * | * | |
| PHRJOBS_SUFF | VARCHAR2(2) | No | * | * | |
| PHRJOBS_EFFECTIVE_DATE | DATE | No | * | * | |
| PHRJOBS_STATUS | VARCHAR2(1) | No | |||
| PHRJOBS_ECLS_CODE | VARCHAR2(2) | No | * | ||
| PHRJOBS_BASE_SAL_HRS | NUMBER(6,2) | Yes | |||
| PHRJOBS_SALARY_RATE | NUMBER(11,6) | No | |||
| PHRJOBS_PER_PAY_SALARY | NUMBER(11,2) | No | |||
| PHRJOBS_APPT_PCT | NUMBER(5,2) | No | |||
| PHRJOBS_DEFER_AMT | NUMBER(11,2) | Yes | |||
| PHRJOBS_CONTRACT_TYPE | VARCHAR2(1) | No | |||
| PHRJOBS_SHIFT | VARCHAR2(1) | No | |||
| PHRJOBS_PAY_CNT | NUMBER(3,0) | Yes | |||
| PHRJOBS_DISP | VARCHAR2(2) | No | |||
| PHRJOBS_ID_SEQ | VARCHAR2(9) | No | |||
| PHRJOBS_LAST_NAME_SEQ | VARCHAR2(60) | No | |||
| PHRJOBS_FIRST_NAME_SEQ | VARCHAR2(60) | No | |||
| PHRJOBS_ACTIVITY_DATE | DATE | No | |||
| PHRJOBS_EMPR_CODE | VARCHAR2(4) | No | * | ||
| PHRJOBS_LGCD_CODE | VARCHAR2(4) | Yes | * | ||
| PHRJOBS_TIME_ENTRY_IND | VARCHAR2(1) | Yes | |||
| PHRJOBS_EFFECTIVE_UNTIL_DATE | DATE | Yes | |||
| PHRJOBS_PCAT_CODE | VARCHAR2(4) | Yes | * | ||
| PHRJOBS_STRS_CONT_CODE | VARCHAR2(2) | Yes | |||
| PHRJOBS_PERS_CONT_CODE | VARCHAR2(2) | Yes | |||
| PHRJOBS_STRS_ASSN_CODE | VARCHAR2(2) | Yes | |||
| PHRJOBS_STRS_PAY_CODE | VARCHAR2(2) | Yes | |||
| PHRJOBS_PERS_PAY_CODE | VARCHAR2(2) | Yes | |||
| PHRJOBS_FULL_ASSGN_SALARY | NUMBER(11,2) | Yes | |||
| PHRJOBS_PREV_FISCAL_YEAR_IND | VARCHAR2(1) | Yes | |||
| PHRJOBS_LCAT_CODE | VARCHAR2(2) | Yes | |||
| PHRJOBS_FTE | NUMBER(6,3) | Yes | |||
| PHRJOBS_HRS_DAY | NUMBER(6,2) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PHRJOBS_PIDM | NBRBJOB_PIDM | NBRBJOB |
| PHRJOBS_POSN | NBRBJOB_POSN | NBRBJOB |
| PHRJOBS_SUFF | NBRBJOB_SUFF | NBRBJOB |
| PHRJOBS_ECLS_CODE | PTRECLS_CODE | PTRECLS |
| PHRJOBS_ORGN_CODE_TS | PTVORGN_CODE | PTVORGN |
| PHRJOBS_LGCD_CODE | PTVLGCD_CODE | PTVLGCD |
| PHRJOBS_EMPR_CODE | PTREMPR_CODE | PTREMPR |
| PHRJOBS_PCAT_CODE | PTVPCAT_CODE | PTVPCAT |
| PHRJOBS_SUFF | PHRJACR_SUFF | PHRJACR |
| PHRJOBS_POSN | PHRJACR_POSN | PHRJACR |
| PHRJOBS_PIDM | PHRJACR_PIDM | PHRJACR |
| PHRJOBS_EFFECTIVE_DATE | PHRJACR_EFFECTIVE_DATE | PHRJACR |
| PHRJOBS_PAYNO | PHRJACR_PAYNO | PHRJACR |
| PHRJOBS_PICT_CODE | PHRJACR_PICT_CODE | PHRJACR |
| PHRJOBS_YEAR | PHRJACR_YEAR | PHRJACR |
| Index Name | Index Type | Column Name |
|---|---|---|
| PHRJOBS_KEY2_INDEX | PHRJOBS_DISP | |
| PHRJOBS_KEY2_INDEX | PHRJOBS_YEAR | |
| PHRJOBS_KEY2_INDEX | PHRJOBS_PICT_CODE | |
| PHRJOBS_KEY2_INDEX | PHRJOBS_PAYNO | |
| PHRJOBS_KEY3_INDEX | PHRJOBS_PIDM | |
| PHRJOBS_KEY3_INDEX | PHRJOBS_POSN | |
| PHRJOBS_KEY3_INDEX | PHRJOBS_SUFF | |
| PHRJOBS_KEY4_INDEX | PHRJOBS_YEAR | |
| PHRJOBS_KEY4_INDEX | PHRJOBS_PICT_CODE | |
| PHRJOBS_KEY4_INDEX | PHRJOBS_PAYNO | |
| PHRJOBS_KEY4_INDEX | PHRJOBS_SEQ_NO | |
| PHRJOBS_KEY4_INDEX | PHRJOBS_ORGN_CODE_TS | |
| PHRJOBS_KEY4_INDEX | PHRJOBS_TS_ROSTER_IND | |
| PHRJOBS_KEY5_INDEX | PHRJOBS_PIDM | |
| PHRJOBS_KEY5_INDEX | PHRJOBS_SEQ_NO | |
| PHRJOBS_KEY6_INDEX | Unique | PHRJOBS_YEAR |
| PHRJOBS_KEY6_INDEX | Unique | PHRJOBS_PICT_CODE |
| PHRJOBS_KEY6_INDEX | Unique | PHRJOBS_PAYNO |
| PHRJOBS_KEY6_INDEX | Unique | PHRJOBS_ID_SEQ |
| PHRJOBS_KEY6_INDEX | Unique | PHRJOBS_SEQ_NO |
| PHRJOBS_KEY6_INDEX | Unique | PHRJOBS_POSN |
| PHRJOBS_KEY6_INDEX | Unique | PHRJOBS_SUFF |
| PHRJOBS_KEY6_INDEX | Unique | PHRJOBS_EFFECTIVE_DATE |
| PK_PHRJOBS | Unique | PHRJOBS_YEAR |
| PK_PHRJOBS | Unique | PHRJOBS_PICT_CODE |
| PK_PHRJOBS | Unique | PHRJOBS_PAYNO |
| PK_PHRJOBS | Unique | PHRJOBS_PIDM |
| PK_PHRJOBS | Unique | PHRJOBS_SEQ_NO |
| PK_PHRJOBS | Unique | PHRJOBS_POSN |
| PK_PHRJOBS | Unique | PHRJOBS_SUFF |
| PK_PHRJOBS | Unique | PHRJOBS_EFFECTIVE_DATE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PHRJOBS_KEY2_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHRJOBS_KEY3_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHRJOBS_KEY4_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHRJOBS_KEY5_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PHRJOBS_KEY6_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PK_PHRJOBS | SQL Index | S10B80.PAYROLL | Rely On |
| NBRBJOB | SQL Table | S10B80.POSNCTL | Refer (no action) |
| PHRJACR | SQL Table | S10B80.PAYROLL | Join |
| PTRECLS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTREMPR | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVLGCD | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVORGN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVPCAT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:38:29:000 | 04/02/2008 13:49:13:000 |
Table PPRCOLR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PPRCOLR_SESSIONID | VARCHAR2(30) | No | |||
| PPRCOLR_TYPE | VARCHAR2(3) | Yes | * | ||
| PPRCOLR_VALUE_DATE | DATE | Yes | |||
| PPRCOLR_VALUE_ATYP | VARCHAR2(30) | Yes | * | ||
| PPRCOLR_JOB | VARCHAR2(30) | Yes | * | ||
| PPRCOLR_PARM_NUMBER | VARCHAR2(10) | Yes | * | ||
| PPRCOLR_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PPRCOLR_JOB | PXRRERN_REPT_CODE | PXRRERN |
| PPRCOLR_PARM_NUMBER | PERJTOT_YEAR | PERJTOT |
| PPRCOLR_VALUE_ATYP | PERJTOT_EMPR_CODE | PERJTOT |
| PPRCOLR_TYPE | PERJTOT_EARN_CODE | PERJTOT |
| PPRCOLR_JOB | PXRRDED_REPT_CODE | PXRRDED |
| PPRCOLR_PARM_NUMBER | PERDTOT_YEAR | PERDTOT |
| PPRCOLR_VALUE_ATYP | PERDTOT_EMPR_CODE | PERDTOT |
| PPRCOLR_TYPE | PERDTOT_BDCA_CODE | PERDTOT |
| PPRCOLR_VALUE_ATYP | PHRJOBS_YEAR | PHRJOBS |
| PPRCOLR_PARM_NUMBER | PHRJOBS_PICT_CODE | PHRJOBS |
| PPRCOLR_TYPE | PHRJOBS_PAYNO | PHRJOBS |
| PPRCOLR_TYPE | PTRBDCA_BDTY_CODE | PTRBDCA |
| PPRCOLR_VALUE_ATYP | NBRBJOB_POSN | NBRBJOB |
| Index Name | Index Type | Column Name |
|---|---|---|
| PPRCOLR_KEY_INDEX | PPRCOLR_SESSIONID | |
| PPRCOLR_KEY_INDEX | PPRCOLR_JOB | |
| PPRCOLR_KEY_INDEX | PPRCOLR_PARM_NUMBER |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PHREARN | SQL Table | S10B80.PAYROLL | Join |
| PEVATOT | SQL View | S10B80.BANINST1 | Use (select) |
| PEVATYP | SQL View | S10B80.BANINST1 | Use (select) |
| PEVDTOT | SQL View | S10B80.BANINST1 | Use (select) |
| PEVJTOT | SQL View | S10B80.BANINST1 | Use (select) |
| PEVRTWK | SQL View | S10B80.BANINST1 | Use (select) |
| PHVTSKY | SQL View | S10B80.BANINST1 | Use (select) |
| PHVTTOT | SQL View | S10B80.BANINST1 | Use (select) |
| PXVREPT | SQL View | S10B80.BANINST1 | Use (select) |
| P_DELETE_PPRCOLR_DAYS | Oracle Package Procedure | S10B80.BANINST1.PEKTEEX | Use (delete) |
| P_INSERT_PHRTHRS_NO_JOB | Oracle Package Procedure | S10B80.BANINST1.PEKTEEX | Use (select) |
| P_INSERT_PHRTHRS_NO_WKSH | Oracle Package Procedure | S10B80.BANINST1.PEKTEEX | Use (select) |
| P_INSERT_PHRTHRS_WKSH | Oracle Package Procedure | S10B80.BANINST1.PEKTEEX | Use (select) |
| P_INSERT_PPRCOLR_DAYS | Oracle Package Procedure | S10B80.BANINST1.PEKTEEX | Use (Insert) |
| PPRCOLR | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PPRCOLR_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| NBRBJOB | SQL Table | S10B80.POSNCTL | Join |
| PERDTOT | SQL Table | S10B80.PAYROLL | Join |
| PERJTOT | SQL Table | S10B80.PAYROLL | Join |
| PHRJOBS | SQL Table | S10B80.PAYROLL | Join |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Join |
| PXRRDED | SQL Table | S10B80.PAYROLL | Join |
| PXRRERN | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:39:53:000 | 04/02/2008 13:49:14:000 |
Table PTRBCAT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRBCAT_CODE | VARCHAR2(2) | No | * | ||
| PTRBCAT_DESC | VARCHAR2(30) | No | |||
| PTRBCAT_ACTIVITY_DATE | DATE | No | |||
| PTRBCAT_FLEX_AMT | NUMBER(11,2) | Yes | |||
| PTRBCAT_WEB_ACCESS_IND | VARCHAR2(1) | No | |||
| PTRBCAT_OPEN_BEGIN_DATE | DATE | Yes | |||
| PTRBCAT_OPEN_END_DATE | DATE | Yes | |||
| PTRBCAT_OPEN_EFFECTIVE_DATE | DATE | Yes | |||
| PTRBCAT_DATE_OVERRIDE_IND | VARCHAR2(1) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRBCAT | Unique | PTRBCAT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PEBEMPL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PEREHIS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBCDN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRECBC | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PEVEMPL | SQL View | S10B80.BANINST1 | Use (select) |
| F_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
| PTRBCAT_RECTYPE | Oracle Package Type | S10B80.BANINST1.POKRECS | Rely On |
| PTRBCAT_REC | Oracle Package Variable | S10B80.BANINST1.PDKLIBS | Rely On |
| P_CHK_WAIVED_DEDUCTION | Oracle Package Procedure | S10B80.BANINST1.BWPKDOEN | Rely On |
| P_PERSONALINFO | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Rely On |
| P_PERSONALINFO | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Use (select) |
| PTRBCATC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select)Rely On |
| P_DISPDATESELECT | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Use (select) |
| P_EDIT_BDCA_CODE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_EDIT_NEW_EFFECTIVE_DATE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_EDIT_PEBEMPL_BCAT_CODE | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (select) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_CARDHOLDER | Use (Insert,select) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_NB_JOB_LABOR | Use (Insert,select) |
| F_ISDEDNFUNCALLOWED | Oracle Package Function | S10B80.BANINST1.BWPKDCMN | Use (select) |
| F_PTRBCAT_REC | Oracle Package Function | S10B80.BANINST1.POKRECS | Rely On |
| F_PTRBCAT_REC | Oracle Package Function | S10B80.BANINST1.POKRECS | Use (select) |
| F_PTRECBC_REC | Oracle Package Function | S10B80.BANINST1.POKRECS | Rely On |
| PTRBCAT | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRBCAT | SQL Index | S10B80.PAYROLL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:34:13:000 | 04/02/2008 13:49:08:000 |
Table PTRBCDN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRBCDN_BCAT_CODE | VARCHAR2(2) | No | * | ||
| PTRBCDN_BDCA_CODE | VARCHAR2(3) | No | * | ||
| PTRBCDN_REQ_IND | VARCHAR2(1) | No | |||
| PTRBCDN_SETUP_IND | VARCHAR2(1) | No | |||
| PTRBCDN_ACTIVITY_DATE | DATE | No | |||
| PTRBCDN_SEQ_NO | NUMBER(2,0) | Yes | |||
| PTRBCDN_AMOUNT1 | NUMBER(11,2) | Yes | |||
| PTRBCDN_AMOUNT2 | NUMBER(11,2) | Yes | |||
| PTRBCDN_AMOUNT3 | NUMBER(11,2) | Yes | |||
| PTRBCDN_AMOUNT4 | NUMBER(11,2) | Yes | |||
| PTRBCDN_OPT_CODE1 | VARCHAR2(2) | Yes | |||
| PTRBCDN_OPT_CODE2 | VARCHAR2(2) | Yes | |||
| PTRBCDN_OPT_CODE3 | VARCHAR2(2) | Yes | |||
| PTRBCDN_OPT_CODE4 | VARCHAR2(2) | Yes | |||
| PTRBCDN_OPT_CODE5 | VARCHAR2(2) | Yes | |||
| PTRBCDN_BEGIN_DATE_IND | VARCHAR2(1) | No | |||
| PTRBCDN_DEDN_STATUS | VARCHAR2(1) | Yes | |||
| PTRBCDN_BEGIN_DATE | DATE | No | |||
| PTRBCDN_END_DATE | DATE | Yes | |||
| PTRBCDN_COVERAGE_END_DATE_IND | VARCHAR2(1) | No | |||
| PTRBCDN_DISP_ON_STMT_IND | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRBCDN_BCAT_CODE | PTRBCAT_CODE | PTRBCAT |
| PTRBCDN_BCAT_CODE | PEBEMPL_BCAT_CODE | PEBEMPL |
| PTRBCDN_BDCA_CODE | PTRBDCA_CODE | PTRBDCA |
| PTRBCDN_BDCA_CODE | PDRDEDN_BDCA_CODE | PDRDEDN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PTRBCDN_KEY_INDEX | Unique | PTRBCDN_BCAT_CODE |
| PTRBCDN_KEY_INDEX | Unique | PTRBCDN_BDCA_CODE |
| PTRBCDN_KEY_INDEX | Unique | PTRBCDN_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRBCDN_REC | Oracle Package Variable | S10B80.BANINST1.PDKLIBS | Rely On |
| GETSECGRPC | Oracle Package Cursor | S10B80.BANINST1.BWPKEBST | Use (select) |
| P_BENEFITS | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Use (select) |
| P_CHK_WAIVED_DEDUCTION | Oracle Package Procedure | S10B80.BANINST1.BWPKDOEN | Rely On |
| F_INVALID_DEDN_EXISTS | Oracle Package Function | S10B80.BANINST1.PB_EMPLOYEE_RULES | Use (select) |
| PTRBCDNBDCAC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select)Rely On |
| PTRBCDNC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select)Rely On |
| P_EDIT_BDCA | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (select) |
| P_EDIT_BDCA_CODE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_EDIT_BDCA_CODE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Use (select) |
| P_EDIT_NEW_EFFECTIVE_DATE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Use (select) |
| P_EDIT_PEBEMPL_BCAT_CODE | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (select) |
| P_VERIFYCOREBDCAEMP | Oracle Package Procedure | S10B80.BANINST1.PDKLIBS | Rely On |
| F_CHECK_REQD_DEDNS | Oracle Package Function | S10B80.BANINST1.POKLIBS | Use (select) |
| F_COREDEDNIND | Oracle Package Function | S10B80.BANINST1.PDKLIBS | Rely On |
| F_DEDNISREQUIRED | Oracle Package Function | S10B80.BANINST1.PDKLIBS | Use (select) |
| F_INVALID_DEDN_EXISTS | Oracle Package Function | S10B80.BANINST1.PEKEMPL | Use (select) |
| F_VERIFYCOREBDCABCAT | Oracle Package Function | S10B80.BANINST1.PDKLIBS | Rely On |
| F_VERIFYCOREBDCABCAT | Oracle Package Function | S10B80.BANINST1.PDKLIBS | Use (select) |
| PTRBCDN | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRBCDN_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PDRDEDN | SQL Table | S10B80.PAYROLL | Join |
| PEBEMPL | SQL Table | S10B80.PAYROLL | Join |
| PTRBCAT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:34:29:000 | 04/02/2008 13:49:08:000 |
Table PTRBDAS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRBDAS_CODE | VARCHAR2(3) | No | * | ||
| PTRBDAS_BDCA_CODE | VARCHAR2(3) | No | * | * | |
| PTRBDAS_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRBDAS_BDCA_CODE | PTRBDCA_CODE | PTRBDCA |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRBDAS | Unique | PTRBDAS_CODE |
| PK_PTRBDAS | Unique | PTRBDAS_BDCA_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PERDTOT | SQL Table | S10B80.PAYROLL | Join |
| PEVATOT | SQL View | S10B80.BANINST1 | Use (select) |
| PEVBDAS | SQL View | S10B80.BANINST1 | Use (select) |
| PTRBDAS | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRBDAS | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:35:12:000 | 04/02/2008 13:49:09:000 |
Table PTRBDCA| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRBDCA_CODE | VARCHAR2(3) | No | * | * | |
| PTRBDCA_SHORT_DESC | VARCHAR2(8) | No | |||
| PTRBDCA_LONG_DESC | VARCHAR2(30) | No | |||
| PTRBDCA_PRIORITY | NUMBER(2,0) | No | |||
| PTRBDCA_CALC_RULE | VARCHAR2(2) | No | |||
| PTRBDCA_WEEK1_IND | VARCHAR2(1) | No | |||
| PTRBDCA_WEEK2_IND | VARCHAR2(1) | No | |||
| PTRBDCA_WEEK3_IND | VARCHAR2(1) | No | |||
| PTRBDCA_WEEK4_IND | VARCHAR2(1) | No | |||
| PTRBDCA_WEEK5_IND | VARCHAR2(1) | No | |||
| PTRBDCA_AMT1_IND | VARCHAR2(1) | No | |||
| PTRBDCA_AMT2_IND | VARCHAR2(1) | No | |||
| PTRBDCA_AMT3_IND | VARCHAR2(1) | No | |||
| PTRBDCA_AMT4_IND | VARCHAR2(1) | No | |||
| PTRBDCA_AMT1_TITLE | VARCHAR2(8) | Yes | |||
| PTRBDCA_AMT2_TITLE | VARCHAR2(8) | Yes | |||
| PTRBDCA_AMT3_TITLE | VARCHAR2(8) | Yes | |||
| PTRBDCA_AMT4_TITLE | VARCHAR2(8) | Yes | |||
| PTRBDCA_OPTION1_IND | VARCHAR2(1) | No | |||
| PTRBDCA_OPTION2_IND | VARCHAR2(1) | No | |||
| PTRBDCA_OPTION3_IND | VARCHAR2(1) | No | |||
| PTRBDCA_OPTION4_IND | VARCHAR2(1) | No | |||
| PTRBDCA_OPTION5_IND | VARCHAR2(1) | No | |||
| PTRBDCA_OPTION1_TITLE | VARCHAR2(8) | Yes | |||
| PTRBDCA_OPTION2_TITLE | VARCHAR2(8) | Yes | |||
| PTRBDCA_OPTION3_TITLE | VARCHAR2(8) | Yes | |||
| PTRBDCA_OPTION4_TITLE | VARCHAR2(8) | Yes | |||
| PTRBDCA_OPTION5_TITLE | VARCHAR2(8) | Yes | |||
| PTRBDCA_GROSS_REPORT_IND | VARCHAR2(1) | Yes | |||
| PTRBDCA_BENEFIT_IND | VARCHAR2(1) | No | |||
| PTRBDCA_TXCD_CODE | VARCHAR2(8) | Yes | |||
| PTRBDCA_TAX_TYPE_IND | VARCHAR2(1) | Yes | |||
| PTRBDCA_OVERLOAD_IND | VARCHAR2(1) | No | |||
| PTRBDCA_ARREAR_IND | VARCHAR2(1) | No | |||
| PTRBDCA_ACTIVITY_DATE | DATE | No | |||
| PTRBDCA_BDTY_CODE | VARCHAR2(2) | Yes | * | ||
| PTRBDCA_AMT1_DESC | VARCHAR2(30) | Yes | |||
| PTRBDCA_AMT2_DESC | VARCHAR2(30) | Yes | |||
| PTRBDCA_AMT3_DESC | VARCHAR2(30) | Yes | |||
| PTRBDCA_AMT4_DESC | VARCHAR2(30) | Yes | |||
| PTRBDCA_1099_CODE | VARCHAR2(2) | Yes | * | ||
| PTRBDCA_FLAT_AMT_IND | VARCHAR2(1) | Yes | |||
| PTRBDCA_YTD_START_MONTH | NUMBER(2,0) | Yes | |||
| PTRBDCA_WEB_DESC | VARCHAR2(100) | Yes | |||
| PTRBDCA_WEB_INFO_URL | VARCHAR2(100) | Yes | |||
| PTRBDCA_OPTION1_WEB_DESC | VARCHAR2(100) | Yes | |||
| PTRBDCA_OPTION2_WEB_DESC | VARCHAR2(100) | Yes | |||
| PTRBDCA_OPTION3_WEB_DESC | VARCHAR2(100) | Yes | |||
| PTRBDCA_OPTION4_WEB_DESC | VARCHAR2(100) | Yes | |||
| PTRBDCA_OPTION5_WEB_DESC | VARCHAR2(100) | Yes | |||
| PTRBDCA_AMT1_WEB_DESC | VARCHAR2(100) | Yes | |||
| PTRBDCA_AMT2_WEB_DESC | VARCHAR2(100) | Yes | |||
| PTRBDCA_AMT3_WEB_DESC | VARCHAR2(100) | Yes | |||
| PTRBDCA_AMT4_WEB_DESC | VARCHAR2(100) | Yes | |||
| PTRBDCA_BDCL_CODE | VARCHAR2(8) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRBDCA_1099_CODE | PTV1099_CODE | PTV1099 |
| PTRBDCA_BDCL_CODE | PTRBDCL_CODE | PTRBDCL |
| PTRBDCA_BDTY_CODE | PTVBDTY_CODE | PTVBDTY |
| PTRBDCA_CODE | PDRDEDN_BDCA_CODE | PDRDEDN |
| PTRBDCA_CODE | PDRBCOV_BDCA_CODE | PDRBCOV |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRBDCA | Unique | PTRBDCA_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRBDED | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PERDTOT | SQL Table | S10B80.PAYROLL | Join |
| PHRDEDN | SQL Table | S10B80.PAYROLL | Join |
| PPRCOLR | SQL Table | S10B80.PAYROLL | Join |
| PTRBCDN | SQL Table | S10B80.PAYROLL | Join |
| PTRBDAS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDCG | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDFQ | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDGM | SQL Table | S10B80.PAYROLL | Join |
| PTRBDID | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDLD | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDLG | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDPD | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDPL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDXD | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRBDXE | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRCBEN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRCOVR | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRDCHN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRFBEN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRFLEX | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRLIFE | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRLIFI | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRPREM | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRSDED | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRSTDE | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXRFSTA | SQL Table | S10B80.PAYROLL | Join |
| PXRRDED | SQL Table | S10B80.PAYROLL | Join |
| PXRTXCD | SQL Table | S10B80.PAYROLL | Join |
| PDVBCOV | SQL View | S10B80.BANINST1 | Use (select) |
| PDVDAMT | SQL View | S10B80.BANINST1 | Use (select) |
| PDVDED1 | SQL View | S10B80.BANINST1 | Use (select) |
| PDVDEDD | SQL View | S10B80.BANINST1 | Use (select) |
| PDVDEDN | SQL View | S10B80.BANINST1 | Use (select) |
| PEVATYP | SQL View | S10B80.BANINST1 | Use (select) |
| PEVDEDT | SQL View | S10B80.BANINST1 | Use (select) |
| F_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
| PAY_DEDN_TYPE | Oracle Package Type | S10B80.BANINST1.BWPKHSTB | Rely On |
| PERDTOT_SUM_TYPE | Oracle Package Type | S10B80.BANINST1.BWPKHDED | Rely On |
| PTRBDCA_REC | Oracle Package Variable | S10B80.BANINST1.PDKLIBS | Rely On |
| PTRBDCA_REC | Oracle Package Variable | S10B80.BANINST1.PXKLIBS | Rely On |
| GETSECGRPC | Oracle Package Cursor | S10B80.BANINST1.BWPKEBST | Use (select) |
| PTRBDCAC | Oracle Package Cursor | S10B80.BANINST1.BWPKDBCV | Use (select) |
| PTRBDCA_C | Oracle Package Cursor | S10B80.BANINST1.PP_W2 | Rely On |
| PTRBDCA_C | Oracle Package Cursor | S10B80.BANINST1.PP_W2 | Use (select) |
| BDCA_EXISTS | Oracle Package Procedure | S10B80.BANINST1.POKPVAL | Use (select) |
| P_BENEFITS | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Use (select) |
| P_BUILD_W2 | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2006 | Rely On |
| P_BUILD_W2 | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2006 | Use (select) |
| P_BUILD_W2 | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2007 | Rely On |
| P_BUILD_W2 | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2007 | Use (select) |
| P_BUILD_W2_REC | Oracle Package Procedure | S10B80.BANINST1.PP_W2 | Rely On |
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2006 | Use (select) |
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2007 | Use (select) |
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2 | Use (select) |
| P_CROSS_FIELD_EDITS | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_EDIT_INPUT | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_EDIT_INPUT | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Use (select)Rely On |
| P_OPENENROLLMENTGRPSHOW | Oracle Package Procedure | S10B80.BANINST1.BWPKDOEN | Rely On |
| P_PRINTCOVEREDPERSONS | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Rely On |
| P_PRINTCOVEREDPERSONS | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Use (select) |
| UT_PB_W2_FEDERALDELETEAPI | Oracle Package Procedure | S10B80.BANINST1.UT_PB_W2_FEDERAL | Use (select) |
| PTRBDCA_REC | Oracle Package Variable | S10B80.BANINST1.BWPKDBCV | Rely On |
| GET_PAY_DEDNC | Oracle Package Cursor | S10B80.BANINST1.BWPKHSTB | Use (select) |
| PERDTOTSUMC | Oracle Package Cursor | S10B80.BANINST1.BWPKHDED | Use (select) |
| PTRBDCABYBDTYC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select)Rely On |
| PTRBDCABYDESCC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select)Rely On |
| PTRBDCAVIEWC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select)Rely On |
| P_APPLY_DEDUCTION | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_CHECK_PRECLUSION | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_DELETE | Oracle Package Procedure | S10B80.BANINST1.PB_DEDN_COMB_LMT | Use (select) |
| P_EDIT_AMOUNT | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_EDIT_BDCA | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (select) |
| P_EDIT_BDCA_CODE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_EDIT_BDCA_CODE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Use (select) |
| P_EDIT_NEW_EFFECTIVE_DATE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_EDIT_NTRFRNG_BDCA_CODE | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (select) |
| P_EDIT_OPT_CODE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_EDIT_OPT_CODE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Use (select) |
| P_OPENENROLLMENTFUNCADDDHIS | Oracle Package Procedure | S10B80.BANINST1.BWPKDOFN | Rely On |
| P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.PB_W2_LOCAL_RULES | Use (select) |
| P_VIEWDEDNSUMMARYBODY | Oracle Package Procedure | S10B80.BANINST1.BWPKHDED | Rely On |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_W2_LOCAL | Use (select) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_DEDN_LMT_GRP | Use (Insert) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_DEDN_LMT_GRP | Use (select) |
| F_CHECK_DECIMAL_DIGITS | Oracle Package Function | S10B80.BANINST1.PDKDEDN | Rely On |
| F_CHECK_DECIMAL_DIGITS | Oracle Package Function | S10B80.BANINST1.PDKDEDN | Use (select) |
| F_DISPLAYEMPRAMOUNT | Oracle Package Function | S10B80.BANINST1.BWPKDCMN | Rely On |
| PTRBDCA | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRBDCA | SQL Index | S10B80.PAYROLL | Rely On |
| PDRBCOV | SQL Table | S10B80.PAYROLL | Join |
| PDRDEDN | SQL Table | S10B80.PAYROLL | Join |
| PTRBDCL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTV1099 | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVBDTY | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:35:18:000 | 04/02/2008 13:49:09:000 |
Table PTRBDCG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRBDCG_CODE | VARCHAR2(3) | No | * | * | |
| PTRBDCG_BDCA_CODE | VARCHAR2(3) | No | * | * | |
| PTRBDCG_USER_ID | VARCHAR2(30) | No | |||
| PTRBDCG_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRBDCG_CODE | PTRBDCA_CODE | PTRBDCA |
| PTRBDCG_BDCA_CODE | PTRBDCA_CODE | PTRBDCA |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRBDCG | Unique | PTRBDCG_CODE |
| PK_PTRBDCG | Unique | PTRBDCG_BDCA_CODE |
| PTRBDCG_BDCA_CODE_INDEX | PTRBDCG_BDCA_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRBDED | SQL Table | S10B80.PAYROLL | Join |
| P_VERIFYCOREBDCAEMP | Oracle Package Procedure | S10B80.BANINST1.PDKLIBS | Rely On |
| P_VERIFYCOREBDCAEMP | Oracle Package Procedure | S10B80.BANINST1.PDKLIBS | Use (select) |
| F_COREDEDNIND | Oracle Package Function | S10B80.BANINST1.PDKLIBS | Use (select) |
| F_VERIFYCOREBDCABCAT | Oracle Package Function | S10B80.BANINST1.PDKLIBS | Use (select) |
| PTRBDCG | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRBDCG | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDCG_BDCA_CODE_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:35:22:000 | 04/02/2008 13:49:09:000 |
Table PTRBDGM| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRBDGM_BDCA_CODE | VARCHAR2(3) | No | * | * | |
| PTRBDGM_BDPG_CODE | VARCHAR2(2) | No | * | ||
| PTRBDGM_BDSG_CODE | VARCHAR2(4) | No | * | ||
| PTRBDGM_WEB_SEL_IND | VARCHAR2(1) | No | |||
| PTRBDGM_WEB_INS_IND | VARCHAR2(1) | No | |||
| PTRBDGM_WEB_UPD_IND | VARCHAR2(1) | No | |||
| PTRBDGM_WEB_DEL_IND | VARCHAR2(1) | No | |||
| PTRBDGM_WEB_EMPR_IND | VARCHAR2(1) | No | |||
| PTRBDGM_WEB_CVG_SEL_IND | VARCHAR2(1) | No | |||
| PTRBDGM_WEB_CVG_INS_IND | VARCHAR2(1) | No | |||
| PTRBDGM_WEB_CVG_UPD_IND | VARCHAR2(1) | No | |||
| PTRBDGM_WEB_CVG_DEL_IND | VARCHAR2(1) | No | |||
| PTRBDGM_WEB_OPEN_IND | VARCHAR2(1) | No | |||
| PTRBDGM_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRBDGM_BDSG_CODE | PTRBDSG_CODE | PTRBDSG |
| PTRBDGM_BDPG_CODE | PTRBDSG_BDPG_CODE | PTRBDSG |
| PTRBDGM_BDCA_CODE | PTRBDCA_CODE | PTRBDCA |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRBDGM | Unique | PTRBDGM_BDCA_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRBDED | SQL Table | S10B80.PAYROLL | Join |
| PHRDEDN | SQL Table | S10B80.PAYROLL | Join |
| PAY_DEDN_TYPE | Oracle Package Type | S10B80.BANINST1.BWPKHSTB | Rely On |
| GETSECGRPC | Oracle Package Cursor | S10B80.BANINST1.BWPKEBST | Use (select) |
| GET_DEDN_SUMC | Oracle Package Cursor | S10B80.BANINST1.BWPKHSTB | Use (select) |
| PDRBDEDC | Oracle Package Cursor | S10B80.BANINST1.BWPKDBCV | Use (select) |
| PDRBDEDCOVERAGESC | Oracle Package Cursor | S10B80.BANINST1.BWPKDBCV | Use (select) |
| P_BENEFITS | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Rely On |
| P_BENEFITS | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Use (select) |
| GET_PAY_DEDNC | Oracle Package Cursor | S10B80.BANINST1.BWPKHSTB | Use (select) |
| P_DISPDEDNYTDDRIVER | Oracle Package Procedure | S10B80.BANINST1.BWPKDQRY | Use (select) |
| F_GETDEDNGROUP | Oracle Package Function | S10B80.BANINST1.PDKLIBS | Use (select) |
| F_ISDEDNFUNCALLOWED | Oracle Package Function | S10B80.BANINST1.BWPKDCMN | Use (select) |
| PTRBDGM | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRBDGM | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Join |
| PTRBDSG | SQL Table | S10B80.PAYROLL | Refer (delete,cascade) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:35:31:000 | 04/02/2008 13:49:09:000 |
Table PTRBDLD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRBDLD_CODE | VARCHAR2(3) | No | * | ||
| PTRBDLD_ECLS_CODE | VARCHAR2(2) | No | |||
| PTRBDLD_COAS_CODE | VARCHAR2(1) | Yes | |||
| PTRBDLD_ACCI_CODE_EMP_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_FUND_CODE_EMP_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_ORGN_CODE_EMP_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_ACCT_CODE_EMP_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_PROG_CODE_EMP_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_ACTV_CODE_EMP_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_LOCN_CODE_EMP_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_ACCI_CODE_EMR_EXP | VARCHAR2(6) | Yes | |||
| PTRBDLD_FUND_CODE_EMR_EXP | VARCHAR2(6) | Yes | |||
| PTRBDLD_ORGN_CODE_EMR_EXP | VARCHAR2(6) | Yes | |||
| PTRBDLD_ACCT_CODE_EMR_EXP | VARCHAR2(6) | Yes | |||
| PTRBDLD_PROG_CODE_EMR_EXP | VARCHAR2(6) | Yes | |||
| PTRBDLD_ACTV_CODE_EMR_EXP | VARCHAR2(6) | Yes | |||
| PTRBDLD_LOCN_CODE_EMR_EXP | VARCHAR2(6) | Yes | |||
| PTRBDLD_ACCI_CODE_EMR_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_FUND_CODE_EMR_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_ORGN_CODE_EMR_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_ACCT_CODE_EMR_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_PROG_CODE_EMR_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_ACTV_CODE_EMR_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_LOCN_CODE_EMR_LIB | VARCHAR2(6) | Yes | |||
| PTRBDLD_EMP_LIB_EXTERNAL | VARCHAR2(60) | Yes | |||
| PTRBDLD_EMR_EXP_EXTERNAL | VARCHAR2(60) | Yes | |||
| PTRBDLD_EMR_LIB_EXTERNAL | VARCHAR2(60) | Yes | |||
| PTRBDLD_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRBDLD_CODE | PTRBDCA_CODE | PTRBDCA |
| Index Name | Index Type | Column Name |
|---|---|---|
| PTRBDLD_KEY_INDEX | Unique | PTRBDLD_CODE |
| PTRBDLD_KEY_INDEX | Unique | PTRBDLD_COAS_CODE |
| PTRBDLD_KEY_INDEX | Unique | PTRBDLD_ECLS_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRBDLD_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:35:50:000 | 04/02/2008 13:49:10:000 |
Table PTRBDMC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRBDMC_BCAT_CODE | VARCHAR2(2) | No | * | ||
| PTRBDMC_BDCA_CODE | VARCHAR2(3) | No | * | ||
| PTRBDMC_EFFECTIVE_DATE | DATE | No | |||
| PTRBDMC_ACTION | VARCHAR2(1) | No | |||
| PTRBDMC_SELECT_STATUS | VARCHAR2(1) | No | |||
| PTRBDMC_CHANGE_STATUS | VARCHAR2(1) | No | |||
| PTRBDMC_ACTIVITY_DATE | DATE | No | |||
| PTRBDMC_USER_ID | VARCHAR2(30) | No | |||
| PTRBDMC_REPL_BDCA_CODE | VARCHAR2(3) | Yes | |||
| PTRBDMC_REF_NO | VARCHAR2(10) | Yes | |||
| PTRBDMC_AMOUNT1 | NUMBER(11,2) | Yes | |||
| PTRBDMC_AMOUNT2 | NUMBER(11,2) | Yes | |||
| PTRBDMC_AMOUNT3 | NUMBER(11,2) | Yes | |||
| PTRBDMC_AMOUNT4 | NUMBER(11,2) | Yes | |||
| PTRBDMC_OPT_CODE1 | VARCHAR2(2) | Yes | |||
| PTRBDMC_OPT_CODE2 | VARCHAR2(2) | Yes | |||
| PTRBDMC_OPT_CODE3 | VARCHAR2(2) | Yes | |||
| PTRBDMC_OPT_CODE4 | VARCHAR2(2) | Yes | |||
| PTRBDMC_OPT_CODE5 | VARCHAR2(2) | Yes | |||
| PTRBDMC_BDCL_CODE | VARCHAR2(8) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRBDMC_BDCL_CODE | PTRBDCL_CODE | PTRBDCL |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRBDMC | Unique | PTRBDMC_BCAT_CODE |
| PK_PTRBDMC | Unique | PTRBDMC_BDCA_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| P_DELETE | Oracle Package Procedure | S10B80.BANINST1.PB_DEDN_COMB_LMT | Use (select) |
| PTRBDMC | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRBDMC | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDCL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:35:59:000 | 04/02/2008 13:49:10:000 |
Table PTRBDPD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRBDPD_CODE | VARCHAR2(3) | No | * | ||
| PTRBDPD_BDCA_CODE | VARCHAR2(3) | No | * | * | |
| PTRBDPD_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRBDPD_BDCA_CODE | PTRBDCA_CODE | PTRBDCA |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRBDPD | Unique | PTRBDPD_CODE |
| PK_PTRBDPD | Unique | PTRBDPD_BDCA_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDRBDED | SQL Table | S10B80.PAYROLL | Join |
| PDRDEDN | SQL Table | S10B80.PAYROLL | Join |
| DHISPRECLUDESC | Oracle Package Cursor | S10B80.BANINST1.BWPKDOEN | Use (select) |
| DHISPRECLUDESC | Oracle Package Cursor | S10B80.BANINST1.BWPKDOFN | Use (select) |
| P_OPENENROLLMENTGRPSHOW | Oracle Package Procedure | S10B80.BANINST1.BWPKDOEN | Rely On |
| P_OPENENROLLMENTGRPSHOW | Oracle Package Procedure | S10B80.BANINST1.BWPKDOEN | Use (select) |
| DEDNPRECLUDESC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select) |
| P_CHECK_PRECLUSION | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Use (select) |
| PTRBDPD | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRBDPD | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:36:07:000 | 04/02/2008 13:49:10:000 |
Table PTRBDPG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRBDPG_CODE | VARCHAR2(2) | No | * | * | |
| PTRBDPG_WEB_SEL_IND | VARCHAR2(1) | No | |||
| PTRBDPG_WEB_INS_IND | VARCHAR2(1) | No | |||
| PTRBDPG_WEB_UPD_IND | VARCHAR2(1) | No | |||
| PTRBDPG_WEB_DEL_IND | VARCHAR2(1) | No | |||
| PTRBDPG_WEB_EMPR_IND | VARCHAR2(1) | No | |||
| PTRBDPG_WEB_CVG_SEL_IND | VARCHAR2(1) | No | |||
| PTRBDPG_WEB_CVG_INS_IND | VARCHAR2(1) | No | |||
| PTRBDPG_WEB_CVG_UPD_IND | VARCHAR2(1) | No | |||
| PTRBDPG_WEB_CVG_DEL_IND | VARCHAR2(1) | No | |||
| PTRBDPG_WEB_OPEN_IND | VARCHAR2(1) | No | |||
| PTRBDPG_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRBDPG_CODE | PTVBDPG_CODE | PTVBDPG |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRBDPG | Unique | PTRBDPG_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRBDSG | SQL Table | S10B80.PAYROLL | Refer (delete,cascade) |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRBDPG | SQL Index | S10B80.PAYROLL | Rely On |
| PTVBDPG | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:36:08:000 | 04/02/2008 13:49:10:000 |
Table PTRBDPL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRBDPL_BDCA_CODE | VARCHAR2(3) | No | * | ||
| PTRBDPL_CODE | VARCHAR2(2) | Yes | |||
| PTRBDPL_DESC | VARCHAR2(30) | Yes | |||
| PTRBDPL_AMT1 | NUMBER(13,4) | Yes | |||
| PTRBDPL_AMT2 | NUMBER(13,4) | Yes | |||
| PTRBDPL_AMT3 | NUMBER(11,2) | Yes | |||
| PTRBDPL_AMT4 | NUMBER(11,2) | Yes | |||
| PTRBDPL_ACTIVITY_DATE | DATE | No | |||
| PTRBDPL_EFFECTIVE_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRBDPL_BDCA_CODE | PTRBDCA_CODE | PTRBDCA |
| PTRBDPL_BDCA_CODE | PDRDEDN_BDCA_CODE | PDRDEDN |
| PTRBDPL_BDCA_CODE | PDRBDED_BDCA_CODE | PDRBDED |
| Index Name | Index Type | Column Name |
|---|---|---|
| PTRBDPL_KEY_INDEX | Unique | PTRBDPL_BDCA_CODE |
| PTRBDPL_KEY_INDEX | Unique | PTRBDPL_CODE |
| PTRBDPL_KEY_INDEX | Unique | PTRBDPL_EFFECTIVE_DATE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PDVDAMT | SQL View | S10B80.BANINST1 | Use (select) |
| PDVDEDD | SQL View | S10B80.BANINST1 | Use (select) |
| PDVDEDN | SQL View | S10B80.BANINST1 | Use (select) |
| F_PTRBDPL_ROWID | SQL Function | S10B80.BANINST1 | Use (select) |
| PTRBDPL_REC | Oracle Package Variable | S10B80.BANINST1.PDKLIBS | Rely On |
| P_BENEFITS | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Rely On |
| P_BENEFITS | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Use (select)Rely On |
| F_GETPLANDESC | Oracle Package Function | S10B80.BANINST1.BWPKEBST | Rely On |
| F_GETPLANDESC | Oracle Package Function | S10B80.BANINST1.BWPKEBST | Use (select) |
| PTRBDPLBYDESCC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select)Rely On |
| PTRBDPLBYRANGEC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select)Rely On |
| PTRBDPLVIEWC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select)Rely On |
| P_EDIT_BDPL | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (select) |
| P_EDIT_OPT_CODE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Use (select) |
| F_CHECK_DECIMAL_DIGITS | Oracle Package Function | S10B80.BANINST1.PDKDEDN | Rely On |
| PTRBDPL | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRBDPL_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PDRBDED | SQL Table | S10B80.PAYROLL | Join |
| PDRDEDN | SQL Table | S10B80.PAYROLL | Join |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:36:09:000 | 04/02/2008 13:49:10:000 |
Table PTRBDSG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRBDSG_CODE | VARCHAR2(4) | No | * | ||
| PTRBDSG_DESC | VARCHAR2(30) | No | |||
| PTRBDSG_WEB_SEL_IND | VARCHAR2(1) | No | |||
| PTRBDSG_WEB_INS_IND | VARCHAR2(1) | No | |||
| PTRBDSG_BDPG_CODE | VARCHAR2(2) | No | * | * | |
| PTRBDSG_WEB_UPD_IND | VARCHAR2(1) | No | |||
| PTRBDSG_WEB_DEL_IND | VARCHAR2(1) | No | |||
| PTRBDSG_WEB_EMPR_IND | VARCHAR2(1) | No | |||
| PTRBDSG_WEB_CVG_SEL_IND | VARCHAR2(1) | No | |||
| PTRBDSG_WEB_CVG_INS_IND | VARCHAR2(1) | No | |||
| PTRBDSG_WEB_CVG_UPD_IND | VARCHAR2(1) | No | |||
| PTRBDSG_WEB_CVG_DEL_IND | VARCHAR2(1) | No | |||
| PTRBDSG_WEB_OPEN_IND | VARCHAR2(1) | No | |||
| PTRBDSG_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRBDSG_BDPG_CODE | PTRBDPG_CODE | PTRBDPG |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRBDSG | Unique | PTRBDSG_CODE |
| PK_PTRBDSG | Unique | PTRBDSG_BDPG_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRBDGM | SQL Table | S10B80.PAYROLL | Refer (delete,cascade) |
| GETSECGRPC | Oracle Package Cursor | S10B80.BANINST1.BWPKEBST | Use (select) |
| P_PRINTLINKS | Oracle Package Procedure | S10B80.BANINST1.BWPKEBST | Rely On |
| PTRBDSG | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRBDSG | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDPG | SQL Table | S10B80.PAYROLL | Refer (delete,cascade) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:36:17:000 | 04/02/2008 13:49:10:000 |
Table PTRCBEN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRCBEN_CODE | VARCHAR2(3) | No | * | ||
| PTRCBEN_PLAN | VARCHAR2(2) | Yes | |||
| PTRCBEN_GROUP | VARCHAR2(3) | No | |||
| PTRCBEN_NO_COLLEGE_AGE | NUMBER(2,0) | Yes | |||
| PTRCBEN_COLLEGE_AGE | NUMBER(2,0) | Yes | |||
| PTRCBEN_DELAY_IND | VARCHAR2(1) | No | |||
| PTRCBEN_DELAY_MONTHS | NUMBER(2,0) | No | |||
| PTRCBEN_GRACE_DAYS | NUMBER(3,0) | No | |||
| PTRCBEN_BASIC_COST | NUMBER(11,2) | No | |||
| PTRCBEN_ADMIN_COST | NUMBER(11,2) | No | |||
| PTRCBEN_TOTAL_COST | NUMBER(11,2) | No | |||
| PTRCBEN_ADMIN_PERCENT | NUMBER(5,2) | No | |||
| PTRCBEN_RATE_CHANGE_IND | VARCHAR2(1) | Yes | |||
| PTRCBEN_COAS_CODE | VARCHAR2(1) | Yes | |||
| PTRCBEN_ACCI_CODE_CSH | VARCHAR2(6) | Yes | |||
| PTRCBEN_FUND_CODE_CSH | VARCHAR2(6) | Yes | |||
| PTRCBEN_ORGN_CODE_CSH | VARCHAR2(6) | Yes | |||
| PTRCBEN_ACCT_CODE_CSH | VARCHAR2(6) | Yes | |||
| PTRCBEN_PROG_CODE_CSH | VARCHAR2(6) | Yes | |||
| PTRCBEN_ACTV_CODE_CSH | VARCHAR2(6) | Yes | |||
| PTRCBEN_LOCN_CODE_CSH | VARCHAR2(6) | Yes | |||
| PTRCBEN_ACCT_CODE_EXTERNAL_CSH | VARCHAR2(60) | Yes | |||
| PTRCBEN_ACCI_CODE_BEN | VARCHAR2(6) | Yes | |||
| PTRCBEN_FUND_CODE_BEN | VARCHAR2(6) | Yes | |||
| PTRCBEN_ORGN_CODE_BEN | VARCHAR2(6) | Yes | |||
| PTRCBEN_ACCT_CODE_BEN | VARCHAR2(6) | Yes | |||
| PTRCBEN_PROG_CODE_BEN | VARCHAR2(6) | Yes | |||
| PTRCBEN_ACTV_CODE_BEN | VARCHAR2(6) | Yes | |||
| PTRCBEN_LOCN_CODE_BEN | VARCHAR2(6) | Yes | |||
| PTRCBEN_ACCT_CODE_EXTERNAL_BEN | VARCHAR2(60) | Yes | |||
| PTRCBEN_ACCI_CODE_ADM | VARCHAR2(6) | Yes | |||
| PTRCBEN_FUND_CODE_ADM | VARCHAR2(6) | Yes | |||
| PTRCBEN_ORGN_CODE_ADM | VARCHAR2(6) | Yes | |||
| PTRCBEN_ACCT_CODE_ADM | VARCHAR2(6) | Yes | |||
| PTRCBEN_PROG_CODE_ADM | VARCHAR2(6) | Yes | |||
| PTRCBEN_ACTV_CODE_ADM | VARCHAR2(6) | Yes | |||
| PTRCBEN_LOCN_CODE_ADM | VARCHAR2(6) | Yes | |||
| PTRCBEN_ACCT_CODE_EXTERNAL_ADM | VARCHAR2(60) | Yes | |||
| PTRCBEN_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRCBEN_CODE | PTRBDCA_CODE | PTRBDCA |
| Index Name | Index Type | Column Name |
|---|---|---|
| PTRCBEN_KEY_INDEX | Unique | PTRCBEN_CODE |
| PTRCBEN_KEY_INDEX | Unique | PTRCBEN_PLAN |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRCBEN_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:37:10:000 | 04/02/2008 13:49:11:000 |
Table PTRECBC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRECBC_CODE | VARCHAR2(2) | No | * | * | |
| PTRECBC_BCAT_CODE | VARCHAR2(2) | No | * | * | |
| PTRECBC_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRECBC_BCAT_CODE | PTRBCAT_CODE | PTRBCAT |
| PTRECBC_CODE | PTRECLS_CODE | PTRECLS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRECBC | Unique | PTRECBC_CODE |
| PK_PTRECBC | Unique | PTRECBC_BCAT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRECBC_RECTYPE | Oracle Package Type | S10B80.BANINST1.POKRECS | Rely On |
| P_EDIT_PEBEMPL_BCAT_CODE | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (select) |
| F_PTRECBC_REC | Oracle Package Function | S10B80.BANINST1.POKRECS | Use (select) |
| PTRECBC | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRECBC | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBCAT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRECLS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:35:45:000 | 04/02/2008 13:49:10:000 |
Table PTRECLS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRECLS_CODE | VARCHAR2(2) | No | * | * | |
| PTRECLS_SHORT_DESC | VARCHAR2(8) | No | |||
| PTRECLS_LONG_DESC | VARCHAR2(30) | No | |||
| PTRECLS_PICT_CODE | VARCHAR2(2) | No | |||
| PTRECLS_SHCD_CODE | VARCHAR2(4) | Yes | |||
| PTRECLS_HOURS_PER_PAY | NUMBER(6,2) | No | |||
| PTRECLS_HOURS_PER_DAY | NUMBER(6,2) | No | |||
| PTRECLS_SALARY_ENCUMBRANCE_IND | VARCHAR2(1) | No | |||
| PTRECLS_TS_ROSTER_IND | VARCHAR2(1) | No | |||
| PTRECLS_DEFAULT_HOURS_IND | VARCHAR2(1) | No | |||
| PTRECLS_SALARY_IND | VARCHAR2(1) | No | |||
| PTRECLS_BUDGET_ROLL_IND | VARCHAR2(1) | No | |||
| PTRECLS_LCAT_CODE | VARCHAR2(2) | No | * | ||
| PTRECLS_BCAT_CODE | VARCHAR2(2) | No | |||
| PTRECLS_ACTIVITY_DATE | DATE | No | |||
| PTRECLS_EEOG_CODE | VARCHAR2(2) | Yes | |||
| PTRECLS_EMPR_CODE | VARCHAR2(4) | No | * | ||
| PTRECLS_INSTRUCT_CODE | VARCHAR2(1) | Yes | |||
| PTRECLS_STCA_CODE | VARCHAR2(2) | Yes | * | ||
| PTRECLS_STGR_CODE | VARCHAR2(2) | Yes | * | ||
| PTRECLS_WKPR_CODE | VARCHAR2(4) | Yes | |||
| PTRECLS_LGCD_CODE | VARCHAR2(4) | Yes | * | ||
| PTRECLS_FLSA_IND | VARCHAR2(1) | No | |||
| PTRECLS_WKSH_CODE | VARCHAR2(4) | Yes | * | ||
| PTRECLS_TIME_ENTRY_IND | VARCHAR2(1) | No | |||
| PTRECLS_TIME_ENTRY_DAY | VARCHAR2(3) | Yes | |||
| PTRECLS_DFPR_CODE | VARCHAR2(4) | Yes | |||
| PTRECLS_PCAT_CODE | VARCHAR2(4) | Yes | * | ||
| PTRECLS_PREMIUM_ROLL_IND | VARCHAR2(1) | Yes | |||
| PTRECLS_INTERNAL_FT_PT_IND | VARCHAR2(1) | No | |||
| PTRECLS_EGRP_CODE | VARCHAR2(4) | Yes | * | ||
| PTRECLS_STRS_ASSN_CODE | VARCHAR2(2) | Yes | |||
| PTRECLS_STRS_PAY_CODE | VARCHAR2(2) | Yes | |||
| PTRECLS_PERS_GROUP | VARCHAR2(5) | Yes | |||
| PTRECLS_PERS_PAY_CODE | VARCHAR2(2) | Yes | |||
| PTRECLS_TIME_ENTRY_METHOD | VARCHAR2(1) | No | |||
| PTRECLS_TIME_ENTRY_TYPE | VARCHAR2(1) | No | |||
| PTRECLS_LEAVE_REQUEST_IND | VARCHAR2(1) | No | |||
| PTRECLS_EXCEPTION_APPROVAL_IND | VARCHAR2(1) | No | |||
| PTRECLS_TIME_IN_OUT_IND | VARCHAR2(1) | No | |||
| PTRECLS_OVERRIDE_LD_WEB_IND | VARCHAR2(1) | No | |||
| PTRECLS_OVERRIDE_LD_DEPT_IND | VARCHAR2(1) | No | |||
| PTRECLS_BUDG_BASIS | NUMBER(6,2) | No | |||
| PTRECLS_ANN_BASIS | NUMBER(6,2) | No | |||
| PTRECLS_CREATE_JFTE_IND | VARCHAR2(1) | No | |||
| PTRECLS_LEAV_REPT_METHOD | VARCHAR2(1) | No | |||
| PTRECLS_PICT_CODE_LEAV_REPT | VARCHAR2(2) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRECLS_WKSH_CODE | NTVWKSH_CODE | NTVWKSH |
| PTRECLS_EGRP_CODE | PTVEGRP_CODE | PTVEGRP |
| PTRECLS_LCAT_CODE | PTVLCAT_CODE | PTVLCAT |
| PTRECLS_STCA_CODE | PTVSTCA_CODE | PTVSTCA |
| PTRECLS_STGR_CODE | PTVSTGR_CODE | PTVSTGR |
| PTRECLS_LGCD_CODE | PTVLGCD_CODE | PTVLGCD |
| PTRECLS_EMPR_CODE | PTREMPR_CODE | PTREMPR |
| PTRECLS_PCAT_CODE | PTVPCAT_CODE | PTVPCAT |
| PTRECLS_CODE | NBRJOBS_ECLS_CODE | NBRJOBS |
| PTRECLS_CODE | NBBPOSN_ECLS_CODE | NBBPOSN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRECLS | Unique | PTRECLS_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| NTRFRNG | SQL Table | S10B80.POSNCTL | Refer (no action) |
| NTRPCLS | SQL Table | S10B80.POSNCTL | Refer (no action) |
| PEBEMPL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PEREHIS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PERFJOB | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PERJHIS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PHRJOBS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRECBC | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRECEC | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRECLC | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRECLD | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTREERN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTREHOL | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRRERN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRSERN | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTRSTDE | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PAVAPPL | SQL View | S10B80.BANINST1 | Use (select) |
| PAVREQ1 | SQL View | S10B80.BANINST1 | Use (select) |
| PEVELEV | SQL View | S10B80.BANINST1 | Use (select) |
| PEVEMPL | SQL View | S10B80.BANINST1 | Use (select) |
| PEVJOBS | SQL View | S10B80.BANINST1 | Use (select) |
| PEVREC1 | SQL View | S10B80.BANINST1 | Use (select) |
| POVDATA | SQL View | S10B80.BANINST1 | Use (select) |
| F_CONCAT_EMPL_DATA | SQL Function | S10B80.BANINST1 | Use (select) |
| F_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
| PTRECLS_RECTYPE | Oracle Package Type | S10B80.BANINST1.POKRECS | Rely On |
| LEAVE_REQUEST_JOB_C | Oracle Package Cursor | S10B80.BANINST1.BWPKTEIS | Use (select) |
| LEAVE_REQUEST_TIME_ENTRY_C | Oracle Package Cursor | S10B80.BANINST1.BWPKTEIS | Use (select) |
| JOBS_CURSOR | Oracle Package Cursor | S10B80.BANINST1.PEKTEEX | Use (select) |
| ECLS_EXISTS | Oracle Package Procedure | S10B80.BANINST1.POKPVAL | Use (select) |
| P_DISP_EARN_CODES | Oracle Package Procedure | S10B80.BANINST1.BWPKFJDT | Rely On |
| P_DISP_EARN_CODES | Oracle Package Procedure | S10B80.BANINST1.BWPKEPDT | Rely On |
| P_GETBASICEMPDATA | Oracle Package Procedure | S10B80.BANINST1.PEKWEMP | Use (select) |
| P_GETEMPDATA | Oracle Package Procedure | S10B80.BANINST1.PEKDEGR | Use (select) |
| P_GET_PAY_DATES | Oracle Package Procedure | S10B80.BANINST1.PEKFASG | Use (select) |
| F_DT_USES_ECLS_VAL | Oracle Package Function | S10B80.BANINST1.EOK496R | Rely On |
| GET_PAY_EARNC | Oracle Package Cursor | S10B80.BANINST1.BWPKHSTB | Use (select) |
| PTRECLSC | Oracle Package Cursor | S10B80.BANINST1.NOKPLIB | Use (select) |
| P_BUILDPATRECR | Oracle Package Procedure | S10B80.BANINST1.PAKRECR | Use (select) |
| P_CALC_SAL_ENCUMBRANCE | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (select) |
| P_DISP_JOB_DETL_BODY | Oracle Package Procedure | S10B80.BANINST1.BWPKFJDT | Rely On |
| P_DISP_JOB_DETL_BODY | Oracle Package Procedure | S10B80.BANINST1.BWPKFJDT | Use (select) |
| P_EDIT_ECLS | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (select) |
| P_EDIT_ECLS_NAME_ONLY | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Use (select) |
| P_EDIT_ECLS_ONLY | Oracle Package Procedure | S10B80.BANINST1.NOKPLIB | Rely On |
| P_EDIT_IPEDS_REPORTABLE | Oracle Package Procedure | S10B80.BANINST1.NOKP3LB | Use (select) |
| P_GET_EMPL_INFO | Oracle Package Procedure | S10B80.BANINST1.POKWLIB | Use (select) |
| P_INCLUDE_ALL_ECLS | Oracle Package Procedure | S10B80.BANINST1.NOKP3LB | Use (select) |
| P_PTRECLS_ADR | Oracle Package Procedure | S10B80.BANINST1.EOK496R | Rely On |
| P_PTRECLS_AIR | Oracle Package Procedure | S10B80.BANINST1.EOK496R | Rely On |
| P_PTRECLS_AUR | Oracle Package Procedure | S10B80.BANINST1.EOK496R | Rely On |
| P_UPDATE_JOBDETAIL | Oracle Package Procedure | S10B80.BANINST1.BWPKFJDT | Rely On |
| P_UPDATE_JOBDETAIL | Oracle Package Procedure | S10B80.BANINST1.BWPKFJDT | Use (select) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_EFFCERT_ECLS | Use (Insert,select) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_EFFCERT_PCLS | Use (Insert,select) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_FAC_JOBDETAIL | Use (Insert,select) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_FAC_CRSASSIGN | Use (Insert,select) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_CARDHOLDER | Use (Insert,select) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_NB_JOB_LABOR | Use (Insert,select) |
| F_PTRECBC_REC | Oracle Package Function | S10B80.BANINST1.POKRECS | Rely On |
| F_PTRECLS_REC | Oracle Package Function | S10B80.BANINST1.POKRECS | Rely On |
| PTRECLS | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRECLS | SQL Index | S10B80.PAYROLL | Rely On |
| NBBPOSN | SQL Table | S10B80.POSNCTL | Join |
| NBRJOBS | SQL Table | S10B80.POSNCTL | Join |
| NTVWKSH | SQL Table | S10B80.POSNCTL | Refer (no action) |
| PTREMPR | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVEGRP | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVLCAT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVLGCD | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVPCAT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVSTCA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PTVSTGR | SQL Table | S10B80.PAYROLL | Refer (no action) |
| ET_PTRECLS_ADR_EXTSOL_496 | SQL Trigger | S10B80.BANIMGR | Fire (delete,after,each row) |
| ET_PTRECLS_AIR_EXTSOL_496 | SQL Trigger | S10B80.BANIMGR | Fire (Insert,after,each row) |
| ET_PTRECLS_AUR_EXTSOL_496 | SQL Trigger | S10B80.BANIMGR | Fire (update,after,each row) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:36:20:000 | 04/02/2008 13:49:10:000 |
Table PTRFBEN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRFBEN_BDCA_CODE | VARCHAR2(3) | No | * | ||
| PTRFBEN_PLAN_CODE | VARCHAR2(2) | Yes | |||
| PTRFBEN_FSA_IND | VARCHAR2(1) | No | |||
| PTRFBEN_AVAIL_IND | VARCHAR2(1) | No | |||
| PTRFBEN_FLEX_AMT | NUMBER(11,2) | Yes | |||
| PTRFBEN_EMPL_AMT | NUMBER(11,2) | Yes | |||
| PTRFBEN_PREM_AMT | NUMBER(11,2) | Yes | |||
| PTRFBEN_DEDN_FREQ | NUMBER(2,0) | No | |||
| PTRFBEN_ACTIVITY_DATE | DATE | No | |||
| PTRFBEN_FSA_GRACE_PERIOD_IND | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRFBEN_BDCA_CODE | PTRBDCA_CODE | PTRBDCA |
| PTRFBEN_BDCA_CODE | PDRDEDN_BDCA_CODE | PDRDEDN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PTRFBEN_KEY2_INDEX | PTRFBEN_FSA_IND | |
| PTRFBEN_KEY_INDEX | Unique | PTRFBEN_BDCA_CODE |
| PTRFBEN_KEY_INDEX | Unique | PTRFBEN_PLAN_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRFBEN_REC | Oracle Package Variable | S10B80.BANINST1.PDKLIBS | Rely On |
| GLOBAL_RECTYPE | Oracle Package Type | S10B80.BANINST1.PDKDEDN | Rely On |
| FLXSAMOUNTSC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select) |
| PTRFBENFSAC | Oracle Package Cursor | S10B80.BANINST1.PDKLIBS | Use (select)Rely On |
| P_EDIT_BDCA_CODE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Rely On |
| P_EDIT_BDCA_CODE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Use (select) |
| PTRFBEN | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRFBEN_KEY2_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PTRFBEN_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PDRDEDN | SQL Table | S10B80.PAYROLL | Join |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:38:15:000 | 04/02/2008 13:49:12:000 |
Table PTRLIFE| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRLIFE_BDCA_CODE | VARCHAR2(3) | No | * | ||
| PTRLIFE_BDPL_CODE | VARCHAR2(2) | Yes | |||
| PTRLIFE_INS_SALARY_DATE | DATE | No | |||
| PTRLIFE_AGE_DATE | DATE | No | |||
| PTRLIFE_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRLIFE_BDCA_CODE | PTRBDCA_CODE | PTRBDCA |
| Index Name | Index Type | Column Name |
|---|---|---|
| PTRLIFE_KEY_INDEX | Unique | PTRLIFE_BDCA_CODE |
| PTRLIFE_KEY_INDEX | Unique | PTRLIFE_BDPL_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRLIFE_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:40:28:000 | 04/02/2008 13:49:15:000 |
Table PTRPICT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRPICT_CODE | VARCHAR2(2) | No | * | * | |
| PTRPICT_DESC | VARCHAR2(30) | No | |||
| PTRPICT_PAYS_PER_YEAR | NUMBER(3,1) | No | |||
| PTRPICT_TAX_FACTOR | NUMBER(3,0) | No | |||
| PTRPICT_SUPP_PAY_IND | VARCHAR2(1) | No | |||
| PTRPICT_CODE_ORIG | VARCHAR2(2) | Yes | |||
| PTRPICT_ACTIVITY_DATE | DATE | No | |||
| PTRPICT_ROE_PERIOD_TYPE | VARCHAR2(30) | Yes | |||
| PTRPICT_UI_MIN_HOURS | NUMBER(6,2) | Yes | |||
| PTRPICT_UI_MIN_EARNINGS | NUMBER(11,2) | Yes | |||
| PTRPICT_UI_MAX_EARNINGS | NUMBER(11,2) | Yes | |||
| PTRPICT_UI_WEEKS | NUMBER(5,3) | Yes | |||
| PTRPICT_BANK_CODE | VARCHAR2(2) | Yes | |||
| PTRPICT_TS_CUTOFF_DAYS | NUMBER(3,0) | Yes | |||
| PTRPICT_TS_CUTOFF_TIME | VARCHAR2(4) | Yes | |||
| PTRPICT_TS_PRIOR_AFTER_IND | VARCHAR2(1) | Yes | |||
| PTRPICT_TS_WEB_VIEW_MONTHS | NUMBER(3,0) | Yes | |||
| PTRPICT_TS_LEAVE_REQUESTS | NUMBER(3,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PTRPICT_CODE | NBRJOBS_PICT_CODE | NBRJOBS |
| PTRPICT_CODE | PTRCALN_PICT_CODE | PTRCALN |
| PTRPICT_CODE | PHRHIST_PICT_CODE | PHRHIST |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRPICT | Unique | PTRPICT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRPICT | SQL Index | S10B80.PAYROLL | Rely On |
| NBRJOBS | SQL Table | S10B80.POSNCTL | Join |
| PHRHIST | SQL Table | S10B80.PAYROLL | Join |
| PTRCALN | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:36:43:000 | 04/02/2008 13:49:11:000 |
Table PTVBDPG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTVBDPG_CODE | VARCHAR2(2) | No | * | ||
| PTVBDPG_DESC | VARCHAR2(30) | No | |||
| PTVBDPG_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTVBDPG | Unique | PTVBDPG_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRBDPG | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTVBDPG | SQL Index | S10B80.PAYROLL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:37:28:000 | 04/02/2008 13:49:11:000 |
Table PTVBDTY| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTVBDTY_CODE | VARCHAR2(2) | No | * | ||
| PTVBDTY_DESC | VARCHAR2(60) | Yes | |||
| PTVBDTY_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTVBDTY | Unique | PTVBDTY_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PTRBDCA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXREXEM | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PDVDEDD | SQL View | S10B80.BANINST1 | Use (select) |
| F_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
| PTVBDTY | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTVBDTY | SQL Index | S10B80.PAYROLL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:37:36:000 | 04/02/2008 13:49:12:000 |
Table PXRADDS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PXRADDS_TXCD_CODE | VARCHAR2(8) | No | * | ||
| PXRADDS_FSTA_CODE | VARCHAR2(2) | Yes | |||
| PXRADDS_SEQ_NO | NUMBER(2,0) | No | |||
| PXRADDS_OPT_CODE | VARCHAR2(1) | Yes | |||
| PXRADDS_MULT_OR_ADD | VARCHAR2(1) | Yes | |||
| PXRADDS_EXEMP_MULT | NUMBER(11,2) | Yes | |||
| PXRADDS_USER_ID | VARCHAR2(30) | No | |||
| PXRADDS_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PXRADDS_TXCD_CODE | PXRTXCD_CODE | PXRTXCD |
| Index Name | Index Type | Column Name |
|---|---|---|
| PXRADDS_KEY_INDEX | Unique | PXRADDS_TXCD_CODE |
| PXRADDS_KEY_INDEX | Unique | PXRADDS_FSTA_CODE |
| PXRADDS_KEY_INDEX | Unique | PXRADDS_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PXRADDS_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PXRTXCD | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:35:48:000 | 04/02/2008 13:49:10:000 |
Table PXRCALC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PXRCALC_TXCD_CODE | VARCHAR2(8) | No | * | ||
| PXRCALC_FSTA_CODE | VARCHAR2(2) | Yes | |||
| PXRCALC_STEP_NO | NUMBER(2,0) | No | |||
| PXRCALC_STEP_DESC | VARCHAR2(30) | Yes | |||
| PXRCALC_OPERATOR | VARCHAR2(1) | Yes | |||
| PXRCALC_OPERAND_IND | VARCHAR2(1) | Yes | |||
| PXRCALC_OPERAND_TYPE | VARCHAR2(2) | Yes | |||
| PXRCALC_AMOUNT | NUMBER(11,4) | Yes | |||
| PXRCALC_RANGE_LOW | NUMBER(11,2) | Yes | |||
| PXRCALC_RANGE_HIGH | NUMBER(11,2) | Yes | |||
| PXRCALC_USER_ID | VARCHAR2(30) | No | |||
| PXRCALC_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PXRCALC_TXCD_CODE | PXRTXCD_CODE | PXRTXCD |
| Index Name | Index Type | Column Name |
|---|---|---|
| PXRCALC_KEY_INDEX | Unique | PXRCALC_TXCD_CODE |
| PXRCALC_KEY_INDEX | Unique | PXRCALC_FSTA_CODE |
| PXRCALC_KEY_INDEX | Unique | PXRCALC_STEP_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PXRCALC_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PXRTXCD | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:39:23:000 | 04/02/2008 13:49:14:000 |
Table PXREXEM| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PXREXEM_TXCD_CODE | VARCHAR2(8) | No | * | ||
| PXREXEM_FSTA_CODE | VARCHAR2(2) | Yes | |||
| PXREXEM_SEQ_NO | NUMBER(2,0) | No | |||
| PXREXEM_PERCENT | NUMBER(7,4) | Yes | |||
| PXREXEM_RANGE_LOW | NUMBER(11,2) | Yes | |||
| PXREXEM_RANGE_HIGH | NUMBER(11,2) | Yes | |||
| PXREXEM_MAX_ANN_TAX | NUMBER(11,2) | Yes | |||
| PXREXEM_WAGE_BASE | NUMBER(11,2) | Yes | |||
| PXREXEM_EMPR_PERCENT | NUMBER(7,4) | Yes | |||
| PXREXEM_OPT_CODE | VARCHAR2(1) | Yes | |||
| PXREXEM_MULT_OR_ADD | VARCHAR2(1) | Yes | |||
| PXREXEM_EXEMP_MULT | NUMBER(11,2) | Yes | |||
| PXREXEM_DEDN_IND | VARCHAR2(1) | Yes | |||
| PXREXEM_DEDN_TYPE | VARCHAR2(1) | Yes | |||
| PXREXEM_DEDN_PERCENT | NUMBER(7,4) | Yes | |||
| PXREXEM_USER_ID | VARCHAR2(30) | No | |||
| PXREXEM_ACTIVITY_DATE | DATE | No | |||
| PXREXEM_BDTY_CODE | VARCHAR2(2) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PXREXEM_BDTY_CODE | PTVBDTY_CODE | PTVBDTY |
| PXREXEM_TXCD_CODE | PXRTXCD_CODE | PXRTXCD |
| Index Name | Index Type | Column Name |
|---|---|---|
| PXREXEM_KEY_INDEX | Unique | PXREXEM_TXCD_CODE |
| PXREXEM_KEY_INDEX | Unique | PXREXEM_FSTA_CODE |
| PXREXEM_KEY_INDEX | Unique | PXREXEM_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PXREXEM_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PTVBDTY | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXRTXCD | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:37:51:000 | 04/02/2008 13:49:12:000 |
Table PXRFSTA| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PXRFSTA_TXCD_CODE | VARCHAR2(8) | No | * | * | |
| PXRFSTA_FIL_STAT | VARCHAR2(2) | No | * | ||
| PXRFSTA_DESC | VARCHAR2(30) | Yes | |||
| PXRFSTA_LOW_INCOME | NUMBER(11,2) | Yes | |||
| PXRFSTA_USER_ID | VARCHAR2(30) | No | |||
| PXRFSTA_ACTIVITY_DATE | DATE | No | |||
| PXRFSTA_MINIMUM_YTD_APPL_GRS | NUMBER(11,2) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PXRFSTA_TXCD_CODE | PXRTXCD_CODE | PXRTXCD |
| PXRFSTA_TXCD_CODE | PTRBDCA_TXCD_CODE | PTRBDCA |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PXRFSTA | Unique | PXRFSTA_TXCD_CODE |
| PK_PXRFSTA | Unique | PXRFSTA_FIL_STAT |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| P_CHOOSETAXOPTCODE | Oracle Package Procedure | S10B80.BANINST1.BWPKXTXS | Use (select) |
| P_EDIT_OPT_CODE | Oracle Package Procedure | S10B80.BANINST1.PDKDEDN | Use (select) |
| F_GETFILINGSTATUSDESC | Oracle Package Function | S10B80.BANINST1.PXKLIBS | Use (select) |
| PXRFSTA | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PXRFSTA | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Join |
| PXRTXCD | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:35:41:000 | 04/02/2008 13:49:09:000 |
Table PXRGRAD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PXRGRAD_TXCD_CODE | VARCHAR2(8) | No | * | ||
| PXRGRAD_FSTA_CODE | VARCHAR2(2) | Yes | |||
| PXRGRAD_OVER | NUMBER(11,2) | No | |||
| PXRGRAD_NOT_OVER | NUMBER(11,2) | No | |||
| PXRGRAD_AMOUNT | NUMBER(11,2) | No | |||
| PXRGRAD_PERCENT | NUMBER(6,3) | No | |||
| PXRGRAD_OVER2 | NUMBER(11,2) | No | |||
| PXRGRAD_USER_ID | VARCHAR2(30) | No | |||
| PXRGRAD_ACTIVITY_DATE | DATE | No | |||
| PXRGRAD_STEP_NO | NUMBER(2,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PXRGRAD_TXCD_CODE | PXRTXCD_CODE | PXRTXCD |
| Index Name | Index Type | Column Name |
|---|---|---|
| PXRGRAD_KEY_INDEX | Unique | PXRGRAD_TXCD_CODE |
| PXRGRAD_KEY_INDEX | Unique | PXRGRAD_FSTA_CODE |
| PXRGRAD_KEY_INDEX | Unique | PXRGRAD_OVER |
| PXRGRAD_KEY_INDEX | Unique | PXRGRAD_STEP_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PXRGRAD_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
| PXRTXCD | SQL Table | S10B80.PAYROLL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:37:34:000 | 04/02/2008 13:49:12:000 |
Table PXRRDED| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PXRRDED_REPT_CODE | VARCHAR2(4) | No | * | * | |
| PXRRDED_RBOX_CODE | VARCHAR2(4) | No | * | * | |
| PXRRDED_BDCA_CODE | VARCHAR2(3) | No | * | * | |
| PXRRDED_AMT_IND | VARCHAR2(1) | No | * | ||
| PXRRDED_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PXRRDED_REPT_CODE | PXRRBOX_REPT_CODE | PXRRBOX |
| PXRRDED_RBOX_CODE | PXRRBOX_CODE | PXRRBOX |
| PXRRDED_REPT_CODE | PTVREPT_CODE | PTVREPT |
| PXRRDED_REPT_CODE | PXRREPT_REPT_CODE | PXRREPT |
| PXRRDED_BDCA_CODE | PTRBDCA_CODE | PTRBDCA |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PXRRDED | Unique | PXRRDED_REPT_CODE |
| PK_PXRRDED | Unique | PXRRDED_RBOX_CODE |
| PK_PXRRDED | Unique | PXRRDED_BDCA_CODE |
| PK_PXRRDED | Unique | PXRRDED_AMT_IND |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PERDTOT | SQL Table | S10B80.PAYROLL | Join |
| PPRCOLR | SQL Table | S10B80.PAYROLL | Join |
| PXVREP2 | SQL View | S10B80.BANINST1 | Use (select) |
| PXVREPT | SQL View | S10B80.BANINST1 | Use (select) |
| PXVRTOT | SQL View | S10B80.BANINST1 | Use (select) |
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2006 | Use (select) |
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2007 | Use (select) |
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2 | Use (select) |
| UT_PB_W2_FEDERALDELETEAPI | Oracle Package Procedure | S10B80.BANINST1.UT_PB_W2_FEDERAL | Use (select) |
| P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.PB_W2_LOCAL_RULES | Use (select) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_W2_LOCAL | Use (select) |
| PXRRDED | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PXRRDED | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Join |
| PTVREPT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXRRBOX | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXRREPT | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:32:15:000 | 04/02/2008 13:49:06:000 |
Table PXRREPT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PXRREPT_REPT_CODE | VARCHAR2(4) | No | * | ||
| PXRREPT_YEAR | VARCHAR2(4) | No | * | ||
| PXRREPT_START_MONTH | NUMBER(2,0) | No | * | ||
| PXRREPT_END_MONTH | NUMBER(2,0) | No | * | ||
| PXRREPT_EMPR_CODE | VARCHAR2(4) | No | * | ||
| PXRREPT_PIDM | NUMBER(8,0) | No | * | ||
| PXRREPT_RBOX_CODE | VARCHAR2(4) | No | * | ||
| PXRREPT_SESSION_ID | VARCHAR2(30) | No | * | ||
| PXRREPT_AMOUNT | NUMBER(11,2) | Yes | |||
| PXRREPT_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PXRREPT | Unique | PXRREPT_REPT_CODE |
| PK_PXRREPT | Unique | PXRREPT_YEAR |
| PK_PXRREPT | Unique | PXRREPT_START_MONTH |
| PK_PXRREPT | Unique | PXRREPT_END_MONTH |
| PK_PXRREPT | Unique | PXRREPT_EMPR_CODE |
| PK_PXRREPT | Unique | PXRREPT_PIDM |
| PK_PXRREPT | Unique | PXRREPT_RBOX_CODE |
| PK_PXRREPT | Unique | PXRREPT_SESSION_ID |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PXRREPT | SQL Index | S10B80.PAYROLL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:33:37:000 | 04/02/2008 13:49:07:000 |
Table PXRRERN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PXRRERN_REPT_CODE | VARCHAR2(4) | No | * | * | |
| PXRRERN_RBOX_CODE | VARCHAR2(4) | No | * | * | |
| PXRRERN_EARN_CODE | VARCHAR2(3) | No | * | ||
| PXRRERN_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PXRRERN_REPT_CODE | PXRRBOX_REPT_CODE | PXRRBOX |
| PXRRERN_RBOX_CODE | PXRRBOX_CODE | PXRRBOX |
| PXRRERN_REPT_CODE | PTVREPT_CODE | PTVREPT |
| PXRRERN_REPT_CODE | PXRREPT_REPT_CODE | PXRREPT |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PXRRERN | Unique | PXRRERN_REPT_CODE |
| PK_PXRRERN | Unique | PXRRERN_RBOX_CODE |
| PK_PXRRERN | Unique | PXRRERN_EARN_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PERJTOT | SQL Table | S10B80.PAYROLL | Join |
| PPRCOLR | SQL Table | S10B80.PAYROLL | Join |
| PXVREP2 | SQL View | S10B80.BANINST1 | Use (select) |
| PXVREPT | SQL View | S10B80.BANINST1 | Use (select) |
| PXVRTOT | SQL View | S10B80.BANINST1 | Use (select) |
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2006 | Use (select) |
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2007 | Use (select) |
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2 | Use (select) |
| PXRRERN | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PXRRERN | SQL Index | S10B80.PAYROLL | Rely On |
| PTVREPT | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXRRBOX | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXRREPT | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:33:44:000 | 04/02/2008 13:49:07:000 |
Table PXRTXCD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PXRTXCD_CODE | VARCHAR2(8) | No | * | * | |
| PXRTXCD_DESC | VARCHAR2(30) | Yes | |||
| PXRTXCD_TAX_TYPE | VARCHAR2(1) | No | |||
| PXRTXCD_STARTING_POINT | VARCHAR2(3) | No | |||
| PXRTXCD_ANNUALIZATION_METHOD | VARCHAR2(1) | Yes | |||
| PXRTXCD_SUPPLEMENTAL_PERCENT | NUMBER(7,4) | Yes | |||
| PXRTXCD_USER_ID | VARCHAR2(30) | No | |||
| PXRTXCD_ACTIVITY_DATE | DATE | No | |||
| PXRTXCD_STAT_CODE | VARCHAR2(3) | Yes | |||
| PXRTXCD_FIPS_CODE | VARCHAR2(2) | Yes | |||
| PXRTXCD_1099_IND | VARCHAR2(1) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| PXRTXCD_CODE | PTRBDCA_TXCD_CODE | PTRBDCA |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PXRTXCD | Unique | PXRTXCD_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PXRADDS | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXRCALC | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXREXEM | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXRFSTA | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXRGRAD | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PXRTVFY | SQL Table | S10B80.PAYROLL | Refer (no action) |
| PDVDEDD | SQL View | S10B80.BANINST1 | Use (select) |
| P_BUILD_W2 | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2006 | Rely On |
| P_BUILD_W2 | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2006 | Use (select) |
| P_BUILD_W2 | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2007 | Rely On |
| P_BUILD_W2 | Oracle Package Procedure | S10B80.BANINST1.PP_W2_2007 | Use (select) |
| P_COMPUTE_BOX_AMOUNTS | Oracle Package Procedure | S10B80.BANINST1.PP_W2 | Use (select) |
| UT_PB_W2_FEDERALDELETEAPI | Oracle Package Procedure | S10B80.BANINST1.UT_PB_W2_FEDERAL | Use (select) |
| P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.PB_W2_STATE_RULES | Rely On |
| P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.PB_W2_STATE_RULES | Use (select) |
| P_VALIDATE_ACCOUNT_NUMBER | Oracle Package Procedure | S10B80.BANINST1.PXKW2FD | Use (select) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_W2_STATE | Use (select) |
| PXRTXCD | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PXRTXCD | SQL Index | S10B80.PAYROLL | Rely On |
| PTRBDCA | SQL Table | S10B80.PAYROLL | Join |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:36:03:000 | 04/02/2008 13:49:10:000 |
Table SPBPERS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SPBPERS_PIDM | NUMBER(8,0) | No | * | * | |
| SPBPERS_SSN | VARCHAR2(15) | Yes | |||
| SPBPERS_BIRTH_DATE | DATE | Yes | |||
| SPBPERS_LGCY_CODE | VARCHAR2(1) | Yes | * | ||
| SPBPERS_ETHN_CODE | VARCHAR2(2) | Yes | * | ||
| SPBPERS_MRTL_CODE | VARCHAR2(1) | Yes | * | ||
| SPBPERS_RELG_CODE | VARCHAR2(2) | Yes | * | ||
| SPBPERS_SEX | VARCHAR2(1) | Yes | |||
| SPBPERS_CONFID_IND | VARCHAR2(1) | Yes | |||
| SPBPERS_DEAD_IND | VARCHAR2(1) | Yes | |||
| SPBPERS_VETC_FILE_NUMBER | VARCHAR2(10) | Yes | |||
| SPBPERS_LEGAL_NAME | VARCHAR2(500) | Yes | |||
| SPBPERS_PREF_FIRST_NAME | VARCHAR2(60) | Yes | |||
| SPBPERS_NAME_PREFIX | VARCHAR2(20) | Yes | |||
| SPBPERS_NAME_SUFFIX | VARCHAR2(20) | Yes | |||
| SPBPERS_ACTIVITY_DATE | DATE | No | |||
| SPBPERS_VERA_IND | VARCHAR2(1) | Yes | |||
| SPBPERS_CITZ_IND | VARCHAR2(1) | Yes | |||
| SPBPERS_DEAD_DATE | DATE | Yes | |||
| SPBPERS_PIN | RAW(1) | Yes | |||
| SPBPERS_CITZ_CODE | VARCHAR2(2) | Yes | * | ||
| SPBPERS_HAIR_CODE | VARCHAR2(2) | Yes | |||
| SPBPERS_EYES_CODE | VARCHAR2(2) | Yes | |||
| SPBPERS_CITY_BIRTH | VARCHAR2(50) | Yes | |||
| SPBPERS_STAT_CODE_BIRTH | VARCHAR2(3) | Yes | * | ||
| SPBPERS_DRIVER_LICENSE | VARCHAR2(20) | Yes | |||
| SPBPERS_STAT_CODE_DRIVER | VARCHAR2(3) | Yes | * | ||
| SPBPERS_NATN_CODE_DRIVER | VARCHAR2(5) | Yes | * | ||
| SPBPERS_UOMS_CODE_HEIGHT | VARCHAR2(4) | Yes | * | ||
| SPBPERS_HEIGHT | NUMBER(2,0) | Yes | |||
| SPBPERS_UOMS_CODE_WEIGHT | VARCHAR2(4) | Yes | * | ||
| SPBPERS_WEIGHT | NUMBER(4,0) | Yes | |||
| SPBPERS_SDVET_IND | VARCHAR2(1) | Yes | |||
| SPBPERS_LICENSE_ISSUED_DATE | DATE | Yes | |||
| SPBPERS_LICENSE_EXPIRES_DATE | DATE | Yes | |||
| SPBPERS_INCAR_IND | VARCHAR2(1) | Yes | |||
| SPBPERS_WEBID | RAW(1) | Yes | |||
| SPBPERS_WEB_LAST_ACCESS | RAW(1) | Yes | |||
| SPBPERS_PIN_DISABLED_IND | RAW(1) | Yes | |||
| SPBPERS_ITIN | NUMBER(9,0) | Yes | |||
| SPBPERS_ACTIVE_DUTY_SEPR_DATE | DATE | Yes | |||
| SPBPERS_DATA_ORIGIN | VARCHAR2(30) | Yes | |||
| SPBPERS_USER_ID | VARCHAR2(30) | Yes | |||
| SPBPERS_ETHN_CDE | VARCHAR2(1) | Yes | |||
| SPBPERS_CONFIRMED_RE_CDE | VARCHAR2(1) | Yes | |||
| SPBPERS_CONFIRMED_RE_DATE | DATE | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SPBPERS_UOMS_CODE_HEIGHT | GTVUOMS_CODE | GTVUOMS |
| SPBPERS_UOMS_CODE_WEIGHT | GTVUOMS_CODE | GTVUOMS |
| SPBPERS_NATN_CODE_DRIVER | STVNATN_CODE | STVNATN |
| SPBPERS_RELG_CODE | STVRELG_CODE | STVRELG |
| SPBPERS_STAT_CODE_BIRTH | STVSTAT_CODE | STVSTAT |
| SPBPERS_STAT_CODE_DRIVER | STVSTAT_CODE | STVSTAT |
| SPBPERS_CITZ_CODE | STVCITZ_CODE | STVCITZ |
| SPBPERS_MRTL_CODE | STVMRTL_CODE | STVMRTL |
| SPBPERS_ETHN_CODE | STVETHN_CODE | STVETHN |
| SPBPERS_LGCY_CODE | STVLGCY_CODE | STVLGCY |
| SPBPERS_PIDM | SARADAP_PIDM | SARADAP |
| SPBPERS_PIDM | SHRTTRM_PIDM | SHRTTRM |
| SPBPERS_PIDM | RORSTAT_PIDM | RORSTAT |
| SPBPERS_CITZ_CODE | SARDCSN_CITZ_CODE | SARDCSN |
| SPBPERS_PIDM | APRDHIS_PIDM | APRDHIS |
| SPBPERS_PIDM | SLRRMAT_PIDM | SLRRMAT |
| SPBPERS_PIDM | SFBETRM_PIDM | SFBETRM |
| SPBPERS_PIDM | SRBRECR_PIDM | SRBRECR |
| SPBPERS_PIDM | SGBSTDN_PIDM | SGBSTDN |
| SPBPERS_PIDM | RPRATRM_PIDM | RPRATRM |
| SPBPERS_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
| SPBPERS_PIDM | GOBSEVS_PIDM | GOBSEVS |
| SPBPERS_PIDM | APRCHIS_PIDM | APRCHIS |
| SPBPERS_PIDM | PEBEMPL_PIDM | PEBEMPL |
| SPBPERS_PIDM | NBRBJOB_PIDM | NBRBJOB |
| SPBPERS_PIDM | GOREMAL_PIDM | GOREMAL |
| SPBPERS_PIDM | SPRMEDI_PIDM | SPRMEDI |
| SPBPERS_PIDM | APRACYR_PIDM | APRACYR |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SPBPERS | Unique | SPBPERS_PIDM |
| SPBPERS_SSN_INDEX | SPBPERS_SSN |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_SPBPERS | SQL Index | S10B80.SATURN | Rely On |
| SPBPERS_SSN_INDEX | SQL Index | S10B80.SATURN | Rely On |
| APRACYR | SQL Table | S10B80.ALUMNI | Join |
| APRCHIS | SQL Table | S10B80.ALUMNI | Join |
| APRDHIS | SQL Table | S10B80.ALUMNI | Join |
| GOBSEVS | SQL Table | S10B80.GENERAL | Join |
| GOREMAL | SQL Table | S10B80.GENERAL | Join |
| GORSEVD | SQL Table | S10B80.GENERAL | Join |
| GTVUOMS | SQL Table | S10B80.GENERAL | Refer (no action) |
| NBRBJOB | SQL Table | S10B80.POSNCTL | Join |
| PEBEMPL | SQL Table | S10B80.PAYROLL | Join |
| RORSTAT | SQL Table | S10B80.FAISMGR | Join |
| RPRATRM | SQL Table | S10B80.FAISMGR | Join |
| SARADAP | SQL Table | S10B80.SATURN | Join |
| SARDCSN | SQL Table | S10B80.SATURN | Join |
| SFBETRM | SQL Table | S10B80.SATURN | Join |
| SGBSTDN | SQL Table | S10B80.SATURN | Join |
| SHRTTRM | SQL Table | S10B80.SATURN | Join |
| SLRRMAT | SQL Table | S10B80.SATURN | Join |
| SPRMEDI | SQL Table | S10B80.SATURN | Join |
| SRBRECR | SQL Table | S10B80.SATURN | Join |
| STVCITZ | SQL Table | S10B80.SATURN | Refer (no action) |
| STVETHN | SQL Table | S10B80.SATURN | Refer (no action) |
| STVLGCY | SQL Table | S10B80.SATURN | Refer (no action) |
| STVMRTL | SQL Table | S10B80.SATURN | Refer (no action) |
| STVNATN | SQL Table | S10B80.SATURN | Refer (no action) |
| STVRELG | SQL Table | S10B80.SATURN | Refer (no action) |
| STVSTAT | SQL Table | S10B80.SATURN | Refer (no action) |
| ET_SPBPERS_AIR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (Insert,after,each row) |
| ET_SPBPERS_AUR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (update,after,each row) |
| ST_SPBPERS_AR_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,each row) |
| ST_SPBPERS_AS_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,all rows) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:40:04:000 | 04/02/2008 21:18:03:000 |
Table SPRIDEN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SPRIDEN_PIDM | NUMBER(8,0) | No | * | ||
| SPRIDEN_ID | VARCHAR2(9) | No | * | ||
| SPRIDEN_LAST_NAME | VARCHAR2(60) | No | |||
| SPRIDEN_FIRST_NAME | VARCHAR2(60) | Yes | |||
| SPRIDEN_MI | VARCHAR2(60) | Yes | |||
| SPRIDEN_CHANGE_IND | VARCHAR2(1) | Yes | |||
| SPRIDEN_ENTITY_IND | VARCHAR2(1) | Yes | |||
| SPRIDEN_ACTIVITY_DATE | DATE | No | |||
| SPRIDEN_USER | VARCHAR2(30) | Yes | |||
| SPRIDEN_ORIGIN | VARCHAR2(30) | Yes | |||
| SPRIDEN_SEARCH_LAST_NAME | VARCHAR2(60) | Yes | |||
| SPRIDEN_SEARCH_FIRST_NAME | VARCHAR2(60) | Yes | |||
| SPRIDEN_SEARCH_MI | VARCHAR2(60) | Yes | |||
| SPRIDEN_SOUNDEX_LAST_NAME | CHAR(4) | Yes | |||
| SPRIDEN_SOUNDEX_FIRST_NAME | CHAR(4) | Yes | |||
| SPRIDEN_NTYP_CODE | VARCHAR2(4) | Yes | * | ||
| SPRIDEN_CREATE_USER | VARCHAR2(30) | Yes | |||
| SPRIDEN_CREATE_DATE | DATE | Yes | |||
| SPRIDEN_DATA_ORIGIN | VARCHAR2(30) | Yes | |||
| SPRIDEN_CREATE_FDMN_CODE | VARCHAR2(30) | Yes | |||
| SPRIDEN_SURNAME_PREFIX | VARCHAR2(60) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SPRIDEN_NTYP_CODE | GTVNTYP_CODE | GTVNTYP |
| SPRIDEN_PIDM | GOBEACC_PIDM | GOBEACC |
| SPRIDEN_PIDM | SFRSTCR_PIDM | SFRSTCR |
| SPRIDEN_PIDM | SPBPERS_PIDM | SPBPERS |
| SPRIDEN_PIDM | NBRBJOB_PIDM | NBRBJOB |
| SPRIDEN_PIDM | SIBINST_PIDM | SIBINST |
| SPRIDEN_PIDM | SHRTTRM_PIDM | SHRTTRM |
| SPRIDEN_PIDM | SARADAP_PIDM | SARADAP |
| SPRIDEN_PIDM | GLBEXTR_KEY | GLBEXTR |
| SPRIDEN_PIDM | SHRDGMR_PIDM | SHRDGMR |
| SPRIDEN_PIDM | RORSTAT_PIDM | RORSTAT |
| SPRIDEN_PIDM | APRXREF_XREF_PIDM | APRXREF |
| SPRIDEN_PIDM | SHBCOMI_PIDM | SHBCOMI |
| SPRIDEN_PIDM | AFRCSLT_PIDM | AFRCSLT |
| SPRIDEN_PIDM | APRCATG_PIDM | APRCATG |
| SPRIDEN_PIDM | SIRASGN_PIDM | SIRASGN |
| SPRIDEN_PIDM | APRCSPS_SPS_PIDM | APRCSPS |
| SPRIDEN_PIDM | SGBSTDN_PIDM | SGBSTDN |
| SPRIDEN_PIDM | PERJOBP_PIDM | PERJOBP |
| SPRIDEN_PIDM | AFRCTYP_CONSTITUENT_PIDM | AFRCTYP |
| SPRIDEN_PIDM | AMRINFO_PIDM | AMRINFO |
| SPRIDEN_PIDM | SORHSCH_PIDM | SORHSCH |
| SPRIDEN_PIDM | RERSTID_PIDM | RERSTID |
| SPRIDEN_PIDM | AOBORGN_PIDM | AOBORGN |
| SPRIDEN_PIDM | GOBSRVR_PIDM | GOBSRVR |
| SPRIDEN_PIDM | APRDHIS_PIDM | APRDHIS |
| SPRIDEN_PIDM | SLRRMAT_PIDM | SLRRMAT |
| SPRIDEN_PIDM | SABSTUD_PIDM | SABSTUD |
| SPRIDEN_PIDM | SGRASSI_PIDM | SGRASSI |
| SPRIDEN_PIDM | SHTTRAN_PIDM | SHTTRAN |
| SPRIDEN_PIDM | APBCONS_PIDM | APBCONS |
| SPRIDEN_PIDM | ASRSSAG_PIDM | ASRSSAG |
| SPRIDEN_PIDM | SABIDEN_PIDM | SABIDEN |
| SPRIDEN_PIDM | SFRENRL_PIDM | SFRENRL |
| SPRIDEN_PIDM | SHRGCOL_PIDM | SHRGCOL |
| SPRIDEN_PIDM | SFBETRM_PIDM | SFBETRM |
| SPRIDEN_PIDM | SRBRECR_PIDM | SRBRECR |
| SPRIDEN_PIDM | PABAPPL_PIDM | PABAPPL |
| SPRIDEN_PIDM | PEBEMPL_PIDM | PEBEMPL |
| SPRIDEN_PIDM | SORPCOL_PIDM | SORPCOL |
| SPRIDEN_PIDM | SPRHOLD_PIDM | SPRHOLD |
| SPRIDEN_PIDM | RPRATRM_PIDM | RPRATRM |
| SPRIDEN_PIDM | SHRCOMM_PIDM_MEMBER | SHRCOMM |
| SPRIDEN_PIDM | RPRAWRD_PIDM | RPRAWRD |
| SPRIDEN_PIDM | ASRSORG_PIDM | ASRSORG |
| SPRIDEN_PIDM | SLRRASG_PIDM | SLRRASG |
| SPRIDEN_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SPRIDEN_PIDM | APRCHLD_CHLD_PIDM | APRCHLD |
| SPRIDEN_PIDM | APREHIS_EMPR_PIDM | APREHIS |
| SPRIDEN_PIDM | PERBARG_PIDM | PERBARG |
| SPRIDEN_PIDM | PARAPIN_PIDM | PARAPIN |
| SPRIDEN_PIDM | SPRADDR_PIDM | SPRADDR |
| SPRIDEN_PIDM | PDRBDED_PIDM | PDRBDED |
| SPRIDEN_PIDM | SORAROL_PIDM | SORAROL |
| SPRIDEN_PIDM | SERDTGL_PIDM | SERDTGL |
| SPRIDEN_PIDM | SERDTND_PIDM | SERDTND |
| SPRIDEN_PIDM | SERDTSR_PIDM | SERDTSR |
| SPRIDEN_PIDM | SLBEVNT_AGENCY_PIDM | SLBEVNT |
| SPRIDEN_PIDM | RORLOGM_PIDM | RORLOGM |
| SPRIDEN_PIDM | RNRTMNT_PIDM | RNRTMNT |
| SPRIDEN_PIDM | SHBHEAD_PIDM | SHBHEAD |
| SPRIDEN_PIDM | SMRRQCM_ORIG_PIDM | SMRRQCM |
| SPRIDEN_PIDM | SMRRQCM_PIDM | SMRRQCM |
| SPRIDEN_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
| SPRIDEN_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
| SPRIDEN_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
| SPRIDEN_PIDM | GOBSEVS_PIDM | GOBSEVS |
| SPRIDEN_PIDM | PERJOBS_COMMENT_PIDM | PERJOBS |
| SPRIDEN_PIDM | PERJOBS_PIDM | PERJOBS |
| SPRIDEN_PIDM | AGBMGID_EMPR_PIDM | AGBMGID |
| SPRIDEN_PIDM | AGBMGID_EMPL_PIDM | AGBMGID |
| SPRIDEN_PIDM | AORCONT_CONTACT_PIDM | AORCONT |
| SPRIDEN_PIDM | SORAINF_PIDM | SORAINF |
| SPRIDEN_PIDM | NBRJOBS_PIDM | NBRJOBS |
| SPRIDEN_PIDM | GORSEVS_PIDM | GORSEVS |
| SPRIDEN_PIDM | PDRBENE_BENE_PIDM | PDRBENE |
| SPRIDEN_PIDM | APRCHIS_PIDM | APRCHIS |
| SPRIDEN_PIDM | PERREVW_PIDM | PERREVW |
| SPRIDEN_PIDM | GERATTD_PIDM | GERATTD |
| SPRIDEN_PIDM | SGRADVR_ADVR_PIDM | SGRADVR |
| SPRIDEN_PIDM | SGRADVR_PIDM | SGRADVR |
| SPRIDEN_PIDM | FABINVH_VEND_CHECK_PIDM | FABINVH |
| SPRIDEN_PIDM | FABINVH_VEND_PIDM | FABINVH |
| SPRIDEN_PIDM | PERJOBH_COMMENT_PIDM | PERJOBH |
| SPRIDEN_PIDM | PERTETH_TRANS_PIDM | PERTETH |
| SPRIDEN_PIDM | PERROUT_ACTION_PIDM | PERROUT |
| SPRIDEN_PIDM | PERROUT_APPR_PIDM | PERROUT |
| SPRIDEN_PIDM | FTVVEND_PIDM | FTVVEND |
| SPRIDEN_PIDM | GOBTPAC_PIDM | GOBTPAC |
| SPRIDEN_PIDM | FRBGRNT_AGENCY_PIDM | FRBGRNT |
| SPRIDEN_PIDM | AMRSTAF_PIDM | AMRSTAF |
| SPRIDEN_PIDM | SHRMRKS_PIDM | SHRMRKS |
| SPRIDEN_PIDM | SHRCMRK_PIDM | SHRCMRK |
| SPRIDEN_PIDM | SHRSMRK_PIDM | SHRSMRK |
| SPRIDEN_PIDM | NBREJOB_PIDM | NBREJOB |
| SPRIDEN_PIDM | SHRNCRS_ADVR_PIDM | SHRNCRS |
| SPRIDEN_PIDM | SHRTCKN_PIDM | SHRTCKN |
| SPRIDEN_PIDM | NBTJOBF_EMPLOYEE_PIDM | NBTJOBF |
| SPRIDEN_PIDM | RCRAPP1_PIDM | RCRAPP1 |
| SPRIDEN_PIDM | RPRLAPP_LENDER_PIDM | RPRLAPP |
| SPRIDEN_PIDM | SFRAREG_PIDM | SFRAREG |
| SPRIDEN_PIDM | PERFJOB_PIDM | PERFJOB |
| SPRIDEN_PIDM | AMRPLAN_PIDM | AMRPLAN |
| SPRIDEN_PIDM | GORVISA_PIDM | GORVISA |
| SPRIDEN_ID | SRTIDEN_ID | SRTIDEN |
| SPRIDEN_PIDM | SRTIDEN_PIDM | SRTIDEN |
| SPRIDEN_PIDM | PERFCNT_PIDM | PERFCNT |
| SPRIDEN_PIDM | APRACYR_PIDM | APRACYR |
| SPRIDEN_PIDM | SHTTRTC_PIDM | SHTTRTC |
| SPRIDEN_PIDM | GOBUMAP_PIDM | GOBUMAP |
| SPRIDEN_PIDM | AORJPST_EMPR_PIDM | AORJPST |
| SPRIDEN_PIDM | FTVIMGR_IMGR_CODE_PIDM | FTVIMGR |
| SPRIDEN_PIDM | APRCRVW_PIDM | APRCRVW |
| SPRIDEN_PIDM | APRERVW_PIDM | APRERVW |
| SPRIDEN_PIDM | APRSRVW_PIDM | APRSRVW |
| SPRIDEN_PIDM | APRDRVW_PIDM | APRDRVW |
| Index Name | Index Type | Column Name |
|---|---|---|
| SPRIDEN_INDEX_ID | SPRIDEN_ID | |
| SPRIDEN_INDEX_ID | SPRIDEN_ENTITY_IND | |
| SPRIDEN_INDEX_ID | SPRIDEN_CHANGE_IND | |
| SPRIDEN_INDEX_PERS | SPRIDEN_LAST_NAME | |
| SPRIDEN_INDEX_PERS | SPRIDEN_FIRST_NAME | |
| SPRIDEN_INDEX_PERS | SPRIDEN_MI | |
| SPRIDEN_INDEX_PERS | SPRIDEN_ENTITY_IND | |
| SPRIDEN_INDEX_PERS | SPRIDEN_CHANGE_IND | |
| SPRIDEN_INDEX_SEARCH | SPRIDEN_SEARCH_LAST_NAME | |
| SPRIDEN_INDEX_SEARCH | SPRIDEN_SEARCH_FIRST_NAME | |
| SPRIDEN_INDEX_SEARCH | SPRIDEN_SEARCH_MI | |
| SPRIDEN_INDEX_SOUNDEX | SPRIDEN_SOUNDEX_LAST_NAME | |
| SPRIDEN_INDEX_SOUNDEX | SPRIDEN_SOUNDEX_FIRST_NAME | |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_PIDM |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_ID |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_LAST_NAME |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_FIRST_NAME |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_MI |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_CHANGE_IND |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_NTYP_CODE |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 13:48:43:000 | 04/02/2008 21:17:58:000 |
Link between SPRIDEN and SPBPERS| Objects list |
|---|
| schema-view : S10B80.BANINST1.PEVJOB1
schema-view : S10B80.BANINST1.GPVENT1 schema-view : S10B80.BANINST1.AOVORG1 schema-view : S10B80.BANINST1.GOVSRVR schema-view : S10B80.BANINST1.PAVAPPL schema-view : S10B80.BANINST1.PEVPRF1 schema-view : S10B80.BANINST1.PEVVER2 schema-view : S10B80.BANINST1.APVCNI1 schema-function : S10B80.BANINST1.F_BENEFICIARY_INFO schema-view : S10B80.BANINST1.PDVDED1 schema-view : S10B80.BANINST1.ROVFINS schema-view : S10B80.BANINST1.GUVALTI schema-view : S10B80.BANINST1.AOVIDEN schema-view : S10B80.BANINST1.AT_AR_BALANCE_BY_ENTITY schema-view : S10B80.BANINST1.APVBRWS schema-view : S10B80.BANINST1.SPVPERS schema-view : S10B80.BANINST1.SPVCURR scope-function : S10B80.BANINST1.GB_IDENTIFICATION.F_IDNAME_SEARCH scope-function : S10B80.BANINST1.GB_IDENTIFICATION.F_SSNNAME_SEARCH scope-cursor : S10B80.BANINST1.ICSPKCOM.PERSON_C scope-cursor : S10B80.BANINST1.PP_W2_2006.EMPL_C scope-cursor : S10B80.BANINST1.PP_W2_2007.EMPL_C scope-cursor : S10B80.BANINST1.SPKLIBS.FULL_NAME_C scope-function : S10B80.BANINST1.TEST_LVH.F_IDNAME_SEARCH scope-procedure : S10B80.BANINST1.SB_PESCXML_PERSON_EXP.P_PERSON_ELEMENT scope-procedure : S10B80.BANINST1.PB_W2_FEDERAL_RULES.P_VALIDATE scope-procedure : S10B80.BANINST1.PP_W2.P_CREATE_W2 scope-function : S10B80.BANINST1.GOKVISA.F_CHECK_CITZ scope-function : S10B80.BANINST1.SHKTRAN.F_IDEN_NAME scope-function : S10B80.BANINST1.SHKTRAN.F_TRANSCRIPT_NAME scope-function : S10B80.BANINST1.BWPKEPCR.F_GET_ID scope-function : S10B80.BANINST1.GB_PERSON.F_GET_PERSON_BY_ID scope-procedure : S10B80.BANINST1.PDKDEDN.P_EDIT_EMPLOYEE_ID |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and SPBPERS | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | SPBPERS |
Link between PTRBDPL and PDRDEDN| Objects list |
|---|
| schema-view : S10B80.BANINST1.PDVDAMT
schema-view : S10B80.BANINST1.PDVDEDN |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PTRBDPL and PDRDEDN | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PTRBDPL | PDRDEDN |
Link between PTRBDCA and PDRDEDN| Objects list |
|---|
| schema-view : S10B80.BANINST1.PDVDAMT
schema-view : S10B80.BANINST1.PDVDEDN scope-cursor : S10B80.BANINST1.BWPKEBST.GETSECGRPC scope-procedure : S10B80.BANINST1.BWPKEBST.P_BENEFITS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PTRBDCA and PDRDEDN | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PTRBDCA | PDRDEDN |
Link between PERJTOT and PXRRERN| Objects list |
|---|
| schema-view : S10B80.BANINST1.PXVRTOT
schema-view : S10B80.BANINST1.PXVREP2 schema-view : S10B80.BANINST1.PXVREPT scope-procedure : S10B80.BANINST1.PP_W2_2006.P_COMPUTE_BOX_AMOUNTS scope-procedure : S10B80.BANINST1.PP_W2_2007.P_COMPUTE_BOX_AMOUNTS scope-procedure : S10B80.BANINST1.PP_W2.P_COMPUTE_BOX_AMOUNTS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PERJTOT and PXRRERN | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PERJTOT | PXRRERN |
Link between PERDTOT and PXRRDED| Objects list |
|---|
| schema-view : S10B80.BANINST1.PXVRTOT
schema-view : S10B80.BANINST1.PXVREP2 schema-view : S10B80.BANINST1.PXVREPT scope-procedure : S10B80.BANINST1.PP_W2_2006.P_COMPUTE_BOX_AMOUNTS scope-procedure : S10B80.BANINST1.PP_W2_2007.P_COMPUTE_BOX_AMOUNTS scope-procedure : S10B80.BANINST1.UT_PB_W2_LOCAL.UT_SETUP scope-procedure : S10B80.BANINST1.PP_W2.P_COMPUTE_BOX_AMOUNTS scope-procedure : S10B80.BANINST1.UT_PB_W2_FEDERAL.UT_PB_W2_FEDERALDELETEAPI scope-procedure : S10B80.BANINST1.PB_W2_LOCAL_RULES.P_VALIDATE |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PERDTOT and PXRRDED | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PERDTOT | PXRRDED |
Link between PXRRERN and PXRREPT| Objects list |
|---|
| schema-view : S10B80.BANINST1.PXVREP2 |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PXRRERN and PXRREPT | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PXRRERN | PXRREPT |
Link between PERJTOT and PXRREPT| Objects list |
|---|
| schema-view : S10B80.BANINST1.PXVREP2 |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PERJTOT and PXRREPT | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PERJTOT | PXRREPT |
Link between PXRRDED and PXRREPT| Objects list |
|---|
| schema-view : S10B80.BANINST1.PXVREP2 |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PXRRDED and PXRREPT | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PXRRDED | PXRREPT |
Link between PERDTOT and PXRREPT| Objects list |
|---|
| schema-view : S10B80.BANINST1.PXVREP2 |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PERDTOT and PXRREPT | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PERDTOT | PXRREPT |
Link between PPRCOLR and PXRRERN| Objects list |
|---|
| schema-view : S10B80.BANINST1.PXVREPT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PPRCOLR and PXRRERN | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PPRCOLR | PXRRERN |
Link between PPRCOLR and PERJTOT| Objects list |
|---|
| schema-view : S10B80.BANINST1.PXVREPT
schema-view : S10B80.BANINST1.PEVJTOT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PPRCOLR and PERJTOT | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PPRCOLR | PERJTOT |
Link between PPRCOLR and PXRRDED| Objects list |
|---|
| schema-view : S10B80.BANINST1.PXVREPT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PPRCOLR and PXRRDED | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PPRCOLR | PXRRDED |
Link between PPRCOLR and PERDTOT| Objects list |
|---|
| schema-view : S10B80.BANINST1.PXVREPT
schema-view : S10B80.BANINST1.PEVATOT schema-view : S10B80.BANINST1.PEVATYP schema-view : S10B80.BANINST1.PEVDTOT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PPRCOLR and PERDTOT | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PPRCOLR | PERDTOT |
Link between PHREARN and PPRCOLR| Objects list |
|---|
| schema-view : S10B80.BANINST1.PHVTTOT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PHREARN and PPRCOLR | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PHREARN | PPRCOLR |
Link between PPRCOLR and PHRJOBS| Objects list |
|---|
| schema-view : S10B80.BANINST1.PHVTTOT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PPRCOLR and PHRJOBS | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PPRCOLR | PHRJOBS |
Link between PERDTOT and PTRBDCA| Objects list |
|---|
| schema-view : S10B80.BANINST1.PEVATYP
schema-view : S10B80.BANINST1.PEVDEDT scope-procedure : S10B80.BANINST1.PP_W2_2006.P_BUILD_W2 scope-procedure : S10B80.BANINST1.PP_W2_2006.P_COMPUTE_BOX_AMOUNTS scope-procedure : S10B80.BANINST1.PP_W2_2007.P_BUILD_W2 scope-procedure : S10B80.BANINST1.PP_W2_2007.P_COMPUTE_BOX_AMOUNTS scope-cursor : S10B80.BANINST1.BWPKHDED.PERDTOTSUMC scope-procedure : S10B80.BANINST1.PP_W2.P_COMPUTE_BOX_AMOUNTS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PERDTOT and PTRBDCA | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PERDTOT | PTRBDCA |
Link between PPRCOLR and PTRBDCA| Objects list |
|---|
| schema-view : S10B80.BANINST1.PEVATYP |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PPRCOLR and PTRBDCA | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PPRCOLR | PTRBDCA |
Link between SPRIDEN and PEBEMPL| Objects list |
|---|
| schema-view : S10B80.BANINST1.PAVAPPL
schema-view : S10B80.BANINST1.PEVPRF1 schema-view : S10B80.BANINST1.PEVVER2 schema-view : S10B80.BANINST1.PHVTIME schema-view : S10B80.BANINST1.PEVEMPL schema-function : S10B80.BANINST1.F_ORDER_BY_LAST scope-cursor : S10B80.BANINST1.PP_W2_2006.EMPL_C scope-cursor : S10B80.BANINST1.PP_W2_2007.EMPL_C scope-procedure : S10B80.BANINST1.PP_W2.P_CREATE_W2 scope-procedure : S10B80.BANINST1.PDKDEDN.P_EDIT_EMPLOYEE_ID scope-function : S10B80.BANINST1.BWPKEBST.F_GETPIDMFROMID |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and PEBEMPL | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | PEBEMPL |
Link between PDRBENE and PDRBCOV| Objects list |
|---|
| schema-function : S10B80.BANINST1.F_BENEFICIARY_INFO
scope-procedure : S10B80.BANINST1.BWPKEBST.P_PRINTCOVEREDPERSONS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PDRBENE and PDRBCOV | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PDRBENE | PDRBCOV |
Link between PDRDEDN and PDRBDED| Objects list |
|---|
| schema-function : S10B80.BANINST1.F_DEDUCTION_ROWID
schema-view : S10B80.BANINST1.PDVDEDD schema-view : S10B80.BANINST1.PDVDEDN scope-function : S10B80.BANINST1.PEKEMPL.F_INVALID_DEDN_EXISTS scope-function : S10B80.BANINST1.PB_EMPLOYEE_RULES.F_INVALID_DEDN_EXISTS scope-cursor : S10B80.BANINST1.BWPKDBCV.PDRBDEDCOVERAGESC scope-cursor : S10B80.BANINST1.BWPKDBCV.PDRBDEDC scope-function : S10B80.BANINST1.BWPKDBCV.F_GETDEDNSTATUS scope-cursor : S10B80.BANINST1.PDKLIBS.DEDNPRECLUDESC scope-cursor : S10B80.BANINST1.PDKLIBS.PDRDEDNRANGECOUNTC scope-procedure : S10B80.BANINST1.PDKLIBS.P_VERIFYCOREBDCAEMP scope-procedure : S10B80.BANINST1.NOKPLIB.P_EDIT_PEBEMPL_BCAT_CODE scope-procedure : S10B80.BANINST1.PDKDEDN.P_CHECK_PRECLUSION scope-function : S10B80.BANINST1.POKLIBS.F_CHECK_REQD_DEDNS scope-cursor : S10B80.BANINST1.BWPKEBST.GETSECGRPC scope-procedure : S10B80.BANINST1.BWPKEBST.P_BENEFITS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PDRDEDN and PDRBDED | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PDRDEDN | PDRBDED |
Link between SPRIDEN and PDRBDED| Objects list |
|---|
| schema-view : S10B80.BANINST1.PDVDED1 |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and PDRBDED | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | PDRBDED |
Link between PERDTOT and PTRBDAS| Objects list |
|---|
| schema-view : S10B80.BANINST1.PEVBDAS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PERDTOT and PTRBDAS | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PERDTOT | PTRBDAS |
Link between PXRTXCD and PTRBDCA| Objects list |
|---|
| schema-view : S10B80.BANINST1.PDVDEDD
scope-procedure : S10B80.BANINST1.PP_W2_2006.P_BUILD_W2 scope-procedure : S10B80.BANINST1.PP_W2_2007.P_BUILD_W2 scope-procedure : S10B80.BANINST1.PP_W2.P_COMPUTE_BOX_AMOUNTS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PXRTXCD and PTRBDCA | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PXRTXCD | PTRBDCA |
Link between PTRBDPL and PDRBDED| Objects list |
|---|
| schema-view : S10B80.BANINST1.PDVDEDD |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PTRBDPL and PDRBDED | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PTRBDPL | PDRBDED |
Link between PTRBDCA and PDRBCOV| Objects list |
|---|
| schema-view : S10B80.BANINST1.PDVBCOV
scope-procedure : S10B80.BANINST1.BWPKEBST.P_PRINTCOVEREDPERSONS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PTRBDCA and PDRBCOV | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PTRBDCA | PDRBCOV |
Link between SPRIDEN and PDRBENE| Objects list |
|---|
| schema-view : S10B80.BANINST1.PDVBEN1
schema-view : S10B80.BANINST1.PDVBENE |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and PDRBENE | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | PDRBENE |
Link between PDRBENE and SPBPERS| Objects list |
|---|
| schema-view : S10B80.BANINST1.PDVBENE |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PDRBENE and SPBPERS | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PDRBENE | SPBPERS |
Link between PARAPST and GTVSDAX| Objects list |
|---|
| schema-function : S10B80.BANINST1.F_SDAX_APPL_STAT
scope-function : S10B80.BANINST1.PAKRECR.F_SDAX_APPL_STAT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PARAPST and GTVSDAX | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PARAPST | GTVSDAX |
Link between SPBPERS and PEBEMPL| Objects list |
|---|
| schema-view : S10B80.BANINST1.PEVEMPL
scope-procedure : S10B80.BANINST1.PEKDEGR.P_BUILDPETDEGR |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPBPERS and PEBEMPL | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPBPERS | PEBEMPL |
Link between GTVSDAX and PERJTOT| Objects list |
|---|
| schema-function : S10B80.BANINST1.F_CONCAT_FISC_GROSS
scope-procedure : S10B80.BANINST1.PEKWEMP.P_GETGROSSINCOME |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between GTVSDAX and PERJTOT | GENERAL |
| Link type | Between | And |
|---|---|---|
| Join | GTVSDAX | PERJTOT |
Link between PXRRDED and PTRBDCA| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.PP_W2_2006.P_COMPUTE_BOX_AMOUNTS
scope-procedure : S10B80.BANINST1.PP_W2_2007.P_COMPUTE_BOX_AMOUNTS scope-procedure : S10B80.BANINST1.PP_W2.P_COMPUTE_BOX_AMOUNTS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PXRRDED and PTRBDCA | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PXRRDED | PTRBDCA |
Link between PHR1042 and PHRHIST| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.PP_W2_2006.P_COMPUTE_BOX_AMOUNTS
scope-procedure : S10B80.BANINST1.PP_W2_2007.P_COMPUTE_BOX_AMOUNTS scope-procedure : S10B80.BANINST1.PP_W2.P_COMPUTE_BOX_AMOUNTS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PHR1042 and PHRHIST | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PHR1042 | PHRHIST |
Link between PTRPICT and PHRHIST| Objects list |
|---|
| scope-function : S10B80.BANINST1.PX_RECORD_OF_EMPLOYMENT.F_VALID_EMPR_CODE
scope-function : S10B80.BANINST1.PX_MASS_ROE.F_VALID_EMPR_CODE |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PTRPICT and PHRHIST | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PTRPICT | PHRHIST |
Link between PHRHIST and PHRJOBS| Objects list |
|---|
| scope-function : S10B80.BANINST1.NOKP3LB.F_GET_POSN_LAST_PAID_DATE
scope-function : S10B80.BANINST1.NOKPLIB.F_GET_LAST_PAID_DATE scope-function : S10B80.BANINST1.PEKLEAV.F_GET_JOB_LEAVE_ACCRUAL scope-procedure : S10B80.BANINST1.PEKLEAV.P_MAIN_ROLL |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PHRHIST and PHRJOBS | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PHRHIST | PHRJOBS |
Link between PHRDEDN and PTRBDGM| Objects list |
|---|
| scope-cursor : S10B80.BANINST1.BWPKHSTB.GET_PAY_DEDNC
scope-cursor : S10B80.BANINST1.BWPKHSTB.GET_DEDN_SUMC |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PHRDEDN and PTRBDGM | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PHRDEDN | PTRBDGM |
Link between PHRDEDN and PTRBDCA| Objects list |
|---|
| scope-cursor : S10B80.BANINST1.BWPKHSTB.GET_PAY_DEDNC |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PHRDEDN and PTRBDCA | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PHRDEDN | PTRBDCA |
Link between PHREARN and PHRJOBS| Objects list |
|---|
| scope-cursor : S10B80.BANINST1.BWPKHSTB.GET_PAY_EARNC |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PHREARN and PHRJOBS | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PHREARN | PHRJOBS |
Link between PHRHIST and PHRDOCM| Objects list |
|---|
| scope-cursor : S10B80.BANINST1.BWPKHSTB.GET_PAY_SUMC
scope-cursor : S10B80.BANINST1.BWPKHSTB.GET_ADJS_DOCC scope-function : S10B80.BANINST1.BWPKHSTB.F_CHECK_IF_ADJUSTED scope-procedure : S10B80.BANINST1.BWPKHSTB.P_GET_ORIGINAL_DATE |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PHRHIST and PHRDOCM | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PHRHIST | PHRDOCM |
Link between PDRBDED and PTRBDGM| Objects list |
|---|
| scope-cursor : S10B80.BANINST1.BWPKDBCV.PDRBDEDCOVERAGESC
scope-cursor : S10B80.BANINST1.BWPKDBCV.PDRBDEDC |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PDRBDED and PTRBDGM | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PDRBDED | PTRBDGM |
Link between PDRBDED and PTRBDPD| Objects list |
|---|
| scope-cursor : S10B80.BANINST1.PDKLIBS.DEDNPRECLUDESC
scope-procedure : S10B80.BANINST1.PDKDEDN.P_CHECK_PRECLUSION |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PDRBDED and PTRBDPD | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PDRBDED | PTRBDPD |
Link between PTRFBEN and PDRDEDN| Objects list |
|---|
| scope-cursor : S10B80.BANINST1.PDKLIBS.FLXSAMOUNTSC |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PTRFBEN and PDRDEDN | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PTRFBEN | PDRDEDN |
Link between PDRFCLM and PDRDEDN| Objects list |
|---|
| scope-cursor : S10B80.BANINST1.PDKLIBS.FLXSAMOUNTSC |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PDRFCLM and PDRDEDN | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PDRFCLM | PDRDEDN |
Link between PDRFBAL and PDRDEDN| Objects list |
|---|
| scope-cursor : S10B80.BANINST1.PDKLIBS.FLXSAMOUNTSC |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PDRFBAL and PDRDEDN | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PDRFBAL | PDRDEDN |
Link between PTRBCDN and PEBEMPL| Objects list |
|---|
| scope-function : S10B80.BANINST1.PDKLIBS.F_DEDNISREQUIRED
scope-cursor : S10B80.BANINST1.BWPKEBST.GETSECGRPC |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PTRBCDN and PEBEMPL | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PTRBCDN | PEBEMPL |
Link between PDRBDED and PTRBDCG| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.PDKLIBS.P_VERIFYCOREBDCAEMP |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PDRBDED and PTRBDCG | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PDRBDED | PTRBDCG |
Link between PHREARN and PHRHIST| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.PEKSNBL.P_ACCRUE_SENIORITY_HOURS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PHREARN and PHRHIST | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PHREARN | PHRHIST |
Link between PHRJOBS and PHRJACR| Objects list |
|---|
| scope-function : S10B80.BANINST1.PEKLEAV.F_GET_JOB_LEAVE_ACCRUAL |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PHRJOBS and PHRJACR | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PHRJOBS | PHRJACR |
Link between PHRJACR and PHRHIST| Objects list |
|---|
| scope-function : S10B80.BANINST1.PEKLEAV.F_GET_JOB_LEAVE_ACCRUAL |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PHRJACR and PHRHIST | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PHRJACR | PHRHIST |
Link between PERJLEV and PHRJACR| Objects list |
|---|
| scope-function : S10B80.BANINST1.PEKLEAV.F_GET_JOB_LEAVE_ACCRUAL |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PERJLEV and PHRJACR | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PERJLEV | PHRJACR |
Link between PEBEMPL and PERJLEV| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.PEKLEAV.P_MAIN_ROLL |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PEBEMPL and PERJLEV | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PEBEMPL | PERJLEV |
Link between PERJLEV and PHRHIST| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.PEKLEAV.P_MAIN_ROLL |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PERJLEV and PHRHIST | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PERJLEV | PHRHIST |
Link between PERJLEV and PHRJOBS| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.PEKLEAV.P_MAIN_ROLL |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PERJLEV and PHRJOBS | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PERJLEV | PHRJOBS |
Link between PTRBCDN and PTRBDCA| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.PDKDEDN.P_EDIT_BDCA_CODE
scope-cursor : S10B80.BANINST1.BWPKEBST.GETSECGRPC |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PTRBCDN and PTRBDCA | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PTRBCDN | PTRBDCA |
Link between PXRFSTA and PTRBDCA| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.PDKDEDN.P_EDIT_OPT_CODE |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PXRFSTA and PTRBDCA | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PXRFSTA | PTRBDCA |
Link between PDRDEDN and PTRBDPD| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.PDKDEDN.P_CHECK_PRECLUSION |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PDRDEDN and PTRBDPD | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PDRDEDN | PTRBDPD |
Link between PTRBCDN and PDRDEDN| Objects list |
|---|
| scope-function : S10B80.BANINST1.POKLIBS.F_CHECK_REQD_DEDNS
scope-procedure : S10B80.BANINST1.BWPKEBST.P_BENEFITS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PTRBCDN and PDRDEDN | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PTRBCDN | PDRDEDN |
Link between PTRBDGM and PTRBDCA| Objects list |
|---|
| scope-procedure : S10B80.BANINST1.BWPKEBST.P_BENEFITS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between PTRBDGM and PTRBDCA | PAYROLL |
| Link type | Between | And |
|---|---|---|
| Join | PTRBDGM | PTRBDCA |
Link between PTRBCDN and PTRBCAT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRBCDN and PTRBCAT (FK1_PTRBCDN_INV_PTRBCAT_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRBCDN | PTRBCDN_BCAT_CODE | PTRBCAT_CODE | PTRBCAT | (1,1)-(0,n) |
Link between PEREHIS and PTRBCAT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PEREHIS and PTRBCAT (FK1_PEREHIS_INV_PTRBCAT_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PEREHIS | PEREHIS_BCAT_CODE | PTRBCAT_CODE | PTRBCAT | (0,1)-(0,n) |
Link between PTRBDAS and PTRBDCA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRBDAS and PTRBDCA (FK1_PTRBDAS_INV_PTRBDCA_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRBDAS | PTRBDAS_BDCA_CODE | PTRBDCA_CODE | PTRBDCA | (1,1)-(0,n) |
Link between PTRBDCG and PTRBDCA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRBDCG and PTRBDCA (FK1_PTRBDCG_INV_PTRBDCA_CODE) | PAYROLL |
| Refer (no action) | Link Informative Foreign Key Between PTRBDCG and PTRBDCA (FK2_PTRBDCG_INV_PTRBDCA_CODE) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRBDCG | PTRBDCG_CODE | PTRBDCA_CODE | PTRBDCA | (1,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRBDCG | PTRBDCG_BDCA_CODE | PTRBDCA_CODE | PTRBDCA | (1,1)-(0,n) |
Link between PTRECBC and PTRBCAT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRECBC and PTRBCAT (FK1_PTRECBC_INV_PTRBCAT_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRECBC | PTRECBC_BCAT_CODE | PTRBCAT_CODE | PTRBCAT | (1,1)-(0,n) |
Link between PTRBDLD and PTRBDCA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRBDLD and PTRBDCA (FK1_PTRBDLD_INV_PTRBDCA_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRBDLD | PTRBDLD_CODE | PTRBDCA_CODE | PTRBDCA | (1,1)-(0,n) |
Link between PXRADDS and PXRTXCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PXRADDS and PXRTXCD (FK1_PXRADDS_INV_PXRTXCD_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PXRADDS | PXRADDS_TXCD_CODE | PXRTXCD_CODE | PXRTXCD | (1,1)-(0,n) |
Link between PXRFSTA and PXRTXCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PXRFSTA and PXRTXCD (FK1_PXRFSTA_INV_PXRTXCD_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PXRFSTA | PXRFSTA_TXCD_CODE | PXRTXCD_CODE | PXRTXCD | (1,1)-(0,n) |
Link between PTRBDPD and PTRBDCA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRBDPD and PTRBDCA (FK1_PTRBDPD_INV_PTRBDCA_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRBDPD | PTRBDPD_BDCA_CODE | PTRBDCA_CODE | PTRBDCA | (1,1)-(0,n) |
Link between PTRBDPL and PTRBDCA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRBDPL and PTRBDCA (FK1_PTRBDPL_INV_PTRBDCA_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRBDPL | PTRBDPL_BDCA_CODE | PTRBDCA_CODE | PTRBDCA | (1,1)-(0,n) |
Link between PTRBDGM and PTRBDSG| Link Type | Link | Project |
|---|---|---|
| Refer (delete,cascade) | Link Informative Foreign Key Between PTRBDGM and PTRBDSG (FK1_PTRBDGM_INV_PTRBDSG_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRBDGM | PTRBDGM_BDPG_CODE | PTRBDSG_BDPG_CODE | PTRBDSG | (1,1)-(0,n) |
| PTRBDGM | PTRBDGM_BDSG_CODE | PTRBDSG_CODE | PTRBDSG | (1,1)-(0,n) |
Link between PTRBDSG and PTRBDPG| Link Type | Link | Project |
|---|---|---|
| Refer (delete,cascade) | Link Informative Foreign Key Between PTRBDSG and PTRBDPG (FK1_PTRBDSG_INV_PTRBDPG_CODE) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRBDSG | PTRBDSG_BDPG_CODE | PTRBDPG_CODE | PTRBDPG | (1,1)-(0,n) |
Link between PEREHIS and PTRECLS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PEREHIS and PTRECLS (FK1_PEREHIS_INV_PTRECLS_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PEREHIS | PEREHIS_ECLS_CODE | PTRECLS_CODE | PTRECLS | (0,1)-(0,n) |
Link between PTRECBC and PTRECLS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRECBC and PTRECLS (FK1_PTRECBC_INV_PTRECLS_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRECBC | PTRECBC_CODE | PTRECLS_CODE | PTRECLS | (1,1)-(0,n) |
Link between PDRBFLX and PEBEMPL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PDRBFLX and PEBEMPL (FK1_PDRBFLX_INV_PEBEMPL_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PDRBFLX | PDRBFLX_PIDM | PEBEMPL_PIDM | PEBEMPL | (1,1)-(0,1) |
Link between PDRFBAL and PEBEMPL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PDRFBAL and PEBEMPL (FK1_PDRFBAL_INV_PEBEMPL_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PDRFBAL | PDRFBAL_PIDM | PEBEMPL_PIDM | PEBEMPL | (1,1)-(0,n) |
Link between PDRFCLM and PEBEMPL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PDRFCLM and PEBEMPL (FK1_PDRFCLM_INV_PEBEMPL_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PDRFCLM | PDRFCLM_PIDM | PEBEMPL_PIDM | PEBEMPL | (1,1)-(0,n) |
Link between PHRHIST and PEBEMPL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PHRHIST and PEBEMPL (FK1_PHRHIST_INV_PEBEMPL_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PHRHIST | PHRHIST_PIDM | PEBEMPL_PIDM | PEBEMPL | (1,1)-(0,n) |
Link between PEBEMPL and PTRBCAT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PEBEMPL and PTRBCAT (FK1_PEBEMPL_INV_PTRBCAT_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PEBEMPL | PEBEMPL_BCAT_CODE | PTRBCAT_CODE | PTRBCAT | (1,1)-(0,n) |
Link between PEBEMPL and PTRECLS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PEBEMPL and PTRECLS (FK1_PEBEMPL_INV_PTRECLS_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PEBEMPL | PEBEMPL_ECLS_CODE | PTRECLS_CODE | PTRECLS | (1,1)-(0,n) |
Link between PTRCBEN and PTRBDCA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRCBEN and PTRBDCA (FK1_PTRCBEN_INV_PTRBDCA_CODE) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRCBEN | PTRCBEN_CODE | PTRBDCA_CODE | PTRBDCA | (1,1)-(0,n) |
Link between PTRBDPG and PTVBDPG| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRBDPG and PTVBDPG (FK1_PTRBDPG_INV_PTVBDPG_CODE) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRBDPG | PTRBDPG_CODE | PTVBDPG_CODE | PTVBDPG | (1,1)-(0,1) |
Link between PXRGRAD and PXRTXCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PXRGRAD and PXRTXCD (FK1_PXRGRAD_INV_PXRTXCD_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PXRGRAD | PXRGRAD_TXCD_CODE | PXRTXCD_CODE | PXRTXCD | (1,1)-(0,n) |
Link between PTRBDCA and PTVBDTY| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRBDCA and PTVBDTY (FK1_PTRBDCA_INV_PTVBDTY_CODE) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRBDCA | PTRBDCA_BDTY_CODE | PTVBDTY_CODE | PTVBDTY | (0,1)-(0,n) |
Link between PXREXEM and PTVBDTY| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PXREXEM and PTVBDTY (FK1_PXREXEM_INV_PTVBDTY_CODE) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PXREXEM | PXREXEM_BDTY_CODE | PTVBDTY_CODE | PTVBDTY | (0,1)-(0,n) |
Link between PXREXEM and PXRTXCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PXREXEM and PXRTXCD (FK1_PXREXEM_INV_PXRTXCD_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PXREXEM | PXREXEM_TXCD_CODE | PXRTXCD_CODE | PXRTXCD | (1,1)-(0,n) |
Link between PTRFBEN and PTRBDCA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRFBEN and PTRBDCA (FK1_PTRFBEN_INV_PTRBDCA_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRFBEN | PTRFBEN_BDCA_CODE | PTRBDCA_CODE | PTRBDCA | (1,1)-(0,n) |
Link between PHRJOBS and PTRECLS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PHRJOBS and PTRECLS (FK1_PHRJOBS_INV_PTRECLS_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PHRJOBS | PHRJOBS_ECLS_CODE | PTRECLS_CODE | PTRECLS | (1,1)-(0,n) |
Link between PDRBCOV and PDRBDED| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PDRBCOV and PDRBDED (FK1_PDRBCOV_INV_PDRBDED_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PDRBCOV | PDRBCOV_PIDM | PDRBDED_PIDM | PDRBDED | (1,1)-(0,n) |
| PDRBCOV | PDRBCOV_BDCA_CODE | PDRBDED_BDCA_CODE | PDRBDED | (1,1)-(0,n) |
Link between PERDTOT and PDRBDED| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PERDTOT and PDRBDED (FK1_PERDTOT_INV_PDRBDED_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PERDTOT | PERDTOT_PIDM | PDRBDED_PIDM | PDRBDED | (1,1)-(0,n) |
| PERDTOT | PERDTOT_BDCA_CODE | PDRBDED_BDCA_CODE | PDRBDED | (1,1)-(0,n) |
Link between PERPCRE and PDRBDED| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PERPCRE and PDRBDED (FK1_PERPCRE_INV_PDRBDED_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PERPCRE | PERPCRE_PIDM | PDRBDED_PIDM | PDRBDED | (1,1)-(0,n) |
| PERPCRE | PERPCRE_BDCA_CODE | PDRBDED_BDCA_CODE | PDRBDED | (1,1)-(0,n) |
Link between PHRDEDN and PDRBDED| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PHRDEDN and PDRBDED (FK1_PHRDEDN_INV_PDRBDED_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PHRDEDN | PHRDEDN_PIDM | PDRBDED_PIDM | PDRBDED | (1,1)-(0,n) |
| PHRDEDN | PHRDEDN_BDCA_CODE | PDRBDED_BDCA_CODE | PDRBDED | (1,1)-(0,n) |
Link between PDRBDED and PEBEMPL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PDRBDED and PEBEMPL (FK1_PDRBDED_INV_PEBEMPL_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PDRBDED | PDRBDED_PIDM | PEBEMPL_PIDM | PEBEMPL | (1,1)-(0,n) |
Link between PDRBDED and PTRBDCA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PDRBDED and PTRBDCA (FK1_PDRBDED_INV_PTRBDCA_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PDRBDED | PDRBDED_BDCA_CODE | PTRBDCA_CODE | PTRBDCA | (1,1)-(0,n) |
Link between PXRCALC and PXRTXCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PXRCALC and PXRTXCD (FK1_PXRCALC_INV_PXRTXCD_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PXRCALC | PXRCALC_TXCD_CODE | PXRTXCD_CODE | PXRTXCD | (1,1)-(0,n) |
Link between PHRJACR and PTRPICT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PHRJACR and PTRPICT (FK2_PHRJACR_INV_PTRPICT_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PHRJACR | PHRJACR_PICT_CODE | PTRPICT_CODE | PTRPICT | (1,1)-(0,n) |
Link between PDRXPID and PDRBDED| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PDRXPID and PDRBDED (FK1_PDRXPID_INV_PDRBDED_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PDRXPID | PDRXPID_PIDM | PDRBDED_PIDM | PDRBDED | (1,1)-(0,n) |
| PDRXPID | PDRXPID_BDCA_CODE | PDRBDED_BDCA_CODE | PDRBDED | (1,1)-(0,n) |
Link between PDRXPID and PTRPICT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PDRXPID and PTRPICT (FK1_PDRXPID_INV_PTRPICT_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PDRXPID | PDRXPID_PICT_CODE | PTRPICT_CODE | PTRPICT | (1,1)-(0,n) |
Link between PTRLIFE and PTRBDCA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between PTRLIFE and PTRBDCA (FK1_PTRLIFE_INV_PTRBDCA_KEY) | PAYROLL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| PTRLIFE | PTRLIFE_BDCA_CODE | PTRBDCA_CODE | PTRBDCA | (1,1)-(0,n) |