Table Detail Report

SCH_EVENT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Event Detail
Definition: Contains the flexible accept fields associated with the appointment.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_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.
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 The value of the order entry field.
SCH_ACTION_ID DOUBLE N The identifier to uniquely identify the action being performed.
SCH_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment.
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_EVENT_DETAIL


Child Column in SCH_EVENT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
SCH_ACTION_ID SCH_EVENT_ACTION SCH_ACTION_ID


SCH_EVENT_DISP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Event Display Fields
Definition: Contains the denormalized display field associated with an appointment.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_DISP


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.
DISP_DISPLAY VARCHAR(255) Y The 225-character string containing the displayable value of the field.
DISP_DT_TM DATETIME Y Date and Time Value
DISP_FIELD_ID DOUBLE N The unique identifier for the scheduling display field.
DISP_FIELD_MEANING VARCHAR(12) N The 12-character string corresponding to the field meaning.
DISP_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DISP_VALUE DOUBLE Y Numeric 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.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
PARENT_ID DOUBLE N Parent Identifier
PARENT_TABLE VARCHAR(32) N Parent Table
SCHEDULE_ID DOUBLE N The unique identifier for the event schedule.
SCH_APPT_ID DOUBLE N The unique identifier for a resource's/patient's appointment.
SCH_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment.
SEQ_NBR DOUBLE Y 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_EVENT_DISP


Child Column in SCH_EVENT_DISP(FK) Parent Table Name Parent Column Name
Parents: SCH_APPT_ID SCH_APPT SCH_APPT_ID
DISP_FIELD_ID SCH_DISP_FIELD DISP_FIELD_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
SCHEDULE_ID SCH_SCHEDULE SCHEDULE_ID


SCH_EVENT_LINK



Column Section Relationship Section Top of Page


Table-level Detail

Description: schedule event link
Definition: schedule event link
Table Type: ACTIVITY





Column Detail - SCH_EVENT_LINK


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.
AUTO_GENERATED_IND DOUBLE N auto generated indicator
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.
LINK_TYPE_CD DOUBLE N link type code
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
PARENT_EVENT_ID DOUBLE N sch_event_id of the parent
PARENT_TYPE_FLAG DOUBLE N This will be used to determine which event is the parent appointment between all the linked appointments.
SCH_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment.
SCH_LINK_ID DOUBLE N This will be used to find the linked appointments associated to a given 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_EVENT_LINK


Child Column in SCH_EVENT_LINK(FK) Parent Table Name Parent Column Name
Parents: SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID


SCH_EVENT_PATIENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Event Patient
Definition: Contains the patient(s)/person(s) associated with an appointment.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_PATIENT


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.
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.
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.
PERSON_PLAN_PROFILE_ID DOUBLE N The identifier of the person health plan profile.
PROFILE_TYPE_CD DOUBLE N Indicates the type of health insurance profile for the person plan profile row (i.e., professional, institutional, workmen's comp).
REFERRAL_IDENT VARCHAR(50) Y referral id from the referrral row in the cloud
SCH_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment.
SCH_PEND_ENCNTR_DETAIL_ID DOUBLE N The identifier of the pending encounter detail row for this appointment.
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.



Relationship Detail - SCH_EVENT_PATIENT


Child Column in SCH_EVENT_PATIENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PERSON_PLAN_PROFILE_ID PERSON_PLAN_PROFILE PERSON_PLAN_PROFILE_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
SCH_PEND_ENCNTR_DETAIL_ID SCH_PEND_ENCNTR_DETAIL SCH_PEND_ENCNTR_DETAIL_ID


SCH_EVENT_RECUR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Event Recur
Definition: The table hold the frequencies for a recurring event.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_RECUR


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.
DAYS_OF_WEEK VARCHAR(7) Y A 7-char string representing the days of the week.
DURATION_TYPE_FLAG DOUBLE N Determines the type of duration.
DURATION_UNITS DOUBLE N Scheduling Duration Units
DURATION_UNITS_CD DOUBLE N Scheduling Duration Units Code
DURATION_UNITS_MEANING VARCHAR(12) Y Scheduling Duration Units Meaning
END_DT_TM DATETIME Y 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.
EVENT_RECUR_ID DOUBLE N The unique identifier for the event's recurring pattern.
LAST_DT_TM DATETIME Y The last date and time an action was taken on the object.
LAST_SEQ_NBR DOUBLE N The sequence number corresponding last execution.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
ORDER_PROTOCOL_TYPE_FLAG DOUBLE Y Determines whether the recurring series is generated from a protocol order and how the protocol is to be managed. 0 - Generated using protocol order.1 - Not generated from future recurring, 2 - Generated from future recurring.
RECUR_STATE_CD DOUBLE N The coded identifier for the current state of the recurring frequency. This column is not being used.
RECUR_STATE_MEANING VARCHAR(12) Y A 12-character description corresponding to the current recurring frequency state.
RECUR_TEMPLATE_ID DOUBLE N The unique identifier of the scheduled event that should be used to create future recurring events.
SCH_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment.
START_DT_TM DATETIME Y The start date and time.
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_EVENT_RECUR


Child Column in SCH_EVENT_RECUR(FK) Parent Table Name Parent Column Name
Parents: DURATION_UNITS_CD CODE_VALUE CODE_VALUE
RECUR_STATE_CD CODE_VALUE CODE_VALUE
RECUR_TEMPLATE_ID SCH_EVENT SCH_EVENT_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID




Parent Column in SCH_EVENT_RECUR (PK) Child Table Name Child Column Name
Children: EVENT_RECUR_ID SCH_EVENT_RECUR_COMM EVENT_RECUR_ID
SCH_EVENT_RECUR_DETAIL EVENT_RECUR_ID
SCH_EVENT_RECUR_LIST EVENT_RECUR_ID
SCH_EVENT_RECUR_ORDER EVENT_RECUR_ID