Table Detail Report
SURG_REQ_PROC_GROUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Surgical Request Procedure Group |
Definition: | Contains information about a surgical request procedure group |
Table Type: | ACTIVITY |
Column Detail - SURG_REQ_PROC_GROUP
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. |
REQ_GROUP_NBR | DOUBLE | Y | The group number |
SURG_REQ_ID | DOUBLE | N | The surgical request related to this surgical request group |
SURG_REQ_PROC_GROUP_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_GROUP
Child Column in SURG_REQ_PROC_GROUP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SURG_REQ_ID | SURG_REQ | SURG_REQ_ID |
Parent Column in SURG_REQ_PROC_GROUP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SURG_REQ_PROC_GROUP_ID | SURG_REQ_PROC | SURG_REQ_PROC_GROUP_ID |
SURG_REQ_STAFF | SURG_REQ_PROC_GROUP_ID |
SURG_REQ_PROC_MODIFIER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Surgical Request Procedure Modifier |
Definition: | Contains modifiers for a surgical request procedure |
Table Type: | ACTIVITY |
Column Detail - SURG_REQ_PROC_MODIFIER
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. |
MODIFIER_CD | DOUBLE | N | The modifier for the surgical request procedure |
SURG_REQ_PROC_ID | DOUBLE | N | The surgical request procedure that this modifier is related to |
SURG_REQ_PROC_MODIFIER_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_MODIFIER
Child Column in SURG_REQ_PROC_MODIFIER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SURG_REQ_PROC_ID | SURG_REQ_PROC | SURG_REQ_PROC_ID |
SURG_REQ_STAFF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Surgical Request Staff |
Definition: | Contains information about a staff member for a surgical request |
Table Type: | ACTIVITY |
Column Detail - SURG_REQ_STAFF
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. |
PRSNL_ID | DOUBLE | N | The personnel ID for this staff |
STAFF_ROLE_CD | DOUBLE | N | The role of this staff for the surgical request |
SURG_REQ_PROC_GROUP_ID | DOUBLE | N | The surgical request group for this staff |
SURG_REQ_STAFF_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_STAFF
Child Column in SURG_REQ_STAFF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRSNL_ID | PRSNL | PERSON_ID |
SURG_REQ_PROC_GROUP_ID | SURG_REQ_PROC_GROUP | SURG_REQ_PROC_GROUP_ID |