Model Location_Management_ERD
| Object Name | Object Type | Layer Name |
|---|---|---|
| GTVDICD | TABLE | ERD |
| GTVPARS | TABLE | ERD |
| GTVSYSI | TABLE | ERD |
| SLBBLDG | TABLE | Tables |
| SLBEVNT | TABLE | Tables |
| SLBRDEF | TABLE | Tables |
| SLBRMAP | TABLE | Tables |
| SLBRMPF | TABLE | Tables |
| SLBTERM | TABLE | Tables |
| SLRASCD | TABLE | Tables |
| SLRBCAT | TABLE | Tables |
| SLRBCMT | TABLE | Tables |
| SLRBDEF | TABLE | Tables |
| SLRCMNT | TABLE | Tables |
| SLRCOLC | TABLE | Tables |
| SLRCOLR | TABLE | Tables |
| SLRDCOL | TABLE | Tables |
| SLRECMT | TABLE | Tables |
| SLRLMFE | TABLE | Tables |
| SLRMASG | TABLE | Tables |
| SLRMFCR | TABLE | Tables |
| SLRMSCD | TABLE | Tables |
| SLRPASG | TABLE | Tables |
| SLRPFCR | TABLE | Tables |
| SLRPREQ | TABLE | Tables |
| SLRPSCD | TABLE | Tables |
| SLRRASG | TABLE | Tables |
| SLRRDEF | TABLE | Tables |
| SLRRFCR | TABLE | Tables |
| SLRRMAT | TABLE | Tables |
| SLRRMDF | TABLE | Tables |
| SLRRUSE | TABLE | Tables |
| SLRTASG | TABLE | Tables |
| SLTFTRN | TABLE | Tables |
| SPBPERS | TABLE | ERD |
| SPRIDEN | TABLE | ERD |
| SSRMEET | TABLE | ERD |
| STVARTP | TABLE | ERD |
| STVASCD | TABLE | ERD |
| STVBLDG | TABLE | ERD |
| STVCAMP | TABLE | ERD |
| STVHAPS | TABLE | ERD |
| STVMRCD | TABLE | ERD |
| STVMSCD | TABLE | ERD |
| STVPRCD | TABLE | ERD |
| STVPSCD | TABLE | ERD |
| STVRDEF | TABLE | ERD |
| STVRMST | TABLE | ERD |
| STVRRCD | TABLE | ERD |
| STVSITE | TABLE | ERD |
| STVTERM | TABLE | ERD |
| TBBDETC | TABLE | ERD |
Table GTVDICD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVDICD_CODE | GTVDICD_CODE | VARCHAR2(3) | No | * | |
| GTVDICD_DESC | GTVDICD_DESC | VARCHAR2(30) | No | ||
| GTVDICD_ACTIVITY_DATE | GTVDICD_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVDICD | Unique | GTVDICD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:30:000 |
Table GTVPARS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVPARS_CODE | GTVPARS_CODE | VARCHAR2(7) | No | * | |
| GTVPARS_DESC | GTVPARS_DESC | VARCHAR2(30) | No | ||
| GTVPARS_SCHEDULER_NUMBER | GTVPARS_SCHEDULER_NUMBER | NUMBER(2,0) | No | ||
| GTVPARS_USER_ID | GTVPARS_USER_ID | VARCHAR2(30) | No | ||
| GTVPARS_ACTIVITY_DATE | GTVPARS_ACTIVITY_DATE | DATE | No | ||
| GTVPARS_CAMP_CODE | GTVPARS_CAMP_CODE | VARCHAR2(3) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GTVPARS_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVPARS | Unique | GTVPARS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:29:000 |
Table GTVSYSI| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSYSI_CODE | GTVSYSI_CODE | VARCHAR2(2) | No | * | * |
| GTVSYSI_DESC | GTVSYSI_DESC | VARCHAR2(30) | No | ||
| GTVSYSI_ACTIVITY_DATE | GTVSYSI_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GTVSYSI_CODE | SLBEVNT_SYSI_CODE | SLBEVNT |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSYSI | Unique | GTVSYSI_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:29:000 |
Table SLBBLDG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLBBLDG_BLDG_CODE | SLBBLDG_BLDG_CODE | VARCHAR2(6) | No | * | * |
| SLBBLDG_CAMP_CODE | SLBBLDG_CAMP_CODE | VARCHAR2(3) | No | ||
| SLBBLDG_CAPACITY | SLBBLDG_CAPACITY | NUMBER(5,0) | No | ||
| SLBBLDG_MAXIMUM_CAPACITY | SLBBLDG_MAXIMUM_CAPACITY | NUMBER(5,0) | Yes | ||
| SLBBLDG_RRCD_CODE | SLBBLDG_RRCD_CODE | VARCHAR2(4) | Yes | ||
| SLBBLDG_PRCD_CODE | SLBBLDG_PRCD_CODE | VARCHAR2(4) | Yes | ||
| SLBBLDG_SITE_CODE | SLBBLDG_SITE_CODE | VARCHAR2(3) | Yes | ||
| SLBBLDG_STREET_LINE1 | SLBBLDG_STREET_LINE1 | VARCHAR2(30) | Yes | ||
| SLBBLDG_STREET_LINE2 | SLBBLDG_STREET_LINE2 | VARCHAR2(30) | Yes | ||
| SLBBLDG_STREET_LINE3 | SLBBLDG_STREET_LINE3 | VARCHAR2(30) | Yes | ||
| SLBBLDG_CITY | SLBBLDG_CITY | VARCHAR2(20) | Yes | ||
| SLBBLDG_STAT_CODE | SLBBLDG_STAT_CODE | VARCHAR2(3) | Yes | ||
| SLBBLDG_ZIP | SLBBLDG_ZIP | VARCHAR2(10) | Yes | ||
| SLBBLDG_CNTY_CODE | SLBBLDG_CNTY_CODE | VARCHAR2(5) | Yes | ||
| SLBBLDG_PHONE_AREA | SLBBLDG_PHONE_AREA | VARCHAR2(3) | Yes | ||
| SLBBLDG_PHONE_NUMBER | SLBBLDG_PHONE_NUMBER | VARCHAR2(7) | Yes | ||
| SLBBLDG_PHONE_EXTENSION | SLBBLDG_PHONE_EXTENSION | VARCHAR2(4) | Yes | ||
| SLBBLDG_ACTIVITY_DATE | SLBBLDG_ACTIVITY_DATE | DATE | No | ||
| SLBBLDG_SEX | SLBBLDG_SEX | VARCHAR2(1) | Yes | ||
| SLBBLDG_COLL_CODE | SLBBLDG_COLL_CODE | VARCHAR2(2) | Yes | ||
| SLBBLDG_DEPT_CODE | SLBBLDG_DEPT_CODE | VARCHAR2(4) | Yes | ||
| SLBBLDG_KEY_NUMBER | SLBBLDG_KEY_NUMBER | VARCHAR2(5) | Yes | ||
| SLBBLDG_PARS_CODE | SLBBLDG_PARS_CODE | VARCHAR2(7) | Yes | * | |
| SLBBLDG_DATA_ORIGIN | SLBBLDG_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SLBBLDG_USER_ID | SLBBLDG_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLBBLDG_BLDG_CODE | STVBLDG_CODE | STVBLDG |
| SLBBLDG_PARS_CODE | GTVPARS_CODE | GTVPARS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLBBLDG | Unique | SLBBLDG_BLDG_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table SLBEVNT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLBEVNT_CRN | SLBEVNT_CRN | VARCHAR2(5) | No | * | |
| SLBEVNT_ETYP_CODE | SLBEVNT_ETYP_CODE | VARCHAR2(4) | No | ||
| SLBEVNT_DESC | SLBEVNT_DESC | VARCHAR2(30) | Yes | ||
| SLBEVNT_AGENCY_PIDM | SLBEVNT_AGENCY_PIDM | NUMBER(8,0) | Yes | ||
| SLBEVNT_CONTACT_NAME | SLBEVNT_CONTACT_NAME | VARCHAR2(35) | Yes | ||
| SLBEVNT_CAMP_CODE | SLBEVNT_CAMP_CODE | VARCHAR2(3) | Yes | ||
| SLBEVNT_SITE_CODE | SLBEVNT_SITE_CODE | VARCHAR2(3) | Yes | * | |
| SLBEVNT_COLL_CODE | SLBEVNT_COLL_CODE | VARCHAR2(2) | Yes | ||
| SLBEVNT_DEPT_CODE | SLBEVNT_DEPT_CODE | VARCHAR2(4) | Yes | ||
| SLBEVNT_ACTIVITY_DATE | SLBEVNT_ACTIVITY_DATE | DATE | Yes | ||
| SLBEVNT_PHONE_AREA | SLBEVNT_PHONE_AREA | VARCHAR2(3) | Yes | ||
| SLBEVNT_PHONE | SLBEVNT_PHONE | VARCHAR2(7) | Yes | ||
| SLBEVNT_PHONE_EXT | SLBEVNT_PHONE_EXT | VARCHAR2(4) | Yes | ||
| SLBEVNT_CONTACT_PIDM | SLBEVNT_CONTACT_PIDM | NUMBER(8,0) | Yes | ||
| SLBEVNT_ATYP_CODE | SLBEVNT_ATYP_CODE | VARCHAR2(2) | Yes | ||
| SLBEVNT_SYSI_CODE | SLBEVNT_SYSI_CODE | VARCHAR2(2) | Yes | ||
| SLBEVNT_COMM_IND | SLBEVNT_COMM_IND | VARCHAR2(1) | No | ||
| SLBEVNT_DICD_CODE | SLBEVNT_DICD_CODE | VARCHAR2(3) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLBEVNT_DICD_CODE | GTVDICD_CODE | GTVDICD |
| SLBEVNT_SITE_CODE | STVSITE_CODE | STVSITE |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLBEVNT | Unique | SLBEVNT_CRN |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:37:000 |
Table SLBRDEF| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLBRDEF_BLDG_CODE | SLBRDEF_BLDG_CODE | VARCHAR2(6) | No | * | * |
| SLBRDEF_ROOM_NUMBER | SLBRDEF_ROOM_NUMBER | VARCHAR2(10) | No | * | |
| SLBRDEF_ACTIVITY_DATE | SLBRDEF_ACTIVITY_DATE | DATE | No | ||
| SLBRDEF_DESC | SLBRDEF_DESC | VARCHAR2(50) | Yes | ||
| SLBRDEF_CAPACITY | SLBRDEF_CAPACITY | NUMBER(5,0) | No | ||
| SLBRDEF_MAXIMUM_CAPACITY | SLBRDEF_MAXIMUM_CAPACITY | NUMBER(5,0) | Yes | ||
| SLBRDEF_RMST_CODE | SLBRDEF_RMST_CODE | VARCHAR2(2) | Yes | * | |
| SLBRDEF_RRCD_CODE | SLBRDEF_RRCD_CODE | VARCHAR2(4) | Yes | ||
| SLBRDEF_PRCD_CODE | SLBRDEF_PRCD_CODE | VARCHAR2(4) | Yes | ||
| SLBRDEF_UTILITY_RATE | SLBRDEF_UTILITY_RATE | NUMBER(7,2) | Yes | ||
| SLBRDEF_UTILITY_RATE_PERIOD | SLBRDEF_UTILITY_RATE_PERIOD | VARCHAR2(2) | Yes | ||
| SLBRDEF_PHONE_AREA | SLBRDEF_PHONE_AREA | VARCHAR2(3) | Yes | ||
| SLBRDEF_PHONE_NUMBER | SLBRDEF_PHONE_NUMBER | VARCHAR2(7) | Yes | ||
| SLBRDEF_PHONE_EXTENSION | SLBRDEF_PHONE_EXTENSION | VARCHAR2(4) | Yes | ||
| SLBRDEF_BCAT_CODE | SLBRDEF_BCAT_CODE | VARCHAR2(4) | Yes | ||
| SLBRDEF_SEX | SLBRDEF_SEX | VARCHAR2(1) | Yes | ||
| SLBRDEF_ROOM_TYPE | SLBRDEF_ROOM_TYPE | VARCHAR2(1) | No | ||
| SLBRDEF_PRIORITY | SLBRDEF_PRIORITY | VARCHAR2(8) | Yes | ||
| SLBRDEF_COLL_CODE | SLBRDEF_COLL_CODE | VARCHAR2(2) | Yes | ||
| SLBRDEF_DEPT_CODE | SLBRDEF_DEPT_CODE | VARCHAR2(4) | Yes | ||
| SLBRDEF_KEY_NUMBER | SLBRDEF_KEY_NUMBER | VARCHAR2(5) | Yes | ||
| SLBRDEF_WIDTH | SLBRDEF_WIDTH | NUMBER(6,2) | Yes | ||
| SLBRDEF_LENGTH | SLBRDEF_LENGTH | NUMBER(6,2) | Yes | ||
| SLBRDEF_AREA | SLBRDEF_AREA | NUMBER(10,2) | Yes | ||
| SLBRDEF_TERM_CODE_EFF | SLBRDEF_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SLBRDEF_PARS_CODE | SLBRDEF_PARS_CODE | VARCHAR2(7) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLBRDEF_RMST_CODE | STVRMST_CODE | STVRMST |
| SLBRDEF_BLDG_CODE | SLBBLDG_BLDG_CODE | SLBBLDG |
| SLBRDEF_PARS_CODE | GTVPARS_CODE | GTVPARS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLBRDEF | Unique | SLBRDEF_BLDG_CODE |
| PK_SLBRDEF | Unique | SLBRDEF_ROOM_NUMBER |
| PK_SLBRDEF | Unique | SLBRDEF_TERM_CODE_EFF |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table SLBRMAP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLBRMAP_PIDM | SLBRMAP_PIDM | NUMBER(8,0) | No | * | * |
| SLBRMAP_ACTIVITY_DATE | SLBRMAP_ACTIVITY_DATE | DATE | No | ||
| SLBRMAP_ARTP_CODE | SLBRMAP_ARTP_CODE | VARCHAR2(4) | No | * | |
| SLBRMAP_FROM_TERM | SLBRMAP_FROM_TERM | VARCHAR2(6) | No | * | * |
| SLBRMAP_TO_TERM | SLBRMAP_TO_TERM | VARCHAR2(6) | No | * | |
| SLBRMAP_APPL_PRIORITY | SLBRMAP_APPL_PRIORITY | VARCHAR2(8) | Yes | ||
| SLBRMAP_PREFERED_BUILDING | SLBRMAP_PREFERED_BUILDING | VARCHAR2(6) | Yes | * | |
| SLBRMAP_PREFERED_ROOM | SLBRMAP_PREFERED_ROOM | VARCHAR2(10) | Yes | ||
| SLBRMAP_PREFERED_BCAT_CODE | SLBRMAP_PREFERED_BCAT_CODE | VARCHAR2(4) | Yes | * | |
| SLBRMAP_PREFERED_CAMP_CODE | SLBRMAP_PREFERED_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SLBRMAP_MRCD_CODE | SLBRMAP_MRCD_CODE | VARCHAR2(4) | Yes | * | |
| SLBRMAP_PR_PIDM | SLBRMAP_PR_PIDM | NUMBER(8,0) | Yes | ||
| SLBRMAP_CONFID_IND | SLBRMAP_CONFID_IND | VARCHAR2(1) | Yes | ||
| SLBRMAP_HAPS_CODE | SLBRMAP_HAPS_CODE | VARCHAR2(2) | Yes | * | |
| SLBRMAP_HAPS_DATE | SLBRMAP_HAPS_DATE | DATE | Yes | ||
| SLBRMAP_ADD_DATE | SLBRMAP_ADD_DATE | DATE | Yes | ||
| SLBRMAP_DATA_ORIGIN | SLBRMAP_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SLBRMAP_USER_ID | SLBRMAP_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLBRMAP_TO_TERM | STVTERM_CODE | STVTERM |
| SLBRMAP_FROM_TERM | STVTERM_CODE | STVTERM |
| SLBRMAP_PREFERED_BUILDING | SLRBCAT_BLDG_CODE | SLRBCAT |
| SLBRMAP_PREFERED_BCAT_CODE | SLRBCAT_CODE | SLRBCAT |
| SLBRMAP_HAPS_CODE | STVHAPS_CODE | STVHAPS |
| SLBRMAP_PREFERED_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SLBRMAP_ARTP_CODE | STVARTP_CODE | STVARTP |
| SLBRMAP_MRCD_CODE | STVMRCD_CODE | STVMRCD |
| SLBRMAP_PIDM | SLRRMAT_PIDM | SLRRMAT |
| SLBRMAP_FROM_TERM | SLRRMAT_TERM_CODE | SLRRMAT |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLBRMAP | Unique | SLBRMAP_PIDM |
| PK_SLBRMAP | Unique | SLBRMAP_FROM_TERM |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table SLBRMPF| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLBRMPF_TERM_CODE | SLBRMPF_TERM_CODE | VARCHAR2(6) | No | * | * |
| SLBRMPF_ONEUP | SLBRMPF_ONEUP | VARCHAR2(5) | No | * | |
| SLBRMPF_CAMP_CODE | SLBRMPF_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SLBRMPF_BLDG_CODE | SLBRMPF_BLDG_CODE | VARCHAR2(6) | Yes | * | |
| SLBRMPF_BCAT_CODE | SLBRMPF_BCAT_CODE | VARCHAR2(8) | Yes | ||
| SLBRMPF_ROOM_NUMBER | SLBRMPF_ROOM_NUMBER | VARCHAR2(10) | Yes | ||
| SLBRMPF_ACTIVITY_DATE | SLBRMPF_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLBRMPF_TERM_CODE | STVTERM_CODE | STVTERM |
| SLBRMPF_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SLBRMPF_BLDG_CODE | STVBLDG_CODE | STVBLDG |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLBRMPF | Unique | SLBRMPF_TERM_CODE |
| PK_SLBRMPF | Unique | SLBRMPF_ONEUP |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table SLBTERM| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLBTERM_TERM_CODE | SLBTERM_TERM_CODE | VARCHAR2(6) | No | * | * |
| SLBTERM_ACTIVITY_DATE | SLBTERM_ACTIVITY_DATE | DATE | No | ||
| SLBTERM_HOUS_ALLOWED | SLBTERM_HOUS_ALLOWED | VARCHAR2(1) | No | ||
| SLBTERM_FEE_ASSESSMENT | SLBTERM_FEE_ASSESSMENT | VARCHAR2(1) | No | ||
| SLBTERM_FEE_ASSESSMNT_EFF_DATE | SLBTERM_FEE_ASSESSMNT_EFF_DATE | DATE | Yes | ||
| SLBTERM_ONEUP | SLBTERM_ONEUP | NUMBER(5,0) | Yes | ||
| SLBTERM_MNTH_CUTOFF | SLBTERM_MNTH_CUTOFF | NUMBER(2,0) | Yes | ||
| SLBTERM_CUTOFF_DATE | SLBTERM_CUTOFF_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLBTERM_TERM_CODE | STVTERM_CODE | STVTERM |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLBTERM | Unique | SLBTERM_TERM_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table SLRASCD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRASCD_TERM_CODE | SLRASCD_TERM_CODE | VARCHAR2(6) | No | * | * |
| SLRASCD_ASCD_CODE | SLRASCD_ASCD_CODE | VARCHAR2(2) | No | * | * |
| SLRASCD_START_DATE | SLRASCD_START_DATE | DATE | Yes | ||
| SLRASCD_END_DATE | SLRASCD_END_DATE | DATE | Yes | ||
| SLRASCD_ACTIVITY_DATE | SLRASCD_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRASCD_TERM_CODE | STVTERM_CODE | STVTERM |
| SLRASCD_ASCD_CODE | STVASCD_CODE | STVASCD |
| SLRASCD_TERM_CODE | SLBTERM_TERM_CODE | SLBTERM |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLRASCD | Unique | SLRASCD_TERM_CODE |
| PK_SLRASCD | Unique | SLRASCD_ASCD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table SLRBCAT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRBCAT_BLDG_CODE | SLRBCAT_BLDG_CODE | VARCHAR2(6) | No | * | |
| SLRBCAT_CODE | SLRBCAT_CODE | VARCHAR2(4) | No | * | |
| SLRBCAT_DESC | SLRBCAT_DESC | VARCHAR2(30) | No | ||
| SLRBCAT_ACTIVITY_DATE | SLRBCAT_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLRBCAT | Unique | SLRBCAT_BLDG_CODE |
| PK_SLRBCAT | Unique | SLRBCAT_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table SLRBCMT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRBCMT_BLDG_CODE | SLRBCMT_BLDG_CODE | VARCHAR2(6) | No | ||
| SLRBCMT_SEQNO | SLRBCMT_SEQNO | NUMBER(23,20) | No | ||
| SLRBCMT_COMMENTS | SLRBCMT_COMMENTS | VARCHAR2(60) | No | ||
| SLRBCMT_ACTIVITY_DATE | SLRBCMT_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRBCMT_KEY_INDEX | SLRBCMT_BLDG_CODE | |
| SLRBCMT_KEY_INDEX | SLRBCMT_SEQNO |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table SLRBDEF| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRBDEF_BLDG_CODE | SLRBDEF_BLDG_CODE | VARCHAR2(6) | No | * | |
| SLRBDEF_RDEF_CODE | SLRBDEF_RDEF_CODE | VARCHAR2(5) | No | * | |
| SLRBDEF_ACTIVITY_DATE | SLRBDEF_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLRBDEF | Unique | SLRBDEF_BLDG_CODE |
| PK_SLRBDEF | Unique | SLRBDEF_RDEF_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table SLRCMNT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRCMNT_BLDG_CODE | SLRCMNT_BLDG_CODE | VARCHAR2(6) | No | * | |
| SLRCMNT_ROOM_NUMBER | SLRCMNT_ROOM_NUMBER | VARCHAR2(10) | No | * | |
| SLRCMNT_COMMENTS | SLRCMNT_COMMENTS | VARCHAR2(60) | No | ||
| SLRCMNT_SEQNO | SLRCMNT_SEQNO | NUMBER(23,20) | No | * | |
| SLRCMNT_ACTIVITY_DATE | SLRCMNT_ACTIVITY_DATE | DATE | No | ||
| SLRCMNT_TERM_CODE_EFF | SLRCMNT_TERM_CODE_EFF | VARCHAR2(6) | No | * |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLRCMNT | Unique | SLRCMNT_BLDG_CODE |
| PK_SLRCMNT | Unique | SLRCMNT_ROOM_NUMBER |
| PK_SLRCMNT | Unique | SLRCMNT_TERM_CODE_EFF |
| PK_SLRCMNT | Unique | SLRCMNT_SEQNO |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table SLRCOLC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRCOLC_SESSIONID | SLRCOLC_SESSIONID | VARCHAR2(10) | No | * | |
| SLRCOLC_RDEF_CODE | SLRCOLC_RDEF_CODE | VARCHAR2(4) | No | * |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLRCOLC | Unique | SLRCOLC_SESSIONID |
| PK_SLRCOLC | Unique | SLRCOLC_RDEF_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table SLRCOLR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRCOLR_SESSIONID | SLRCOLR_SESSIONID | VARCHAR2(30) | No | * | |
| SLRCOLR_TERM_CODE | SLRCOLR_TERM_CODE | VARCHAR2(6) | No | * | * |
| SLRCOLR_PIDM | SLRCOLR_PIDM | VARCHAR2(8) | No | * | |
| SLRCOLR_ACTIVITY_DATE | SLRCOLR_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRCOLR_TERM_CODE | STVTERM_CODE | STVTERM |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLRCOLR | Unique | SLRCOLR_SESSIONID |
| PK_SLRCOLR | Unique | SLRCOLR_TERM_CODE |
| PK_SLRCOLR | Unique | SLRCOLR_PIDM |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table SLRDCOL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRDCOL_SESSIONID | SLRDCOL_SESSIONID | VARCHAR2(10) | No | ||
| SLRDCOL_PIDM | SLRDCOL_PIDM | NUMBER(8,0) | No | ||
| SLRDCOL_RDEF_CODE | SLRDCOL_RDEF_CODE | VARCHAR2(4) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRDCOL_RDEF_CODE | STVRDEF_CODE | STVRDEF |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRDCOL_KEY_INDEX | Unique | SLRDCOL_SESSIONID |
| SLRDCOL_KEY_INDEX | Unique | SLRDCOL_PIDM |
| SLRDCOL_KEY_INDEX | Unique | SLRDCOL_RDEF_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table SLRECMT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRECMT_CRN | SLRECMT_CRN | VARCHAR2(6) | No | ||
| SLRECMT_SEQNO | SLRECMT_SEQNO | NUMBER(23,20) | No | ||
| SLRECMT_COMMENTS | SLRECMT_COMMENTS | VARCHAR2(60) | No | ||
| SLRECMT_ACTIVITY_DATE | SLRECMT_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRECMT_KEY_INDEX | SLRECMT_CRN | |
| SLRECMT_KEY_INDEX | SLRECMT_SEQNO |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table SLRLMFE| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRLMFE_TERM_CODE | SLRLMFE_TERM_CODE | VARCHAR2(6) | No | * | |
| SLRLMFE_RATE_CODE | SLRLMFE_RATE_CODE | VARCHAR2(4) | No | * | |
| SLRLMFE_M_D_T | SLRLMFE_M_D_T | VARCHAR2(1) | No | ||
| SLRLMFE_DETAIL_CODE | SLRLMFE_DETAIL_CODE | VARCHAR2(4) | No | * | |
| SLRLMFE_BASE_RATE | SLRLMFE_BASE_RATE | NUMBER(9,4) | No | ||
| SLRLMFE_MIN_CHARGE | SLRLMFE_MIN_CHARGE | NUMBER(7,2) | No | ||
| SLRLMFE_MAX_CHARGE | SLRLMFE_MAX_CHARGE | NUMBER(7,2) | No | ||
| SLRLMFE_TYPE | SLRLMFE_TYPE | VARCHAR2(7) | No | ||
| SLRLMFE_ACTIVITY_DATE | SLRLMFE_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRLMFE_TERM_CODE | STVTERM_CODE | STVTERM |
| SLRLMFE_TERM_CODE | SLBTERM_TERM_CODE | SLBTERM |
| SLRLMFE_RATE_CODE | STVMRCD_CODE | STVMRCD |
| SLRLMFE_RATE_CODE | STVRRCD_CODE | STVRRCD |
| SLRLMFE_RATE_CODE | STVPRCD_CODE | STVPRCD |
| SLRLMFE_RATE_CODE | SLRRASG_RRCD_CODE | SLRRASG |
| SLRLMFE_RATE_CODE | SLRMASG_MRCD_CODE | SLRMASG |
| SLRLMFE_RATE_CODE | SLRPASG_PRCD_CODE | SLRPASG |
| SLRLMFE_DETAIL_CODE | TBBDETC_DETAIL_CODE | TBBDETC |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRLMFE_KEY_INDEX | SLRLMFE_TERM_CODE | |
| SLRLMFE_KEY_INDEX | SLRLMFE_TYPE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table SLRMASG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRMASG_PIDM | SLRMASG_PIDM | NUMBER(8,0) | No | ||
| SLRMASG_TERM_CODE | SLRMASG_TERM_CODE | VARCHAR2(6) | No | * | |
| SLRMASG_MRCD_CODE | SLRMASG_MRCD_CODE | VARCHAR2(4) | No | * | |
| SLRMASG_BEGIN_DATE | SLRMASG_BEGIN_DATE | DATE | No | ||
| SLRMASG_END_DATE | SLRMASG_END_DATE | DATE | No | ||
| SLRMASG_TOTAL_DAYS | SLRMASG_TOTAL_DAYS | NUMBER(9,5) | No | ||
| SLRMASG_TOTAL_MONTHS | SLRMASG_TOTAL_MONTHS | NUMBER(7,5) | No | ||
| SLRMASG_TOTAL_TERMS | SLRMASG_TOTAL_TERMS | NUMBER(7,5) | No | ||
| SLRMASG_MSCD_CODE | SLRMASG_MSCD_CODE | VARCHAR2(2) | No | * | |
| SLRMASG_MSCD_DATE | SLRMASG_MSCD_DATE | DATE | No | ||
| SLRMASG_ONL_OR_BAT | SLRMASG_ONL_OR_BAT | VARCHAR2(1) | No | ||
| SLRMASG_ACTIVITY_DATE | SLRMASG_ACTIVITY_DATE | DATE | No | ||
| SLRMASG_AR_IND | SLRMASG_AR_IND | VARCHAR2(1) | No | ||
| SLRMASG_ROLL_IND | SLRMASG_ROLL_IND | VARCHAR2(1) | Yes | ||
| SLRMASG_ASSESS_NEEDED | SLRMASG_ASSESS_NEEDED | VARCHAR2(1) | No | ||
| SLRMASG_DATA_ORIGIN | SLRMASG_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SLRMASG_USER_ID | SLRMASG_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRMASG_TERM_CODE | STVTERM_CODE | STVTERM |
| SLRMASG_MSCD_CODE | STVMSCD_CODE | STVMSCD |
| SLRMASG_MRCD_CODE | STVMRCD_CODE | STVMRCD |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRMASG_KEY_INDEX | SLRMASG_PIDM | |
| SLRMASG_KEY_INDEX | SLRMASG_TERM_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table SLRMFCR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRMFCR_TERM_CODE | SLRMFCR_TERM_CODE | VARCHAR2(6) | No | * | |
| SLRMFCR_MSCD_CODE | SLRMFCR_MSCD_CODE | VARCHAR2(2) | No | * | |
| SLRMFCR_FROM_DATE | SLRMFCR_FROM_DATE | DATE | Yes | ||
| SLRMFCR_TO_DATE | SLRMFCR_TO_DATE | DATE | Yes | ||
| SLRMFCR_REFUND | SLRMFCR_REFUND | NUMBER(3,0) | No | ||
| SLRMFCR_ACTIVITY_DATE | SLRMFCR_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRMFCR_TERM_CODE | STVTERM_CODE | STVTERM |
| SLRMFCR_MSCD_CODE | STVMSCD_CODE | STVMSCD |
| SLRMFCR_TERM_CODE | SLRMSCD_TERM_CODE | SLRMSCD |
| SLRMFCR_MSCD_CODE | SLRMSCD_MSCD_CODE | SLRMSCD |
| SLRMFCR_TERM_CODE | SLRMASG_TERM_CODE | SLRMASG |
| SLRMFCR_MSCD_CODE | SLRMASG_MSCD_CODE | SLRMASG |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRMFCR_KEY_INDEX | Unique | SLRMFCR_TERM_CODE |
| SLRMFCR_KEY_INDEX | Unique | SLRMFCR_MSCD_CODE |
| SLRMFCR_KEY_INDEX | Unique | SLRMFCR_FROM_DATE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table SLRMSCD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRMSCD_TERM_CODE | SLRMSCD_TERM_CODE | VARCHAR2(6) | No | * | * |
| SLRMSCD_MSCD_CODE | SLRMSCD_MSCD_CODE | VARCHAR2(2) | No | * | * |
| SLRMSCD_START_DATE | SLRMSCD_START_DATE | DATE | Yes | ||
| SLRMSCD_END_DATE | SLRMSCD_END_DATE | DATE | Yes | ||
| SLRMSCD_ACTIVITY_DATE | SLRMSCD_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRMSCD_TERM_CODE | SLBTERM_TERM_CODE | SLBTERM |
| SLRMSCD_MSCD_CODE | STVMSCD_CODE | STVMSCD |
| SLRMSCD_TERM_CODE | STVTERM_CODE | STVTERM |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLRMSCD | Unique | SLRMSCD_TERM_CODE |
| PK_SLRMSCD | Unique | SLRMSCD_MSCD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table SLRPASG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRPASG_PIDM | SLRPASG_PIDM | NUMBER(8,0) | No | * | |
| SLRPASG_TERM_CODE | SLRPASG_TERM_CODE | VARCHAR2(6) | No | * | |
| SLRPASG_PRCD_CODE | SLRPASG_PRCD_CODE | VARCHAR2(4) | No | * | |
| SLRPASG_PHONE_ACCOUNT_NUMBER | SLRPASG_PHONE_ACCOUNT_NUMBER | VARCHAR2(20) | Yes | ||
| SLRPASG_PHONE_AREA | SLRPASG_PHONE_AREA | VARCHAR2(3) | Yes | ||
| SLRPASG_PHONE_EXT | SLRPASG_PHONE_EXT | VARCHAR2(4) | Yes | ||
| SLRPASG_PHONE_NUMBER | SLRPASG_PHONE_NUMBER | VARCHAR2(7) | No | ||
| SLRPASG_BEGIN_DATE | SLRPASG_BEGIN_DATE | DATE | No | ||
| SLRPASG_END_DATE | SLRPASG_END_DATE | DATE | No | ||
| SLRPASG_TOTAL_DAYS | SLRPASG_TOTAL_DAYS | NUMBER(9,5) | No | ||
| SLRPASG_TOTAL_MONTHS | SLRPASG_TOTAL_MONTHS | NUMBER(7,5) | No | ||
| SLRPASG_TOTAL_TERMS | SLRPASG_TOTAL_TERMS | NUMBER(7,5) | No | ||
| SLRPASG_PSCD_CODE | SLRPASG_PSCD_CODE | VARCHAR2(2) | No | * | |
| SLRPASG_PSCD_DATE | SLRPASG_PSCD_DATE | DATE | No | ||
| SLRPASG_ONL_OR_BAT | SLRPASG_ONL_OR_BAT | VARCHAR2(1) | No | ||
| SLRPASG_ACTIVITY_DATE | SLRPASG_ACTIVITY_DATE | DATE | No | ||
| SLRPASG_AR_IND | SLRPASG_AR_IND | VARCHAR2(1) | No | ||
| SLRPASG_ROLL_IND | SLRPASG_ROLL_IND | VARCHAR2(1) | Yes | ||
| SLRPASG_ASSESS_NEEDED | SLRPASG_ASSESS_NEEDED | VARCHAR2(1) | No | ||
| SLRPASG_DATA_ORIGIN | SLRPASG_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SLRPASG_USER_ID | SLRPASG_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRPASG_TERM_CODE | STVTERM_CODE | STVTERM |
| SLRPASG_PRCD_CODE | STVPRCD_CODE | STVPRCD |
| SLRPASG_PSCD_CODE | STVPSCD_CODE | STVPSCD |
| SLRPASG_PIDM | SLRRASG_PIDM | SLRRASG |
| SLRPASG_TERM_CODE | SLRRASG_TERM_CODE | SLRRASG |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRPASG_KEY_INDEX | SLRPASG_PIDM | |
| SLRPASG_KEY_INDEX | SLRPASG_TERM_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table SLRPFCR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRPFCR_TERM_CODE | SLRPFCR_TERM_CODE | VARCHAR2(6) | No | * | |
| SLRPFCR_PSCD_CODE | SLRPFCR_PSCD_CODE | VARCHAR2(2) | No | * | |
| SLRPFCR_FROM_DATE | SLRPFCR_FROM_DATE | DATE | Yes | ||
| SLRPFCR_TO_DATE | SLRPFCR_TO_DATE | DATE | Yes | ||
| SLRPFCR_REFUND | SLRPFCR_REFUND | NUMBER(3,0) | No | ||
| SLRPFCR_ACTIVITY_DATE | SLRPFCR_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRPFCR_TERM_CODE | STVTERM_CODE | STVTERM |
| SLRPFCR_TERM_CODE | SLRPSCD_TERM_CODE | SLRPSCD |
| SLRPFCR_PSCD_CODE | SLRPSCD_PSCD_CODE | SLRPSCD |
| SLRPFCR_PSCD_CODE | STVPSCD_CODE | STVPSCD |
| SLRPFCR_TERM_CODE | SLRPASG_TERM_CODE | SLRPASG |
| SLRPFCR_PSCD_CODE | SLRPASG_PSCD_CODE | SLRPASG |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRPFCR_KEY_INDEX | Unique | SLRPFCR_TERM_CODE |
| SLRPFCR_KEY_INDEX | Unique | SLRPFCR_PSCD_CODE |
| SLRPFCR_KEY_INDEX | Unique | SLRPFCR_FROM_DATE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table SLRPREQ| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRPREQ_PIDM | SLRPREQ_PIDM | NUMBER(8,0) | No | ||
| SLRPREQ_TERM_CODE | SLRPREQ_TERM_CODE | VARCHAR2(6) | No | * | |
| SLRPREQ_RDEF_CODE | SLRPREQ_RDEF_CODE | VARCHAR2(4) | No | * | |
| SLRPREQ_MUST_MATCH | SLRPREQ_MUST_MATCH | VARCHAR2(1) | Yes | ||
| SLRPREQ_ACTIVITY_DATE | SLRPREQ_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRPREQ_RDEF_CODE | STVRDEF_CODE | STVRDEF |
| SLRPREQ_TERM_CODE | STVTERM_CODE | STVTERM |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRPREQ_KEY_INDEX | SLRPREQ_PIDM |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table SLRPSCD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRPSCD_TERM_CODE | SLRPSCD_TERM_CODE | VARCHAR2(6) | No | * | * |
| SLRPSCD_PSCD_CODE | SLRPSCD_PSCD_CODE | VARCHAR2(2) | No | * | * |
| SLRPSCD_START_DATE | SLRPSCD_START_DATE | DATE | Yes | ||
| SLRPSCD_END_DATE | SLRPSCD_END_DATE | DATE | Yes | ||
| SLRPSCD_ACTIVITY_DATE | SLRPSCD_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRPSCD_PSCD_CODE | STVPSCD_CODE | STVPSCD |
| SLRPSCD_TERM_CODE | STVTERM_CODE | STVTERM |
| SLRPSCD_TERM_CODE | SLBTERM_TERM_CODE | SLBTERM |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLRPSCD | Unique | SLRPSCD_TERM_CODE |
| PK_SLRPSCD | Unique | SLRPSCD_PSCD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table SLRRASG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRRASG_PIDM | SLRRASG_PIDM | NUMBER(8,0) | No | * | |
| SLRRASG_BLDG_CODE | SLRRASG_BLDG_CODE | VARCHAR2(6) | No | * | |
| SLRRASG_ROOM_NUMBER | SLRRASG_ROOM_NUMBER | VARCHAR2(10) | No | * | |
| SLRRASG_TERM_CODE | SLRRASG_TERM_CODE | VARCHAR2(6) | No | * | |
| SLRRASG_RRCD_CODE | SLRRASG_RRCD_CODE | VARCHAR2(4) | No | * | |
| SLRRASG_BEGIN_DATE | SLRRASG_BEGIN_DATE | DATE | No | ||
| SLRRASG_END_DATE | SLRRASG_END_DATE | DATE | No | ||
| SLRRASG_TOTAL_DAYS | SLRRASG_TOTAL_DAYS | NUMBER(9,5) | No | ||
| SLRRASG_TOTAL_MONTHS | SLRRASG_TOTAL_MONTHS | NUMBER(7,5) | No | ||
| SLRRASG_TOTAL_TERMS | SLRRASG_TOTAL_TERMS | NUMBER(7,5) | No | ||
| SLRRASG_ASCD_CODE | SLRRASG_ASCD_CODE | VARCHAR2(2) | No | * | |
| SLRRASG_ASCD_DATE | SLRRASG_ASCD_DATE | DATE | No | ||
| SLRRASG_ONL_OR_BAT | SLRRASG_ONL_OR_BAT | VARCHAR2(1) | No | ||
| SLRRASG_ACTIVITY_DATE | SLRRASG_ACTIVITY_DATE | DATE | No | ||
| SLRRASG_AR_IND | SLRRASG_AR_IND | VARCHAR2(1) | No | ||
| SLRRASG_OVERLOAD_IND | SLRRASG_OVERLOAD_IND | VARCHAR2(1) | Yes | ||
| SLRRASG_ROLL_IND | SLRRASG_ROLL_IND | VARCHAR2(1) | Yes | ||
| SLRRASG_OVERRIDE_ERROR | SLRRASG_OVERRIDE_ERROR | VARCHAR2(1) | Yes | ||
| SLRRASG_ASSESS_NEEDED | SLRRASG_ASSESS_NEEDED | VARCHAR2(1) | No | ||
| SLRRASG_DATA_ORIGIN | SLRRASG_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SLRRASG_USER_ID | SLRRASG_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRRASG_TERM_CODE | STVTERM_CODE | STVTERM |
| SLRRASG_RRCD_CODE | STVRRCD_CODE | STVRRCD |
| SLRRASG_ASCD_CODE | STVASCD_CODE | STVASCD |
| SLRRASG_BLDG_CODE | STVBLDG_CODE | STVBLDG |
| SLRRASG_BLDG_CODE | SLBBLDG_BLDG_CODE | SLBBLDG |
| SLRRASG_PIDM | SPBPERS_PIDM | SPBPERS |
| SLRRASG_PIDM | SPRIDEN_PIDM | SPRIDEN |
| SLRRASG_BLDG_CODE | SLBRDEF_BLDG_CODE | SLBRDEF |
| SLRRASG_ROOM_NUMBER | SLBRDEF_ROOM_NUMBER | SLBRDEF |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRRASG_BLDG_INDEX | SLRRASG_BLDG_CODE | |
| SLRRASG_BLDG_INDEX | SLRRASG_ROOM_NUMBER | |
| SLRRASG_KEY_INDEX | SLRRASG_PIDM | |
| SLRRASG_KEY_INDEX | SLRRASG_BLDG_CODE | |
| SLRRASG_KEY_INDEX | SLRRASG_ROOM_NUMBER |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table SLRRDEF| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRRDEF_BLDG_CODE | SLRRDEF_BLDG_CODE | VARCHAR2(6) | No | * | |
| SLRRDEF_ROOM_NUMBER | SLRRDEF_ROOM_NUMBER | VARCHAR2(10) | No | * | |
| SLRRDEF_RDEF_CODE | SLRRDEF_RDEF_CODE | VARCHAR2(4) | No | * | * |
| SLRRDEF_MUST_MATCH | SLRRDEF_MUST_MATCH | VARCHAR2(1) | Yes | ||
| SLRRDEF_ACTIVITY_DATE | SLRRDEF_ACTIVITY_DATE | DATE | No | ||
| SLRRDEF_TERM_CODE_EFF | SLRRDEF_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SLRRDEF_DATA_ORIGIN | SLRRDEF_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SLRRDEF_USER_ID | SLRRDEF_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRRDEF_RDEF_CODE | STVRDEF_CODE | STVRDEF |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLRRDEF | Unique | SLRRDEF_BLDG_CODE |
| PK_SLRRDEF | Unique | SLRRDEF_ROOM_NUMBER |
| PK_SLRRDEF | Unique | SLRRDEF_TERM_CODE_EFF |
| PK_SLRRDEF | Unique | SLRRDEF_RDEF_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table SLRRFCR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRRFCR_TERM_CODE | SLRRFCR_TERM_CODE | VARCHAR2(6) | No | * | |
| SLRRFCR_ASCD_CODE | SLRRFCR_ASCD_CODE | VARCHAR2(2) | No | * | |
| SLRRFCR_FROM_DATE | SLRRFCR_FROM_DATE | DATE | Yes | ||
| SLRRFCR_TO_DATE | SLRRFCR_TO_DATE | DATE | Yes | ||
| SLRRFCR_REFUND | SLRRFCR_REFUND | NUMBER(3,0) | No | ||
| SLRRFCR_ACTIVITY_DATE | SLRRFCR_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRRFCR_TERM_CODE | STVTERM_CODE | STVTERM |
| SLRRFCR_ASCD_CODE | STVASCD_CODE | STVASCD |
| SLRRFCR_TERM_CODE | SLRASCD_TERM_CODE | SLRASCD |
| SLRRFCR_ASCD_CODE | SLRASCD_ASCD_CODE | SLRASCD |
| SLRRFCR_TERM_CODE | SLRRASG_TERM_CODE | SLRRASG |
| SLRRFCR_ASCD_CODE | SLRRASG_ASCD_CODE | SLRRASG |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRRFCR_KEY_INDEX | Unique | SLRRFCR_TERM_CODE |
| SLRRFCR_KEY_INDEX | Unique | SLRRFCR_ASCD_CODE |
| SLRRFCR_KEY_INDEX | Unique | SLRRFCR_FROM_DATE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table SLRRMAT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRRMAT_TERM_CODE | SLRRMAT_TERM_CODE | VARCHAR2(6) | No | * | * |
| SLRRMAT_ONEUP | SLRRMAT_ONEUP | VARCHAR2(5) | No | * | |
| SLRRMAT_PIDM | SLRRMAT_PIDM | NUMBER(8,0) | No | * | |
| SLRRMAT_ACCEPT_IND | SLRRMAT_ACCEPT_IND | VARCHAR2(1) | Yes | ||
| SLRRMAT_ACTIVITY_DATE | SLRRMAT_ACTIVITY_DATE | DATE | No | ||
| SLRRMAT_DATA_ORIGIN | SLRRMAT_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SLRRMAT_USER_ID | SLRRMAT_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRRMAT_TERM_CODE | STVTERM_CODE | STVTERM |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLRRMAT | Unique | SLRRMAT_TERM_CODE |
| PK_SLRRMAT | Unique | SLRRMAT_ONEUP |
| PK_SLRRMAT | Unique | SLRRMAT_PIDM |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table SLRRMDF| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRRMDF_TERM_CODE | SLRRMDF_TERM_CODE | VARCHAR2(6) | No | * | * |
| SLRRMDF_ONEUP | SLRRMDF_ONEUP | VARCHAR2(5) | No | * | |
| SLRRMDF_RDEF_CODE | SLRRMDF_RDEF_CODE | VARCHAR2(4) | No | * | * |
| SLRRMDF_MUST_MATCH | SLRRMDF_MUST_MATCH | VARCHAR2(1) | Yes | ||
| SLRRMDF_ACTIVITY_DATE | SLRRMDF_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRRMDF_TERM_CODE | STVTERM_CODE | STVTERM |
| SLRRMDF_RDEF_CODE | STVRDEF_CODE | STVRDEF |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SLRRMDF | Unique | SLRRMDF_TERM_CODE |
| PK_SLRRMDF | Unique | SLRRMDF_ONEUP |
| PK_SLRRMDF | Unique | SLRRMDF_RDEF_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table SLRRUSE| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRRUSE_BLDG_CODE | SLRRUSE_BLDG_CODE | VARCHAR2(6) | No | ||
| SLRRUSE_ROOM_NUMBER | SLRRUSE_ROOM_NUMBER | VARCHAR2(10) | No | ||
| SLRRUSE_START_DATE | SLRRUSE_START_DATE | DATE | No | ||
| SLRRUSE_END_DATE | SLRRUSE_END_DATE | DATE | Yes | ||
| SLRRUSE_ACTIVITY_DATE | SLRRUSE_ACTIVITY_DATE | DATE | No | ||
| SLRRUSE_BEGIN_TIME | SLRRUSE_BEGIN_TIME | VARCHAR2(4) | Yes | ||
| SLRRUSE_END_TIME | SLRRUSE_END_TIME | VARCHAR2(4) | Yes | ||
| SLRRUSE_SUN_DAY | SLRRUSE_SUN_DAY | VARCHAR2(1) | Yes | ||
| SLRRUSE_MON_DAY | SLRRUSE_MON_DAY | VARCHAR2(1) | Yes | ||
| SLRRUSE_TUE_DAY | SLRRUSE_TUE_DAY | VARCHAR2(1) | Yes | ||
| SLRRUSE_WED_DAY | SLRRUSE_WED_DAY | VARCHAR2(1) | Yes | ||
| SLRRUSE_THU_DAY | SLRRUSE_THU_DAY | VARCHAR2(1) | Yes | ||
| SLRRUSE_FRI_DAY | SLRRUSE_FRI_DAY | VARCHAR2(1) | Yes | ||
| SLRRUSE_SAT_DAY | SLRRUSE_SAT_DAY | VARCHAR2(1) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRRUSE_KEY_INDEX | SLRRUSE_BLDG_CODE | |
| SLRRUSE_KEY_INDEX | SLRRUSE_ROOM_NUMBER |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table SLRTASG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLRTASG_TERM_CODE | SLRTASG_TERM_CODE | VARCHAR2(6) | No | * | |
| SLRTASG_PIDM | SLRTASG_PIDM | NUMBER(8,0) | No | ||
| SLRTASG_PRIORITY | SLRTASG_PRIORITY | VARCHAR2(8) | Yes | ||
| SLRTASG_BLDG_CODE | SLRTASG_BLDG_CODE | VARCHAR2(6) | Yes | * | |
| SLRTASG_ROOM_NUMBER | SLRTASG_ROOM_NUMBER | VARCHAR2(10) | Yes | ||
| SLRTASG_BCAT_CODE | SLRTASG_BCAT_CODE | VARCHAR2(8) | Yes | ||
| SLRTASG_CAMP_CODE | SLRTASG_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SLRTASG_ONEUP | SLRTASG_ONEUP | VARCHAR2(5) | Yes | ||
| SLRTASG_RMATE_OK | SLRTASG_RMATE_OK | VARCHAR2(1) | Yes | ||
| SLRTASG_MESSAGE | SLRTASG_MESSAGE | VARCHAR2(45) | Yes | ||
| SLRTASG_MESSAGE_SEQ | SLRTASG_MESSAGE_SEQ | NUMBER(2,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SLRTASG_TERM_CODE | STVTERM_CODE | STVTERM |
| SLRTASG_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SLRTASG_BLDG_CODE | STVBLDG_CODE | STVBLDG |
| Index Name | Index Type | Column Name |
|---|---|---|
| SLRTASG_KEY_INDEX | SLRTASG_TERM_CODE | |
| SLRTASG_KEY_INDEX | SLRTASG_PIDM |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Table SLTFTRN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SLTFTRN_PIDM | SLTFTRN_PIDM | NUMBER(8,0) | No | ||
| SLTFTRN_TERM_CODE | SLTFTRN_TERM_CODE | VARCHAR2(6) | No | ||
| SLTFTRN_DETAIL_CODE | SLTFTRN_DETAIL_CODE | VARCHAR2(4) | No | ||
| SLTFTRN_EFF_DATE | SLTFTRN_EFF_DATE | DATE | No | ||
| SLTFTRN_SRCE_CODE | SLTFTRN_SRCE_CODE | VARCHAR2(1) | No | ||
| SLTFTRN_AMOUNT | SLTFTRN_AMOUNT | NUMBER(12,2) | No |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41: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 SSRMEET| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SSRMEET_TERM_CODE | SSRMEET_TERM_CODE | VARCHAR2(6) | No | * | |
| SSRMEET_CRN | SSRMEET_CRN | VARCHAR2(5) | No | * | |
| SSRMEET_DAYS_CODE | SSRMEET_DAYS_CODE | VARCHAR2(1) | Yes | ||
| SSRMEET_DAY_NUMBER | SSRMEET_DAY_NUMBER | NUMBER(1,0) | Yes | ||
| SSRMEET_BEGIN_TIME | SSRMEET_BEGIN_TIME | VARCHAR2(4) | Yes | ||
| SSRMEET_END_TIME | SSRMEET_END_TIME | VARCHAR2(4) | Yes | ||
| SSRMEET_BLDG_CODE | SSRMEET_BLDG_CODE | VARCHAR2(6) | Yes | * | |
| SSRMEET_ROOM_CODE | SSRMEET_ROOM_CODE | VARCHAR2(10) | Yes | ||
| SSRMEET_ACTIVITY_DATE | SSRMEET_ACTIVITY_DATE | DATE | No | ||
| SSRMEET_START_DATE | SSRMEET_START_DATE | DATE | No | ||
| SSRMEET_END_DATE | SSRMEET_END_DATE | DATE | No | ||
| SSRMEET_CATAGORY | SSRMEET_CATAGORY | VARCHAR2(2) | Yes | * | |
| SSRMEET_SUN_DAY | SSRMEET_SUN_DAY | VARCHAR2(1) | Yes | * | |
| SSRMEET_MON_DAY | SSRMEET_MON_DAY | VARCHAR2(1) | Yes | * | |
| SSRMEET_TUE_DAY | SSRMEET_TUE_DAY | VARCHAR2(1) | Yes | * | |
| SSRMEET_WED_DAY | SSRMEET_WED_DAY | VARCHAR2(1) | Yes | * | |
| SSRMEET_THU_DAY | SSRMEET_THU_DAY | VARCHAR2(1) | Yes | * | |
| SSRMEET_FRI_DAY | SSRMEET_FRI_DAY | VARCHAR2(1) | Yes | * | |
| SSRMEET_SAT_DAY | SSRMEET_SAT_DAY | VARCHAR2(1) | Yes | * | |
| SSRMEET_SCHD_CODE | SSRMEET_SCHD_CODE | VARCHAR2(3) | Yes | * | |
| SSRMEET_OVER_RIDE | SSRMEET_OVER_RIDE | VARCHAR2(1) | Yes | ||
| SSRMEET_CREDIT_HR_SESS | SSRMEET_CREDIT_HR_SESS | NUMBER(7,3) | Yes | ||
| SSRMEET_MEET_NO | SSRMEET_MEET_NO | NUMBER(4,0) | Yes | ||
| SSRMEET_HRS_WEEK | SSRMEET_HRS_WEEK | NUMBER(5,2) | Yes | ||
| SSRMEET_FUNC_CODE | SSRMEET_FUNC_CODE | VARCHAR2(12) | Yes | * | |
| SSRMEET_COMT_CODE | SSRMEET_COMT_CODE | VARCHAR2(6) | Yes | * | |
| SSRMEET_SCHS_CODE | SSRMEET_SCHS_CODE | VARCHAR2(3) | Yes | * | |
| SSRMEET_MTYP_CODE | SSRMEET_MTYP_CODE | VARCHAR2(4) | Yes | * | |
| SSRMEET_DATA_ORIGIN | SSRMEET_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SSRMEET_USER_ID | SSRMEET_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SSRMEET_COMT_CODE | STVCOMT_CODE | STVCOMT |
| SSRMEET_TERM_CODE | SIRASGN_TERM_CODE | SIRASGN |
| SSRMEET_CRN | SIRASGN_CRN | SIRASGN |
| SSRMEET_CATAGORY | SIRASGN_CATEGORY | SIRASGN |
| SSRMEET_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC |
| SSRMEET_MON_DAY | SSREXCL_DAY | SSREXCL |
| SSRMEET_TUE_DAY | SSREXCL_DAY | SSREXCL |
| SSRMEET_WED_DAY | SSREXCL_DAY | SSREXCL |
| SSRMEET_THU_DAY | SSREXCL_DAY | SSREXCL |
| SSRMEET_FRI_DAY | SSREXCL_DAY | SSREXCL |
| SSRMEET_SAT_DAY | SSREXCL_DAY | SSREXCL |
| SSRMEET_SUN_DAY | SSREXCL_DAY | SSREXCL |
| SSRMEET_SCHD_CODE | SCRSCHD_SCHD_CODE | SCRSCHD |
| SSRMEET_CRN | SSRXLST_CRN | SSRXLST |
| SSRMEET_TERM_CODE | SSRXLST_TERM_CODE | SSRXLST |
| SSRMEET_BLDG_CODE | SLBBLDG_BLDG_CODE | SLBBLDG |
| SSRMEET_SCHS_CODE | GTVSCHS_CODE | GTVSCHS |
| SSRMEET_MTYP_CODE | GTVMTYP_CODE | GTVMTYP |
| SSRMEET_TERM_CODE | SSBSECT_TERM_CODE | SSBSECT |
| SSRMEET_CRN | SSBSECT_CRN | SSBSECT |
| SSRMEET_TERM_CODE | SFRSTCR_TERM_CODE | SFRSTCR |
| SSRMEET_CRN | SFRSTCR_CRN | SFRSTCR |
| SSRMEET_TERM_CODE | SFTREGS_TERM_CODE | SFTREGS |
| SSRMEET_CRN | SFTREGS_CRN | SFTREGS |
| Index Name | Index Type | Column Name |
|---|---|---|
| SSRMEET_KEY_INDEX | SSRMEET_TERM_CODE | |
| SSRMEET_KEY_INDEX | SSRMEET_CRN | |
| SSRMEET_KEY_INDEX | SSRMEET_BEGIN_TIME | |
| SSRMEET_KEY_INDEX | SSRMEET_MON_DAY | |
| SSRMEET_KEY_INDEX | SSRMEET_TUE_DAY | |
| SSRMEET_KEY_INDEX | SSRMEET_WED_DAY | |
| SSRMEET_KEY_INDEX | SSRMEET_THU_DAY | |
| SSRMEET_KEY_INDEX | SSRMEET_FRI_DAY | |
| SSRMEET_KEY_INDEX | SSRMEET_SAT_DAY | |
| SSRMEET_KEY_INDEX | SSRMEET_SUN_DAY | |
| SSRMEET_KEY_INDEX2 | SSRMEET_BLDG_CODE | |
| SSRMEET_KEY_INDEX2 | SSRMEET_ROOM_CODE | |
| SSRMEET_KEY_INDEX2 | SSRMEET_BEGIN_TIME | |
| SSRMEET_KEY_INDEX2 | SSRMEET_END_TIME | |
| SSRMEET_KEY_INDEX2 | SSRMEET_MON_DAY | |
| SSRMEET_KEY_INDEX2 | SSRMEET_TUE_DAY | |
| SSRMEET_KEY_INDEX2 | SSRMEET_WED_DAY | |
| SSRMEET_KEY_INDEX2 | SSRMEET_THU_DAY | |
| SSRMEET_KEY_INDEX2 | SSRMEET_FRI_DAY | |
| SSRMEET_KEY_INDEX2 | SSRMEET_SAT_DAY | |
| SSRMEET_KEY_INDEX2 | SSRMEET_SUN_DAY | |
| SSRMEET_KEY_INDEX2 | SSRMEET_START_DATE | |
| SSRMEET_KEY_INDEX2 | SSRMEET_END_DATE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table STVARTP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVARTP_CODE | STVARTP_CODE | VARCHAR2(4) | No | * | |
| STVARTP_DESC | STVARTP_DESC | VARCHAR2(30) | Yes | ||
| STVARTP_ROOM_REQ_IND | STVARTP_ROOM_REQ_IND | VARCHAR2(1) | Yes | ||
| STVARTP_MEAL_REQ_IND | STVARTP_MEAL_REQ_IND | VARCHAR2(1) | Yes | ||
| STVARTP_ACTIVITY_DATE | STVARTP_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVARTP | Unique | STVARTP_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:42:000 |
Table STVASCD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVASCD_CODE | STVASCD_CODE | VARCHAR2(2) | No | * | |
| STVASCD_DESC | STVASCD_DESC | VARCHAR2(30) | Yes | ||
| STVASCD_COUNT_IN_USAGE | STVASCD_COUNT_IN_USAGE | VARCHAR2(1) | No | ||
| STVASCD_ACTIVITY_DATE | STVASCD_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVASCD | Unique | STVASCD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVBLDG| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVBLDG_CODE | STVBLDG_CODE | VARCHAR2(6) | No | * | |
| STVBLDG_DESC | STVBLDG_DESC | VARCHAR2(30) | No | ||
| STVBLDG_ACTIVITY_DATE | STVBLDG_ACTIVITY_DATE | DATE | No | ||
| STVBLDG_VR_MSG_NO | STVBLDG_VR_MSG_NO | NUMBER(6,0) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVBLDG | Unique | STVBLDG_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39: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 STVHAPS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVHAPS_CODE | STVHAPS_CODE | VARCHAR2(2) | No | * | |
| STVHAPS_DESC | STVHAPS_DESC | VARCHAR2(30) | Yes | ||
| STVHAPS_INACT_IND | STVHAPS_INACT_IND | VARCHAR2(1) | Yes | ||
| STVHAPS_ACTIVITY_DATE | STVHAPS_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVHAPS | Unique | STVHAPS_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:44:000 |
Table STVMRCD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVMRCD_CODE | STVMRCD_CODE | VARCHAR2(4) | No | * | |
| STVMRCD_MONTHLY_IND | STVMRCD_MONTHLY_IND | VARCHAR2(1) | No | ||
| STVMRCD_DAILY_IND | STVMRCD_DAILY_IND | VARCHAR2(1) | No | ||
| STVMRCD_TERMLY_IND | STVMRCD_TERMLY_IND | VARCHAR2(1) | No | ||
| STVMRCD_DESC | STVMRCD_DESC | VARCHAR2(30) | No | ||
| STVMRCD_ACTIVITY_DATE | STVMRCD_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVMRCD | Unique | STVMRCD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table STVMSCD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVMSCD_CODE | STVMSCD_CODE | VARCHAR2(2) | No | * | |
| STVMSCD_DESC | STVMSCD_DESC | VARCHAR2(30) | Yes | ||
| STVMSCD_ACTIVITY_DATE | STVMSCD_ACTIVITY_DATE | DATE | No | ||
| STVMSCD_STOP_ROLL | STVMSCD_STOP_ROLL | VARCHAR2(1) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVMSCD | Unique | STVMSCD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table STVPRCD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVPRCD_CODE | STVPRCD_CODE | VARCHAR2(4) | No | * | |
| STVPRCD_MONTHLY_IND | STVPRCD_MONTHLY_IND | VARCHAR2(1) | No | ||
| STVPRCD_DAILY_IND | STVPRCD_DAILY_IND | VARCHAR2(1) | No | ||
| STVPRCD_TERMLY_IND | STVPRCD_TERMLY_IND | VARCHAR2(1) | No | ||
| STVPRCD_DESC | STVPRCD_DESC | VARCHAR2(30) | No | ||
| STVPRCD_ACTIVITY_DATE | STVPRCD_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVPRCD | Unique | STVPRCD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table STVPSCD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVPSCD_CODE | STVPSCD_CODE | VARCHAR2(2) | No | * | |
| STVPSCD_DESC | STVPSCD_DESC | VARCHAR2(30) | Yes | ||
| STVPSCD_ACTIVITY_DATE | STVPSCD_ACTIVITY_DATE | DATE | No | ||
| STVPSCD_STOP_ROLL | STVPSCD_STOP_ROLL | VARCHAR2(1) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVPSCD | Unique | STVPSCD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table STVRDEF| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVRDEF_CODE | STVRDEF_CODE | VARCHAR2(4) | No | * | |
| STVRDEF_DESC | STVRDEF_DESC | VARCHAR2(30) | Yes | ||
| STVRDEF_ACTIVITY_DATE | STVRDEF_ACTIVITY_DATE | DATE | No | ||
| STVRDEF_SCHEDULER_NUMBER | STVRDEF_SCHEDULER_NUMBER | NUMBER(2,0) | Yes | ||
| STVRDEF_AUTO_SCHEDULER_IND | STVRDEF_AUTO_SCHEDULER_IND | VARCHAR2(1) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVRDEF | Unique | STVRDEF_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39:000 |
Table STVRMST| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVRMST_CODE | STVRMST_CODE | VARCHAR2(2) | No | * | |
| STVRMST_DESC | STVRMST_DESC | VARCHAR2(30) | Yes | ||
| STVRMST_INACT_IND | STVRMST_INACT_IND | VARCHAR2(1) | Yes | ||
| STVRMST_ACTIVITY_DATE | STVRMST_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVRMST | Unique | STVRMST_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:41:000 |
Table STVRRCD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVRRCD_CODE | STVRRCD_CODE | VARCHAR2(4) | No | * | |
| STVRRCD_MONTHLY_IND | STVRRCD_MONTHLY_IND | VARCHAR2(1) | No | ||
| STVRRCD_DAILY_IND | STVRRCD_DAILY_IND | VARCHAR2(1) | No | ||
| STVRRCD_TERMLY_IND | STVRRCD_TERMLY_IND | VARCHAR2(1) | No | ||
| STVRRCD_DESC | STVRRCD_DESC | VARCHAR2(30) | No | ||
| STVRRCD_ACTIVITY_DATE | STVRRCD_ACTIVITY_DATE | DATE | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVRRCD | Unique | STVRRCD_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:39: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 STVTERM| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVTERM_CODE | STVTERM_CODE | VARCHAR2(6) | No | * | * |
| STVTERM_DESC | STVTERM_DESC | VARCHAR2(30) | No | ||
| STVTERM_START_DATE | STVTERM_START_DATE | DATE | No | ||
| STVTERM_END_DATE | STVTERM_END_DATE | DATE | No | ||
| STVTERM_FA_PROC_YR | STVTERM_FA_PROC_YR | VARCHAR2(4) | Yes | ||
| STVTERM_ACTIVITY_DATE | STVTERM_ACTIVITY_DATE | DATE | No | ||
| STVTERM_FA_TERM | STVTERM_FA_TERM | VARCHAR2(1) | Yes | ||
| STVTERM_FA_PERIOD | STVTERM_FA_PERIOD | NUMBER(2,0) | Yes | ||
| STVTERM_FA_END_PERIOD | STVTERM_FA_END_PERIOD | NUMBER(2,0) | Yes | ||
| STVTERM_ACYR_CODE | STVTERM_ACYR_CODE | VARCHAR2(4) | No | * | |
| STVTERM_HOUSING_START_DATE | STVTERM_HOUSING_START_DATE | DATE | No | ||
| STVTERM_HOUSING_END_DATE | STVTERM_HOUSING_END_DATE | DATE | No | ||
| STVTERM_SYSTEM_REQ_IND | STVTERM_SYSTEM_REQ_IND | VARCHAR2(1) | Yes | ||
| STVTERM_TRMT_CODE | STVTERM_TRMT_CODE | VARCHAR2(1) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| STVTERM_CODE | TBRACCD_TERM_CODE | TBRACCD |
| STVTERM_ACYR_CODE | STVACYR_CODE | STVACYR |
| STVTERM_TRMT_CODE | STVTRMT_CODE | STVTRMT |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVTERM | Unique | STVTERM_CODE |
| STVTERM_ACYR_INDEX | Unique | STVTERM_ACYR_CODE |
| STVTERM_ACYR_INDEX | Unique | STVTERM_CODE |
| STVTERM_AIDY_INDEX | STVTERM_FA_PROC_YR | |
| STVTERM_AIDY_INDEX | STVTERM_CODE | |
| STVTERM_END_DATE_INDEX | STVTERM_END_DATE | |
| STVTERM_START_DATE_INDEX | STVTERM_START_DATE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/07/2004 04:58:27:000 |
Table TBBDETC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| TBBDETC_DETAIL_CODE | TBBDETC_DETAIL_CODE | VARCHAR2(4) | No | * | * |
| TBBDETC_DESC | TBBDETC_DESC | VARCHAR2(30) | No | ||
| TBBDETC_TYPE_IND | TBBDETC_TYPE_IND | VARCHAR2(1) | No | ||
| TBBDETC_PRIORITY | TBBDETC_PRIORITY | VARCHAR2(3) | No | ||
| TBBDETC_LIKE_TERM_IND | TBBDETC_LIKE_TERM_IND | VARCHAR2(1) | Yes | ||
| TBBDETC_DCAT_CODE | TBBDETC_DCAT_CODE | VARCHAR2(3) | Yes | * | |
| TBBDETC_AMOUNT | TBBDETC_AMOUNT | NUMBER(7,2) | Yes | ||
| TBBDETC_TERM_CODE | TBBDETC_TERM_CODE | VARCHAR2(6) | Yes | * | |
| TBBDETC_EFFECTIVE_DATE | TBBDETC_EFFECTIVE_DATE | DATE | Yes | ||
| TBBDETC_REFUNDABLE_IND | TBBDETC_REFUNDABLE_IND | VARCHAR2(1) | Yes | ||
| TBBDETC_RECEIPT_IND | TBBDETC_RECEIPT_IND | VARCHAR2(1) | Yes | ||
| TBBDETC_REFUND_IND | TBBDETC_REFUND_IND | VARCHAR2(1) | Yes | ||
| TBBDETC_ACTIVITY_DATE | TBBDETC_ACTIVITY_DATE | DATE | No | ||
| TBBDETC_PAYT_CODE | TBBDETC_PAYT_CODE | VARCHAR2(1) | Yes | * | |
| TBBDETC_PREBILL_PRINT_IND | TBBDETC_PREBILL_PRINT_IND | VARCHAR2(1) | Yes | ||
| TBBDETC_GL_NOS_ENTERABLE | TBBDETC_GL_NOS_ENTERABLE | VARCHAR2(1) | Yes | ||
| TBBDETC_TAXT_CODE | TBBDETC_TAXT_CODE | VARCHAR2(2) | Yes | * | |
| TBBDETC_TBDC_IND | TBBDETC_TBDC_IND | VARCHAR2(1) | Yes | ||
| TBBDETC_DETAIL_CODE_IND | TBBDETC_DETAIL_CODE_IND | VARCHAR2(1) | Yes | ||
| TBBDETC_DETC_ACTIVE_IND | TBBDETC_DETC_ACTIVE_IND | VARCHAR2(1) | No | ||
| TBBDETC_DIRD_IND | TBBDETC_DIRD_IND | VARCHAR2(1) | No | ||
| TBBDETC_TIV_IND | TBBDETC_TIV_IND | VARCHAR2(1) | No | ||
| TBBDETC_INST_CHG_IND | TBBDETC_INST_CHG_IND | VARCHAR2(1) | No | ||
| TBBDETC_LIKE_AIDY_IND | TBBDETC_LIKE_AIDY_IND | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| TBBDETC_DETAIL_CODE | TBBEACT_DETAIL_CODE | TBBEACT |
| TBBDETC_DETAIL_CODE | TRRACCD_DETAIL_CODE | TRRACCD |
| TBBDETC_TERM_CODE | STVTERM_CODE | STVTERM |
| TBBDETC_PAYT_CODE | TTVPAYT_CODE | TTVPAYT |
| TBBDETC_DCAT_CODE | TTVDCAT_CODE | TTVDCAT |
| TBBDETC_TAXT_CODE | TTVTAXT_CODE | TTVTAXT |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_TBBDETC | Unique | TBBDETC_DETAIL_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:46:000 |
Link between SLRRASG and SLBRDEF| Objects list |
|---|
| schema-view : S4B70.BANINST1.ROVRASG |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRRASG and SLBRDEF | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRRASG | SLBRDEF |
Link between SLBEVNT and STVSITE| Objects list |
|---|
| forms-data-block-trigger : BANNER7_FORMS.SHACRMQ.SHBCRMY."POST-QUERY"
forms-module-trigger : BANNER7_FORMS.SHACATQ.FILLEVENT forms-module-function : BANNER7_FORMS.SHACRMY.SELECT_SLBEVNT_2 forms-module-function : BANNER7_FORMS.SLAEVNT.SELECT_SLBEVNT_5 forms-data-block-trigger : BANNER7_FORMS_10G.SHACRMQ.SHBCRMY."POST-QUERY" forms-module-function : BANNER7_FORMS_10G.SLAEVNT.SELECT_SLBEVNT_5 forms-module-trigger : BANNER7_FORMS_10G.SHACATQ.FILLEVENT forms-module-function : BANNER7_FORMS_10G.SHACRMY.SELECT_SLBEVNT_2 |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLBEVNT and STVSITE | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLBEVNT | STVSITE |
Link between SLRLMFE and SLRRASG| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVRREF |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRLMFE and SLRRASG | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRLMFE | SLRRASG |
Link between SLRRFCR and SLRRASG| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVRREF |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRRFCR and SLRRASG | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRRFCR | SLRRASG |
Link between SLRLMFE and SLRMASG| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVMREF |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRLMFE and SLRMASG | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRLMFE | SLRMASG |
Link between SLRMFCR and SLRMASG| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVMREF |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRMFCR and SLRMASG | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRMFCR | SLRMASG |
Link between SLRLMFE and SLRPASG| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVPREF |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRLMFE and SLRPASG | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRLMFE | SLRPASG |
Link between SLRPFCR and SLRPASG| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVPREF |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRPFCR and SLRPASG | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRPFCR | SLRPASG |
Link between SPRIDEN and SLBEVNT| Objects list |
|---|
| forms-module-trigger : BANNER7_FORMS.SLAEVNT.CHECK_SLBEVNT
forms-module-trigger : BANNER7_FORMS_10G.SLAEVNT.CHECK_SLBEVNT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and SLBEVNT | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | SLBEVNT |
Link between SLRLMFE and STVMRCD| Objects list |
|---|
| forms-data-block-item-trigger : BANNER7_FORMS.SLAMASG.SLRMASG.SLRMASG_MRCD_CODE.SET_INDS
forms-data-block-item-trigger : BANNER7_FORMS.SLAMASG.SLRMASG.WORKASG_BEGIN_DATE."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.SLAMASG.SLRMASG.WORKASG_END_DATE."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS_10G.SLAMASG.SLRMASG.SLRMASG_MRCD_CODE.SET_INDS forms-data-block-item-trigger : BANNER7_FORMS_10G.SLAMASG.SLRMASG.WORKASG_BEGIN_DATE."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS_10G.SLAMASG.SLRMASG.WORKASG_END_DATE."POST-CHANGE" |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRLMFE and STVMRCD | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRLMFE | STVMRCD |
Link between SLBRDEF and SLBBLDG| Objects list |
|---|
| forms-module-procedure : BANNER7_FORMS.SLARASG.GET_RATE
forms-module-procedure : BANNER7_FORMS_10G.SLARASG.GET_RATE |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLBRDEF and SLBBLDG | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLBRDEF | SLBBLDG |
Link between SLRLMFE and STVRRCD| Objects list |
|---|
| forms-data-block-item-trigger : BANNER7_FORMS.SLARASG.SLRRASG.SLRRASG_RRCD_CODE.SET_INDS
forms-data-block-item-trigger : BANNER7_FORMS_10G.SLARASG.SLRRASG.SLRRASG_RRCD_CODE.SET_INDS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRLMFE and STVRRCD | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRLMFE | STVRRCD |
Link between SLRLMFE and STVPRCD| Objects list |
|---|
| forms-data-block-item-trigger : BANNER7_FORMS.SLAPASG.SLRPASG.SLRPASG_PRCD_CODE.SET_INDS
forms-data-block-item-trigger : BANNER7_FORMS_10G.SLAPASG.SLRPASG.SLRPASG_PRCD_CODE.SET_INDS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRLMFE and STVPRCD | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRLMFE | STVPRCD |
Link between SSRMEET and SLBBLDG| Objects list |
|---|
| schema-view : S4B70.BANINST1.SSVMEET |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SSRMEET and SLBBLDG | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SSRMEET | SLBBLDG |
Link between SLBRMAP and SLRRMAT| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVRMAT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLBRMAP and SLRRMAT | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLBRMAP | SLRRMAT |
Link between SPBPERS and SLRRMAT| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVRMAT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPBPERS and SLRRMAT | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPBPERS | SLRRMAT |
Link between SPRIDEN and SLRRMAT| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVRMAT |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and SLRRMAT | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | SLRRMAT |
Link between SLRPASG and SLRRASG| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVRUSE |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRPASG and SLRRASG | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRPASG | SLRRASG |
Link between SLRRASG and SLBBLDG| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVRUSE |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRRASG and SLBBLDG | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRRASG | SLBBLDG |
Link between SLRRASG and SPBPERS| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVRUSE |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRRASG and SPBPERS | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRRASG | SPBPERS |
Link between SLRRASG and SPRIDEN| Objects list |
|---|
| schema-view : S4B70.BANINST1.SLVRUSE |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SLRRASG and SPRIDEN | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SLRRASG | SPRIDEN |
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 SLRLMFE and TBBDETC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRLMFE and TBBDETC (FK1_SLRLMFE_INV_TBBDETC_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRLMFE | SLRLMFE_DETAIL_CODE | TBBDETC_DETAIL_CODE | TBBDETC | (1,1)-(0,n) |
Link between TBBDETC and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between TBBDETC and STVTERM (FK1_TBBDETC_INV_STVTERM_CODE) | TAISMGR |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| TBBDETC | TBBDETC_TERM_CODE | STVTERM_CODE | STVTERM | (0,1)-(0,n) |
Link between GTVSYSI and SLBEVNT| Objects list |
|---|
| forms-module-trigger : BANNER7_FORMS.GEAFUNC.VALIDATE_CRN
forms-module-trigger : BANNER7_FORMS_10G.GEAFUNC.VALIDATE_CRN |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between GTVSYSI and SLBEVNT | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | GTVSYSI | SLBEVNT |
Link between SLRPSCD and STVPSCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRPSCD and STVPSCD (FK1_SLRPSCD_INV_STVPSCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRPSCD | SLRPSCD_PSCD_CODE | STVPSCD_CODE | STVPSCD | (1,1)-(0,n) |
Link between SLRRFCR and STVASCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRRFCR and STVASCD (FK1_SLRRFCR_INV_STVASCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRRFCR | SLRRFCR_ASCD_CODE | STVASCD_CODE | STVASCD | (1,1)-(0,n) |
Link between SLRRFCR and SLRASCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRRFCR and SLRASCD (FK1_SLRRFCR_INV_SLRASCD_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRRFCR | SLRRFCR_TERM_CODE | SLRASCD_TERM_CODE | SLRASCD | (1,1)-(0,n) |
| SLRRFCR | SLRRFCR_ASCD_CODE | SLRASCD_ASCD_CODE | SLRASCD | (1,1)-(0,n) |
Link between SLRASCD and STVASCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRASCD and STVASCD (FK1_SLRASCD_INV_STVASCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRASCD | SLRASCD_ASCD_CODE | STVASCD_CODE | STVASCD | (1,1)-(0,n) |
Link between SLRASCD and SLBTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRASCD and SLBTERM (FK1_SLRASCD_INV_SLBTERM_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRASCD | SLRASCD_TERM_CODE | SLBTERM_TERM_CODE | SLBTERM | (1,1)-(0,n) |
Link between SLRPSCD and SLBTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRPSCD and SLBTERM (FK1_SLRPSCD_INV_SLBTERM_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRPSCD | SLRPSCD_TERM_CODE | SLBTERM_TERM_CODE | SLBTERM | (1,1)-(0,n) |
Link between SLBRDEF and STVRMST| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBRDEF and STVRMST (FK1_SLBRDEF_INV_STVRMST_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBRDEF | SLBRDEF_RMST_CODE | STVRMST_CODE | STVRMST | (0,1)-(0,n) |
Link between SLRPFCR and SLRPSCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRPFCR and SLRPSCD (FK1_SLRPFCR_INV_SLRPSCD_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRPFCR | SLRPFCR_TERM_CODE | SLRPSCD_TERM_CODE | SLRPSCD | (1,1)-(0,n) |
| SLRPFCR | SLRPFCR_PSCD_CODE | SLRPSCD_PSCD_CODE | SLRPSCD | (1,1)-(0,n) |
Link between SLRPFCR and STVPSCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRPFCR and STVPSCD (FK1_SLRPFCR_INV_STVPSCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRPFCR | SLRPFCR_PSCD_CODE | STVPSCD_CODE | STVPSCD | (1,1)-(0,n) |
Link between SLBRMAP and STVARTP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBRMAP and STVARTP (FK1_SLBRMAP_INV_STVARTP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBRMAP | SLBRMAP_ARTP_CODE | STVARTP_CODE | STVARTP | (1,1)-(0,n) |
Link between SLBRMAP and SLRBCAT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBRMAP and SLRBCAT (FK1_SLBRMAP_INV_SLRBCAT_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBRMAP | SLBRMAP_PREFERED_BUILDING | SLRBCAT_BLDG_CODE | SLRBCAT | (0,1)-(0,n) |
| SLBRMAP | SLBRMAP_PREFERED_BCAT_CODE | SLRBCAT_CODE | SLRBCAT | (0,1)-(0,n) |
Link between SLRRASG and STVASCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRRASG and STVASCD (FK1_SLRRASG_INV_STVASCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRRASG | SLRRASG_ASCD_CODE | STVASCD_CODE | STVASCD | (1,1)-(0,n) |
Link between SLBRMAP and STVHAPS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBRMAP and STVHAPS (FK1_SLBRMAP_INV_STVHAPS_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBRMAP | SLBRMAP_HAPS_CODE | STVHAPS_CODE | STVHAPS | (0,1)-(0,n) |
Link between SLBRMAP and STVCAMP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBRMAP and STVCAMP (FK1_SLBRMAP_INV_STVCAMP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBRMAP | SLBRMAP_PREFERED_CAMP_CODE | STVCAMP_CODE | STVCAMP | (0,1)-(0,n) |
Link between SLBRMPF and STVCAMP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBRMPF and STVCAMP (FK1_SLBRMPF_INV_STVCAMP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBRMPF | SLBRMPF_CAMP_CODE | STVCAMP_CODE | STVCAMP | (0,1)-(0,n) |
Link between SLRTASG and STVCAMP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRTASG and STVCAMP (FK1_SLRTASG_INV_STVCAMP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRTASG | SLRTASG_CAMP_CODE | STVCAMP_CODE | STVCAMP | (0,1)-(0,n) |
Link between SLRRASG and STVRRCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRRASG and STVRRCD (FK1_SLRRASG_INV_STVRRCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRRASG | SLRRASG_RRCD_CODE | STVRRCD_CODE | STVRRCD | (1,1)-(0,n) |
Link between SLBBLDG and STVBLDG| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBBLDG and STVBLDG (FK1_SLBBLDG_INV_STVBLDG_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBBLDG | SLBBLDG_BLDG_CODE | STVBLDG_CODE | STVBLDG | (1,1)-(0,1) |
Link between SLBRMPF and STVBLDG| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBRMPF and STVBLDG (FK1_SLBRMPF_INV_STVBLDG_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBRMPF | SLBRMPF_BLDG_CODE | STVBLDG_CODE | STVBLDG | (0,1)-(0,n) |
Link between SLRRASG and STVBLDG| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRRASG and STVBLDG (FK1_SLRRASG_INV_STVBLDG_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRRASG | SLRRASG_BLDG_CODE | STVBLDG_CODE | STVBLDG | (1,1)-(0,n) |
Link between SLRTASG and STVBLDG| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRTASG and STVBLDG (FK1_SLRTASG_INV_STVBLDG_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRTASG | SLRTASG_BLDG_CODE | STVBLDG_CODE | STVBLDG | (0,1)-(0,n) |
Link between SLBRMAP and STVMRCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBRMAP and STVMRCD (FK1_SLBRMAP_INV_STVMRCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBRMAP | SLBRMAP_MRCD_CODE | STVMRCD_CODE | STVMRCD | (0,1)-(0,n) |
Link between SLRMASG and STVMRCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRMASG and STVMRCD (FK1_SLRMASG_INV_STVMRCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRMASG | SLRMASG_MRCD_CODE | STVMRCD_CODE | STVMRCD | (1,1)-(0,n) |
Link between SLRLMFE and SLBTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRLMFE and SLBTERM (FK1_SLRLMFE_INV_SLBTERM_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRLMFE | SLRLMFE_TERM_CODE | SLBTERM_TERM_CODE | SLBTERM | (1,1)-(0,n) |
Link between SLRPASG and STVPSCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRPASG and STVPSCD (FK1_SLRPASG_INV_STVPSCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRPASG | SLRPASG_PSCD_CODE | STVPSCD_CODE | STVPSCD | (1,1)-(0,n) |
Link between SLBRMAP and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBRMAP and STVTERM (FK1_SLBRMAP_INV_STVTERM_CODE) | SATURN |
| Refer (no action) | Link Informative Foreign Key Between SLBRMAP and STVTERM (FK2_SLBRMAP_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBRMAP | SLBRMAP_TO_TERM | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBRMAP | SLBRMAP_FROM_TERM | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLBRMPF and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBRMPF and STVTERM (FK1_SLBRMPF_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBRMPF | SLBRMPF_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLBTERM and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBTERM and STVTERM (FK1_SLBTERM_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBTERM | SLBTERM_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,1) |
Link between SLRASCD and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRASCD and STVTERM (FK1_SLRASCD_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRASCD | SLRASCD_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRCOLR and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRCOLR and STVTERM (FK1_SLRCOLR_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRCOLR | SLRCOLR_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRLMFE and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRLMFE and STVTERM (FK1_SLRLMFE_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRLMFE | SLRLMFE_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRMASG and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRMASG and STVTERM (FK1_SLRMASG_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRMASG | SLRMASG_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRMFCR and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRMFCR and STVTERM (FK1_SLRMFCR_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRMFCR | SLRMFCR_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRPASG and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRPASG and STVTERM (FK1_SLRPASG_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRPASG | SLRPASG_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRPFCR and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRPFCR and STVTERM (FK1_SLRPFCR_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRPFCR | SLRPFCR_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRPSCD and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRPSCD and STVTERM (FK1_SLRPSCD_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRPSCD | SLRPSCD_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRRASG and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRRASG and STVTERM (FK1_SLRRASG_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRRASG | SLRRASG_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRRFCR and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRRFCR and STVTERM (FK1_SLRRFCR_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRRFCR | SLRRFCR_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRRMAT and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRRMAT and STVTERM (FK1_SLRRMAT_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRRMAT | SLRRMAT_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRRMDF and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRRMDF and STVTERM (FK1_SLRRMDF_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRRMDF | SLRRMDF_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRTASG and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRTASG and STVTERM (FK1_SLRTASG_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRTASG | SLRTASG_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRDCOL and STVRDEF| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRDCOL and STVRDEF (FK1_SLRDCOL_INV_STVRDEF_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRDCOL | SLRDCOL_RDEF_CODE | STVRDEF_CODE | STVRDEF | (0,1)-(0,n) |
Link between SLRRMDF and STVRDEF| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRRMDF and STVRDEF (FK1_SLRRMDF_INV_STVRDEF_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRRMDF | SLRRMDF_RDEF_CODE | STVRDEF_CODE | STVRDEF | (1,1)-(0,n) |
Link between SLRRDEF and STVRDEF| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRRDEF and STVRDEF (FK1_SLRRDEF_INV_STVRDEF_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRRDEF | SLRRDEF_RDEF_CODE | STVRDEF_CODE | STVRDEF | (1,1)-(0,n) |
Link between SLRMASG and STVMSCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRMASG and STVMSCD (FK1_SLRMASG_INV_STVMSCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRMASG | SLRMASG_MSCD_CODE | STVMSCD_CODE | STVMSCD | (1,1)-(0,n) |
Link between SLRMFCR and STVMSCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRMFCR and STVMSCD (FK1_SLRMFCR_INV_STVMSCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRMFCR | SLRMFCR_MSCD_CODE | STVMSCD_CODE | STVMSCD | (1,1)-(0,n) |
Link between SLRPASG and STVPRCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRPASG and STVPRCD (FK1_SLRPASG_INV_STVPRCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRPASG | SLRPASG_PRCD_CODE | STVPRCD_CODE | STVPRCD | (1,1)-(0,n) |
Link between SLRMFCR and SLRMSCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRMFCR and SLRMSCD (FK1_SLRMFCR_INV_SLRMSCD_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRMFCR | SLRMFCR_TERM_CODE | SLRMSCD_TERM_CODE | SLRMSCD | (1,1)-(0,n) |
| SLRMFCR | SLRMFCR_MSCD_CODE | SLRMSCD_MSCD_CODE | SLRMSCD | (1,1)-(0,n) |
Link between SLRMSCD and SLBTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRMSCD and SLBTERM (FK1_SLRMSCD_INV_SLBTERM_KEY) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRMSCD | SLRMSCD_TERM_CODE | SLBTERM_TERM_CODE | SLBTERM | (1,1)-(0,n) |
Link between SLRMSCD and STVMSCD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRMSCD and STVMSCD (FK1_SLRMSCD_INV_STVMSCD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRMSCD | SLRMSCD_MSCD_CODE | STVMSCD_CODE | STVMSCD | (1,1)-(0,n) |
Link between SLRMSCD and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRMSCD and STVTERM (FK1_SLRMSCD_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRMSCD | SLRMSCD_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLRPREQ and STVRDEF| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRPREQ and STVRDEF (FK1_SLRPREQ_INV_STVRDEF_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRPREQ | SLRPREQ_RDEF_CODE | STVRDEF_CODE | STVRDEF | (1,1)-(0,n) |
Link between SLRPREQ and STVTERM| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLRPREQ and STVTERM (FK1_SLRPREQ_INV_STVTERM_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLRPREQ | SLRPREQ_TERM_CODE | STVTERM_CODE | STVTERM | (1,1)-(0,n) |
Link between SLBBLDG and GTVPARS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBBLDG and GTVPARS (FK1_SLBBLDG_INV_GTVPARS_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBBLDG | SLBBLDG_PARS_CODE | GTVPARS_CODE | GTVPARS | (0,1)-(0,n) |
Link between SLBRDEF and GTVPARS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBRDEF and GTVPARS (FK1_SLBRDEF_INV_GTVPARS_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBRDEF | SLBRDEF_PARS_CODE | GTVPARS_CODE | GTVPARS | (0,1)-(0,n) |
Link between GTVPARS and STVCAMP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GTVPARS and STVCAMP (FK1_GTVPARS_INV_STVCAMP_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GTVPARS | GTVPARS_CAMP_CODE | STVCAMP_CODE | STVCAMP | (0,1)-(0,n) |
Link between SLBEVNT and GTVDICD| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SLBEVNT and GTVDICD (FK1_SLBEVNT_INV_GTVDICD_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SLBEVNT | SLBEVNT_DICD_CODE | GTVDICD_CODE | GTVDICD | (0,1)-(0,n) |