Table Detail Report

PM_QUE_WORK_LIST_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Management Queue Work List Configuration
Definition: Stores the work list configuration for each logical domain.
Table Type: REFERENCE





Column Detail - PM_QUE_WORK_LIST_CONFIG


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE Y Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE Y The person who caused the active_status_cd to be set or change.
CONFIGURATION_BLOB LONGBLOB Y Contains the configurations value
LOGICAL_DOMAIN_ID DOUBLE Y The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PM_QUE_WORK_LIST_CONFIG_ID DOUBLE N Unique system generated number used to identify a single row on the PM_QUE_WORK_LIST_CONFIG table.
PM_QUE_WORK_LIST_ID DOUBLE Y PM Queue Work List ID from PM_QUE_WORK_LIST table to which the configuration is related.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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.



Relationship Detail - PM_QUE_WORK_LIST_CONFIG


Child Column in PM_QUE_WORK_LIST_CONFIG(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PM_QUE_WORK_LIST_ID PM_QUE_WORK_LIST WORK_LIST_ID


PM_RBC_LONG_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Management - Room and Board Charge Long Text
Definition: The PM_RBC_LONG_TEXT table stores long text information for room & bed charge process activity data.
Table Type: ACTIVITY





Column Detail - PM_RBC_LONG_TEXT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LONG_CLOB LONGTEXT Y Used to store the text for the long text identifier.
PARENT_ENTITY_ID DOUBLE N Used to store the identifier for the parent
PARENT_ENTITY_NAME VARCHAR(30) N Used to store the name for the parent
PM_RBC_LONG_TEXT_ID DOUBLE N Unique generated number that identifies a single row on the PM_RBC_LONG_TEXT table.
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.



Relationship Detail - PM_RBC_LONG_TEXT




Parent Column in PM_RBC_LONG_TEXT (PK) Child Table Name Child Column Name
Children: PM_RBC_LONG_TEXT_ID PM_RBC_RS_ENCNTR_R LOG_LONG_TEXT_ID
PM_RBC_RS_ENCNTR_R QUERY_LONG_TEXT_ID
PM_RBC_RUN LOG_LONG_TEXT_ID
PM_RBC_RUN_SET LOG_LONG_TEXT_ID
PM_RBC_RUN_SET QUERY_LONG_TEXT_ID


PM_RBC_PARM_SET_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Management Room and Bed Charge Parameter Set Relationship
Definition: This table stores information about the relationships between parameter sets and room and bed charge criteria.
Table Type: REFERENCE





Column Detail - PM_RBC_PARM_SET_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CREATE_DT_TM DATETIME N The date and time this row was inserted on the table.
CREATE_PRSNL_ID DOUBLE N The personnel ID of the person who created the row in the table
ENCNTR_TYPE_CD DOUBLE N Categorizes the encounter into a logical group or type. Examples may include inpatient, outpatient, etc.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LOC_FACILITY_CD DOUBLE N This field is the patient location with a location type of facility.
PM_RBC_PARM_SET_R_ID DOUBLE N Unique generated number that identifies a unique row on the PM_RBC_PARM_SET table.
RC_PARAMETER_SET_ID DOUBLE N This is the value of the unique primary identifier of the RC_PARAMETER_SET table. It is an internal system assigned number.
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.



Relationship Detail - PM_RBC_PARM_SET_R


Child Column in PM_RBC_PARM_SET_R(FK) Parent Table Name Parent Column Name
Parents: LOC_FACILITY_CD LOCATION LOCATION_CD
CREATE_PRSNL_ID PRSNL PERSON_ID
RC_PARAMETER_SET_ID RC_PARAMETER_SET RC_PARAMETER_SET_ID




Parent Column in PM_RBC_PARM_SET_R (PK) Child Table Name Child Column Name
Children: PM_RBC_PARM_SET_R_ID PM_RBC_RUN_SET PM_RBC_PARM_SET_R_ID


PM_RBC_RS_ENCNTR_CHARGE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Management - Room and Bed Charge Run Set Encounter Relationship
Definition: The PM_RBC_ENCNTR_CHARGE_R table stores information about each charge submitted in the execution of the room & bed charge process.
Table Type: ACTIVITY





Column Detail - PM_RBC_RS_ENCNTR_CHARGE_R


Column Name Type Null? Definition
ACCOMMODATION_CD DOUBLE N Current type of accommodations in which the patient (encounter) has been placed. (e.g. Private, Semi Private, etc.) For this table, it is the accommodation for the given service date/time, at the time of room & bed charge processing.
ACCOMMODATION_REQUEST_CD DOUBLE N Current type of accommodations in which the patient (encounter) has been placed. (e.g. Private, Semi Private, etc.) For this table, it is the accommodation for the given service date/time, at the time of room & bed charge processing.
ACTUAL_ACCOMMODATION_CD DOUBLE N The actual accommodation code used for this charge event during room & bed charge processing.
CEA_TYPE_CD DOUBLE N The charge event activity type associated with the transaction, such as COMPLETE or REVERSE.
CHARGE_TYPE_CD DOUBLE N Value from 13028 that represents whether the charge event is a debit, credit, etc.
ENCNTR_TYPE_CD DOUBLE N Categorizes the encounter into a logical group or type. Examples may include inpatient, outpatient, etc. For this table, it is the encounter type for the given service date/time, at the time of room & bed charge processing.
ENCNTR_TYPE_CLASS_CD DOUBLE N Encounter type class is used to categorize patients into more general groups than encounter type. (i.e., inpatient, outpatient, emergency, recurring outpatient). The values in this codeset all have Cerner defined meanings. For this table, it is the encounter type class for the given service date/time, at the time of room & bed charge processing.
EXT_EVENT_VALUE DOUBLE N Populates ext_m_event_id on charge reversals.
ITEM_QTY DOUBLE N The quantity the price should be multiplied by to arrive at the item_extended_price.
LOC_FACILITY_CD DOUBLE N This field is the current patient location with a location type of facility. For this table, it is the facility to which the patient was assigned for the given service date/time, at the time of room & bed charge processing.
PERF_LOC_CD DOUBLE N Value from codeset 220 that represents the location at which the services were provided.
PM_RBC_RS_ENCNTR_CHARGE_R_ID DOUBLE N This is the value of the unique primary identifier of the PM_RBC_RS_ENCNTR_CHARGE_R table. It is an internal system assigned number.
PM_RBC_RS_ENCNTR_R_ID DOUBLE N This is the value of the unique primary identifier of the PM_RBC_RS_ENCNTR_R table. It is an internal system assigned number.
SERVICE_DT_TM DATETIME Y The service date and time.
STATUS_CD DOUBLE N Indicates success/failure of charge event submission or status.
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.



Relationship Detail - PM_RBC_RS_ENCNTR_CHARGE_R


Child Column in PM_RBC_RS_ENCNTR_CHARGE_R(FK) Parent Table Name Parent Column Name
Parents: LOC_FACILITY_CD LOCATION LOCATION_CD
PERF_LOC_CD LOCATION LOCATION_CD
PM_RBC_RS_ENCNTR_R_ID PM_RBC_RS_ENCNTR_R PM_RBC_RS_ENCNTR_R_ID


PM_RBC_RS_ENCNTR_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Management - Room and Bed Charge Run Set Encounter Relationship
Definition: The PM_RBC_RUN_SET_ENCNTR_R table stores information about each encounter that qualified for each set in the execution of the room & bed charge process.
Table Type: ACTIVITY





Column Detail - PM_RBC_RS_ENCNTR_R


Column Name Type Null? Definition
CHARGE_EVENT_CNT DOUBLE N Count of charge events submitted for this encounter.
CHARGE_EVENT_FAIL_CNT DOUBLE N Count of charge events that failed for this encounter.
CHARGE_EVENT_SUCCESS_CNT DOUBLE N Count of charge events that succeeded for this encounter.
COMPLETE_DT_TM DATETIME Y Date/time the room & bed charge processing completed for this encounter.
DISCH_DT_TM DATETIME Y The actual date/time that the patient was discharged from the facility. For this table, it is the discharge date/time at the time the room & bed charge process was executed.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the ENCOUNTER table. It is an internal system assigned number.
FAILURE_REASON_CD DOUBLE N More detailed the reason the set is in a failed status.
INPATIENT_ADMIT_DT_TM DATETIME Y The date/time the patient was admitted as an inpatient. For this table, it is the inpatient admit date/time at the time the room & bed charge process was executed.
LOG_LONG_TEXT_ID DOUBLE N Stores the identifier of the row on the pm_rbc_long_text table containing the general logging text for the processing of this encounter during the execution of the room & bed charge process.
PM_RBC_RS_ENCNTR_R_ID DOUBLE N This is the value of the unique primary identifier of the PM_RBC_RS_ENCNTR table. It is an internal system assigned number.
PM_RBC_RUN_SET_ID DOUBLE N This is the value of the unique primary identifier of the PM_RBC_RUN_SET table. It is an internal system assigned number.
QUERY_LONG_TEXT_ID DOUBLE N Stores the identifier of the row on the pm_rbc_long_text table containing the encounter query text for this set in the execution of the room & bed charge process.
REG_DT_TM DATETIME Y The date/time that the registration or admission process was performed. For this table, it is the registration date/time at the time the room & bed charge process was executed.
START_DT_TM DATETIME Y Date/time the room & bed charge processing started for this encounter.
STATUS_CD DOUBLE N Overall status of this execution of the room & bed charge process.
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.



Relationship Detail - PM_RBC_RS_ENCNTR_R


Child Column in PM_RBC_RS_ENCNTR_R(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LOG_LONG_TEXT_ID PM_RBC_LONG_TEXT PM_RBC_LONG_TEXT_ID
QUERY_LONG_TEXT_ID PM_RBC_LONG_TEXT PM_RBC_LONG_TEXT_ID
PM_RBC_RUN_SET_ID PM_RBC_RUN_SET PM_RBC_RUN_SET_ID




Parent Column in PM_RBC_RS_ENCNTR_R (PK) Child Table Name Child Column Name
Children: PM_RBC_RS_ENCNTR_R_ID PM_RBC_RS_ENCNTR_CHARGE_R PM_RBC_RS_ENCNTR_R_ID