Code Items

Entity Relationship Diagram

Tip:   

Right click the attachment to view Entity Relationship Diagram for Code Items in a new tab.

List of Objects

Table Schema Name 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
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER ID ID 1 VARCHAR 255   NO NO YES YES
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER LOOKUP_TYPE LOOKUP_TYPE 2 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER CANONICAL_CODE CANONICAL_CODE 3 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER CANONICAL_DESC CANONICAL_DESC 4 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER STATUS_CODE STATUS_CODE 5 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER MDM_URI MDM_URI 6 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER LOAD_STATUS LOAD_STATUS 7 VARCHAR 100   NO YES NO NO
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER PLUGIN_PROCESS_DT PLUGIN_PROCESS_DT 8 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER LOAD_DETAILS LOAD_DETAILS 9 VARCHAR 50000   NO YES NO NO
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_CRT_DT SYS_CRT_DT 10 TIMESTAMP_LTZ     NO NO NO YES
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_CRT_BY SYS_CRT_BY 11 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_UPDT_DT SYS_UPDT_DT 12 TIMESTAMP_LTZ     NO NO NO YES
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_UPDT_BY SYS_UPDT_BY 13 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_EFF_DT SYS_EFF_DT 14 TIMESTAMP_LTZ     NO NO NO YES
MDM_CANONICAL R_CODE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_END_DT SYS_END_DT 15 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL R_DEPENDENCY_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER ID ID 1 VARCHAR 255   YES NO YES YES
MDM_CANONICAL R_DEPENDENCY_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER PARENT_ID PARENT_ID 2 VARCHAR 255   NO NO YES YES
MDM_CANONICAL R_DEPENDENCY_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER STATUS_CODE STATUS_CODE 3 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_DEPENDENCY_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_CRT_DT SYS_CRT_DT 4 TIMESTAMP_LTZ     NO NO NO YES
MDM_CANONICAL R_DEPENDENCY_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_CRT_BY SYS_CRT_BY 5 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_DEPENDENCY_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_UPDT_DT SYS_UPDT_DT 6 TIMESTAMP_LTZ     NO NO NO YES
MDM_CANONICAL R_DEPENDENCY_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_UPDT_BY SYS_UPDT_BY 7 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_DEPENDENCY_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_EFF_DT SYS_EFF_DT 8 TIMESTAMP_LTZ     NO NO NO YES
MDM_CANONICAL R_DEPENDENCY_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_END_DT SYS_END_DT 9 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL R_EXTERNAL_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER ID ID 1 VARCHAR 255   NO NO YES YES
MDM_CANONICAL R_EXTERNAL_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER DATA_SOURCE_CD DATA_SOURCE_CD 2 VARCHAR 255   NO NO YES YES
MDM_CANONICAL R_EXTERNAL_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER EXTERNAL_CODE EXTERNAL_CODE 3 VARCHAR 255   NO NO YES YES
MDM_CANONICAL R_EXTERNAL_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER EXTERNAL_CODE_DESC EXTERNAL_CODE_DESC 4 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_EXTERNAL_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_CRT_DT SYS_CRT_DT 5 TIMESTAMP_LTZ     NO NO NO YES
MDM_CANONICAL R_EXTERNAL_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_CRT_BY SYS_CRT_BY 6 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_EXTERNAL_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_UPDT_DT SYS_UPDT_DT 7 TIMESTAMP_LTZ     NO NO NO YES
MDM_CANONICAL R_EXTERNAL_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_UPDT_BY SYS_UPDT_BY 8 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_EXTERNAL_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER STATUS_CODE STATUS_CODE 9 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_EXTERNAL_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER DOWNSTREAM_DEFAULT DOWNSTREAM_DEFAULT 10 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_EXTERNAL_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_EFF_DT SYS_EFF_DT 11 TIMESTAMP_LTZ     NO NO NO YES
MDM_CANONICAL R_EXTERNAL_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_END_DT SYS_END_DT 12 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL R_LOCALE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER ID ID 1 VARCHAR 255   NO NO YES YES
MDM_CANONICAL R_LOCALE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER LANGUAGE LANGUAGE 2 VARCHAR 255   NO NO YES YES
MDM_CANONICAL R_LOCALE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER LANGUAGE_DESC LANGUAGE_DESC 3 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_LOCALE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER STATUS_CODE STATUS_CODE 4 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_LOCALE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_CRT_DT SYS_CRT_DT 5 TIMESTAMP_LTZ     NO NO NO YES
MDM_CANONICAL R_LOCALE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_CRT_BY SYS_CRT_BY 6 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_LOCALE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_UPDT_DT SYS_UPDT_DT 7 TIMESTAMP_LTZ     NO NO NO YES
MDM_CANONICAL R_LOCALE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_UPDT_BY SYS_UPDT_BY 8 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_LOCALE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_EFF_DT SYS_EFF_DT 9 TIMESTAMP_LTZ     NO NO NO YES
MDM_CANONICAL R_LOCALE_ITEMS CODE ITEMS MASTER CODE ITEMS MASTER SYS_END_DT SYS_END_DT 10 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER ID ID 1 VARCHAR 255   YES NO YES YES
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER LOOKUP_TYPE LOOKUP_TYPE 2 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER CANONICAL_CODES CANONICAL_CODES 3 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER DATA_SOURCE_CODE DATA_SOURCE_CODE 4 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER LOAD_STATUS LOAD_STATUS 5 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER MDM_URI MDM_URI 6 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER COMMENTS COMMENTS 7 VARCHAR 255   NO YES NO NO
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER PLUGIN_PROCESS_DT PLUGIN_PROCESS_DT 8 TIMESTAMP_LTZ   9 NO YES NO NO
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER SYS_CRT_DT SYS_CRT_DT 9 TIMESTAMP_LTZ   9 NO NO NO NO
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER SYS_CRT_BY SYS_CRT_BY 10 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER SYS_UPDT_DT SYS_UPDT_DT 11 TIMESTAMP_LTZ   9 NO NO NO NO
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER SYS_UPDT_BY SYS_UPDT_BY 12 VARCHAR 255   NO NO NO YES
MDM_CANONICAL R_CODE_CLEANUP_INPUT CODE ITEMS MASTER CODE ITEMS MASTER LOAD_DETAILS LOAD_DETAILS 13 VARCHAR 255   NO YES NO NO