Model ERD Faculty Load
| Object Name | Object Type | Layer Name |
|---|---|---|
| PTRTENR | TABLE | ERD |
| SFRSTCR | TABLE | ERD |
| SIBCFTE | TABLE | Tables |
| SIBFACD | TABLE | Tables |
| SIBFACD_TMP | TABLE | Tables |
| SIBINST | TABLE | Tables |
| SIBTERM | TABLE | Tables |
| SIRASGN | TABLE | Tables |
| SIRATTR | TABLE | Tables |
| SIRCMNT | TABLE | Tables |
| SIRCOLC | TABLE | Tables |
| SIRCOLR | TABLE | Tables |
| SIRDPCL | TABLE | Tables |
| SIRFCNT | TABLE | Tables |
| SIRFLCT | TABLE | Tables |
| SIRFLRC | TABLE | Tables |
| SIRFLRT | TABLE | Tables |
| SIRICNT | TABLE | Tables |
| SIRLVAS | TABLE | Tables |
| SIRNIST | TABLE | Tables |
| SIRNLVA | TABLE | Tables |
| SIROFFC | TABLE | Tables |
| SPRIDEN | TABLE | ERD |
| SSBSECT | TABLE | ERD |
| SSRMEET | TABLE | ERD |
| SSRXLST | TABLE | ERD |
| STVASTY | TABLE | ERD |
| STVCNTR | TABLE | Tables |
| STVCOLL | TABLE | ERD |
| STVDEPT | TABLE | ERD |
| STVFATT | TABLE | ERD |
| STVFCNT | TABLE | ERD |
| STVFCST | TABLE | ERD |
| STVFCTG | TABLE | ERD |
| STVFSTP | TABLE | ERD |
| STVNIST | TABLE | ERD |
| STVTELE | TABLE | ERD |
| STVTOPS | TABLE | ERD |
| STVWKLD | TABLE | ERD |

