Table Detail Report

SCH_PEND_WARNING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Pending Warning
Definition: Warnings overridden during the booking process.
Table Type: ACTIVITY





Column Detail - SCH_PEND_WARNING


Column Name Type Null? Definition
SCH_PEND_APPT_ID DOUBLE Y Appointment participant that the warning belongs to.
SCH_PEND_WARNING_ID DOUBLE N Unique generated number that identifies a single row on the SCH_PEND_WARNING table.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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.
WARN_PRSNL_ID DOUBLE Y Unique identifier of the personnel that overrode the warning.
WARN_REASON_CD DOUBLE Y Reason the warning was overridden.
WARN_TYPE_CD DOUBLE Y Type of warning being overridden.



Relationship Detail - SCH_PEND_WARNING


Child Column in SCH_PEND_WARNING(FK) Parent Table Name Parent Column Name
Parents: WARN_PRSNL_ID PRSNL PERSON_ID
SCH_PEND_APPT_ID SCH_PEND_APPT SCH_PEND_APPT_ID


SCH_RESOURCE_LOCK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Resource Lock
Definition: A locking table used to lock a resource on a specific date.
Table Type: ACTIVITY





Column Detail - SCH_RESOURCE_LOCK


Column Name Type Null? Definition
LOCK_DT_TM DATETIME N The date for which the resource is locked.
PERSON_ID DOUBLE N Identifier of the person being locked.
RESOURCE_CD DOUBLE N Identifier of the resource being locked.
SCH_RESOURCE_LOCK_ID DOUBLE N The unique primary key of this table. It uniquely identifies a resource lock.
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_RESOURCE_LOCK


Child Column in SCH_RESOURCE_LOCK(FK) Parent Table Name Parent Column Name
Parents: RESOURCE_CD SCH_RESOURCE RESOURCE_CD


SCH_SCHEDULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Event Schedules
Definition: Contains the schedules for the appointments. An appointment can have multiple schedules.
Table Type: ACTIVITY





Column Detail - SCH_SCHEDULE


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.
ADDITIONAL_MINUTE_NBR DOUBLE N Additional minutes to be added to current schedule.
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.
GRPSESSION_ID DOUBLE N This will be used to find the schedules associated to a given group session. This will be used when actions such as reschedule occur, to easily get to the schedules that will be affected.
INDIRECT_BOOK_IND DOUBLE Y indirect booking indicator
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00. This field is used to maintain foreign keys to tables that contain a VERSION_DT_TM in the primary key.
OVERRIDE_DURATION_MINUTE_NBR DOUBLE N The duration (in minutes) of the patient override.
RES_LIST_ID DOUBLE N The unique identifier of the scheduling resource list.
SCHEDULE_ID DOUBLE N The unique identifier for the event schedule. The schedules are used to track rescheduling of an event.
SCHEDULE_SEQ DOUBLE N Used to document the rescheduling of appointments.
SCH_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment.
SCH_STATE_CD DOUBLE N The coded identifier for the current state of the appointment.
STATE_MEANING VARCHAR(12) Y A 12-character string corresponding to the current state of the appointment.
UNCONFIRM_COUNT DOUBLE N Determines the number of resource that have not been confirmed for the current 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_SCHEDULE


Child Column in SCH_SCHEDULE(FK) Parent Table Name Parent Column Name
Parents: SCH_STATE_CD CODE_VALUE CODE_VALUE
GRPSESSION_ID SCH_EVENT SCH_EVENT_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
RES_LIST_ID SCH_RESOURCE_LIST RES_LIST_ID




Parent Column in SCH_SCHEDULE (PK) Child Table Name Child Column Name
Children: SCHEDULE_ID EPISODE_ACTIVITY CREATED_BY_SCHEDULE_ID
PM_OFFER SCHEDULE_ID
PM_POST_DOC SCHEDULE_ID
SCH_APPT SCHEDULE_ID
SCH_ENTRY SCHEDULE_ID
SCH_EVENT_ACTION SCHEDULE_ID
SCH_EVENT_DISP SCHEDULE_ID
SCH_EVENT_ROLE SCHEDULE_ID
SCH_LOCATION SCHEDULE_ID
SCH_MESSAGING SCHEDULE_ID
SCH_SCHEDULE_MOVE SCHEDULE_ID


SCH_SCHEDULE_MOVE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SCHEDULING SCHEDULE MOVE
Definition: Store move criteria for each schedule
Table Type: ACTIVITY





Column Detail - SCH_SCHEDULE_MOVE


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.
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 single unique identifier
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.
MOVE_FLAG DOUBLE N indicates type of move criteria
MOVE_PREF_BEG_TM DOUBLE N preferred begin time of move criteria
MOVE_PREF_END_TM DOUBLE N preferred end time of move criteria
MOVE_REQUESTOR VARCHAR(255) Y the person who requested the move criteria
NULL_DT_TM DATETIME N date time field for version logic
SCHEDULE_ID DOUBLE N identifier for event schedule
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 date time field for version logic



Relationship Detail - SCH_SCHEDULE_MOVE


Child Column in SCH_SCHEDULE_MOVE(FK) Parent Table Name Parent Column Name
Parents: SCHEDULE_ID SCH_SCHEDULE SCHEDULE_ID


SCH_SLOT_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Slot Alias
Definition: This table is used to store a foreign system alias for a schedulable slot.
Table Type: ACTIVITY





Column Detail - SCH_SLOT_ALIAS


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.
ALIAS_POOL_CD DOUBLE N A collection used to generate aliases.
APPLY_SLOT DOUBLE N The apply slot.
APPT_DEF_ID DOUBLE N The ID of the scheudling appointment definition the alias is related to.
ASSIGN_AUTHORITY_SYS_CD DOUBLE N This field identifies whether the ESI server received and alias that was configured for Hold.
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.
CAB_SERVICE_ID DOUBLE N Service Id of Related Choose and Book Service
CHECK_DIGIT DOUBLE Y Parity digit.
CHECK_DIGIT_METHOD_CD DOUBLE N Method for checking the digit.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
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.
NULL_DT_TM DATETIME N The null date and time.
OFFSET_MINS DOUBLE Y The offset (in minutes) of the start time interval in a contiguous slot.
PUBLISHED_IND DOUBLE N Is this slot available in Choose and Book?
SLOT_ALIAS VARCHAR(255) N The slot alias identifier.
SLOT_ALIAS_ID DOUBLE N The primary key of this table.
SLOT_ALIAS_SUB_TYPE_CD DOUBLE N Identifies a category within a particular slot alias type code.
SLOT_ALIAS_TYPE_CD DOUBLE N Identifies a kind or type of alias
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 date and time field for version logic.



Relationship Detail - SCH_SLOT_ALIAS


Child Column in SCH_SLOT_ALIAS(FK) Parent Table Name Parent Column Name
Parents: ALIAS_POOL_CD CODE_VALUE CODE_VALUE
CHECK_DIGIT_METHOD_CD CODE_VALUE CODE_VALUE
SLOT_ALIAS_SUB_TYPE_CD CODE_VALUE CODE_VALUE
SLOT_ALIAS_TYPE_CD CODE_VALUE CODE_VALUE
APPT_DEF_ID SCH_APPT_DEF APPT_DEF_ID
CAB_SERVICE_ID SCH_CAB_SERVICE CAB_SERVICE_ID