Table Detail Report

SCH_PEND_APPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Schedule Pending Appointment
Definition: Stores information to the pending appointment scheduled from patient portal.
Table Type: ACTIVITY





Column Detail - SCH_PEND_APPT


Column Name Type Null? Definition
APPLY_SLOT_ID DOUBLE N The unique identifier for the applied slot.
APPT_SYNONYM_CD DOUBLE N The identifier for an appointment type synonym.
APPT_TYPE_CD DOUBLE N The identifier for an appointment type.
BEG_DT_TM DATETIME N Begin Date and Time value
BOOKING_ID DOUBLE N The unique identifier for a resource availability lock.
CLEANUP_DURATION DOUBLE Y The duration for patient recovery or resource (such as room) clean up.
CREATE_DT_TM DATETIME N Create Date and Time value.
DURATION DOUBLE N The duration in minutes.
END_DT_TM DATETIME N End Date and Time value.
EXPIRE_DT_TM DATETIME N The date and time that the booking_id will expire.
LIST_ROLE_ID DOUBLE N The identifier for the list role.
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient.
PERSON_ID DOUBLE N The person that the appointment is for.
PRIMARY_ROLE_IND DOUBLE N Designated the resource's appointment role as the primary role for the appointment.
RESOURCE_CD DOUBLE N The identifier for the resource. A resource is an item of limited availability.
RESOURCE_MNEMONIC VARCHAR(100) Y A 100-character string used for identification and selection.
ROLE_DESCRIPTION VARCHAR(200) Y The description of the role on the resource list.
ROLE_MEANING VARCHAR(12) Y A 12-character description corresponding to the scheduling role.
ROLE_SEQ DOUBLE N The order of the role on the resource list.
SCH_PEND_APPT_ID DOUBLE N Unique generated number that identifies a single row on the SCH_PEND_APPT table.
SCH_PEND_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment.
SCH_ROLE_CD DOUBLE N The coded identifier for the scheduling role.
SETUP_DURATION DOUBLE Y The duration for patient arrival or resource (such as room) set up.
SLOT_MNEMONIC VARCHAR(100) Y A 100-character string used for identification and selection.
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 - SCH_PEND_APPT


