Model ERD Academic History
| Object Name | Object Type | Layer Name |
|---|---|---|
| GTVDICD | TABLE | ERD |
| SCBCRSE | TABLE | ERD |
| SDBDEGR | TABLE | ERD |
| SFRENRL | TABLE | ERD |
| SFRSTCR | TABLE | ERD |
| SGBSTDN | TABLE | ERD |
| SHBCATT | TABLE | Tables |
| SHBCGPA | TABLE | Tables |
| SHBCOMI | TABLE | Tables |
| SHBCRMY | TABLE | Tables |
| SHBDIPL | TABLE | Tables |
| SHBGCTL | TABLE | Tables |
| SHBGEDI | TABLE | Tables |
| SHBGRAD | TABLE | Tables |
| SHBGRUL | TABLE | Tables |
| SHBGSCH | TABLE | Tables |
| SHBHEAD | TABLE | Tables |
| SHBOGSC | TABLE | Tables |
| SHBRPTR | TABLE | Tables |
| SHBRPTS | TABLE | Tables |
| SHBRTYP | TABLE | Tables |
| SHBTATC | TABLE | Tables |
| SHBWTRR | TABLE | Tables |
| SHRASDL | TABLE | Tables |
| SHRASES | TABLE | Tables |
| SHRASGE | TABLE | Tables |
| SHRASTR | TABLE | Tables |
| SHRASUM | TABLE | Tables |
| SHRATTC | TABLE | Tables |
| SHRATTR | TABLE | Tables |
| SHRCAPP | TABLE | Tables |
| SHRCAST | TABLE | Tables |
| SHRCATT | TABLE | Tables |
| SHRCCMT | TABLE | Tables |
| SHRCGDR | TABLE | Tables |
| SHRCGPA | TABLE | Tables |
| SHRCHRT | TABLE | Tables |
| SHRCMRK | TABLE | Tables |
| SHRCOMC | TABLE | Tables |
| SHRCOMM | TABLE | Tables |
| SHRCRSR | TABLE | Tables |
| SHRDCMT | TABLE | Tables |
| SHRDGCM | TABLE | Tables |
| SHRDGDH | TABLE | Tables |
| SHRDGIH | TABLE | Tables |
| SHRDGMR | TABLE | Tables |
| SHRDRTM | TABLE | Tables |
| SHREDIS | TABLE | Tables |
| SHREGPA | TABLE | Tables |
| SHREVNT | TABLE | Tables |
| SHRGCOL | TABLE | Tables |
| SHRGCOM | TABLE | Tables |
| SHRGOWN | TABLE | Tables |
| SHRGPAC | TABLE | Tables |
| SHRGPAL | TABLE | Tables |
| SHRGRDE | TABLE | Tables |
| SHRGRDO | TABLE | Tables |
| SHRGRDS | TABLE | Tables |
| SHRGRSC | TABLE | Tables |
| SHRGRUL | TABLE | Tables |
| SHRHDR4 | TABLE | Tables |
| SHRICIP | TABLE | Tables |
| SHRICMT | TABLE | Tables |
| SHRIDEN | TABLE | Tables |
| SHRINST | TABLE | Tables |
| SHRIPDS | TABLE | Tables |
| SHRIPED | TABLE | Tables |
| SHRLGDR | TABLE | Tables |
| SHRLGPA | TABLE | Tables |
| SHRLGSC | TABLE | Tables |
| SHRMRKA | TABLE | Tables |
| SHRMRKS | TABLE | Tables |
| SHRNCRD | TABLE | Tables |
| SHRNCRS | TABLE | Tables |
| SHROGDR | TABLE | Tables |
| SHRPREV | TABLE | Tables |
| SHRPRGE | TABLE | Tables |
| SHRQPND | TABLE | Tables |
| SHRQPNM | TABLE | Tables |
| SHRRDEF | TABLE | Tables |
| SHRRPAR | TABLE | Tables |
| SHRRPEQ | TABLE | Tables |
| SHRSCOM | TABLE | Tables |
| SHRSMRK | TABLE | Tables |
| SHRSRKA | TABLE | Tables |
| SHRSSUM | TABLE | Tables |
| SHRSUMA | TABLE | Tables |
| SHRSUMS | TABLE | Tables |
| SHRTATC | TABLE | Tables |
| SHRTATT | TABLE | Tables |
| SHRTCKD | TABLE | Tables |
| SHRTCKG | TABLE | Tables |
| SHRTCKL | TABLE | Tables |
| SHRTCKN | TABLE | Tables |
| SHRTCMT | TABLE | Tables |
| SHRTGPA | TABLE | Tables |
| SHRTGRD | TABLE | Tables |
| SHRTMCM | TABLE | Tables |
| SHRTPRT | TABLE | Tables |
| SHRTRAM | TABLE | Tables |
| SHRTRAT | TABLE | Tables |
| SHRTRCD | TABLE | Tables |
| SHRTRCE | TABLE | Tables |
| SHRTRCR | TABLE | Tables |
| SHRTREP | TABLE | Tables |
| SHRTRIT | TABLE | Tables |
| SHRTRPO | TABLE | Tables |
| SHRTRSS | TABLE | Tables |
| SHRTRTA | TABLE | Tables |
| SHRTRTK | TABLE | Tables |
| SHRTTCM | TABLE | Tables |
| SHRTTRM | TABLE | Tables |
| SHTIACT | TABLE | Tables |
| SHTTRAN | TABLE | Tables |
| SHTTRTC | TABLE | Tables |
| SMRPRLE | TABLE | ERD |
| SOBCURR | TABLE | ERD |
| SORCCON | TABLE | ERD |
| SORCMJR | TABLE | ERD |
| SORCMNR | TABLE | ERD |
| SPBPERS | TABLE | ERD |
| SPRIDEN | TABLE | ERD |
| SSBSECT | TABLE | ERD |

