Table Detail Report

CODE_VALUE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: CODE VALUE GROUP
Definition: Used to create logical groupings of code_values
Table Type: REFERENCE





Column Detail - CODE_VALUE_GROUP


Column Name Type Null? Definition
CHILD_CODE_VALUE DOUBLE N The code value of the child record
CODE_SET DOUBLE Y The code set that the child code value belongs to. This is a denormalized column and reads should be from Code_value.code_set of the child code_value
COLLATION_SEQ DOUBLE Y Ordering field for grouping
PARENT_CODE_VALUE DOUBLE N The code value of the parent record
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CODE_VALUE_GROUP


Child Column in CODE_VALUE_GROUP(FK) Parent Table Name Parent Column Name
Parents: CHILD_CODE_VALUE CODE_VALUE CODE_VALUE
PARENT_CODE_VALUE CODE_VALUE CODE_VALUE


CODE_VALUE_LOG_DOMAIN_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Code Value Logical Domain Relationship
Definition: This table is used to relate Logical Domains to Code Values.
Table Type: REFERENCE





Column Detail - CODE_VALUE_LOG_DOMAIN_R


Column Name Type Null? Definition
CODE_VALUE DOUBLE N Contains the unique value of the code involved in this relationship.
CODE_VALUE_LOG_DOMAIN_R_ID DOUBLE N Uniquely identifies a relationship between a code value and a logical domain.
DISPLAY VARCHAR(40) Y The display string for this code_value, logical_domain pairing.
LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain related to this relationship.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CODE_VALUE_LOG_DOMAIN_R


Child Column in CODE_VALUE_LOG_DOMAIN_R(FK) Parent Table Name Parent Column Name
Parents: CODE_VALUE CODE_VALUE CODE_VALUE
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


CODE_VALUE_OUTBOUND



Column Section Relationship Section Top of Page


Table-level Detail

Description: Outbound alias translations
Definition: This table is used to provider outbound interface mechanisms a translation from code_value to the receiving system's nomenclature.
Table Type: REFERENCE





Column Detail - CODE_VALUE_OUTBOUND


Column Name Type Null? Definition
ALIAS VARCHAR(100) N The actual outbound alias
ALIAS_TYPE_MEANING VARCHAR(12) Y The meaning of the alias. Used when alias is not unique enough within a code_set.
CODE_SET DOUBLE N The Code Set for the code_value. - This is a denormalized column and reads should be from Code_value.code_set of the code_value
CODE_VALUE DOUBLE N Code value of the outbound alias. This is a denormalized column and reads should be from Code_value.code_set of the code_value.
CONTRIBUTOR_SOURCE_CD DOUBLE N Contributing System CD for the destination system
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CODE_VALUE_OUTBOUND


Child Column in CODE_VALUE_OUTBOUND(FK) Parent Table Name Parent Column Name
Parents: CODE_VALUE CODE_VALUE CODE_VALUE
CODE_SET CODE_VALUE_SET CODE_SET


CODE_VALUE_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Used to store the list of code_sets.
Definition: Used to store the list of code_sets and their descriptions as well as other attributes about a code_set.
Table Type: REFERENCE





Column Detail - CODE_VALUE_SET


Column Name Type Null? Definition
ACTIVE_IND_DUP_IND DOUBLE Y Indicates whether the ACTIVE_IND field is being used for duplicate checking when adding/updating code values.
ADD_ACCESS_IND DOUBLE Y Indicates whether the user may add code values to this code set.
ALIAS_DUP_IND DOUBLE Y The alias, alias_type_meaning, code_set, and contributor_system_cd on the code_value_alias table will be used for duplicate checking.
CACHE_IND DOUBLE Y Indicates whether this code set will be cached by the decoder
CDF_MEANING_DUP_IND DOUBLE Y Indicates whether the CDF Meaning field on the code value table will be used for duplicate checking when adding/updating code values.
CHG_ACCESS_IND DOUBLE Y Indicates whether the user can change code values in CRMCode.
CODE_SET DOUBLE N The number of the code set header record (determined by following the procedure for creating a new code set).
CODE_SET_HITS DOUBLE Y Used by the decoders.
CODE_VALUES_CNT DOUBLE Y Used by the decoders.
CONTRIBUTOR VARCHAR(18) Y Obsolete
DEFINITION VARCHAR(500) Y Definition.
DEFINITION_DUP_IND DOUBLE Y definition duplicate indicator
DEF_DUP_RULE_FLAG DOUBLE Y Defines how the code set should be handled during merge.
DEL_ACCESS_IND DOUBLE Y Controls whether code values can be deleted in CRMCODE
DESCRIPTION VARCHAR(60) Y description of the code set
DISPLAY VARCHAR(40) Y display of the code set
DISPLAY_DUP_IND DOUBLE Y Indicates whether DISPLAY field on the code value table will be used for duplicate checking when inserting/updating code values.
DISPLAY_KEY VARCHAR(40) Y Similar to DISPLAY but contains only upper case and alphanumeric characters without any special characters or embedded spaces; Typically used in index to improve query performanced
DISPLAY_KEY_DUP_IND DOUBLE Y use display_key as the duplicate check for this code set
DOMAIN_CODE_SET DOUBLE Y Not used.
DOMAIN_QUALIFIER_IND DOUBLE Y not used
EXTENSION_IND DOUBLE Y Indicates whether code_set_extension rows exist
INQ_ACCESS_IND DOUBLE Y determines whether this code set can be viewed in crmcode
OWNER_MODULE VARCHAR(12) Y Not used.
TABLE_NAME VARCHAR(32) Y Not used.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CODE_VALUE_SET




Parent Column in CODE_VALUE_SET (PK) Child Table Name Child Column Name
Children: CODE_SET CODE_DOMAIN_FILTER CODE_SET
CODE_SET_EXTENSION CODE_SET
CODE_SET_FIELD_DOMAIN CODE_SET
CODE_SET_INTERFACE CODE_SET
CODE_VALUE_ALIAS CODE_SET
CODE_VALUE_OUTBOUND CODE_SET
COMMON_DATA_FOUNDATION CODE_SET
REGIMEN_CAT_ATTRIBUTE CODE_SET
SCH_CODE_REF CODE_SET


COMMON_DATA_FOUNDATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Common Data Foundation or CDF_MEANING
Definition: Used to store processing meanings and give code values universal meaning.
Table Type: REFERENCE





Column Detail - COMMON_DATA_FOUNDATION


Column Name Type Null? Definition
CDF_MEANING VARCHAR(12) N The actual string value for the cdf meaning
CODE_SET DOUBLE N The code set of the cdf meaning
DEFINITION VARCHAR(100) Y The definition for the cdf meaning
DISPLAY VARCHAR(40) N The display string for the cdf meaning
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - COMMON_DATA_FOUNDATION


Child Column in COMMON_DATA_FOUNDATION(FK) Parent Table Name Parent Column Name
Parents: CODE_SET CODE_VALUE_SET CODE_SET




Parent Column in COMMON_DATA_FOUNDATION (PK) Child Table Name Child Column Name
Children: CDF_MEANING CODE_CDF_EXT CDF_MEANING
CODE_SET CODE_CDF_EXT CODE_SET