Table Detail Report

PM_RBC_RUN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Management Room and Bed Charge Run
Definition: The PM_RBC_RUN table stores information about each execution of the room & bed charge process.
Table Type: ACTIVITY





Column Detail - PM_RBC_RUN


Column Name Type Null? Definition
COMPLETE_DT_TM DATETIME Y Date and time the room and bed charge process execution completed.
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 this execution of the room & bed charge process.
PM_RBC_RUN_ID DOUBLE N Unique generated number that identifies a single row on the PM_RBC_RUN table.
RDB_HANDLE_NBR DOUBLE N A unique identifier (handle) for database session used to execute run.
RUN_MODE_CD DOUBLE N Mode of execution for this instance of the room & bed charge process.
RUN_TZ DOUBLE N Time zone associated with this execution of the room & bed charge process.
SERVICE_DT_TM DATETIME Y Date of service for which the room & bed charge process was executed.
START_DT_TM DATETIME Y Date and time the room & bed charge process execution started.
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_RUN


Child Column in PM_RBC_RUN(FK) Parent Table Name Parent Column Name
Parents: LOG_LONG_TEXT_ID PM_RBC_LONG_TEXT PM_RBC_LONG_TEXT_ID




Parent Column in PM_RBC_RUN (PK) Child Table Name Child Column Name
Children: PM_RBC_RUN_ID PM_RBC_RUN_SET PM_RBC_RUN_ID


PM_RBC_RUN_SET



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PM_RBC_RUN_SET


Column Name Type Null? Definition
CHARGE_EVENT_CNT DOUBLE N Count of charge events submitted in this set.
CHARGE_EVENT_FAIL_CNT DOUBLE N Count of charge events that failed in this set.
CHARGE_EVENT_SUCCESS_CNT DOUBLE N Count of charge events that succeeded in this set.
COMPLETE_DT_TM DATETIME Y Date/time room & bed charge process execution completed.
ENCNTR_CNT DOUBLE N Count of encounters that qualified for this set.
ENCNTR_FAIL_CNT DOUBLE N Count of encounters that failed in this set.
ENCNTR_SUCCESS_CNT DOUBLE N Count of encounters that succeeded in this set.
FAILURE_REASON_CD DOUBLE N More detailed the reason the set is in a failed status.
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 this set in the execution of the room & bed charge process.
PM_RBC_PARM_SET_R_ID DOUBLE N This is the value of the unique primary identifier of the PM_RBC_PARM_SET_R table. It is an internal system assigned number.
PM_RBC_RUN_ID DOUBLE N This is the value of the unique primary identifier of the PM_RBC_RUN 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.
START_DT_TM DATETIME Y Date/time room & bed charge process execution started.
STATUS_CD DOUBLE N Overall status of this set in the 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_RUN_SET


Child Column in PM_RBC_RUN_SET(FK) Parent Table Name Parent Column Name
Parents: 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_PARM_SET_R_ID PM_RBC_PARM_SET_R PM_RBC_PARM_SET_R_ID
PM_RBC_RUN_ID PM_RBC_RUN PM_RBC_RUN_ID




Parent Column in PM_RBC_RUN_SET (PK) Child Table Name Child Column Name
Children: PM_RBC_RUN_SET_ID PM_RBC_RS_ENCNTR_R PM_RBC_RUN_SET_ID


PM_ROOM_BED_CHARGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Room Bed Charge Table
Definition: This table is stores information about a person and encounter that is used to calculate room and bed charges.
Table Type: ACTIVITY





Column Detail - PM_ROOM_BED_CHARGE


Column Name Type Null? Definition
ACCOMMODATION_CD DOUBLE N Defines Accommodation level of encounter
ACCOMMODATION_REQUEST_CD DOUBLE N Requested accommodation level which can differ from actual accommodation level assigned
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 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 Y 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 Y 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.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_EFFECTIVE_DT_TM DATETIME Y 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_BED_CD DOUBLE N The code_value for the bed in which the patient is located.
LOC_BUILDING_CD DOUBLE N The code value for the building at which the patient is located.
LOC_FACILITY_CD DOUBLE N The code value for the facility at which the patient is located.
LOC_NURSE_UNIT_CD DOUBLE N The code value for the Location Nurse Unitat which the patient is located.
LOC_ROOM_CD DOUBLE N The code_value representing the room in which the patient is located.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
ROOM_BED_CHARGE_ID DOUBLE N Unique Identifier for PM_ROOM_BED_CHARGE Table
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.



Relationship Detail - PM_ROOM_BED_CHARGE


Child Column in PM_ROOM_BED_CHARGE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LOC_BED_CD LOCATION LOCATION_CD
LOC_BUILDING_CD LOCATION LOCATION_CD
LOC_FACILITY_CD LOCATION LOCATION_CD
LOC_NURSE_UNIT_CD LOCATION LOCATION_CD
LOC_ROOM_CD LOCATION LOCATION_CD
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID


PM_RPT_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM RPT BATCH
Definition: Batch reporting table for Person Management
Table Type: REFERENCE





Column Detail - PM_RPT_BATCH


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.
BATCH_DESCRIPTION CHAR(100) Y Free-text description of the defined batch of Person Management Reports
BATCH_ID DOUBLE N Primary Key attribute
BATCH_NAME CHAR(20) N Name of the batch defined for Person Management Reporting
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
DATA_STATUS_CD DOUBLE Y Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE Y The person who caused the data_status_cd to be set or change.
END_EFFECTIVE_DT_TM DATETIME Y 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.
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.



Relationship Detail - PM_RPT_BATCH




Parent Column in PM_RPT_BATCH (PK) Child Table Name Child Column Name
Children: BATCH_ID PM_RPT_BATCH_PARAMS BATCH_ID


PM_RPT_BATCH_PARAMS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM RPT BATCH PARAMS
Definition: Batch parameters table for Person Management
Table Type: REFERENCE





Column Detail - PM_RPT_BATCH_PARAMS


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.
BATCH_ID DOUBLE Y Foreign Key to the PM_RPT_BATCH table used in Person Management Reporting
BATCH_PARAMS_ID DOUBLE N Primary Key attribute
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
COPIES DOUBLE Y Number of copies to print for a particular report in a specific batch
DATA_STATUS_CD DOUBLE Y Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE Y The person who caused the data_status_cd to be set or change.
END_EFFECTIVE_DT_TM DATETIME Y 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.
OUTPUT_DEST_CD DOUBLE Y The output destination (printer) for this batch report
REPORT_ID DOUBLE N Foreign Key attribute to the PM_RPT_REPORT table used in Person Management Reporting
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.



Relationship Detail - PM_RPT_BATCH_PARAMS


Child Column in PM_RPT_BATCH_PARAMS(FK) Parent Table Name Parent Column Name
Parents: BATCH_ID PM_RPT_BATCH BATCH_ID
REPORT_ID PM_RPT_REPORT REPORT_ID