Table Detail Report

SCH_EVENT_RECUR_COMM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Event recur comment
Definition: Scheduling comments for event recurring instances.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_RECUR_COMM


Column Name Type Null? Definition
EVENT_RECUR_ID DOUBLE N Unique generated number that identifies a single row on the SCH_EVENT_RECUR_COMM table
SCH_EVENT_RECUR_COMM_ID DOUBLE N Unique generated number that identifies a single row on the SCH_EVENT_RECUR_COMM table.
SUB_TEXT_CD DOUBLE N The identifier for the scheduling text sub-type.
TEXT_ID DOUBLE N Text Identifier
TEXT_TYPE_CD DOUBLE N The identifier for the scheduling text type
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.



Relationship Detail - SCH_EVENT_RECUR_COMM


Child Column in SCH_EVENT_RECUR_COMM(FK) Parent Table Name Parent Column Name
Parents: TEXT_ID LONG_TEXT LONG_TEXT_ID
EVENT_RECUR_ID SCH_EVENT_RECUR EVENT_RECUR_ID


SCH_EVENT_RECUR_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Event Recur Detail
Definition: Scheduling event recurring instance accept format details.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_RECUR_DETAIL


Column Name Type Null? Definition
EVENT_RECUR_ID DOUBLE N SEQUENCE NAME:SCH_RECUR_SEQ Unique generated number that identifies a single row on the SCH_EVENT_RECUR table
OE_FIELD_DISPLAY_VALUE VARCHAR(255) Y OThe value in the order entry field display.
OE_FIELD_DT_TM_VALUE DATETIME Y Date and time value captured by this detail. This is only filled out for date/time details.
OE_FIELD_ID DOUBLE N SEQUENCE NAME:REFERENCE_SEQ 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_EVENT_RECUR_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the SCH_EVENT_RECUR_DETAIL table.
SEQ_NBR DOUBLE N This value in this column is used to sequence the values in an order entry field.
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.



Relationship Detail - SCH_EVENT_RECUR_DETAIL


Child Column in SCH_EVENT_RECUR_DETAIL(FK) Parent Table Name Parent Column Name
Parents: EVENT_RECUR_ID SCH_EVENT_RECUR EVENT_RECUR_ID


SCH_EVENT_RECUR_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Event Recurring List
Definition: Table to store the information about how a future instance of a recurring appointment should be booked.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_RECUR_LIST


Column Name Type Null? Definition
ADDITIONAL_MINUTE_NBR DOUBLE N Additional minutes to be added to the recurring instances.
APPT_REASON_FREE VARCHAR(255) Y The free text reason the appointment was requested.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. it is an internal system assigned number.
EVENT_RECUR_ID DOUBLE N The unique identifier of the associated sch_event_recur table.
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient.
OVERRIDE_DURATION_MINUTE_NBR DOUBLE N The duration (in minutes) of the patient override.
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).
RES_LIST_ID DOUBLE N The unique identifier of the associated scheduling resource.
SCH_EVENT_RECUR_LIST_ID DOUBLE N Unique generated number that identifies a single row on the SCH_EVENT_RECUR_LIST table.
SEQ_NBR DOUBLE N The instance sequence for recurring series within one date.
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.



Relationship Detail - SCH_EVENT_RECUR_LIST


Child Column in SCH_EVENT_RECUR_LIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
EVENT_RECUR_ID SCH_EVENT_RECUR EVENT_RECUR_ID
RES_LIST_ID SCH_RESOURCE_LIST RES_LIST_ID




Parent Column in SCH_EVENT_RECUR_LIST (PK) Child Table Name Child Column Name
Children: SCH_EVENT_RECUR_LIST_ID SCH_EVENT_RECUR_ROLE SCH_EVENT_RECUR_LIST_ID
SCH_FREQ_DATE SCH_EVENT_RECUR_LIST_ID


SCH_EVENT_RECUR_ORDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Event Recurring Order
Definition: Table used to record the orderables which will be attached to the recurring instances.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_RECUR_ORDER


Column Name Type Null? Definition
ACTION_TYPE_CD DOUBLE N A grouping mechanism within catalog type code
EVENT_RECUR_ID DOUBLE N the identifier from sch_event_recur table
ORDER_PROVIDER_ID DOUBLE N Order physician's personnal Id
ORDER_SYNONYM_ID DOUBLE N Id of the synonym for this order
SCH_EVENT_RECUR_ORDER_ID DOUBLE N Unique generated number that identifies a single row on the SCH_EVENT_RECUR_ORDER 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.



Relationship Detail - SCH_EVENT_RECUR_ORDER


Child Column in SCH_EVENT_RECUR_ORDER(FK) Parent Table Name Parent Column Name
Parents: ORDER_SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
ORDER_PROVIDER_ID PRSNL PERSON_ID
EVENT_RECUR_ID SCH_EVENT_RECUR EVENT_RECUR_ID




Parent Column in SCH_EVENT_RECUR_ORDER (PK) Child Table Name Child Column Name
Children: SCH_EVENT_RECUR_ORDER_ID SCH_EVENT_RECUR_ORD_DETAIL SCH_EVENT_RECUR_ORDER_ID


SCH_EVENT_RECUR_ORD_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Event Recurring Instance Order Details
Definition: The order details of a scheduling event recurring instance.
Table Type: ACTIVITY





Column Detail - SCH_EVENT_RECUR_ORD_DETAIL


Column Name Type Null? Definition
DETAIL_SEQUENCE DOUBLE N The sequence of the order details.
OE_FIELD_DISPLAY_VALUE VARCHAR(255) Y The display value of the event recurring order detail.
OE_FIELD_DT_TM_VALUE DATETIME Y Date and time value captured by this detail. This is only filled out for date/time details.
OE_FIELD_ID DOUBLE N SEQUENCE NAME:REFERENCE_SEQ 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 N The value of the order entry field.
SCH_EVENT_RECUR_ORDER_ID DOUBLE N SEQUENCE NAME:SCH_RECUR_SEQUnique generated number that identifies a single row on the SCH_EVENT_RECUR_ORDER table.
SCH_EVENT_RECUR_ORD_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the SCH_EVENT_RECUR_ORD_DETAIL 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.



Relationship Detail - SCH_EVENT_RECUR_ORD_DETAIL


Child Column in SCH_EVENT_RECUR_ORD_DETAIL(FK) Parent Table Name Parent Column Name
Parents: SCH_EVENT_RECUR_ORDER_ID SCH_EVENT_RECUR_ORDER SCH_EVENT_RECUR_ORDER_ID