Table Detail Report

PM_WAIT_LIST_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Management Wait List History
Definition: Person Mgmt: History of wait list information
Table Type: ACTIVITY





Column Detail - PM_WAIT_LIST_HIST


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.)
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.
ADMITTING_PRSNL_ID DOUBLE N This is a key from the Personnel(PRSNL) table. It is the personnel that admitted the patient.
ADMIT_BOOKING_CD DOUBLE N The admission booking type. Examples are full booking, partial booking, etc.
ADMIT_CATEGORY_CD DOUBLE N Admission or administrative category of the wait list. An example would be 'private'. or 'NHS'.
ADMIT_DECISION_DT_TM DATETIME Y Date and time the decision to admit was made
ADMIT_GUARANTEED_DT_TM DATETIME Y The guaranteed admission date and time.
ADMIT_OFFER_OUTCOME_CD DOUBLE N Outcome of waiting list admission (ex. patient admitted and treated, patient admitted and suspended, Another appointment given).
ADMIT_TYPE_CD DOUBLE N Admit type indicates the circumstance under which the patient was admit or will be admitted. (i.e., accident, emergent, routine, elective, labor/delivery, etc.)
ANESTHETIC_CD DOUBLE N Waiting list anesthetic code (ex. Local anesthetic, epidural)
APPOINTMENT_CD DOUBLE N Did the patient have an appointment.
ATTENDANCE_CD DOUBLE N Attendance record of the appontment. Such as 'on time', 'arrived late', etc.
ATTENDDOC_CLINICAL_SERVICE_CD DOUBLE N Attending physician's default clinical service code.
AUTO_BLOOD_IND DOUBLE Y Indicate if the current encounter has autologous blood donation.
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.
CANCER_REFERRAL_CD DOUBLE N The Cancer Referral Code describes whether the referral is a cancer referral.
CHANGE_2_BIT DOUBLE N Identifies which columns have had a change.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
CHG_DT_TM DATETIME Y Date and time change was made.
CHG_ID DOUBLE N ID of person making change.
COMMENTS_RE_DISCHARGE VARCHAR(255) Y Text comments for a discharge.
COMMISSIONER_REFERENCE VARCHAR(50) Y Commissioner reference identifier.
CONTRACT_STATUS_CD DOUBLE N Codified field indicating status of a care contract.
DECLINE_STATUS_CD DOUBLE N Field contains a code value that contains a textual reason for a decline.
DECLINE_STATUS_DT_TM DATETIME Y Date and Time Decline Status was set.
DELAY_STATUS_CD DOUBLE N Field that contains a code that refers to a text description of the reason a delay status occurred.
DELAY_STATUS_DT_TM DATETIME Y Date/Time that a delay status was set.
DIAGNOSIS_ID DOUBLE N Patient's diagnosis. This is a key field in the Diagnosis table.
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 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.
EST_ADMIT_DT_TM DATETIME Y Estimated Date/Time that a person on the wait list will be admitted.
EST_ARRIVE_DT_TM DATETIME Y Estimated Patient Arrival.
EST_LENGTH_PROCEDURE_CD DOUBLE N Field that contains a code the refers to a length of time. For example, 10 Mins, 15 Mins, etc.
FINANCIAL_CLASS_CD DOUBLE N The financial classification used for a given encounter. Examples may include Worker's Comp, Self Pay, etc.
FINANCIAL_CLASS_EFF_DT_TM DATETIME Y The date/time that a financial class becomes effective.
FROM_ED_IND DOUBLE N Indicates whether this encounter was transferred from the emergency department.
FUNCTIONAL_DEFICIENCY_CAUSE_CD DOUBLE N The primary presenting cause of functional deficiency.
FUNCTIONAL_DEFICIENCY_CD DOUBLE N Function to be restored, by reference to the affected part of the body, which is the subject of the particular wait list record.
HIST_ACTION VARCHAR(3) N Action taken. Example: UPT, RMV
LAST_DNA_DT_TM DATETIME Y Last date and time a DNA was recorded for a waiting list entry
LOCATION_CD DOUBLE N The field contains a code that identifies the current permanent location of the patient.
LOC_BED_CD DOUBLE N This field is the code value for a current patient location with a location type of bed.
LOC_BUILDING_CD DOUBLE N This field is the code value for the current patient location with a location type of building.
LOC_FACILITY_CD DOUBLE N This field is the code value for the current patient location with a location type of facility.
LOC_NURSE_UNIT_CD DOUBLE N This field is the code value for the current patient location with a location type of Nurse Unit.
LOC_ROOM_CD DOUBLE N This field is the code value for the current patient location with a location type of Room.
MANAGEMENT_CD DOUBLE N Intended management.
MED_SERVICE_CD DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be of treatment type, surgery, general resources, or others.
NCEPOD_CD DOUBLE N The NCEPOD (National Confidential Enquiry into Patient Outcome and Death) Classification categorizes the urgency of the patient's intervention.
OPERATION_CD DOUBLE N Waiting list operation code (ex. One or more operative procedure carried out, . no operative procedures performed or intended)
ORIG_REQUEST_RECEIVED_DT_TM DATETIME Y Original date and time that the wait list request was received.
OTHER_MED_CONDITION VARCHAR(40) Y Text description of a medical condition.
PEND_ACCEPTANCE_DT_TM DATETIME Y Pending Acceptance Date and Time.
PEND_NOTIFICATION_DT_TM DATETIME Y Pending Notification date and time.
PEND_PLACE_PRIORITY_CD DOUBLE N The level of importance in bed assignment activity in relation to other encounters.
PEND_PLACE_PRIORITY_DT_TM DATETIME Y The level date and time when the pending location placement priority was set.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PLANNED_ADMIT_DT_TM DATETIME Y The date/time a patient is planned to be admitted.
PLANNED_OPERATION_CD DOUBLE N A field containing a code value that represents a planned operation.
PLANNED_PROCEDURE_CD DOUBLE N The code value for the planned Procedure for this wait list row.
PLANNED_PROCEDURE_DT_TM DATETIME Y The date/time the procedure is planned to occur.
PM_HIST_TRACKING_ID DOUBLE N This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
PM_WAIT_LIST_HIST_ID DOUBLE N This is the unique identifier for a wait list history row.
PM_WAIT_LIST_ID DOUBLE N This is a primary key from the PM_WAIT_LIST table. It is a unique identifier of a wait list row.
PREV_PROV_ADMIT_DT_TM DATETIME Y Previous provider's admission date and time
PRE_ADMIT_ATTEND_IND DOUBLE Y Indicates whether the attending physician performed the pre admit.
PRE_ADMIT_CLIN_APPT_DT_TM DATETIME Y Date/Time an appointment was set before admit.
PROCEDURE_ID DOUBLE N Procedure id is the primary unique identification number of the procedure table. It is an internal system assigned sequence number.
PROVISIONAL_ADMIT_DT_TM DATETIME Y Date/Time the provisional admit was made.
REASON_FOR_CHANGE_CD DOUBLE N Code value for a text description of the reason a change was made.
REASON_FOR_REMOVAL VARCHAR(255) Y A text description of the reason a removal was made.
REASON_FOR_REMOVAL_CD DOUBLE N Code value for a text description of the reason a removal was made.
RECOMMEND_DT_TM DATETIME Y The date/time that removal,etc. was recommended.
REFERRAL_DT_TM DATETIME Y The date and time of the referral.
REFERRAL_REASON_CD DOUBLE N The resaon for the referral.
REFERRAL_SOURCE_CD DOUBLE N Source of referral.
REFERRAL_TYPE_CD DOUBLE N Referral type.
REMOVAL_DT_TM DATETIME Y Date/Time that a person was removed from the wait list.
REQUESTED_LOCATION_CD DOUBLE N Code value representing the location a patient on the wait list requested to be moved to.
RESCHD_APPT_BY_DT_TM DATETIME Y The guaranteed date that the appoinment will be rescheduled by.
SERVICE_TYPE_REQUESTED_CD DOUBLE N Service type requested.
STAND_BY_CD DOUBLE N Code Value that contains a text description of a wait list stand by.
STATUS_CD DOUBLE N Code value that refers to the status of a wait list row. Examples: Normal, Deferred.
STATUS_DETAIL_CD DOUBLE N This code value represents further detail on the main wait list status.
STATUS_DT_TM DATETIME Y The date/time a status was set.
STATUS_END_DT_TM DATETIME Y Status end date time.
STATUS_REVIEW_CD DOUBLE N Code value for status of a wait list review.
STATUS_REVIEW_DT_TM DATETIME Y The date/time that a wait list status was reviewed.
SUB_STATUS_CD DOUBLE N The code value that identifies the sub status of a wait list row. Some examples are Waiting, Cancelled, Deferred, Removed, etc.
SUPRA_SERVICE_REQUEST_CD DOUBLE N The type of supra service request.
TRACKING_2_BIT DOUBLE N Identifies which columns are being tracked for history.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME Y Date and time the transaction, which triggered the history row, occurred. This field can be system assigned or manually manipulated by users.
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.
URGENCY_CD DOUBLE N Code Value for the urgency of patient event on wait list. Example: within 7 days.
URGENCY_DT_TM DATETIME Y The date/time an urgency field was declared for a wait list row.
WAIT_LIST_IND DOUBLE Y Indicator to show the conversation type.



Relationship Detail - PM_WAIT_LIST_HIST


Child Column in PM_WAIT_LIST_HIST(FK) Parent Table Name Parent Column Name
Parents: DIAGNOSIS_ID DIAGNOSIS DIAGNOSIS_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
LOCATION_CD LOCATION LOCATION_CD
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
PERSON_ID PERSON PERSON_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID
PM_WAIT_LIST_ID PM_WAIT_LIST PM_WAIT_LIST_ID
PROCEDURE_ID PROCEDURE PROCEDURE_ID


PM_WAIT_LIST_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person management waiting list status
Definition: Stores the status time periods that a waiting list entry will go through.
Table Type: ACTIVITY





Column Detail - PM_WAIT_LIST_STATUS


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.
COMMENT_LONG_TEXT_ID DOUBLE N Status comments.
PM_WAIT_LIST_ID DOUBLE N This is the unique identifier of the pm_wait_list table that linked to this future status change.
PM_WAIT_LIST_STATUS_ID DOUBLE N Unique identifier for the table.
REASON_FOR_CHANGE_CD DOUBLE N Code value for a text description of the reason a change was made
STATUS_CD DOUBLE N Code value that refers to the status of a wait list row. examples: normal, deferred
STATUS_DT_TM DATETIME N Date/Time that the status began or should begin
STATUS_END_DT_TM DATETIME N Date/Time that the status change ended or should end.
STATUS_REVIEW_DT_TM DATETIME Y This column will be used to add suspension review date on the suspension view.
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_WAIT_LIST_STATUS


Child Column in PM_WAIT_LIST_STATUS(FK) Parent Table Name Parent Column Name
Parents: COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PM_WAIT_LIST_ID PM_WAIT_LIST PM_WAIT_LIST_ID


SERVICE_CATEGORY_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Service Catagory History
Definition: Records history of Service Catagory changes
Table Type: ACTIVITY





Column Detail - SERVICE_CATEGORY_HIST


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.
ATTEND_PRSNL_ID DOUBLE Y The personnel IDof the attending doc from the encntr_prsnl_reltn table.
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.
MED_SERVICE_CD DOUBLE Y The type or category of medical service that the patient is receiving in relation to their encounter. The category may be of treatment type, surgery, general resources, or others.
SERVICE_CATEGORY_CD DOUBLE Y Codified field which identifies the current category of service the patient is receiving.
SVC_CAT_HIST_ID DOUBLE N Unique Identifier for this table.
TRANSACTION_DT_TM DATETIME Y Date and Time the transaction was processed
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 - SERVICE_CATEGORY_HIST


Child Column in SERVICE_CATEGORY_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in SERVICE_CATEGORY_HIST (PK) Child Table Name Child Column Name
Children: SVC_CAT_HIST_ID ABSTRACTING SVC_CAT_HIST_ID
ABSTRACT_DATA SVC_CAT_HIST_ID
ABST_CODING_RELTN SVC_CAT_HIST_ID
CAC_DOCUMENT SVC_CAT_HIST_ID
CODING SVC_CAT_HIST_ID
CODING_AUDIT SVC_CAT_HIST_ID
CODING_HIST SVC_CAT_HIST_ID
CODING_SPECIALTY SVC_CAT_HIST_ID
DIAGNOSIS SVC_CAT_HIST_ID
DIAGNOSIS_HIST SVC_CAT_HIST_ID
DRG SVC_CAT_HIST_ID
DRG_ENCNTR_EXTENSION SVC_CAT_HIST_ID
DRG_SPECIALTY SVC_CAT_HIST_ID
EEM_BENEFIT_ALLOC SVC_CAT_HIST_ID
NOMENCLATURE_ENCNTR_DESC SVC_CAT_HIST_ID
PROCEDURE SVC_CAT_HIST_ID
PROCEDURE_HIST SVC_CAT_HIST_ID


SERVICE_TYPE_GROUPING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Service Type Grouping
Definition: Represents the groupings of encounter type codes or appointment type codes to service type codes for Insurance Eligibility transactions.
Table Type: REFERENCE





Column Detail - SERVICE_TYPE_GROUPING


Column Name Type Null? Definition
LOGICAL_DOMAIN_ID DOUBLE N The logical domain id for which the grouping applies.
PARENT_CD DOUBLE N The encounter type code value or appointment type code value that is related to the service type. Must be a value from code set 71 or 14230.
PARENT_CODE_SET DOUBLE N The code set of the parent_cd. Either 71 or 14230.
PRIORITY_SEQ DOUBLE N The priority of the service_type_grouping row for a given parent_cd and logical_domain_id.
SERVICE_TYPE_CD DOUBLE N The requested eligibility service type .
SERVICE_TYPE_GROUPING_ID DOUBLE N The unique primary key of this table. It is an internally generated number.
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 - SERVICE_TYPE_GROUPING


Child Column in SERVICE_TYPE_GROUPING(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID