Table Detail Report
BR_REPORT
Column Section | Top of Page |
Table-level Detail
Description: | BEDROCK REPORT |
Definition: | bedrock reports |
Table Type: | REFERENCE |
Column Detail - BR_REPORT
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CLIENT_ID | DOUBLE | N | Identifies which bedrock client data belongs to |
BR_REPORT_HISTORY_ID | DOUBLE | N | Report history ID |
BR_REPORT_ID | DOUBLE | N | unique identifier |
LAST_RUN_DT_TM | DATETIME | Y | Date/time the report was accessed |
LAST_RUN_PRSNL_ID | DOUBLE | N | Id of the user that accessed the report |
LAST_RUN_STATUS_FLAG | DOUBLE | N | Status of a digital xray report (good data, incomplete data) |
PROGRAM_NAME | VARCHAR(50) | N | name of the ccl program associated with the report |
REFRESH_NBR_OF_DAYS | DOUBLE | N | Indicates frequency of report run |
REPORT_NAME | VARCHAR(100) | N | name of the report |
REPORT_TYPE_FLAG | DOUBLE | N | Flag to indicate the type of report (bedrock audit,digital x-ray) |
SEQUENCE | DOUBLE | N | Sequence |
SOLUTION_DISP | VARCHAR(100) | Y | Display value of the solution |
SOLUTION_MEAN | VARCHAR(100) | Y | Meaning of the solution |
STEP_CAT_MEAN | VARCHAR(50) | N | short name of the solution |
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. |
BR_REPORT_HISTORY
Column Section | Top of Page |
Table-level Detail
Description: | Bedrock Report History |
Definition: | Stores history data for bedrock reports |
Table Type: | REFERENCE |
Column Detail - BR_REPORT_HISTORY
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CLIENT_ID | DOUBLE | N | Identifies which bedrock client data belongs to |
BR_REPORT_HISTORY_ID | DOUBLE | N | Unique id for the table |
BR_REPORT_ID | DOUBLE | N | Unique id from br_report |
RUN_DT_TM | DATETIME | Y | Date/time the instance of report was accessed |
RUN_PRSNL_ID | DOUBLE | N | Id of the user who accessed instance of the report |
RUN_STATUS_FLAG | DOUBLE | N | Status of the report?s data when it was accessed |
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_REPORT_PARAMS
Column Section | Top of Page |
Table-level Detail
Description: | Bedrock Report Parameters |
Definition: | Stores the type of parameter to be used in the bedrock reports |
Table Type: | REFERENCE |
Column Detail - BR_REPORT_PARAMS
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CLIENT_ID | DOUBLE | N | Identifies which bedrock client data belongs to |
BR_REPORT_ID | DOUBLE | N | Unique id from br_report |
CAPTION | VARCHAR(100) | Y | The string that will be displayed to the end user when prompting for data like 'Facility' or 'Organization'. |
CODE_SET | DOUBLE | N | Code set number for a CODESET Parameter |
MULTIPLE_VALUE_IND | DOUBLE | Y | 1 if more than one value is valid |
PARAM_TYPE_MEAN | VARCHAR(20) | N | Type of parameter (CODESET,FACILITY,DATE, etc..) |
REQUIRED_IND | DOUBLE | Y | 1 if at least one value is required |
SEQUENCE | DOUBLE | Y | Orders the parameters |
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. |
BR_REPORT_STATISTICS
Column Section | Top of Page |
Table-level Detail
Description: | Bedrock Report Statistics |
Definition: | Gather data for Bedrock reports |
Table Type: | REFERENCE |
Column Detail - BR_REPORT_STATISTICS
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CLIENT_ID | DOUBLE | N | Identifies which bedrock client data belongs to |
BR_REPORT_HISTORY_ID | DOUBLE | N | Unique id from br_report_history_table |
BR_REPORT_STATISTICS_ID | DOUBLE | N | Unique is for the table |
QUALIFYING_ITEMS | DOUBLE | Y | Number to indicate how much of data is good |
STATISTIC_MEANING | VARCHAR(25) | Y | Unique meaning for the type of statistic |
STATUS_FLAG | DOUBLE | N | Number to indicate if data is good, incomplete,etc.. |
TOTAL_ITEMS | DOUBLE | Y | Total number of data items being reviewed |
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. |
BR_RLI_CLIENT_LOG
Column Section | Top of Page |
Table-level Detail
Description: | BEDROCK RLI CLIENT LOG |
Definition: | Reference Lab order client activity log |
Table Type: | REFERENCE |
Column Detail - BR_RLI_CLIENT_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CLIENT_ID | DOUBLE | N | Identifies which bedrock client data belongs to |
LAST_UPDT_DT_TM | DATETIME | Y | date/time when the row was last updated |
SUPPLIER_FLAG | DOUBLE | N | Unique identifier for an RLI supplier 1 = ARUP, 2 = Mayo, 3 = LabOne, 4 = Quest Toplab, 5 = Quest Antrim, 6 = Quest AML |
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. |