Table Detail Report

SCH_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduled Appointment
Definition: Contains the requested/scheduled appointments.
Table Type: ACTIVITY





Column Detail - SCH_EVENT


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_REASON_FREE VARCHAR(255) Y The free text reason the appointment was requested.
APPT_SYNONYM_CD DOUBLE N The identifier for an appointment type synonym.
APPT_SYNONYM_FREE VARCHAR(255) Y The free textmnemonic corresponding to appointment type synonym used to request the appointment.
APPT_TYPE_CD DOUBLE N The identifier for an appointment type. An example would be cardiac cath, echo stress, etc.
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.
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.
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.
ESO_SEND_IND DOUBLE Y Determines if the scheduled event has been sent through the interface.
EVENT_CLASS_CD DOUBLE N The class code for the scheduling event. An example would be onward referral, etc.
EVENT_RECUR_ID DOUBLE N The unique identifier for the event's recurring pattern.
FIRST_BKD_ASI_DT_TM DATETIME Y The first time the appointment was booked.
GRACE_PERIOD_CD DOUBLE N The unit of measure for grace period value from code set 54.
GRACE_PERIOD_MEANING VARCHAR(12) Y The meaning of the grace period cd like 'DAYS', 'WEEKS', 'MONTHS', etc.
GRACE_PERIOD_VALUE DOUBLE Y The numeric value of a period of time before and after the requested date during which an event may be scheduled.
GRP_BEG_DT_TM DATETIME Y Indicates the beginning of the first session
GRP_CAPACITY DOUBLE Y Used to know the maximum number of patients that can be scheduled for this event.
GRP_CLOSED_IND DOUBLE N Indicates whether session can be used once current date/time is past the first session's start date/time
GRP_DESC VARCHAR(255) Y Name of the Group Session - will be displayed on the appointment book view.
GRP_END_DT_TM DATETIME Y Indicates the end of the last session.
GRP_FLAG DOUBLE Y Indicator to distinguish between Group Sessions, Structured Group Sessions and non Group Sessions. 0 - Traditional event not part of a group session, 1 - Group session event, 2 - Structured group session event, 3 - All events scheduled in the book into the group sessions.
GRP_NBR_SCHED DOUBLE Y Used to track the number of patients that have been scheduled into this event.
GRP_SHARED_IND DOUBLE N Indicates whether the session can be used together with other sessions.
NULL_DT_TM DATETIME N Contains 31-DEC-2100 00:00:00.00
OE_FORMAT_ID DOUBLE N The identifier of the accept format.
OFFSET_BEG_UNITS DOUBLE Y Scheduling Offset Beg Units
OFFSET_BEG_UNITS_CD DOUBLE N The unit of measure for the field Offset_Beg_Units. An example would be days, dollars, etc.
OFFSET_BEG_UNITS_MEANING VARCHAR(12) Y Scheduling Offset Beg Units Meaning
OFFSET_END_UNITS DOUBLE Y Scheduling Offset End Units
OFFSET_END_UNITS_CD DOUBLE N The unit of measure for the field Offset_End_Units. An example would be days, dollars, etc.
OFFSET_END_UNITS_MEANING VARCHAR(12) Y Scheduling Offset End Units Meaning
OFFSET_EVENT_ID DOUBLE N The unique identifier of the event the current event is offset from.
OFFSET_FROM_CD DOUBLE N Indicates what the offset is associated with. An example would be person or primary resource.
OFFSET_FROM_MEANING VARCHAR(12) Y Scheduling Offset From Type Meaning
OFFSET_TYPE_CD DOUBLE N Indicates what type of scheduling offset it is. An example would be begining or ending.
OFFSET_TYPE_MEANING VARCHAR(12) Y Scheduling Offset Type Meaning
ORDER_SENTENCE_ID DOUBLE N The identifier of the order sentence.
ORIG_REQ_END_DT_TM DATETIME Y The original requested end date time specified by the provider at the time the event was initially requested. Useful when rescheduling or for reporting purpose.
ORIG_REQ_START_DT_TM DATETIME Y The original requested start date time specified by the provider at the time the event was initially requested. Useful when rescheduling or for reporting purpose.
PROTOCOL_PARENT_ID DOUBLE N The unique identifier of the protocol parent event.
PROTOCOL_SEQ_NBR DOUBLE Y The sequence of the protocol component within the protocol.
PROTOCOL_TYPE_FLAG DOUBLE Y A field used to determine if the event is part of a protocol (parent, child). 0 - none, 1 - parent only, 2 - parent & child, 3 - child only.
RECUR_PARENT_ID DOUBLE N The unique identifier of the recurring series parent scheduled event.
RECUR_SEQ_NBR DOUBLE N Determines the order among the children of a recursive event.
RECUR_TEMPLATE_ID DOUBLE N The unique identifier of the scheduled event that should be used to create future recurring events.
RECUR_TYPE_FLAG DOUBLE N The flag determines if the event is a member of a recurring series (parent, sibling?). 0 - Not a recursive event, 1 - Recursive event
REFER_DT_TM DATETIME Y The date and time of the referral information.
REFER_PRINTED_IND DOUBLE N Indicates whether the referral's information has been printed.
REQUEST_RANGE_RETAIN_IND DOUBLE Y When this value is set to 1, all requests for this event will retain the requested date time range from the original request for booking. When this is set to 0, the dates associated with requests are not limited to the initial date time ranges.
REQ_PRSNL_ID DOUBLE N The PERSON_ID of the person from the personnel table (PRSNL) that requested the appointment.
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_EVENT_SEQ DOUBLE N Used to sequence scheduling events.
SCH_MEANING VARCHAR(12) N The 12-character string corresponding to the current state of the appointment.
SCH_STATE_CD DOUBLE N The coded identifier corresponding to the current state of the appointment. An example would be complete, confirmed, deleted. etc.
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


