Table Detail Report

SCH_PEND_LOC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Pending Location
Definition: Contains location information about an appointment which will be created.
Table Type: ACTIVITY





Column Detail - SCH_PEND_LOC


Column Name Type Null? Definition
LOCATION_CD DOUBLE N The location to be considered for this pending event.
SCH_PEND_EVENT_ID DOUBLE N The pending event identifier that this data belongs to.
SCH_PEND_LOC_ID DOUBLE N Unique generated number that identifies a single row on the SCH_PEND_LOC 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_PEND_LOC


Child Column in SCH_PEND_LOC(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
SCH_PEND_EVENT_ID SCH_PEND_EVENT SCH_PEND_EVENT_ID




Parent Column in SCH_PEND_LOC (PK) Child Table Name Child Column Name
Children: SCH_PEND_LOC_ID SCH_PEND_RES SCH_PEND_LOC_ID


SCH_PEND_ORDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Pending Order
Definition: Contains base order information about an appointment which will be created.
Table Type: ACTIVITY





Column Detail - SCH_PEND_ORDER


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The order catalog.
MODIFIED_IND DOUBLE N Indicates id the order detail has been modified. 0 represents no change. 1 represents that the order details are modified.
ORDER_ID DOUBLE N The order identifier.
ORDER_SEQ_NBR DOUBLE N The sequence in which the order should appear on the event.
SCH_PEND_EVENT_ID DOUBLE N The pending event identifier that this data belongs to.
SCH_PEND_ORDER_ID DOUBLE N Unique generated number that identifies a single row on the SCH_PEND_ORDER table.
SYNONYM_ID DOUBLE N The order 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.



Relationship Detail - SCH_PEND_ORDER


Child Column in SCH_PEND_ORDER(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
SCH_PEND_EVENT_ID SCH_PEND_EVENT SCH_PEND_EVENT_ID




Parent Column in SCH_PEND_ORDER (PK) Child Table Name Child Column Name
Children: SCH_PEND_ORDER_ID SCH_PEND_ORDER_DETAIL SCH_PEND_ORDER_ID
SCH_PEND_SURG_ITEM SCH_PEND_ORDER_ID


SCH_PEND_ORDER_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Pending Order Detail
Definition: Contains order detail information about an appointment which will be created.
Table Type: ACTIVITY





Column Detail - SCH_PEND_ORDER_DETAIL


Column Name Type Null? Definition
OE_FIELD_DISPLAY_VALUE VARCHAR(255) Y The detail display value associated to the pending order.
OE_FIELD_DT_TM_VALUE DATETIME Y The detail display value associated to the pending order.
OE_FIELD_ID DOUBLE N The field identifier associated to the pending order.
OE_FIELD_MEANING VARCHAR(25) Y The field meaning associated to the pending order.
OE_FIELD_MEANING_ID DOUBLE N The field meaning identifier associated to the pending order.
OE_FIELD_VALUE DOUBLE Y The detail value associated to the pending order.
SCH_PEND_ORDER_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the SCH_PEND_ORDER_DETAIL table.
SCH_PEND_ORDER_ID DOUBLE N The pending order identifier.
SEQ_NBR DOUBLE N The sequence in which the detail should be used when multiple values exist for a specific field identifier.
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_PEND_ORDER_DETAIL


Child Column in SCH_PEND_ORDER_DETAIL(FK) Parent Table Name Parent Column Name
Parents: OE_FIELD_MEANING_ID OE_FIELD_MEANING OE_FIELD_MEANING_ID
OE_FIELD_ID ORDER_ENTRY_FIELDS OE_FIELD_ID
SCH_PEND_ORDER_ID SCH_PEND_ORDER SCH_PEND_ORDER_ID


SCH_PEND_RES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Pending Resource
Definition: Contains resource information about an appointment which will be created.
Table Type: ACTIVITY





Column Detail - SCH_PEND_RES


Column Name Type Null? Definition
RESOURCE_CD DOUBLE N The resource to be considered for this pending event.
SCH_PEND_LOC_ID DOUBLE N The pend location identifier that this data belongs to
SCH_PEND_RES_ID DOUBLE N Unique generated number that identifies a single row on the SCH_PEND_RES 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_PEND_RES


Child Column in SCH_PEND_RES(FK) Parent Table Name Parent Column Name
Parents: SCH_PEND_LOC_ID SCH_PEND_LOC SCH_PEND_LOC_ID


SCH_PEND_SURG_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Pending Surgical Item
Definition: Surgical items related to an appointment draft.
Table Type: ACTIVITY





Column Detail - SCH_PEND_SURG_ITEM


Column Name Type Null? Definition
CHANGE_FLAG DOUBLE Y Whether the preference card is schedulable.
HOLD_QTY DOUBLE Y Quantity of items to mark as ON-HOLD.
ITEM_ID DOUBLE Y The item to be associated with the surgical appointment.
LIST_ROLE_ID DOUBLE Y List role identifier associated to the preference card.
OPEN_QTY DOUBLE Y Quantity of items to mark as open.
PREF_CARD_ID DOUBLE Y Preference card identifier associated to the draft order or orderable.
SCH_PEND_ORDER_ID DOUBLE Y Unique identifier for the draft order or orderable
SCH_PEND_SURG_ITEM_ID DOUBLE N Unique generated number that identifies a single row on the SCH_PEND_SURG_ITEM table.;
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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_PEND_SURG_ITEM


Child Column in SCH_PEND_SURG_ITEM(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
PREF_CARD_ID PREFERENCE_CARD PREF_CARD_ID
LIST_ROLE_ID SCH_LIST_ROLE LIST_ROLE_ID
SCH_PEND_ORDER_ID SCH_PEND_ORDER SCH_PEND_ORDER_ID