Table Detail Report

BR_TIME_ZONE



Column Section Top of Page


Table-level Detail

Description: BEDROCK TIME ZONE
Definition: list of all time zones
Table Type: REFERENCE





Column Detail - BR_TIME_ZONE


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.
DESCRIPTION VARCHAR(100) N long name of the time zone
REGION VARCHAR(100) Y time zone region
SEQUENCE DOUBLE N time zone sequence
TIME_ZONE VARCHAR(100) Y short name of the time zone (country/city)
TIME_ZONE_ID DOUBLE N table key
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_TYPE_SEG_R



Column Section Top of Page


Table-level Detail

Description: Bedrock Type Segment Relationship
Definition: This table stores the HL7 segments that are available for the HL7 interface type/interface direction
Table Type: REFERENCE





Column Detail - BR_TYPE_SEG_R


Column Name Type Null? Definition
BR_TYPE_SEG_R_ID DOUBLE N Unique id
INBOUND_IND DOUBLE N value of 1 indicates that this segment is available for the inbound interface direction
INTERFACE_TYPE VARCHAR(60) Y the type of HL7 interface, i.e. ADT, Orders, Results
OUTBOUND_IND DOUBLE N value of 1 indicates that this segment is available for the outbound interface direction
REQUIRED_IND DOUBLE N value of 1 indicates that this segment is required for the interface type/direction
SEGMENT_NAME VARCHAR(10) Y the name of the HL7 segment, i.e. PID, PV1, NTE
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_VOCABULARY



Column Section Top of Page


Table-level Detail

Description: Bedrock Vocabulary
Definition: Reference data will be stored on this table. The data will assist in proposing new vocabulary to be loaded by bedrock.
Table Type: REFERENCE





Column Detail - BR_VOCABULARY


Column Name Type Null? Definition
BR_VOCABULARY_ID DOUBLE N Unique identifier for the table.
SOURCE_IDENTIFIER VARCHAR(50) Y The code or key from the vocabulary that contributed the string.
SOURCE_NAME VARCHAR(40) Y The name of the vocabulary's source.
SOURCE_STRING VARCHAR(255) Y Variable length string contributed by the source vocabulary.
SOURCE_VOCAB_MEAN VARCHAR(12) Y The meaning of the vocabulary that contributed the string.
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_WIZARD_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: BR_WIZARD_HIST
Definition: Table to store user logons of bedrock wizards
Table Type: ACTIVITY





Column Detail - BR_WIZARD_HIST


Column Name Type Null? Definition
BR_WIZARD_HIST_ID DOUBLE N Unique id for the table
LOG_DT_TM DATETIME Y Date and time the user logged into the wizard
PRSNL_ID DOUBLE N Unique id of the user that logged into the wizard
SOLUTION_MEAN VARCHAR(100) Y Solution meaning column
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
WIZARD_MEAN VARCHAR(100) Y Wizard meaning column



Relationship Detail - BR_WIZARD_HIST


Child Column in BR_WIZARD_HIST(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


MP_VIEWPOINT



Column Section Relationship Section Top of Page


Table-level Detail

Description: MPages Viewpoint
Definition: Basic information about a viewpiont (collection of Mpages views)
Table Type: REFERENCE





Column Detail - MP_VIEWPOINT


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.
MP_VIEWPOINT_ID DOUBLE N Unique, generated number that identifies a single row on the MP_VIEWPOINT table.
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.
VIEWPOINT_NAME VARCHAR(150) N The displayable name of the Viewpoint.
VIEWPOINT_NAME_KEY VARCHAR(150) N Indexed and converted version of the VIEWPOINT_NAME column used fir searching purposes.



Relationship Detail - MP_VIEWPOINT




Parent Column in MP_VIEWPOINT (PK) Child Table Name Child Column Name
Children: MP_VIEWPOINT_ID MP_VIEWPOINT_RELTN MP_VIEWPOINT_ID