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