Child Column in SCH_EVENT(FK) Parent Table Name Parent Column Name
Parents: APPT_TYPE_CD CODE_VALUE CODE_VALUE
CONTRIBUTOR_SYSTEM_CD CODE_VALUE CODE_VALUE
SCH_STATE_CD CODE_VALUE CODE_VALUE
ORDER_SENTENCE_ID ORDER_SENTENCE ORDER_SENTENCE_ID
REQ_PRSNL_ID PRSNL PERSON_ID
OFFSET_EVENT_ID SCH_EVENT SCH_EVENT_ID
PROTOCOL_PARENT_ID SCH_EVENT SCH_EVENT_ID
RECUR_PARENT_ID SCH_EVENT SCH_EVENT_ID
RECUR_TEMPLATE_ID SCH_EVENT SCH_EVENT_ID




Parent Column in SCH_EVENT (PK) Child Table Name Child Column Name
Children: SCH_EVENT_ID AUTH_SCH_EVENT_RELTN SCH_EVENT_ID
AUTH_SCH_EVENT_RELTN_HIST SCH_EVENT_ID
CDI_WORK_ITEM SCH_EVENT_ID
ESI_LOG SCH_EVENT_ID
MP_AMB_ORG_SAT SCH_EVENT_ID
PFT_QUEUE_ITEM SCH_EVENT_ID
PFT_QUEUE_ITEM_HIST SCH_EVENT_ID
PM_WAIT_LIST SCH_EVENT_ID
RC_SLA_ACTIVITY SCH_EVENT_ID
SCH_APPT GRPSESSION_ID
SCH_APPT SCH_EVENT_ID
SCH_DISPLACED_APPT SCH_EVENT_ID
SCH_ENTRY SCH_EVENT_ID
SCH_EVENT OFFSET_EVENT_ID
SCH_EVENT PROTOCOL_PARENT_ID
SCH_EVENT RECUR_PARENT_ID
SCH_EVENT RECUR_TEMPLATE_ID
SCH_EVENT_ACTION SCH_EVENT_ID
SCH_EVENT_ALIAS SCH_EVENT_ID
SCH_EVENT_ATTACH SCH_EVENT_ID
SCH_EVENT_COMM SCH_EVENT_ID
SCH_EVENT_DETAIL SCH_EVENT_ID
SCH_EVENT_DISP SCH_EVENT_ID
SCH_EVENT_LINK SCH_EVENT_ID
SCH_EVENT_PATIENT SCH_EVENT_ID
SCH_EVENT_RECUR RECUR_TEMPLATE_ID
SCH_EVENT_RECUR SCH_EVENT_ID
SCH_EVENT_ROLE SCH_EVENT_ID
SCH_MESSAGING SCH_EVENT_ID
SCH_SCHEDULE GRPSESSION_ID
SCH_SCHEDULE SCH_EVENT_ID
SI_DOCUMENT_INFO SCH_EVENT_ID
SURGICAL_CASE SCH_EVENT_ID


