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.