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 |