FN_EV_SURVEY_ACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: FN_EV_SURVEY_ACT
Definition: Stores all survey activity data for each encounter used by Emergent Event
Table Type: ACTIVITY





Column Detail - FN_EV_SURVEY_ACT


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.
CREATE_DT_TM DATETIME Y The date and time the row was created
ENCNTR_ID DOUBLE Y encounter which the survey is associated with
FN_EV_SURVEY_ACT_ID DOUBLE N PRIMARY KEY
PERFORMED_DT_TM DATETIME Y The date and time the survey was performed
PERFORMED_PRSNL_ID DOUBLE Y personnel id of provider who performed this survey
SURVEY_GRP_ID DOUBLE Y Unique identifier for a survey activity, there may be more than one row with same survey_grp_id, but only one of those rows will be current as indicated by the active_ind field.; The group ID value will be same as PK value of first survey in the group.;
SURVEY_NAME VARCHAR(255) Y Survey name that is displayed to the user.
SURVEY_TYPE_FLAG DOUBLE Y Determines survey is Pre-Hospital, Primary, Secondary, Other
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 - FN_EV_SURVEY_ACT


Child Column in FN_EV_SURVEY_ACT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERFORMED_PRSNL_ID PRSNL PERSON_ID




Parent Column in FN_EV_SURVEY_ACT (PK) Child Table Name Child Column Name
Children: FN_EV_SURVEY_ACT_ID FN_EV_SURVEY_ELEMENT_ACT FN_EV_SURVEY_ACT_ID


FN_EV_SURVEY_DETAIL_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: FN_EV_SURVEY_DETAIL_REF
Definition: DETAILS FOR SURVEY REFERENCE
Table Type: REFERENCE





Column Detail - FN_EV_SURVEY_DETAIL_REF


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y DATE and TIME Survey details were created
FN_EV_SURVEY_DETAIL_REF_ID DOUBLE N PRIMARY KEY
FN_EV_SURVEY_REF_ID DOUBLE Y FK value for the parent table survey id
INSTANCE_NBR DOUBLE Y the instance number of the survey reference
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 - FN_EV_SURVEY_DETAIL_REF


Child Column in FN_EV_SURVEY_DETAIL_REF(FK) Parent Table Name Parent Column Name
Parents: FN_EV_SURVEY_REF_ID FN_EV_SURVEY_REF FN_EV_SURVEY_REF_ID




Parent Column in FN_EV_SURVEY_DETAIL_REF (PK) Child Table Name Child Column Name
Children: FN_EV_SURVEY_DETAIL_REF_ID FN_EV_SURVEY_ELEMENT_REF FN_EV_SURVEY_DETAIL_REF_ID


FN_EV_SURVEY_ELEMENT_ACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: FN_EV_SURVEY_ELEMENT_ACT
Definition: Stores the layout activity data of a given survey used by Emergent Event.
Table Type: ACTIVITY





Column Detail - FN_EV_SURVEY_ELEMENT_ACT


Column Name Type Null? Definition
ELEMENT_NAME VARCHAR(255) Y Indicates name of element that is displayed to the user.
ELEMENT_SEQ DOUBLE Y Indicates sequence of elements in the survey.
EVENT_CD DOUBLE Y Documented Result for a Question type. Foreign key to CODE_VALUE table
EVENT_ID DOUBLE Y Indicates event_id that was signed for the event_cd
FN_EV_SURVEY_ACT_ID DOUBLE Y Foreign key value from the FN_EV_SURVEY_ACT table
FN_EV_SURVEY_ELEMENT_ACT_ID DOUBLE N PRIMARY KEY
HIDE_IND DOUBLE Y Indicates item is hidden and not displayed to the user in the survey
LINK_EVENT_CD DOUBLE Y Event Code linked to associated nomenclature for documentation.
NOMENCLATURE_ID DOUBLE Y Stores nomenclature id that is associated to parent element.
TYPE_FLAG DOUBLE Y Indicates a SECTION or QUESTION
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 - FN_EV_SURVEY_ELEMENT_ACT


Child Column in FN_EV_SURVEY_ELEMENT_ACT(FK) Parent Table Name Parent Column Name
Parents: FN_EV_SURVEY_ACT_ID FN_EV_SURVEY_ACT FN_EV_SURVEY_ACT_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


FN_EV_SURVEY_ELEMENT_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: FN_EV_SURVEY_ELEMENT_REF
Definition: Stores the layout reference data of a given survey used by Emergent Event.
Table Type: REFERENCE





Column Detail - FN_EV_SURVEY_ELEMENT_REF


Column Name Type Null? Definition
ELEMENT_NAME VARCHAR(255) Y Indicates name of element that is displayed to the user.
ELEMENT_SEQ DOUBLE Y Indicates sequence of elements in the survey.
EVENT_CD DOUBLE Y Documented Result for a Question type. Foreign key to CODE_VALUE table
FN_EV_SURVEY_DETAIL_REF_ID DOUBLE Y Identifies the survey detail ID of the survey whic contais this element
FN_EV_SURVEY_ELEMENT_REF_ID DOUBLE N PRIMARY KEY
HIDE_IND DOUBLE Y Indicates item is hidden and not displayed to the user in the survey
LINK_EVENT_CD DOUBLE Y Event Code linked to associated nomenclature for documentation.
NOMENCLATURE_ID DOUBLE Y Stores nomenclature id that is associated to parent element.
TYPE_FLAG DOUBLE Y Indicates if the element is a SECTION or QUESTION
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 - FN_EV_SURVEY_ELEMENT_REF


Child Column in FN_EV_SURVEY_ELEMENT_REF(FK) Parent Table Name Parent Column Name
Parents: FN_EV_SURVEY_DETAIL_REF_ID FN_EV_SURVEY_DETAIL_REF FN_EV_SURVEY_DETAIL_REF_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


FN_EV_SURVEY_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: FN_EV_SURVEY_REF
Definition: Stores all parent survey reference data versions used by Emergent Event
Table Type: REFERENCE





Column Detail - FN_EV_SURVEY_REF


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y date and time the survey refernce was created
FN_EV_SURVEY_REF_ID DOUBLE N PRIMARY KEY
ORGANIZATION_ID DOUBLE Y This is the value of the unique primary identifier of the organization table. it is an internal system assigned number. ;
SURVEY_KEY_IDENT VARCHAR(255) Y Unique identification for a survey
SURVEY_NAME VARCHAR(255) Y Survey name that is displayed to the user.
SURVEY_TYPE_FLAG DOUBLE Y Determines survey is Pre-Hospital - Primary - Secondary - Other
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 - FN_EV_SURVEY_REF


Child Column in FN_EV_SURVEY_REF(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in FN_EV_SURVEY_REF (PK) Child Table Name Child Column Name
Children: FN_EV_SURVEY_REF_ID FN_EV_SURVEY_DETAIL_REF FN_EV_SURVEY_REF_ID