Table Detail Report
SA_ANESTHESIA_REC_FIELD_VALUES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SA Anesthesia Record Field Values |
Definition: | Stores field values for anesthesia record |
Table Type: | ACTIVITY |
Column Detail - SA_ANESTHESIA_REC_FIELD_VALUES
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. |
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 | N | 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. |
ADMIT_REASON | VARCHAR(255) | Y | Reason For Admit |
ANESTHESIA_TYPE_CD | DOUBLE | N | Anesthesia Type Code |
ANESTHESIOLOGIST_ID | DOUBLE | N | Anesthesiologist ID |
ASA_CLASS_CD | DOUBLE | N | ASA Class Code |
CARDIOLOGIST_ID | DOUBLE | N | Cardiologist ID |
DIAGNOSIS_NOMENCLATURE_ID | DOUBLE | N | Diagnosis Nomenclature |
ENCNTR_ID | DOUBLE | N | ENCOUNTER ID |
NPO_DT_TM | DATETIME | Y | NPO Date / Time |
OR_CD | DOUBLE | N | Operating Room Code |
PERSON_ID | DOUBLE | N | Person ID |
PHYSICIAN_ID | DOUBLE | N | Physician ID |
PRE_OP_DIAGNOSIS_TXT | VARCHAR(255) | Y | Pre Op Diagnosis TEXT |
PROBLEM_NOMENCLATURE_ID | DOUBLE | N | Problem Nomenclature |
PROCEDURE_NOMENCLATURE_ID | DOUBLE | N | Procedure Nomenclature |
SA_ANESTHESIA_RECORD_ID | DOUBLE | N | SA Anesthesia Record Id |
SA_ANESTHESIA_REC_FIELD_VAL_ID | DOUBLE | N | Unique identifier |
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 - SA_ANESTHESIA_REC_FIELD_VALUES
Child Column in SA_ANESTHESIA_REC_FIELD_VALUES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
DIAGNOSIS_NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
PROBLEM_NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
PROCEDURE_NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
PERSON_ID | PERSON | PERSON_ID | |
ANESTHESIOLOGIST_ID | PRSNL | PERSON_ID | |
CARDIOLOGIST_ID | PRSNL | PERSON_ID | |
PHYSICIAN_ID | PRSNL | PERSON_ID | |
SA_ANESTHESIA_RECORD_ID | SA_ANESTHESIA_RECORD | SA_ANESTHESIA_RECORD_ID |
SA_ANESTHESIA_REC_LOCK
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SA Anesthesia Record Lock |
Definition: | Contains records for when an anesthesia record is opened/closed for documentation - an anesthesia record can only be opened for documentation on one PC 1 record each time an anesthesia record is opened/closed in IA for documentation. Estimate 2:1 with SA_ANESTHESIA_RECORD. 52,200 |
Table Type: | ACTIVITY |
Column Detail - SA_ANESTHESIA_REC_LOCK
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. |
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 | N | 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. |
LOCKED_BY_PRSNL_ID | DOUBLE | N | User who is opening or who has closed the record |
LOCKED_DT_TM | DATETIME | Y | Date/Time the record was locked (opened) or unlocked (closed) |
LOCKED_IND | DOUBLE | Y | Indicates whether this record is for an anes record being locked (opened) or unlocked (closed) 1=locked |
LOCKED_LOCATION_CD | DOUBLE | N | Location where the PC that has locked (opened) or unlocked (closed) the anesthesia record is located. |
SA_ANESTHESIA_RECORD_ID | DOUBLE | N | The Anesthesia Record that is being locked (opened) or unlocked (closed) |
SA_ANESTHESIA_REC_LOCK_ID | DOUBLE | N | Unique value to the anesthesia record lock record |
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 - SA_ANESTHESIA_REC_LOCK
Child Column in SA_ANESTHESIA_REC_LOCK(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SA_ANESTHESIA_RECORD_ID | SA_ANESTHESIA_RECORD | SA_ANESTHESIA_RECORD_ID |
SA_ANESTHESIA_REC_SIGNATURE
Column Section | Top of Page |
Table-level Detail
Description: | Surginet Anesthesia Record Signature |
Definition: | Surginet Anesthesia Record Signature - used to store signatures for the anesthesia record. |
Table Type: | ACTIVITY |
Column Detail - SA_ANESTHESIA_REC_SIGNATURE
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. |
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 | N | 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. |
SA_ANESTHESIA_RECORD_ID | DOUBLE | N | Anesthesia Record ID - FK to anesthesia record |
SA_ANESTHESIA_REC_SIGNATURE_ID | DOUBLE | N | Anesthesia Record Signature ID - Primary Key |
SIGNATURE_DT_TM | DATETIME | N | Signature Date and time |
SIGNED_BY_PRSNL_ID | DOUBLE | N | Signed by personnel ID |
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. |
SA_ANESTHESIA_REC_STATUS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SA Anesthesia Record Status |
Definition: | Contains records for when an anesthesia records status changes (unfinalized,finalized,etc) 1 record each time an anesthesia record is finalized or unfinalized. Estimate 2:1 with SA_ANESTHESIA_RECORD. 52,200 |
Table Type: | ACTIVITY |
Column Detail - SA_ANESTHESIA_REC_STATUS
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. |
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 | N | 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. |
PRINT_STATUS_FLAG | DOUBLE | N | Used to indicate whether the billing summary needs to be printed for the anesthesia record. 0 = not printed; 1 = printed; 2 = needs to be re-printed. |
PRSNL_ID | DOUBLE | N | User that changed the status of the anesthesia record |
SA_ANESTHESIA_RECORD_ID | DOUBLE | N | The Anesthesia Record that the status refers to |
SA_ANESTHESIA_REC_STATUS_ID | DOUBLE | N | Unique value to the anesthesia record status record |
STATUS_DT_TM | DATETIME | N | Date/Time the status of the anesthesia record was changed |
STATUS_TYPE_FLAG | DOUBLE | N | Determines status of anesthesia record (0=finalized, 1=unfinalized) |
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 - SA_ANESTHESIA_REC_STATUS
Child Column in SA_ANESTHESIA_REC_STATUS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SA_ANESTHESIA_RECORD_ID | SA_ANESTHESIA_RECORD | SA_ANESTHESIA_RECORD_ID |
SA_CASE_ATTRIBUTE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SA Case Attribute |
Definition: | Contains Case Information for the Record |
Table Type: | ACTIVITY |
Column Detail - SA_CASE_ATTRIBUTE
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. |
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 | N | 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. |
CASE_ATTRIBUTE_SEQUENCE | DOUBLE | N | Sequence of the attribute (if they are the same type cd) |
CASE_ATTRIBUTE_TYPE_CD | DOUBLE | N | The type of attribute |
CASE_ATTRIBUTE_VALUE_TXT | VARCHAR(255) | N | The value for the attribute |
SA_ANESTHESIA_RECORD_ID | DOUBLE | N | The anesthesia record the attribute is associated to |
SA_CASE_ATTRIBUTE_ID | DOUBLE | N | Unique identifier for the record |
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 - SA_CASE_ATTRIBUTE
Child Column in SA_CASE_ATTRIBUTE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SA_ANESTHESIA_RECORD_ID | SA_ANESTHESIA_RECORD | SA_ANESTHESIA_RECORD_ID |