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 |