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 |