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. |