CODE_CDF_EXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: cdf_meaning extensions
Definition: cdf meanings can be extended by adding additional parameters to the code_cdf_ext table. This is done in a name value pair lookup approach. Each additional parameter becomes a row on the code cddf ext entity.
Table Type: REFERENCE





Column Detail - CODE_CDF_EXT


Column Name Type Null? Definition
ACTION_FIELD VARCHAR(50) Y Not currently used
CDF_MEANING VARCHAR(12) N The cdf_meaning that the extension is for.
CODE_SET DOUBLE N The code set of the cdf extension
FIELD_DEFAULT VARCHAR(50) Y The default value
FIELD_HELP VARCHAR(100) Y A simple caption explaining the field
FIELD_IN_MASK VARCHAR(50) Y The input mask for the cdf extension
FIELD_LEN DOUBLE Y The length of the cdf extension
FIELD_NAME VARCHAR(32) N The field name of the extension.
FIELD_OUT_MASK VARCHAR(50) Y The output mask for the cdf extension
FIELD_PROMPT VARCHAR(50) Y The prompt for the cdf extension
FIELD_SEQ DOUBLE Y The order in which the cdf extension is prompted for.
FIELD_TYPE DOUBLE Y The data type of the cdf extension
FIELD_VALUE VARCHAR(100) Y The actual stored value
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.
VAL_CODE_SET DOUBLE Y The code_set that all responses must exist in
VAL_CONDITION VARCHAR(100) Y The check for valid values (i.e. only allow X and Z)



Relationship Detail - CODE_CDF_EXT


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


CODE_DOMAIN_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: The code domain filter entity contains the code value(s) fro
Definition: The code domain filter entity contains the code value(s) from the code set(s) specified by the code set domain entity. The code values are converted to alpha and concatenated together to form a domain key.
Table Type: REFERENCE





Column Detail - CODE_DOMAIN_FILTER


Column Name Type Null? Definition
CODE_SET DOUBLE N
DEFINITION VARCHAR(100) Y
DOMAIN_ID DOUBLE N Column
DOMAIN_KEY VARCHAR(500) N
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_DOMAIN_FILTER


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


CODE_DOMAIN_FILTER_DISPLAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: The code domain filter display entity is used to filter the
Definition: The code domain filter display entity is used to filter the display of code values within a code set. The domain id is pointed to the sub set of code values with the code sets that are valid for that domain id.
Table Type: REFERENCE





Column Detail - CODE_DOMAIN_FILTER_DISPLAY


Column Name Type Null? Definition
CODE_SET DOUBLE N Not currently used
CODE_VALUE DOUBLE N code value
DOMAIN_ID DOUBLE N Not currently 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_DOMAIN_FILTER_DISPLAY


Child Column in CODE_DOMAIN_FILTER_DISPLAY(FK) Parent Table Name Parent Column Name
Parents: CODE_VALUE CODE_VALUE CODE_VALUE


CODE_SET_DOMAIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Code set domain is a subset of the code set field domain by
Definition: Code set domain is a subset of the code set field domain by which the user has decided to filter the code set. This can be one or more of the code set(s) from the specified code set field domain, and can be specified in order of importance by the user.
Table Type: REFERENCE





Column Detail - CODE_SET_DOMAIN


Column Name Type Null? Definition
CODE_SET DOUBLE N Not currently used
FIELD_SEQUENCE DOUBLE N Not currently used
REFERENCE DOUBLE N Not currently 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_SET_DOMAIN


Child Column in CODE_SET_DOMAIN(FK) Parent Table Name Parent Column Name
Parents: CODE_SET CODE_SET_FIELD_DOMAIN CODE_SET
REFERENCE CODE_SET_FIELD_DOMAIN REFERENCE


CODE_SET_EXTENSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Code set extensions
Definition: Code sets can be extended by adding additional parameters to the code set definition. This is done in a name value pair lookup approach. Each additional parameter becomes a row on the code set extension entity.
Table Type: REFERENCE





Column Detail - CODE_SET_EXTENSION


Column Name Type Null? Definition
ACTION_FIELD VARCHAR(50) Y Not currently used
CODE_SET DOUBLE N The code set for the code value
FIELD_DEFAULT VARCHAR(50) Y The default value
FIELD_HELP VARCHAR(100) Y A simple caption explaining the field
FIELD_IN_MASK VARCHAR(50) Y The input mask for the code value extension
FIELD_LEN DOUBLE Y The length of the code value extension
FIELD_NAME VARCHAR(32) N The field name of the extension.
FIELD_OUT_MASK VARCHAR(50) Y The output mask for the code value extension
FIELD_PROMPT VARCHAR(50) Y The prompt for the code value extension
FIELD_SEQ DOUBLE Y The order in which the code value extension is prompted for.
FIELD_TYPE DOUBLE Y The data type of the code value extension
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.
VALIDATION_CODE_SET DOUBLE Y The code_set that all responses must exist in
VALIDATION_CONDITION VARCHAR(100) Y The check for valid values (i.e. only allow X and Z)



Relationship Detail - CODE_SET_EXTENSION


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




Parent Column in CODE_SET_EXTENSION (PK) Child Table Name Child Column Name
Children: CODE_SET CODE_VALUE_EXTENSION CODE_SET
FIELD_NAME CODE_VALUE_EXTENSION FIELD_NAME