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