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 |