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