Table Detail Report

BR_CKI_DATA_TYPE_COLUMNS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock CKI Data Type Columns
Definition: Stores the values and the order of data that should be in a spreadsheet to be parsed by the CKI Mapping wizard
Table Type: REFERENCE





Column Detail - BR_CKI_DATA_TYPE_COLUMNS


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
COLUMN_DISPLAY VARCHAR(60) Y Name of the column in the spreadsheet.
COLUMN_POSITION DOUBLE Y Number to identify the order of the data items in the spreadsheet.
DATA_TYPE_COLUMNS_ID DOUBLE N Primary Key
DATA_TYPE_ID DOUBLE N Id for the type of data set (Order Catalog, Code Set, etc..)
SCREEN_DISPLAY VARCHAR(60) Y If the data should be displayed there is has a value and the value is the name of the column in the wizard.
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_COLUMNS


Child Column in BR_CKI_DATA_TYPE_COLUMNS(FK) Parent Table Name Parent Column Name
Parents: DATA_TYPE_ID BR_CKI_DATA_TYPE DATA_TYPE_ID


BR_CKI_MATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: BR CKI Match
Definition: Stores the matched values from the CKI Mapping wizard
Table Type: REFERENCE





Column Detail - BR_CKI_MATCH


Column Name Type Null? Definition
BR_CKI_MATCH_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)
CONCEPT_CKI VARCHAR(50) Y CKI value that was matched to the client's data item
DATA_ITEM VARCHAR(20) Y String identifier for the client's data item that was matched.
DATA_ITEM_NAME VARCHAR(100) Y Name of the clients data item that was matched
DATA_TYPE_ID DOUBLE N Unique id for the data type (BR_CKI_DATA_TYPE)
MILLENNIUM_NAME VARCHAR(100) Y Name of the millennium item that was matched to the client data item
MILLENNIUM_VALUE DOUBLE N Unique id of the millennium item that was matched to the client data item
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_MATCH


Child Column in BR_CKI_MATCH(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


BR_CKI_SCREEN_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock CKI Screen Info
Definition: Stores the display value for columns in the CKI Mapping Wizard
Table Type: REFERENCE





Column Detail - BR_CKI_SCREEN_INFO


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DATA_TYPE_ID DOUBLE N Id for the data type
SCREEN_DISPLAY VARCHAR(60) Y Display value for the column
SCREEN_INFO_ID DOUBLE N PRIMARY KEY
SCREEN_POSITION DOUBLE Y Order to be displayed for the display values on the screen of the wizard.
SCREEN_TYPE VARCHAR(30) Y String for the page in the CKI Wizard
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_SCREEN_INFO


Child Column in BR_CKI_SCREEN_INFO(FK) Parent Table Name Parent Column Name
Parents: DATA_TYPE_ID BR_CKI_DATA_TYPE DATA_TYPE_ID


BR_CLIENT



Column Section Top of Page


Table-level Detail

Description: BEDROCK CLIENT
Definition: stores all bedrock clients
Table Type: REFERENCE





Column Detail - BR_CLIENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
AUTOBUILD_CLIENT_ID DOUBLE N indicates which autobuild should be used
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
BR_CLIENT_NAME VARCHAR(255) N name of bedrock client
CLIENT_MNEMONIC VARCHAR(12) Y client's Cerner mnemonic
DATA_MOVE_READY_IND DOUBLE Y indicates if the client's data is ready to move
FRANCHISE_CLIENT_ID DOUBLE N Holds the client_id of the parent if the client is a franchise child
FRANCHISE_FLAG DOUBLE N Determines whether the client is a franchise parent or child. A value of 1 means the client is a franchise parent, a value of 2 means the client is a child of a franchise parent
OPERATING_SYSTEM VARCHAR(3) Y operating system of the Millennium database
REGION VARCHAR(100) N country the client is in
SITE_READY_IND DOUBLE N indicates if the site is ready to start
START_VERSION_NBR DOUBLE N Identifies which version of start has been loaded
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_CLIENT_ITEM_RELTN



Column Section Top of Page


Table-level Detail

Description: BEDROCK CLIENT ITEM RELATIONSHIP
Definition: solutions & steps for each client
Table Type: REFERENCE





Column Detail - BR_CLIENT_ITEM_RELTN


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
BR_CLIENT_ITEM_RELTN_ID DOUBLE N Unique identifier for this table
ITEM_DISPLAY VARCHAR(255) N the display value of the ""STEP"" or ""SOLUTION""
ITEM_MEAN VARCHAR(255) N the meaning of the ""STEP"" or ""SOLUTION""
ITEM_TYPE VARCHAR(255) N Type of Item
SOLUTION_SEQ DOUBLE Y display sequence of the solution on the bedrock implementation page
SOLUTION_TYPE_FLAG DOUBLE N flag to identify the type of solution in the application (0=design/build,1=lighthouse)
STATUS_DT_TM DATETIME Y date/time the status was last updated
STATUS_FLAG DOUBLE N status of the step - not started (0), in process (1) or complete (2)
STATUS_ID DOUBLE N identifier of the user that caused the change in status - from the br_prsnl table
STEP_CAT_DISP VARCHAR(100) Y display associated with the solution of the step (i.e. PowerChart Office)
STEP_CAT_MEAN VARCHAR(100) Y meaning associated with the solution of the step (i.e. PCO)
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.