Table Detail Report
PM_OFFER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Patient Management |
Definition: | Contains a list of offers for an encounter. A refused offer is written when the patient refuses an offered available date for an appointment and an accepted offer is written when the patient accepts an offered available date for an appointment. |
Table Type: | ACTIVITY |
Column Detail - PM_OFFER
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. |
ADMIT_OFFER_OUTCOME_CD | DOUBLE | N | The outcome of the admission offer. |
APPT_DT_TM | DATETIME | Y | The date time of the appointment associated with the offer. |
ARRIVED_ON_TIME_IND | DOUBLE | N | An indicator representing whether the patient arrived on time for their appointment or not. |
ATTENDANCE_CD | DOUBLE | N | The type of attendance. |
CANCEL_DT_TM | DATETIME | Y | The date time if the offer is cancelled. |
DNA_DT_TM | DATETIME | Y | The date time if the patient did not arrive. |
ENCNTR_ID | DOUBLE | N | The encounter that the offer is written for. |
MEDICAL_STAFF_TYPE_CD | DOUBLE | N | Identifies the type of medical staff |
OFFER_DT_TM | DATETIME | Y | Offer_dt_tm is the date/time that the offer was made for. So if yesterday morning I offered a patient an appointment on May 5th at 8:00, my offer_made_dt_tm would be 4/15/2009 11:15am and my offer_dt_tm would be 5/5/2009 8:00am. |
OFFER_MADE_DT_TM | DATETIME | Y | The date and time the offer was made or refused. So if yesterday morning I offered a patient an appointment on May 5th at 8:00, my offer_made_dt_tm would be 4/15/2009 11:15am and my offer_dt_tm would be 5/5/2009 8:00am. |
OFFER_TYPE_CD | DOUBLE | N | The Type of Offer that was recorded (accepted, refused, etc.). |
OUTCOME_OF_ATTENDANCE_CD | DOUBLE | N | The outcome of the Attendance. |
PAT_INITIATED_IND | DOUBLE | N | Indicator to note whether or not the patient initiated the offer date. |
PIFU_EXPIRY_DT_TM | DATETIME | Y | Specifies the date by which a patient initiated follow up pathway will expire |
PIFU_OUTCOME_CD | DOUBLE | Y | Specifies the outcome of a patient initiated follow up pathway |
PIFU_PATHWAY_IND | DOUBLE | Y | Specifies whether there is a patient initiated follow up pathway present for the offer |
PIFU_REVIEW_DT_TM | DATETIME | Y | Specifies the date by which a patient initiated follow up pathway needs to be reviewed |
PM_OFFER_ID | DOUBLE | N | This is the value of the unique primary identifier of the offer table. It is an internal system assigned number. |
REASONABLE_OFFER_IND | DOUBLE | N | An indicator representing whether or not the offer was considered reasonable. |
REMOVE_FROM_WL_IND | DOUBLE | N | An indicator representing whether this offer should trigger the patient to be removed from the waitlist. |
SCHEDULE_ID | DOUBLE | N | The Schedule that this offer represents. |
SCH_REASON_CD | DOUBLE | N | The Reason for the latest change to the appointment associated to the offer. Could be the Cancel reason, the Reschedule reason, or the DNA reason. |
TCI_DT_TM | DATETIME | Y | The date and time the patient should arrive. |
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. |
WL_REASON_FOR_REMOVAL_CD | DOUBLE | N | The reason the patient should be removed from the waitlist. |
WL_REMOVAL_DT_TM | DATETIME | Y | The date and time for the removal from the waitlist. |
Relationship Detail - PM_OFFER
Child Column in PM_OFFER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
SCHEDULE_ID | SCH_SCHEDULE | SCHEDULE_ID |
Parent Column in PM_OFFER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PM_OFFER_ID | PM_OFFER_HIST | PM_OFFER_ID |
PM_OFFER_PROC_RELTN | PM_OFFER_ID |
PM_OFFER_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Patient Management Offer History |
Definition: | Contains the transactional history of a list of offers for an encounter. All columns, except offer_hist_id, create_dt_tm, and the updt_* columns, are representing a snapshot of the pm_offer table, including the active_* columns. |
Table Type: | ACTIVITY |
Column Detail - PM_OFFER_HIST
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. |
ADMIT_OFFER_OUTCOME_CD | DOUBLE | N | The outcome of the admission offer. |
APPT_DT_TM | DATETIME | Y | The date time of the appointment associated with the offer. |
ARRIVED_ON_TIME_IND | DOUBLE | N | An indicator representing whether the patient arrived on time for their appointment or not. |
ATTENDANCE_CD | DOUBLE | N | The type of attendance. |
CANCEL_DT_TM | DATETIME | Y | The date time if the offer is cancelled. |
CREATE_DT_TM | DATETIME | N | The date and time that the history row was created. |
DNA_DT_TM | DATETIME | Y | The date time if the patient did not arrive. |
ENCNTR_ID | DOUBLE | N | The encounter that the offer is written for. |
MEDICAL_STAFF_TYPE_CD | DOUBLE | N | Identifies the type of medical staff |
OFFER_DT_TM | DATETIME | Y | Offer_dt_tm is the date/time that the offer was made for. So if yesterday morning I offered a patient an appointment on May 5th at 8:00, my offer_made_dt_tm would be 4/15/2009 11:15am and my offer_dt_tm would be 5/5/2009 8:00am. |
OFFER_MADE_DT_TM | DATETIME | Y | The date and time the offer was made or refused. |
OFFER_TYPE_CD | DOUBLE | N | The Type of Offer that was recorded (accepted, refused, etc.). |
OUTCOME_OF_ATTENDANCE_CD | DOUBLE | N | The outcome of the Attendance. |
PAT_INITIATED_IND | DOUBLE | N | Indicator to note whether or not the patient initiated the offer date. |
PIFU_EXPIRY_DT_TM | DATETIME | Y | Specifies the date by which a patient initiated follow up pathway will expire. |
PIFU_OUTCOME_CD | DOUBLE | Y | Specifies the outcome of a patient initiated follow up pathway |
PIFU_PATHWAY_IND | DOUBLE | Y | Specifies whether there is a patient initiated follow up pathway present for the offer |
PIFU_REVIEW_DT_TM | DATETIME | Y | Specifies the date by which a patient initiated follow up pathway needs to be reviewed |
PM_OFFER_HIST_ID | DOUBLE | N | This is the value of the unique primary identifier of the offer hist table. It is an internal system assigned number. |
PM_OFFER_ID | DOUBLE | N | The ID of the offer the history is related to. |
REASONABLE_OFFER_IND | DOUBLE | N | An indicator representing whether or not the offer was considered reasonable. |
REMOVE_FROM_WL_IND | DOUBLE | N | An indicator representing whether this offer should trigger the patient to be removed from the waitlist. |
SCHEDULE_ID | DOUBLE | N | The Schedule that this offer represents. |
SCH_REASON_CD | DOUBLE | N | The Reason for the latest change to the appointment associated to the offer. Could be the Cancel reason, the Reschedule reason, or the DNA reason. |
TCI_DT_TM | DATETIME | Y | The date and time the patient should arrive. |
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. |
WL_REASON_FOR_REMOVAL_CD | DOUBLE | N | The reason the patient should be removed from the waitlist. |
WL_REMOVAL_DT_TM | DATETIME | Y | The date and time for the removal from the waitlist. |
Relationship Detail - PM_OFFER_HIST
Child Column in PM_OFFER_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PM_OFFER_ID | PM_OFFER | PM_OFFER_ID |
PM_PSO_LINK
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Patient Management Patient Status Orders Link |
Definition: | A temporary staging table to hold orders transaction data to work around limitations within Orders physician selection UI and EKM/Discern's ability to modify order details during the sign order event. |
Table Type: | ACTIVITY |
Column Detail - PM_PSO_LINK
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. |
CREATE_DT_TM | DATETIME | Y | This is the date and time that the row was created. |
LINK_STATUS_CD | DOUBLE | N | Contains the value of the status of the link. |
OE_FIELD_DISPLAY_VALUE | VARCHAR(255) | Y | The display value of the order detail. |
OE_FIELD_DT_TM_VALUE | DATETIME | Y | The date and time value of the field if of type date/time. |
OE_FIELD_ID | DOUBLE | N | The id of the field. |
OE_FIELD_MEANING | VARCHAR(25) | Y | The meaning of the field. |
OE_FIELD_MEANING_ID | DOUBLE | N | The Cerner controlled value that id's the meaning of the field. |
OE_FIELD_VALUE | DOUBLE | Y | The value of the field if a numeric or coded value. |
ORDER_ID | DOUBLE | N | The id of the order. |
PM_PSO_LINK_ID | DOUBLE | N | Unique generated number that identifies a single row on the PM_PSO_LINK 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_PSO_LINK
Child Column in PM_PSO_LINK(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OE_FIELD_MEANING_ID | OE_FIELD_MEANING | OE_FIELD_MEANING_ID |
ORDER_ID | ORDERS | ORDER_ID |
PM_TRANSFER_ENCNTR_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter/transfer relationship. |
Definition: | This table is used to record the transfer of an encounter prsnl reltation from one prsnl to another. This information can then be used to undo the transfer. |
Table Type: | ACTIVITY |
Column Detail - PM_TRANSFER_ENCNTR_RELTN
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. |
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. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
ENCNTR_PRSNL_R_CD | DOUBLE | N | Encounter personnel relationship code identifies the type of relationship between the prsnl and the encounter. (For Example: Attending Physician, Admitting Physician, 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. |
PM_TRANSFER_ENCNTR_RELTN_ID | DOUBLE | N | This is the value of the unique primary identifier of the pm_transfer_encntr_reltn table. It is an internal system assigned number. |
PRSNL_PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the prsnl table. It is an internal system assigned number. |
TRANSFER_PRSNL_PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the prsnl table. It is an internal system assigned 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 - PM_TRANSFER_ENCNTR_RELTN
Child Column in PM_TRANSFER_ENCNTR_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PRSNL_PERSON_ID | PRSNL | PERSON_ID | |
TRANSFER_PRSNL_PERSON_ID | PRSNL | PERSON_ID |
PM_WAIT_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Mgmt Wait list table. |
Definition: | Person Mgmt: Wait list information |
Table Type: | ACTIVITY |
Column Detail - PM_WAIT_LIST
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 | 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. |
ADJ_WAITING_START_DT_TM | DATETIME | Y | The current adjusted waiting start date and time for an encounter. |
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 | Type of waiting list admission. (ex. Day case, inpatient) |
ANESTHETIC_CD | DOUBLE | N | Waiting list anesthetic code (ex. Local anesthetic, epidural) |
APPOINTMENT_CD | DOUBLE | N | Did the patient have an appointment. |
APPT_LOCATION_CD | DOUBLE | N | Location where appointment is scheduled to |
APPT_SYNONYM_CD | DOUBLE | N | Synonym used to schedule appointment. What the appointment is for. |
APPT_TYPE_CD | DOUBLE | N | What the appointment is for. Examples are 'MRI Knee', 'Ortho Consult', etc. |
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. |
CHG_DT_TM | DATETIME | Y | Date and time change was made. |
CHG_ID | DOUBLE | N | ID of person who made change. |
COMMENT_LONG_TEXT_ID | DOUBLE | N | Waiting list comments |
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. |
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_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. |
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 | The wait list management code. Some examples are 'No overnight stay required', 'Panned admission - With overnight'. |
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 | The date and time of the pending acceptance. |
PEND_NOTIFICATION_DT_TM | DATETIME | Y | The date and time of the pending notification. |
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_WAIT_LIST_ID | DOUBLE | N | This is the unique identifier for a wait list row. |
PREV_PROV_ADMIT_DT_TM | DATETIME | Y | The date and time of the admission of the previous provider. |
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. |
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 | The source of the referral. |
REFERRAL_TYPE_CD | DOUBLE | N | The type of referral. |
REMOVAL_DT_TM | DATETIME | Y | Date/Time that a person was removed from the wait list. |
REQUESTED_DT_TM | DATETIME | Y | Represent requested date/time if waitlist encounter in requested state |
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. |
RESOURCE_CD | DOUBLE | N | Primary resource the appointment was scheduled with. |
SCHEDULE_DT_TM | DATETIME | Y | Represents scheduled date/time if event is scheduled. |
SCH_EVENT_ID | DOUBLE | N | Link wait list encounter to scheduling event (appt) |
SERVICE_TYPE_REQUESTED_CD | DOUBLE | N | The 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 | The end date and time of the status. |
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. |
SUSPENDED_DAYS | DOUBLE | N | Total number of days suspended. |
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. |
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. |
WAITING_END_DT_TM | DATETIME | Y | The current actual waiting end date and time for an encounter. |
WAITING_START_DT_TM | DATETIME | Y | The current actual waiting start date and time for an encounter. |
WAIT_LIST_IND | DOUBLE | Y | Indicator to show the conversation type. |
Relationship Detail - PM_WAIT_LIST
Child Column in PM_WAIT_LIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | 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 | |
SCH_EVENT_ID | SCH_EVENT | SCH_EVENT_ID |
Parent Column in PM_WAIT_LIST (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PM_WAIT_LIST_ID | PM_WAIT_LIST_HIST | PM_WAIT_LIST_ID |
PM_WAIT_LIST_STATUS | PM_WAIT_LIST_ID |