Table Detail Report

SA_PRSNL_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Personnel Activity
Definition: Contains records that document prsnl associated to an anesthesia record Based on the # of prsnl involved in a case, and how they are tracked. Estimate 3:1 with SA_ANESTHESIA_RECORD. 78,300
Table Type: ACTIVITY





Column Detail - SA_PRSNL_ACTIVITY


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.
CREATED_DT_TM DATETIME Y Stores the date time at which personnel was added
CREATED_ID DOUBLE N Stores ID of the user who added a personnel
MAX_RES_CONCURRENCY_VAL DOUBLE N The maximum Supervisor Conurrency for the provider on the record.
MAX_SUP_CONCURRENCY_VAL DOUBLE N The maximum Resident Conurrency value for this provider on the record
PREVIOUS_PRSNL_ACTIVITY_ID DOUBLE N The previous activity record that this record replaces (because of a change), if 0 this is the original record
PRSNL_ACTIVITY_DT_TM DATETIME Y The date/time the activity occurred
PRSNL_ACTIVITY_TYPE_CD DOUBLE N The type of activity that the activity record is documenting
PRSNL_ID DOUBLE N The provider that the activity record is documenting
REFERRED_IN_SURGERY_IND DOUBLE Y Indicates if surgery documentation recorded the attendee
SA_ANESTHESIA_RECORD_ID DOUBLE N The anesthesia record that the prsnl activity is for
SA_PRSNL_ACTIVITY_ID DOUBLE N Unique value that identifies the prsnl activity record
SA_REF_CAT_PRSNL_ID DOUBLE N SA REFERENCE CATEGORY PERSONNEL ID FK TO SA_REF_CAT_PRSNL
START_IND DOUBLE Y Indicates whether this is defining a start or end time (1=start,0=end)
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_PRSNL_ACTIVITY


Child Column in SA_PRSNL_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: CREATED_ID PRSNL PERSON_ID
PRSNL_ID PRSNL PERSON_ID
SA_ANESTHESIA_RECORD_ID SA_ANESTHESIA_RECORD SA_ANESTHESIA_RECORD_ID
PREVIOUS_PRSNL_ACTIVITY_ID SA_PRSNL_ACTIVITY SA_PRSNL_ACTIVITY_ID
SA_REF_CAT_PRSNL_ID SA_REF_CAT_PRSNL SA_REF_CAT_PRSNL_ID




Parent Column in SA_PRSNL_ACTIVITY (PK) Child Table Name Child Column Name
Children: SA_PRSNL_ACTIVITY_ID SA_PRSNL_ACTIVITY PREVIOUS_PRSNL_ACTIVITY_ID
SA_PRSNL_ACTIVITY_TIME SA_PRSNL_ACTIVITY_ID


SA_PRSNL_ACTIVITY_TIME



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Personel Activity Time
Definition: Child of PRSNL_ACTIVITY (which Contains records that document prsnl associated to an anesthesia record). Based on the # of prsnl involved in a case, and how they are tracked.
Table Type: ACTIVITY





Column Detail - SA_PRSNL_ACTIVITY_TIME


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.
END_DT_TM DATETIME Y End Date and Time
PREV_PRSNL_ACTIVITY_TIME_ID DOUBLE N Parent row ID if this is a child in a recursive relationship within the table.
PULLED_TO_SURGERY_IND DOUBLE N Indicates whether the data is pulled to surgery documentation
SA_PRSNL_ACTIVITY_ID DOUBLE N ID of row in Parent Table
SA_PRSNL_ACTIVITY_TIME_ID DOUBLE N Primary Key field for this table.
SIGN_DT_TM DATETIME Y Stores the date time stamp of the signature
START_DT_TM DATETIME N The start date and time
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_PRSNL_ACTIVITY_TIME


Child Column in SA_PRSNL_ACTIVITY_TIME(FK) Parent Table Name Parent Column Name
Parents: SA_PRSNL_ACTIVITY_ID SA_PRSNL_ACTIVITY SA_PRSNL_ACTIVITY_ID
PREV_PRSNL_ACTIVITY_TIME_ID SA_PRSNL_ACTIVITY_TIME SA_PRSNL_ACTIVITY_TIME_ID




Parent Column in SA_PRSNL_ACTIVITY_TIME (PK) Child Table Name Child Column Name
Children: SA_PRSNL_ACTIVITY_TIME_ID SA_PRSNL_ACTIVITY_TIME PREV_PRSNL_ACTIVITY_TIME_ID


SA_REF_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference Action
Definition: Contains all of the actions that can be documented within an anesthesia record. Size - Based on the number of actions that are built. Estimate < 100 rows.
Table Type: REFERENCE





Column Detail - SA_REF_ACTION


