Model SMRALIB Base Table
| Object Name | Object Type | Layer Name |
|---|---|---|
| SMBAGEN | TABLE | Layer(5) |
| SMBARUL | TABLE | Layer(5) |
| SMBSAGN | TABLE | Layer(5) |
| SMRACAA | TABLE | Layer(5) |
| SMRACCM | TABLE | Layer(5) |
| SMRACLV | TABLE | Layer(5) |
| SMRACMT | TABLE | Layer(5) |
| SMRAEXL | TABLE | Layer(5) |
| SMRALIB | TABLE | Layer(5) |
| SMRALVL | TABLE | Layer(5) |
| SMRAQUA | TABLE | Layer(5) |
| SMRARCM | TABLE | Layer(5) |
| SMRAREX | TABLE | Layer(5) |
| SMRARGC | TABLE | Layer(5) |
| SMRARGD | TABLE | Layer(5) |
| SMRARLT | TABLE | Layer(5) |
| SMRARLV | TABLE | Layer(5) |
| SMRARSA | TABLE | Layer(5) |
| SMRARSC | TABLE | Layer(5) |
| SMRARUL | TABLE | Layer(5) |
| SMRIEAT | TABLE | Layer(5) |
| SMRIECC | TABLE | Layer(5) |
| SMRIECO | TABLE | Layer(5) |
| SMRIECP | TABLE | Layer(5) |
| SMRIEDG | TABLE | Layer(5) |
| SMRIEDP | TABLE | Layer(5) |
| SMRIEMJ | TABLE | Layer(5) |
| SMRIEMN | TABLE | Layer(5) |
| SMRSACA | TABLE | Layer(5) |
| SMRSACE | TABLE | Layer(5) |
| SMRSACL | TABLE | Layer(5) |
| SMRSACM | TABLE | Layer(5) |
| SMRSACT | TABLE | Layer(5) |
| SMRSAGC | TABLE | Layer(5) |
| SMRSAGM | TABLE | Layer(5) |
| SMRSALV | TABLE | Layer(5) |
| SMRSARC | TABLE | Layer(5) |
| SMRSARG | TABLE | Layer(5) |
| SMRSARS | TABLE | Layer(5) |
Table SMBAGEN
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMBAGEN_AREA | SMBAGEN_AREA | VARCHAR2(10) | No | * | * |
| SMBAGEN_TERM_CODE_EFF | SMBAGEN_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMBAGEN_ACTIVITY_DATE | SMBAGEN_ACTIVITY_DATE | DATE | No | ||
| SMBAGEN_ACTIVE_IND | SMBAGEN_ACTIVE_IND | VARCHAR2(1) | No | ||
| SMBAGEN_CRSE_REUSE_IND | SMBAGEN_CRSE_REUSE_IND | VARCHAR2(1) | No | ||
| SMBAGEN_ATTR_REUSE_IND | SMBAGEN_ATTR_REUSE_IND | VARCHAR2(1) | No | ||
| SMBAGEN_CONNECTOR_OVERALL | SMBAGEN_CONNECTOR_OVERALL | VARCHAR2(1) | No | ||
| SMBAGEN_CONNECTOR_INST | SMBAGEN_CONNECTOR_INST | VARCHAR2(1) | No | ||
| SMBAGEN_CONNECTOR_I_TRAD | SMBAGEN_CONNECTOR_I_TRAD | VARCHAR2(1) | No | ||
| SMBAGEN_CONNECTOR_I_NONTRAD | SMBAGEN_CONNECTOR_I_NONTRAD | VARCHAR2(1) | No | ||
| SMBAGEN_CONNECTOR_TRANSFER | SMBAGEN_CONNECTOR_TRANSFER | VARCHAR2(1) | No | ||
| SMBAGEN_WITHIN_IND | SMBAGEN_WITHIN_IND | VARCHAR2(1) | No | ||
| SMBAGEN_GC_IND | SMBAGEN_GC_IND | VARCHAR2(1) | Yes | ||
| SMBAGEN_AREA_PRIORITY | SMBAGEN_AREA_PRIORITY | NUMBER(3,0) | Yes | ||
| SMBAGEN_YEAR_RULE | SMBAGEN_YEAR_RULE | NUMBER(2,0) | Yes | ||
| SMBAGEN_MIN_AREA_GPA | SMBAGEN_MIN_AREA_GPA | NUMBER(23,9) | Yes | ||
| SMBAGEN_GRDE_CODE_MIN | SMBAGEN_GRDE_CODE_MIN | VARCHAR2(6) | Yes | ||
| SMBAGEN_COMPL_CREDITS | SMBAGEN_COMPL_CREDITS | NUMBER(11,3) | Yes | ||
| SMBAGEN_COMPL_COURSES | SMBAGEN_COMPL_COURSES | NUMBER(3,0) | Yes | ||
| SMBAGEN_REQ_CREDITS_OVERALL | SMBAGEN_REQ_CREDITS_OVERALL | NUMBER(11,3) | Yes | ||
| SMBAGEN_REQ_COURSES_OVERALL | SMBAGEN_REQ_COURSES_OVERALL | NUMBER(3,0) | Yes | ||
| SMBAGEN_REQ_CREDITS_INST | SMBAGEN_REQ_CREDITS_INST | NUMBER(11,3) | Yes | ||
| SMBAGEN_REQ_COURSES_INST | SMBAGEN_REQ_COURSES_INST | NUMBER(3,0) | Yes | ||
| SMBAGEN_REQ_CREDITS_I_TRAD | SMBAGEN_REQ_CREDITS_I_TRAD | NUMBER(11,3) | Yes | ||
| SMBAGEN_REQ_COURSES_I_TRAD | SMBAGEN_REQ_COURSES_I_TRAD | NUMBER(3,0) | Yes | ||
| SMBAGEN_MAX_CREDITS_I_NONTRAD | SMBAGEN_MAX_CREDITS_I_NONTRAD | NUMBER(11,3) | Yes | ||
| SMBAGEN_MAX_COURSES_I_NONTRAD | SMBAGEN_MAX_COURSES_I_NONTRAD | NUMBER(3,0) | Yes | ||
| SMBAGEN_MAX_CREDITS_TRANSFER | SMBAGEN_MAX_CREDITS_TRANSFER | NUMBER(11,3) | Yes | ||
| SMBAGEN_MAX_COURSES_TRANSFER | SMBAGEN_MAX_COURSES_TRANSFER | NUMBER(3,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMBAGEN_AREA | SMRALIB_AREA | SMRALIB |
| SMBAGEN_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMBAGEN | Unique | SMBAGEN_AREA |
| PK_SMBAGEN | Unique | SMBAGEN_TERM_CODE_EFF |
| Functional Domain |
|---|
| gpa |
Table SMBARULTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMBARUL_KEY_RULE | SMBARUL_KEY_RULE | VARCHAR2(10) | No | * | |
| SMBARUL_DESC | SMBARUL_DESC | VARCHAR2(30) | No | ||
| SMBARUL_AREA | SMBARUL_AREA | VARCHAR2(10) | No | * | * |
| SMBARUL_TERM_CODE_EFF | SMBARUL_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMBARUL_CONNECTOR_COND | SMBARUL_CONNECTOR_COND | VARCHAR2(1) | No | ||
| SMBARUL_CONNECTOR_MAX_COND | SMBARUL_CONNECTOR_MAX_COND | VARCHAR2(1) | No | ||
| SMBARUL_CONNECTOR_REQ | SMBARUL_CONNECTOR_REQ | VARCHAR2(1) | No | ||
| SMBARUL_CONNECTOR_MAX | SMBARUL_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMBARUL_ACTIVITY_DATE | SMBARUL_ACTIVITY_DATE | DATE | No | ||
| SMBARUL_REQ_CRED_COND | SMBARUL_REQ_CRED_COND | NUMBER(11,3) | Yes | ||
| SMBARUL_REQ_COURSES_COND | SMBARUL_REQ_COURSES_COND | NUMBER(3,0) | Yes | ||
| SMBARUL_MAX_CRED_COND | SMBARUL_MAX_CRED_COND | NUMBER(11,3) | Yes | ||
| SMBARUL_MAX_COURSES_COND | SMBARUL_MAX_COURSES_COND | NUMBER(3,0) | Yes | ||
| SMBARUL_REQ_NUMB_COND | SMBARUL_REQ_NUMB_COND | NUMBER(3,0) | Yes | ||
| SMBARUL_REQ_CREDITS | SMBARUL_REQ_CREDITS | NUMBER(11,3) | Yes | ||
| SMBARUL_REQ_COURSES | SMBARUL_REQ_COURSES | NUMBER(3,0) | Yes | ||
| SMBARUL_MAX_CREDITS | SMBARUL_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMBARUL_MAX_COURSES | SMBARUL_MAX_COURSES | NUMBER(3,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMBARUL_AREA | SMRALIB_AREA | SMRALIB |
| SMBARUL_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMBARUL | Unique | SMBARUL_KEY_RULE |
| PK_SMBARUL | Unique | SMBARUL_AREA |
| PK_SMBARUL | Unique | SMBARUL_TERM_CODE_EFF |
Table SMBSAGNTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMBSAGN_PIDM | SMBSAGN_PIDM | NUMBER(8,0) | No | * | * |
| SMBSAGN_AREA | SMBSAGN_AREA | VARCHAR2(10) | No | * | * |
| SMBSAGN_TERM_CODE_EFF | SMBSAGN_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMBSAGN_ACTIVITY_DATE | SMBSAGN_ACTIVITY_DATE | DATE | No | ||
| SMBSAGN_ACTIVE_IND | SMBSAGN_ACTIVE_IND | VARCHAR2(1) | No | ||
| SMBSAGN_CRSE_REUSE_IND | SMBSAGN_CRSE_REUSE_IND | VARCHAR2(1) | No | ||
| SMBSAGN_ATTR_REUSE_IND | SMBSAGN_ATTR_REUSE_IND | VARCHAR2(1) | No | ||
| SMBSAGN_CONNECTOR_OVERALL | SMBSAGN_CONNECTOR_OVERALL | VARCHAR2(1) | No | ||
| SMBSAGN_CONNECTOR_INST | SMBSAGN_CONNECTOR_INST | VARCHAR2(1) | No | ||
| SMBSAGN_CONNECTOR_I_TRAD | SMBSAGN_CONNECTOR_I_TRAD | VARCHAR2(1) | No | ||
| SMBSAGN_CONNECTOR_I_NONTRAD | SMBSAGN_CONNECTOR_I_NONTRAD | VARCHAR2(1) | No | ||
| SMBSAGN_CONNECTOR_TRANSFER | SMBSAGN_CONNECTOR_TRANSFER | VARCHAR2(1) | No | ||
| SMBSAGN_WITHIN_IND | SMBSAGN_WITHIN_IND | VARCHAR2(1) | No | ||
| SMBSAGN_GC_IND | SMBSAGN_GC_IND | VARCHAR2(1) | Yes | ||
| SMBSAGN_AREA_PRIORITY | SMBSAGN_AREA_PRIORITY | NUMBER(3,0) | Yes | ||
| SMBSAGN_YEAR_RULE | SMBSAGN_YEAR_RULE | NUMBER(2,0) | Yes | ||
| SMBSAGN_MIN_AREA_GPA | SMBSAGN_MIN_AREA_GPA | NUMBER(23,9) | Yes | ||
| SMBSAGN_GRDE_CODE_MIN | SMBSAGN_GRDE_CODE_MIN | VARCHAR2(6) | Yes | ||
| SMBSAGN_COMPL_CREDITS | SMBSAGN_COMPL_CREDITS | NUMBER(11,3) | Yes | ||
| SMBSAGN_COMPL_COURSES | SMBSAGN_COMPL_COURSES | NUMBER(3,0) | Yes | ||
| SMBSAGN_REQ_CREDITS_OVERALL | SMBSAGN_REQ_CREDITS_OVERALL | NUMBER(11,3) | Yes | ||
| SMBSAGN_REQ_COURSES_OVERALL | SMBSAGN_REQ_COURSES_OVERALL | NUMBER(3,0) | Yes | ||
| SMBSAGN_REQ_CREDITS_INST | SMBSAGN_REQ_CREDITS_INST | NUMBER(11,3) | Yes | ||
| SMBSAGN_REQ_COURSES_INST | SMBSAGN_REQ_COURSES_INST | NUMBER(3,0) | Yes | ||
| SMBSAGN_REQ_CREDITS_I_TRAD | SMBSAGN_REQ_CREDITS_I_TRAD | NUMBER(11,3) | Yes | ||
| SMBSAGN_REQ_COURSES_I_TRAD | SMBSAGN_REQ_COURSES_I_TRAD | NUMBER(3,0) | Yes | ||
| SMBSAGN_MAX_CREDITS_I_NONTRAD | SMBSAGN_MAX_CREDITS_I_NONTRAD | NUMBER(11,3) | Yes | ||
| SMBSAGN_MAX_COURSES_I_NONTRAD | SMBSAGN_MAX_COURSES_I_NONTRAD | NUMBER(3,0) | Yes | ||
| SMBSAGN_MAX_CREDITS_TRANSFER | SMBSAGN_MAX_CREDITS_TRANSFER | NUMBER(11,3) | Yes | ||
| SMBSAGN_MAX_COURSES_TRANSFER | SMBSAGN_MAX_COURSES_TRANSFER | NUMBER(3,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMBSAGN_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SMBSAGN_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMBSAGN_AREA | SMRALIB_AREA | SMRALIB |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMBSAGN | Unique | SMBSAGN_PIDM |
| PK_SMBSAGN | Unique | SMBSAGN_AREA |
| PK_SMBSAGN | Unique | SMBSAGN_TERM_CODE_EFF |
| Functional Domain |
|---|
| gpa |
Table SMRACAATable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRACAA_AREA | SMRACAA_AREA | VARCHAR2(10) | No | * | * |
| SMRACAA_TERM_CODE_EFF | SMRACAA_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRACAA_ACTIVITY_DATE | SMRACAA_ACTIVITY_DATE | DATE | No | ||
| SMRACAA_TRANSFER_IND | SMRACAA_TRANSFER_IND | VARCHAR2(1) | No | ||
| SMRACAA_SEQNO | SMRACAA_SEQNO | NUMBER(8,0) | No | * | |
| SMRACAA_SPLIT_COURSE_IND | SMRACAA_SPLIT_COURSE_IND | VARCHAR2(1) | No | ||
| SMRACAA_CONNECTOR_REQ | SMRACAA_CONNECTOR_REQ | VARCHAR2(1) | No | ||
| SMRACAA_CONNECTOR_MAX | SMRACAA_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMRACAA_CONNECTOR_TRANSFER | SMRACAA_CONNECTOR_TRANSFER | VARCHAR2(1) | No | ||
| SMRACAA_CNT_IN_GPA_IND | SMRACAA_CNT_IN_GPA_IND | VARCHAR2(1) | No | ||
| SMRACAA_SET | SMRACAA_SET | VARCHAR2(3) | Yes | ||
| SMRACAA_SUBSET | SMRACAA_SUBSET | NUMBER(3,0) | Yes | ||
| SMRACAA_RULE | SMRACAA_RULE | VARCHAR2(10) | Yes | ||
| SMRACAA_SUBJ_CODE | SMRACAA_SUBJ_CODE | VARCHAR2(4) | Yes | * | |
| SMRACAA_CRSE_NUMB_LOW | SMRACAA_CRSE_NUMB_LOW | VARCHAR2(5) | Yes | ||
| SMRACAA_CRSE_NUMB_HIGH | SMRACAA_CRSE_NUMB_HIGH | VARCHAR2(5) | Yes | ||
| SMRACAA_ATTR_CODE | SMRACAA_ATTR_CODE | VARCHAR2(4) | Yes | * | |
| SMRACAA_ATTS_CODE | SMRACAA_ATTS_CODE | VARCHAR2(4) | Yes | * | |
| SMRACAA_CAMP_CODE | SMRACAA_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SMRACAA_COLL_CODE | SMRACAA_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SMRACAA_DEPT_CODE | SMRACAA_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SMRACAA_YEAR_RULE | SMRACAA_YEAR_RULE | NUMBER(2,0) | Yes | ||
| SMRACAA_TERM_CODE_FROM | SMRACAA_TERM_CODE_FROM | VARCHAR2(6) | Yes | * | |
| SMRACAA_TERM_CODE_TO | SMRACAA_TERM_CODE_TO | VARCHAR2(6) | Yes | * | |
| SMRACAA_REQ_CREDITS | SMRACAA_REQ_CREDITS | NUMBER(11,3) | Yes | ||
| SMRACAA_REQ_COURSES | SMRACAA_REQ_COURSES | NUMBER(3,0) | Yes | ||
| SMRACAA_MAX_CREDITS | SMRACAA_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMRACAA_MAX_COURSES | SMRACAA_MAX_COURSES | NUMBER(3,0) | Yes | ||
| SMRACAA_MIN_CRED_CRSE | SMRACAA_MIN_CRED_CRSE | NUMBER(7,3) | Yes | ||
| SMRACAA_MAX_CRED_CRSE | SMRACAA_MAX_CRED_CRSE | NUMBER(7,3) | Yes | ||
| SMRACAA_COMPL_CREDITS | SMRACAA_COMPL_CREDITS | NUMBER(11,3) | Yes | ||
| SMRACAA_COMPL_COURSES | SMRACAA_COMPL_COURSES | NUMBER(3,0) | Yes | ||
| SMRACAA_GRDE_CODE_MIN | SMRACAA_GRDE_CODE_MIN | VARCHAR2(6) | Yes | ||
| SMRACAA_MAX_CREDITS_TRANSFER | SMRACAA_MAX_CREDITS_TRANSFER | NUMBER(11,3) | Yes | ||
| SMRACAA_MAX_COURSES_TRANSFER | SMRACAA_MAX_COURSES_TRANSFER | NUMBER(3,0) | Yes | ||
| SMRACAA_END_FUNCTION | SMRACAA_END_FUNCTION | VARCHAR2(1) | Yes | ||
| SMRACAA_CATALOG_IND | SMRACAA_CATALOG_IND | VARCHAR2(1) | No | ||
| SMRACAA_TESC_CODE | SMRACAA_TESC_CODE | VARCHAR2(4) | Yes | * | |
| SMRACAA_MIN_VALUE | SMRACAA_MIN_VALUE | VARCHAR2(5) | Yes | ||
| SMRACAA_MAX_VALUE | SMRACAA_MAX_VALUE | VARCHAR2(5) | Yes | ||
| SMRACAA_CONCURRENCY_IND | SMRACAA_CONCURRENCY_IND | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRACAA_AREA | SMRALIB_AREA | SMRALIB |
| SMRACAA_ATTR_CODE | STVATTR_CODE | STVATTR |
| SMRACAA_ATTS_CODE | STVATTS_CODE | STVATTS |
| SMRACAA_SUBJ_CODE | STVSUBJ_CODE | STVSUBJ |
| SMRACAA_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SMRACAA_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SMRACAA_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SMRACAA_TESC_CODE | STVTESC_CODE | STVTESC |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRACAA | Unique | SMRACAA_AREA |
| PK_SMRACAA | Unique | SMRACAA_TERM_CODE_EFF |
| PK_SMRACAA | Unique | SMRACAA_SEQNO |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_AREA |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_TERM_CODE_EFF |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_SET |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_SUBSET |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_RULE |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_SUBJ_CODE |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_CRSE_NUMB_LOW |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_CRSE_NUMB_HIGH |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_ATTR_CODE |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_ATTS_CODE |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_CAMP_CODE |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_COLL_CODE |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_DEPT_CODE |
| SMRACAA_KEY_INDEX | Unique | SMRACAA_SEQNO |
| Functional Domain |
|---|
| gpa |
Table SMRACCMTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRACCM_AREA | SMRACCM_AREA | VARCHAR2(10) | No | * | |
| SMRACCM_AREA | SMRACCM_AREA | VARCHAR2(10) | No | * | |
| SMRACCM_TERM_CODE_EFF | SMRACCM_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRACCM_TERM_CODE_EFF | SMRACCM_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRACCM_SMRACAA_SEQNO | SMRACCM_SMRACAA_SEQNO | NUMBER(8,0) | No | * | |
| SMRACCM_ACTIVITY_DATE | SMRACCM_ACTIVITY_DATE | DATE | No | ||
| SMRACCM_TEXT_SEQNO | SMRACCM_TEXT_SEQNO | NUMBER(23,20) | Yes | ||
| SMRACCM_TEXT | SMRACCM_TEXT | VARCHAR2(60) | Yes | ||
| SMRACCM_PRNT_CODE | SMRACCM_PRNT_CODE | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRACCM_AREA | SMRACAA_AREA | SMRACAA |
| SMRACCM_TERM_CODE_EFF | SMRACAA_TERM_CODE_EFF | SMRACAA |
| SMRACCM_SMRACAA_SEQNO | SMRACAA_SEQNO | SMRACAA |
| SMRACCM_AREA | SMRALIB_AREA | SMRALIB |
| SMRACCM_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRACCM_PRNT_CODE | STVPRNT_CODE | STVPRNT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRACCM_KEY_INDEX | SMRACCM_AREA | |
| SMRACCM_KEY_INDEX | SMRACCM_TERM_CODE_EFF | |
| SMRACCM_KEY_INDEX | SMRACCM_SMRACAA_SEQNO | |
| SMRACCM_KEY_INDEX | SMRACCM_TEXT_SEQNO |
Table SMRACLVTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRACLV_AREA | SMRACLV_AREA | VARCHAR2(10) | No | * | |
| SMRACLV_AREA | SMRACLV_AREA | VARCHAR2(10) | No | * | |
| SMRACLV_TERM_CODE_EFF | SMRACLV_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRACLV_TERM_CODE_EFF | SMRACLV_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRACLV_SMRACAA_SEQNO | SMRACLV_SMRACAA_SEQNO | NUMBER(8,0) | No | * | |
| SMRACLV_INCL_EXCL_IND | SMRACLV_INCL_EXCL_IND | VARCHAR2(1) | No | ||
| SMRACLV_CONNECTOR_MAX | SMRACLV_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMRACLV_ACTIVITY_DATE | SMRACLV_ACTIVITY_DATE | DATE | No | ||
| SMRACLV_LEVL_CODE | SMRACLV_LEVL_CODE | VARCHAR2(2) | Yes | * | |
| SMRACLV_GRDE_CODE_MIN | SMRACLV_GRDE_CODE_MIN | VARCHAR2(6) | Yes | ||
| SMRACLV_MAX_CREDITS | SMRACLV_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMRACLV_MAX_COURSES | SMRACLV_MAX_COURSES | NUMBER(3,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRACLV_AREA | SMRACAA_AREA | SMRACAA |
| SMRACLV_TERM_CODE_EFF | SMRACAA_TERM_CODE_EFF | SMRACAA |
| SMRACLV_SMRACAA_SEQNO | SMRACAA_SEQNO | SMRACAA |
| SMRACLV_AREA | SMRALIB_AREA | SMRALIB |
| SMRACLV_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SMRACLV_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRACLV_KEY_INDEX | Unique | SMRACLV_AREA |
| SMRACLV_KEY_INDEX | Unique | SMRACLV_TERM_CODE_EFF |
| SMRACLV_KEY_INDEX | Unique | SMRACLV_SMRACAA_SEQNO |
| SMRACLV_KEY_INDEX | Unique | SMRACLV_LEVL_CODE |
Table SMRACMTTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRACMT_AREA | SMRACMT_AREA | VARCHAR2(10) | No | * | |
| SMRACMT_TERM_CODE_EFF | SMRACMT_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRACMT_ACTIVITY_DATE | SMRACMT_ACTIVITY_DATE | DATE | No | ||
| SMRACMT_TEXT_SEQNO | SMRACMT_TEXT_SEQNO | NUMBER(23,20) | Yes | ||
| SMRACMT_TEXT | SMRACMT_TEXT | VARCHAR2(60) | Yes | ||
| SMRACMT_PRNT_CODE | SMRACMT_PRNT_CODE | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRACMT_AREA | SMRALIB_AREA | SMRALIB |
| SMRACMT_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRACMT_PRNT_CODE | STVPRNT_CODE | STVPRNT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRACMT_KEY_INDEX | SMRACMT_AREA | |
| SMRACMT_KEY_INDEX | SMRACMT_TERM_CODE_EFF | |
| SMRACMT_KEY_INDEX | SMRACMT_TEXT_SEQNO |
Table SMRAEXLTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRAEXL_AREA | SMRAEXL_AREA | VARCHAR2(10) | No | * | |
| SMRAEXL_AREA | SMRAEXL_AREA | VARCHAR2(10) | No | * | |
| SMRAEXL_TERM_CODE_EFF | SMRAEXL_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRAEXL_TERM_CODE_EFF | SMRAEXL_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRAEXL_SMRACAA_SEQNO | SMRAEXL_SMRACAA_SEQNO | NUMBER(8,0) | No | * | |
| SMRAEXL_ACTIVITY_DATE | SMRAEXL_ACTIVITY_DATE | DATE | No | ||
| SMRAEXL_SUBJ_CODE | SMRAEXL_SUBJ_CODE | VARCHAR2(4) | Yes | * | |
| SMRAEXL_CRSE_NUMB_LOW | SMRAEXL_CRSE_NUMB_LOW | VARCHAR2(5) | Yes | ||
| SMRAEXL_CRSE_NUMB_HIGH | SMRAEXL_CRSE_NUMB_HIGH | VARCHAR2(5) | Yes | ||
| SMRAEXL_ATTR_CODE | SMRAEXL_ATTR_CODE | VARCHAR2(4) | Yes | * | |
| SMRAEXL_ATTS_CODE | SMRAEXL_ATTS_CODE | VARCHAR2(4) | Yes | * | |
| SMRAEXL_CAMP_CODE | SMRAEXL_CAMP_CODE | VARCHAR2(3) | Yes | ||
| SMRAEXL_COLL_CODE | SMRAEXL_COLL_CODE | VARCHAR2(2) | Yes | ||
| SMRAEXL_DEPT_CODE | SMRAEXL_DEPT_CODE | VARCHAR2(4) | Yes | ||
| SMRAEXL_TERM_CODE_FROM | SMRAEXL_TERM_CODE_FROM | VARCHAR2(6) | Yes | * | |
| SMRAEXL_TERM_CODE_TO | SMRAEXL_TERM_CODE_TO | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRAEXL_AREA | SMRACAA_AREA | SMRACAA |
| SMRAEXL_TERM_CODE_EFF | SMRACAA_TERM_CODE_EFF | SMRACAA |
| SMRAEXL_SMRACAA_SEQNO | SMRACAA_SEQNO | SMRACAA |
| SMRAEXL_AREA | SMRALIB_AREA | SMRALIB |
| SMRAEXL_ATTR_CODE | STVATTR_CODE | STVATTR |
| SMRAEXL_ATTS_CODE | STVATTS_CODE | STVATTS |
| SMRAEXL_SUBJ_CODE | STVSUBJ_CODE | STVSUBJ |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRAEXL_KEY_INDEX | Unique | SMRAEXL_AREA |
| SMRAEXL_KEY_INDEX | Unique | SMRAEXL_TERM_CODE_EFF |
| SMRAEXL_KEY_INDEX | Unique | SMRAEXL_SMRACAA_SEQNO |
| SMRAEXL_KEY_INDEX | Unique | SMRAEXL_SUBJ_CODE |
| SMRAEXL_KEY_INDEX | Unique | SMRAEXL_CRSE_NUMB_LOW |
| SMRAEXL_KEY_INDEX | Unique | SMRAEXL_CRSE_NUMB_HIGH |
| SMRAEXL_KEY_INDEX | Unique | SMRAEXL_ATTR_CODE |
| SMRAEXL_KEY_INDEX | Unique | SMRAEXL_ATTS_CODE |
| SMRAEXL_KEY_INDEX | Unique | SMRAEXL_CAMP_CODE |
| SMRAEXL_KEY_INDEX | Unique | SMRAEXL_COLL_CODE |
| SMRAEXL_KEY_INDEX | Unique | SMRAEXL_DEPT_CODE |
Table SMRALIBTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRALIB_AREA | SMRALIB_AREA | VARCHAR2(10) | No | * | |
| SMRALIB_AREA_DESC | SMRALIB_AREA_DESC | VARCHAR2(30) | No | ||
| SMRALIB_LEVL_CODE_STU | SMRALIB_LEVL_CODE_STU | VARCHAR2(2) | No | * | |
| SMRALIB_LEVL_CODE | SMRALIB_LEVL_CODE | VARCHAR2(2) | No | * | |
| SMRALIB_DYNAMIC_IND | SMRALIB_DYNAMIC_IND | VARCHAR2(1) | No | ||
| SMRALIB_PRINT_IND | SMRALIB_PRINT_IND | VARCHAR2(1) | No | ||
| SMRALIB_ACTIVITY_DATE | SMRALIB_ACTIVITY_DATE | DATE | No | ||
| SMRALIB_COMPL_USAGE_IND | SMRALIB_COMPL_USAGE_IND | VARCHAR2(1) | No | ||
| SMRALIB_PREREQ_USAGE_IND | SMRALIB_PREREQ_USAGE_IND | VARCHAR2(1) | No | ||
| SMRALIB_PRESCR_USAGE_IND | SMRALIB_PRESCR_USAGE_IND | RAW(1) | Yes |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRALIB | Unique | SMRALIB_AREA |
Table SMRALVLTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRALVL_AREA | SMRALVL_AREA | VARCHAR2(10) | No | * | |
| SMRALVL_TERM_CODE_EFF | SMRALVL_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRALVL_INCL_EXCL_IND | SMRALVL_INCL_EXCL_IND | VARCHAR2(1) | No | ||
| SMRALVL_CONNECTOR_MAX | SMRALVL_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMRALVL_ACTIVITY_DATE | SMRALVL_ACTIVITY_DATE | DATE | No | ||
| SMRALVL_LEVL_CODE | SMRALVL_LEVL_CODE | VARCHAR2(2) | Yes | * | |
| SMRALVL_GRDE_CODE_MIN | SMRALVL_GRDE_CODE_MIN | VARCHAR2(6) | Yes | ||
| SMRALVL_MAX_CREDITS | SMRALVL_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMRALVL_MAX_COURSES | SMRALVL_MAX_COURSES | NUMBER(3,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRALVL_AREA | SMRALIB_AREA | SMRALIB |
| SMRALVL_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SMRALVL_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRALVL_KEY_INDEX | Unique | SMRALVL_AREA |
| SMRALVL_KEY_INDEX | Unique | SMRALVL_TERM_CODE_EFF |
| SMRALVL_KEY_INDEX | Unique | SMRALVL_LEVL_CODE |
Table SMRAQUATable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRAQUA_AREA | SMRAQUA_AREA | VARCHAR2(10) | No | * | * |
| SMRAQUA_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRAQUA_CAMP_WC_IND | SMRAQUA_CAMP_WC_IND | VARCHAR2(1) | No | ||
| SMRAQUA_COLL_WC_IND | SMRAQUA_COLL_WC_IND | VARCHAR2(1) | No | ||
| SMRAQUA_DEGC_WC_IND | SMRAQUA_DEGC_WC_IND | VARCHAR2(1) | No | ||
| SMRAQUA_DEPT_WC_IND | SMRAQUA_DEPT_WC_IND | VARCHAR2(1) | No | ||
| SMRAQUA_MAJR_WC_IND | SMRAQUA_MAJR_WC_IND | VARCHAR2(1) | No | ||
| SMRAQUA_CONC_WC_IND | SMRAQUA_CONC_WC_IND | VARCHAR2(1) | No | ||
| SMRAQUA_MINR_WC_IND | SMRAQUA_MINR_WC_IND | VARCHAR2(1) | No | ||
| SMRAQUA_ATTS_WC_IND | SMRAQUA_ATTS_WC_IND | VARCHAR2(1) | No | ||
| SMRAQUA_ACTIVITY_DATE | SMRAQUA_ACTIVITY_DATE | DATE | No | ||
| SMRAQUA_CAMP_CODE | SMRAQUA_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SMRAQUA_COLL_CODE | SMRAQUA_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SMRAQUA_DEGC_CODE | SMRAQUA_DEGC_CODE | VARCHAR2(6) | Yes | * | |
| SMRAQUA_DEPT_CODE | SMRAQUA_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SMRAQUA_MAJR_CODE | SMRAQUA_MAJR_CODE | VARCHAR2(4) | Yes | * | |
| SMRAQUA_MAJR_CODE_CONC | SMRAQUA_MAJR_CODE_CONC | VARCHAR2(4) | Yes | * | |
| SMRAQUA_MAJR_CODE_MINR | SMRAQUA_MAJR_CODE_MINR | VARCHAR2(4) | Yes | * | |
| SMRAQUA_ATTS_CODE | SMRAQUA_ATTS_CODE | VARCHAR2(4) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRAQUA_AREA | SMRALIB_AREA | SMRALIB |
| SMRAQUA_ATTS_CODE | STVATTS_CODE | STVATTS |
| SMRAQUA_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SMRAQUA_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SMRAQUA_DEGC_CODE | STVDEGC_CODE | STVDEGC |
| SMRAQUA_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SMRAQUA_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRAQUA | Unique | SMRAQUA_AREA |
| PK_SMRAQUA | Unique | SMRAQUA_TERM_CODE_EFF |
Table SMRARCMTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRARCM_KEY_RULE | SMRARCM_KEY_RULE | VARCHAR2(10) | No | * | |
| SMRARCM_AREA | SMRARCM_AREA | VARCHAR2(10) | No | * | |
| SMRARCM_AREA | SMRARCM_AREA | VARCHAR2(10) | No | * | |
| SMRARCM_TERM_CODE_EFF | SMRARCM_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRARCM_TERM_CODE_EFF | SMRARCM_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRARCM_SMRARUL_SEQNO | SMRARCM_SMRARUL_SEQNO | NUMBER(8,0) | No | * | |
| SMRARCM_ACTIVITY_DATE | SMRARCM_ACTIVITY_DATE | DATE | No | ||
| SMRARCM_TEXT_SEQNO | SMRARCM_TEXT_SEQNO | NUMBER(23,20) | Yes | ||
| SMRARCM_TEXT | SMRARCM_TEXT | VARCHAR2(60) | Yes | ||
| SMRARCM_PRNT_CODE | SMRARCM_PRNT_CODE | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRARCM_KEY_RULE | SMRARUL_KEY_RULE | SMRARUL |
| SMRARCM_AREA | SMRARUL_AREA | SMRARUL |
| SMRARCM_TERM_CODE_EFF | SMRARUL_TERM_CODE_EFF | SMRARUL |
| SMRARCM_SMRARUL_SEQNO | SMRARUL_SEQNO | SMRARUL |
| SMRARCM_AREA | SMRALIB_AREA | SMRALIB |
| SMRARCM_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRARCM_PRNT_CODE | STVPRNT_CODE | STVPRNT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRARCM_KEY_INDEX | SMRARCM_KEY_RULE | |
| SMRARCM_KEY_INDEX | SMRARCM_AREA | |
| SMRARCM_KEY_INDEX | SMRARCM_TERM_CODE_EFF | |
| SMRARCM_KEY_INDEX | SMRARCM_SMRARUL_SEQNO | |
| SMRARCM_KEY_INDEX | SMRARCM_TEXT_SEQNO |
Table SMRAREXTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRAREX_KEY_RULE | SMRAREX_KEY_RULE | VARCHAR2(10) | No | * | |
| SMRAREX_AREA | SMRAREX_AREA | VARCHAR2(10) | No | * | |
| SMRAREX_AREA | SMRAREX_AREA | VARCHAR2(10) | No | * | |
| SMRAREX_TERM_CODE_EFF | SMRAREX_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRAREX_TERM_CODE_EFF | SMRAREX_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRAREX_SMRARUL_SEQNO | SMRAREX_SMRARUL_SEQNO | NUMBER(8,0) | No | * | |
| SMRAREX_ACTIVITY_DATE | SMRAREX_ACTIVITY_DATE | DATE | No | ||
| SMRAREX_SUBJ_CODE | SMRAREX_SUBJ_CODE | VARCHAR2(4) | Yes | * | |
| SMRAREX_CRSE_NUMB_LOW | SMRAREX_CRSE_NUMB_LOW | VARCHAR2(5) | Yes | ||
| SMRAREX_CRSE_NUMB_HIGH | SMRAREX_CRSE_NUMB_HIGH | VARCHAR2(5) | Yes | ||
| SMRAREX_ATTR_CODE | SMRAREX_ATTR_CODE | VARCHAR2(4) | Yes | * | |
| SMRAREX_ATTS_CODE | SMRAREX_ATTS_CODE | VARCHAR2(4) | Yes | * | |
| SMRAREX_TERM_CODE_FROM | SMRAREX_TERM_CODE_FROM | VARCHAR2(6) | Yes | * | |
| SMRAREX_TERM_CODE_TO | SMRAREX_TERM_CODE_TO | VARCHAR2(6) | Yes | * | |
| SMRAREX_CAMP_CODE | SMRAREX_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SMRAREX_COLL_CODE | SMRAREX_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SMRAREX_DEPT_CODE | SMRAREX_DEPT_CODE | VARCHAR2(4) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRAREX_KEY_RULE | SMRARUL_KEY_RULE | SMRARUL |
| SMRAREX_AREA | SMRARUL_AREA | SMRARUL |
| SMRAREX_TERM_CODE_EFF | SMRARUL_TERM_CODE_EFF | SMRARUL |
| SMRAREX_SMRARUL_SEQNO | SMRARUL_SEQNO | SMRARUL |
| SMRAREX_AREA | SMRALIB_AREA | SMRALIB |
| SMRAREX_ATTR_CODE | STVATTR_CODE | STVATTR |
| SMRAREX_ATTS_CODE | STVATTS_CODE | STVATTS |
| SMRAREX_SUBJ_CODE | STVSUBJ_CODE | STVSUBJ |
| SMRAREX_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SMRAREX_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SMRAREX_CAMP_CODE | STVCAMP_CODE | STVCAMP |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRAREX_KEY_INDEX | Unique | SMRAREX_KEY_RULE |
| SMRAREX_KEY_INDEX | Unique | SMRAREX_AREA |
| SMRAREX_KEY_INDEX | Unique | SMRAREX_TERM_CODE_EFF |
| SMRAREX_KEY_INDEX | Unique | SMRAREX_SMRARUL_SEQNO |
| SMRAREX_KEY_INDEX | Unique | SMRAREX_SUBJ_CODE |
| SMRAREX_KEY_INDEX | Unique | SMRAREX_CRSE_NUMB_LOW |
| SMRAREX_KEY_INDEX | Unique | SMRAREX_CRSE_NUMB_HIGH |
| SMRAREX_KEY_INDEX | Unique | SMRAREX_ATTR_CODE |
| SMRAREX_KEY_INDEX | Unique | SMRAREX_ATTS_CODE |
| SMRAREX_KEY_INDEX | Unique | SMRAREX_CAMP_CODE |
| SMRAREX_KEY_INDEX | Unique | SMRAREX_COLL_CODE |
| SMRAREX_KEY_INDEX | Unique | SMRAREX_DEPT_CODE |
Table SMRARGCTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRARGC_AREA | SMRARGC_AREA | VARCHAR2(10) | No | * | |
| SMRARGC_TERM_CODE_EFF | SMRARGC_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRARGC_GRDE_CODE | SMRARGC_GRDE_CODE | VARCHAR2(6) | No | ||
| SMRARGC_ACTIVITY_DATE | SMRARGC_ACTIVITY_DATE | DATE | No | ||
| SMRARGC_TEXT_SEQNO | SMRARGC_TEXT_SEQNO | NUMBER(23,20) | Yes | ||
| SMRARGC_TEXT | SMRARGC_TEXT | VARCHAR2(60) | Yes | ||
| SMRARGC_PRNT_CODE | SMRARGC_PRNT_CODE | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRARGC_AREA | SMRALIB_AREA | SMRALIB |
| SMRARGC_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRARGC_PRNT_CODE | STVPRNT_CODE | STVPRNT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRARGC_KEY_INDEX | SMRARGC_AREA | |
| SMRARGC_KEY_INDEX | SMRARGC_TERM_CODE_EFF | |
| SMRARGC_KEY_INDEX | SMRARGC_GRDE_CODE | |
| SMRARGC_KEY_INDEX | SMRARGC_TEXT_SEQNO |
Table SMRARGDTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRARGD_AREA | SMRARGD_AREA | VARCHAR2(10) | No | * | |
| SMRARGD_TERM_CODE_EFF | SMRARGD_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRARGD_CONNECTOR_MAX | SMRARGD_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMRARGD_ACTIVITY_DATE | SMRARGD_ACTIVITY_DATE | DATE | No | ||
| SMRARGD_GRDE_CODE | SMRARGD_GRDE_CODE | VARCHAR2(6) | Yes | ||
| SMRARGD_MAX_CREDITS | SMRARGD_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMRARGD_MAX_COURSES | SMRARGD_MAX_COURSES | NUMBER(3,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRARGD_AREA | SMRALIB_AREA | SMRALIB |
| SMRARGD_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRARGD_KEY_INDEX | Unique | SMRARGD_AREA |
| SMRARGD_KEY_INDEX | Unique | SMRARGD_TERM_CODE_EFF |
| SMRARGD_KEY_INDEX | Unique | SMRARGD_GRDE_CODE |
Table SMRARLTTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRARLT_KEY_RULE | SMRARLT_KEY_RULE | VARCHAR2(10) | No | * | |
| SMRARLT_AREA | SMRARLT_AREA | VARCHAR2(10) | No | * | |
| SMRARLT_AREA | SMRARLT_AREA | VARCHAR2(10) | No | * | |
| SMRARLT_TERM_CODE_EFF | SMRARLT_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRARLT_TERM_CODE_EFF | SMRARLT_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRARLT_ACTIVITY_DATE | SMRARLT_ACTIVITY_DATE | DATE | No | ||
| SMRARLT_TEXT_SEQNO | SMRARLT_TEXT_SEQNO | NUMBER(23,20) | Yes | ||
| SMRARLT_TEXT | SMRARLT_TEXT | VARCHAR2(60) | Yes | ||
| SMRARLT_PRNT_CODE | SMRARLT_PRNT_CODE | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRARLT_AREA | SMRALIB_AREA | SMRALIB |
| SMRARLT_KEY_RULE | SMBARUL_KEY_RULE | SMBARUL |
| SMRARLT_AREA | SMBARUL_AREA | SMBARUL |
| SMRARLT_TERM_CODE_EFF | SMBARUL_TERM_CODE_EFF | SMBARUL |
| SMRARLT_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRARLT_PRNT_CODE | STVPRNT_CODE | STVPRNT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRARLT_KEY_INDEX | SMRARLT_KEY_RULE | |
| SMRARLT_KEY_INDEX | SMRARLT_AREA | |
| SMRARLT_KEY_INDEX | SMRARLT_TERM_CODE_EFF | |
| SMRARLT_KEY_INDEX | SMRARLT_TEXT_SEQNO |
Table SMRARLVTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRARLV_KEY_RULE | SMRARLV_KEY_RULE | VARCHAR2(10) | No | * | |
| SMRARLV_AREA | SMRARLV_AREA | VARCHAR2(10) | No | * | |
| SMRARLV_AREA | SMRARLV_AREA | VARCHAR2(10) | No | * | |
| SMRARLV_TERM_CODE_EFF | SMRARLV_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRARLV_TERM_CODE_EFF | SMRARLV_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRARLV_SMRARUL_SEQNO | SMRARLV_SMRARUL_SEQNO | NUMBER(8,0) | No | * | |
| SMRARLV_INCL_EXCL_IND | SMRARLV_INCL_EXCL_IND | VARCHAR2(1) | No | ||
| SMRARLV_CONNECTOR_MAX | SMRARLV_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMRARLV_ACTIVITY_DATE | SMRARLV_ACTIVITY_DATE | DATE | No | ||
| SMRARLV_LEVL_CODE | SMRARLV_LEVL_CODE | VARCHAR2(2) | Yes | * | |
| SMRARLV_GRDE_CODE_MIN | SMRARLV_GRDE_CODE_MIN | VARCHAR2(6) | Yes | ||
| SMRARLV_MAX_CREDITS | SMRARLV_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMRARLV_MAX_COURSES | SMRARLV_MAX_COURSES | NUMBER(3,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRARLV_KEY_RULE | SMRARUL_KEY_RULE | SMRARUL |
| SMRARLV_AREA | SMRARUL_AREA | SMRARUL |
| SMRARLV_TERM_CODE_EFF | SMRARUL_TERM_CODE_EFF | SMRARUL |
| SMRARLV_SMRARUL_SEQNO | SMRARUL_SEQNO | SMRARUL |
| SMRARLV_AREA | SMRALIB_AREA | SMRALIB |
| SMRARLV_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SMRARLV_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRARLV_KEY_INDEX | Unique | SMRARLV_KEY_RULE |
| SMRARLV_KEY_INDEX | Unique | SMRARLV_AREA |
| SMRARLV_KEY_INDEX | Unique | SMRARLV_TERM_CODE_EFF |
| SMRARLV_KEY_INDEX | Unique | SMRARLV_SMRARUL_SEQNO |
| SMRARLV_KEY_INDEX | Unique | SMRARLV_LEVL_CODE |
Table SMRARSATable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRARSA_AREA | SMRARSA_AREA | VARCHAR2(10) | No | * | * |
| SMRARSA_TERM_CODE_EFF | SMRARSA_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRARSA_CONNECTOR_MAX | SMRARSA_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMRARSA_ACTIVITY_DATE | SMRARSA_ACTIVITY_DATE | DATE | No | ||
| SMRARSA_SEQNO | SMRARSA_SEQNO | NUMBER(8,0) | No | * | |
| SMRARSA_SUBJ_CODE | SMRARSA_SUBJ_CODE | VARCHAR2(4) | Yes | * | |
| SMRARSA_CRSE_NUMB_LOW | SMRARSA_CRSE_NUMB_LOW | VARCHAR2(5) | Yes | ||
| SMRARSA_CRSE_NUMB_HIGH | SMRARSA_CRSE_NUMB_HIGH | VARCHAR2(5) | Yes | ||
| SMRARSA_ATTR_CODE | SMRARSA_ATTR_CODE | VARCHAR2(4) | Yes | * | |
| SMRARSA_CAMP_CODE | SMRARSA_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SMRARSA_COLL_CODE | SMRARSA_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SMRARSA_DEPT_CODE | SMRARSA_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SMRARSA_MAX_CREDITS | SMRARSA_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMRARSA_MAX_COURSES | SMRARSA_MAX_COURSES | NUMBER(3,0) | Yes | ||
| SMRARSA_END_FUNCTION | SMRARSA_END_FUNCTION | VARCHAR2(1) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRARSA_AREA | SMRALIB_AREA | SMRALIB |
| SMRARSA_ATTR_CODE | STVATTR_CODE | STVATTR |
| SMRARSA_SUBJ_CODE | STVSUBJ_CODE | STVSUBJ |
| SMRARSA_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SMRARSA_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SMRARSA_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SMRARSA_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRARSA | Unique | SMRARSA_AREA |
| PK_SMRARSA | Unique | SMRARSA_TERM_CODE_EFF |
| PK_SMRARSA | Unique | SMRARSA_SEQNO |
| SMRARSA_KEY_INDEX2 | Unique | SMRARSA_AREA |
| SMRARSA_KEY_INDEX2 | Unique | SMRARSA_TERM_CODE_EFF |
| SMRARSA_KEY_INDEX2 | Unique | SMRARSA_SUBJ_CODE |
| SMRARSA_KEY_INDEX2 | Unique | SMRARSA_CRSE_NUMB_LOW |
| SMRARSA_KEY_INDEX2 | Unique | SMRARSA_CRSE_NUMB_HIGH |
| SMRARSA_KEY_INDEX2 | Unique | SMRARSA_ATTR_CODE |
| SMRARSA_KEY_INDEX2 | Unique | SMRARSA_CAMP_CODE |
| SMRARSA_KEY_INDEX2 | Unique | SMRARSA_COLL_CODE |
| SMRARSA_KEY_INDEX2 | Unique | SMRARSA_DEPT_CODE |
| SMRARSA_KEY_INDEX2 | Unique | SMRARSA_SEQNO |
Table SMRARSCTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRARSC_AREA | SMRARSC_AREA | VARCHAR2(10) | No | * | |
| SMRARSC_AREA | SMRARSC_AREA | VARCHAR2(10) | No | * | |
| SMRARSC_TERM_CODE_EFF | SMRARSC_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRARSC_TERM_CODE_EFF | SMRARSC_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRARSC_SMRARSA_SEQNO | SMRARSC_SMRARSA_SEQNO | NUMBER(8,0) | No | * | |
| SMRARSC_ACTIVITY_DATE | SMRARSC_ACTIVITY_DATE | DATE | No | ||
| SMRARSC_TEXT_SEQNO | SMRARSC_TEXT_SEQNO | NUMBER(23,20) | Yes | ||
| SMRARSC_TEXT | SMRARSC_TEXT | VARCHAR2(60) | Yes | ||
| SMRARSC_PRNT_CODE | SMRARSC_PRNT_CODE | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRARSC_AREA | SMRARSA_AREA | SMRARSA |
| SMRARSC_TERM_CODE_EFF | SMRARSA_TERM_CODE_EFF | SMRARSA |
| SMRARSC_SMRARSA_SEQNO | SMRARSA_SEQNO | SMRARSA |
| SMRARSC_AREA | SMRALIB_AREA | SMRALIB |
| SMRARSC_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRARSC_PRNT_CODE | STVPRNT_CODE | STVPRNT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRARSC_KEY_INDEX | SMRARSC_AREA | |
| SMRARSC_KEY_INDEX | SMRARSC_TERM_CODE_EFF | |
| SMRARSC_KEY_INDEX | SMRARSC_SMRARSA_SEQNO | |
| SMRARSC_KEY_INDEX | SMRARSC_TEXT_SEQNO |
Table SMRARULTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRARUL_KEY_RULE | SMRARUL_KEY_RULE | VARCHAR2(10) | No | * | * |
| SMRARUL_AREA | SMRARUL_AREA | VARCHAR2(10) | No | * | * |
| SMRARUL_AREA | SMRARUL_AREA | VARCHAR2(10) | No | * | * |
| SMRARUL_TERM_CODE_EFF | SMRARUL_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRARUL_TERM_CODE_EFF | SMRARUL_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRARUL_SEQNO | SMRARUL_SEQNO | NUMBER(8,0) | No | * | |
| SMRARUL_SPLIT_COURSE_IND | SMRARUL_SPLIT_COURSE_IND | VARCHAR2(1) | No | ||
| SMRARUL_ACTIVITY_DATE | SMRARUL_ACTIVITY_DATE | DATE | No | ||
| SMRARUL_TRANSFER_IND | SMRARUL_TRANSFER_IND | VARCHAR2(1) | No | ||
| SMRARUL_CONNECTOR_REQ | SMRARUL_CONNECTOR_REQ | VARCHAR2(1) | No | ||
| SMRARUL_CONNECTOR_MAX | SMRARUL_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMRARUL_CONNECTOR_TRANSFER | SMRARUL_CONNECTOR_TRANSFER | VARCHAR2(1) | No | ||
| SMRARUL_CNT_IN_GPA_IND | SMRARUL_CNT_IN_GPA_IND | VARCHAR2(1) | No | ||
| SMRARUL_SET | SMRARUL_SET | VARCHAR2(3) | Yes | ||
| SMRARUL_SUBSET | SMRARUL_SUBSET | NUMBER(3,0) | Yes | ||
| SMRARUL_RULE | SMRARUL_RULE | VARCHAR2(10) | Yes | ||
| SMRARUL_SUBJ_CODE | SMRARUL_SUBJ_CODE | VARCHAR2(4) | Yes | * | |
| SMRARUL_CRSE_NUMB_LOW | SMRARUL_CRSE_NUMB_LOW | VARCHAR2(5) | Yes | ||
| SMRARUL_CRSE_NUMB_HIGH | SMRARUL_CRSE_NUMB_HIGH | VARCHAR2(5) | Yes | ||
| SMRARUL_ATTR_CODE | SMRARUL_ATTR_CODE | VARCHAR2(4) | Yes | * | |
| SMRARUL_ATTS_CODE | SMRARUL_ATTS_CODE | VARCHAR2(4) | Yes | * | |
| SMRARUL_CAMP_CODE | SMRARUL_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SMRARUL_COLL_CODE | SMRARUL_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SMRARUL_DEPT_CODE | SMRARUL_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SMRARUL_YEAR_RULE | SMRARUL_YEAR_RULE | NUMBER(2,0) | Yes | ||
| SMRARUL_TERM_CODE_FROM | SMRARUL_TERM_CODE_FROM | VARCHAR2(6) | Yes | * | |
| SMRARUL_TERM_CODE_TO | SMRARUL_TERM_CODE_TO | VARCHAR2(6) | Yes | * | |
| SMRARUL_REQ_CREDITS | SMRARUL_REQ_CREDITS | NUMBER(11,3) | Yes | ||
| SMRARUL_REQ_COURSES | SMRARUL_REQ_COURSES | NUMBER(3,0) | Yes | ||
| SMRARUL_MAX_CREDITS | SMRARUL_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMRARUL_MAX_COURSES | SMRARUL_MAX_COURSES | NUMBER(3,0) | Yes | ||
| SMRARUL_MIN_CRED_CRSE | SMRARUL_MIN_CRED_CRSE | NUMBER(7,3) | Yes | ||
| SMRARUL_MAX_CRED_CRSE | SMRARUL_MAX_CRED_CRSE | NUMBER(7,3) | Yes | ||
| SMRARUL_COMPL_CREDITS | SMRARUL_COMPL_CREDITS | NUMBER(11,3) | Yes | ||
| SMRARUL_COMPL_COURSES | SMRARUL_COMPL_COURSES | NUMBER(3,0) | Yes | ||
| SMRARUL_GRDE_CODE_MIN | SMRARUL_GRDE_CODE_MIN | VARCHAR2(6) | Yes | ||
| SMRARUL_MAX_CREDITS_TRANSFER | SMRARUL_MAX_CREDITS_TRANSFER | NUMBER(11,3) | Yes | ||
| SMRARUL_MAX_COURSES_TRANSFER | SMRARUL_MAX_COURSES_TRANSFER | NUMBER(3,0) | Yes | ||
| SMRARUL_CATALOG_IND | SMRARUL_CATALOG_IND | VARCHAR2(1) | No | ||
| SMRARUL_TESC_CODE | SMRARUL_TESC_CODE | VARCHAR2(4) | Yes | * | |
| SMRARUL_MIN_VALUE | SMRARUL_MIN_VALUE | VARCHAR2(5) | Yes | ||
| SMRARUL_MAX_VALUE | SMRARUL_MAX_VALUE | VARCHAR2(5) | Yes | ||
| SMRARUL_CONCURRENCY_IND | SMRARUL_CONCURRENCY_IND | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRARUL_AREA | SMRALIB_AREA | SMRALIB |
| SMRARUL_ATTR_CODE | STVATTR_CODE | STVATTR |
| SMRARUL_ATTS_CODE | STVATTS_CODE | STVATTS |
| SMRARUL_SUBJ_CODE | STVSUBJ_CODE | STVSUBJ |
| SMRARUL_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SMRARUL_KEY_RULE | SMBARUL_KEY_RULE | SMBARUL |
| SMRARUL_AREA | SMBARUL_AREA | SMBARUL |
| SMRARUL_TERM_CODE_EFF | SMBARUL_TERM_CODE_EFF | SMBARUL |
| SMRARUL_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SMRARUL_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SMRARUL_TESC_CODE | STVTESC_CODE | STVTESC |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRARUL | Unique | SMRARUL_KEY_RULE |
| PK_SMRARUL | Unique | SMRARUL_AREA |
| PK_SMRARUL | Unique | SMRARUL_TERM_CODE_EFF |
| PK_SMRARUL | Unique | SMRARUL_SEQNO |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_KEY_RULE |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_AREA |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_TERM_CODE_EFF |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_SEQNO |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_SET |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_SUBSET |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_RULE |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_SUBJ_CODE |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_CRSE_NUMB_LOW |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_CRSE_NUMB_HIGH |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_ATTR_CODE |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_ATTS_CODE |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_CAMP_CODE |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_COLL_CODE |
| SMRARUL_KEY_INDEX | Unique | SMRARUL_DEPT_CODE |
| Functional Domain |
|---|
| gpa |
Table SMRIEATTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRIEAT_AREA | SMRIEAT_AREA | VARCHAR2(10) | No | * | * |
| SMRIEAT_TERM_CODE_EFF | SMRIEAT_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIEAT_TERM_CODE_EFF | SMRIEAT_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIEAT_ATTS_CODE | SMRIEAT_ATTS_CODE | VARCHAR2(4) | No | * | * |
| SMRIEAT_ACTIVITY_DATE | SMRIEAT_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRIEAT_ATTS_CODE | STVATTS_CODE | STVATTS |
| SMRIEAT_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRIEAT_AREA | SMRAQUA_AREA | SMRAQUA |
| SMRIEAT_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRIEAT | Unique | SMRIEAT_AREA |
| PK_SMRIEAT | Unique | SMRIEAT_TERM_CODE_EFF |
| PK_SMRIEAT | Unique | SMRIEAT_ATTS_CODE |
Table SMRIECCTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRIECC_AREA | SMRIECC_AREA | VARCHAR2(10) | No | * | * |
| SMRIECC_TERM_CODE_EFF | SMRIECC_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIECC_TERM_CODE_EFF | SMRIECC_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIECC_MAJR_CODE_CONC | SMRIECC_MAJR_CODE_CONC | VARCHAR2(4) | No | * | * |
| SMRIECC_ACTIVITY_DATE | SMRIECC_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRIECC_MAJR_CODE_CONC | STVMAJR_CODE | STVMAJR |
| SMRIECC_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRIECC_AREA | SMRAQUA_AREA | SMRAQUA |
| SMRIECC_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRIECC | Unique | SMRIECC_AREA |
| PK_SMRIECC | Unique | SMRIECC_TERM_CODE_EFF |
| PK_SMRIECC | Unique | SMRIECC_MAJR_CODE_CONC |
Table SMRIECOTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRIECO_AREA | SMRIECO_AREA | VARCHAR2(10) | No | * | * |
| SMRIECO_TERM_CODE_EFF | SMRIECO_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIECO_TERM_CODE_EFF | SMRIECO_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIECO_COLL_CODE | SMRIECO_COLL_CODE | VARCHAR2(2) | No | * | * |
| SMRIECO_ACTIVITY_DATE | SMRIECO_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRIECO_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SMRIECO_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRIECO_AREA | SMRAQUA_AREA | SMRAQUA |
| SMRIECO_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRIECO | Unique | SMRIECO_AREA |
| PK_SMRIECO | Unique | SMRIECO_TERM_CODE_EFF |
| PK_SMRIECO | Unique | SMRIECO_COLL_CODE |
Table SMRIECPTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRIECP_AREA | SMRIECP_AREA | VARCHAR2(10) | No | * | * |
| SMRIECP_TERM_CODE_EFF | SMRIECP_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIECP_TERM_CODE_EFF | SMRIECP_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIECP_CAMP_CODE | SMRIECP_CAMP_CODE | VARCHAR2(3) | No | * | * |
| SMRIECP_ACTIVITY_DATE | SMRIECP_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRIECP_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SMRIECP_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRIECP_AREA | SMRAQUA_AREA | SMRAQUA |
| SMRIECP_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRIECP | Unique | SMRIECP_AREA |
| PK_SMRIECP | Unique | SMRIECP_TERM_CODE_EFF |
| PK_SMRIECP | Unique | SMRIECP_CAMP_CODE |
Table SMRIEDGTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRIEDG_AREA | SMRIEDG_AREA | VARCHAR2(10) | No | * | * |
| SMRIEDG_TERM_CODE_EFF | SMRIEDG_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIEDG_TERM_CODE_EFF | SMRIEDG_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIEDG_DEGR_CODE | SMRIEDG_DEGR_CODE | VARCHAR2(6) | No | * | * |
| SMRIEDG_ACTIVITY_DATE | SMRIEDG_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRIEDG_DEGR_CODE | STVDEGC_CODE | STVDEGC |
| SMRIEDG_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRIEDG_AREA | SMRAQUA_AREA | SMRAQUA |
| SMRIEDG_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRIEDG | Unique | SMRIEDG_AREA |
| PK_SMRIEDG | Unique | SMRIEDG_TERM_CODE_EFF |
| PK_SMRIEDG | Unique | SMRIEDG_DEGR_CODE |
Table SMRIEDPTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRIEDP_AREA | SMRIEDP_AREA | VARCHAR2(10) | No | * | * |
| SMRIEDP_TERM_CODE_EFF | SMRIEDP_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIEDP_TERM_CODE_EFF | SMRIEDP_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIEDP_DEPT_CODE | SMRIEDP_DEPT_CODE | VARCHAR2(4) | No | * | * |
| SMRIEDP_ACTIVITY_DATE | SMRIEDP_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRIEDP_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SMRIEDP_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRIEDP_AREA | SMRAQUA_AREA | SMRAQUA |
| SMRIEDP_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRIEDP | Unique | SMRIEDP_AREA |
| PK_SMRIEDP | Unique | SMRIEDP_TERM_CODE_EFF |
| PK_SMRIEDP | Unique | SMRIEDP_DEPT_CODE |
Table SMRIEMJTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRIEMJ_AREA | SMRIEMJ_AREA | VARCHAR2(10) | No | * | * |
| SMRIEMJ_TERM_CODE_EFF | SMRIEMJ_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIEMJ_TERM_CODE_EFF | SMRIEMJ_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIEMJ_MAJR_CODE | SMRIEMJ_MAJR_CODE | VARCHAR2(4) | No | * | * |
| SMRIEMJ_ACTIVITY_DATE | SMRIEMJ_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRIEMJ_MAJR_CODE | STVMAJR_CODE | STVMAJR |
| SMRIEMJ_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRIEMJ_AREA | SMRAQUA_AREA | SMRAQUA |
| SMRIEMJ_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRIEMJ | Unique | SMRIEMJ_AREA |
| PK_SMRIEMJ | Unique | SMRIEMJ_TERM_CODE_EFF |
| PK_SMRIEMJ | Unique | SMRIEMJ_MAJR_CODE |
Table SMRIEMNTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRIEMN_AREA | SMRIEMN_AREA | VARCHAR2(10) | No | * | * |
| SMRIEMN_TERM_CODE_EFF | SMRIEMN_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIEMN_TERM_CODE_EFF | SMRIEMN_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRIEMN_MAJR_CODE_MINR | SMRIEMN_MAJR_CODE_MINR | VARCHAR2(4) | No | * | * |
| SMRIEMN_ACTIVITY_DATE | SMRIEMN_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRIEMN_MAJR_CODE_MINR | STVMAJR_CODE | STVMAJR |
| SMRIEMN_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRIEMN_AREA | SMRAQUA_AREA | SMRAQUA |
| SMRIEMN_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRIEMN | Unique | SMRIEMN_AREA |
| PK_SMRIEMN | Unique | SMRIEMN_TERM_CODE_EFF |
| PK_SMRIEMN | Unique | SMRIEMN_MAJR_CODE_MINR |
Table SMRSACATable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRSACA_PIDM | SMRSACA_PIDM | NUMBER(8,0) | No | * | * |
| SMRSACA_AREA | SMRSACA_AREA | VARCHAR2(10) | No | * | * |
| SMRSACA_TERM_CODE_EFF | SMRSACA_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRSACA_ACTIVITY_DATE | SMRSACA_ACTIVITY_DATE | DATE | No | ||
| SMRSACA_TRANSFER_IND | SMRSACA_TRANSFER_IND | VARCHAR2(1) | No | ||
| SMRSACA_SEQNO | SMRSACA_SEQNO | NUMBER(8,0) | No | * | |
| SMRSACA_SPLIT_COURSE_IND | SMRSACA_SPLIT_COURSE_IND | VARCHAR2(1) | No | ||
| SMRSACA_CONNECTOR_REQ | SMRSACA_CONNECTOR_REQ | VARCHAR2(1) | No | ||
| SMRSACA_CONNECTOR_MAX | SMRSACA_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMRSACA_CONNECTOR_TRANSFER | SMRSACA_CONNECTOR_TRANSFER | VARCHAR2(1) | No | ||
| SMRSACA_CNT_IN_GPA_IND | SMRSACA_CNT_IN_GPA_IND | VARCHAR2(1) | No | ||
| SMRSACA_SET | SMRSACA_SET | VARCHAR2(3) | Yes | ||
| SMRSACA_SUBSET | SMRSACA_SUBSET | NUMBER(3,0) | Yes | ||
| SMRSACA_RULE | SMRSACA_RULE | VARCHAR2(10) | Yes | ||
| SMRSACA_SUBJ_CODE | SMRSACA_SUBJ_CODE | VARCHAR2(4) | Yes | * | |
| SMRSACA_CRSE_NUMB_LOW | SMRSACA_CRSE_NUMB_LOW | VARCHAR2(5) | Yes | ||
| SMRSACA_CRSE_NUMB_HIGH | SMRSACA_CRSE_NUMB_HIGH | VARCHAR2(5) | Yes | ||
| SMRSACA_ATTR_CODE | SMRSACA_ATTR_CODE | VARCHAR2(4) | Yes | * | |
| SMRSACA_ATTS_CODE | SMRSACA_ATTS_CODE | VARCHAR2(4) | Yes | * | |
| SMRSACA_CAMP_CODE | SMRSACA_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SMRSACA_COLL_CODE | SMRSACA_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SMRSACA_DEPT_CODE | SMRSACA_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SMRSACA_YEAR_RULE | SMRSACA_YEAR_RULE | NUMBER(2,0) | Yes | ||
| SMRSACA_TERM_CODE_FROM | SMRSACA_TERM_CODE_FROM | VARCHAR2(6) | Yes | * | |
| SMRSACA_TERM_CODE_TO | SMRSACA_TERM_CODE_TO | VARCHAR2(6) | Yes | * | |
| SMRSACA_REQ_CREDITS | SMRSACA_REQ_CREDITS | NUMBER(11,3) | Yes | ||
| SMRSACA_REQ_COURSES | SMRSACA_REQ_COURSES | NUMBER(3,0) | Yes | ||
| SMRSACA_MAX_CREDITS | SMRSACA_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMRSACA_MAX_COURSES | SMRSACA_MAX_COURSES | NUMBER(3,0) | Yes | ||
| SMRSACA_MIN_CRED_CRSE | SMRSACA_MIN_CRED_CRSE | NUMBER(7,3) | Yes | ||
| SMRSACA_MAX_CRED_CRSE | SMRSACA_MAX_CRED_CRSE | NUMBER(7,3) | Yes | ||
| SMRSACA_COMPL_CREDITS | SMRSACA_COMPL_CREDITS | NUMBER(11,3) | Yes | ||
| SMRSACA_COMPL_COURSES | SMRSACA_COMPL_COURSES | NUMBER(3,0) | Yes | ||
| SMRSACA_GRDE_CODE_MIN | SMRSACA_GRDE_CODE_MIN | VARCHAR2(6) | Yes | ||
| SMRSACA_MAX_CREDITS_TRANSFER | SMRSACA_MAX_CREDITS_TRANSFER | NUMBER(11,3) | Yes | ||
| SMRSACA_MAX_COURSES_TRANSFER | SMRSACA_MAX_COURSES_TRANSFER | NUMBER(3,0) | Yes | ||
| SMRSACA_END_FUNCTION | SMRSACA_END_FUNCTION | VARCHAR2(1) | Yes | ||
| SMRSACA_CATALOG_IND | SMRSACA_CATALOG_IND | VARCHAR2(1) | No | ||
| SMRSACA_ACTN_CODE | SMRSACA_ACTN_CODE | VARCHAR2(3) | Yes | * | |
| SMRSACA_ADJ_CREDITS | SMRSACA_ADJ_CREDITS | NUMBER(11,3) | Yes | ||
| SMRSACA_ADJ_COURSES | SMRSACA_ADJ_COURSES | NUMBER(3,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRSACA_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SMRSACA_ACTN_CODE | STVACTN_CODE | STVACTN |
| SMRSACA_ATTR_CODE | STVATTR_CODE | STVATTR |
| SMRSACA_ATTS_CODE | STVATTS_CODE | STVATTS |
| SMRSACA_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SMRSACA_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SMRSACA_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SMRSACA_SUBJ_CODE | STVSUBJ_CODE | STVSUBJ |
| SMRSACA_AREA | SMRALIB_AREA | SMRALIB |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRSACA | Unique | SMRSACA_PIDM |
| PK_SMRSACA | Unique | SMRSACA_AREA |
| PK_SMRSACA | Unique | SMRSACA_TERM_CODE_EFF |
| PK_SMRSACA | Unique | SMRSACA_SEQNO |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_PIDM |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_AREA |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_TERM_CODE_EFF |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_SET |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_SUBSET |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_RULE |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_SUBJ_CODE |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_CRSE_NUMB_LOW |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_CRSE_NUMB_HIGH |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_ATTR_CODE |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_ATTS_CODE |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_CAMP_CODE |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_COLL_CODE |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_DEPT_CODE |
| SMRSACA_KEY_INDEX | Unique | SMRSACA_SEQNO |
| Functional Domain |
|---|
| gpa |
Table SMRSACETable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRSACE_PIDM | SMRSACE_PIDM | NUMBER(8,0) | No | * | |
| SMRSACE_PIDM | SMRSACE_PIDM | NUMBER(8,0) | No | * | |
| SMRSACE_AREA | SMRSACE_AREA | VARCHAR2(10) | No | * | |
| SMRSACE_TERM_CODE_EFF | SMRSACE_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSACE_TERM_CODE_EFF | SMRSACE_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSACE_SMRSACA_SEQNO | SMRSACE_SMRSACA_SEQNO | NUMBER(8,0) | No | * | |
| SMRSACE_ACTIVITY_DATE | SMRSACE_ACTIVITY_DATE | DATE | No | ||
| SMRSACE_SUBJ_CODE | SMRSACE_SUBJ_CODE | VARCHAR2(4) | Yes | * | |
| SMRSACE_CRSE_NUMB_LOW | SMRSACE_CRSE_NUMB_LOW | VARCHAR2(5) | Yes | ||
| SMRSACE_CRSE_NUMB_HIGH | SMRSACE_CRSE_NUMB_HIGH | VARCHAR2(5) | Yes | ||
| SMRSACE_ATTR_CODE | SMRSACE_ATTR_CODE | VARCHAR2(4) | Yes | * | |
| SMRSACE_ATTS_CODE | SMRSACE_ATTS_CODE | VARCHAR2(4) | Yes | * | |
| SMRSACE_CAMP_CODE | SMRSACE_CAMP_CODE | VARCHAR2(3) | Yes | ||
| SMRSACE_COLL_CODE | SMRSACE_COLL_CODE | VARCHAR2(2) | Yes | ||
| SMRSACE_DEPT_CODE | SMRSACE_DEPT_CODE | VARCHAR2(4) | Yes | ||
| SMRSACE_TERM_CODE_FROM | SMRSACE_TERM_CODE_FROM | VARCHAR2(6) | Yes | * | |
| SMRSACE_TERM_CODE_TO | SMRSACE_TERM_CODE_TO | VARCHAR2(6) | Yes | * | |
| SMRSACE_ACTN_CODE | SMRSACE_ACTN_CODE | VARCHAR2(3) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRSACE_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SMRSACE_PIDM | SMRSACA_PIDM | SMRSACA |
| SMRSACE_AREA | SMRSACA_AREA | SMRSACA |
| SMRSACE_TERM_CODE_EFF | SMRSACA_TERM_CODE_EFF | SMRSACA |
| SMRSACE_SMRSACA_SEQNO | SMRSACA_SEQNO | SMRSACA |
| SMRSACE_ACTN_CODE | STVACTN_CODE | STVACTN |
| SMRSACE_ATTR_CODE | STVATTR_CODE | STVATTR |
| SMRSACE_ATTS_CODE | STVATTS_CODE | STVATTS |
| SMRSACE_SUBJ_CODE | STVSUBJ_CODE | STVSUBJ |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRSACE_KEY_INDEX | Unique | SMRSACE_PIDM |
| SMRSACE_KEY_INDEX | Unique | SMRSACE_AREA |
| SMRSACE_KEY_INDEX | Unique | SMRSACE_TERM_CODE_EFF |
| SMRSACE_KEY_INDEX | Unique | SMRSACE_SMRSACA_SEQNO |
| SMRSACE_KEY_INDEX | Unique | SMRSACE_SUBJ_CODE |
| SMRSACE_KEY_INDEX | Unique | SMRSACE_CRSE_NUMB_LOW |
| SMRSACE_KEY_INDEX | Unique | SMRSACE_CRSE_NUMB_HIGH |
| SMRSACE_KEY_INDEX | Unique | SMRSACE_ATTR_CODE |
| SMRSACE_KEY_INDEX | Unique | SMRSACE_ATTS_CODE |
| SMRSACE_KEY_INDEX | Unique | SMRSACE_CAMP_CODE |
| SMRSACE_KEY_INDEX | Unique | SMRSACE_COLL_CODE |
| SMRSACE_KEY_INDEX | Unique | SMRSACE_DEPT_CODE |
Table SMRSACLTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRSACL_PIDM | SMRSACL_PIDM | NUMBER(8,0) | No | * | |
| SMRSACL_PIDM | SMRSACL_PIDM | NUMBER(8,0) | No | * | |
| SMRSACL_AREA | SMRSACL_AREA | VARCHAR2(10) | No | * | |
| SMRSACL_TERM_CODE_EFF | SMRSACL_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSACL_TERM_CODE_EFF | SMRSACL_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSACL_SMRSACA_SEQNO | SMRSACL_SMRSACA_SEQNO | NUMBER(8,0) | No | * | |
| SMRSACL_INCL_EXCL_IND | SMRSACL_INCL_EXCL_IND | VARCHAR2(1) | No | ||
| SMRSACL_CONNECTOR_MAX | SMRSACL_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMRSACL_ACTIVITY_DATE | SMRSACL_ACTIVITY_DATE | DATE | No | ||
| SMRSACL_LEVL_CODE | SMRSACL_LEVL_CODE | VARCHAR2(2) | Yes | * | |
| SMRSACL_GRDE_CODE_MIN | SMRSACL_GRDE_CODE_MIN | VARCHAR2(6) | Yes | ||
| SMRSACL_MAX_CREDITS | SMRSACL_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMRSACL_MAX_COURSES | SMRSACL_MAX_COURSES | NUMBER(3,0) | Yes | ||
| SMRSACL_ACTN_CODE | SMRSACL_ACTN_CODE | VARCHAR2(3) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRSACL_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SMRSACL_PIDM | SMRSACA_PIDM | SMRSACA |
| SMRSACL_AREA | SMRSACA_AREA | SMRSACA |
| SMRSACL_TERM_CODE_EFF | SMRSACA_TERM_CODE_EFF | SMRSACA |
| SMRSACL_SMRSACA_SEQNO | SMRSACA_SEQNO | SMRSACA |
| SMRSACL_ACTN_CODE | STVACTN_CODE | STVACTN |
| SMRSACL_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SMRSACL_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRSACL_KEY_INDEX | Unique | SMRSACL_PIDM |
| SMRSACL_KEY_INDEX | Unique | SMRSACL_AREA |
| SMRSACL_KEY_INDEX | Unique | SMRSACL_TERM_CODE_EFF |
| SMRSACL_KEY_INDEX | Unique | SMRSACL_SMRSACA_SEQNO |
| SMRSACL_KEY_INDEX | Unique | SMRSACL_LEVL_CODE |
Table SMRSACMTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRSACM_PIDM | SMRSACM_PIDM | NUMBER(8,0) | No | * | |
| SMRSACM_AREA | SMRSACM_AREA | VARCHAR2(10) | No | * | |
| SMRSACM_TERM_CODE_EFF | SMRSACM_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSACM_ACTIVITY_DATE | SMRSACM_ACTIVITY_DATE | DATE | No | ||
| SMRSACM_TEXT_SEQNO | SMRSACM_TEXT_SEQNO | NUMBER(23,20) | Yes | ||
| SMRSACM_TEXT | SMRSACM_TEXT | VARCHAR2(60) | Yes | ||
| SMRSACM_PRNT_CODE | SMRSACM_PRNT_CODE | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRSACM_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SMRSACM_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRSACM_PRNT_CODE | STVPRNT_CODE | STVPRNT |
| SMRSACM_AREA | SMRALIB_AREA | SMRALIB |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRSACM_KEY_INDEX | SMRSACM_PIDM | |
| SMRSACM_KEY_INDEX | SMRSACM_AREA | |
| SMRSACM_KEY_INDEX | SMRSACM_TERM_CODE_EFF | |
| SMRSACM_KEY_INDEX | SMRSACM_TEXT_SEQNO |
Table SMRSACTTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRSACT_PIDM | SMRSACT_PIDM | NUMBER(8,0) | No | * | |
| SMRSACT_PIDM | SMRSACT_PIDM | NUMBER(8,0) | No | * | |
| SMRSACT_AREA | SMRSACT_AREA | VARCHAR2(10) | No | * | |
| SMRSACT_TERM_CODE_EFF | SMRSACT_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSACT_TERM_CODE_EFF | SMRSACT_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSACT_SMRSACA_SEQNO | SMRSACT_SMRSACA_SEQNO | NUMBER(8,0) | No | * | |
| SMRSACT_ACTIVITY_DATE | SMRSACT_ACTIVITY_DATE | DATE | No | ||
| SMRSACT_TEXT_SEQNO | SMRSACT_TEXT_SEQNO | NUMBER(23,20) | Yes | ||
| SMRSACT_TEXT | SMRSACT_TEXT | VARCHAR2(60) | Yes | ||
| SMRSACT_PRNT_CODE | SMRSACT_PRNT_CODE | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRSACT_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SMRSACT_PIDM | SMRSACA_PIDM | SMRSACA |
| SMRSACT_AREA | SMRSACA_AREA | SMRSACA |
| SMRSACT_TERM_CODE_EFF | SMRSACA_TERM_CODE_EFF | SMRSACA |
| SMRSACT_SMRSACA_SEQNO | SMRSACA_SEQNO | SMRSACA |
| SMRSACT_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRSACT_PRNT_CODE | STVPRNT_CODE | STVPRNT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRSACT_KEY_INDEX | SMRSACT_PIDM | |
| SMRSACT_KEY_INDEX | SMRSACT_AREA | |
| SMRSACT_KEY_INDEX | SMRSACT_TERM_CODE_EFF | |
| SMRSACT_KEY_INDEX | SMRSACT_SMRSACA_SEQNO | |
| SMRSACT_KEY_INDEX | SMRSACT_TEXT_SEQNO |
Table SMRSAGCTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRSAGC_PIDM | SMRSAGC_PIDM | NUMBER(8,0) | No | * | |
| SMRSAGC_AREA | SMRSAGC_AREA | VARCHAR2(10) | No | * | |
| SMRSAGC_TERM_CODE_EFF | SMRSAGC_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSAGC_GRDE_CODE | SMRSAGC_GRDE_CODE | VARCHAR2(6) | No | ||
| SMRSAGC_ACTIVITY_DATE | SMRSAGC_ACTIVITY_DATE | DATE | No | ||
| SMRSAGC_TEXT_SEQNO | SMRSAGC_TEXT_SEQNO | NUMBER(23,20) | Yes | ||
| SMRSAGC_TEXT | SMRSAGC_TEXT | VARCHAR2(60) | Yes | ||
| SMRSAGC_PRNT_CODE | SMRSAGC_PRNT_CODE | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRSAGC_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SMRSAGC_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRSAGC_PRNT_CODE | STVPRNT_CODE | STVPRNT |
| SMRSAGC_AREA | SMRALIB_AREA | SMRALIB |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRSAGC_KEY_INDEX | SMRSAGC_PIDM | |
| SMRSAGC_KEY_INDEX | SMRSAGC_AREA | |
| SMRSAGC_KEY_INDEX | SMRSAGC_TERM_CODE_EFF | |
| SMRSAGC_KEY_INDEX | SMRSAGC_GRDE_CODE | |
| SMRSAGC_KEY_INDEX | SMRSAGC_TEXT_SEQNO |
Table SMRSAGMTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRSAGM_PIDM | SMRSAGM_PIDM | NUMBER(8,0) | No | * | |
| SMRSAGM_AREA | SMRSAGM_AREA | VARCHAR2(10) | No | * | |
| SMRSAGM_TERM_CODE_EFF | SMRSAGM_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSAGM_ACTIVITY_DATE | SMRSAGM_ACTIVITY_DATE | DATE | No | ||
| SMRSAGM_CRSE_REUSE_IND | SMRSAGM_CRSE_REUSE_IND | VARCHAR2(1) | No | ||
| SMRSAGM_ATTR_REUSE_IND | SMRSAGM_ATTR_REUSE_IND | VARCHAR2(1) | No | ||
| SMRSAGM_GROUP | SMRSAGM_GROUP | VARCHAR2(10) | Yes | ||
| SMRSAGM_SET | SMRSAGM_SET | VARCHAR2(3) | Yes | ||
| SMRSAGM_SUBSET | SMRSAGM_SUBSET | NUMBER(3,0) | Yes | ||
| SMRSAGM_RULE | SMRSAGM_RULE | VARCHAR2(10) | Yes | ||
| SMRSAGM_YEAR_RULE | SMRSAGM_YEAR_RULE | NUMBER(2,0) | Yes | ||
| SMRSAGM_WITHIN_IND | SMRSAGM_WITHIN_IND | VARCHAR2(1) | No | ||
| SMRSAGM_ACTN_CODE | SMRSAGM_ACTN_CODE | VARCHAR2(3) | Yes | * | |
| SMRSAGM_ADJ_CREDITS | SMRSAGM_ADJ_CREDITS | NUMBER(11,3) | Yes | ||
| SMRSAGM_ADJ_COURSES | SMRSAGM_ADJ_COURSES | NUMBER(3,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRSAGM_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SMRSAGM_ACTN_CODE | STVACTN_CODE | STVACTN |
| SMRSAGM_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRSAGM_AREA | SMRALIB_AREA | SMRALIB |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRSAGM_KEY_INDEX | Unique | SMRSAGM_PIDM |
| SMRSAGM_KEY_INDEX | Unique | SMRSAGM_AREA |
| SMRSAGM_KEY_INDEX | Unique | SMRSAGM_TERM_CODE_EFF |
| SMRSAGM_KEY_INDEX | Unique | SMRSAGM_SET |
| SMRSAGM_KEY_INDEX | Unique | SMRSAGM_SUBSET |
| SMRSAGM_KEY_INDEX | Unique | SMRSAGM_RULE |
| SMRSAGM_KEY_INDEX | Unique | SMRSAGM_GROUP |
Table SMRSALVTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRSALV_PIDM | SMRSALV_PIDM | NUMBER(8,0) | No | * | |
| SMRSALV_AREA | SMRSALV_AREA | VARCHAR2(10) | No | * | |
| SMRSALV_TERM_CODE_EFF | SMRSALV_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSALV_INCL_EXCL_IND | SMRSALV_INCL_EXCL_IND | VARCHAR2(1) | No | ||
| SMRSALV_CONNECTOR_MAX | SMRSALV_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMRSALV_ACTIVITY_DATE | SMRSALV_ACTIVITY_DATE | DATE | No | ||
| SMRSALV_LEVL_CODE | SMRSALV_LEVL_CODE | VARCHAR2(2) | Yes | * | |
| SMRSALV_GRDE_CODE_MIN | SMRSALV_GRDE_CODE_MIN | VARCHAR2(6) | Yes | ||
| SMRSALV_MAX_CREDITS | SMRSALV_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMRSALV_MAX_COURSES | SMRSALV_MAX_COURSES | NUMBER(3,0) | Yes | ||
| SMRSALV_ACTN_CODE | SMRSALV_ACTN_CODE | VARCHAR2(3) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRSALV_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SMRSALV_ACTN_CODE | STVACTN_CODE | STVACTN |
| SMRSALV_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SMRSALV_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRSALV_AREA | SMRALIB_AREA | SMRALIB |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRSALV_KEY_INDEX | Unique | SMRSALV_PIDM |
| SMRSALV_KEY_INDEX | Unique | SMRSALV_AREA |
| SMRSALV_KEY_INDEX | Unique | SMRSALV_TERM_CODE_EFF |
| SMRSALV_KEY_INDEX | Unique | SMRSALV_LEVL_CODE |
Table SMRSARCTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRSARC_PIDM | SMRSARC_PIDM | NUMBER(8,0) | No | * | |
| SMRSARC_PIDM | SMRSARC_PIDM | NUMBER(8,0) | No | * | |
| SMRSARC_AREA | SMRSARC_AREA | VARCHAR2(10) | No | * | |
| SMRSARC_TERM_CODE_EFF | SMRSARC_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSARC_TERM_CODE_EFF | SMRSARC_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSARC_SMRSARS_SEQNO | SMRSARC_SMRSARS_SEQNO | NUMBER(8,0) | No | * | |
| SMRSARC_ACTIVITY_DATE | SMRSARC_ACTIVITY_DATE | DATE | No | ||
| SMRSARC_TEXT_SEQNO | SMRSARC_TEXT_SEQNO | NUMBER(23,20) | Yes | ||
| SMRSARC_TEXT | SMRSARC_TEXT | VARCHAR2(60) | Yes | ||
| SMRSARC_PRNT_CODE | SMRSARC_PRNT_CODE | VARCHAR2(6) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRSARC_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SMRSARC_PIDM | SMRSARS_PIDM | SMRSARS |
| SMRSARC_AREA | SMRSARS_AREA | SMRSARS |
| SMRSARC_TERM_CODE_EFF | SMRSARS_TERM_CODE_EFF | SMRSARS |
| SMRSARC_SMRSARS_SEQNO | SMRSARS_SEQNO | SMRSARS |
| SMRSARC_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRSARC_PRNT_CODE | STVPRNT_CODE | STVPRNT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRSARC_KEY_INDEX | SMRSARC_PIDM | |
| SMRSARC_KEY_INDEX | SMRSARC_AREA | |
| SMRSARC_KEY_INDEX | SMRSARC_TERM_CODE_EFF | |
| SMRSARC_KEY_INDEX | SMRSARC_SMRSARS_SEQNO | |
| SMRSARC_KEY_INDEX | SMRSARC_TEXT_SEQNO |
Table SMRSARGTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRSARG_PIDM | SMRSARG_PIDM | NUMBER(8,0) | No | * | |
| SMRSARG_AREA | SMRSARG_AREA | VARCHAR2(10) | No | * | |
| SMRSARG_TERM_CODE_EFF | SMRSARG_TERM_CODE_EFF | VARCHAR2(6) | No | * | |
| SMRSARG_CONNECTOR_MAX | SMRSARG_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMRSARG_ACTIVITY_DATE | SMRSARG_ACTIVITY_DATE | DATE | No | ||
| SMRSARG_GRDE_CODE | SMRSARG_GRDE_CODE | VARCHAR2(6) | Yes | ||
| SMRSARG_MAX_CREDITS | SMRSARG_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMRSARG_MAX_COURSES | SMRSARG_MAX_COURSES | NUMBER(3,0) | Yes | ||
| SMRSARG_ACTN_CODE | SMRSARG_ACTN_CODE | VARCHAR2(3) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRSARG_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SMRSARG_ACTN_CODE | STVACTN_CODE | STVACTN |
| SMRSARG_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRSARG_AREA | SMRALIB_AREA | SMRALIB |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SMRSARG_KEY_INDEX | Unique | SMRSARG_PIDM |
| SMRSARG_KEY_INDEX | Unique | SMRSARG_AREA |
| SMRSARG_KEY_INDEX | Unique | SMRSARG_TERM_CODE_EFF |
| SMRSARG_KEY_INDEX | Unique | SMRSARG_GRDE_CODE |
Table SMRSARSTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SMRSARS_PIDM | SMRSARS_PIDM | NUMBER(8,0) | No | * | * |
| SMRSARS_AREA | SMRSARS_AREA | VARCHAR2(10) | No | * | * |
| SMRSARS_TERM_CODE_EFF | SMRSARS_TERM_CODE_EFF | VARCHAR2(6) | No | * | * |
| SMRSARS_CONNECTOR_MAX | SMRSARS_CONNECTOR_MAX | VARCHAR2(1) | No | ||
| SMRSARS_ACTIVITY_DATE | SMRSARS_ACTIVITY_DATE | DATE | No | ||
| SMRSARS_SEQNO | SMRSARS_SEQNO | NUMBER(8,0) | No | * | |
| SMRSARS_SUBJ_CODE | SMRSARS_SUBJ_CODE | VARCHAR2(4) | Yes | * | |
| SMRSARS_CRSE_NUMB_LOW | SMRSARS_CRSE_NUMB_LOW | VARCHAR2(5) | Yes | ||
| SMRSARS_CRSE_NUMB_HIGH | SMRSARS_CRSE_NUMB_HIGH | VARCHAR2(5) | Yes | ||
| SMRSARS_ATTR_CODE | SMRSARS_ATTR_CODE | VARCHAR2(4) | Yes | * | |
| SMRSARS_CAMP_CODE | SMRSARS_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SMRSARS_COLL_CODE | SMRSARS_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SMRSARS_DEPT_CODE | SMRSARS_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SMRSARS_MAX_CREDITS | SMRSARS_MAX_CREDITS | NUMBER(11,3) | Yes | ||
| SMRSARS_MAX_COURSES | SMRSARS_MAX_COURSES | NUMBER(3,0) | Yes | ||
| SMRSARS_END_FUNCTION | SMRSARS_END_FUNCTION | VARCHAR2(1) | Yes | ||
| SMRSARS_ACTN_CODE | SMRSARS_ACTN_CODE | VARCHAR2(3) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SMRSARS_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SMRSARS_ACTN_CODE | STVACTN_CODE | STVACTN |
| SMRSARS_ATTR_CODE | STVATTR_CODE | STVATTR |
| SMRSARS_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SMRSARS_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SMRSARS_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SMRSARS_SUBJ_CODE | STVSUBJ_CODE | STVSUBJ |
| SMRSARS_TERM_CODE_EFF | STVTERM_CODE | STVTERM |
| SMRSARS_AREA | SMRALIB_AREA | SMRALIB |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SMRSARS | Unique | SMRSARS_PIDM |
| PK_SMRSARS | Unique | SMRSARS_AREA |
| PK_SMRSARS | Unique | SMRSARS_TERM_CODE_EFF |
| PK_SMRSARS | Unique | SMRSARS_SEQNO |
| SMRSARS_KEY_INDEX2 | Unique | SMRSARS_PIDM |
| SMRSARS_KEY_INDEX2 | Unique | SMRSARS_AREA |
| SMRSARS_KEY_INDEX2 | Unique | SMRSARS_TERM_CODE_EFF |
| SMRSARS_KEY_INDEX2 | Unique | SMRSARS_SUBJ_CODE |
| SMRSARS_KEY_INDEX2 | Unique | SMRSARS_CRSE_NUMB_LOW |
| SMRSARS_KEY_INDEX2 | Unique | SMRSARS_CRSE_NUMB_HIGH |
| SMRSARS_KEY_INDEX2 | Unique | SMRSARS_ATTR_CODE |
| SMRSARS_KEY_INDEX2 | Unique | SMRSARS_CAMP_CODE |
| SMRSARS_KEY_INDEX2 | Unique | SMRSARS_COLL_CODE |
| SMRSARS_KEY_INDEX2 | Unique | SMRSARS_DEPT_CODE |
| SMRSARS_KEY_INDEX2 | Unique | SMRSARS_SEQNO |
Link between SMRIEAT and SMRAQUA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRIEAT and SMRAQUA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRIEAT | SMRIEAT_AREA | SMRAQUA_AREA | SMRAQUA | (1,1)-(0,n) |
| SMRIEAT | SMRIEAT_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA | (1,1)-(0,n) |
Link between SMRIECC and SMRAQUA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRIECC and SMRAQUA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRIECC | SMRIECC_AREA | SMRAQUA_AREA | SMRAQUA | (1,1)-(0,n) |
| SMRIECC | SMRIECC_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA | (1,1)-(0,n) |
Link between SMRIECO and SMRAQUA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRIECO and SMRAQUA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRIECO | SMRIECO_AREA | SMRAQUA_AREA | SMRAQUA | (1,1)-(0,n) |
| SMRIECO | SMRIECO_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA | (1,1)-(0,n) |
Link between SMRIECP and SMRAQUA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRIECP and SMRAQUA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRIECP | SMRIECP_AREA | SMRAQUA_AREA | SMRAQUA | (1,1)-(0,n) |
| SMRIECP | SMRIECP_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA | (1,1)-(0,n) |
Link between SMRIEDG and SMRAQUA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRIEDG and SMRAQUA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRIEDG | SMRIEDG_AREA | SMRAQUA_AREA | SMRAQUA | (1,1)-(0,n) |
| SMRIEDG | SMRIEDG_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA | (1,1)-(0,n) |
Link between SMRIEMJ and SMRAQUA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRIEMJ and SMRAQUA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRIEMJ | SMRIEMJ_AREA | SMRAQUA_AREA | SMRAQUA | (1,1)-(0,n) |
| SMRIEMJ | SMRIEMJ_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA | (1,1)-(0,n) |
Link between SMRIEMN and SMRAQUA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRIEMN and SMRAQUA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRIEMN | SMRIEMN_AREA | SMRAQUA_AREA | SMRAQUA | (1,1)-(0,n) |
| SMRIEMN | SMRIEMN_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA | (1,1)-(0,n) |
Link between SMRIEDP and SMRAQUA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRIEDP and SMRAQUA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRIEDP | SMRIEDP_AREA | SMRAQUA_AREA | SMRAQUA | (1,1)-(0,n) |
| SMRIEDP | SMRIEDP_TERM_CODE_EFF | SMRAQUA_TERM_CODE_EFF | SMRAQUA | (1,1)-(0,n) |
Link between SMRAQUA and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRAQUA and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRAQUA | SMRAQUA_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRACCM and SMRACAA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRACCM and SMRACAA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRACCM | SMRACCM_AREA | SMRACAA_AREA | SMRACAA | (1,1)-(0,n) |
| SMRACCM | SMRACCM_TERM_CODE_EFF | SMRACAA_TERM_CODE_EFF | SMRACAA | (1,1)-(0,n) |
| SMRACCM | SMRACCM_SMRACAA_SEQNO | SMRACAA_SEQNO | SMRACAA | (1,1)-(0,n) |
Link between SMRACLV and SMRACAA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRACLV and SMRACAA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRACLV | SMRACLV_AREA | SMRACAA_AREA | SMRACAA | (1,1)-(0,n) |
| SMRACLV | SMRACLV_TERM_CODE_EFF | SMRACAA_TERM_CODE_EFF | SMRACAA | (1,1)-(0,n) |
| SMRACLV | SMRACLV_SMRACAA_SEQNO | SMRACAA_SEQNO | SMRACAA | (1,1)-(0,n) |
Link between SMRARSC and SMRARSA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARSC and SMRARSA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARSC | SMRARSC_AREA | SMRARSA_AREA | SMRARSA | (1,1)-(0,n) |
| SMRARSC | SMRARSC_TERM_CODE_EFF | SMRARSA_TERM_CODE_EFF | SMRARSA | (1,1)-(0,n) |
| SMRARSC | SMRARSC_SMRARSA_SEQNO | SMRARSA_SEQNO | SMRARSA | (1,1)-(0,n) |
Link between SMRARCM and SMRARUL| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARCM and SMRARUL | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARCM | SMRARCM_KEY_RULE | SMRARUL_KEY_RULE | SMRARUL | (1,1)-(0,n) |
| SMRARCM | SMRARCM_AREA | SMRARUL_AREA | SMRARUL | (1,1)-(0,n) |
| SMRARCM | SMRARCM_TERM_CODE_EFF | SMRARUL_TERM_CODE_EFF | SMRARUL | (1,1)-(0,n) |
| SMRARCM | SMRARCM_SMRARUL_SEQNO | SMRARUL_SEQNO | SMRARUL | (1,1)-(0,n) |
Link between SMRAREX and SMRARUL| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRAREX and SMRARUL | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRAREX | SMRAREX_KEY_RULE | SMRARUL_KEY_RULE | SMRARUL | (1,1)-(0,n) |
| SMRAREX | SMRAREX_AREA | SMRARUL_AREA | SMRARUL | (1,1)-(0,n) |
| SMRAREX | SMRAREX_TERM_CODE_EFF | SMRARUL_TERM_CODE_EFF | SMRARUL | (1,1)-(0,n) |
| SMRAREX | SMRAREX_SMRARUL_SEQNO | SMRARUL_SEQNO | SMRARUL | (1,1)-(0,n) |
Link between SMRARLV and SMRARUL| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARLV and SMRARUL | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARLV | SMRARLV_KEY_RULE | SMRARUL_KEY_RULE | SMRARUL | (1,1)-(0,n) |
| SMRARLV | SMRARLV_AREA | SMRARUL_AREA | SMRARUL | (1,1)-(0,n) |
| SMRARLV | SMRARLV_TERM_CODE_EFF | SMRARUL_TERM_CODE_EFF | SMRARUL | (1,1)-(0,n) |
| SMRARLV | SMRARLV_SMRARUL_SEQNO | SMRARUL_SEQNO | SMRARUL | (1,1)-(0,n) |
Link between SMRARGC and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARGC and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARGC | SMRARGC_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMBAGEN and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMBAGEN and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMBAGEN | SMBAGEN_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRACAA and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRACAA and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRACAA | SMRACAA_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRACCM and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRACCM and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRACCM | SMRACCM_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRACLV and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRACLV and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRACLV | SMRACLV_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRACMT and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRACMT and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRACMT | SMRACMT_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRARCM and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARCM and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARCM | SMRARCM_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRAREX and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRAREX and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRAREX | SMRAREX_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRARGD and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARGD and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARGD | SMRARGD_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRARLT and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARLT and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARLT | SMRARLT_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRARLV and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARLV and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARLV | SMRARLV_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRARSA and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARSA and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARSA | SMRARSA_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRARSC and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARSC and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARSC | SMRARSC_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRARUL and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARUL and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARUL | SMRARUL_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRALVL and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRALVL and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRALVL | SMRALVL_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRSALV and SMRALIB| Objects list |
|---|
| forms-module-record-group : FORMS_BANNER.SOQOLIB.ADJ_AREA_RG |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SMRSALV and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRSALV | SMRSALV_AREA | SMRALIB_AREA | SMRALIB | (0,1)-(0,1) |
Link between SMRSARS and SMRALIB| Objects list |
|---|
| forms-module-record-group : FORMS_BANNER.SOQOLIB.ADJ_AREA_RG |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SMRSARS and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRSARS | SMRSARS_AREA | SMRALIB_AREA | SMRALIB | (0,1)-(0,1) |
Link between SMRSACA and SMRALIB| Objects list |
|---|
| forms-module-record-group : FORMS_BANNER.SOQOLIB.ADJ_AREA_RG |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SMRSACA and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRSACA | SMRSACA_AREA | SMRALIB_AREA | SMRALIB | (0,1)-(0,1) |
Link between SMBSAGN and SMRALIB| Objects list |
|---|
| forms-module-record-group : FORMS_BANNER.SOQOLIB.ADJ_AREA_RG |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SMBSAGN and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMBSAGN | SMBSAGN_AREA | SMRALIB_AREA | SMRALIB | (0,1)-(0,1) |
Link between SMRSAGM and SMRALIB| Objects list |
|---|
| forms-module-record-group : FORMS_BANNER.SOQOLIB.ADJ_AREA_RG |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SMRSAGM and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRSAGM | SMRSAGM_AREA | SMRALIB_AREA | SMRALIB | (0,1)-(0,1) |
Link between SMRSARG and SMRALIB| Objects list |
|---|
| forms-module-record-group : FORMS_BANNER.SOQOLIB.ADJ_AREA_RG |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SMRSARG and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRSARG | SMRSARG_AREA | SMRALIB_AREA | SMRALIB | (0,1)-(0,1) |
Link between SMRSAGC and SMRALIB| Objects list |
|---|
| forms-module-record-group : FORMS_BANNER.SOQOLIB.ADJ_AREA_RG |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SMRSAGC and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRSAGC | SMRSAGC_AREA | SMRALIB_AREA | SMRALIB | (0,1)-(0,1) |
Link between SMRSACM and SMRALIB| Objects list |
|---|
| forms-module-record-group : FORMS_BANNER.SOQOLIB.ADJ_AREA_RG |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SMRSACM and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRSACM | SMRSACM_AREA | SMRALIB_AREA | SMRALIB | (0,1)-(0,1) |
Link between SMRAEXL and SMRACAA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRAEXL and SMRACAA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRAEXL | SMRAEXL_AREA | SMRACAA_AREA | SMRACAA | (1,1)-(0,n) |
| SMRAEXL | SMRAEXL_TERM_CODE_EFF | SMRACAA_TERM_CODE_EFF | SMRACAA | (1,1)-(0,n) |
| SMRAEXL | SMRAEXL_SMRACAA_SEQNO | SMRACAA_SEQNO | SMRACAA | (1,1)-(0,n) |
Link between SMRAEXL and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRAEXL and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRAEXL | SMRAEXL_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRARLT and SMBARUL| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARLT and SMBARUL | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARLT | SMRARLT_KEY_RULE | SMBARUL_KEY_RULE | SMBARUL | (1,1)-(0,n) |
| SMRARLT | SMRARLT_AREA | SMBARUL_AREA | SMBARUL | (1,1)-(0,n) |
| SMRARLT | SMRARLT_TERM_CODE_EFF | SMBARUL_TERM_CODE_EFF | SMBARUL | (1,1)-(0,n) |
Link between SMRARUL and SMBARUL| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRARUL and SMBARUL | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRARUL | SMRARUL_KEY_RULE | SMBARUL_KEY_RULE | SMBARUL | (1,1)-(0,n) |
| SMRARUL | SMRARUL_AREA | SMBARUL_AREA | SMBARUL | (1,1)-(0,n) |
| SMRARUL | SMRARUL_TERM_CODE_EFF | SMBARUL_TERM_CODE_EFF | SMBARUL | (1,1)-(0,n) |
Link between SMBARUL and SMRALIB| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMBARUL and SMRALIB | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMBARUL | SMBARUL_AREA | SMRALIB_AREA | SMRALIB | (1,1)-(0,n) |
Link between SMRSACE and SMRSACA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRSACE and SMRSACA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRSACE | SMRSACE_PIDM | SMRSACA_PIDM | SMRSACA | (1,1)-(0,n) |
| SMRSACE | SMRSACE_AREA | SMRSACA_AREA | SMRSACA | (1,1)-(0,n) |
| SMRSACE | SMRSACE_TERM_CODE_EFF | SMRSACA_TERM_CODE_EFF | SMRSACA | (1,1)-(0,n) |
| SMRSACE | SMRSACE_SMRSACA_SEQNO | SMRSACA_SEQNO | SMRSACA | (1,1)-(0,n) |
Link between SMRSACL and SMRSACA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRSACL and SMRSACA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRSACL | SMRSACL_PIDM | SMRSACA_PIDM | SMRSACA | (1,1)-(0,n) |
| SMRSACL | SMRSACL_AREA | SMRSACA_AREA | SMRSACA | (1,1)-(0,n) |
| SMRSACL | SMRSACL_TERM_CODE_EFF | SMRSACA_TERM_CODE_EFF | SMRSACA | (1,1)-(0,n) |
| SMRSACL | SMRSACL_SMRSACA_SEQNO | SMRSACA_SEQNO | SMRSACA | (1,1)-(0,n) |
Link between SMRSACT and SMRSACA| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRSACT and SMRSACA | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRSACT | SMRSACT_PIDM | SMRSACA_PIDM | SMRSACA | (1,1)-(0,n) |
| SMRSACT | SMRSACT_AREA | SMRSACA_AREA | SMRSACA | (1,1)-(0,n) |
| SMRSACT | SMRSACT_TERM_CODE_EFF | SMRSACA_TERM_CODE_EFF | SMRSACA | (1,1)-(0,n) |
| SMRSACT | SMRSACT_SMRSACA_SEQNO | SMRSACA_SEQNO | SMRSACA | (1,1)-(0,n) |
Link between SMRSARC and SMRSARS| Link Type | Link | Project |
|---|---|---|
| Refer(No Action ) | Link Foreign Key Between SMRSARC and SMRSARS | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SMRSARC | SMRSARC_PIDM | SMRSARS_PIDM | SMRSARS | (1,1)-(0,n) |
| SMRSARC | SMRSARC_AREA | SMRSARS_AREA | SMRSARS | (1,1)-(0,n) |
| SMRSARC | SMRSARC_TERM_CODE_EFF | SMRSARS_TERM_CODE_EFF | SMRSARS | (1,1)-(0,n) |
| SMRSARC | SMRSARC_SMRSARS_SEQNO | SMRSARS_SEQNO | SMRSARS | (1,1)-(0,n) |