SURG_REQ



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Request
Definition: Contains information about a surgical request
Table Type: ACTIVITY





Column Detail - SURG_REQ


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
ANESTHESIA_CD DOUBLE N The type of anesthesia to use for this surgical request
BLOCK_TIME_IND DOUBLE N Whether or not the surgeon's time should be blocked during this surgical request
CONCURRENT_PROC_IND DOUBLE N Whether or not all procedures for this surgical request can be performed concurrently
DATE_REQ_TYPE_FLAG DOUBLE N Which date time field to use where 0 = timeframe_cd, 1=req_start_dt_tm and req_end_dt_tm, and 2 = req_date_free-text
DEFER_ANESTHESIA_IND DOUBLE N Whether or not the anesthesia type is deferred to the anesthesiologist
ENCNTR_ID DOUBLE N The encounter ID of the Surgery Request submitted
FACILITY_CD DOUBLE N The facility for this surgical request
IN_PROGRESS_IND DOUBLE N Indicates if a row should considered as a surgical request that is being saved to be finished at a later time.
LOCATION_CD DOUBLE N The location for this surgical request
PATIENT_TYPE_CD DOUBLE N The patient's type (e.g. inpatient or outpatient)
PERSON_ID DOUBLE N The person ID for this surgical request
PRSNL_ID DOUBLE N The personnel ID of the person who originally created the Surgery Request
REQUEST_STATUS_CD DOUBLE N The status of the surgical request
REQ_DATE_FREETEXT VARCHAR(255) Y A free text field for requesting a timeframe for this surgical request
REQ_END_DT_TM DATETIME Y The requested end date time for this surgical request
REQ_START_DT_TM DATETIME Y The requested begin date time for this surgical request
SUBMIT_DT_TM DATETIME Y The time and date of this surgical request was submitted.
SURG_REQ_ID DOUBLE N PRIMARY KEY
TIMEFRAME_CD DOUBLE N A granular timeframe for this surgical request
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.



Relationship Detail - SURG_REQ


Child Column in SURG_REQ(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in SURG_REQ (PK) Child Table Name Child Column Name
Children: SURG_REQ_ID SURG_REQ_FAVORITE SURG_REQ_ID
SURG_REQ_ORDER_R SURG_REQ_ID
SURG_REQ_PLAN_R SURG_REQ_ID
SURG_REQ_PROC_GROUP SURG_REQ_ID


SURG_REQ_FAVORITE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Request Favorties
Definition: Mpage component, Request for Surgery allows users to save different combinations of surgery location, staff, procedure, ect as favorites. This table will store those different combinations for each user.
Table Type: ACTIVITY





Column Detail - SURG_REQ_FAVORITE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
FAVORITE_NAME VARCHAR(255) Y Name of the Favorite
PRSNL_ID DOUBLE N personnel identifier
SURG_REQ_FAVORITE_ID DOUBLE N PRIMARY KEY
SURG_REQ_ID DOUBLE N FK value from SURG_REQ table
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.



Relationship Detail - SURG_REQ_FAVORITE


Child Column in SURG_REQ_FAVORITE(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SURG_REQ_ID SURG_REQ SURG_REQ_ID


SURG_REQ_ORDER_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Request Order Reference
Definition: Links a surgical request to an order
Table Type: ACTIVITY





Column Detail - SURG_REQ_ORDER_R


Column Name Type Null? Definition
ORDER_ID DOUBLE N An order associated with a surgical request
SURG_REQ_ID DOUBLE N The surgical request that is associated with an order
SURG_REQ_ORDER_R_ID DOUBLE N Primary Key
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.



Relationship Detail - SURG_REQ_ORDER_R


Child Column in SURG_REQ_ORDER_R(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
SURG_REQ_ID SURG_REQ SURG_REQ_ID


SURG_REQ_PLAN_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Request Plan Reference
Definition: Links a powerplan to a surgical request
Table Type: ACTIVITY





Column Detail - SURG_REQ_PLAN_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
PATHWAY_CATALOG_ID DOUBLE N The pathway catalog related to this surgical request plan
PATHWAY_CUSTOMIZED_PLAN_ID DOUBLE N PATHWAY CUSTOMIZED PLAN ID is used to store the favorite ID of the powerplan
REQUESTED_PLAN_COUNT DOUBLE N REQUESTED PLAN COUNT
SURG_REQ_ID DOUBLE N The surgical request related to this surgical request plan
SURG_REQ_PLAN_R_ID DOUBLE N PRIMARY KEY
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.



Relationship Detail - SURG_REQ_PLAN_R


Child Column in SURG_REQ_PLAN_R(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID
PATHWAY_CUSTOMIZED_PLAN_ID PATHWAY_CUSTOMIZED_PLAN PATHWAY_CUSTOMIZED_PLAN_ID
SURG_REQ_ID SURG_REQ SURG_REQ_ID


SURG_REQ_PROC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Surgical Request Procedure
Definition: Contains information about a surgical request procedure
Table Type: ACTIVITY





Column Detail - SURG_REQ_PROC


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
ORDER_ID DOUBLE N The order ID for this procedure
PRIMARY_PROCEDURE_IND DOUBLE N Whether or not this is the primary procedure for the surgical request group
PROC_SYNONYM_ID DOUBLE N The synonym ID for this procedure
SURG_REQ_PROC_GROUP_ID DOUBLE N The surgical request group associated with this procedure
SURG_REQ_PROC_ID DOUBLE N PRIMARY KEY
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.



Relationship Detail - SURG_REQ_PROC


Child Column in SURG_REQ_PROC(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
PROC_SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
SURG_REQ_PROC_GROUP_ID SURG_REQ_PROC_GROUP SURG_REQ_PROC_GROUP_ID




Parent Column in SURG_REQ_PROC (PK) Child Table Name Child Column Name
Children: SURG_REQ_PROC_ID SURG_REQ_PROC_MODIFIER SURG_REQ_PROC_ID