Reference Data
Entity Relationship Diagram
|
Tip: |
Right click the attachment to view Entity Relationship Diagram for Reference Data in a new tab. |
List of Objects
| DB Object Name | Object Business Name | Object Description | DB Attribute Name | Attribute Business Name | Ordinal Position | Data Type Name | Data Type Size | Numeric Scale | Is Identity | Is Nullable | Primary Key | Mandatory |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RDM_CANONICAL_LCL_REF_C | RDM Code Canonical Locale Reference | RDM Code Canonical Locale Reference | RDM_CD_SYS_KEY_C | RDM CD SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| RDM_CANONICAL_LCL_REF_C | RDM Code Canonical Locale Reference | RDM Code Canonical Locale Reference | RDM_CD_BUS_KEY_C | RDM CD BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| RDM_CANONICAL_LCL_REF_C | RDM Code Canonical Locale Reference | RDM Code Canonical Locale Reference | LOCALE_CD_C | LOCALE CD C | 3 | VARCHAR | 20 | NO | NO | TRUE | TRUE | |
| RDM_CANONICAL_LCL_REF_C | RDM Code Canonical Locale Reference | RDM Code Canonical Locale Reference | LOCALE_RDM_CD_NM_C | LOCALE RDM CD NM C | 4 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_CANONICAL_LCL_REF_C | RDM Code Canonical Locale Reference | RDM Code Canonical Locale Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 5 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_CANONICAL_LCL_REF_C | RDM Code Canonical Locale Reference | RDM Code Canonical Locale Reference | SYS_CRT_BY_C | SYS CRT BY C | 6 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_CANONICAL_LCL_REF_C | RDM Code Canonical Locale Reference | RDM Code Canonical Locale Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 7 | TIMESTAMP_LTZ | NO | NO | TRUE | TRUE | ||
| RDM_CANONICAL_LCL_REF_C | RDM Code Canonical Locale Reference | RDM Code Canonical Locale Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 8 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_CANONICAL_LCL_REF_C | RDM Code Canonical Locale Reference | RDM Code Canonical Locale Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_CANONICAL_LCL_REF_C | RDM Code Canonical Locale Reference | RDM Code Canonical Locale Reference | SYS_END_DTT_C | SYS END DTT C | 10 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_CD_CANONICAL_REL_C | RDM Code Canonical Relation | RDM Code Canonical Relation | RDM_CD_SYS_KEY_C | RDM CD SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| RDM_CD_CANONICAL_REL_C | RDM Code Canonical Relation | RDM Code Canonical Relation | RDM_CD_BUS_KEY_C | RDM CD BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| RDM_CD_CANONICAL_REL_C | RDM Code Canonical Relation | RDM Code Canonical Relation | CANONICAL_RDM_CD_SYS_KEY_C | CANONICAL RDM CD SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| RDM_CD_CANONICAL_REL_C | RDM Code Canonical Relation | RDM Code Canonical Relation | CANONICAL_RDM_CD_BUS_KEY_C | CANONICAL RDM CD BUS KEY C | 4 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| RDM_CD_CANONICAL_REL_C | RDM Code Canonical Relation | RDM Code Canonical Relation | SYS_CRT_DTT_C | SYS CRT DTT C | 5 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_CD_CANONICAL_REL_C | RDM Code Canonical Relation | RDM Code Canonical Relation | SYS_CRT_BY_C | SYS CRT BY C | 6 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_CD_CANONICAL_REL_C | RDM Code Canonical Relation | RDM Code Canonical Relation | SYS_EFF_DTT_C | SYS EFF DTT C | 7 | TIMESTAMP_LTZ | NO | NO | TRUE | TRUE | ||
| RDM_CD_CANONICAL_REL_C | RDM Code Canonical Relation | RDM Code Canonical Relation | SYS_UPDT_DTT_C | SYS UPDT DTT C | 8 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_CD_CANONICAL_REL_C | RDM Code Canonical Relation | RDM Code Canonical Relation | SYS_UPDT_BY_C | SYS UPDT BY C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_CD_CANONICAL_REL_C | RDM Code Canonical Relation | RDM Code Canonical Relation | SYS_END_DTT_C | SYS END DTT C | 10 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_CD_PAR_REL_C | RDM Code Parallel Relation | RDM Code Parallel Relation | RDM_CD_SYS_KEY_C | RDM CD SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| RDM_CD_PAR_REL_C | RDM Code Parallel Relation | RDM Code Parallel Relation | RDM_CD_BUS_KEY_C | RDM CD BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| RDM_CD_PAR_REL_C | RDM Code Parallel Relation | RDM Code Parallel Relation | RDM_TYPE_BUS_KEY_C | RDM TYPE BUS KEY C | 3 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| RDM_CD_PAR_REL_C | RDM Code Parallel Relation | RDM Code Parallel Relation | PRNT_RDM_TYPE_BUS_KEY_C | PRNT RDM TYPE BUS KEY C | 4 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| RDM_CD_PAR_REL_C | RDM Code Parallel Relation | RDM Code Parallel Relation | PRNT_RDM_CD_SYS_KEY_C | PRNT RDM CD SYS KEY C | 5 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| RDM_CD_PAR_REL_C | RDM Code Parallel Relation | RDM Code Parallel Relation | PRNT_RDM_CD_BUS_KEY_C | PRNT RDM CD BUS KEY C | 6 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| RDM_CD_PAR_REL_C | RDM Code Parallel Relation | RDM Code Parallel Relation | SYS_CRT_DTT_C | SYS CRT DTT C | 7 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_CD_PAR_REL_C | RDM Code Parallel Relation | RDM Code Parallel Relation | SYS_CRT_BY_C | SYS CRT BY C | 8 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_CD_PAR_REL_C | RDM Code Parallel Relation | RDM Code Parallel Relation | SYS_EFF_DTT_C | SYS EFF DTT C | 9 | TIMESTAMP_LTZ | NO | NO | TRUE | TRUE | ||
| RDM_CD_PAR_REL_C | RDM Code Parallel Relation | RDM Code Parallel Relation | SYS_UPDT_DTT_C | SYS UPDT DTT C | 10 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_CD_PAR_REL_C | RDM Code Parallel Relation | RDM Code Parallel Relation | SYS_UPDT_BY_C | SYS UPDT BY C | 11 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_CD_PAR_REL_C | RDM Code Parallel Relation | RDM Code Parallel Relation | SYS_END_DTT_C | SYS END DTT C | 12 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | RDM_CD_SYS_KEY_C | RDM CD SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | RDM_CD_BUS_KEY_C | RDM CD BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | RDM_TYPE_SYS_KEY_C | RDM TYPE SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | RDM_TYPE_BUS_KEY_C | RDM TYPE BUS KEY C | 4 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | SRC_SYS_CD_C | SRC SYS CD C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | CTRY_CD_C | CTRY CD C | 6 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | RDM_CD_VAL_C | RDM CD VAL C | 7 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | RDM_CD_ID_C | RDM CD ID C | 8 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | RDM_CD_NM_C | RDM CD NM C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | RDM_CD_ALT_DESC_C | RDM CD ALT DESC C | 10 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | RDM_CD_LVL_NBR_C | RDM CD LVL NBR C | 11 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | RDM_CD_LVL_NM_C | RDM CD LVL NM C | 12 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 13 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | SYS_CRT_BY_C | SYS CRT BY C | 14 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 15 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 16 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 17 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_CODE_REF_C | RDM Code Reference | RDM Code Reference | SYS_END_DTT_C | SYS END DTT C | 18 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_TYPE_REF_C | RDM Type Reference | RDM Type Reference | RDM_TYPE_SYS_KEY_C | RDM TYPE SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| RDM_TYPE_REF_C | RDM Type Reference | RDM Type Reference | RDM_TYPE_BUS_KEY_C | RDM TYPE BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| RDM_TYPE_REF_C | RDM Type Reference | RDM Type Reference | RDM_TYPE_NM_C | RDM TYPE NM C | 3 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| RDM_TYPE_REF_C | RDM Type Reference | RDM Type Reference | RDM_TYPE_DESC_C | RDM TYPE DESC C | 4 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_TYPE_REF_C | RDM Type Reference | RDM Type Reference | ISPARENT | ISPARENT | 5 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| RDM_TYPE_REF_C | RDM Type Reference | RDM Type Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 6 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_TYPE_REF_C | RDM Type Reference | RDM Type Reference | SYS_CRT_BY_C | SYS CRT BY C | 7 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_TYPE_REF_C | RDM Type Reference | RDM Type Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 8 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_TYPE_REF_C | RDM Type Reference | RDM Type Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 9 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| RDM_TYPE_REF_C | RDM Type Reference | RDM Type Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 10 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| RDM_TYPE_REF_C | RDM Type Reference | RDM Type Reference | SYS_END_DTT_C | SYS END DTT C | 11 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE |