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. |