Model General_Student_ERD
| Object Name | Object Type | Layer Name |
|---|---|---|
| EXCEPTIONS | TABLE | Tables |
| SABAUDF | TABLE | Tables |
| SFRMHRS | TABLE | ERD |
| SGBEOPS | TABLE | Tables |
| SGBOEDU | TABLE | Tables |
| SGBSTDN | TABLE | Tables |
| SGBUSER | TABLE | Tables |
| SGRACMT | TABLE | Tables |
| SGRADVR | TABLE | Tables |
| SGRASSI | TABLE | Tables |
| SGRASST | TABLE | Tables |
| SGRCATT | TABLE | Tables |
| SGRCHRT | TABLE | Tables |
| SGRCLSR | TABLE | Tables |
| SGRCMNT | TABLE | Tables |
| SGRCOLR | TABLE | Tables |
| SGRCOOP | TABLE | Tables |
| SGRDISA | TABLE | Tables |
| SGRDSER | TABLE | Tables |
| SGRDUTY | TABLE | Tables |
| SGRESEL | TABLE | Tables |
| SGRSACT | TABLE | Tables |
| SGRSATT | TABLE | Tables |
| SGRSCMT | TABLE | Tables |
| SGRSPRT | TABLE | Tables |
| SGRVETN | TABLE | Tables |
| SHRLGPA | TABLE | ERD |
| SHRTTRM | TABLE | ERD |
| SMRPRLE | TABLE | ERD |
| SOBCURR | TABLE | ERD |
| SORCCON | TABLE | ERD |
| SORCMJR | TABLE | ERD |
| SORCMNR | TABLE | ERD |
| SPBPERS | TABLE | ERD |
| SPRIDEN | TABLE | ERD |
| STVACTC | TABLE | ERD |
| STVACYR | TABLE | ERD |
| STVADMT | TABLE | ERD |
| STVADVR | TABLE | ERD |
| STVAFDC | TABLE | ERD |
| STVAPRN | TABLE | ERD |
| STVASTD | TABLE | ERD |
| STVATTS | TABLE | ERD |
| STVBLCK | TABLE | ERD |
| STVBSKL | TABLE | ERD |
| STVCAMP | TABLE | ERD |
| STVCAPL | TABLE | ERD |
| STVCAST | TABLE | ERD |
| STVCHRT | TABLE | ERD |
| STVCLAS | TABLE | ERD |
| STVCOLL | TABLE | ERD |
| STVCOPC | TABLE | ERD |
| STVCREA | TABLE | ERD |
| STVDEPS | TABLE | ERD |
| STVDISA | TABLE | ERD |
| STVDLEV | TABLE | ERD |
| STVEDLV | TABLE | ERD |
| STVEGOL | TABLE | ERD |
| STVELIG | TABLE | ERD |
| STVEMEX | TABLE | ERD |
| STVEMPL | TABLE | ERD |
| STVEOPS | TABLE | ERD |
| STVESEL | TABLE | ERD |
| STVGAIN | TABLE | ERD |
| STVGSTA | TABLE | ERD |
| STVGTYP | TABLE | ERD |
| STVINCM | TABLE | ERD |
| STVLEAV | TABLE | ERD |
| STVLEVL | TABLE | ERD |
| STVMARS | TABLE | ERD |
| STVMEDI | TABLE | ERD |
| STVORIG | TABLE | ERD |
| STVORSN | TABLE | ERD |
| STVPRAC | TABLE | ERD |
| STVPREV | TABLE | ERD |
| STVRATE | TABLE | ERD |
| STVRESD | TABLE | ERD |
| STVSEPR | TABLE | ERD |
| STVSESS | TABLE | ERD |
| STVSFAE | TABLE | ERD |
| STVSITE | TABLE | ERD |
| STVSOFF | TABLE | ERD |
| STVSPRV | TABLE | ERD |
| STVSPSR | TABLE | ERD |
| STVSPST | TABLE | ERD |
| STVSSEP | TABLE | ERD |
| STVSSER | TABLE | ERD |
| STVSSRS | TABLE | ERD |
| STVSSST | TABLE | ERD |
| STVSTST | TABLE | ERD |
| STVSTYP | TABLE | ERD |
| STVSUDA | TABLE | ERD |
| STVSUDB | TABLE | ERD |
| STVSUDC | TABLE | ERD |
| STVSUDD | TABLE | ERD |
| STVSUDE | TABLE | ERD |
| STVSUDF | TABLE | ERD |
| STVSUDG | TABLE | ERD |
| STVSUDH | TABLE | ERD |
| STVSUDI | TABLE | ERD |
| STVSUDJ | TABLE | ERD |
| STVTASK | TABLE | ERD |
| STVTRCN | TABLE | ERD |
| STVVETC | TABLE | ERD |
| STVVOED | TABLE | ERD |
| STVWTHD | TABLE | ERD |
Table EXCEPTIONS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| ROW_ID | ROW_ID | ROWID | Yes | ||
| OWNER | OWNER | VARCHAR2(30) | Yes | ||
| TABLE_NAME | TABLE_NAME | VARCHAR2(30) | Yes | ||
| CONSTRAINT | CONSTRAINT | VARCHAR2(30) | Yes |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table SABAUDF| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SABAUDF_TERM_CODE_EFF | SABAUDF_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SABAUDF_FLAG1_DESC | SABAUDF_FLAG1_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_FLAG2_DESC | SABAUDF_FLAG2_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_FLAG3_DESC | SABAUDF_FLAG3_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_FLAG4_DESC | SABAUDF_FLAG4_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_FLAG5_DESC | SABAUDF_FLAG5_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_FLAG6_DESC | SABAUDF_FLAG6_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_FLAG7_DESC | SABAUDF_FLAG7_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_FLAG8_DESC | SABAUDF_FLAG8_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_FLAG9_DESC | SABAUDF_FLAG9_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_FLAG10_DESC | SABAUDF_FLAG10_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA1_DESC | SABAUDF_DATA1_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA2_DESC | SABAUDF_DATA2_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA3_DESC | SABAUDF_DATA3_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA4_DESC | SABAUDF_DATA4_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA5_DESC | SABAUDF_DATA5_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA6_DESC | SABAUDF_DATA6_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA7_DESC | SABAUDF_DATA7_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA8_DESC | SABAUDF_DATA8_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA9_DESC | SABAUDF_DATA9_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA10_DESC | SABAUDF_DATA10_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA11_DESC | SABAUDF_DATA11_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA12_DESC | SABAUDF_DATA12_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA13_DESC | SABAUDF_DATA13_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA14_DESC | SABAUDF_DATA14_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA15_DESC | SABAUDF_DATA15_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA16_DESC | SABAUDF_DATA16_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA17_DESC | SABAUDF_DATA17_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA18_DESC | SABAUDF_DATA18_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA19_DESC | SABAUDF_DATA19_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_DATA20_DESC | SABAUDF_DATA20_DESC | VARCHAR2(20) | Yes | ||
| SABAUDF_ACTIVITY_DATE | SABAUDF_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SABAUDF_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SABAUDF | Unique | SABAUDF_TERM_CODE_EFF |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table SFRMHRS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SFRMHRS_TERM_CODE | SFRMHRS_TERM_CODE | VARCHAR2(6) | No | * | * |
| SFRMHRS_LEVL_CODE | SFRMHRS_LEVL_CODE | VARCHAR2(2) | No | * | * |
| SFRMHRS_MAX_HRS | SFRMHRS_MAX_HRS | NUMBER(9,3) | No | ||
| SFRMHRS_ACTIVITY_DATE | SFRMHRS_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SFRMHRS_TERM_CODE | STVTERM_CODE | STVTERM |
| SFRMHRS_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SFRMHRS_TERM_CODE | SOBTERM_TERM_CODE | SOBTERM |
| SFRMHRS_LEVL_CODE | SGBSTDN_LEVL_CODE | SGBSTDN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SFRMHRS | Unique | SFRMHRS_TERM_CODE |
| PK_SFRMHRS | Unique | SFRMHRS_LEVL_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table SGBEOPS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGBEOPS_PIDM | SGBEOPS_PIDM | NUMBER(8,0) | No | * | |
| SGBEOPS_TERM_CODE_EFF | SGBEOPS_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SGBEOPS_EOPS_CODE | SGBEOPS_EOPS_CODE | VARCHAR2(2) | Yes | * | |
| SGBEOPS_ACCEPT_DATE | SGBEOPS_ACCEPT_DATE | DATE | Yes | ||
| SGBEOPS_SFAE_CODE | SGBEOPS_SFAE_CODE | VARCHAR2(2) | Yes | * | |
| SGBEOPS_ACTIVITY_DATE | SGBEOPS_ACTIVITY_DATE | DATE | No | ||
| SGBEOPS_TRAC_CODE | SGBEOPS_TRAC_CODE | VARCHAR2(3) | Yes | ||
| SGBEOPS_PLANNED_CREDITS | SGBEOPS_PLANNED_CREDITS | NUMBER(9,3) | Yes | ||
| SGBEOPS_WTHD_CODE | SGBEOPS_WTHD_CODE | VARCHAR2(1) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGBEOPS_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SGBEOPS_WTHD_CODE | STVWTHD_CODE | STVWTHD |
| SGBEOPS_EOPS_CODE | STVEOPS_CODE | STVEOPS |
| SGBEOPS_SFAE_CODE | STVSFAE_CODE | STVSFAE |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SGBEOPS | Unique | SGBEOPS_PIDM |
| PK_SGBEOPS | Unique | SGBEOPS_TERM_CODE_EFF |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table SGBOEDU| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGBOEDU_PIDM | SGBOEDU_PIDM | NUMBER(8,0) | No | ||
| SGBOEDU_TERM_CODE_EFF | SGBOEDU_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SGBOEDU_EOPS_CODE | SGBOEDU_EOPS_CODE | VARCHAR2(2) | Yes | * | |
| SGBOEDU_SFAE_CODE | SGBOEDU_SFAE_CODE | VARCHAR2(2) | Yes | * | |
| SGBOEDU_ACCEPT_DATE | SGBOEDU_ACCEPT_DATE | DATE | Yes | ||
| SGBOEDU_TRAC_CODE | SGBOEDU_TRAC_CODE | VARCHAR2(3) | Yes | ||
| SGBOEDU_PLANNED_CREDITS | SGBOEDU_PLANNED_CREDITS | NUMBER(9,3) | Yes | ||
| SGBOEDU_ACTIVITY_DATE | SGBOEDU_ACTIVITY_DATE | DATE | No | ||
| SGBOEDU_MARS_CODE | SGBOEDU_MARS_CODE | VARCHAR2(1) | Yes | * | |
| SGBOEDU_DEPS_CODE | SGBOEDU_DEPS_CODE | VARCHAR2(1) | Yes | * | |
| SGBOEDU_AFDC_CODE | SGBOEDU_AFDC_CODE | VARCHAR2(1) | Yes | * | |
| SGBOEDU_WTHD_CODE | SGBOEDU_WTHD_CODE | VARCHAR2(1) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGBOEDU_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SGBOEDU_EOPS_CODE | STVEOPS_CODE | STVEOPS |
| SGBOEDU_SFAE_CODE | STVSFAE_CODE | STVSFAE |
| SGBOEDU_AFDC_CODE | STVAFDC_CODE | STVAFDC |
| SGBOEDU_DEPS_CODE | STVDEPS_CODE | STVDEPS |
| SGBOEDU_WTHD_CODE | STVWTHD_CODE | STVWTHD |
| SGBOEDU_MARS_CODE | STVMARS_CODE | STVMARS |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGBOEDU_KEY_INDEX | Unique | SGBOEDU_PIDM |
| SGBOEDU_KEY_INDEX | Unique | SGBOEDU_TERM_CODE_EFF |
| SGBOEDU_KEY_INDEX | Unique | SGBOEDU_EOPS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table SGBSTDN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGBSTDN_PIDM | SGBSTDN_PIDM | NUMBER(8,0) | No | * | * |
| SGBSTDN_TERM_CODE_EFF | SGBSTDN_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SGBSTDN_STST_CODE | SGBSTDN_STST_CODE | VARCHAR2(2) | No | * | |
| SGBSTDN_LEVL_CODE | SGBSTDN_LEVL_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_STYP_CODE | SGBSTDN_STYP_CODE | VARCHAR2(1) | No | * | |
| SGBSTDN_TERM_CODE_MATRIC | SGBSTDN_TERM_CODE_MATRIC | VARCHAR2(6) | Yes | * | |
| SGBSTDN_TERM_CODE_ADMIT | SGBSTDN_TERM_CODE_ADMIT | VARCHAR2(6) | Yes | * | |
| SGBSTDN_EXP_GRAD_DATE | SGBSTDN_EXP_GRAD_DATE | DATE | Yes | ||
| SGBSTDN_CAMP_CODE | SGBSTDN_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SGBSTDN_FULL_PART_IND | SGBSTDN_FULL_PART_IND | VARCHAR2(1) | Yes | ||
| SGBSTDN_SESS_CODE | SGBSTDN_SESS_CODE | VARCHAR2(1) | Yes | * | |
| SGBSTDN_RESD_CODE | SGBSTDN_RESD_CODE | VARCHAR2(1) | Yes | * | |
| SGBSTDN_COLL_CODE_1 | SGBSTDN_COLL_CODE_1 | VARCHAR2(2) | Yes | * | |
| SGBSTDN_DEGC_CODE_1 | SGBSTDN_DEGC_CODE_1 | VARCHAR2(6) | Yes | * | |
| SGBSTDN_MAJR_CODE_1 | SGBSTDN_MAJR_CODE_1 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_MINR_1 | SGBSTDN_MAJR_CODE_MINR_1 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_MINR_1_2 | SGBSTDN_MAJR_CODE_MINR_1_2 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_CONC_1 | SGBSTDN_MAJR_CODE_CONC_1 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_CONC_1_2 | SGBSTDN_MAJR_CODE_CONC_1_2 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_CONC_1_3 | SGBSTDN_MAJR_CODE_CONC_1_3 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_COLL_CODE_2 | SGBSTDN_COLL_CODE_2 | VARCHAR2(2) | Yes | * | |
| SGBSTDN_DEGC_CODE_2 | SGBSTDN_DEGC_CODE_2 | VARCHAR2(6) | Yes | * | |
| SGBSTDN_MAJR_CODE_2 | SGBSTDN_MAJR_CODE_2 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_MINR_2 | SGBSTDN_MAJR_CODE_MINR_2 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_MINR_2_2 | SGBSTDN_MAJR_CODE_MINR_2_2 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_CONC_2 | SGBSTDN_MAJR_CODE_CONC_2 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_CONC_2_2 | SGBSTDN_MAJR_CODE_CONC_2_2 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_CONC_2_3 | SGBSTDN_MAJR_CODE_CONC_2_3 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_ORSN_CODE | SGBSTDN_ORSN_CODE | VARCHAR2(1) | Yes | * | |
| SGBSTDN_PRAC_CODE | SGBSTDN_PRAC_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_ADVR_PIDM | SGBSTDN_ADVR_PIDM | NUMBER(8,0) | Yes | ||
| SGBSTDN_GRAD_CREDIT_APPR_IND | SGBSTDN_GRAD_CREDIT_APPR_IND | VARCHAR2(1) | Yes | ||
| SGBSTDN_CAPL_CODE | SGBSTDN_CAPL_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_LEAV_CODE | SGBSTDN_LEAV_CODE | VARCHAR2(1) | Yes | * | |
| SGBSTDN_LEAV_FROM_DATE | SGBSTDN_LEAV_FROM_DATE | DATE | Yes | ||
| SGBSTDN_LEAV_TO_DATE | SGBSTDN_LEAV_TO_DATE | DATE | Yes | ||
| SGBSTDN_ASTD_CODE | SGBSTDN_ASTD_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_TERM_CODE_ASTD | SGBSTDN_TERM_CODE_ASTD | VARCHAR2(6) | Yes | * | |
| SGBSTDN_RATE_CODE | SGBSTDN_RATE_CODE | VARCHAR2(5) | Yes | * | |
| SGBSTDN_ACTIVITY_DATE | SGBSTDN_ACTIVITY_DATE | DATE | No | ||
| SGBSTDN_MAJR_CODE_1_2 | SGBSTDN_MAJR_CODE_1_2 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_2_2 | SGBSTDN_MAJR_CODE_2_2 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_EDLV_CODE | SGBSTDN_EDLV_CODE | VARCHAR2(3) | Yes | * | |
| SGBSTDN_INCM_CODE | SGBSTDN_INCM_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_ADMT_CODE | SGBSTDN_ADMT_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_EMEX_CODE | SGBSTDN_EMEX_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_APRN_CODE | SGBSTDN_APRN_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_TRCN_CODE | SGBSTDN_TRCN_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_GAIN_CODE | SGBSTDN_GAIN_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_VOED_CODE | SGBSTDN_VOED_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_BLCK_CODE | SGBSTDN_BLCK_CODE | VARCHAR2(10) | Yes | * | |
| SGBSTDN_TERM_CODE_GRAD | SGBSTDN_TERM_CODE_GRAD | VARCHAR2(6) | Yes | * | |
| SGBSTDN_ACYR_CODE | SGBSTDN_ACYR_CODE | VARCHAR2(4) | Yes | * | |
| SGBSTDN_DEPT_CODE | SGBSTDN_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SGBSTDN_SITE_CODE | SGBSTDN_SITE_CODE | VARCHAR2(3) | Yes | * | |
| SGBSTDN_DEPT_CODE_2 | SGBSTDN_DEPT_CODE_2 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_EGOL_CODE | SGBSTDN_EGOL_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_DEGC_CODE_DUAL | SGBSTDN_DEGC_CODE_DUAL | VARCHAR2(6) | Yes | * | |
| SGBSTDN_LEVL_CODE_DUAL | SGBSTDN_LEVL_CODE_DUAL | VARCHAR2(2) | Yes | * | |
| SGBSTDN_DEPT_CODE_DUAL | SGBSTDN_DEPT_CODE_DUAL | VARCHAR2(4) | Yes | * | |
| SGBSTDN_COLL_CODE_DUAL | SGBSTDN_COLL_CODE_DUAL | VARCHAR2(2) | Yes | * | |
| SGBSTDN_MAJR_CODE_DUAL | SGBSTDN_MAJR_CODE_DUAL | VARCHAR2(4) | Yes | * | |
| SGBSTDN_BSKL_CODE | SGBSTDN_BSKL_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_PRIM_ROLL_IND | SGBSTDN_PRIM_ROLL_IND | VARCHAR2(1) | Yes | ||
| SGBSTDN_PROGRAM_1 | SGBSTDN_PROGRAM_1 | VARCHAR2(12) | Yes | * | |
| SGBSTDN_TERM_CODE_CTLG_1 | SGBSTDN_TERM_CODE_CTLG_1 | VARCHAR2(6) | Yes | * | |
| SGBSTDN_DEPT_CODE_1_2 | SGBSTDN_DEPT_CODE_1_2 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_CONC_121 | SGBSTDN_MAJR_CODE_CONC_121 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_CONC_122 | SGBSTDN_MAJR_CODE_CONC_122 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_CONC_123 | SGBSTDN_MAJR_CODE_CONC_123 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_SECD_ROLL_IND | SGBSTDN_SECD_ROLL_IND | VARCHAR2(1) | Yes | ||
| SGBSTDN_TERM_CODE_ADMIT_2 | SGBSTDN_TERM_CODE_ADMIT_2 | VARCHAR2(6) | Yes | * | |
| SGBSTDN_ADMT_CODE_2 | SGBSTDN_ADMT_CODE_2 | VARCHAR2(2) | Yes | * | |
| SGBSTDN_PROGRAM_2 | SGBSTDN_PROGRAM_2 | VARCHAR2(12) | Yes | * | |
| SGBSTDN_TERM_CODE_CTLG_2 | SGBSTDN_TERM_CODE_CTLG_2 | VARCHAR2(6) | Yes | * | |
| SGBSTDN_LEVL_CODE_2 | SGBSTDN_LEVL_CODE_2 | VARCHAR2(2) | Yes | * | |
| SGBSTDN_CAMP_CODE_2 | SGBSTDN_CAMP_CODE_2 | VARCHAR2(3) | Yes | * | |
| SGBSTDN_DEPT_CODE_2_2 | SGBSTDN_DEPT_CODE_2_2 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_CONC_221 | SGBSTDN_MAJR_CODE_CONC_221 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_CONC_222 | SGBSTDN_MAJR_CODE_CONC_222 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_MAJR_CODE_CONC_223 | SGBSTDN_MAJR_CODE_CONC_223 | VARCHAR2(4) | Yes | * | |
| SGBSTDN_CURR_RULE_1 | SGBSTDN_CURR_RULE_1 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CMJR_RULE_1_1 | SGBSTDN_CMJR_RULE_1_1 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CCON_RULE_11_1 | SGBSTDN_CCON_RULE_11_1 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CCON_RULE_11_2 | SGBSTDN_CCON_RULE_11_2 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CCON_RULE_11_3 | SGBSTDN_CCON_RULE_11_3 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CMJR_RULE_1_2 | SGBSTDN_CMJR_RULE_1_2 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CCON_RULE_12_1 | SGBSTDN_CCON_RULE_12_1 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CCON_RULE_12_2 | SGBSTDN_CCON_RULE_12_2 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CCON_RULE_12_3 | SGBSTDN_CCON_RULE_12_3 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CMNR_RULE_1_1 | SGBSTDN_CMNR_RULE_1_1 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CMNR_RULE_1_2 | SGBSTDN_CMNR_RULE_1_2 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CURR_RULE_2 | SGBSTDN_CURR_RULE_2 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CMJR_RULE_2_1 | SGBSTDN_CMJR_RULE_2_1 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CCON_RULE_21_1 | SGBSTDN_CCON_RULE_21_1 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CCON_RULE_21_2 | SGBSTDN_CCON_RULE_21_2 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CCON_RULE_21_3 | SGBSTDN_CCON_RULE_21_3 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CMJR_RULE_2_2 | SGBSTDN_CMJR_RULE_2_2 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CCON_RULE_22_1 | SGBSTDN_CCON_RULE_22_1 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CCON_RULE_22_2 | SGBSTDN_CCON_RULE_22_2 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CCON_RULE_22_3 | SGBSTDN_CCON_RULE_22_3 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CMNR_RULE_2_1 | SGBSTDN_CMNR_RULE_2_1 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_CMNR_RULE_2_2 | SGBSTDN_CMNR_RULE_2_2 | NUMBER(8,0) | Yes | * | |
| SGBSTDN_PREV_CODE | SGBSTDN_PREV_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_TERM_CODE_PREV | SGBSTDN_TERM_CODE_PREV | VARCHAR2(6) | Yes | * | |
| SGBSTDN_CAST_CODE | SGBSTDN_CAST_CODE | VARCHAR2(2) | Yes | * | |
| SGBSTDN_TERM_CODE_CAST | SGBSTDN_TERM_CODE_CAST | VARCHAR2(6) | Yes | * | |
| SGBSTDN_DATA_ORIGIN | SGBSTDN_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SGBSTDN_USER_ID | SGBSTDN_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGBSTDN_TERM_CODE_ASTD | STVTERM_CODE | STVTERM |
| SGBSTDN_TERM_CODE_CTLG_2 | STVTERM_CODE | STVTERM |
| SGBSTDN_TERM_CODE_ADMIT_2 | STVTERM_CODE | STVTERM |
| SGBSTDN_TERM_CODE_CTLG_1 | STVTERM_CODE | STVTERM |
| SGBSTDN_TERM_CODE_MATRIC | STVTERM_CODE | STVTERM |
| SGBSTDN_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SGBSTDN_TERM_CODE_ADMIT | STVTERM_CODE | STVTERM |
| SGBSTDN_TERM_CODE_GRAD | STVTERM_CODE | STVTERM |
| SGBSTDN_TERM_CODE_PREV | STVTERM_CODE | STVTERM |
| SGBSTDN_TERM_CODE_CAST | STVTERM_CODE | STVTERM |
| SGBSTDN_VOED_CODE | STVVOED_CODE | STVVOED |
| SGBSTDN_CMNR_RULE_1_1 | SORCMNR_CMNR_RULE | SORCMNR |
| SGBSTDN_CMNR_RULE_2_2 | SORCMNR_CMNR_RULE | SORCMNR |
| SGBSTDN_CMNR_RULE_2_1 | SORCMNR_CMNR_RULE | SORCMNR |
| SGBSTDN_CMNR_RULE_1_2 | SORCMNR_CMNR_RULE | SORCMNR |
| SGBSTDN_LEVL_CODE_2 | STVLEVL_CODE | STVLEVL |
| SGBSTDN_LEVL_CODE_DUAL | STVLEVL_CODE | STVLEVL |
| SGBSTDN_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SGBSTDN_APRN_CODE | STVAPRN_CODE | STVAPRN |
| SGBSTDN_PREV_CODE | STVPREV_CODE | STVPREV |
| SGBSTDN_SITE_CODE | STVSITE_CODE | STVSITE |
| SGBSTDN_EDLV_CODE | STVEDLV_CODE | STVEDLV |
| SGBSTDN_CMJR_RULE_1_2 | SORCMJR_CMJR_RULE | SORCMJR |
| SGBSTDN_CMJR_RULE_2_2 | SORCMJR_CMJR_RULE | SORCMJR |
| SGBSTDN_CMJR_RULE_2_1 | SORCMJR_CMJR_RULE | SORCMJR |
| SGBSTDN_CMJR_RULE_1_1 | SORCMJR_CMJR_RULE | SORCMJR |
| SGBSTDN_PRAC_CODE | STVPRAC_CODE | STVPRAC |
| SGBSTDN_LEAV_CODE | STVLEAV_CODE | STVLEAV |
| SGBSTDN_BSKL_CODE | STVBSKL_CODE | STVBSKL |
| SGBSTDN_CAMP_CODE_2 | STVCAMP_CODE | STVCAMP |
| SGBSTDN_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SGBSTDN_PROGRAM_2 | SMRPRLE_PROGRAM | SMRPRLE |
| SGBSTDN_PROGRAM_1 | SMRPRLE_PROGRAM | SMRPRLE |
| SGBSTDN_CCON_RULE_22_1 | SORCCON_CCON_RULE | SORCCON |
| SGBSTDN_CCON_RULE_22_2 | SORCCON_CCON_RULE | SORCCON |
| SGBSTDN_CCON_RULE_22_3 | SORCCON_CCON_RULE | SORCCON |
| SGBSTDN_CCON_RULE_11_1 | SORCCON_CCON_RULE | SORCCON |
| SGBSTDN_CCON_RULE_11_2 | SORCCON_CCON_RULE | SORCCON |
| SGBSTDN_CCON_RULE_12_1 | SORCCON_CCON_RULE | SORCCON |
| SGBSTDN_CCON_RULE_12_2 | SORCCON_CCON_RULE | SORCCON |
| SGBSTDN_CCON_RULE_12_3 | SORCCON_CCON_RULE | SORCCON |
| SGBSTDN_CCON_RULE_21_1 | SORCCON_CCON_RULE | SORCCON |
| SGBSTDN_CCON_RULE_21_2 | SORCCON_CCON_RULE | SORCCON |
| SGBSTDN_CCON_RULE_21_3 | SORCCON_CCON_RULE | SORCCON |
| SGBSTDN_CCON_RULE_11_3 | SORCCON_CCON_RULE | SORCCON |
| SGBSTDN_MAJR_CODE_MINR_2 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_MINR_2_2 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_CONC_2 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_CONC_2_2 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_CONC_2_3 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_DUAL | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_CONC_121 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_CONC_122 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_CONC_123 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_CONC_221 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_1_2 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_CONC_222 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_CONC_223 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_2_2 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_1 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_MINR_1 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_MINR_1_2 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_CONC_1 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_CONC_1_2 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_CONC_1_3 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_MAJR_CODE_2 | STVMAJR_CODE | STVMAJR |
| SGBSTDN_CURR_RULE_1 | SOBCURR_CURR_RULE | SOBCURR |
| SGBSTDN_CURR_RULE_2 | SOBCURR_CURR_RULE | SOBCURR |
| SGBSTDN_ACYR_CODE | STVACYR_CODE | STVACYR |
| SGBSTDN_ADMT_CODE | STVADMT_CODE | STVADMT |
| SGBSTDN_ADMT_CODE_2 | STVADMT_CODE | STVADMT |
| SGBSTDN_ASTD_CODE | STVASTD_CODE | STVASTD |
| SGBSTDN_COLL_CODE_1 | STVCOLL_CODE | STVCOLL |
| SGBSTDN_COLL_CODE_2 | STVCOLL_CODE | STVCOLL |
| SGBSTDN_COLL_CODE_DUAL | STVCOLL_CODE | STVCOLL |
| SGBSTDN_DEGC_CODE_1 | STVDEGC_CODE | STVDEGC |
| SGBSTDN_DEGC_CODE_2 | STVDEGC_CODE | STVDEGC |
| SGBSTDN_DEGC_CODE_DUAL | STVDEGC_CODE | STVDEGC |
| SGBSTDN_EGOL_CODE | STVEGOL_CODE | STVEGOL |
| SGBSTDN_EMEX_CODE | STVEMEX_CODE | STVEMEX |
| SGBSTDN_GAIN_CODE | STVGAIN_CODE | STVGAIN |
| SGBSTDN_RATE_CODE | STVRATE_CODE | STVRATE |
| SGBSTDN_RESD_CODE | STVRESD_CODE | STVRESD |
| SGBSTDN_SESS_CODE | STVSESS_CODE | STVSESS |
| SGBSTDN_STST_CODE | STVSTST_CODE | STVSTST |
| SGBSTDN_STYP_CODE | STVSTYP_CODE | STVSTYP |
| SGBSTDN_TRCN_CODE | STVTRCN_CODE | STVTRCN |
| SGBSTDN_DEPT_CODE_2_2 | STVDEPT_CODE | STVDEPT |
| SGBSTDN_DEPT_CODE_1_2 | STVDEPT_CODE | STVDEPT |
| SGBSTDN_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SGBSTDN_DEPT_CODE_2 | STVDEPT_CODE | STVDEPT |
| SGBSTDN_DEPT_CODE_DUAL | STVDEPT_CODE | STVDEPT |
| SGBSTDN_CAPL_CODE | STVCAPL_CODE | STVCAPL |
| SGBSTDN_INCM_CODE | STVINCM_CODE | STVINCM |
| SGBSTDN_CAST_CODE | STVCAST_CODE | STVCAST |
| SGBSTDN_BLCK_CODE | STVBLCK_CODE | STVBLCK |
| SGBSTDN_ORSN_CODE | STVORSN_CODE | STVORSN |
| SGBSTDN_PIDM | SHRTTRM_PIDM | SHRTTRM |
| SGBSTDN_PIDM | SHRLGPA_PIDM | SHRLGPA |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SGBSTDN | Unique | SGBSTDN_PIDM |
| PK_SGBSTDN | Unique | SGBSTDN_TERM_CODE_EFF |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table SGBUSER| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGBUSER_PIDM | SGBUSER_PIDM | NUMBER(8,0) | No | * | |
| SGBUSER_TERM_CODE | SGBUSER_TERM_CODE | VARCHAR2(6) | No | * | * |
| SGBUSER_SUDA_CODE | SGBUSER_SUDA_CODE | VARCHAR2(15) | Yes | * | |
| SGBUSER_SUDB_CODE | SGBUSER_SUDB_CODE | VARCHAR2(15) | Yes | * | |
| SGBUSER_SUDC_CODE | SGBUSER_SUDC_CODE | VARCHAR2(15) | Yes | * | |
| SGBUSER_SUDD_CODE | SGBUSER_SUDD_CODE | VARCHAR2(15) | Yes | * | |
| SGBUSER_SUDE_CODE | SGBUSER_SUDE_CODE | VARCHAR2(15) | Yes | * | |
| SGBUSER_SUDF_CODE | SGBUSER_SUDF_CODE | VARCHAR2(15) | Yes | * | |
| SGBUSER_SUDG_CODE | SGBUSER_SUDG_CODE | VARCHAR2(15) | Yes | * | |
| SGBUSER_SUDH_CODE | SGBUSER_SUDH_CODE | VARCHAR2(15) | Yes | * | |
| SGBUSER_SUDI_CODE | SGBUSER_SUDI_CODE | VARCHAR2(15) | Yes | * | |
| SGBUSER_SUDJ_CODE | SGBUSER_SUDJ_CODE | VARCHAR2(15) | Yes | * | |
| SGBUSER_ACTIVITY_DATE | SGBUSER_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGBUSER_TERM_CODE | STVTERM_CODE | STVTERM |
| SGBUSER_SUDA_CODE | STVSUDA_CODE | STVSUDA |
| SGBUSER_SUDB_CODE | STVSUDB_CODE | STVSUDB |
| SGBUSER_SUDC_CODE | STVSUDC_CODE | STVSUDC |
| SGBUSER_SUDD_CODE | STVSUDD_CODE | STVSUDD |
| SGBUSER_SUDE_CODE | STVSUDE_CODE | STVSUDE |
| SGBUSER_SUDF_CODE | STVSUDF_CODE | STVSUDF |
| SGBUSER_SUDG_CODE | STVSUDG_CODE | STVSUDG |
| SGBUSER_SUDH_CODE | STVSUDH_CODE | STVSUDH |
| SGBUSER_SUDI_CODE | STVSUDI_CODE | STVSUDI |
| SGBUSER_SUDJ_CODE | STVSUDJ_CODE | STVSUDJ |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SGBUSER | Unique | SGBUSER_PIDM |
| PK_SGBUSER | Unique | SGBUSER_TERM_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table SGRACMT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRACMT_PIDM | SGRACMT_PIDM | NUMBER(8,0) | No | ||
| SGRACMT_TERM_CODE_EFF | SGRACMT_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SGRACMT_CATEGORY | SGRACMT_CATEGORY | VARCHAR2(1) | No | ||
| SGRACMT_GTYP_CODE | SGRACMT_GTYP_CODE | VARCHAR2(6) | No | * | |
| SGRACMT_SEQNO | SGRACMT_SEQNO | NUMBER(23,20) | Yes | ||
| SGRACMT_TEXT | SGRACMT_TEXT | VARCHAR2(60) | Yes | ||
| SGRACMT_ORIG_CODE | SGRACMT_ORIG_CODE | VARCHAR2(4) | Yes | * | |
| SGRACMT_ORIG_DATE | SGRACMT_ORIG_DATE | DATE | Yes | ||
| SGRACMT_ACTIVITY_DATE | SGRACMT_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRACMT_GTYP_CODE | STVGTYP_CODE | STVGTYP |
| SGRACMT_ORIG_CODE | STVORIG_CODE | STVORIG |
| SGRACMT_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGRACMT_KEY_INDEX | SGRACMT_PIDM | |
| SGRACMT_KEY_INDEX | SGRACMT_TERM_CODE_EFF | |
| SGRACMT_KEY_INDEX | SGRACMT_CATEGORY | |
| SGRACMT_KEY_INDEX | SGRACMT_GTYP_CODE | |
| SGRACMT_KEY_INDEX | SGRACMT_SEQNO |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table SGRADVR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRADVR_PIDM | SGRADVR_PIDM | NUMBER(8,0) | No | ||
| SGRADVR_TERM_CODE_EFF | SGRADVR_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SGRADVR_ADVR_PIDM | SGRADVR_ADVR_PIDM | NUMBER(8,0) | Yes | * | |
| SGRADVR_ADVR_CODE | SGRADVR_ADVR_CODE | VARCHAR2(4) | Yes | * | |
| SGRADVR_PRIM_IND | SGRADVR_PRIM_IND | VARCHAR2(1) | Yes | ||
| SGRADVR_ACTIVITY_DATE | SGRADVR_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRADVR_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SGRADVR_ADVR_CODE | STVADVR_CODE | STVADVR |
| SGRADVR_ADVR_PIDM | SPRIDEN_PIDM | SPRIDEN |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGRADVR_ADVR_PIDM_INDEX | SGRADVR_ADVR_PIDM | |
| SGRADVR_KEY_INDEX | SGRADVR_PIDM | |
| SGRADVR_KEY_INDEX | SGRADVR_TERM_CODE_EFF |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table SGRASSI| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRASSI_PIDM | SGRASSI_PIDM | NUMBER(8,0) | No | * | |
| SGRASSI_TERM_CODE_EFF | SGRASSI_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SGRASSI_CATEGORY | SGRASSI_CATEGORY | VARCHAR2(1) | No | * | |
| SGRASSI_GTYP_CODE | SGRASSI_GTYP_CODE | VARCHAR2(6) | No | * | * |
| SGRASSI_SOFF_CODE | SGRASSI_SOFF_CODE | VARCHAR2(6) | Yes | * | |
| SGRASSI_STIPEND | SGRASSI_STIPEND | NUMBER(7,2) | Yes | ||
| SGRASSI_FTE_VALUE | SGRASSI_FTE_VALUE | NUMBER(5,2) | Yes | ||
| SGRASSI_MIN_CRSE_LOAD | SGRASSI_MIN_CRSE_LOAD | NUMBER(9,3) | Yes | ||
| SGRASSI_MAX_CRSE_LOAD | SGRASSI_MAX_CRSE_LOAD | NUMBER(9,3) | Yes | ||
| SGRASSI_REQUIRED_HRS | SGRASSI_REQUIRED_HRS | NUMBER(11,3) | Yes | ||
| SGRASSI_GSTA_CODE | SGRASSI_GSTA_CODE | VARCHAR2(2) | Yes | * | |
| SGRASSI_GSTA_DATE | SGRASSI_GSTA_DATE | DATE | Yes | ||
| SGRASSI_DEGC_CODE | SGRASSI_DEGC_CODE | VARCHAR2(6) | Yes | * | |
| SGRASSI_LEVL_CODE | SGRASSI_LEVL_CODE | VARCHAR2(2) | Yes | * | |
| SGRASSI_COLL_CODE | SGRASSI_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SGRASSI_DEPT_CODE | SGRASSI_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SGRASSI_MAJR_CODE | SGRASSI_MAJR_CODE | VARCHAR2(4) | Yes | * | |
| SGRASSI_PIDM_SUPERVISOR | SGRASSI_PIDM_SUPERVISOR | NUMBER(8,0) | Yes | ||
| SGRASSI_ACTIVITY_DATE | SGRASSI_ACTIVITY_DATE | DATE | No | ||
| SGRASSI_PROGRAM | SGRASSI_PROGRAM | VARCHAR2(12) | Yes | ||
| SGRASSI_TERM_CODE_CTLG | SGRASSI_TERM_CODE_CTLG | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRASSI_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SGRASSI_TERM_CODE_CTLG | STVTERM_CODE | STVTERM |
| SGRASSI_GTYP_CODE | STVGTYP_CODE | STVGTYP |
| SGRASSI_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SGRASSI_GSTA_CODE | STVGSTA_CODE | STVGSTA |
| SGRASSI_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SGRASSI_MAJR_CODE | STVMAJR_CODE | STVMAJR |
| SGRASSI_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SGRASSI_SOFF_CODE | STVSOFF_CODE | STVSOFF |
| SGRASSI_DEGC_CODE | STVDEGC_CODE | STVDEGC |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SGRASSI | Unique | SGRASSI_PIDM |
| PK_SGRASSI | Unique | SGRASSI_TERM_CODE_EFF |
| PK_SGRASSI | Unique | SGRASSI_CATEGORY |
| PK_SGRASSI | Unique | SGRASSI_GTYP_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table SGRASST| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRASST_PIDM | SGRASST_PIDM | NUMBER(8,0) | No | ||
| SGRASST_TERM_CODE_EFF | SGRASST_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SGRASST_CATEGORY | SGRASST_CATEGORY | VARCHAR2(1) | No | ||
| SGRASST_GTYP_CODE | SGRASST_GTYP_CODE | VARCHAR2(6) | No | * | |
| SGRASST_TASK_CODE | SGRASST_TASK_CODE | VARCHAR2(6) | Yes | * | |
| SGRASST_PIDM_COORDINATOR | SGRASST_PIDM_COORDINATOR | NUMBER(8,0) | Yes | ||
| SGRASST_ACTIVITY_DATE | SGRASST_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRASST_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SGRASST_GTYP_CODE | STVGTYP_CODE | STVGTYP |
| SGRASST_TASK_CODE | STVTASK_CODE | STVTASK |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGRASST_KEY_INDEX | Unique | SGRASST_PIDM |
| SGRASST_KEY_INDEX | Unique | SGRASST_TERM_CODE_EFF |
| SGRASST_KEY_INDEX | Unique | SGRASST_CATEGORY |
| SGRASST_KEY_INDEX | Unique | SGRASST_GTYP_CODE |
| SGRASST_KEY_INDEX | Unique | SGRASST_TASK_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table SGRCATT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRCATT_SEQ_NO | SGRCATT_SEQ_NO | NUMBER(3,0) | No | * | |
| SGRCATT_ATTS_CODE | SGRCATT_ATTS_CODE | VARCHAR2(4) | No | * | * |
| SGRCATT_ACTIVITY_DATE | SGRCATT_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRCATT_ATTS_CODE | STVATTS_CODE | STVATTS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SGRCATT | Unique | SGRCATT_SEQ_NO |
| PK_SGRCATT | Unique | SGRCATT_ATTS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table SGRCHRT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRCHRT_PIDM | SGRCHRT_PIDM | NUMBER(8,0) | No | ||
| SGRCHRT_TERM_CODE_EFF | SGRCHRT_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SGRCHRT_CHRT_CODE | SGRCHRT_CHRT_CODE | VARCHAR2(10) | Yes | * | |
| SGRCHRT_ACTIVE_IND | SGRCHRT_ACTIVE_IND | VARCHAR2(1) | Yes | ||
| SGRCHRT_CREA_CODE | SGRCHRT_CREA_CODE | VARCHAR2(4) | Yes | * | |
| SGRCHRT_ACTIVITY_DATE | SGRCHRT_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRCHRT_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SGRCHRT_CREA_CODE | STVCREA_CODE | STVCREA |
| SGRCHRT_CHRT_CODE | STVCHRT_CODE | STVCHRT |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGRCHRT_KEY_INDEX | Unique | SGRCHRT_PIDM |
| SGRCHRT_KEY_INDEX | Unique | SGRCHRT_TERM_CODE_EFF |
| SGRCHRT_KEY_INDEX | Unique | SGRCHRT_CHRT_CODE |
| SGRCHRT_KEY_INDEX2 | SGRCHRT_TERM_CODE_EFF | |
| SGRCHRT_KEY_INDEX2 | SGRCHRT_CHRT_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table SGRCLSR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRCLSR_LEVL_CODE | SGRCLSR_LEVL_CODE | VARCHAR2(2) | No | * | |
| SGRCLSR_CLAS_CODE | SGRCLSR_CLAS_CODE | VARCHAR2(2) | No | * | |
| SGRCLSR_FROM_HOURS | SGRCLSR_FROM_HOURS | NUMBER(11,3) | No | ||
| SGRCLSR_TO_HOURS | SGRCLSR_TO_HOURS | NUMBER(11,3) | No | ||
| SGRCLSR_ACTIVITY_DATE | SGRCLSR_ACTIVITY_DATE | DATE | No | ||
| SGRCLSR_SEQ_NO | SGRCLSR_SEQ_NO | NUMBER(3,0) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRCLSR_CLAS_CODE | STVCLAS_CODE | STVCLAS |
| SGRCLSR_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGRCLSR_KEY_INDEX | SGRCLSR_LEVL_CODE | |
| SGRCLSR_KEY_INDEX | SGRCLSR_CLAS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table SGRCMNT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRCMNT_PIDM | SGRCMNT_PIDM | NUMBER(8,0) | No | ||
| SGRCMNT_TERM_CODE | SGRCMNT_TERM_CODE | VARCHAR2(6) | No | * | |
| SGRCMNT_ACTC_CODE | SGRCMNT_ACTC_CODE | VARCHAR2(8) | No | * | |
| SGRCMNT_SEQ_NO | SGRCMNT_SEQ_NO | NUMBER(23,20) | Yes | ||
| SGRCMNT_COMMENT_TEXT | SGRCMNT_COMMENT_TEXT | VARCHAR2(4000) | No | ||
| SGRCMNT_ACTIVITY_DATE | SGRCMNT_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRCMNT_TERM_CODE | STVTERM_CODE | STVTERM |
| SGRCMNT_ACTC_CODE | STVACTC_CODE | STVACTC |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGRCMNT_KEY_INDEX | SGRCMNT_PIDM | |
| SGRCMNT_KEY_INDEX | SGRCMNT_TERM_CODE | |
| SGRCMNT_KEY_INDEX | SGRCMNT_ACTC_CODE | |
| SGRCMNT_KEY_INDEX | SGRCMNT_SEQ_NO |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table SGRCOLR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRCOLR_SESSIONID | SGRCOLR_SESSIONID | VARCHAR2(30) | No | ||
| SGRCOLR_CHRT_CODE | SGRCOLR_CHRT_CODE | VARCHAR2(10) | No | * | |
| SGRCOLR_TERM_CODE_START | SGRCOLR_TERM_CODE_START | VARCHAR2(6) | No | * | |
| SGRCOLR_TERM_CODE_END | SGRCOLR_TERM_CODE_END | VARCHAR2(6) | No | * | |
| SGRCOLR_ACTC_CODE | SGRCOLR_ACTC_CODE | VARCHAR2(8) | Yes | * | |
| SGRCOLR_DLEV_CODE | SGRCOLR_DLEV_CODE | VARCHAR2(2) | Yes | * | |
| SGRCOLR_PRINT_IND | SGRCOLR_PRINT_IND | VARCHAR2(1) | No | ||
| SGRCOLR_PIDM | SGRCOLR_PIDM | NUMBER(8,0) | No | ||
| SGRCOLR_ID | SGRCOLR_ID | VARCHAR2(9) | No | ||
| SGRCOLR_SEX | SGRCOLR_SEX | VARCHAR2(1) | Yes | ||
| SGRCOLR_IPEDS_CATEGORY | SGRCOLR_IPEDS_CATEGORY | VARCHAR2(1) | Yes | ||
| SGRCOLR_CREA_CODE | SGRCOLR_CREA_CODE | VARCHAR2(4) | Yes | * | |
| SGRCOLR_TERM_CODE_INACTIVE | SGRCOLR_TERM_CODE_INACTIVE | VARCHAR2(6) | Yes | * | |
| SGRCOLR_DEGC_CODE | SGRCOLR_DEGC_CODE | VARCHAR2(6) | Yes | * | |
| SGRCOLR_MAJR_CODE | SGRCOLR_MAJR_CODE | VARCHAR2(4) | Yes | * | |
| SGRCOLR_AWARDED_DATE | SGRCOLR_AWARDED_DATE | DATE | Yes | ||
| SGRCOLR_CRHRS | SGRCOLR_CRHRS | NUMBER(11,3) | Yes | ||
| SGRCOLR_CEU | SGRCOLR_CEU | NUMBER(11,3) | Yes | ||
| SGRCOLR_ACTIVITY_DATE | SGRCOLR_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRCOLR_TERM_CODE_INACTIVE | STVTERM_CODE | STVTERM |
| SGRCOLR_TERM_CODE_END | STVTERM_CODE | STVTERM |
| SGRCOLR_TERM_CODE_START | STVTERM_CODE | STVTERM |
| SGRCOLR_CREA_CODE | STVCREA_CODE | STVCREA |
| SGRCOLR_ACTC_CODE | STVACTC_CODE | STVACTC |
| SGRCOLR_CHRT_CODE | STVCHRT_CODE | STVCHRT |
| SGRCOLR_DLEV_CODE | STVDLEV_CODE | STVDLEV |
| SGRCOLR_MAJR_CODE | STVMAJR_CODE | STVMAJR |
| SGRCOLR_DEGC_CODE | STVDEGC_CODE | STVDEGC |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGRCOLR_KEY_INDEX | SGRCOLR_SESSIONID | |
| SGRCOLR_KEY_INDEX | SGRCOLR_CHRT_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table SGRCOOP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRCOOP_PIDM | SGRCOOP_PIDM | NUMBER(8,0) | No | * | |
| SGRCOOP_TERM_CODE | SGRCOOP_TERM_CODE | VARCHAR2(6) | No | * | * |
| SGRCOOP_LEVL_CODE | SGRCOOP_LEVL_CODE | VARCHAR2(2) | No | * | * |
| SGRCOOP_EMPL_CODE | SGRCOOP_EMPL_CODE | VARCHAR2(4) | Yes | * | |
| SGRCOOP_COPC_CODE | SGRCOOP_COPC_CODE | VARCHAR2(6) | Yes | * | |
| SGRCOOP_END_DATE | SGRCOOP_END_DATE | DATE | Yes | ||
| SGRCOOP_BEGIN_DATE | SGRCOOP_BEGIN_DATE | DATE | Yes | ||
| SGRCOOP_INTEREST_IND | SGRCOOP_INTEREST_IND | VARCHAR2(1) | Yes | ||
| SGRCOOP_EMPL_CONTACT_NAME | SGRCOOP_EMPL_CONTACT_NAME | VARCHAR2(30) | Yes | ||
| SGRCOOP_EMPL_CONTACT_TITLE | SGRCOOP_EMPL_CONTACT_TITLE | VARCHAR2(30) | Yes | ||
| SGRCOOP_ACTIVITY_DATE | SGRCOOP_ACTIVITY_DATE | DATE | No | ||
| SGRCOOP_PHONE_AREA | SGRCOOP_PHONE_AREA | VARCHAR2(3) | Yes | ||
| SGRCOOP_PHONE_NUMBER | SGRCOOP_PHONE_NUMBER | VARCHAR2(7) | Yes | ||
| SGRCOOP_PHONE_EXT | SGRCOOP_PHONE_EXT | VARCHAR2(4) | Yes | ||
| SGRCOOP_SEQ_NO | SGRCOOP_SEQ_NO | NUMBER(4,0) | No | * | |
| SGRCOOP_CRN | SGRCOOP_CRN | VARCHAR2(5) | Yes | ||
| SGRCOOP_EVAL_PREPARED_DATE | SGRCOOP_EVAL_PREPARED_DATE | DATE | Yes | ||
| SGRCOOP_EVAL_RECEIVED_DATE | SGRCOOP_EVAL_RECEIVED_DATE | DATE | Yes | ||
| SGRCOOP_OVERRIDE_IND | SGRCOOP_OVERRIDE_IND | VARCHAR2(1) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRCOOP_COPC_CODE | STVCOPC_CODE | STVCOPC |
| SGRCOOP_TERM_CODE | STVTERM_CODE | STVTERM |
| SGRCOOP_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SGRCOOP_EMPL_CODE | STVEMPL_CODE | STVEMPL |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SGRCOOP | Unique | SGRCOOP_PIDM |
| PK_SGRCOOP | Unique | SGRCOOP_TERM_CODE |
| PK_SGRCOOP | Unique | SGRCOOP_LEVL_CODE |
| PK_SGRCOOP | Unique | SGRCOOP_SEQ_NO |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table SGRDISA| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRDISA_PIDM | SGRDISA_PIDM | NUMBER(8,0) | No | * | |
| SGRDISA_TERM_CODE | SGRDISA_TERM_CODE | VARCHAR2(6) | No | * | * |
| SGRDISA_DISA_CODE | SGRDISA_DISA_CODE | VARCHAR2(2) | No | * | * |
| SGRDISA_MEDI_CODE | SGRDISA_MEDI_CODE | VARCHAR2(2) | Yes | * | |
| SGRDISA_SPSR_CODE | SGRDISA_SPSR_CODE | VARCHAR2(2) | Yes | * | |
| SGRDISA_PRIMARY_IND | SGRDISA_PRIMARY_IND | VARCHAR2(1) | Yes | ||
| SGRDISA_ACTIVITY_DATE | SGRDISA_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRDISA_TERM_CODE | STVTERM_CODE | STVTERM |
| SGRDISA_DISA_CODE | STVDISA_CODE | STVDISA |
| SGRDISA_MEDI_CODE | STVMEDI_CODE | STVMEDI |
| SGRDISA_SPSR_CODE | STVSPSR_CODE | STVSPSR |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SGRDISA | Unique | SGRDISA_PIDM |
| PK_SGRDISA | Unique | SGRDISA_TERM_CODE |
| PK_SGRDISA | Unique | SGRDISA_DISA_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table SGRDSER| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRDSER_PIDM | SGRDSER_PIDM | NUMBER(8,0) | No | * | |
| SGRDSER_TERM_CODE | SGRDSER_TERM_CODE | VARCHAR2(6) | No | * | |
| SGRDSER_DISA_CODE | SGRDSER_DISA_CODE | VARCHAR2(2) | No | * | |
| SGRDSER_SSER_CODE | SGRDSER_SSER_CODE | VARCHAR2(4) | No | * | |
| SGRDSER_NBR_CONTACTS | SGRDSER_NBR_CONTACTS | NUMBER(3,0) | Yes | ||
| SGRDSER_SSST_CODE | SGRDSER_SSST_CODE | VARCHAR2(2) | Yes | * | |
| SGRDSER_SEPR_CODE | SGRDSER_SEPR_CODE | VARCHAR2(2) | Yes | * | |
| SGRDSER_SPRV_CODE | SGRDSER_SPRV_CODE | VARCHAR2(6) | Yes | * | |
| SGRDSER_SSEP_CODE | SGRDSER_SSEP_CODE | VARCHAR2(4) | Yes | * | |
| SGRDSER_BEGIN_DATE | SGRDSER_BEGIN_DATE | DATE | Yes | ||
| SGRDSER_END_DATE | SGRDSER_END_DATE | DATE | Yes | ||
| SGRDSER_SSRS_CODE | SGRDSER_SSRS_CODE | VARCHAR2(2) | Yes | * | |
| SGRDSER_ORIG_CODE | SGRDSER_ORIG_CODE | VARCHAR2(4) | Yes | * | |
| SGRDSER_CAMP_CODE | SGRDSER_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SGRDSER_ACTIVITY_DATE | SGRDSER_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRDSER_TERM_CODE | STVTERM_CODE | STVTERM |
| SGRDSER_SSEP_CODE | STVSSEP_CODE | STVSSEP |
| SGRDSER_SSER_CODE | STVSSER_CODE | STVSSER |
| SGRDSER_SPRV_CODE | STVSPRV_CODE | STVSPRV |
| SGRDSER_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SGRDSER_SEPR_CODE | STVSEPR_CODE | STVSEPR |
| SGRDSER_DISA_CODE | STVDISA_CODE | STVDISA |
| SGRDSER_SSRS_CODE | STVSSRS_CODE | STVSSRS |
| SGRDSER_SSST_CODE | STVSSST_CODE | STVSSST |
| SGRDSER_PIDM | SGRDISA_PIDM | SGRDISA |
| SGRDSER_TERM_CODE | SGRDISA_TERM_CODE | SGRDISA |
| SGRDSER_DISA_CODE | SGRDISA_DISA_CODE | SGRDISA |
| SGRDSER_ORIG_CODE | STVORIG_CODE | STVORIG |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGRDSER_KEY_INDEX | SGRDSER_PIDM | |
| SGRDSER_KEY_INDEX | SGRDSER_TERM_CODE | |
| SGRDSER_KEY_INDEX | SGRDSER_DISA_CODE | |
| SGRDSER_KEY_INDEX | SGRDSER_SSER_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table SGRDUTY| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRDUTY_PIDM | SGRDUTY_PIDM | NUMBER(8,0) | No | * | * |
| SGRDUTY_LEVL_CODE | SGRDUTY_LEVL_CODE | VARCHAR2(2) | No | * | * |
| SGRDUTY_TERM_CODE | SGRDUTY_TERM_CODE | VARCHAR2(6) | No | * | * |
| SGRDUTY_EMPL_CODE | SGRDUTY_EMPL_CODE | VARCHAR2(4) | No | * | * |
| SGRDUTY_SEQ_NO | SGRDUTY_SEQ_NO | NUMBER(4,0) | No | * | |
| SGRDUTY_DESC | SGRDUTY_DESC | VARCHAR2(60) | Yes | ||
| SGRDUTY_ACTIVITY_DATE | SGRDUTY_ACTIVITY_DATE | DATE | No | ||
| SGRDUTY_COOP_SEQ_NO | SGRDUTY_COOP_SEQ_NO | NUMBER(4,0) | No | * | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRDUTY_TERM_CODE | STVTERM_CODE | STVTERM |
| SGRDUTY_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SGRDUTY_PIDM | SGRCOOP_PIDM | SGRCOOP |
| SGRDUTY_TERM_CODE | SGRCOOP_TERM_CODE | SGRCOOP |
| SGRDUTY_LEVL_CODE | SGRCOOP_LEVL_CODE | SGRCOOP |
| SGRDUTY_COOP_SEQ_NO | SGRCOOP_SEQ_NO | SGRCOOP |
| SGRDUTY_EMPL_CODE | STVEMPL_CODE | STVEMPL |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SGRDUTY | Unique | SGRDUTY_PIDM |
| PK_SGRDUTY | Unique | SGRDUTY_TERM_CODE |
| PK_SGRDUTY | Unique | SGRDUTY_LEVL_CODE |
| PK_SGRDUTY | Unique | SGRDUTY_COOP_SEQ_NO |
| PK_SGRDUTY | Unique | SGRDUTY_EMPL_CODE |
| PK_SGRDUTY | Unique | SGRDUTY_SEQ_NO |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table SGRESEL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRESEL_PIDM | SGRESEL_PIDM | NUMBER(8,0) | No | ||
| SGRESEL_TERM_CODE_EFF | SGRESEL_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SGRESEL_ESEL_CODE | SGRESEL_ESEL_CODE | VARCHAR2(2) | Yes | * | |
| SGRESEL_PRIMARY_IND | SGRESEL_PRIMARY_IND | VARCHAR2(1) | Yes | ||
| SGRESEL_ACTIVITY_DATE | SGRESEL_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRESEL_ESEL_CODE | STVESEL_CODE | STVESEL |
| SGRESEL_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGRESEL_KEY_INDEX | Unique | SGRESEL_PIDM |
| SGRESEL_KEY_INDEX | Unique | SGRESEL_TERM_CODE_EFF |
| SGRESEL_KEY_INDEX | Unique | SGRESEL_ESEL_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table SGRSACT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRSACT_PIDM | SGRSACT_PIDM | NUMBER(8,0) | No | ||
| SGRSACT_ACTC_CODE | SGRSACT_ACTC_CODE | VARCHAR2(8) | No | * | |
| SGRSACT_TERM_CODE | SGRSACT_TERM_CODE | VARCHAR2(6) | Yes | * | |
| SGRSACT_ACTIVITY_DATE | SGRSACT_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRSACT_TERM_CODE | STVTERM_CODE | STVTERM |
| SGRSACT_ACTC_CODE | STVACTC_CODE | STVACTC |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGRSACT_KEY_INDEX | SGRSACT_PIDM | |
| SGRSACT_KEY_INDEX | SGRSACT_ACTC_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table SGRSATT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRSATT_PIDM | SGRSATT_PIDM | NUMBER(8,0) | No | ||
| SGRSATT_TERM_CODE_EFF | SGRSATT_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SGRSATT_ATTS_CODE | SGRSATT_ATTS_CODE | VARCHAR2(4) | Yes | * | |
| SGRSATT_ACTIVITY_DATE | SGRSATT_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRSATT_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SGRSATT_ATTS_CODE | STVATTS_CODE | STVATTS |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGRSATT_KEY_INDEX | Unique | SGRSATT_PIDM |
| SGRSATT_KEY_INDEX | Unique | SGRSATT_TERM_CODE_EFF |
| SGRSATT_KEY_INDEX | Unique | SGRSATT_ATTS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table SGRSCMT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRSCMT_PIDM | SGRSCMT_PIDM | NUMBER(8,0) | No | ||
| SGRSCMT_SEQ_NO | SGRSCMT_SEQ_NO | NUMBER(3,0) | No | ||
| SGRSCMT_TERM_CODE | SGRSCMT_TERM_CODE | VARCHAR2(6) | Yes | * | |
| SGRSCMT_COMMENT_TEXT | SGRSCMT_COMMENT_TEXT | VARCHAR2(4000) | Yes | ||
| SGRSCMT_ACTIVITY_DATE | SGRSCMT_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRSCMT_TERM_CODE | STVTERM_CODE | STVTERM |
| Index Name | Index Type | Column Name |
|---|---|---|
| SGRSCMT_KEY_INDEX | SGRSCMT_PIDM |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table SGRSPRT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRSPRT_PIDM | SGRSPRT_PIDM | NUMBER(8,0) | No | * | |
| SGRSPRT_TERM_CODE | SGRSPRT_TERM_CODE | VARCHAR2(6) | No | * | * |
| SGRSPRT_ACTC_CODE | SGRSPRT_ACTC_CODE | VARCHAR2(8) | No | * | * |
| SGRSPRT_SPST_CODE | SGRSPRT_SPST_CODE | VARCHAR2(2) | Yes | * | |
| SGRSPRT_ELIG_CODE | SGRSPRT_ELIG_CODE | VARCHAR2(2) | Yes | * | |
| SGRSPRT_ACTIVITY_DATE | SGRSPRT_ACTIVITY_DATE | DATE | No | ||
| SGRSPRT_ATHL_AID_IND | SGRSPRT_ATHL_AID_IND | VARCHAR2(1) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRSPRT_TERM_CODE | STVTERM_CODE | STVTERM |
| SGRSPRT_ELIG_CODE | STVELIG_CODE | STVELIG |
| SGRSPRT_SPST_CODE | STVSPST_CODE | STVSPST |
| SGRSPRT_ACTC_CODE | STVACTC_CODE | STVACTC |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SGRSPRT | Unique | SGRSPRT_PIDM |
| PK_SGRSPRT | Unique | SGRSPRT_TERM_CODE |
| PK_SGRSPRT | Unique | SGRSPRT_ACTC_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table SGRVETN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SGRVETN_PIDM | SGRVETN_PIDM | NUMBER(8,0) | No | * | |
| SGRVETN_TERM_CODE_VA | SGRVETN_TERM_CODE_VA | VARCHAR2(6) | No | * | * |
| SGRVETN_VETC_CODE | SGRVETN_VETC_CODE | VARCHAR2(1) | No | * | |
| SGRVETN_CERT_HOURS | SGRVETN_CERT_HOURS | NUMBER(9,3) | No | ||
| SGRVETN_CERT_DATE | SGRVETN_CERT_DATE | DATE | No | ||
| SGRVETN_ACTIVITY_DATE | SGRVETN_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SGRVETN_TERM_CODE_VA | STVTERM_CODE | STVTERM |
| SGRVETN_VETC_CODE | STVVETC_CODE | STVVETC |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SGRVETN | Unique | SGRVETN_PIDM |
| PK_SGRVETN | Unique | SGRVETN_TERM_CODE_VA |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table SHRLGPA| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SHRLGPA_PIDM | SHRLGPA_PIDM | NUMBER(8,0) | No | * | |
| SHRLGPA_LEVL_CODE | SHRLGPA_LEVL_CODE | VARCHAR2(2) | No | * | * |
| SHRLGPA_GPA_TYPE_IND | SHRLGPA_GPA_TYPE_IND | VARCHAR2(1) | No | * | |
| SHRLGPA_HOURS_ATTEMPTED | SHRLGPA_HOURS_ATTEMPTED | NUMBER(11,3) | No | ||
| SHRLGPA_HOURS_EARNED | SHRLGPA_HOURS_EARNED | NUMBER(11,3) | No | ||
| SHRLGPA_GPA_HOURS | SHRLGPA_GPA_HOURS | NUMBER(11,3) | No | ||
| SHRLGPA_QUALITY_POINTS | SHRLGPA_QUALITY_POINTS | NUMBER(17,6) | No | ||
| SHRLGPA_GPA | SHRLGPA_GPA | NUMBER(23,9) | No | ||
| SHRLGPA_ACTIVITY_DATE | SHRLGPA_ACTIVITY_DATE | DATE | No | ||
| SHRLGPA_HOURS_PASSED | SHRLGPA_HOURS_PASSED | NUMBER(11,3) | No | ||
| SHRLGPA_GPA_CALC | SHRLGPA_GPA_CALC | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SHRLGPA_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SHRLGPA | Unique | SHRLGPA_PIDM |
| PK_SHRLGPA | Unique | SHRLGPA_LEVL_CODE |
| PK_SHRLGPA | Unique | SHRLGPA_GPA_TYPE_IND |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table SHRTTRM| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SHRTTRM_PIDM | SHRTTRM_PIDM | NUMBER(8,0) | No | * | * |
| SHRTTRM_TERM_CODE | SHRTTRM_TERM_CODE | VARCHAR2(6) | No | * | * |
| SHRTTRM_UPDATE_SOURCE_IND | SHRTTRM_UPDATE_SOURCE_IND | VARCHAR2(1) | No | ||
| SHRTTRM_PRE_CATALOG_IND | SHRTTRM_PRE_CATALOG_IND | VARCHAR2(1) | Yes | ||
| SHRTTRM_RECORD_STATUS_IND | SHRTTRM_RECORD_STATUS_IND | VARCHAR2(1) | No | ||
| SHRTTRM_RECORD_STATUS_DATE | SHRTTRM_RECORD_STATUS_DATE | DATE | No | ||
| SHRTTRM_GRADE_MAILING_DATE | SHRTTRM_GRADE_MAILING_DATE | DATE | Yes | ||
| SHRTTRM_GRADE_MAILER_CHG_DATE | SHRTTRM_GRADE_MAILER_CHG_DATE | DATE | Yes | ||
| SHRTTRM_GRADE_MAILER_DUP | SHRTTRM_GRADE_MAILER_DUP | VARCHAR2(1) | Yes | ||
| SHRTTRM_GRADE_MAILER_DUP_DATE | SHRTTRM_GRADE_MAILER_DUP_DATE | DATE | Yes | ||
| SHRTTRM_EXAM_CODE | SHRTTRM_EXAM_CODE | VARCHAR2(2) | Yes | * | |
| SHRTTRM_CODE_TRANSCRIPT_DIST | SHRTTRM_CODE_TRANSCRIPT_DIST | VARCHAR2(2) | Yes | ||
| SHRTTRM_ASTD_CODE_END_OF_TERM | SHRTTRM_ASTD_CODE_END_OF_TERM | VARCHAR2(2) | Yes | * | |
| SHRTTRM_ASTD_DATE_END_OF_TERM | SHRTTRM_ASTD_DATE_END_OF_TERM | DATE | Yes | ||
| SHRTTRM_ACTIVITY_DATE | SHRTTRM_ACTIVITY_DATE | DATE | No | ||
| SHRTTRM_ASTD_CODE_DL | SHRTTRM_ASTD_CODE_DL | VARCHAR2(2) | Yes | * | |
| SHRTTRM_ASTD_DATE_DL | SHRTTRM_ASTD_DATE_DL | DATE | Yes | ||
| SHRTTRM_WRSN_CODE | SHRTTRM_WRSN_CODE | VARCHAR2(2) | Yes | * | |
| SHRTTRM_SBGI_CODE_TRANS | SHRTTRM_SBGI_CODE_TRANS | VARCHAR2(6) | Yes | * | |
| SHRTTRM_PREV_CODE | SHRTTRM_PREV_CODE | VARCHAR2(2) | Yes | * | |
| SHRTTRM_PREV_DATE | SHRTTRM_PREV_DATE | DATE | Yes | ||
| SHRTTRM_CAST_CODE | SHRTTRM_CAST_CODE | VARCHAR2(2) | Yes | * | |
| SHRTTRM_CAST_DATE | SHRTTRM_CAST_DATE | DATE | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SHRTTRM_PIDM | SFRENRL_PIDM | SFRENRL |
| SHRTTRM_TERM_CODE | SFRENRL_TERM_CODE | SFRENRL |
| SHRTTRM_ASTD_CODE_END_OF_TERM | STVASTD_CODE | STVASTD |
| SHRTTRM_ASTD_CODE_DL | STVASTD_CODE | STVASTD |
| SHRTTRM_PREV_CODE | STVPREV_CODE | STVPREV |
| SHRTTRM_TERM_CODE | STVTERM_CODE | STVTERM |
| SHRTTRM_SBGI_CODE_TRANS | STVSBGI_CODE | STVSBGI |
| SHRTTRM_EXAM_CODE | STVEXAM_CODE | STVEXAM |
| SHRTTRM_CAST_CODE | STVCAST_CODE | STVCAST |
| SHRTTRM_WRSN_CODE | STVWRSN_CODE | STVWRSN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SHRTTRM | Unique | SHRTTRM_PIDM |
| PK_SHRTTRM | Unique | SHRTTRM_TERM_CODE |
| SHRTTRM_KEY_INDEX2 | SHRTTRM_TERM_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table SMRPRLE| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRPRLE_PROGRAM | SMRPRLE_PROGRAM | VARCHAR2(12) | No | * | |
| SMRPRLE_PROGRAM_DESC | SMRPRLE_PROGRAM_DESC | VARCHAR2(30) | No | ||
| SMRPRLE_ACTIVITY_DATE | SMRPRLE_ACTIVITY_DATE | DATE | No | ||
| SMRPRLE_LEVL_CODE | SMRPRLE_LEVL_CODE | VARCHAR2(2) | No | * | |
| SMRPRLE_CURR_IND | SMRPRLE_CURR_IND | VARCHAR2(1) | No | ||
| SMRPRLE_LOCKED_IND | SMRPRLE_LOCKED_IND | VARCHAR2(1) | No | ||
| SMRPRLE_CURR_RULE_IND | SMRPRLE_CURR_RULE_IND | VARCHAR2(1) | No | ||
| SMRPRLE_CAMP_CODE | SMRPRLE_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SMRPRLE_COLL_CODE | SMRPRLE_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SMRPRLE_DEGC_CODE | SMRPRLE_DEGC_CODE | VARCHAR2(6) | Yes | * | |
| SMRPRLE_PIDM | SMRPRLE_PIDM | NUMBER(8,0) | Yes | ||
| SMRPRLE_LEVL_CODE_STU | SMRPRLE_LEVL_CODE_STU | VARCHAR2(2) | No | * | |
| SMRPRLE_WEB_IND | SMRPRLE_WEB_IND | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRPRLE_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SMRPRLE_DEGC_CODE | STVDEGC_CODE | STVDEGC |
| SMRPRLE_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SMRPRLE_LEVL_CODE_STU | STVLEVL_CODE | STVLEVL |
| SMRPRLE_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRPRLE | Unique | SMRPRLE_PROGRAM |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table SOBCURR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SOBCURR_CURR_RULE | SOBCURR_CURR_RULE | NUMBER(8,0) | No | * | |
| SOBCURR_TERM_CODE_INIT | SOBCURR_TERM_CODE_INIT | VARCHAR2(6) | No | * | |
| SOBCURR_LEVL_CODE | SOBCURR_LEVL_CODE | VARCHAR2(2) | No | * | |
| SOBCURR_ACTIVITY_DATE | SOBCURR_ACTIVITY_DATE | DATE | No | ||
| SOBCURR_PRIM_ROLL_IND | SOBCURR_PRIM_ROLL_IND | VARCHAR2(1) | No | ||
| SOBCURR_SECD_ROLL_IND | SOBCURR_SECD_ROLL_IND | VARCHAR2(1) | No | ||
| SOBCURR_LOCK_IND | SOBCURR_LOCK_IND | VARCHAR2(1) | No | ||
| SOBCURR_CAMP_CODE | SOBCURR_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SOBCURR_COLL_CODE | SOBCURR_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SOBCURR_DEGC_CODE | SOBCURR_DEGC_CODE | VARCHAR2(6) | Yes | * | |
| SOBCURR_PROGRAM | SOBCURR_PROGRAM | VARCHAR2(12) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SOBCURR_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SOBCURR_TERM_CODE_INIT | STVTERM_CODE | STVTERM |
| SOBCURR_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SOBCURR_PROGRAM | SMRPRLE_PROGRAM | SMRPRLE |
| SOBCURR_DEGC_CODE | STVDEGC_CODE | STVDEGC |
| SOBCURR_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SOBCURR_LEVL_CODE | STVWAPP_LEVL_CODE | STVWAPP |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SOBCURR | Unique | SOBCURR_CURR_RULE |
| SOBCURR_KEY_INDEX | Unique | SOBCURR_LEVL_CODE |
| SOBCURR_KEY_INDEX | Unique | SOBCURR_CAMP_CODE |
| SOBCURR_KEY_INDEX | Unique | SOBCURR_COLL_CODE |
| SOBCURR_KEY_INDEX | Unique | SOBCURR_DEGC_CODE |
| SOBCURR_KEY_INDEX | Unique | SOBCURR_PROGRAM |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table SORCCON| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SORCCON_CURR_RULE | SORCCON_CURR_RULE | NUMBER(8,0) | No | * | |
| SORCCON_CCON_RULE | SORCCON_CCON_RULE | NUMBER(8,0) | No | * | |
| SORCCON_TERM_CODE_EFF | SORCCON_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SORCCON_ADM_IND | SORCCON_ADM_IND | VARCHAR2(1) | No | ||
| SORCCON_STU_IND | SORCCON_STU_IND | VARCHAR2(1) | No | ||
| SORCCON_HIS_IND | SORCCON_HIS_IND | VARCHAR2(1) | No | ||
| SORCCON_REC_IND | SORCCON_REC_IND | VARCHAR2(1) | No | ||
| SORCCON_DAU_IND | SORCCON_DAU_IND | VARCHAR2(1) | No | ||
| SORCCON_ACTIVITY_DATE | SORCCON_ACTIVITY_DATE | DATE | No | ||
| SORCCON_CMJR_RULE | SORCCON_CMJR_RULE | NUMBER(8,0) | Yes | * | |
| SORCCON_MAJR_CODE_CONC | SORCCON_MAJR_CODE_CONC | VARCHAR2(4) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SORCCON_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SORCCON_CMJR_RULE | SORCMJR_CMJR_RULE | SORCMJR |
| SORCCON_CURR_RULE | SOBCURR_CURR_RULE | SOBCURR |
| SORCCON_MAJR_CODE_CONC | STVMAJR_CODE | STVMAJR |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SORCCON | Unique | SORCCON_CCON_RULE |
| SORCCON_KEY_INDEX | Unique | SORCCON_CURR_RULE |
| SORCCON_KEY_INDEX | Unique | SORCCON_TERM_CODE_EFF |
| SORCCON_KEY_INDEX | Unique | SORCCON_CMJR_RULE |
| SORCCON_KEY_INDEX | Unique | SORCCON_MAJR_CODE_CONC |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table SORCMJR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SORCMJR_CURR_RULE | SORCMJR_CURR_RULE | NUMBER(8,0) | No | * | |
| SORCMJR_CMJR_RULE | SORCMJR_CMJR_RULE | NUMBER(8,0) | No | * | |
| SORCMJR_TERM_CODE_EFF | SORCMJR_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SORCMJR_ADM_IND | SORCMJR_ADM_IND | VARCHAR2(1) | No | ||
| SORCMJR_STU_IND | SORCMJR_STU_IND | VARCHAR2(1) | No | ||
| SORCMJR_HIS_IND | SORCMJR_HIS_IND | VARCHAR2(1) | No | ||
| SORCMJR_REC_IND | SORCMJR_REC_IND | VARCHAR2(1) | No | ||
| SORCMJR_DAU_IND | SORCMJR_DAU_IND | VARCHAR2(1) | No | ||
| SORCMJR_ACTIVITY_DATE | SORCMJR_ACTIVITY_DATE | DATE | No | ||
| SORCMJR_MAJR_CODE | SORCMJR_MAJR_CODE | VARCHAR2(4) | Yes | * | |
| SORCMJR_DEPT_CODE | SORCMJR_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SORCMJR_DEGR_CDE | SORCMJR_DEGR_CDE | VARCHAR2(3) | Yes | * | |
| SORCMJR_EDI_QLFR | SORCMJR_EDI_QLFR | VARCHAR2(2) | Yes | * | |
| SORCMJR_EDI_VALUE | SORCMJR_EDI_VALUE | VARCHAR2(30) | Yes | * | |
| SORCMJR_DISP_WEB_IND | SORCMJR_DISP_WEB_IND | VARCHAR2(1) | No | ||
| SORCMJR_DESC | SORCMJR_DESC | VARCHAR2(60) | Yes | ||
| SORCMJR_AUTO_DEC_IND | SORCMJR_AUTO_DEC_IND | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SORCMJR_CURR_RULE | SOBCURR_CURR_RULE | SOBCURR |
| SORCMJR_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SORCMJR_MAJR_CODE | STVMAJR_CODE | STVMAJR |
| SORCMJR_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SORCMJR_DEGR_CDE | SARETRY_DEGR_CDE | SARETRY |
| SORCMJR_EDI_QLFR | SAREFOS_IDQL_CDE | SAREFOS |
| SORCMJR_EDI_VALUE | SAREFOS_IDEN_CDE | SAREFOS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SORCMJR | Unique | SORCMJR_CMJR_RULE |
| SORCMJR_KEY_INDEX | Unique | SORCMJR_CURR_RULE |
| SORCMJR_KEY_INDEX | Unique | SORCMJR_TERM_CODE_EFF |
| SORCMJR_KEY_INDEX | Unique | SORCMJR_MAJR_CODE |
| SORCMJR_KEY_INDEX | Unique | SORCMJR_DEPT_CODE |
| SORCMJR_KEY_INDEX2 | SORCMJR_DEGR_CDE | |
| SORCMJR_KEY_INDEX2 | SORCMJR_EDI_QLFR | |
| SORCMJR_KEY_INDEX2 | SORCMJR_EDI_VALUE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table SORCMNR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SORCMNR_CURR_RULE | SORCMNR_CURR_RULE | NUMBER(8,0) | No | * | |
| SORCMNR_CMNR_RULE | SORCMNR_CMNR_RULE | NUMBER(8,0) | No | * | |
| SORCMNR_TERM_CODE_EFF | SORCMNR_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SORCMNR_ADM_IND | SORCMNR_ADM_IND | VARCHAR2(1) | No | ||
| SORCMNR_STU_IND | SORCMNR_STU_IND | VARCHAR2(1) | No | ||
| SORCMNR_HIS_IND | SORCMNR_HIS_IND | VARCHAR2(1) | No | ||
| SORCMNR_REC_IND | SORCMNR_REC_IND | VARCHAR2(1) | No | ||
| SORCMNR_DAU_IND | SORCMNR_DAU_IND | VARCHAR2(1) | No | ||
| SORCMNR_ACTIVITY_DATE | SORCMNR_ACTIVITY_DATE | DATE | No | ||
| SORCMNR_MAJR_CODE_MINR | SORCMNR_MAJR_CODE_MINR | VARCHAR2(4) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SORCMNR_CURR_RULE | SOBCURR_CURR_RULE | SOBCURR |
| SORCMNR_MAJR_CODE_MINR | STVMAJR_CODE | STVMAJR |
| SORCMNR_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SORCMNR | Unique | SORCMNR_CMNR_RULE |
| SORCMNR_KEY_INDEX | Unique | SORCMNR_CURR_RULE |
| SORCMNR_KEY_INDEX | Unique | SORCMNR_TERM_CODE_EFF |
| SORCMNR_KEY_INDEX | Unique | SORCMNR_MAJR_CODE_MINR |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table SPBPERS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SPBPERS_PIDM | SPBPERS_PIDM | NUMBER(8,0) | No | * | * |
| SPBPERS_SSN | SPBPERS_SSN | VARCHAR2(9) | Yes | ||
| SPBPERS_BIRTH_DATE | SPBPERS_BIRTH_DATE | DATE | Yes | ||
| SPBPERS_LGCY_CODE | SPBPERS_LGCY_CODE | VARCHAR2(1) | Yes | * | |
| SPBPERS_ETHN_CODE | SPBPERS_ETHN_CODE | VARCHAR2(2) | Yes | * | |
| SPBPERS_MRTL_CODE | SPBPERS_MRTL_CODE | VARCHAR2(1) | Yes | * | |
| SPBPERS_RELG_CODE | SPBPERS_RELG_CODE | VARCHAR2(2) | Yes | * | |
| SPBPERS_SEX | SPBPERS_SEX | VARCHAR2(1) | Yes | ||
| SPBPERS_CONFID_IND | SPBPERS_CONFID_IND | VARCHAR2(1) | Yes | ||
| SPBPERS_DEAD_IND | SPBPERS_DEAD_IND | VARCHAR2(1) | Yes | ||
| SPBPERS_VETC_FILE_NUMBER | SPBPERS_VETC_FILE_NUMBER | VARCHAR2(10) | Yes | ||
| SPBPERS_LEGAL_NAME | SPBPERS_LEGAL_NAME | VARCHAR2(60) | Yes | ||
| SPBPERS_PREF_FIRST_NAME | SPBPERS_PREF_FIRST_NAME | VARCHAR2(15) | Yes | ||
| SPBPERS_NAME_PREFIX | SPBPERS_NAME_PREFIX | VARCHAR2(20) | Yes | ||
| SPBPERS_NAME_SUFFIX | SPBPERS_NAME_SUFFIX | VARCHAR2(20) | Yes | ||
| SPBPERS_ACTIVITY_DATE | SPBPERS_ACTIVITY_DATE | DATE | No | ||
| SPBPERS_VERA_IND | SPBPERS_VERA_IND | VARCHAR2(1) | Yes | ||
| SPBPERS_CITZ_IND | SPBPERS_CITZ_IND | VARCHAR2(1) | Yes | ||
| SPBPERS_DEAD_DATE | SPBPERS_DEAD_DATE | DATE | Yes | ||
| SPBPERS_PIN | SPBPERS_PIN | RAW(1) | Yes | ||
| SPBPERS_CITZ_CODE | SPBPERS_CITZ_CODE | VARCHAR2(2) | Yes | * | |
| SPBPERS_HAIR_CODE | SPBPERS_HAIR_CODE | VARCHAR2(2) | Yes | ||
| SPBPERS_EYES_CODE | SPBPERS_EYES_CODE | VARCHAR2(2) | Yes | ||
| SPBPERS_CITY_BIRTH | SPBPERS_CITY_BIRTH | VARCHAR2(20) | Yes | ||
| SPBPERS_STAT_CODE_BIRTH | SPBPERS_STAT_CODE_BIRTH | VARCHAR2(3) | Yes | * | |
| SPBPERS_DRIVER_LICENSE | SPBPERS_DRIVER_LICENSE | VARCHAR2(20) | Yes | ||
| SPBPERS_STAT_CODE_DRIVER | SPBPERS_STAT_CODE_DRIVER | VARCHAR2(3) | Yes | * | |
| SPBPERS_NATN_CODE_DRIVER | SPBPERS_NATN_CODE_DRIVER | VARCHAR2(5) | Yes | * | |
| SPBPERS_UOMS_CODE_HEIGHT | SPBPERS_UOMS_CODE_HEIGHT | VARCHAR2(4) | Yes | * | |
| SPBPERS_HEIGHT | SPBPERS_HEIGHT | NUMBER(2,0) | Yes | ||
| SPBPERS_UOMS_CODE_WEIGHT | SPBPERS_UOMS_CODE_WEIGHT | VARCHAR2(4) | Yes | * | |
| SPBPERS_WEIGHT | SPBPERS_WEIGHT | NUMBER(4,0) | Yes | ||
| SPBPERS_SDVET_IND | SPBPERS_SDVET_IND | VARCHAR2(1) | Yes | ||
| SPBPERS_LICENSE_ISSUED_DATE | SPBPERS_LICENSE_ISSUED_DATE | DATE | Yes | ||
| SPBPERS_LICENSE_EXPIRES_DATE | SPBPERS_LICENSE_EXPIRES_DATE | DATE | Yes | ||
| SPBPERS_INCAR_IND | SPBPERS_INCAR_IND | VARCHAR2(1) | Yes | ||
| SPBPERS_WEBID | SPBPERS_WEBID | RAW(1) | Yes | ||
| SPBPERS_WEB_LAST_ACCESS | SPBPERS_WEB_LAST_ACCESS | RAW(1) | Yes | ||
| SPBPERS_PIN_DISABLED_IND | SPBPERS_PIN_DISABLED_IND | RAW(1) | Yes | ||
| SPBPERS_ITIN | SPBPERS_ITIN | NUMBER(9,0) | Yes | ||
| SPBPERS_ACTIVE_DUTY_SEPR_DATE | SPBPERS_ACTIVE_DUTY_SEPR_DATE | DATE | Yes | ||
| SPBPERS_DATA_ORIGIN | SPBPERS_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SPBPERS_USER_ID | 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_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
| SPBPERS_PIDM | GOBSEVS_PIDM | GOBSEVS |
| SPBPERS_LGCY_CODE | STVLGCY_CODE | STVLGCY |
| SPBPERS_ETHN_CODE | STVETHN_CODE | STVETHN |
| SPBPERS_STAT_CODE_DRIVER | STVSTAT_CODE | STVSTAT |
| SPBPERS_STAT_CODE_BIRTH | STVSTAT_CODE | STVSTAT |
| SPBPERS_MRTL_CODE | STVMRTL_CODE | STVMRTL |
| SPBPERS_RELG_CODE | STVRELG_CODE | STVRELG |
| SPBPERS_NATN_CODE_DRIVER | STVNATN_CODE | STVNATN |
| SPBPERS_CITZ_CODE | STVCITZ_CODE | STVCITZ |
| SPBPERS_PIDM | SHRDGMR_PIDM | SHRDGMR |
| SPBPERS_PIDM | SLRRMAT_PIDM | SLRRMAT |
| SPBPERS_UOMS_CODE_WEIGHT | GTVUOMS_CODE | GTVUOMS |
| SPBPERS_UOMS_CODE_HEIGHT | GTVUOMS_CODE | GTVUOMS |
| SPBPERS_PIDM | SGBSTDN_PIDM | SGBSTDN |
| SPBPERS_CITZ_CODE | SARDCSN_CITZ_CODE | SARDCSN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SPBPERS | Unique | SPBPERS_PIDM |
| SPBPERS_SSN_INDEX | SPBPERS_SSN |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table SPRIDEN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SPRIDEN_PIDM | SPRIDEN_PIDM | NUMBER(8,0) | No | * | |
| SPRIDEN_ID | SPRIDEN_ID | VARCHAR2(9) | No | * | |
| SPRIDEN_LAST_NAME | SPRIDEN_LAST_NAME | VARCHAR2(60) | No | ||
| SPRIDEN_FIRST_NAME | SPRIDEN_FIRST_NAME | VARCHAR2(15) | Yes | ||
| SPRIDEN_MI | SPRIDEN_MI | VARCHAR2(15) | Yes | ||
| SPRIDEN_CHANGE_IND | SPRIDEN_CHANGE_IND | VARCHAR2(1) | Yes | ||
| SPRIDEN_ENTITY_IND | SPRIDEN_ENTITY_IND | VARCHAR2(1) | Yes | ||
| SPRIDEN_ACTIVITY_DATE | SPRIDEN_ACTIVITY_DATE | DATE | No | ||
| SPRIDEN_USER | SPRIDEN_USER | VARCHAR2(30) | Yes | ||
| SPRIDEN_ORIGIN | SPRIDEN_ORIGIN | VARCHAR2(30) | Yes | ||
| SPRIDEN_SEARCH_LAST_NAME | SPRIDEN_SEARCH_LAST_NAME | VARCHAR2(60) | Yes | ||
| SPRIDEN_SEARCH_FIRST_NAME | SPRIDEN_SEARCH_FIRST_NAME | VARCHAR2(15) | Yes | ||
| SPRIDEN_SEARCH_MI | SPRIDEN_SEARCH_MI | VARCHAR2(15) | Yes | ||
| SPRIDEN_SOUNDEX_LAST_NAME | SPRIDEN_SOUNDEX_LAST_NAME | CHAR(4) | Yes | ||
| SPRIDEN_SOUNDEX_FIRST_NAME | SPRIDEN_SOUNDEX_FIRST_NAME | CHAR(4) | Yes | ||
| SPRIDEN_NTYP_CODE | SPRIDEN_NTYP_CODE | VARCHAR2(4) | Yes | ||
| SPRIDEN_CREATE_USER | SPRIDEN_CREATE_USER | VARCHAR2(30) | Yes | ||
| SPRIDEN_CREATE_DATE | SPRIDEN_CREATE_DATE | DATE | Yes | ||
| SPRIDEN_DATA_ORIGIN | SPRIDEN_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SPRIDEN_CREATE_FDMN_CODE | SPRIDEN_CREATE_FDMN_CODE | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SPRIDEN_PIDM | RPRATRM_PIDM | RPRATRM |
| SPRIDEN_PIDM | AGRPIDS_XREF_PIDM | AGRPIDS |
| SPRIDEN_PIDM | AGRPIDS_PIDM | AGRPIDS |
| SPRIDEN_PIDM | ASRSSAG_PIDM | ASRSSAG |
| SPRIDEN_PIDM | AOBORGN_PIDM | AOBORGN |
| SPRIDEN_PIDM | ASRSORG_PIDM | ASRSORG |
| SPRIDEN_PIDM | AGRGIDS_XREF_PIDM | AGRGIDS |
| SPRIDEN_PIDM | AGRGIDS_PIDM | AGRGIDS |
| SPRIDEN_PIDM | AGBPLDG_PIDM | AGBPLDG |
| SPRIDEN_PIDM | AGRPMEM_PIDM | AGRPMEM |
| SPRIDEN_PIDM | AGRPMEM_MEMO_PIDM | AGRPMEM |
| SPRIDEN_PIDM | AGRGMEM_PIDM | AGRGMEM |
| SPRIDEN_PIDM | AGRGMEM_MEMO_PIDM | AGRGMEM |
| SPRIDEN_PIDM | AGRGPAY_PIDM | AGRGPAY |
| SPRIDEN_PIDM | APRXREF_XREF_PIDM | APRXREF |
| SPRIDEN_PIDM | GLBEXTR_KEY | GLBEXTR |
| SPRIDEN_PIDM | AGBMGID_EMPR_PIDM | AGBMGID |
| SPRIDEN_PIDM | AGBMGID_EMPL_PIDM | AGBMGID |
| SPRIDEN_PIDM | FRRPRPI_ID_PIDM | FRRPRPI |
| SPRIDEN_PIDM | FIRBOND_IMGR_CODE_PIDM | FIRBOND |
| SPRIDEN_PIDM | FPBAGRH_VEND_PIDM | FPBAGRH |
| SPRIDEN_PIDM | FTVAGCY_AGCY_CODE_PIDM | FTVAGCY |
| SPRIDEN_PIDM | APRCATG_PIDM | APRCATG |
| SPRIDEN_PIDM | AARMEMB_RENEWAL_PIDM | AARMEMB |
| SPRIDEN_PIDM | AARMEMB_REMINDER_PIDM | AARMEMB |
| SPRIDEN_PIDM | APRDRVW_PIDM | APRDRVW |
| SPRIDEN_PIDM | FRBGRNT_AGENCY_PIDM | FRBGRNT |
| SPRIDEN_PIDM | FRRGRPI_ID_PIDM | FRRGRPI |
| SPRIDEN_PIDM | FPRBIDV_VEND_PIDM | FPRBIDV |
| SPRIDEN_PIDM | FPBREQH_VEND_PIDM | FPBREQH |
| SPRIDEN_PIDM | FIRCERD_IMGR_CODE_PIDM | FIRCERD |
| SPRIDEN_PIDM | FIRMMKT_IMGR_CODE_PIDM | FIRMMKT |
| SPRIDEN_PIDM | FIRPRTY_IMGR_CODE_PIDM | FIRPRTY |
| SPRIDEN_PIDM | FTVFMGR_FMGR_CODE_PIDM | FTVFMGR |
| SPRIDEN_PIDM | FIRSTCK_IMGR_CODE_PIDM | FIRSTCK |
| SPRIDEN_PIDM | FIRSTOP_IMGR_CODE_PIDM | FIRSTOP |
| SPRIDEN_PIDM | GERFGST_PIDM | GERFGST |
| SPRIDEN_PIDM | GERATTD_PIDM | GERATTD |
| SPRIDEN_PIDM | GEBFUNC_SPNSR_ORGN_PIDM | GEBFUNC |
| SPRIDEN_PIDM | GORSEVS_PIDM | GORSEVS |
| SPRIDEN_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
| SPRIDEN_PIDM | GOBSEVS_PIDM | GOBSEVS |
| SPRIDEN_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
| SPRIDEN_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
| SPRIDEN_PIDM | PERTETH_TRANS_PIDM | PERTETH |
| SPRIDEN_PIDM | PERHSIP_PIDM | PERHSIP |
| SPRIDEN_PIDM | GOBSRVR_PIDM | GOBSRVR |
| SPRIDEN_PIDM | NBRJOBS_PIDM | NBRJOBS |
| SPRIDEN_PIDM | GOBEACC_PIDM | GOBEACC |
| SPRIDEN_PIDM | NOBTRAN_PIDM | NOBTRAN |
| SPRIDEN_PIDM | PCBPERS_COBRA_BFCTR_PIDM | PCBPERS |
| SPRIDEN_PIDM | PDRBENE_BENE_PIDM | PDRBENE |
| SPRIDEN_PIDM | NBRBJOB_PIDM | NBRBJOB |
| SPRIDEN_PIDM | PERBARG_PIDM | PERBARG |
| SPRIDEN_PIDM | PERJOBS_PIDM | PERJOBS |
| SPRIDEN_PIDM | TBBCONT_PIDM | TBBCONT |
| SPRIDEN_PIDM | TBRCOLC_PIDM | TBRCOLC |
| SPRIDEN_PIDM | TBBCSTU_STU_PIDM | TBBCSTU |
| SPRIDEN_PIDM | TBBACCT_PIDM | TBBACCT |
| SPRIDEN_PIDM | TBBESTU_PIDM | TBBESTU |
| SPRIDEN_PIDM | TBRACCD_PIDM | TBRACCD |
| SPRIDEN_PIDM | FTVCARD_CARDHOLDER_PIDM | FTVCARD |
| SPRIDEN_PIDM | FCREMPO_PIDM | FCREMPO |
| SPRIDEN_PIDM | FABINVH_VEND_PIDM | FABINVH |
| SPRIDEN_PIDM | APBCONS_PIDM | APBCONS |
| SPRIDEN_PIDM | APRERVW_PIDM | APRERVW |
| SPRIDEN_PIDM | APRSRVW_PIDM | APRSRVW |
| SPRIDEN_PIDM | APRCRVW_PIDM | APRCRVW |
| SPRIDEN_PIDM | SIBINST_PIDM | SIBINST |
| SPRIDEN_PIDM | SLBEVNT_AGENCY_PIDM | SLBEVNT |
| SPRIDEN_PIDM | SHTTRAN_PIDM | SHTTRAN |
| SPRIDEN_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SPRIDEN_PIDM | SMBAOGN_PIDM | SMBAOGN |
| SPRIDEN_PIDM | SMRRQCM_ORIG_PIDM | SMRRQCM |
| SPRIDEN_PIDM | SMRRQCM_PIDM | SMRRQCM |
| SPRIDEN_ID | SRTIDEN_ID | SRTIDEN |
| SPRIDEN_PIDM | SRTIDEN_PIDM | SRTIDEN |
| SPRIDEN_PIDM | SHBDIPL_PIDM | SHBDIPL |
| SPRIDEN_PIDM | SORPCOL_PIDM | SORPCOL |
| SPRIDEN_PIDM | SLRRMAT_PIDM | SLRRMAT |
| SPRIDEN_PIDM | SORHSCH_PIDM | SORHSCH |
| SPRIDEN_PIDM | SHBCATT_PIDM | SHBCATT |
| SPRIDEN_PIDM | SORAINF_PIDM | SORAINF |
| SPRIDEN_PIDM | GERPART_PIDM | GERPART |
| SPRIDEN_PIDM | SPBPERS_PIDM | SPBPERS |
| SPRIDEN_PIDM | PEBEMPL_PIDM | PEBEMPL |
| SPRIDEN_PIDM | FTVVEND_PIDM | FTVVEND |
| SPRIDEN_PIDM | FTVCUST_PIDM | FTVCUST |
| SPRIDEN_PIDM | FRBPROP_AGENCY_PIDM | FRBPROP |
| SPRIDEN_PIDM | RNRTMNT_PIDM | RNRTMNT |
| SPRIDEN_PIDM | SIRASGN_PIDM | SIRASGN |
| SPRIDEN_PIDM | SORAROL_PIDM | SORAROL |
| SPRIDEN_PIDM | SABSTUD_PIDM | SABSTUD |
| SPRIDEN_PIDM | SGBSTDN_PIDM | SGBSTDN |
| SPRIDEN_PIDM | SFRENRL_PIDM | SFRENRL |
| SPRIDEN_PIDM | SMBPOGN_PIDM | SMBPOGN |
| SPRIDEN_PIDM | SGRASSI_PIDM | SGRASSI |
| SPRIDEN_PIDM | SHBHEAD_PIDM | SHBHEAD |
| SPRIDEN_PIDM | RORLOGM_PIDM | RORLOGM |
| SPRIDEN_PIDM | SFRSTCR_PIDM | SFRSTCR |
| SPRIDEN_PIDM | SHRDGMR_PIDM | SHRDGMR |
| SPRIDEN_PIDM | AMRCONF_PIDM | AMRCONF |
| 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 |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table STVACTC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVACTC_CODE | STVACTC_CODE | VARCHAR2(8) | No | * | |
| STVACTC_DESC | STVACTC_DESC | VARCHAR2(30) | Yes | ||
| STVACTC_ACTIVITY_DATE | STVACTC_ACTIVITY_DATE | DATE | No | ||
| STVACTC_ACTP_CODE | STVACTC_ACTP_CODE | VARCHAR2(5) | Yes | * | |
| STVACTC_ACCG_CODE | STVACTC_ACCG_CODE | VARCHAR2(5) | Yes | * | |
| STVACTC_LEAD_CODE | STVACTC_LEAD_CODE | VARCHAR2(5) | Yes | * | |
| STVACTC_DISP_WEB_IND | STVACTC_DISP_WEB_IND | RAW(1) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| STVACTC_ACCG_CODE | STVACCG_CODE | STVACCG |
| STVACTC_LEAD_CODE | STVLEAD_CODE | STVLEAD |
| STVACTC_ACTP_CODE | STVACTP_CODE | STVACTP |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVACTC | Unique | STVACTC_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table STVACYR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVACYR_CODE | STVACYR_CODE | VARCHAR2(4) | No | * | |
| STVACYR_DESC | STVACYR_DESC | VARCHAR2(30) | Yes | ||
| STVACYR_ACTIVITY_DATE | STVACYR_ACTIVITY_DATE | DATE | No | ||
| STVACYR_SYSREQ_IND | STVACYR_SYSREQ_IND | VARCHAR2(1) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVACYR | Unique | STVACYR_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table STVADMT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVADMT_CODE | STVADMT_CODE | VARCHAR2(2) | No | * | |
| STVADMT_DESC | STVADMT_DESC | VARCHAR2(30) | No | ||
| STVADMT_ACTIVITY_DATE | STVADMT_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVADMT | Unique | STVADMT_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVADVR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVADVR_CODE | STVADVR_CODE | VARCHAR2(4) | No | * | |
| STVADVR_DESC | STVADVR_DESC | VARCHAR2(30) | No | ||
| STVADVR_ACTIVITY_DATE | STVADVR_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVADVR | Unique | STVADVR_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVAFDC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVAFDC_CODE | STVAFDC_CODE | VARCHAR2(1) | No | * | |
| STVAFDC_DESC | STVAFDC_DESC | VARCHAR2(30) | No | ||
| STVAFDC_ACTIVITY_DATE | STVAFDC_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVAFDC | Unique | STVAFDC_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table STVAPRN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVAPRN_CODE | STVAPRN_CODE | VARCHAR2(2) | No | * | |
| STVAPRN_DESC | STVAPRN_DESC | VARCHAR2(30) | No | ||
| STVAPRN_ACTIVITY_DATE | STVAPRN_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVAPRN | Unique | STVAPRN_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table STVASTD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVASTD_CODE | STVASTD_CODE | VARCHAR2(2) | No | * | |
| STVASTD_DESC | STVASTD_DESC | VARCHAR2(30) | No | ||
| STVASTD_PROBATION_IND | STVASTD_PROBATION_IND | VARCHAR2(1) | Yes | ||
| STVASTD_PREVENT_REG_IND | STVASTD_PREVENT_REG_IND | VARCHAR2(1) | Yes | ||
| STVASTD_MAX_REG_HOURS | STVASTD_MAX_REG_HOURS | NUMBER(9,3) | Yes | ||
| STVASTD_ACTIVITY_DATE | STVASTD_ACTIVITY_DATE | DATE | No | ||
| STVASTD_DEANS_LIST_IND | STVASTD_DEANS_LIST_IND | VARCHAR2(1) | Yes | ||
| STVASTD_SYSTEM_REQ_IND | STVASTD_SYSTEM_REQ_IND | VARCHAR2(1) | Yes | ||
| STVASTD_EDI_EQUIV | STVASTD_EDI_EQUIV | VARCHAR2(3) | Yes | ||
| STVASTD_VR_MSG_NO | STVASTD_VR_MSG_NO | NUMBER(6,0) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVASTD | Unique | STVASTD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table STVATTS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVATTS_CODE | STVATTS_CODE | VARCHAR2(4) | No | * | |
| STVATTS_DESC | STVATTS_DESC | VARCHAR2(30) | No | ||
| STVATTS_ACTIVITY_DATE | STVATTS_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVATTS | Unique | STVATTS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table STVBLCK| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVBLCK_CODE | STVBLCK_CODE | VARCHAR2(10) | No | * | |
| STVBLCK_DESC | STVBLCK_DESC | VARCHAR2(30) | No | ||
| STVBLCK_ACTIVITY_DATE | STVBLCK_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVBLCK | Unique | STVBLCK_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table STVBSKL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVBSKL_CODE | STVBSKL_CODE | VARCHAR2(2) | No | * | |
| STVBSKL_DESC | STVBSKL_DESC | VARCHAR2(30) | No | ||
| STVBSKL_ACTIVITY_DATE | STVBSKL_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVBSKL | Unique | STVBSKL_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table STVCAMP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVCAMP_CODE | STVCAMP_CODE | VARCHAR2(3) | No | * | |
| STVCAMP_DESC | STVCAMP_DESC | VARCHAR2(30) | Yes | ||
| STVCAMP_ACTIVITY_DATE | STVCAMP_ACTIVITY_DATE | DATE | No | ||
| STVCAMP_DICD_CODE | STVCAMP_DICD_CODE | VARCHAR2(3) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVCAMP | Unique | STVCAMP_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:37:000 |
Table STVCAPL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVCAPL_CODE | STVCAPL_CODE | VARCHAR2(2) | No | * | |
| STVCAPL_DESC | STVCAPL_DESC | VARCHAR2(30) | Yes | ||
| STVCAPL_ACTIVITY_DATE | STVCAPL_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVCAPL | Unique | STVCAPL_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table STVCAST| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVCAST_CODE | STVCAST_CODE | VARCHAR2(2) | No | * | |
| STVCAST_DESC | STVCAST_DESC | VARCHAR2(30) | No | ||
| STVCAST_DEANS_LIST_IND | STVCAST_DEANS_LIST_IND | VARCHAR2(1) | No | ||
| STVCAST_PROBATION_IND | STVCAST_PROBATION_IND | VARCHAR2(1) | No | ||
| STVCAST_PREVENT_REG_IND | STVCAST_PREVENT_REG_IND | VARCHAR2(1) | No | ||
| STVCAST_SYS_REQ_IND | STVCAST_SYS_REQ_IND | VARCHAR2(1) | No | ||
| STVCAST_USER_ID | STVCAST_USER_ID | VARCHAR2(30) | No | ||
| STVCAST_ACTIVITY_DATE | STVCAST_ACTIVITY_DATE | DATE | No | ||
| STVCAST_MAX_REG_HOURS | STVCAST_MAX_REG_HOURS | NUMBER(9,3) | Yes | ||
| STVCAST_EDI_EQUIV | STVCAST_EDI_EQUIV | VARCHAR2(3) | Yes | ||
| STVCAST_VR_MSG_NO | STVCAST_VR_MSG_NO | NUMBER(6,0) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVCAST | Unique | STVCAST_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table STVCHRT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVCHRT_CODE | STVCHRT_CODE | VARCHAR2(10) | No | * | |
| STVCHRT_DESC | STVCHRT_DESC | VARCHAR2(30) | No | ||
| STVCHRT_TERM_CODE_START | STVCHRT_TERM_CODE_START | VARCHAR2(6) | Yes | * | |
| STVCHRT_TERM_CODE_END | STVCHRT_TERM_CODE_END | VARCHAR2(6) | Yes | * | |
| STVCHRT_DLEV_CODE | STVCHRT_DLEV_CODE | VARCHAR2(2) | Yes | * | |
| STVCHRT_ACTIVITY_DATE | STVCHRT_ACTIVITY_DATE | DATE | No | ||
| STVCHRT_RIGHT_IND | STVCHRT_RIGHT_IND | VARCHAR2(1) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| STVCHRT_TERM_CODE_START | STVTERM_CODE | STVTERM |
| STVCHRT_TERM_CODE_END | STVTERM_CODE | STVTERM |
| STVCHRT_DLEV_CODE | STVDLEV_CODE | STVDLEV |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVCHRT | Unique | STVCHRT_CODE |
| STVCHRT_KEY_INDEX2 | STVCHRT_TERM_CODE_START |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVCLAS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVCLAS_CODE | STVCLAS_CODE | VARCHAR2(2) | No | * | |
| STVCLAS_DESC | STVCLAS_DESC | VARCHAR2(30) | No | ||
| STVCLAS_ACTIVITY_DATE | STVCLAS_ACTIVITY_DATE | DATE | No | ||
| STVCLAS_EDI_EQUIV | STVCLAS_EDI_EQUIV | VARCHAR2(2) | Yes | ||
| STVCLAS_LMS_EQUIV | STVCLAS_LMS_EQUIV | VARCHAR2(3) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVCLAS | Unique | STVCLAS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table STVCOLL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVCOLL_CODE | STVCOLL_CODE | VARCHAR2(2) | No | * | |
| STVCOLL_DESC | STVCOLL_DESC | VARCHAR2(30) | No | ||
| STVCOLL_ADDR_STREET_LINE1 | STVCOLL_ADDR_STREET_LINE1 | VARCHAR2(30) | Yes | ||
| STVCOLL_ADDR_STREET_LINE2 | STVCOLL_ADDR_STREET_LINE2 | VARCHAR2(30) | Yes | ||
| STVCOLL_ADDR_STREET_LINE3 | STVCOLL_ADDR_STREET_LINE3 | VARCHAR2(30) | Yes | ||
| STVCOLL_ADDR_CITY | STVCOLL_ADDR_CITY | VARCHAR2(20) | Yes | ||
| STVCOLL_ADDR_STATE | STVCOLL_ADDR_STATE | VARCHAR2(2) | Yes | ||
| STVCOLL_ADDR_COUNTRY | STVCOLL_ADDR_COUNTRY | VARCHAR2(28) | Yes | ||
| STVCOLL_ADDR_ZIP_CODE | STVCOLL_ADDR_ZIP_CODE | VARCHAR2(10) | Yes | ||
| STVCOLL_ACTIVITY_DATE | STVCOLL_ACTIVITY_DATE | DATE | Yes | ||
| STVCOLL_SYSTEM_REQ_IND | STVCOLL_SYSTEM_REQ_IND | VARCHAR2(1) | Yes | ||
| STVCOLL_VR_MSG_NO | STVCOLL_VR_MSG_NO | NUMBER(6,0) | Yes | ||
| STVCOLL_STATSCAN_CDE3 | STVCOLL_STATSCAN_CDE3 | VARCHAR2(6) | Yes | ||
| STVCOLL_DICD_CODE | STVCOLL_DICD_CODE | VARCHAR2(3) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVCOLL | Unique | STVCOLL_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table STVCOPC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVCOPC_CODE | STVCOPC_CODE | VARCHAR2(6) | No | * | |
| STVCOPC_DESC | STVCOPC_DESC | VARCHAR2(30) | Yes | ||
| STVCOPC_ACTIVITY_DATE | STVCOPC_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVCOPC | Unique | STVCOPC_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table STVCREA| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVCREA_CODE | STVCREA_CODE | VARCHAR2(4) | No | * | |
| STVCREA_DESC | STVCREA_DESC | VARCHAR2(30) | No | ||
| STVCREA_ACTIVITY_DATE | STVCREA_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVCREA | Unique | STVCREA_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table STVDEPS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVDEPS_CODE | STVDEPS_CODE | VARCHAR2(1) | No | * | |
| STVDEPS_DESC | STVDEPS_DESC | VARCHAR2(30) | No | ||
| STVDEPS_ACTIVITY_DATE | STVDEPS_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVDEPS | Unique | STVDEPS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVDISA| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVDISA_CODE | STVDISA_CODE | VARCHAR2(2) | No | * | |
| STVDISA_DESC | STVDISA_DESC | VARCHAR2(30) | No | ||
| STVDISA_ACTIVITY_DATE | STVDISA_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVDISA | Unique | STVDISA_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table STVDLEV| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVDLEV_CODE | STVDLEV_CODE | VARCHAR2(2) | No | * | |
| STVDLEV_DESC | STVDLEV_DESC | VARCHAR2(30) | No | ||
| STVDLEV_ACTIVITY_DATE | STVDLEV_ACTIVITY_DATE | DATE | No | ||
| STVDLEV_NUMERIC_VALUE | STVDLEV_NUMERIC_VALUE | NUMBER(2,0) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVDLEV | Unique | STVDLEV_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table STVEDLV| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVEDLV_CODE | STVEDLV_CODE | VARCHAR2(3) | No | * | |
| STVEDLV_DESC | STVEDLV_DESC | VARCHAR2(30) | No | ||
| STVEDLV_ACTIVITY_DATE | STVEDLV_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVEDLV | Unique | STVEDLV_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table STVEGOL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVEGOL_CODE | STVEGOL_CODE | VARCHAR2(2) | No | * | |
| STVEGOL_DESC | STVEGOL_DESC | VARCHAR2(30) | No | ||
| STVEGOL_ACTIVITY_DATE | STVEGOL_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVEGOL | Unique | STVEGOL_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVELIG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVELIG_CODE | STVELIG_CODE | VARCHAR2(2) | No | * | |
| STVELIG_DESC | STVELIG_DESC | VARCHAR2(30) | No | ||
| STVELIG_ACTIVITY_DATE | STVELIG_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVELIG | Unique | STVELIG_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table STVEMEX| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVEMEX_CODE | STVEMEX_CODE | VARCHAR2(2) | No | * | |
| STVEMEX_DESC | STVEMEX_DESC | VARCHAR2(30) | No | ||
| STVEMEX_ACTIVITY_DATE | STVEMEX_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVEMEX | Unique | STVEMEX_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table STVEMPL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVEMPL_CODE | STVEMPL_CODE | VARCHAR2(4) | No | * | |
| STVEMPL_DESC | STVEMPL_DESC | VARCHAR2(30) | Yes | ||
| STVEMPL_STREET_LINE1 | STVEMPL_STREET_LINE1 | VARCHAR2(30) | Yes | ||
| STVEMPL_STREET_LINE2 | STVEMPL_STREET_LINE2 | VARCHAR2(30) | Yes | ||
| STVEMPL_STREET_LINE3 | STVEMPL_STREET_LINE3 | VARCHAR2(30) | Yes | ||
| STVEMPL_CITY | STVEMPL_CITY | VARCHAR2(20) | Yes | ||
| STVEMPL_STAT_CODE | STVEMPL_STAT_CODE | VARCHAR2(3) | Yes | * | |
| STVEMPL_ZIP | STVEMPL_ZIP | VARCHAR2(10) | Yes | ||
| STVEMPL_NATN_CODE | STVEMPL_NATN_CODE | VARCHAR2(5) | Yes | * | |
| STVEMPL_PHONE_AREA | STVEMPL_PHONE_AREA | VARCHAR2(3) | Yes | ||
| STVEMPL_PHONE_NUMBER | STVEMPL_PHONE_NUMBER | VARCHAR2(7) | Yes | ||
| STVEMPL_PHONE_EXT | STVEMPL_PHONE_EXT | VARCHAR2(4) | Yes | ||
| STVEMPL_ACTIVITY_DATE | STVEMPL_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| STVEMPL_STAT_CODE | STVSTAT_CODE | STVSTAT |
| STVEMPL_NATN_CODE | STVNATN_CODE | STVNATN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVEMPL | Unique | STVEMPL_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table STVEOPS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVEOPS_CODE | STVEOPS_CODE | VARCHAR2(2) | No | * | |
| STVEOPS_DESC | STVEOPS_DESC | VARCHAR2(30) | No | ||
| STVEOPS_ACTIVITY_DATE | STVEOPS_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVEOPS | Unique | STVEOPS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table STVESEL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVESEL_CODE | STVESEL_CODE | VARCHAR2(2) | No | * | |
| STVESEL_DESC | STVESEL_DESC | VARCHAR2(30) | No | ||
| STVESEL_ACTIVITY_DATE | STVESEL_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVESEL | Unique | STVESEL_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table STVGAIN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVGAIN_CODE | STVGAIN_CODE | VARCHAR2(2) | No | * | |
| STVGAIN_DESC | STVGAIN_DESC | VARCHAR2(30) | No | ||
| STVGAIN_ACTIVITY_DATE | STVGAIN_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVGAIN | Unique | STVGAIN_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table STVGSTA| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVGSTA_CODE | STVGSTA_CODE | VARCHAR2(2) | No | * | |
| STVGSTA_DESC | STVGSTA_DESC | VARCHAR2(30) | No | ||
| STVGSTA_ACTIVITY_DATE | STVGSTA_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVGSTA | Unique | STVGSTA_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table STVGTYP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVGTYP_CODE | STVGTYP_CODE | VARCHAR2(6) | No | * | |
| STVGTYP_DESC | STVGTYP_DESC | VARCHAR2(30) | No | ||
| STVGTYP_ACTIVITY_DATE | STVGTYP_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVGTYP | Unique | STVGTYP_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table STVINCM| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVINCM_CODE | STVINCM_CODE | VARCHAR2(2) | No | * | |
| STVINCM_DESC | STVINCM_DESC | VARCHAR2(30) | No | ||
| STVINCM_ACTIVITY_DATE | STVINCM_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVINCM | Unique | STVINCM_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table STVLEAV| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVLEAV_CODE | STVLEAV_CODE | VARCHAR2(1) | No | * | |
| STVLEAV_DESC | STVLEAV_DESC | VARCHAR2(30) | Yes | ||
| STVLEAV_ACTIVITY_DATE | STVLEAV_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVLEAV | Unique | STVLEAV_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/07/2004 04:58:26:000 |
Table STVLEVL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVLEVL_CODE | STVLEVL_CODE | VARCHAR2(2) | No | * | * |
| STVLEVL_DESC | STVLEVL_DESC | VARCHAR2(30) | No | ||
| STVLEVL_ACTIVITY_DATE | STVLEVL_ACTIVITY_DATE | DATE | No | ||
| STVLEVL_ACAD_IND | STVLEVL_ACAD_IND | VARCHAR2(1) | Yes | ||
| STVLEVL_CEU_IND | STVLEVL_CEU_IND | VARCHAR2(1) | No | ||
| STVLEVL_SYSTEM_REQ_IND | STVLEVL_SYSTEM_REQ_IND | VARCHAR2(1) | Yes | ||
| STVLEVL_VR_MSG_NO | STVLEVL_VR_MSG_NO | NUMBER(6,0) | Yes | ||
| STVLEVL_EDI_EQUIV | STVLEVL_EDI_EQUIV | VARCHAR2(2) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| STVLEVL_CODE | SFTREGS_LEVL_CODE | SFTREGS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVLEVL | Unique | STVLEVL_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table STVMARS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVMARS_CODE | STVMARS_CODE | VARCHAR2(1) | No | * | |
| STVMARS_DESC | STVMARS_DESC | VARCHAR2(30) | No | ||
| STVMARS_ACTIVITY_DATE | STVMARS_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVMARS | Unique | STVMARS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table STVMEDI| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVMEDI_CODE | STVMEDI_CODE | VARCHAR2(2) | No | * | |
| STVMEDI_DESC | STVMEDI_DESC | VARCHAR2(30) | Yes | ||
| STVMEDI_ACTIVITY_DATE | STVMEDI_ACTIVITY_DATE | DATE | No | ||
| STVMEDI_DISP_WEB_IND | STVMEDI_DISP_WEB_IND | RAW(1) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVMEDI | Unique | STVMEDI_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table STVORIG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVORIG_CODE | STVORIG_CODE | VARCHAR2(4) | No | * | |
| STVORIG_DESC | STVORIG_DESC | VARCHAR2(30) | Yes | ||
| STVORIG_ACTIVITY_DATE | STVORIG_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVORIG | Unique | STVORIG_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table STVORSN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVORSN_CODE | STVORSN_CODE | VARCHAR2(1) | No | * | |
| STVORSN_DESC | STVORSN_DESC | VARCHAR2(30) | Yes | ||
| STVORSN_ACTIVITY_DATE | STVORSN_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVORSN | Unique | STVORSN_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table STVPRAC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVPRAC_CODE | STVPRAC_CODE | VARCHAR2(2) | No | * | |
| STVPRAC_DESC | STVPRAC_DESC | VARCHAR2(30) | Yes | ||
| STVPRAC_ACTIVITY_DATE | STVPRAC_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVPRAC | Unique | STVPRAC_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table STVPREV| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVPREV_CODE | STVPREV_CODE | VARCHAR2(2) | No | * | |
| STVPREV_DESC | STVPREV_DESC | VARCHAR2(30) | No | ||
| STVPREV_SYS_REQ_IND | STVPREV_SYS_REQ_IND | VARCHAR2(1) | No | ||
| STVPREV_USER_ID | STVPREV_USER_ID | VARCHAR2(30) | No | ||
| STVPREV_ACTIVITY_DATE | STVPREV_ACTIVITY_DATE | DATE | No | ||
| STVPREV_VR_MSG_NO | STVPREV_VR_MSG_NO | NUMBER(6,0) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVPREV | Unique | STVPREV_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table STVRATE| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVRATE_CODE | STVRATE_CODE | VARCHAR2(5) | No | * | |
| STVRATE_DESC | STVRATE_DESC | VARCHAR2(30) | Yes | ||
| STVRATE_ACTIVITY_DATE | STVRATE_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVRATE | Unique | STVRATE_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table STVRESD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVRESD_CODE | STVRESD_CODE | VARCHAR2(1) | No | * | |
| STVRESD_DESC | STVRESD_DESC | VARCHAR2(30) | Yes | ||
| STVRESD_IN_STATE_IND | STVRESD_IN_STATE_IND | VARCHAR2(1) | Yes | ||
| STVRESD_ACTIVITY_DATE | STVRESD_ACTIVITY_DATE | DATE | No | ||
| STVRESD_SYSTEM_REQ_IND | STVRESD_SYSTEM_REQ_IND | VARCHAR2(1) | Yes | ||
| STVRESD_VR_MSG_NO | STVRESD_VR_MSG_NO | NUMBER(6,0) | Yes | ||
| STVRESD_DISP_WEB_IND | STVRESD_DISP_WEB_IND | RAW(1) | Yes | ||
| STVRESD_EDI_EQUIV | STVRESD_EDI_EQUIV | VARCHAR2(1) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVRESD | Unique | STVRESD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table STVSEPR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSEPR_CODE | STVSEPR_CODE | VARCHAR2(2) | No | * | |
| STVSEPR_DESC | STVSEPR_DESC | VARCHAR2(30) | No | ||
| STVSEPR_ACTIVITY_DATE | STVSEPR_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSEPR | Unique | STVSEPR_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table STVSESS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSESS_CODE | STVSESS_CODE | VARCHAR2(1) | No | * | |
| STVSESS_DESC | STVSESS_DESC | VARCHAR2(30) | No | ||
| STVSESS_ACTIVITY_DATE | STVSESS_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSESS | Unique | STVSESS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table STVSFAE| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSFAE_CODE | STVSFAE_CODE | VARCHAR2(2) | No | * | |
| STVSFAE_DESC | STVSFAE_DESC | VARCHAR2(30) | No | ||
| STVSFAE_ACTIVITY_DATE | STVSFAE_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSFAE | Unique | STVSFAE_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table STVSITE| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSITE_CODE | STVSITE_CODE | VARCHAR2(3) | No | * | |
| STVSITE_DESC | STVSITE_DESC | VARCHAR2(30) | Yes | ||
| STVSITE_STREET_ADDR1 | STVSITE_STREET_ADDR1 | VARCHAR2(30) | Yes | ||
| STVSITE_STREET_ADDR2 | STVSITE_STREET_ADDR2 | VARCHAR2(30) | Yes | ||
| STVSITE_STREET_ADDR3 | STVSITE_STREET_ADDR3 | VARCHAR2(30) | Yes | ||
| STVSITE_CITY | STVSITE_CITY | VARCHAR2(20) | Yes | ||
| STVSITE_STATE | STVSITE_STATE | VARCHAR2(3) | Yes | ||
| STVSITE_FOREIGN_COUNTRY | STVSITE_FOREIGN_COUNTRY | VARCHAR2(28) | Yes | ||
| STVSITE_ZIPC | STVSITE_ZIPC | VARCHAR2(10) | Yes | ||
| STVSITE_ACTIVITY_DATE | STVSITE_ACTIVITY_DATE | DATE | No | ||
| STVSITE_NATN_CODE | STVSITE_NATN_CODE | VARCHAR2(5) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSITE | Unique | STVSITE_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/07/2004 04:58:26:000 |
Table STVSOFF| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSOFF_CODE | STVSOFF_CODE | VARCHAR2(6) | No | * | |
| STVSOFF_DESC | STVSOFF_DESC | VARCHAR2(30) | No | ||
| STVSOFF_ACTIVITY_DATE | STVSOFF_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSOFF | Unique | STVSOFF_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table STVSPRV| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSPRV_CODE | STVSPRV_CODE | VARCHAR2(6) | No | * | |
| STVSPRV_DESC | STVSPRV_DESC | VARCHAR2(30) | No | ||
| STVSPRV_ACTIVITY_DATE | STVSPRV_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSPRV | Unique | STVSPRV_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table STVSPSR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSPSR_CODE | STVSPSR_CODE | VARCHAR2(2) | No | * | |
| STVSPSR_DESC | STVSPSR_DESC | VARCHAR2(30) | No | ||
| STVSPSR_ACTIVITY_DATE | STVSPSR_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSPSR | Unique | STVSPSR_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table STVSPST| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSPST_CODE | STVSPST_CODE | VARCHAR2(2) | No | * | |
| STVSPST_DESC | STVSPST_DESC | VARCHAR2(30) | No | ||
| STVSPST_ACTIVITY_DATE | STVSPST_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSPST | Unique | STVSPST_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table STVSSEP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSSEP_CODE | STVSSEP_CODE | VARCHAR2(4) | No | * | |
| STVSSEP_DESC | STVSSEP_DESC | VARCHAR2(30) | No | ||
| STVSSEP_ACTIVITY_DATE | STVSSEP_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSSEP | Unique | STVSSEP_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table STVSSER| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSSER_CODE | STVSSER_CODE | VARCHAR2(4) | No | * | |
| STVSSER_DESC | STVSSER_DESC | VARCHAR2(30) | No | ||
| STVSSER_TYPE | STVSSER_TYPE | VARCHAR2(2) | Yes | ||
| STVSSER_ACTIVITY_DATE | STVSSER_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSSER | Unique | STVSSER_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table STVSSRS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSSRS_CODE | STVSSRS_CODE | VARCHAR2(2) | No | * | |
| STVSSRS_DESC | STVSSRS_DESC | VARCHAR2(30) | No | ||
| STVSSRS_ACTIVITY_DATE | STVSSRS_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSSRS | Unique | STVSSRS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table STVSSST| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSSST_CODE | STVSSST_CODE | VARCHAR2(2) | No | * | |
| STVSSST_DESC | STVSSST_DESC | VARCHAR2(30) | No | ||
| STVSSST_ACTIVITY_DATE | STVSSST_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSSST | Unique | STVSSST_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table STVSTST| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSTST_CODE | STVSTST_CODE | VARCHAR2(2) | No | * | |
| STVSTST_DESC | STVSTST_DESC | VARCHAR2(30) | No | ||
| STVSTST_REG_IND | STVSTST_REG_IND | VARCHAR2(1) | Yes | ||
| STVSTST_ACTIVITY_DATE | STVSTST_ACTIVITY_DATE | DATE | No | ||
| STVSTST_SYSTEM_REQ_IND | STVSTST_SYSTEM_REQ_IND | VARCHAR2(1) | Yes | ||
| STVSTST_CSTS_CODE | STVSTST_CSTS_CODE | VARCHAR2(15) | Yes | * | |
| STVSTST_CACT_CODE | STVSTST_CACT_CODE | VARCHAR2(15) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| STVSTST_CACT_CODE | STVCACT_CODE | STVCACT |
| STVSTST_CSTS_CODE | STVCSTS_CODE | STVCSTS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSTST | Unique | STVSTST_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVSTYP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSTYP_CODE | STVSTYP_CODE | VARCHAR2(1) | No | * | |
| STVSTYP_DESC | STVSTYP_DESC | VARCHAR2(30) | Yes | ||
| STVSTYP_NEXT_STATUS | STVSTYP_NEXT_STATUS | VARCHAR2(1) | Yes | ||
| STVSTYP_ACTIVITY_DATE | STVSTYP_ACTIVITY_DATE | DATE | No | ||
| STVSTYP_SYSTEM_REQ_IND | STVSTYP_SYSTEM_REQ_IND | VARCHAR2(1) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSTYP | Unique | STVSTYP_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVSUDA| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSUDA_CODE | STVSUDA_CODE | VARCHAR2(15) | No | * | |
| STVSUDA_DESC | STVSUDA_DESC | VARCHAR2(30) | No | ||
| STVSUDA_ACTIVITY_DATE | STVSUDA_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSUDA | Unique | STVSUDA_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table STVSUDB| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSUDB_CODE | STVSUDB_CODE | VARCHAR2(15) | No | * | |
| STVSUDB_DESC | STVSUDB_DESC | VARCHAR2(30) | No | ||
| STVSUDB_ACTIVITY_DATE | STVSUDB_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSUDB | Unique | STVSUDB_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table STVSUDC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSUDC_CODE | STVSUDC_CODE | VARCHAR2(15) | No | * | |
| STVSUDC_DESC | STVSUDC_DESC | VARCHAR2(30) | No | ||
| STVSUDC_ACTIVITY_DATE | STVSUDC_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSUDC | Unique | STVSUDC_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table STVSUDD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSUDD_CODE | STVSUDD_CODE | VARCHAR2(15) | No | * | |
| STVSUDD_DESC | STVSUDD_DESC | VARCHAR2(30) | No | ||
| STVSUDD_ACTIVITY_DATE | STVSUDD_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSUDD | Unique | STVSUDD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table STVSUDE| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSUDE_CODE | STVSUDE_CODE | VARCHAR2(15) | No | * | |
| STVSUDE_DESC | STVSUDE_DESC | VARCHAR2(30) | No | ||
| STVSUDE_ACTIVITY_DATE | STVSUDE_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSUDE | Unique | STVSUDE_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVSUDF| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSUDF_CODE | STVSUDF_CODE | VARCHAR2(15) | No | * | |
| STVSUDF_DESC | STVSUDF_DESC | VARCHAR2(30) | No | ||
| STVSUDF_ACTIVITY_DATE | STVSUDF_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSUDF | Unique | STVSUDF_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVSUDG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSUDG_CODE | STVSUDG_CODE | VARCHAR2(15) | No | * | |
| STVSUDG_DESC | STVSUDG_DESC | VARCHAR2(30) | No | ||
| STVSUDG_ACTIVITY_DATE | STVSUDG_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSUDG | Unique | STVSUDG_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVSUDH| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSUDH_CODE | STVSUDH_CODE | VARCHAR2(15) | No | * | |
| STVSUDH_DESC | STVSUDH_DESC | VARCHAR2(30) | No | ||
| STVSUDH_ACTIVITY_DATE | STVSUDH_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSUDH | Unique | STVSUDH_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVSUDI| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSUDI_CODE | STVSUDI_CODE | VARCHAR2(15) | No | * | |
| STVSUDI_DESC | STVSUDI_DESC | VARCHAR2(30) | No | ||
| STVSUDI_ACTIVITY_DATE | STVSUDI_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSUDI | Unique | STVSUDI_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVSUDJ| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVSUDJ_CODE | STVSUDJ_CODE | VARCHAR2(15) | No | * | |
| STVSUDJ_DESC | STVSUDJ_DESC | VARCHAR2(30) | No | ||
| STVSUDJ_ACTIVITY_DATE | STVSUDJ_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVSUDJ | Unique | STVSUDJ_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table STVTASK| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVTASK_CODE | STVTASK_CODE | VARCHAR2(6) | No | * | |
| STVTASK_DESC | STVTASK_DESC | VARCHAR2(30) | No | ||
| STVTASK_ACTIVITY_DATE | STVTASK_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVTASK | Unique | STVTASK_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVTRCN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVTRCN_CODE | STVTRCN_CODE | VARCHAR2(2) | No | * | |
| STVTRCN_DESC | STVTRCN_DESC | VARCHAR2(30) | No | ||
| STVTRCN_ACTIVITY_DATE | STVTRCN_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVTRCN | Unique | STVTRCN_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table STVVETC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVVETC_CODE | STVVETC_CODE | VARCHAR2(1) | No | * | |
| STVVETC_DESC | STVVETC_DESC | VARCHAR2(30) | No | ||
| STVVETC_ACTIVITY_DATE | STVVETC_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVVETC | Unique | STVVETC_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table STVVOED| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVVOED_CODE | STVVOED_CODE | VARCHAR2(2) | No | * | |
| STVVOED_DESC | STVVOED_DESC | VARCHAR2(30) | No | ||
| STVVOED_ACTIVITY_DATE | STVVOED_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVVOED | Unique | STVVOED_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table STVWTHD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVWTHD_CODE | STVWTHD_CODE | VARCHAR2(1) | No | * | |
| STVWTHD_DESC | STVWTHD_DESC | VARCHAR2(30) | No | ||
| STVWTHD_ACTIVITY_DATE | STVWTHD_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVWTHD | Unique | STVWTHD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Link between SGBSTDN and SHRLGPA| Objects list |
|---|
| forms-data-block-trigger : BANNER7_FORMS.RPAELAP.RPRLAPP.CHECK_DISB_REC_DELAY
forms-data-block-trigger : BANNER7_FORMS.RPALORG.RPRLAPP.CHECK_DISB_REC_DELAY forms-data-block-trigger : BANNER7_FORMS_10G.RPAELAP.RPRLAPP.CHECK_DISB_REC_DELAY forms-data-block-trigger : BANNER7_FORMS_10G.RPALORG.RPRLAPP.CHECK_DISB_REC_DELAY |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SGBSTDN and SHRLGPA | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SGBSTDN | SHRLGPA |
Link between SPRIDEN and SGBSTDN| Objects list |
|---|
| schema-view : S4B70.BANINST1.SGVSTD2
schema-view : S4B70.BANINST1.SHVDEAN schema-view : S4B70.BANINST1.SHVACST |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and SGBSTDN | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | SGBSTDN |
Link between SPBPERS and SGBSTDN| Objects list |
|---|
| schema-view : S4B70.BANINST1.SGVSTD2 |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPBPERS and SGBSTDN | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPBPERS | SGBSTDN |
Link between SPRIDEN and SGRASSI| Objects list |
|---|
| schema-view : S4B70.BANINST1.SGVASSI |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and SGRASSI | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | SGRASSI |
Link between SFRMHRS and SGBSTDN| Objects list |
|---|
| forms-module-trigger : BANNER7_FORMS.SFAREGS.GET_MHRS
forms-module-trigger : BANNER7_FORMS_10G.SFAREGS.GET_MHRS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SFRMHRS and SGBSTDN | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SFRMHRS | SGBSTDN |
Link between SGBSTDN and SHRTTRM| Objects list |
|---|
| schema-view : S4B70.BANINST1.SHVDEAN
schema-view : S4B70.BANINST1.SHVACST |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SGBSTDN and SHRTTRM | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SGBSTDN | SHRTTRM |
Link between SPRIDEN and SPBPERS| Objects list |
|---|
| forms-pl/sql-library-procedure : BANNER7_FORMS.GOQRPLS.G$_SEL_SPRIDEN_ID_NAME
forms-pl/sql-library-procedure : BANNER7_FORMS.GOQRPLS.G$_VALID_ALL_ID forms-pl/sql-library-procedure : BANNER7_FORMS.AOQRPLS.A$_SEL_ID_INFO forms-pl/sql-library-procedure : BANNER7_FORMS.AOQRPLS.A$_SEL_ID_PERS_INFO forms-module-procedure : BANNER7_FORMS.AMAPROS.LOAD_STAFF_BLOCK forms-module-record-group : BANNER7_FORMS.AGAPMEM.THIRDPP_IDS_RG forms-module-procedure : BANNER7_FORMS.AMACONT.A$_SEL_ID_INFO forms-module-procedure : BANNER7_FORMS.AOQOLIB.A$_SEL_ID_INFO forms-module-procedure : BANNER7_FORMS.AOQOLIB.A$_SEL_ID_PERS_INFO forms-module-record-group : BANNER7_FORMS.AGAGMEM.THIRDPP_IDS_RG forms-module-record-group : BANNER7_FORMS.AGATPAY.THIRDPP_MEM_RG forms-data-block-item-trigger : BANNER7_FORMS.APACHLD.APRCHLD.APRCHLD_OTHR_PIDM."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.APACHLD.APRCHLD.OTHR_ID."POST-CHANGE" forms-module-record-group : BANNER7_FORMS.APACOMB.APRXREF_RG forms-module-record-group : BANNER7_FORMS.APACOMB.XREF_ID_RG forms-module-record-group : BANNER7_FORMS.AGAPIDS.THIRDPP_MEM_RG forms-module-record-group : BANNER7_FORMS.AGAGIDS.THIRDPP_MEM_RG forms-data-block-trigger : BANNER7_FORMS.AMASTAF.AMRCONT2."POST-QUERY" forms-module-procedure : BANNER7_FORMS.ASAMRES.SEL_SOLICITOR_ID_INFO forms-module-procedure : BANNER7_FORMS.ASASIGN.SEL_CTYP_SOL_ID_INFO forms-module-procedure : BANNER7_FORMS.ASASIGN.SEL_KEY_SOL_ID_INFO forms-module-procedure : BANNER7_FORMS.ASASANG.SEL_SOLICITOR_ID_INFO forms-module-procedure : BANNER7_FORMS.APAIDEN.SEL_ID_INFO_CUSTOM forms-data-block-item-trigger : BANNER7_FORMS.APACRVW.APRCRVW.APRCRVW_OTHR_PIDM."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.APACRVW.APRCRVW.OTHR_ID."WHEN-VALIDATE-ITEM" forms-data-block-trigger : BANNER7_FORMS.APASBIO.APRXREF."POST-QUERY" schema-view : S4B70.BANINST1.APVBRWS forms-module-procedure : BANNER7_FORMS.ASAASCT.SEL_SOLICITOR_ID_INFO forms-data-block-item-trigger : BANNER7_FORMS.APACONS.APRCSPS.SPS_ID."POST-CHANGE" forms-module-procedure : BANNER7_FORMS.ASICONT.SEL_NON_CONS_ID_INFO forms-module-function : BANNER7_FORMS.FAAONLC.SELECT_SPRIDEN_1 forms-data-block-trigger : BANNER7_FORMS.GOASEVS.GORSEVD.QUERY_IDEN_PERS forms-module-procedure : BANNER7_FORMS.GOAADDR.SELECT_SPRIDEN_2 forms-data-block-trigger : BANNER7_FORMS.PCABENE.PCRBENE.RETRIEVE_SEX_AND_BIRTH_DATE forms-data-block-item-trigger : BANNER7_FORMS.PDAASGN.PERNASG.ID."POST-CHANGE" forms-data-block-trigger : BANNER7_FORMS.PDABENE.PDRBENE.RETRIEVE_SEX_AND_BIRTH_DATE forms-data-block-item-trigger : BANNER7_FORMS.PDAMR87.PDRMR87.ID."POST-CHANGE" forms-module-procedure : BANNER7_FORMS.NOAEPAF.EDIT_ID forms-data-block-item-trigger : BANNER7_FORMS.PDAPERS.PDRPERS.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.PDICLST.KEY_BLOCK.BENE_ID."POST-CHANGE" schema-view : S4B70.BANINST1.GOVSRVR forms-module-trigger : BANNER7_FORMS.PEAFMLA.EDIT_ID forms-data-block-trigger : BANNER7_FORMS.PEAFMLA.KEY_BLOCK.CHECK_KEYS forms-data-block-item-trigger : BANNER7_FORMS.GUAMESG.GURTKLR.GURTKLR_PIDM."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.GUAMESG.GURTKLR.IDNO."POST-CHANGE" schema-view : S4B70.BANINST1.GUVALTI forms-data-block-item-trigger : BANNER7_FORMS.NHIEDST.KEY_BLOCK.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.PDADEMO.PERDEMO.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.PDAF496.PDRF496.ID."POST-CHANGE" schema-view : S4B70.BANINST1.SPVPERS forms-data-block-trigger : BANNER7_FORMS.RJASEME.RJRSEAR."POST-QUERY" forms-data-block-item-trigger : BANNER7_FORMS.SLARMAT.SLRRMAT.SLRRMAT_PIDM."POST-CHANGE" forms-module-procedure : BANNER7_FORMS.SHICMID.G$_VALID_ID forms-module-trigger : BANNER7_FORMS.TSATAXI.GET_SSN forms-pl/sql-library-procedure : BANNER7_FORMS_10G.GOQRPLS.G$_SEL_SPRIDEN_ID_NAME forms-pl/sql-library-procedure : BANNER7_FORMS_10G.GOQRPLS.G$_VALID_ALL_ID forms-pl/sql-library-procedure : BANNER7_FORMS_10G.AOQRPLS.A$_SEL_ID_INFO forms-pl/sql-library-procedure : BANNER7_FORMS_10G.AOQRPLS.A$_SEL_ID_PERS_INFO forms-module-record-group : BANNER7_FORMS_10G.AGAPMEM.THIRDPP_IDS_RG forms-module-procedure : BANNER7_FORMS_10G.AOQOLIB.A$_SEL_ID_INFO forms-module-procedure : BANNER7_FORMS_10G.AOQOLIB.A$_SEL_ID_PERS_INFO forms-module-record-group : BANNER7_FORMS_10G.AGAGMEM.THIRDPP_IDS_RG forms-module-record-group : BANNER7_FORMS_10G.AGATPAY.THIRDPP_MEM_RG forms-data-block-item-trigger : BANNER7_FORMS_10G.APACHLD.APRCHLD.APRCHLD_OTHR_PIDM."POST-CHANGE" forms-module-record-group : BANNER7_FORMS_10G.APACOMB.APRXREF_RG forms-module-record-group : BANNER7_FORMS_10G.APACOMB.XREF_ID_RG forms-module-record-group : BANNER7_FORMS_10G.AGAPIDS.THIRDPP_MEM_RG forms-module-procedure : BANNER7_FORMS_10G.APAIDEN.SEL_ID_INFO_CUSTOM forms-module-record-group : BANNER7_FORMS_10G.AGAGIDS.THIRDPP_MEM_RG forms-data-block-item-trigger : BANNER7_FORMS_10G.APACONS.APRCSPS.SPS_ID."POST-CHANGE" forms-data-block-trigger : BANNER7_FORMS_10G.GOASEVS.GORSEVD.QUERY_IDEN_PERS forms-module-procedure : BANNER7_FORMS_10G.GOAADDR.SELECT_SPRIDEN_2 forms-data-block-trigger : BANNER7_FORMS_10G.PCABENE.PCRBENE.RETRIEVE_SEX_AND_BIRTH_DATE forms-data-block-item-trigger : BANNER7_FORMS_10G.PDAASGN.PERNASG.ID."POST-CHANGE" forms-data-block-trigger : BANNER7_FORMS_10G.PDABENE.PDRBENE.RETRIEVE_SEX_AND_BIRTH_DATE forms-data-block-item-trigger : BANNER7_FORMS_10G.PDAMR87.PDRMR87.ID."POST-CHANGE" forms-module-procedure : BANNER7_FORMS_10G.NOAEPAF.EDIT_ID forms-data-block-item-trigger : BANNER7_FORMS_10G.PDAPERS.PDRPERS.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS_10G.PDICLST.KEY_BLOCK.BENE_ID."POST-CHANGE" forms-module-trigger : BANNER7_FORMS_10G.PEAFMLA.EDIT_ID forms-data-block-trigger : BANNER7_FORMS_10G.PEAFMLA.KEY_BLOCK.CHECK_KEYS forms-data-block-item-trigger : BANNER7_FORMS_10G.NHIEDST.KEY_BLOCK.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS_10G.PDADEMO.PERDEMO.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS_10G.PDAF496.PDRF496.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS_10G.SLARMAT.SLRRMAT.SLRRMAT_PIDM."POST-CHANGE" |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and SPBPERS | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | SPBPERS |
Link between SGRADVR and SPRIDEN| Objects list |
|---|
| forms-pl/sql-library-procedure : BANNER7_FORMS.SOQRPLS.S$_GET_ADVR
forms-module-procedure : BANNER7_FORMS.SFARQST.A_GET_ADVR forms-module-procedure : BANNER7_FORMS.SFAREGS.A_GET_ADVR forms-pl/sql-library-procedure : BANNER7_FORMS_10G.SOQRPLS.S$_GET_ADVR forms-module-procedure : BANNER7_FORMS_10G.SFARQST.A_GET_ADVR forms-module-procedure : BANNER7_FORMS_10G.SFAREGS.A_GET_ADVR |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SGRADVR and SPRIDEN | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SGRADVR | SPRIDEN |
Link between SGRCMNT and STVACTC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCMNT and STVACTC (FK1_SGRCMNT_INV_STVACTC_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCMNT | SGRCMNT_ACTC_CODE | STVACTC_CODE | STVACTC | (1,1)-(0,n) |
Link between SGRDSER and STVDISA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDSER and STVDISA (FK1_SGRDSER_INV_STVDISA_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDSER | SGRDSER_DISA_CODE | STVDISA_CODE | STVDISA | (1,1)-(0,n) |
Link between SGRDSER and STVSSEP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDSER and STVSSEP (FK1_SGRDSER_INV_STVSSEP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDSER | SGRDSER_SSEP_CODE | STVSSEP_CODE | STVSSEP | (0,1)-(0,n) |
Link between SGRDSER and STVSSER| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDSER and STVSSER (FK1_SGRDSER_INV_STVSSER_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDSER | SGRDSER_SSER_CODE | STVSSER_CODE | STVSSER | (1,1)-(0,n) |
Link between SGRASST and STVTASK| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRASST and STVTASK (FK1_SGRASST_INV_STVTASK_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRASST | SGRASST_TASK_CODE | STVTASK_CODE | STVTASK | (0,1)-(0,n) |
Link between SGRDSER and STVSSRS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDSER and STVSSRS (FK1_SGRDSER_INV_STVSSRS_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDSER | SGRDSER_SSRS_CODE | STVSSRS_CODE | STVSSRS | (0,1)-(0,n) |
Link between SGRDSER and STVSSST| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDSER and STVSSST (FK1_SGRDSER_INV_STVSSST_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDSER | SGRDSER_SSST_CODE | STVSSST_CODE | STVSSST | (0,1)-(0,n) |
Link between SGRCOLR and STVACTC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCOLR and STVACTC (FK1_SGRCOLR_INV_STVACTC_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCOLR | SGRCOLR_ACTC_CODE | STVACTC_CODE | STVACTC | (0,1)-(0,n) |
Link between SGRCOOP and STVEMPL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCOOP and STVEMPL (FK1_SGRCOOP_INV_STVEMPL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCOOP | SGRCOOP_EMPL_CODE | STVEMPL_CODE | STVEMPL | (0,1)-(0,n) |
Link between SGBOEDU and STVEOPS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBOEDU and STVEOPS (FK1_SGBOEDU_INV_STVEOPS_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBOEDU | SGBOEDU_EOPS_CODE | STVEOPS_CODE | STVEOPS | (0,1)-(0,n) |
Link between SGRADVR and STVADVR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRADVR and STVADVR (FK1_SGRADVR_INV_STVADVR_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRADVR | SGRADVR_ADVR_CODE | STVADVR_CODE | STVADVR | (0,1)-(0,n) |
Link between SGRDSER and STVSEPR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDSER and STVSEPR (FK1_SGRDSER_INV_STVSEPR_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDSER | SGRDSER_SEPR_CODE | STVSEPR_CODE | STVSEPR | (0,1)-(0,n) |
Link between SHRTTRM and STVASTD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SHRTTRM and STVASTD (FK1_SHRTTRM_INV_STVASTD_CODE) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SHRTTRM and STVASTD (FK2_SHRTTRM_INV_STVASTD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SHRTTRM | SHRTTRM_ASTD_CODE_END_OF_TERM | STVASTD_CODE | STVASTD | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SHRTTRM | SHRTTRM_ASTD_CODE_DL | STVASTD_CODE | STVASTD | (0,1)-(0,n) |
Link between SGRCATT and STVATTS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCATT and STVATTS (FK1_SGRCATT_INV_STVATTS_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCATT | SGRCATT_ATTS_CODE | STVATTS_CODE | STVATTS | (1,1)-(0,n) |
Link between SGBOEDU and STVSFAE| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBOEDU and STVSFAE (FK1_SGBOEDU_INV_STVSFAE_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBOEDU | SGBOEDU_SFAE_CODE | STVSFAE_CODE | STVSFAE | (0,1)-(0,n) |
Link between SGRCOLR and STVDLEV| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCOLR and STVDLEV (FK1_SGRCOLR_INV_STVDLEV_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCOLR | SGRCOLR_DLEV_CODE | STVDLEV_CODE | STVDLEV | (0,1)-(0,n) |
Link between SGBUSER and STVSUDA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBUSER and STVSUDA (FK1_SGBUSER_INV_STVSUDA_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBUSER | SGBUSER_SUDA_CODE | STVSUDA_CODE | STVSUDA | (0,1)-(0,n) |
Link between SGBUSER and STVSUDB| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBUSER and STVSUDB (FK1_SGBUSER_INV_STVSUDB_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBUSER | SGBUSER_SUDB_CODE | STVSUDB_CODE | STVSUDB | (0,1)-(0,n) |
Link between SGBUSER and STVSUDC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBUSER and STVSUDC (FK1_SGBUSER_INV_STVSUDC_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBUSER | SGBUSER_SUDC_CODE | STVSUDC_CODE | STVSUDC | (0,1)-(0,n) |
Link between SGBUSER and STVSUDD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBUSER and STVSUDD (FK1_SGBUSER_INV_STVSUDD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBUSER | SGBUSER_SUDD_CODE | STVSUDD_CODE | STVSUDD | (0,1)-(0,n) |
Link between SGBUSER and STVSUDE| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBUSER and STVSUDE (FK1_SGBUSER_INV_STVSUDE_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBUSER | SGBUSER_SUDE_CODE | STVSUDE_CODE | STVSUDE | (0,1)-(0,n) |
Link between SGBUSER and STVSUDF| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBUSER and STVSUDF (FK1_SGBUSER_INV_STVSUDF_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBUSER | SGBUSER_SUDF_CODE | STVSUDF_CODE | STVSUDF | (0,1)-(0,n) |
Link between SGBUSER and STVSUDG| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBUSER and STVSUDG (FK1_SGBUSER_INV_STVSUDG_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBUSER | SGBUSER_SUDG_CODE | STVSUDG_CODE | STVSUDG | (0,1)-(0,n) |
Link between SGBUSER and STVSUDH| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBUSER and STVSUDH (FK1_SGBUSER_INV_STVSUDH_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBUSER | SGBUSER_SUDH_CODE | STVSUDH_CODE | STVSUDH | (0,1)-(0,n) |
Link between SGBUSER and STVSUDI| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBUSER and STVSUDI (FK1_SGBUSER_INV_STVSUDI_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBUSER | SGBUSER_SUDI_CODE | STVSUDI_CODE | STVSUDI | (0,1)-(0,n) |
Link between SGBUSER and STVSUDJ| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBUSER and STVSUDJ (FK1_SGBUSER_INV_STVSUDJ_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBUSER | SGBUSER_SUDJ_CODE | STVSUDJ_CODE | STVSUDJ | (0,1)-(0,n) |
Link between SGBOEDU and STVAFDC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBOEDU and STVAFDC (FK1_SGBOEDU_INV_STVAFDC_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBOEDU | SGBOEDU_AFDC_CODE | STVAFDC_CODE | STVAFDC | (0,1)-(0,n) |
Link between SGRDUTY and SGRCOOP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDUTY and SGRCOOP (FK1_SGRDUTY_INV_SGRCOOP_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDUTY | SGRDUTY_PIDM | SGRCOOP_PIDM | SGRCOOP | (1,1)-(0,n) |
| SGRDUTY | SGRDUTY_LEVL_CODE | SGRCOOP_LEVL_CODE | SGRCOOP | (1,1)-(0,n) |
| SGRDUTY | SGRDUTY_TERM_CODE | SGRCOOP_TERM_CODE | SGRCOOP | (1,1)-(0,n) |
| SGRDUTY | SGRDUTY_COOP_SEQ_NO | SGRCOOP_SEQ_NO | SGRCOOP | (1,1)-(0,n) |
Link between SGRDUTY and STVEMPL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDUTY and STVEMPL (FK1_SGRDUTY_INV_STVEMPL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDUTY | SGRDUTY_EMPL_CODE | STVEMPL_CODE | STVEMPL | (1,1)-(0,n) |
Link between SGRASSI and STVCOLL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRASSI and STVCOLL (FK1_SGRASSI_INV_STVCOLL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRASSI | SGRASSI_COLL_CODE | STVCOLL_CODE | STVCOLL | (0,1)-(0,n) |
Link between SOBCURR and STVCOLL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SOBCURR and STVCOLL (FK1_SOBCURR_INV_STVCOLL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SOBCURR | SOBCURR_COLL_CODE | STVCOLL_CODE | STVCOLL | (0,1)-(0,n) |
Link between SGRCOOP and STVCOPC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCOOP and STVCOPC (FK1_SGRCOOP_INV_STVCOPC_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCOOP | SGRCOOP_COPC_CODE | STVCOPC_CODE | STVCOPC | (0,1)-(0,n) |
Link between SORCCON and SOBCURR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SORCCON and SOBCURR (FK1_SORCCON_INV_SOBCURR_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SORCCON | SORCCON_CURR_RULE | SOBCURR_CURR_RULE | SOBCURR | (1,1)-(0,n) |
Link between SGRDSER and STVORIG| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDSER and STVORIG (FK1_SGRDSER_INV_STVORIG_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDSER | SGRDSER_ORIG_CODE | STVORIG_CODE | STVORIG | (0,1)-(0,n) |
Link between SGBEOPS and STVEOPS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBEOPS and STVEOPS (FK1_SGBEOPS_INV_STVEOPS_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBEOPS | SGBEOPS_EOPS_CODE | STVEOPS_CODE | STVEOPS | (0,1)-(0,n) |
Link between SGBEOPS and STVSFAE| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBEOPS and STVSFAE (FK1_SGBEOPS_INV_STVSFAE_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBEOPS | SGBEOPS_SFAE_CODE | STVSFAE_CODE | STVSFAE | (0,1)-(0,n) |
Link between SGBOEDU and STVMARS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBOEDU and STVMARS (FK1_SGBOEDU_INV_STVMARS_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBOEDU | SGBOEDU_MARS_CODE | STVMARS_CODE | STVMARS | (0,1)-(0,n) |
Link between SGRVETN and STVVETC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRVETN and STVVETC (FK1_SGRVETN_INV_STVVETC_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRVETN | SGRVETN_VETC_CODE | STVVETC_CODE | STVVETC | (1,1)-(0,n) |
Link between SGBOEDU and STVDEPS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBOEDU and STVDEPS (FK1_SGBOEDU_INV_STVDEPS_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBOEDU | SGBOEDU_DEPS_CODE | STVDEPS_CODE | STVDEPS | (0,1)-(0,n) |
Link between SGBSTDN and SORCCON| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CCON_RULE_22_1 | SORCCON_CCON_RULE | SORCCON | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CCON_RULE_22_2 | SORCCON_CCON_RULE | SORCCON | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CCON_RULE_22_3 | SORCCON_CCON_RULE | SORCCON | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CCON_RULE_11_1 | SORCCON_CCON_RULE | SORCCON | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CCON_RULE_11_2 | SORCCON_CCON_RULE | SORCCON | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CCON_RULE_11_3 | SORCCON_CCON_RULE | SORCCON | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CCON_RULE_12_1 | SORCCON_CCON_RULE | SORCCON | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CCON_RULE_12_2 | SORCCON_CCON_RULE | SORCCON | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CCON_RULE_12_3 | SORCCON_CCON_RULE | SORCCON | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CCON_RULE_21_1 | SORCCON_CCON_RULE | SORCCON | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CCON_RULE_21_2 | SORCCON_CCON_RULE | SORCCON | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CCON_RULE_21_3 | SORCCON_CCON_RULE | SORCCON | (0,1)-(0,n) |
Link between SGBSTDN and SOBCURR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and SOBCURR (FK1_SGBSTDN_INV_SOBCURR_KEY) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and SOBCURR (FK2_SGBSTDN_INV_SOBCURR_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CURR_RULE_1 | SOBCURR_CURR_RULE | SOBCURR | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CURR_RULE_2 | SOBCURR_CURR_RULE | SOBCURR | (0,1)-(0,n) |
Link between SGBSTDN and STVACYR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVACYR (FK1_SGBSTDN_INV_STVACYR_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_ACYR_CODE | STVACYR_CODE | STVACYR | (0,1)-(0,n) |
Link between SGBSTDN and STVADMT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVADMT (FK1_SGBSTDN_INV_STVADMT_CODE) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVADMT (FK2_SGBSTDN_INV_STVADMT_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_ADMT_CODE | STVADMT_CODE | STVADMT | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_ADMT_CODE_2 | STVADMT_CODE | STVADMT | (0,1)-(0,n) |
Link between SGBSTDN and STVASTD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVASTD (FK1_SGBSTDN_INV_STVASTD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_ASTD_CODE | STVASTD_CODE | STVASTD | (0,1)-(0,n) |
Link between SGBSTDN and STVCOLL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVCOLL (FK1_SGBSTDN_INV_STVCOLL_CODE) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVCOLL (FK2_SGBSTDN_INV_STVCOLL_CODE) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVCOLL (FK3_SGBSTDN_INV_STVCOLL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_COLL_CODE_1 | STVCOLL_CODE | STVCOLL | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_COLL_CODE_2 | STVCOLL_CODE | STVCOLL | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_COLL_CODE_DUAL | STVCOLL_CODE | STVCOLL | (0,1)-(0,n) |
Link between SGBSTDN and STVEGOL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVEGOL (FK1_SGBSTDN_INV_STVEGOL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_EGOL_CODE | STVEGOL_CODE | STVEGOL | (0,1)-(0,n) |
Link between SGBSTDN and STVEMEX| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVEMEX (FK1_SGBSTDN_INV_STVEMEX_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_EMEX_CODE | STVEMEX_CODE | STVEMEX | (0,1)-(0,n) |
Link between SGBSTDN and STVGAIN| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVGAIN (FK1_SGBSTDN_INV_STVGAIN_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_GAIN_CODE | STVGAIN_CODE | STVGAIN | (0,1)-(0,n) |
Link between SGBSTDN and STVRATE| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVRATE (FK1_SGBSTDN_INV_STVRATE_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_RATE_CODE | STVRATE_CODE | STVRATE | (0,1)-(0,n) |
Link between SGBSTDN and STVRESD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVRESD (FK1_SGBSTDN_INV_STVRESD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_RESD_CODE | STVRESD_CODE | STVRESD | (0,1)-(0,n) |
Link between SGBSTDN and STVSESS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVSESS (FK1_SGBSTDN_INV_STVSESS_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_SESS_CODE | STVSESS_CODE | STVSESS | (0,1)-(0,n) |
Link between SGBSTDN and STVSTST| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVSTST (FK1_SGBSTDN_INV_STVSTST_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_STST_CODE | STVSTST_CODE | STVSTST | (1,1)-(0,n) |
Link between SGBSTDN and STVSTYP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVSTYP (FK1_SGBSTDN_INV_STVSTYP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_STYP_CODE | STVSTYP_CODE | STVSTYP | (1,1)-(0,n) |
Link between SGBSTDN and STVTRCN| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVTRCN (FK1_SGBSTDN_INV_STVTRCN_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_TRCN_CODE | STVTRCN_CODE | STVTRCN | (0,1)-(0,n) |
Link between SGBSTDN and STVORSN| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVORSN (FK1_SGBSTDN_INV_STVORSN_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_ORSN_CODE | STVORSN_CODE | STVORSN | (0,1)-(0,n) |
Link between SGRSACT and STVACTC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRSACT and STVACTC (FK1_SGRSACT_INV_STVACTC_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRSACT | SGRSACT_ACTC_CODE | STVACTC_CODE | STVACTC | (1,1)-(0,n) |
Link between SGRCHRT and STVCHRT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCHRT and STVCHRT (FK1_SGRCHRT_INV_STVCHRT_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCHRT | SGRCHRT_CHRT_CODE | STVCHRT_CODE | STVCHRT | (0,1)-(0,n) |
Link between SGRCOLR and STVCHRT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCOLR and STVCHRT (FK1_SGRCOLR_INV_STVCHRT_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCOLR | SGRCOLR_CHRT_CODE | STVCHRT_CODE | STVCHRT | (1,1)-(0,n) |
Link between STVCHRT and STVDLEV| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between STVCHRT and STVDLEV (FK1_STVCHRT_INV_STVDLEV_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| STVCHRT | STVCHRT_DLEV_CODE | STVDLEV_CODE | STVDLEV | (0,1)-(0,n) |
Link between SGRASSI and STVGSTA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRASSI and STVGSTA (FK1_SGRASSI_INV_STVGSTA_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRASSI | SGRASSI_GSTA_CODE | STVGSTA_CODE | STVGSTA | (0,1)-(0,n) |
Link between SGBSTDN and STVLEAV| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVLEAV (FK1_SGBSTDN_INV_STVLEAV_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_LEAV_CODE | STVLEAV_CODE | STVLEAV | (0,1)-(0,n) |
Link between SGRSPRT and STVACTC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRSPRT and STVACTC (FK1_SGRSPRT_INV_STVACTC_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRSPRT | SGRSPRT_ACTC_CODE | STVACTC_CODE | STVACTC | (1,1)-(0,n) |
Link between SGBSTDN and STVBSKL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVBSKL (FK1_SGBSTDN_INV_STVBSKL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_BSKL_CODE | STVBSKL_CODE | STVBSKL | (0,1)-(0,n) |
Link between SGBSTDN and STVCAMP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVCAMP (FK1_SGBSTDN_INV_STVCAMP_CODE) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVCAMP (FK2_SGBSTDN_INV_STVCAMP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CAMP_CODE_2 | STVCAMP_CODE | STVCAMP | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CAMP_CODE | STVCAMP_CODE | STVCAMP | (0,1)-(0,n) |
Link between SGRDSER and STVCAMP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDSER and STVCAMP (FK1_SGRDSER_INV_STVCAMP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDSER | SGRDSER_CAMP_CODE | STVCAMP_CODE | STVCAMP | (0,1)-(0,n) |
Link between SOBCURR and STVCAMP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SOBCURR and STVCAMP (FK1_SOBCURR_INV_STVCAMP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SOBCURR | SOBCURR_CAMP_CODE | STVCAMP_CODE | STVCAMP | (0,1)-(0,n) |
Link between SGRSATT and STVATTS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRSATT and STVATTS (FK1_SGRSATT_INV_STVATTS_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRSATT | SGRSATT_ATTS_CODE | STVATTS_CODE | STVATTS | (0,1)-(0,n) |
Link between SGBSTDN and STVCAPL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVCAPL (FK1_SGBSTDN_INV_STVCAPL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CAPL_CODE | STVCAPL_CODE | STVCAPL | (0,1)-(0,n) |
Link between SGBSTDN and STVINCM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVINCM (FK1_SGBSTDN_INV_STVINCM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_INCM_CODE | STVINCM_CODE | STVINCM | (0,1)-(0,n) |
Link between SGBSTDN and STVCAST| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVCAST (FK1_SGBSTDN_INV_STVCAST_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CAST_CODE | STVCAST_CODE | STVCAST | (0,1)-(0,n) |
Link between SHRTTRM and STVCAST| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SHRTTRM and STVCAST (FK1_SHRTTRM_INV_STVCAST_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SHRTTRM | SHRTTRM_CAST_CODE | STVCAST_CODE | STVCAST | (0,1)-(0,n) |
Link between SGRASSI and STVSOFF| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRASSI and STVSOFF (FK1_SGRASSI_INV_STVSOFF_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRASSI | SGRASSI_SOFF_CODE | STVSOFF_CODE | STVSOFF | (0,1)-(0,n) |
Link between SGBSTDN and STVBLCK| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVBLCK (FK1_SGBSTDN_INV_STVBLCK_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_BLCK_CODE | STVBLCK_CODE | STVBLCK | (0,1)-(0,n) |
Link between SFRMHRS and STVLEVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SFRMHRS and STVLEVL (FK1_SFRMHRS_INV_STVLEVL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SFRMHRS | SFRMHRS_LEVL_CODE | STVLEVL_CODE | STVLEVL | (1,1)-(0,n) |
Link between SGBSTDN and STVLEVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVLEVL (FK1_SGBSTDN_INV_STVLEVL_CODE) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVLEVL (FK2_SGBSTDN_INV_STVLEVL_CODE) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVLEVL (FK3_SGBSTDN_INV_STVLEVL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_LEVL_CODE_2 | STVLEVL_CODE | STVLEVL | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_LEVL_CODE_DUAL | STVLEVL_CODE | STVLEVL | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_LEVL_CODE | STVLEVL_CODE | STVLEVL | (0,1)-(0,n) |
Link between SGRASSI and STVLEVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRASSI and STVLEVL (FK1_SGRASSI_INV_STVLEVL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRASSI | SGRASSI_LEVL_CODE | STVLEVL_CODE | STVLEVL | (0,1)-(0,n) |
Link between SGRCOOP and STVLEVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCOOP and STVLEVL (FK1_SGRCOOP_INV_STVLEVL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCOOP | SGRCOOP_LEVL_CODE | STVLEVL_CODE | STVLEVL | (1,1)-(0,n) |
Link between SGRDUTY and STVLEVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDUTY and STVLEVL (FK1_SGRDUTY_INV_STVLEVL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDUTY | SGRDUTY_LEVL_CODE | STVLEVL_CODE | STVLEVL | (1,1)-(0,n) |
Link between SHRLGPA and STVLEVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SHRLGPA and STVLEVL (FK1_SHRLGPA_INV_STVLEVL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SHRLGPA | SHRLGPA_LEVL_CODE | STVLEVL_CODE | STVLEVL | (1,1)-(0,n) |
Link between SOBCURR and STVLEVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SOBCURR and STVLEVL (FK1_SOBCURR_INV_STVLEVL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SOBCURR | SOBCURR_LEVL_CODE | STVLEVL_CODE | STVLEVL | (1,1)-(0,n) |
Link between SGRASSI and STVGTYP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRASSI and STVGTYP (FK1_SGRASSI_INV_STVGTYP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRASSI | SGRASSI_GTYP_CODE | STVGTYP_CODE | STVGTYP | (1,1)-(0,n) |
Link between SGRASST and STVGTYP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRASST and STVGTYP (FK1_SGRASST_INV_STVGTYP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRASST | SGRASST_GTYP_CODE | STVGTYP_CODE | STVGTYP | (1,1)-(0,n) |
Link between SGRESEL and STVESEL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRESEL and STVESEL (FK1_SGRESEL_INV_STVESEL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRESEL | SGRESEL_ESEL_CODE | STVESEL_CODE | STVESEL | (0,1)-(0,n) |
Link between SGBSTDN and STVEDLV| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVEDLV (FK1_SGBSTDN_INV_STVEDLV_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_EDLV_CODE | STVEDLV_CODE | STVEDLV | (0,1)-(0,n) |
Link between SGBSTDN and SORCMJR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and SORCMJR (FK1_SGBSTDN_INV_SORCMJR_KEY) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and SORCMJR (FK2_SGBSTDN_INV_SORCMJR_KEY) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and SORCMJR (FK3_SGBSTDN_INV_SORCMJR_KEY) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and SORCMJR (FK4_SGBSTDN_INV_SORCMJR_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CMJR_RULE_1_2 | SORCMJR_CMJR_RULE | SORCMJR | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CMJR_RULE_2_2 | SORCMJR_CMJR_RULE | SORCMJR | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CMJR_RULE_2_1 | SORCMJR_CMJR_RULE | SORCMJR | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CMJR_RULE_1_1 | SORCMJR_CMJR_RULE | SORCMJR | (0,1)-(0,n) |
Link between SORCCON and SORCMJR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SORCCON and SORCMJR (FK1_SORCCON_INV_SORCMJR_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SORCCON | SORCCON_CMJR_RULE | SORCMJR_CMJR_RULE | SORCMJR | (0,1)-(0,n) |
Link between SORCMJR and SOBCURR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SORCMJR and SOBCURR (FK1_SORCMJR_INV_SOBCURR_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SORCMJR | SORCMJR_CURR_RULE | SOBCURR_CURR_RULE | SOBCURR | (1,1)-(0,n) |
Link between SGBSTDN and SMRPRLE| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and SMRPRLE (FK1_SGBSTDN_INV_SMRPRLE_KEY) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and SMRPRLE (FK2_SGBSTDN_INV_SMRPRLE_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_PROGRAM_2 | SMRPRLE_PROGRAM | SMRPRLE | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_PROGRAM_1 | SMRPRLE_PROGRAM | SMRPRLE | (0,1)-(0,n) |
Link between SOBCURR and SMRPRLE| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SOBCURR and SMRPRLE (FK1_SOBCURR_INV_SMRPRLE_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SOBCURR | SOBCURR_PROGRAM | SMRPRLE_PROGRAM | SMRPRLE | (0,1)-(0,n) |
Link between SMRPRLE and STVCAMP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SMRPRLE and STVCAMP (FK1_SMRPRLE_INV_STVCAMP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRPRLE | SMRPRLE_CAMP_CODE | STVCAMP_CODE | STVCAMP | (0,1)-(0,n) |
Link between SMRPRLE and STVCOLL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SMRPRLE and STVCOLL (FK1_SMRPRLE_INV_STVCOLL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRPRLE | SMRPRLE_COLL_CODE | STVCOLL_CODE | STVCOLL | (0,1)-(0,n) |
Link between SMRPRLE and STVLEVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SMRPRLE and STVLEVL (FK1_SMRPRLE_INV_STVLEVL_CODE) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SMRPRLE and STVLEVL (FK2_SMRPRLE_INV_STVLEVL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRPRLE | SMRPRLE_LEVL_CODE | STVLEVL_CODE | STVLEVL | (1,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRPRLE | SMRPRLE_LEVL_CODE_STU | STVLEVL_CODE | STVLEVL | (1,1)-(0,n) |
Link between SGBSTDN and STVVOED| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVVOED (FK1_SGBSTDN_INV_STVVOED_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_VOED_CODE | STVVOED_CODE | STVVOED | (0,1)-(0,n) |
Link between SGBSTDN and SORCMNR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and SORCMNR (FK1_SGBSTDN_INV_SORCMNR_KEY) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and SORCMNR (FK2_SGBSTDN_INV_SORCMNR_KEY) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and SORCMNR (FK3_SGBSTDN_INV_SORCMNR_KEY) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and SORCMNR (FK4_SGBSTDN_INV_SORCMNR_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CMNR_RULE_1_1 | SORCMNR_CMNR_RULE | SORCMNR | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CMNR_RULE_2_2 | SORCMNR_CMNR_RULE | SORCMNR | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CMNR_RULE_2_1 | SORCMNR_CMNR_RULE | SORCMNR | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_CMNR_RULE_1_2 | SORCMNR_CMNR_RULE | SORCMNR | (0,1)-(0,n) |
Link between SORCMNR and SOBCURR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SORCMNR and SOBCURR (FK1_SORCMNR_INV_SOBCURR_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SORCMNR | SORCMNR_CURR_RULE | SOBCURR_CURR_RULE | SOBCURR | (1,1)-(0,n) |
Link between SGRDSER and STVSPRV| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDSER and STVSPRV (FK1_SGRDSER_INV_STVSPRV_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDSER | SGRDSER_SPRV_CODE | STVSPRV_CODE | STVSPRV | (0,1)-(0,n) |
Link between SGRSPRT and STVSPST| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRSPRT and STVSPST (FK1_SGRSPRT_INV_STVSPST_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRSPRT | SGRSPRT_SPST_CODE | STVSPST_CODE | STVSPST | (0,1)-(0,n) |
Link between SGRSPRT and STVELIG| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRSPRT and STVELIG (FK1_SGRSPRT_INV_STVELIG_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRSPRT | SGRSPRT_ELIG_CODE | STVELIG_CODE | STVELIG | (0,1)-(0,n) |
Link between SGRCHRT and STVCREA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCHRT and STVCREA (FK1_SGRCHRT_INV_STVCREA_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCHRT | SGRCHRT_CREA_CODE | STVCREA_CODE | STVCREA | (0,1)-(0,n) |
Link between SGRCOLR and STVCREA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCOLR and STVCREA (FK1_SGRCOLR_INV_STVCREA_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCOLR | SGRCOLR_CREA_CODE | STVCREA_CODE | STVCREA | (0,1)-(0,n) |
Link between SGBSTDN and STVAPRN| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVAPRN (FK1_SGBSTDN_INV_STVAPRN_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_APRN_CODE | STVAPRN_CODE | STVAPRN | (0,1)-(0,n) |
Link between SGBSTDN and STVPRAC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVPRAC (FK1_SGBSTDN_INV_STVPRAC_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_PRAC_CODE | STVPRAC_CODE | STVPRAC | (0,1)-(0,n) |
Link between SGBEOPS and STVWTHD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBEOPS and STVWTHD (FK1_SGBEOPS_INV_STVWTHD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBEOPS | SGBEOPS_WTHD_CODE | STVWTHD_CODE | STVWTHD | (0,1)-(0,n) |
Link between SGBOEDU and STVWTHD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBOEDU and STVWTHD (FK1_SGBOEDU_INV_STVWTHD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBOEDU | SGBOEDU_WTHD_CODE | STVWTHD_CODE | STVWTHD | (0,1)-(0,n) |
Link between SGRDSER and SGRDISA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDSER and SGRDISA (FK1_SGRDSER_INV_SGRDISA_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDSER | SGRDSER_PIDM | SGRDISA_PIDM | SGRDISA | (1,1)-(0,n) |
| SGRDSER | SGRDSER_TERM_CODE | SGRDISA_TERM_CODE | SGRDISA | (1,1)-(0,n) |
| SGRDSER | SGRDSER_DISA_CODE | SGRDISA_DISA_CODE | SGRDISA | (1,1)-(0,n) |
Link between SGRDISA and STVDISA| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDISA and STVDISA (FK1_SGRDISA_INV_STVDISA_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDISA | SGRDISA_DISA_CODE | STVDISA_CODE | STVDISA | (1,1)-(0,n) |
Link between SGRDISA and STVMEDI| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDISA and STVMEDI (FK1_SGRDISA_INV_STVMEDI_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDISA | SGRDISA_MEDI_CODE | STVMEDI_CODE | STVMEDI | (0,1)-(0,n) |
Link between SGRDISA and STVSPSR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRDISA and STVSPSR (FK1_SGRDISA_INV_STVSPSR_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRDISA | SGRDISA_SPSR_CODE | STVSPSR_CODE | STVSPSR | (0,1)-(0,n) |
Link between SHRTTRM and STVPREV| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SHRTTRM and STVPREV (FK1_SHRTTRM_INV_STVPREV_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SHRTTRM | SHRTTRM_PREV_CODE | STVPREV_CODE | STVPREV | (0,1)-(0,n) |
Link between SGBSTDN and STVPREV| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVPREV (FK1_SGBSTDN_INV_STVPREV_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_PREV_CODE | STVPREV_CODE | STVPREV | (0,1)-(0,n) |
Link between SGRCLSR and STVCLAS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCLSR and STVCLAS (FK1_SGRCLSR_INV_STVCLAS_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCLSR | SGRCLSR_CLAS_CODE | STVCLAS_CODE | STVCLAS | (1,1)-(0,n) |
Link between SGRCLSR and STVLEVL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRCLSR and STVLEVL (FK1_SGRCLSR_INV_STVLEVL_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRCLSR | SGRCLSR_LEVL_CODE | STVLEVL_CODE | STVLEVL | (1,1)-(0,n) |
Link between SGRACMT and STVGTYP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRACMT and STVGTYP (FK1_SGRACMT_INV_STVGTYP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRACMT | SGRACMT_GTYP_CODE | STVGTYP_CODE | STVGTYP | (1,1)-(0,n) |
Link between SGRACMT and STVORIG| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGRACMT and STVORIG (FK1_SGRACMT_INV_STVORIG_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGRACMT | SGRACMT_ORIG_CODE | STVORIG_CODE | STVORIG | (0,1)-(0,n) |
Link between SGBSTDN and STVSITE| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SGBSTDN and STVSITE (FK1_SGBSTDN_INV_STVSITE_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SGBSTDN | SGBSTDN_SITE_CODE | STVSITE_CODE | STVSITE | (0,1)-(0,n) |