Table Detail Report

SCH_DATE_EXCEPT



Column Section Top of Page


Table-level Detail

Description: Scheduling Date Exceptions
Definition: Stores date exceptions for a given scheduling request date range.
Table Type: ACTIVITY





Column Detail - SCH_DATE_EXCEPT


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.
BEG_DT_TM DATETIME N Begin Date and Time value
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.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
END_DT_TM DATETIME N End Date and Time value
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.
EXC_SEQ_NBR DOUBLE N This field is used to keep the records unique
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
SCENARIO_NBR DOUBLE N Sequence number to distinguish a scenario of scheduling request date range.
SCH_ACTION_ID DOUBLE N The identifier to uniquely identify the action being performed.
SEQ_NBR DOUBLE N Determines the order among the children of a group.
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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.


SCH_DEF_APPLY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Default Apply
Definition: Contains the instance on which a default schedule was applied to a resource.
Table Type: ACTIVITY





Column Detail - SCH_DEF_APPLY


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.
APPLY_DT_TM DATETIME N Date and Time the default schedule application string was applied.
APPLY_PRSNL_ID DOUBLE N The PERSON_ID of the person from the personnel table (PRSNL) that performed the action.
BEG_DT_TM DATETIME N Begin Date and Time value
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.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
DAYS_OF_WEEK VARCHAR(10) N A 7-char string representing the days of the week.
DEF_APPLY_ID DOUBLE N The unique identifier for the default schedule application.
DEF_SCHED_ID DOUBLE N The identifier for a default schedule.
DEF_STATE_CD DOUBLE N The coded identifier for the current state of the default schedule application.
DEF_STATE_MEANING VARCHAR(12) Y A 12-character description corresponding to the default schedule state.
END_DT_TM DATETIME N End Date and Time value
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.
FREQUENCY_ID DOUBLE N The unique identifier for a scheduling frequency.
LOCATION_CD DOUBLE N The location associcted to the scheduling default template.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
RESOURCE_CD DOUBLE N The identifier for the resource. A resource is an item of limited availability.
SCH_CLINIC_ID DOUBLE N Clinic Id assoiciated to the location and schedule.
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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_DEF_APPLY


Child Column in SCH_DEF_APPLY(FK) Parent Table Name Parent Column Name
Parents: DEF_STATE_CD CODE_VALUE CODE_VALUE
RESOURCE_CD CODE_VALUE CODE_VALUE
LOCATION_CD LOCATION LOCATION_CD
APPLY_PRSNL_ID PRSNL PERSON_ID
SCH_CLINIC_ID SCH_CLINIC SCH_CLINIC_ID
DEF_SCHED_ID SCH_DEF_SCHED DEF_SCHED_ID
FREQUENCY_ID SCH_FREQ FREQUENCY_ID




Parent Column in SCH_DEF_APPLY (PK) Child Table Name Child Column Name
Children: DEF_APPLY_ID SCH_APPLY_LIST DEF_APPLY_ID
SCH_DISPLACED_APPT DEF_APPLY_ID


SCH_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Detail
Definition: Scheduling Detail table
Table Type: ACTIVITY





Column Detail - SCH_DETAIL


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.
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.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
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.
LABEL_TEXT VARCHAR(200) Y Label Text
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
OE_FIELD_DISPLAY_VALUE VARCHAR(255) Y Order Entry Field Display Value
OE_FIELD_DT_TM_VALUE DATETIME Y Order Entry Field Date and Time Value
OE_FIELD_ID DOUBLE N The unique identifier for the order entry field.
OE_FIELD_MEANING VARCHAR(25) Y Defined the piece of information represented.
OE_FIELD_MEANING_ID DOUBLE N Defines the piece of information represented by the field.
OE_FIELD_VALUE DOUBLE Y Order Entry Field Value
PARENT_ID DOUBLE N Parent Identifier
PARENT_TABLE VARCHAR(32) N Parent Table
SEQ_NBR DOUBLE N Determines the order among the children of a group.
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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_DETAIL


Child Column in SCH_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_DISPLACED_APPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Displaced Appointment
Definition: Displaced appointments are recorded here.
Table Type: ACTIVITY





Column Detail - SCH_DISPLACED_APPT


Column Name Type Null? Definition
DEF_APPLY_ID DOUBLE N The ID of the row in the SCH_DEF_APPLY table that causes the appointment to be displaced.
PLACEMENT_STATE_CD DOUBLE N The state of the displaced appointment.
PLACEMENT_STATE_MEANING VARCHAR(12) N Additional text about the state of the displaced appointment.
SCH_APPT_ID DOUBLE N The appointment ID of the displaced appointment. Relates back to the SCH_APPT table.
SCH_DISPLACED_APPT_ID DOUBLE N The unique primary key of this table.
SCH_EVENT_ID DOUBLE N The scheduling event id of the displaced appointment. Relates to the SCH_EVENT 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 - SCH_DISPLACED_APPT


Child Column in SCH_DISPLACED_APPT(FK) Parent Table Name Parent Column Name
Parents: SCH_APPT_ID SCH_APPT SCH_APPT_ID
DEF_APPLY_ID SCH_DEF_APPLY DEF_APPLY_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID


SCH_ENTRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Entry
Definition: Master table to store scheduling requests information.
Table Type: ACTIVITY





Column Detail - SCH_ENTRY


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.
APPT_TYPE_CD DOUBLE N The identifier for an appointment type.
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.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
EARLIEST_DT_TM DATETIME Y The earliest request start 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.
ENTRY_STATE_CD DOUBLE N The coded identifier for the state of the request list entry.
ENTRY_STATE_MEANING VARCHAR(12) N A 12-character description corresponding to the state of the request list entry.
ENTRY_TYPE_CD DOUBLE N The coded identifier for the request list entry type.
ENTRY_TYPE_MEANING VARCHAR(12) N A 12-character description corresponding to the request list entry type.
LATEST_DT_TM DATETIME Y The latest requested start date and time.
NO_CONTACT_FLAG DOUBLE Y Indicates if the scheduling patient can be contacted. When set to 1 the patient should not be contacted.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
QUEUE_ID DOUBLE N The unique identifier for the scheduling request list queue.
REQUEST_MADE_DT_TM DATETIME N The date and time the original request was created.
REQ_ACTION_CD DOUBLE N The coded identifier for the requested action.
REQ_ACTION_MEANING VARCHAR(12) N A 12-character description corresponding to the requested action.
SCHEDULE_ID DOUBLE N The unique identifier for the event schedule.
SCH_ACTION_ID DOUBLE N The identifier to uniquely identify the action being performed.
SCH_APPT_ID DOUBLE N The unique identifier for a resource's/patient's appointment.
SCH_ENTRY_ID DOUBLE N The unique identifier for the scheduling request list entry.
SCH_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment.
STANDBY_PRIORITY_CD DOUBLE N The priority of the standby appointment reqquest.
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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_ENTRY


Child Column in SCH_ENTRY(FK) Parent Table Name Parent Column Name
Parents: APPT_TYPE_CD CODE_VALUE CODE_VALUE
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
SCH_APPT_ID SCH_APPT SCH_APPT_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
SCH_ACTION_ID SCH_EVENT_ACTION SCH_ACTION_ID
QUEUE_ID SCH_OBJECT SCH_OBJECT_ID
SCHEDULE_ID SCH_SCHEDULE SCHEDULE_ID




Parent Column in SCH_ENTRY (PK) Child Table Name Child Column Name
Children: SCH_ENTRY_ID PFT_QUEUE_ITEM SCH_ENTRY_ID
PFT_QUEUE_ITEM_HIST SCH_ENTRY_ID