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 |