Column Name Type Null? Definition
ACTION_DESCRIPTION VARCHAR(250) Y Unique value that identifies the action
ACTION_NAME VARCHAR(30) Y Display name of the action
ACTION_NAME_KEY VARCHAR(50) Y Display name of the action upper case with no blanks.
ACTION_NAME_KEY_A_NLS VARCHAR(200) Y ACTION_NAME_KEY_A_NLS column
ACTION_NAME_KEY_NLS VARCHAR(102) Y Display name of the action _key_nls format
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.
BILL_IND DOUBLE N Indicates whether action should be displayed on the billing summary
CHILD_SELECTION_REQ_IND DOUBLE N Indicates whether a value has to be entered for the action when it is documented
DEFAULT_VALUE VARCHAR(250) Y Default Value
ORIGINAL_REF_ACTION_ID DOUBLE N FK from the original SA_REF_ACTION_ID value. Used for versioning.
PRINT_IND DOUBLE N Indicates whether action detail for group should be displayed on the billing summary
REF_TYPE_FLAG DOUBLE N The type of reference this item is built for (I.e Anesthesia (0), CVNet (1)
REMINDER_FREQUENCY_MINS DOUBLE Y The interval in minutes which represents the default value of frequency of the reminder associated to an action.
SA_REF_ACTION_ID DOUBLE N Unique value that identifies the action Primary Key
SA_REF_ICON_ID DOUBLE N The icon associated with the action it
SIGNATURE_REQUIRED_IND DOUBLE N Determines if action signature is required
SINGLE_DOC_IND DOUBLE N Defines whether the action can be documented multiple times or only once per record
SUPERVISOR_SIGN_REQ_IND DOUBLE N The supervisor_sign_req_ind is set to '1' if supervisor signature is required on the action, else it is set to '0'
TASK_ASSAY_CD DOUBLE N Task Assay Code - code set 14003
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.
VALUE_REQUIRED_IND DOUBLE Y Indicates whether a value has to be entered for the action when it is documented (1=value must be entered,0=a value doesn't have to be entered)
VALUE_TYPE_FLAG DOUBLE Y The type of value that can be entered for this action
VERSION_NBR DOUBLE N Version Number. Used for Versioning.



Relationship Detail - SA_REF_ACTION


Child Column in SA_REF_ACTION(FK) Parent Table Name Parent Column Name
Parents: ORIGINAL_REF_ACTION_ID SA_REF_ACTION SA_REF_ACTION_ID
SA_REF_ICON_ID SA_REF_ICON SA_REF_ICON_ID




Parent Column in SA_REF_ACTION (PK) Child Table Name Child Column Name
Children: SA_REF_ACTION_ID SA_ACTION SA_REF_ACTION_ID
SA_REF_ACTION ORIGINAL_REF_ACTION_ID
SA_REF_ACTION_GROUP_R SA_REF_ACTION_ID
SA_REF_CAT_ACTION SA_REF_ACTION_ID
SA_REF_EXCLUDE_ACTION SA_REF_ACTION_ID
SA_REF_MACRO_ACTION SA_REF_ACTION_ID
SA_REF_REQUIRED_ACTION SA_REF_ACTION_ID
SA_TODO_ACTION SA_REF_ACTION_ID


SA_REF_ACTION_GROUP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference Action Group
Definition: Contains the top level groups of an anesthesia Action. Size - Based on the number of actions that are built. Estimate 2:1 with SA_REF_ACTION.
Table Type: REFERENCE





Column Detail - SA_REF_ACTION_GROUP_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.
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_REF_ACTION_GROUP_R_ID DOUBLE N Unique value that identifies the action group
SA_REF_ACTION_ID DOUBLE N The anesthesia action that has this group record contained within it
SA_REF_GROUP_ID DOUBLE N The group that belongs to the anesthesia action
SEQUENCE DOUBLE N The sequence the group should be displayed when displayed with the other groups for the anesthesia Action
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_REF_ACTION_GROUP_R


Child Column in SA_REF_ACTION_GROUP_R(FK) Parent Table Name Parent Column Name
Parents: SA_REF_ACTION_ID SA_REF_ACTION SA_REF_ACTION_ID
SA_REF_GROUP_ID SA_REF_GROUP SA_REF_GROUP_ID


SA_REF_ACTION_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference Action Item
Definition: Contains all the lower-level action items that can be used to document an anesthesia action. Size - Based on the number of actions that are built. Estimate 2:1 with SA_REF_ACTION.
Table Type: REFERENCE





Column Detail - SA_REF_ACTION_ITEM


Column Name Type Null? Definition
ACTION_ITEM_DESCRIPTION VARCHAR(250) Y A description of what the action item documents
ACTION_ITEM_NAME VARCHAR(50) Y The display name of the action item
ACTION_ITEM_NAME_KEY VARCHAR(50) Y The display name of the action item _key format
ACTION_ITEM_NAME_KEY_A_NLS VARCHAR(200) Y ACTION_ITEM_NAME_KEY_A_NLS column
ACTION_ITEM_NAME_KEY_NLS VARCHAR(102) Y The display name of the action item _key format NLS form
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.
CHILD_SELECTION_REQ_IND DOUBLE N Indicates that a lower level action item must be selected if this action item is selected
DEFAULT_VALUE VARCHAR(250) Y Default Value
SA_REF_ACTION_ITEM_ID DOUBLE N Unique value that identifies the action item
TASK_ASSAY_CD DOUBLE N The task assay code associated to the response item.
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.
VALUE_REQUIRED_IND DOUBLE N Indicates that a value must be associated to the action item if this item is selected
VALUE_TYPE_FLAG DOUBLE N Indicates the type of value that is associated to the action item (string, number, item, etc.)



Relationship Detail - SA_REF_ACTION_ITEM




Parent Column in SA_REF_ACTION_ITEM (PK) Child Table Name Child Column Name
Children: SA_REF_ACTION_ITEM_ID SA_ACTION_ITEM SA_REF_ACTION_ITEM_ID
SA_REF_ACTION_ITEM_CHILD_GROUP SA_REF_ACTION_ITEM_ID
SA_REF_GROUP_ACTION_ITEM_R SA_REF_ACTION_ITEM_ID
SA_REF_MACRO_ACTION_ITEM SA_REF_ACTION_ITEM_ID
SA_TODO_ACTION_ITEM SA_REF_ACTION_ITEM_ID