Table Detail Report
STAFF_ACTIVITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Staff Activity |
Definition: | Used by SNStaffAssign |
Table Type: | ACTIVITY |
Column Detail - STAFF_ACTIVITY
Column Name | Type | Null? | Definition |
---|---|---|---|
CREATE_DT_TM | DATETIME | Y | Create Date and TimeColumn |
CREATE_PRSNL_ID | DOUBLE | N | Create Personnel IdColumn |
CREATE_TASK | DOUBLE | Y | Create TaskColumn |
CREAT_APPLCTX | DOUBLE | Y | Create Application ContextColumn |
FREE_TEXT_NAME | VARCHAR(100) | N | Free text nameColumn |
METHOD_FLAG | DOUBLE | Y | Method Flag. Possible values are: null = Assign by case; 1 = Assign by case; 2 = Assign by OR; 3 = Assign by Team |
PRSNL_ID | DOUBLE | N | Person_ID of the staff assigned |
ROLE_CD | DOUBLE | N | Role of the assigned staff |
SHIFT_CD | DOUBLE | N | Shift Code the staff is assigned to |
STAFF_ACTIVITY_ID | DOUBLE | N | Staff Activity IdColumn |
START_DT_TM | DATETIME | N | The activity Start Date and Time |
START_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
STOP_DT_TM | DATETIME | N | The activity Stop Date and Time |
STOP_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
SURG_AREA_CD | DOUBLE | N | Surgical Area Cd for the associated staff activity |
SURG_CASE_ID | DOUBLE | N | Surgical Case ID the staff is assigned to |
SURG_OP_LOC_CD | DOUBLE | N | OR the staff is assigned to |
TEAM_CD | DOUBLE | N | Team the staff is associated to |
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 | 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 | 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 - STAFF_ACTIVITY
Child Column in STAFF_ACTIVITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRSNL_ID | PRSNL | PERSON_ID |
SURG_CASE_ID | SURGICAL_CASE | SURG_CASE_ID |
SURGICAL_CASE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Surgical Case |
Definition: | Contains the attributes of a surgical case, including patient, start and stop date/time, OR, primary surgeon, etc. |
Table Type: | ACTIVITY |
Column Detail - SURGICAL_CASE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
ADDL_SUPPLIES_IND | DOUBLE | Y | Indicates that additional supplies have been requested by the Surgeon. |
ADD_ON_IND | DOUBLE | Y | Indicates that the Case is an "add-on" i.e. case is scheduled after the schedule has been finalized. |
ANESTH_PRSNL_ID | DOUBLE | N | The primary anesthesiologist associated with this surgical case |
ANESTH_TYPE_CD | DOUBLE | N | *** OBSOLETE ***Column |
APPT_ID | DOUBLE | N | *** OBSOLETE ***Column |
ASA_CLASS_CD | DOUBLE | N | Used for Surgery Mgmt Reporting -- indicates the ASA class assoc. w/ this case |
CANCEL_DT_TM | DATETIME | Y | The date and time this case was cancelled |
CANCEL_REASON_CD | DOUBLE | N | The reason this surgical case was cancelled |
CANCEL_REQ_BY_ID | DOUBLE | N | The person responsible for requesting the cancel of this case |
CANCEL_REQ_BY_TEXT | VARCHAR(100) | Y | The free-text name of the person responsible for requesting the cancel of this case (when not on prsnl table) |
CANCEL_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
CASE_LEVEL_CD | DOUBLE | N | Used for Surgery Mgmt Reporting -- indicates the case level assoc. w/ this case |
CHECKIN_BY_ID | DOUBLE | N | This is the person_id of the user that checked in the case. |
CHECKIN_DT_TM | DATETIME | Y | This is the date/time that the user checked in the case. |
CHECKIN_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
CREATE_APPLCTX | DOUBLE | Y | Context of the application creating the row |
CREATE_DT_TM | DATETIME | Y | Creation Date and Time for this row |
CREATE_PRSNL_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the creation of the row in the table. |
CREATE_TASK | DOUBLE | Y | The registered (assigned) task number for the process that created the row. |
CURR_CASE_STATUS_CD | DOUBLE | N | The current status of this case, i.e. Patient In Holding, Patient In OR, etc. |
CURR_CASE_STATUS_DT_TM | DATETIME | Y | The date and time the current status of this case became effective |
DEPT_CD | DOUBLE | N | Used for Surgery Mgmt Reporting -- indicates the department assoc. w/ this case |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
ENHANCED_UI_IND | DOUBLE | N | Stores the preference indicator(0/1) which would help differentiate whether patient chart(surgical case) documentation should occur with enhanced workflows support or not. |
INST_CD | DOUBLE | N | Used for Surgery Mgmt Reporting -- indicates the institution assoc. w/ this case |
OR_SHIFT_CD | DOUBLE | N | Used for Surgery Mgmt Reporting -- indicates the shift that the start of this case falls in |
PAT_TYPE_CD | DOUBLE | N | Used for Surgery Mgmt Reporting -- indicates the patient type assoc. with this case |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
POSTOP_DIAG_TEXT_ID | DOUBLE | N | Postop Diagonosis Text Id |
PREOP_DIAG_TEXT_ID | DOUBLE | N | Preop Diagonosis Text IdColumn |
SCHED_ANESTH_PRSNL_ID | DOUBLE | N | Used for Surgery Mgmt Reporting -- the anesthesiologist scheduled for this case |
SCHED_CASE_NBR_LOCN_CD | DOUBLE | N | Scheduled Case Number Location CodeColumn |
SCHED_CASE_TYPE_CD | DOUBLE | N | Scheduled Case Type |
SCHED_CLEANUP_DUR | DOUBLE | N | Scheduled Cleanup DurationColumn |
SCHED_DUR | DOUBLE | Y | Scheduled Case DurationColumn |
SCHED_OP_LOC_CD | DOUBLE | N | Scheduled Operating Room Location Code |
SCHED_OR_SHIFT_CD | DOUBLE | N | Used for Surgery Mgmt Reporting -- indicates the OR Shift assoc. w/ this case |
SCHED_PAT_TYPE_CD | DOUBLE | N | Scheduled Patient Type CodeColumn |
SCHED_QTY | DOUBLE | Y | Used for Surgery Mgmt Reporting -- indicates that this case has been scheduled |
SCHED_SETUP_DUR | DOUBLE | Y | Scheduled setup durationColumn |
SCHED_START_DAY | DOUBLE | Y | Used for Surgery Mgmt Reporting -- indicates the day of the week this case is scheduled to start on |
SCHED_START_DT_TM | DATETIME | Y | Scheduled Start Date TimeColumn |
SCHED_START_HOUR | DOUBLE | Y | Used for Surgery Mgmt Reporting -- indicates the hour of the day this case is scheduled to start on |
SCHED_START_MONTH | DOUBLE | Y | Used for Surgery Mgmt Reporting -- indicates the month this case is scheduled to start on |
SCHED_START_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
SCHED_SURG_AREA_CD | DOUBLE | N | Scheduled Surgical Area CodeColumn |
SCHED_SURG_SPECIALTY_ID | DOUBLE | N | *** OBSOLETE *** |
SCHED_TYPE_CD | DOUBLE | N | Scheduled Type CodeColumn |
SCH_EVENT_ID | DOUBLE | N | Scheduled Event IdColumn |
SURGEON_PRSNL_ID | DOUBLE | N | The primary surgeon associated with this surgical case |
SURG_AREA_CD | DOUBLE | N | The surgical area associated with this surgical case |
SURG_CASE_ID | DOUBLE | N | The primary key, uniquely identifying a surgical case |
SURG_CASE_NBR_CNT | DOUBLE | Y | The last portion of the OR Case Number, i.e. MAIN-1997- XXXXX. This number is incremented by 1 for each case, starting at 1 for the first case scheduled in a given year. |
SURG_CASE_NBR_FORMATTED | VARCHAR(100) | Y | The formatted Surgical case number |
SURG_CASE_NBR_LOCN_CD | DOUBLE | N | The surgical area associated with this case, used to retrieve the accession site prefix to be use in the OR Case Number, i.e. MAIN-xxxx-xxxx. |
SURG_CASE_NBR_YR | DOUBLE | Y | The middle portion of the OR Case Number, i.e. xxxx-1997-xxxx. The value is the year the case was scheduled IN, not the year the case was scheduled FOR. |
SURG_COMPLETE_QTY | DOUBLE | Y | Used for Surgery Mgmt Reporting -- indicates the completion of this case |
SURG_DUR_MIN | DOUBLE | Y | Used for Surgery Mgmt Reporting -- indicates the duration of this case |
SURG_OP_LOC_CD | DOUBLE | N | Used for Surgery Mgmt Reporting -- indicates the OR Number assoc. w/ this case |
SURG_SPECIALTY_ID | DOUBLE | N | Used for Surgery Mgmt Reporting -- indicates the surgical specialty assoc. w/ this case |
SURG_START_DAY | DOUBLE | Y | Used for Surgery Mgmt Reporting -- indicates the day of the week this case was started |
SURG_START_DT_TM | DATETIME | Y | The date and time the surgical case started. |
SURG_START_HOUR | DOUBLE | Y | Used for Surgery Mgmt Reporting -- indicates the hour of the day this case was started |
SURG_START_MONTH | DOUBLE | Y | Used for Surgery Mgmt Reporting -- indicates the month this case was started |
SURG_START_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
SURG_STOP_DT_TM | DATETIME | Y | The surgery stop date and time. |
SURG_STOP_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
TURNOVER_DUR | DOUBLE | Y | Used for Surgery Mgmt Reporting -- the turnover duration for this case |
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. |
UPDT_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
WOUND_CLASS_CD | DOUBLE | N | Used for Surgery Mgmt Reporting -- indicates the wound class assoc. w/ this case |
Relationship Detail - SURGICAL_CASE
Child Column in SURGICAL_CASE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PERSON_ID | PERSON | PERSON_ID | |
ANESTH_PRSNL_ID | PRSNL | PERSON_ID | |
CANCEL_REQ_BY_ID | PRSNL | PERSON_ID | |
CHECKIN_BY_ID | PRSNL | PERSON_ID | |
SCHED_ANESTH_PRSNL_ID | PRSNL | PERSON_ID | |
SURGEON_PRSNL_ID | PRSNL | PERSON_ID | |
SURG_SPECIALTY_ID | PRSNL_GROUP | PRSNL_GROUP_ID | |
SCH_EVENT_ID | SCH_EVENT | SCH_EVENT_ID |
Parent Column in SURGICAL_CASE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SURG_CASE_ID | CASE_ATTENDANCE | SURG_CASE_ID |
CASE_CART | SURG_CASE_ID | ||
CASE_CART_PICK_LIST | SURG_CASE_ID | ||
CASE_TIMES | SURG_CASE_ID | ||
LH_CNT_IC_ADV_SURG_DATA | SURG_CASE_ID | ||
MM_SUPPLY_CABINET | SURG_CASE_ID | ||
PERIOPERATIVE_DOCUMENT | SURG_CASE_ID | ||
RXS_ITEM_GROUP_ACT | SURG_CASE_ID | ||
RXS_LOCATION_TASK | SURG_CASE_ID | ||
SA_ANESTHESIA_RECORD | SURGICAL_CASE_ID | ||
SCHED_CASE_PICK_LIST | SURG_CASE_ID | ||
SN_ACUITY_LEVEL | SURG_CASE_ID | ||
SN_CASE_LONG_TEXT | SURG_CASE_ID | ||
SN_CASE_TRACKING | SURG_CASE_ID | ||
SN_CHARGE_HEADER | SURG_CASE_ID | ||
SN_CHARGE_ITEM | SURG_CASE_ID | ||
SN_CHARGE_QUEUE | SURG_CASE_ID | ||
SN_IMPLANT_LOG_ST | SURG_CASE_ID | ||
SN_NOMEN_ST | SURG_CASE_ID | ||
SN_PICKLIST | SURG_CASE_ID | ||
SN_SURG_CASE_ST | SURG_CASE_ID | ||
STAFF_ACTIVITY | SURG_CASE_ID | ||
SURGICAL_DELAY | SURG_CASE_ID | ||
SURG_CASE_PROCEDURE | SURG_CASE_ID |
SURGICAL_DELAY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Surgical Delay |
Definition: | Contains entries documented in Intraoperative Record associated with surgical delays |
Table Type: | ACTIVITY |
Column Detail - SURGICAL_DELAY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CREATE_APPLCTX | DOUBLE | Y | The application context responsible for inserting this row on the table |
CREATE_DT_TM | DATETIME | Y | The date and time this row was inserted on the table |
CREATE_PRSNL_ID | DOUBLE | N | The person responsible for inserting this row on the table |
CREATE_TASK | DOUBLE | Y | The task responsible for inserting this row on the table |
DEF_IND | DOUBLE | Y | OBSOLETE -- An indicator of whether or not this is a default value that has not yet been accepted by the user |
DELAY_DESC | VARCHAR(255) | Y | The description of the delay.Column |
DELAY_DOC_BY_ID | DOUBLE | N | A reference (foreign key) to the person table indicating the person responsible for documenting the intraoperative delay |
DELAY_DURATION | DOUBLE | Y | The duration of this intraoperative delay |
DELAY_OBSERVE_BY_ID | DOUBLE | N | A reference (foreign key) to the person table indicating the person that has observed the intraoperative delay |
DELAY_REASON_CD | DOUBLE | N | The reason for this intraoperative delay |
DELAY_REPORT_TO_ID | DOUBLE | N | A reference (foreign key) to the person table indicating the person this intraoperative delay was reported to. |
DELAY_REPORT_TO_TEXT | VARCHAR(100) | Y | A free-text name of the person to whom this intraoperative delay was reported to |
DISPLAY_SEQ | DOUBLE | Y | The sequence in which this intraoperative delay should be displayed |
DOC_TYPE_CD | DOUBLE | N | This column references the specific document type that this delay is associated with. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
RESULT_STATUS_FLAG | DOUBLE | Y | OBSOLETE -- The status of this entry of Surgical Delays, i.e. new unverified, Corrected, etc. |
SEGMENT_HEADER_ID | DOUBLE | N | A reference (foreign key) to the segment_header, indicating the status of this segment, i.e. Not Applicable, Accessed, Discontinued, etc. |
STAGE_CD | DOUBLE | N | Represents which surgical staging area the delay is associated with. |
SURG_AREA_CD | DOUBLE | N | The surgical area associated with this intraoperative delay |
SURG_CASE_ID | DOUBLE | N | A reference (foreign key) to the surgical_case table, indicating the surgical case associated with this delays entry. |
SURG_DELAY_ID | DOUBLE | N | The primary key, uniquely identifying a row on this table. This value is unique for each version of a Surgical Delay entry. |
SURG_DELAY_STATIC_ID | DOUBLE | N | OBSOLETE -- A value that is used to group together all versions of Surgical Delay entries. It remains static across all versions. When the first version is inserted, this value is equal to the surg_delay_id |
SURG_START_DT_TM | DATETIME | Y | The date and time this surgical encounter was started. This column was added to this table for reporting purposes |
SURG_START_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
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 - SURGICAL_DELAY
Child Column in SURGICAL_DELAY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DELAY_DOC_BY_ID | PRSNL | PERSON_ID |
DELAY_OBSERVE_BY_ID | PRSNL | PERSON_ID | |
DELAY_REPORT_TO_ID | PRSNL | PERSON_ID | |
SEGMENT_HEADER_ID | SEGMENT_HEADER | SEGMENT_HEADER_ID | |
SURG_CASE_ID | SURGICAL_CASE | SURG_CASE_ID |
SURGICAL_PROCEDURE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Surgical Procedure |
Definition: | Contains the attributes of an order catalog entry specific to a surgical procedure |
Table Type: | REFERENCE |
Column Detail - SURGICAL_PROCEDURE
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | A reference (foreign key) to the order_catalog table indicating the order catalog entry associated with this surgical procedure |
CLEANUP_TIME | DOUBLE | Y | ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. Cleanup time required for the procedure in Minutes |
CREATE_APPLCTX | DOUBLE | Y | Create Appltication ContextColumn |
CREATE_DT_TM | DATETIME | Y | Create Date and TimeColumn |
CREATE_PRSNL_ID | DOUBLE | Y | Create Personnel IdColumn |
CREATE_TASK | DOUBLE | Y | Create TaskColumn |
DEF_ANESTH_TYPE_CD | DOUBLE | N | ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. The default anesthesia type associated with this surgical procedure |
DEF_CASE_LEVEL_CD | DOUBLE | N | ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. The default case level associated with this surgical procedure, i.e. Routine 1 Circ 1 Scrub |
DEF_PROC_DUR | DOUBLE | Y | ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. The default duration associated with this surgical procedure |
DEF_WOUND_CLASS_CD | DOUBLE | N | ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. The default wound class associated with this surgical procedure |
FROZEN_SECTION_REQ_IND | DOUBLE | Y | ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. An indicator of whether or not a frozen section is required for this surgical procedure |
SETUP_TIME | DOUBLE | Y | ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. Setup Time |
SPEC_REQ_IND | DOUBLE | Y | ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. An indicator of whether or not a specimen is required for this surgical procedure. This indicator will be used when the Intraoperative Record is being verified. |
SURG_SPECIALTY_ID | DOUBLE | N | ** OBSOLETE** This column becomes obsolete when new table SURGE_PROC_DETAIL is implemented. The surgical specialty associated with this surgical procedure. Corresponds to the CDF Meaning of "SURGSPEC" on the prsnl_group 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 - SURGICAL_PROCEDURE
Child Column in SURGICAL_PROCEDURE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
SURG_SPECIALTY_ID | PRSNL_GROUP | PRSNL_GROUP_ID |
SURGICAL_STAFF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Surgical Staff |
Definition: | Surgical Staff Table |
Table Type: | REFERENCE |
Column Detail - SURGICAL_STAFF
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CREATE_APPLCTX | DOUBLE | Y | Create Application ContextColumn |
CREATE_DT_TM | DATETIME | Y | Create Date and time of the rowColumn |
CREATE_PRSNL_ID | DOUBLE | N | Prsnl Id of the person creating the rowColumn |
CREATE_TASK | DOUBLE | Y | The Application task that created the row. |
DEF_DAYS | DOUBLE | Y | Default days the surgical staff person works Saturday is 1, sunday is 2, Monday is 4.. |
DEF_ROLE_CD | DOUBLE | N | Default Role for the Personnel |
DEF_SHIFT_CD | DOUBLE | N | Default Shift the Person works |
DEF_SURG_OP_LOC_CD | DOUBLE | N | Default Operating Room the Person works in |
DEF_TEAM_CD | DOUBLE | N | Default team the person works in |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
SURG_AREA_CD | DOUBLE | N | Surgical Area the Staff is associated with |
SURG_STAFF_ID | DOUBLE | N | Unique Sequence Number for this 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 - SURGICAL_STAFF
Child Column in SURGICAL_STAFF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PRSNL | PERSON_ID |