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 |