Table GTVDICD
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVDICD_CODE | GTVDICD_CODE | VARCHAR2(3) | No | * | |
| GTVDICD_DESC | GTVDICD_DESC | VARCHAR2(30) | No | ||
| GTVDICD_ACTIVITY_DATE | GTVDICD_ACTIVITY_DATE | DATE | No |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVDICD | Unique | GTVDICD_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVDICD | INDEX | S4B70."GENERAL" | Rely on () |
Table SCBCRSE
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SCBCRSE_SUBJ_CODE | SCBCRSE_SUBJ_CODE | VARCHAR2(4) | No | * | |
| SCBCRSE_CRSE_NUMB | SCBCRSE_CRSE_NUMB | VARCHAR2(5) | No | * | |
| SCBCRSE_EFF_TERM | SCBCRSE_EFF_TERM | VARCHAR2(6) | Yes | * | |
| SCBCRSE_COLL_CODE | SCBCRSE_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SCBCRSE_DIVS_CODE | SCBCRSE_DIVS_CODE | VARCHAR2(4) | Yes | * | |
| SCBCRSE_DEPT_CODE | SCBCRSE_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SCBCRSE_CSTA_CODE | SCBCRSE_CSTA_CODE | VARCHAR2(1) | Yes | * | |
| SCBCRSE_TITLE | SCBCRSE_TITLE | VARCHAR2(30) | Yes | ||
| SCBCRSE_CIPC_CODE | SCBCRSE_CIPC_CODE | VARCHAR2(6) | Yes | * | |
| SCBCRSE_CREDIT_HR_IND | SCBCRSE_CREDIT_HR_IND | VARCHAR2(2) | Yes | ||
| SCBCRSE_CREDIT_HR_LOW | SCBCRSE_CREDIT_HR_LOW | NUMBER(7,3) | Yes | ||
| SCBCRSE_CREDIT_HR_HIGH | SCBCRSE_CREDIT_HR_HIGH | NUMBER(7,3) | Yes | ||
| SCBCRSE_LEC_HR_IND | SCBCRSE_LEC_HR_IND | VARCHAR2(2) | Yes | ||
| SCBCRSE_LEC_HR_LOW | SCBCRSE_LEC_HR_LOW | NUMBER(7,3) | Yes | ||
| SCBCRSE_LEC_HR_HIGH | SCBCRSE_LEC_HR_HIGH | NUMBER(7,3) | Yes | ||
| SCBCRSE_LAB_HR_IND | SCBCRSE_LAB_HR_IND | VARCHAR2(2) | Yes | ||
| SCBCRSE_LAB_HR_LOW | SCBCRSE_LAB_HR_LOW | NUMBER(7,3) | Yes | ||
| SCBCRSE_LAB_HR_HIGH | SCBCRSE_LAB_HR_HIGH | NUMBER(7,3) | Yes | ||
| SCBCRSE_OTH_HR_IND | SCBCRSE_OTH_HR_IND | VARCHAR2(2) | Yes | ||
| SCBCRSE_OTH_HR_LOW | SCBCRSE_OTH_HR_LOW | NUMBER(7,3) | Yes | ||
| SCBCRSE_OTH_HR_HIGH | SCBCRSE_OTH_HR_HIGH | NUMBER(7,3) | Yes | ||
| SCBCRSE_BILL_HR_IND | SCBCRSE_BILL_HR_IND | VARCHAR2(2) | Yes | ||
| SCBCRSE_BILL_HR_LOW | SCBCRSE_BILL_HR_LOW | NUMBER(7,3) | Yes | ||
| SCBCRSE_BILL_HR_HIGH | SCBCRSE_BILL_HR_HIGH | NUMBER(7,3) | Yes | ||
| SCBCRSE_APRV_CODE | SCBCRSE_APRV_CODE | VARCHAR2(1) | Yes | * | |
| SCBCRSE_REPEAT_LIMIT | SCBCRSE_REPEAT_LIMIT | NUMBER(2,0) | Yes | ||
| SCBCRSE_PWAV_CODE | SCBCRSE_PWAV_CODE | VARCHAR2(1) | Yes | * | |
| SCBCRSE_TUIW_IND | SCBCRSE_TUIW_IND | VARCHAR2(1) | Yes | ||
| SCBCRSE_ADD_FEES_IND | SCBCRSE_ADD_FEES_IND | VARCHAR2(1) | Yes | ||
| SCBCRSE_ACTIVITY_DATE | SCBCRSE_ACTIVITY_DATE | DATE | Yes | ||
| SCBCRSE_CONT_HR_LOW | SCBCRSE_CONT_HR_LOW | NUMBER(7,3) | Yes | ||
| SCBCRSE_CONT_HR_IND | SCBCRSE_CONT_HR_IND | VARCHAR2(2) | Yes | ||
| SCBCRSE_CONT_HR_HIGH | SCBCRSE_CONT_HR_HIGH | NUMBER(7,3) | Yes | ||
| SCBCRSE_CEU_IND | SCBCRSE_CEU_IND | VARCHAR2(1) | Yes | ||
| SCBCRSE_REPS_CODE | SCBCRSE_REPS_CODE | VARCHAR2(2) | Yes | * | |
| SCBCRSE_MAX_RPT_UNITS | SCBCRSE_MAX_RPT_UNITS | NUMBER(9,3) | Yes | ||
| SCBCRSE_CAPP_PREREQ_TEST_IND | SCBCRSE_CAPP_PREREQ_TEST_IND | VARCHAR2(1) | No | ||
| SCBCRSE_DUNT_CODE | SCBCRSE_DUNT_CODE | VARCHAR2(4) | Yes | * | |
| SCBCRSE_NUMBER_OF_UNITS | SCBCRSE_NUMBER_OF_UNITS | NUMBER(7,2) | Yes | ||
| SCBCRSE_DATA_ORIGIN | SCBCRSE_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SCBCRSE_USER_ID | SCBCRSE_USER_ID | VARCHAR2(30) | Yes |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SCBCRSE_KEY_INDEX | Unique | SCBCRSE_SUBJ_CODE |
| SCBCRSE_KEY_INDEX | Unique | SCBCRSE_CRSE_NUMB |
| SCBCRSE_KEY_INDEX | Unique | SCBCRSE_EFF_TERM |