Table PTRTENR
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| PTRTENR_CODE | PTRTENR_CODE | VARCHAR2(2) | No | * | |
| PTRTENR_DESC | PTRTENR_DESC | VARCHAR2(30) | No | ||
| PTRTENR_DATE_IND | PTRTENR_DATE_IND | VARCHAR2(1) | No | ||
| PTRTENR_REVIEW_DATE_IND | PTRTENR_REVIEW_DATE_IND | VARCHAR2(1) | No | ||
| PTRTENR_EEO_TENURE_IND | PTRTENR_EEO_TENURE_IND | VARCHAR2(1) | No | ||
| PTRTENR_ACTIVITY_DATE | PTRTENR_ACTIVITY_DATE | DATE | No |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_PTRTENR | Unique | PTRTENR_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_PTRTENR | INDEX | S4B70.PAYROLL | Rely on () |
Table SFRSTCR
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SFRSTCR_TERM_CODE | SFRSTCR_TERM_CODE | VARCHAR2(6) | No | * | * |
| SFRSTCR_PIDM | SFRSTCR_PIDM | NUMBER(8,0) | No | * | * |
| SFRSTCR_CRN | SFRSTCR_CRN | VARCHAR2(5) | No | * | * |
| SFRSTCR_CLASS_SORT_KEY | SFRSTCR_CLASS_SORT_KEY | NUMBER(4,0) | Yes | ||
| SFRSTCR_REG_SEQ | SFRSTCR_REG_SEQ | NUMBER(4,0) | No | ||
| SFRSTCR_PTRM_CODE | SFRSTCR_PTRM_CODE | VARCHAR2(3) | Yes | * | |
| SFRSTCR_RSTS_CODE | SFRSTCR_RSTS_CODE | VARCHAR2(2) | Yes | * | |
| SFRSTCR_RSTS_DATE | SFRSTCR_RSTS_DATE | DATE | Yes | ||
| SFRSTCR_ERROR_FLAG | SFRSTCR_ERROR_FLAG | VARCHAR2(1) | Yes | ||
| SFRSTCR_MESSAGE | SFRSTCR_MESSAGE | VARCHAR2(25) | Yes | ||
| SFRSTCR_BILL_HR | SFRSTCR_BILL_HR | NUMBER(7,3) | Yes | ||
| SFRSTCR_WAIV_HR | SFRSTCR_WAIV_HR | NUMBER(7,3) | Yes | ||
| SFRSTCR_CREDIT_HR | SFRSTCR_CREDIT_HR | NUMBER(7,3) | Yes | ||
| SFRSTCR_BILL_HR_HOLD | SFRSTCR_BILL_HR_HOLD | NUMBER(7,3) | Yes | ||
| SFRSTCR_CREDIT_HR_HOLD | SFRSTCR_CREDIT_HR_HOLD | NUMBER(7,3) | Yes | ||
| SFRSTCR_GMOD_CODE | SFRSTCR_GMOD_CODE | VARCHAR2(1) | Yes | * | |
| SFRSTCR_GRDE_CODE | SFRSTCR_GRDE_CODE | VARCHAR2(6) | Yes | ||
| SFRSTCR_GRDE_CODE_MID | SFRSTCR_GRDE_CODE_MID | VARCHAR2(6) | Yes | ||
| SFRSTCR_GRDE_DATE | SFRSTCR_GRDE_DATE | DATE | Yes | ||
| SFRSTCR_DUPL_OVER | SFRSTCR_DUPL_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_LINK_OVER | SFRSTCR_LINK_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_CORQ_OVER | SFRSTCR_CORQ_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_PREQ_OVER | SFRSTCR_PREQ_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_TIME_OVER | SFRSTCR_TIME_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_CAPC_OVER | SFRSTCR_CAPC_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_LEVL_OVER | SFRSTCR_LEVL_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_COLL_OVER | SFRSTCR_COLL_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_MAJR_OVER | SFRSTCR_MAJR_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_CLAS_OVER | SFRSTCR_CLAS_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_APPR_OVER | SFRSTCR_APPR_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_APPR_RECEIVED_IND | SFRSTCR_APPR_RECEIVED_IND | VARCHAR2(1) | Yes | ||
| SFRSTCR_ADD_DATE | SFRSTCR_ADD_DATE | DATE | No | ||
| SFRSTCR_ACTIVITY_DATE | SFRSTCR_ACTIVITY_DATE | DATE | No | ||
| SFRSTCR_LEVL_CODE | SFRSTCR_LEVL_CODE | VARCHAR2(2) | No | * | |
| SFRSTCR_CAMP_CODE | SFRSTCR_CAMP_CODE | VARCHAR2(3) | No | * | |
| SFRSTCR_RESERVED_KEY | SFRSTCR_RESERVED_KEY | VARCHAR2(8) | Yes | ||
| SFRSTCR_ATTEND_HR | SFRSTCR_ATTEND_HR | NUMBER(9,3) | Yes | ||
| SFRSTCR_REPT_OVER | SFRSTCR_REPT_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_RPTH_OVER | SFRSTCR_RPTH_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_TEST_OVER | SFRSTCR_TEST_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_CAMP_OVER | SFRSTCR_CAMP_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_USER | SFRSTCR_USER | VARCHAR2(30) | Yes | ||
| SFRSTCR_DEGC_OVER | SFRSTCR_DEGC_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_PROG_OVER | SFRSTCR_PROG_OVER | VARCHAR2(1) | Yes | ||
| SFRSTCR_LAST_ATTEND | SFRSTCR_LAST_ATTEND | DATE | Yes | ||
| SFRSTCR_GCMT_CODE | SFRSTCR_GCMT_CODE | VARCHAR2(7) | Yes | * | |
| SFRSTCR_DATA_ORIGIN | SFRSTCR_DATA_ORIGIN | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SFRSTCR_RSTS_CODE | STVRSTS_CODE | STVRSTS |
| SFRSTCR_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SFRSTCR_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SFRSTCR_TERM_CODE | STVTERM_CODE | STVTERM |
| SFRSTCR_GMOD_CODE | STVGMOD_CODE | STVGMOD |
| SFRSTCR_PTRM_CODE | STVPTRM_CODE | STVPTRM |
| SFRSTCR_PIDM | SFBETRM_PIDM | SFBETRM |
| SFRSTCR_TERM_CODE | SFBETRM_TERM_CODE | SFBETRM |
| SFRSTCR_GCMT_CODE | STVGCMT_CODE | STVGCMT |
| SFRSTCR_TERM_CODE | RORENRL_TERM_CODE | RORENRL |
| SFRSTCR_PIDM | RORENRL_PIDM | RORENRL |
| SFRSTCR_TERM_CODE | SFRENRL_TERM_CODE | SFRENRL |
| SFRSTCR_PIDM | SFRENRL_PIDM | SFRENRL |
| SFRSTCR_TERM_CODE | SHRGCOM_TERM_CODE | SHRGCOM |
| SFRSTCR_CRN | SHRGCOM_CRN | SHRGCOM |
| SFRSTCR_TERM_CODE | SHRSCOM_TERM_CODE | SHRSCOM |
| SFRSTCR_CRN | SHRSCOM_CRN | SHRSCOM |
| SFRSTCR_TERM_CODE | SSBSECT_TERM_CODE | SSBSECT |
| SFRSTCR_CRN | SSBSECT_CRN | SSBSECT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SFRSTCR | Unique | SFRSTCR_TERM_CODE |
| PK_SFRSTCR | Unique | SFRSTCR_PIDM |
| PK_SFRSTCR | Unique | SFRSTCR_CRN |
| SFRSTCR_INDEX2 | SFRSTCR_TERM_CODE | |
| SFRSTCR_INDEX2 | SFRSTCR_CRN | |
| SFRSTCR_INDEX2 | SFRSTCR_CLASS_SORT_KEY | |
| SFRSTCR_INDEX2 | SFRSTCR_REG_SEQ | |
| SFRSTCR_KEY_INDEX3 | SFRSTCR_PIDM |