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 |