Model Pay History
| Object Name | Object Type | Layer Name |
|---|---|---|
| PEBEMPL | TABLE | Default |
| PHR1042 | TABLE | Default |
| PHRACCR | TABLE | Default |
| PHRATND | TABLE | Default |
| PHRDEDN | TABLE | Default |
| PHRDOCM | TABLE | Default |
| PHREARN | TABLE | Default |
| PHRELBD | TABLE | Default |
| PHRERRL | TABLE | Default |
| PHRFLSA | TABLE | Default |
| PHRHIST | TABLE | Main Objects |
| PHRHOUR | TABLE | Default |
| PHRJACR | TABLE | Default |
| PHRJOBS | TABLE | Default |
| PHRMTIM | TABLE | Default |
| PHRUICW | TABLE | Default |
| PTRCALN | TABLE | Default |
Table PEBEMPL
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PEBEMPL_PIDM | PEBEMPL_PIDM | NUMBER(8,0) | No | * | * |
| PEBEMPL_EMPL_STATUS | PEBEMPL_EMPL_STATUS | VARCHAR2(1) | No | ||
| PEBEMPL_COAS_CODE_HOME | PEBEMPL_COAS_CODE_HOME | VARCHAR2(1) | Yes | ||
| PEBEMPL_ORGN_CODE_HOME | PEBEMPL_ORGN_CODE_HOME | VARCHAR2(6) | No | * | |
| PEBEMPL_COAS_CODE_DIST | PEBEMPL_COAS_CODE_DIST | VARCHAR2(1) | Yes | ||
| PEBEMPL_ORGN_CODE_DIST | PEBEMPL_ORGN_CODE_DIST | VARCHAR2(6) | No | * | |
| PEBEMPL_ECLS_CODE | PEBEMPL_ECLS_CODE | VARCHAR2(2) | No | * | |
| PEBEMPL_LCAT_CODE | PEBEMPL_LCAT_CODE | VARCHAR2(2) | No | * | |
| PEBEMPL_BCAT_CODE | PEBEMPL_BCAT_CODE | VARCHAR2(2) | No | * | |
| PEBEMPL_FIRST_HIRE_DATE | PEBEMPL_FIRST_HIRE_DATE | DATE | No | ||
| PEBEMPL_CURRENT_HIRE_DATE | PEBEMPL_CURRENT_HIRE_DATE | DATE | No | ||
| PEBEMPL_ADJ_SERVICE_DATE | PEBEMPL_ADJ_SERVICE_DATE | DATE | No | ||
| PEBEMPL_SENIORITY_DATE | PEBEMPL_SENIORITY_DATE | DATE | No | ||
| PEBEMPL_LREA_CODE | PEBEMPL_LREA_CODE | VARCHAR2(2) | Yes | ||
| PEBEMPL_LOA_BEG_DATE | PEBEMPL_LOA_BEG_DATE | DATE | Yes | ||
| PEBEMPL_LOA_END_DATE | PEBEMPL_LOA_END_DATE | DATE | Yes | ||
| PEBEMPL_TREA_CODE | PEBEMPL_TREA_CODE | VARCHAR2(2) | Yes | * | |
| PEBEMPL_TERM_DATE | PEBEMPL_TERM_DATE | DATE | Yes | ||
| PEBEMPL_I9_FORM_IND | PEBEMPL_I9_FORM_IND | VARCHAR2(1) | Yes | ||
| PEBEMPL_I9_DATE | PEBEMPL_I9_DATE | DATE | Yes | ||
| PEBEMPL_I9_EXPIRE_DATE | PEBEMPL_I9_EXPIRE_DATE | DATE | Yes | ||
| PEBEMPL_ACTIVITY_DATE | PEBEMPL_ACTIVITY_DATE | DATE | No | ||
| PEBEMPL_WKPR_CODE | PEBEMPL_WKPR_CODE | VARCHAR2(4) | Yes | * | |
| PEBEMPL_FLSA_IND | PEBEMPL_FLSA_IND | VARCHAR2(1) | No | ||
| PEBEMPL_STGR_CODE | PEBEMPL_STGR_CODE | VARCHAR2(2) | Yes | * | |
| PEBEMPL_DAYS_IN_CANADA | PEBEMPL_DAYS_IN_CANADA | NUMBER(3,0) | Yes | ||
| PEBEMPL_1042_RECIPIENT_CD | PEBEMPL_1042_RECIPIENT_CD | VARCHAR2(2) | Yes | ||
| PEBEMPL_INTERNAL_FT_PT_IND | PEBEMPL_INTERNAL_FT_PT_IND | VARCHAR2(1) | No | ||
| PEBEMPL_DICD_CODE | PEBEMPL_DICD_CODE | VARCHAR2(3) | Yes | ||
| PEBEMPL_EGRP_CODE | PEBEMPL_EGRP_CODE | VARCHAR2(4) | Yes | ||
| PEBEMPL_IPEDS_SOFT_MONEY_IND | PEBEMPL_IPEDS_SOFT_MONEY_IND | VARCHAR2(1) | No | ||
| PEBEMPL_FIRST_WORK_DATE | PEBEMPL_FIRST_WORK_DATE | DATE | Yes | ||
| PEBEMPL_LAST_WORK_DATE | PEBEMPL_LAST_WORK_DATE | DATE | Yes | ||
| PEBEMPL_CALIF_PENSION_IND | PEBEMPL_CALIF_PENSION_IND | VARCHAR2(1) | Yes | ||
| PEBEMPL_NRSI_CODE | PEBEMPL_NRSI_CODE | VARCHAR2(4) | Yes | * | |
| PEBEMPL_SSN_LAST_NAME | PEBEMPL_SSN_LAST_NAME | VARCHAR2(20) | Yes | ||
| PEBEMPL_SSN_FIRST_NAME | PEBEMPL_SSN_FIRST_NAME | VARCHAR2(15) | Yes | ||
| PEBEMPL_SSN_MI | PEBEMPL_SSN_MI | VARCHAR2(15) | Yes | ||
| PEBEMPL_SSN_SUFFIX | PEBEMPL_SSN_SUFFIX | VARCHAR2(4) | Yes | ||
| PEBEMPL_JBLN_CODE | PEBEMPL_JBLN_CODE | VARCHAR2(6) | Yes | * | |
| PEBEMPL_COLL_CODE | PEBEMPL_COLL_CODE | VARCHAR2(2) | Yes | * | |
| PEBEMPL_CAMP_CODE | PEBEMPL_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| PEBEMPL_USER_ID | PEBEMPL_USER_ID | VARCHAR2(30) | Yes | ||
| PEBEMPL_DATA_ORIGIN | PEBEMPL_DATA_ORIGIN | 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_STGR_CODE | PTVSTGR_CODE | PTVSTGR |
| PEBEMPL_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| PEBEMPL_COLL_CODE | STVCOLL_CODE | STVCOLL |
| PEBEMPL_ORGN_CODE_DIST | PTVORGN_CODE | PTVORGN |
| PEBEMPL_WKPR_CODE | PTRWKPR_CODE | PTRWKPR |
| PEBEMPL_PIDM | POTPARM_PIDM | POTPARM |
| PEBEMPL_PIDM | NBRBJOB_PIDM | NBRBJOB |
Index| 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 |