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 |