Table Detail Report
BR_CKI_CLIENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | BR CKI Client |
Definition: | List of clients that use the CKI Mapping wizard. Stores the name, mnemonic and an id. |
Table Type: | REFERENCE |
Column Detail - BR_CKI_CLIENT
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CLIENT_ID | DOUBLE | N | Identifies which bedrock client data belongs to |
CLIENT_ID | DOUBLE | N | Id to identify client specific to cki mapping |
CLIENT_MNEMONIC | VARCHAR(12) | Y | Short character string to identify client |
CLIENT_NAME | VARCHAR(255) | Y | Long character string to identify client |
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 - BR_CKI_CLIENT
Parent Column in BR_CKI_CLIENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CLIENT_ID | BR_CKI_CLIENT_DATA | CLIENT_ID |
BR_CKI_MATCH | CLIENT_ID |
BR_CKI_CLIENT_DATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Bedrock CKI Client Data |
Definition: | Stores client data to be matched to a concept cki for each data type |
Table Type: | REFERENCE |
Column Detail - BR_CKI_CLIENT_DATA
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CKI_CLIENT_DATA_ID | DOUBLE | N | Unique id for the table |
BR_CLIENT_ID | DOUBLE | N | Identifies which bedrock client data belongs to |
CLIENT_ID | DOUBLE | N | Unique id for the client (BR_CKI_CLIENT) |
DATA_TYPE_ID | DOUBLE | N | Unique id for the data type (BR_CKI_DATA_TYPE) |
FIELD_CNT | DOUBLE | N | Count of number of field rows for this client data |
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 - BR_CKI_CLIENT_DATA
Child Column in BR_CKI_CLIENT_DATA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CLIENT_ID | BR_CKI_CLIENT | CLIENT_ID |
DATA_TYPE_ID | BR_CKI_DATA_TYPE | DATA_TYPE_ID |
Parent Column in BR_CKI_CLIENT_DATA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BR_CKI_CLIENT_DATA_ID | BR_CKI_CLIENT_DATA_FIELD | BR_CKI_CLIENT_DATA_ID |
BR_CKI_CLIENT_DATA_FIELD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | BR CKI CLIENT DATA FIELDS |
Definition: | Stores client data fields for the BR_CKI_CLINENT_DATA table |
Table Type: | REFERENCE |
Column Detail - BR_CKI_CLIENT_DATA_FIELD
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CKI_CLIENT_DATA_FIELD_ID | DOUBLE | N | Unique id for the table |
BR_CKI_CLIENT_DATA_ID | DOUBLE | N | Unique id for the parent table |
FIELD_CONTENT | VARCHAR(100) | Y | Client data loaded from a spreadsheet. Will vary by data type. (Descriptions, Mnemonics, CPT4, filters, etc?) |
FIELD_NBR | DOUBLE | N | Field number to sequence or order the fields for client data |
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 - BR_CKI_CLIENT_DATA_FIELD
Child Column in BR_CKI_CLIENT_DATA_FIELD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BR_CKI_CLIENT_DATA_ID | BR_CKI_CLIENT_DATA | BR_CKI_CLIENT_DATA_ID |
BR_CKI_CLIENT_INFO
Column Section | Top of Page |
Table-level Detail
Description: | Bedrock CKI Client Info |
Definition: | Stores data type information for each client using the CKI Mapping wizard |
Table Type: | REFERENCE |
Column Detail - BR_CKI_CLIENT_INFO
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CLIENT_ID | DOUBLE | N | Identifies which bedrock client data belongs to |
CLIENT_ID | DOUBLE | N | Unique id for the client |
CLIENT_INFO_ID | DOUBLE | N | Unique id for the BR_CKI_client_info |
DATA_TYPE_ID | DOUBLE | N | Unique id for the BR_CKI data type |
EXPORT_IND | DOUBLE | Y | Indicates if mapping was done and an extract was created |
LOAD_DT_TM | DATETIME | Y | Date that the data set was loaded for mapping |
LOCK_IND | DOUBLE | Y | Indicates if mapping is currently being performed for a client/data type |
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. |
BR_CKI_DATA_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Bedrock CKI Data Type |
Definition: | A list of data types that can be used for CKI Mapping |
Table Type: | REFERENCE |
Column Detail - BR_CKI_DATA_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CLIENT_ID | DOUBLE | N | Identifies which bedrock client data belongs to |
DATA_TYPE_ID | DOUBLE | N | Unique id for the data type |
DATA_TYPE_MEANING | VARCHAR(30) | Y | Short character description for the data type |
DATA_TYPE_NAME | VARCHAR(30) | Y | Long character description for the data type |
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 - BR_CKI_DATA_TYPE
Parent Column in BR_CKI_DATA_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DATA_TYPE_ID | BR_CKI_CLIENT_DATA | DATA_TYPE_ID |
BR_CKI_DATA_TYPE_COLUMNS | DATA_TYPE_ID | ||
BR_CKI_MATCH | DATA_TYPE_ID | ||
BR_CKI_SCREEN_INFO | DATA_TYPE_ID |