SCH_EVENT_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Event Actions
Definition: Record the actions performed on an appointment
Table Type: ACTIVITY





Column Detail - SCH_EVENT_ACTION


Column Name Type Null? Definition
ABN_CONV_ID DOUBLE N Conversation Identifier of last Medical Necessity Check
ACTION_DT_TM DATETIME N The date/time of the scheduling action.
ACTION_MEANING VARCHAR(12) N A 12-char description corresponding to the Scheduling ActionCode.
ACTION_PRSNL_ID DOUBLE N There will be situations where the person will be a patient and not be a PRSNL. In this case the source of the _id will be PERSON.
ACTION_SOURCE_CD DOUBLE Y The code value of the source of the action being taken. (User, Appointment Reminder, Auto Dialer, etc.).
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_SYNONYM_CD DOUBLE Y The identifier for an appointment type synonym.
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.
BREACH_OFFSET_DAYS DOUBLE Y The number of days in breach for adding a referral letter from the freeze or lead time.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
CONTACT_FOLLOW_UP_DT_TM DATETIME Y The date/time of the follow-up action for scheduling items.
CONTACT_OUTCOME_CD DOUBLE Y An outcome code value associated with contacting a referrer to add a referral letter.
CONVERSATION_ID DOUBLE N Scheduling Conversation Identifier. This identifier is used to track all the scheduling actions to perform at a list of appointments at the same transaction. This field makes debugging much easier.
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.
ESO_ACTION_CD DOUBLE N A coded Identifier for the Scheduling ESO Action Code. An example would be 'cancel appointment', 'appointment', etc.
ESO_ACTION_MEANING VARCHAR(12) Y A 12-char description corresponding to the Scheduling ESO Action Code.
GUIDANCE_EXISTS_IND DOUBLE Y Indicates whether a Service Specific Booking Guidance was defined for the specialty associated to the action.
HIPAA_ACTION_CD DOUBLE N Used to track if a record has already been processed by HIPAA logging.
NULL_DT_TM DATETIME N Contains 31-DEC-2100 00:00:00.00
ORGANIZATION_ID DOUBLE N The organization context of the user at time of action.
ORIG_ACTION_ID DOUBLE N The event action identifier on the SCH_EVENT_ACTION table of the original request.
PATIENT_DECEASED_IND DOUBLE Y Indicates whether the patient is deceased at the time the action is performed.
PERFORM_DT_TM DATETIME N The performed date and time specified by the user that the action was performed. It is used for retroactive checkin.
POSITION_CD DOUBLE N The position of the personnel when the action was performed. For example, 'RN', 'Case Manager', etc.
PRACTICE_ORG_ID DOUBLE N The identifier of a Practice organization which applies to the action.
PRODUCT_CD DOUBLE N The scheduling product code. Some examples are 'Choose and Book', 'IQ Health', etc.
PROXY_ID DOUBLE N Identifier representing the person on behalf of which the action was performed.
PROXY_ORGANIZATION_ID DOUBLE N The organization context of proxied user at time of action.
PROXY_POSITION_CD DOUBLE N The position of the proxy personnel when the action was performed. For example, 'RN', 'Case Manager', etc.
PROXY_ROLE_PROFILE VARCHAR(255) Y Identifies the role profile of the proxy personnel who performed this action.
REASON_MEANING VARCHAR(12) Y A 12-character description corresponding to the scheduling reason.
REFERRING_RESOURCE_CD DOUBLE N The resource_cd of the resource that onward referred the appointment.
REQ_ACTION_CD DOUBLE N The coded identifier for the requested action. An example would be 'appointment', 'cancel', etc.
REQ_ACTION_ID DOUBLE N The unique identifier corresponding to the requested action. This field is used to store details and comments about the requested action.
REQ_ACTION_MEANING VARCHAR(12) Y A 12-character description corresponding to the requested action.
RESOURCE_CD DOUBLE N The identifier for the resource associated to this action.
ROLE_PROFILE VARCHAR(255) Y Identifies the role profile of personnel who performed this action.
SCHEDULE_ID DOUBLE N The unique identifier for the event schedule.
SCH_ACTION_CD DOUBLE N A unique identifier for the Scheduling Action Code. An example would be 'defer', 'cancel', etc.
SCH_ACTION_ID DOUBLE N The identifier to uniquely identify the action being performed. The unique primary key of this table.
SCH_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment. References the SCH_EVENT table.
SCH_REASON_CD DOUBLE N The coded identifier of the scheduling reason. An example would be 'patient deceased', 'no show', etc.,
SCH_USER_SESSION_ID DOUBLE N ** OBSOLETE COLUMN (Parent table is obsolete) ** This will be the ID of the user's session that performed the action. The primary key of the SCH_USER_SESSION table.
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.
VER_INTERCHANGE_ID DOUBLE N ABN (Advance Beneficiary Notices) transaction id.
VER_STATUS_CD DOUBLE N ABN (Advance Beneficiary Notices) Verification status code. Examples are 'error', 'returned' and 'denial'.
VER_STATUS_MEANING VARCHAR(12) Y ABN (Advance Beneficiary Notices) Verification status meaning.