Child Column in SCH_PEND_APPT(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
PERSON_ID PERSON PERSON_ID
BOOKING_ID SCH_BOOKING BOOKING_ID
LIST_ROLE_ID SCH_LIST_ROLE LIST_ROLE_ID




Parent Column in SCH_PEND_APPT (PK) Child Table Name Child Column Name
Children: SCH_PEND_APPT_ID SCH_PEND_WARNING SCH_PEND_APPT_ID


SCH_PEND_ENCNTR_AUTH_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Pend Encounter Authorization Relationship
Definition: Defines a relationship between the sch_pend_encntr_detail table and the authorization table.
Table Type: ACTIVITY





Column Detail - SCH_PEND_ENCNTR_AUTH_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.
AUTHORIZATION_ID DOUBLE N Uniquely identifies the related authorization.
SCH_PEND_ENCNTR_AUTH_RELTN_ID DOUBLE N Uniquely identifies a relationship between the sch_pend_encntr_detail and the authorization tables.
SCH_PEND_ENCNTR_DETAIL_ID DOUBLE N Uniquely identifies the related Pending Encounter Detail.
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 - SCH_PEND_ENCNTR_AUTH_RELTN


Child Column in SCH_PEND_ENCNTR_AUTH_RELTN(FK) Parent Table Name Parent Column Name
Parents: AUTHORIZATION_ID AUTHORIZATION AUTHORIZATION_ID
SCH_PEND_ENCNTR_DETAIL_ID SCH_PEND_ENCNTR_DETAIL SCH_PEND_ENCNTR_DETAIL_ID


SCH_PEND_ENCNTR_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Pending Encounter Details
Definition: This table stores data that is captured at the time of booking the appointment and will be used to generate an encounter for the appointment closer to the appointment date and time.
Table Type: ACTIVITY





Column Detail - SCH_PEND_ENCNTR_DETAIL


Column Name Type Null? Definition
ASSIGNMENT_OF_BENEFITS_CD DOUBLE N The patient's assignment of benefits code.
ATTENDING_PRSNL_ID DOUBLE N The identifier of the attending physician.
CLIENT_ORG_ID DOUBLE N The identifier of the client organization for the encounter.
ENCNTR_TYPE_CD DOUBLE N The type of encounter.
EST_ARRIVE_DT_TM DATETIME Y The estimated arrival date and time for the encounter.
FACILITY_ORG_ID DOUBLE N The identifier of the facility organization for the encounter.
LOCATION_CD DOUBLE N The location of the encounter.
PATIENT_CASE_ID DOUBLE N The identifier of the patient case row for this appointment.
PATIENT_SIGNATURE_SOURCE_CD DOUBLE N The patient's signature source code.
PROVIDER_ACCEPT_ASSIGNMENT_CD DOUBLE N The provider accept assignment code.
REASON_FOR_VISIT VARCHAR(255) Y The free text description of reason for visit. otherwise known as admitting symptom, presenting symptom, etc. it is a brief description of why the person has presented for examination or treatment and may be the patient described symptom.
REFERRING_PRSNL_ID DOUBLE N The identifier of the referring physician.
REG_DT_TM DATETIME Y The registration date and time of the encounter.
RELEASE_OF_INFORMATION_CD DOUBLE N The patient's release of information code.
SCH_PEND_ENCNTR_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the SCH_PEND_ENCNTR_DETAIL 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 - SCH_PEND_ENCNTR_DETAIL


Child Column in SCH_PEND_ENCNTR_DETAIL(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
CLIENT_ORG_ID ORGANIZATION ORGANIZATION_ID
FACILITY_ORG_ID ORGANIZATION ORGANIZATION_ID
PATIENT_CASE_ID PATIENT_CASE PATIENT_CASE_ID
ATTENDING_PRSNL_ID PRSNL PERSON_ID
REFERRING_PRSNL_ID PRSNL PERSON_ID




Parent Column in SCH_PEND_ENCNTR_DETAIL (PK) Child Table Name Child Column Name
Children: SCH_PEND_ENCNTR_DETAIL_ID SCH_EVENT_PATIENT SCH_PEND_ENCNTR_DETAIL_ID
SCH_PEND_ENCNTR_AUTH_RELTN SCH_PEND_ENCNTR_DETAIL_ID


SCH_PEND_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling pending event
Definition: Contains base appointment information about an appointment which will be created
Table Type: ACTIVITY





Column Detail - SCH_PEND_EVENT


Column Name Type Null? Definition
APPT_SYNONYM_CD DOUBLE N The appointment type synonym
APPT_TYPE_CD DOUBLE N The appointment type
CREATE_DT_TM DATETIME Y Date and time when the entry was created
ENCNTR_ID DOUBLE N The encounter identifier related to the pending event.
PERSON_ID DOUBLE N The person identifier related to the pending event.
PROTOCOL_PARENT_ID DOUBLE Y The pending event identifier of the first protocol event in the series. Zero if not part of a protocol.
PROTOCOL_SEQ_NBR DOUBLE Y The sequence within the protocol. Zero if not part of a protocol.
RECUR_PARENT_ID DOUBLE Y The pending event identifier of the first event in the series. Zero if not part of a recurring series
RECUR_SEQ_NBR DOUBLE Y The sequence within the recurring series. Zero if not part of a recurring series.
SCH_EVENT_ID DOUBLE N The event id to be used when modifying information for an existing appointment.
SCH_PEND_EVENT_ID DOUBLE N Unique generated number that identifies a single row on the SCH_PEND_EVENT 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 - SCH_PEND_EVENT


Child Column in SCH_PEND_EVENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PROTOCOL_PARENT_ID SCH_PEND_EVENT SCH_PEND_EVENT_ID
RECUR_PARENT_ID SCH_PEND_EVENT SCH_PEND_EVENT_ID




Parent Column in SCH_PEND_EVENT (PK) Child Table Name Child Column Name
Children: SCH_PEND_EVENT_ID SCH_PEND_EVENT PROTOCOL_PARENT_ID
SCH_PEND_EVENT RECUR_PARENT_ID
SCH_PEND_EVENT_DETAIL SCH_PEND_EVENT_ID
SCH_PEND_LOC SCH_PEND_EVENT_ID
SCH_PEND_ORDER SCH_PEND_EVENT_ID


SCH_PEND_EVENT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Pending Event Detail
Definition: Contains event detail information about an appointment which will be created.
Table Type: ACTIVITY





Column Detail - SCH_PEND_EVENT_DETAIL


Column Name Type Null? Definition
OE_FIELD_DISPLAY_VALUE VARCHAR(255) Y The detail display value associated to the pending event.
OE_FIELD_DT_TM_VALUE DATETIME Y Order Entry Field Date and Time Value associated to the pending event.
OE_FIELD_ID DOUBLE N The field identifier associated to the pending event.
OE_FIELD_MEANING VARCHAR(25) Y The field meaning associated to the pending event.
OE_FIELD_MEANING_ID DOUBLE N The field meaning identifier associated to the pending event.
OE_FIELD_VALUE DOUBLE Y The detail value associated to the pending event.
SCH_PEND_EVENT_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the SCH_PEND_EVENT_DETAIL table.
SCH_PEND_EVENT_ID DOUBLE N The pending event identifier that this data belongs to.
SEQ_NBR DOUBLE N The sequence in which the detail should be used when multiple values exist for a specific field identifier.
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 - SCH_PEND_EVENT_DETAIL


Child Column in SCH_PEND_EVENT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: OE_FIELD_MEANING_ID OE_FIELD_MEANING OE_FIELD_MEANING_ID
OE_FIELD_ID ORDER_ENTRY_FIELDS OE_FIELD_ID
SCH_PEND_EVENT_ID SCH_PEND_EVENT SCH_PEND_EVENT_ID