Table Detail Report

BR_PAL_COLUMNS



Column Section Top of Page


Table-level Detail

Description: BR PAL COLUMNS
Definition: holds patient access list information while building
Table Type: REFERENCE





Column Detail - BR_PAL_COLUMNS


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Bedrock Client ID from BR_CLIENT
COLUMN_CD DOUBLE N This is the unique identifier to the column from codeset 6023Column
COLUMN_DESCRIPTION VARCHAR(150) Y describes what the column is used for
COLUMN_MEANING VARCHAR(15) Y cdf_meaning from 6023 for certain columns
COLUMN_NAME VARCHAR(40) Y display for the PAL column
COLUMN_NAME_KEY VARCHAR(40) N uppercase column_name
COLUMN_TYPE_CD DOUBLE N Stores the type of Patient Access List columns
SECTION VARCHAR(20) Y Display for the type of PAL section
START_VERSION_NBR DOUBLE Y Identifies which version of start has been loaded
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_PARTIAL_FILL



Column Section Top of Page


Table-level Detail

Description: BEDROCK PARTIAL FILL
Definition: list of tables touched by bedrock
Table Type: REFERENCE





Column Detail - BR_PARTIAL_FILL


Column Name Type Null? Definition
TABLE_NAME VARCHAR(30) N name of millennium table touched with Bedrock
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_PERSON_SEARCH_SETTINGS



Column Section Top of Page


Table-level Detail

Description: Bedrock Person Search Settings
Definition: all available person search filters or results
Table Type: REFERENCE





Column Detail - BR_PERSON_SEARCH_SETTINGS


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
BR_PERSON_SEARCH_SETTINGS_ID DOUBLE N Unique id
CODESET DOUBLE Y codeset number if linked to a code_value row
DATA_TYPE_FLAG DOUBLE Y number assigned to the type of filter or result
DESCRIPTION VARCHAR(50) Y name of filter or result
DISPLAY VARCHAR(50) Y name of filter or result
MEANING VARCHAR(20) Y cdf_meaning if linked to a code_value row
SETTING_MEAN VARCHAR(20) Y meaning to link types of rows
START_VERSION_NBR DOUBLE Y Identifies which version of start has been loaded
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_PHARM_PRODUCT_WORK



Column Section Top of Page


Table-level Detail

Description: Bedrock Pharmacy Product Work
Definition: This table contains the client's pharmacy items from their legacy system
Table Type: REFERENCE





Column Detail - BR_PHARM_PRODUCT_WORK


Column Name Type Null? Definition
ACQUISITION_COST DOUBLE N Acquisition cost for the product
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CHARGE_NBR VARCHAR(200) Y Charge identifier for the product
DESCRIPTION VARCHAR(60) N Description of the product
FACILITY_CD DOUBLE N Facility with which the product is associated
MATCH_IND DOUBLE N indicates if this product has been matched to a Multum item
MATCH_NDC VARCHAR(11) Y NDC of the item to which product was matched
MATCH_OPTION DOUBLE N data option chosen during the match
NDC VARCHAR(11) N National Drug Code of the product
UBC_IDENT VARCHAR(200) Y unit based cabinet identifier for the product
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_PHYS_EXPER_HISTORY



Column Section Top of Page


Table-level Detail

Description: Bedrock Physician Experience History
Definition: Stores the history of changes made to the physician experience preferences.
Table Type: REFERENCE





Column Detail - BR_PHYS_EXPER_HISTORY


Column Name Type Null? Definition
BR_PHYS_EXPER_HISTORY_ID DOUBLE N Unique, generated number that identifies a single row on the BR_PHYS_EXPER_HISTORY table.
NEW_VALUE VARCHAR(100) N The new value that was set for the preference.
POSITION_CD DOUBLE N The position that was updated.
PREFERENCE_NAME VARCHAR(100) N The preference name that was updated.
PREVIOUS_VALUE VARCHAR(100) N The previous value for the preference.
TOPIC_NAME VARCHAR(100) N The topic that was updated.
TRANSACTION_DT_TM DATETIME N The time that the update was made.
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.