Relationship Detail - SCH_EVENT_ACTION


Child Column in SCH_EVENT_ACTION(FK) Parent Table Name Parent Column Name
Parents: ESO_ACTION_CD CODE_VALUE CODE_VALUE
REQ_ACTION_CD CODE_VALUE CODE_VALUE
RESOURCE_CD CODE_VALUE CODE_VALUE
VER_STATUS_CD CODE_VALUE CODE_VALUE
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRACTICE_ORG_ID ORGANIZATION ORGANIZATION_ID
PROXY_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
ACTION_PRSNL_ID PRSNL PERSON_ID
PROXY_ID PRSNL PERSON_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
ORIG_ACTION_ID SCH_EVENT_ACTION SCH_ACTION_ID
SCHEDULE_ID SCH_SCHEDULE SCHEDULE_ID




Parent Column in SCH_EVENT_ACTION (PK) Child Table Name Child Column Name
Children: SCH_ACTION_ID PM_POST_DOC SCH_ACTION_ID
SCH_ACTION_DATE SCH_ACTION_ID
SCH_ACTION_LOC SCH_ACTION_ID
SCH_ACTION_ROLE SCH_ACTION_ID
SCH_ENTRY SCH_ACTION_ID
SCH_EVENT_ACTION ORIG_ACTION_ID
SCH_EVENT_ATTACH CANCEL_ACTION_ID
SCH_EVENT_COMM SCH_ACTION_ID
SCH_EVENT_DETAIL SCH_ACTION_ID


SCH_EVENT_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Event Alias
Definition: Alias names used to identify appointments across an interface.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_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 VARCHAR(255) N A identifier of the object on a foreign system
ALIAS_POOL_CD DOUBLE N A collection used to generate aliases.
ASSIGN_AUTHORITY_SYS_CD DOUBLE N This field determines whether the ESI Server received an order 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.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
CHECK_DIGIT DOUBLE Y Parity
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.
EVENT_ALIAS_SUB_TYPE_CD DOUBLE N Alias sub type.
EVENT_ALIAS_TYPE_CD DOUBLE N Type of alias.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
SCH_EVENT_ALIAS_ID DOUBLE N A unique identifier for the event alias.
SCH_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment.
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_ALIAS


