Table Detail Report

BR_DTA_INTERPRETATIVE



Column Section Top of Page


Table-level Detail

Description: BEDROCK DTA INTERPRETATIVE
Definition: legacy dta interpretative data
Table Type: REFERENCE





Column Detail - BR_DTA_INTERPRETATIVE


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DTA_ID DOUBLE N Legacy assay id.
LONG_TEXT LONGTEXT Y The long text description for the interpretation.
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_DTA_LOINC



Column Section Top of Page


Table-level Detail

Description: Bedrock Discrete Task Assay LOINC
Definition: Stores LOINC codes imported from files received from foreign systems.
Table Type: REFERENCE





Column Detail - BR_DTA_LOINC


Column Name Type Null? Definition
ACTIVITY_TYPE_TXT VARCHAR(20) N The activity type of the orderable (I.E. Lab)
BR_DTA_LOINC_ID DOUBLE N Uniquely identifies a specific LOINC association.
LOINC_TXT VARCHAR(20) N The LOINC code associated with a foreign file system DTA.
LONG_DTA_NAME VARCHAR(60) N The long name of a foreign file system DTA.
SHORT_DTA_NAME VARCHAR(40) N The short name of a foreign file system DTA.
SOURCE_IDENTIFIER_NAME VARCHAR(40) N The name of the foreign file containing the DTA/LOINC associations.
SPECIMEN_TYPE_TXT VARCHAR(40) N Textual display of the specimen type associated with a LOINC code.
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.
WIZARD_MEAN_TXT VARCHAR(100) N Used to identify which build tool will be reading the rows on the table.


BR_DTA_MAP



Column Section Top of Page


Table-level Detail

Description: BEDROCK DTA MAP
Definition: legacy dta data map
Table Type: REFERENCE





Column Detail - BR_DTA_MAP


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DTA_ID DOUBLE N Legacy assay id.
TASK_ASSAY_CD DOUBLE N dta id
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_DTA_RELATIONSHIP



Column Section Top of Page


Table-level Detail

Description: BEDROCK DTA RELATIONSHIP
Definition: legacy dta relationships
Table Type: REFERENCE





Column Detail - BR_DTA_RELATIONSHIP


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DTA_ID DOUBLE N Legacy assay id.
INTERVAL_MIN DOUBLE N Defined as 1 the interval minutes associated to the assay for this order catalog item.
OC_ID DOUBLE N Legacy order catalog item.
PENDING_IND DOUBLE N Defined as 1 the pending indicator is defined.
REPEAT_IND DOUBLE N Defined as 1 the repeat indicator is defined.
RESTRICT_DISPLAY_IND DOUBLE N Defined as 1 the restrict display indicator is defined.
SEQUENCE DOUBLE N Sequence
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_DTA_RRF



Column Section Top of Page


Table-level Detail

Description: BEDROCK DTA RRF
Definition: legacy dta reference ranges
Table Type: REFERENCE





Column Detail - BR_DTA_RRF


Column Name Type Null? Definition
AGE_FROM DOUBLE N beginning age
AGE_FROM_UNITS VARCHAR(25) Y beginning age units (month/year)
AGE_TO DOUBLE N ending age
AGE_TO_UNITS VARCHAR(25) Y ending age units (month/year)
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CRITICAL_HIGH DOUBLE N critical high
CRITICAL_IND DOUBLE Y Indicates if critical_high, critical_low, or both are valued.
CRITICAL_LOW DOUBLE N critical low
DILUTE_IND DOUBLE N Defined as 1 the dilute indicator is defined.
DTA_ID DOUBLE N Legacy assay id.
FEASIBLE_HIGH DOUBLE N feasible high
FEASIBLE_IND DOUBLE Y Indicates if feasible_high, feasible_low, or both are valued.
FEASIBLE_LOW DOUBLE N feasible low
LINEAR_HIGH DOUBLE N linear high
LINEAR_IND DOUBLE Y Indicates if linear_high, linear_low, or both are valued.
LINEAR_LOW DOUBLE N linear low
NORMAL_HIGH DOUBLE N normal high
NORMAL_IND DOUBLE Y Indicates if normal_high, normal_low, or both are valued.
NORMAL_LOW DOUBLE N normal low
REVIEW_HIGH DOUBLE N review high
REVIEW_IND DOUBLE Y Indicates if review_high, review_low, or both are valued.
REVIEW_LOW DOUBLE N review low
RRF_ID DOUBLE N Reference range ID.
SERVICE_RESOURCE VARCHAR(40) Y Service resource for the reference range
SEX VARCHAR(12) Y gender
UNKNOWN_AGE_IND DOUBLE N indicates unknown age
UOM VARCHAR(40) Y The unit of measure.
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.