Child Column in SCH_EVENT_ALIAS(FK) Parent Table Name Parent Column Name
Parents: ALIAS_POOL_CD CODE_VALUE CODE_VALUE
CHECK_DIGIT_METHOD_CD CODE_VALUE CODE_VALUE
CONTRIBUTOR_SYSTEM_CD CODE_VALUE CODE_VALUE
EVENT_ALIAS_SUB_TYPE_CD CODE_VALUE CODE_VALUE
EVENT_ALIAS_TYPE_CD CODE_VALUE CODE_VALUE
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID


SCH_EVENT_ATTACH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Event Attachments
Definition: Scheduling Event Attachments
Table Type: ACTIVITY





Column Detail - SCH_EVENT_ATTACH


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.
ATTACH_SOURCE_FLAG DOUBLE N This is the source of the association of the order_to_appointment.
ATTACH_TYPE_CD DOUBLE N The coded Identifier for the scheduling attachment type.
ATTACH_TYPE_MEANING VARCHAR(12) Y A 12-characted description corresponding to the scheduling attchment type code.
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.
BEG_SCHEDULE_SEQ DOUBLE N The scheduling sequence on which the attachment became active.
CANCEL_ACTION_ID DOUBLE N Used to track the scheduling action on which an order was cancelled. This provides the ability to 're-associate' cancelled orders.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
CONCURRENT_IND DOUBLE N Determines if the order is concurrent with the previous order in the event.
DESCRIPTION VARCHAR(100) Y A long description used for documentation.
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.
END_SCHEDULE_SEQ DOUBLE N The ending schedule sequence on which the attachment became inactive.
EVENT_DT_TM DATETIME Y The date and time the row was written from the scheduling appointment book.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
ORDER_DT_TM DATETIME Y The date and time the order corresponding to the row was written from the order server.
ORDER_ID DOUBLE N The unique identifier of the order.
ORDER_SEQ_NBR DOUBLE N The sequence of the order within the appointment.
ORDER_STATUS_CD DOUBLE N The coded identifier for the status of the order.
ORDER_STATUS_MEANING VARCHAR(12) Y A 12-character description corresponding ORDER_STATUS_CD.
PRIMARY_IND DOUBLE N Mark the attachment as the primary attachment for the schedule sequence.
SCH_ATTACH_ID DOUBLE N The generated numeric identifier for the scheduling event attachment.
SCH_EVENT_ID DOUBLE N The unique identifier for the requested/scheduled appointment.
SCH_STATE_CD DOUBLE N The coded identifier corresponding to the current state of association to the attachment.
SEQ_NBR DOUBLE N Determines the order among the children of a group.
STATE_MEANING VARCHAR(12) Y The 12-character string corresponding to the current state of association to the attachment.
SYNONYM_ID DOUBLE N The unique identifier of the order catalog synonym.
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_ATTACH


Child Column in SCH_EVENT_ATTACH(FK) Parent Table Name Parent Column Name
Parents: ATTACH_TYPE_CD CODE_VALUE CODE_VALUE
ORDER_STATUS_CD CODE_VALUE CODE_VALUE
SCH_STATE_CD CODE_VALUE CODE_VALUE
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
CANCEL_ACTION_ID SCH_EVENT_ACTION SCH_ACTION_ID


SCH_EVENT_COMM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Event Comments
Definition: Freetext comment associated with an appointment.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_COMM


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
PREDEFINED_COMM_CD DOUBLE Y Code value assigned to the predefined comment.
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.
SUB_TEXT_CD DOUBLE N The identifier for the scheduling text sub-type.
SUB_TEXT_MEANING VARCHAR(12) N The 12-character string corresponding to the scheduling text sub-type.
TEXT_ID DOUBLE N Text Identifier
TEXT_TYPE_CD DOUBLE N The identifier for the scheduling text type.
TEXT_TYPE_MEANING VARCHAR(12) N The 12-character string corresponding to the scheduling text type.
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_COMM


Child Column in SCH_EVENT_COMM(FK) Parent Table Name Parent Column Name
Parents: SUB_TEXT_CD CODE_VALUE CODE_VALUE
TEXT_TYPE_CD CODE_VALUE CODE_VALUE
TEXT_ID LONG_TEXT LONG_TEXT_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
SCH_ACTION_ID SCH_EVENT_ACTION SCH_ACTION_ID