Table Detail Report

AOAV_OUTCOME_COMP_COND_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV_OUTCOME_COMPONENT_CONDITION_RELATION
Definition: This table has the list of conditions for each component that contributed to the outcome
Table Type: ACTIVITY





Column Detail - AOAV_OUTCOME_COMP_COND_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.
AOAV_CONDITION_ID DOUBLE N Unique identifer for AOAV CONDITION
AOAV_OUTCOME_COMP_COND_R_ID DOUBLE N PRIMARY KEY
AOAV_OUTCOME_COMP_ID DOUBLE N Unique identifer for AOAV COMPONENT
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 - AOAV_OUTCOME_COMP_COND_R


Child Column in AOAV_OUTCOME_COMP_COND_R(FK) Parent Table Name Parent Column Name
Parents: AOAV_CONDITION_ID AOAV_CONDITION AOAV_CONDITION_ID
AOAV_OUTCOME_COMP_ID AOAV_OUTCOME_COMP AOAV_OUTCOME_COMP_ID


AOAV_OUTCOME_COMP_EVENT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV_OUTCOME_COMPONENT_EVENT_RELATION
Definition: This table has the list of events for each component that contributed to the outcome
Table Type: ACTIVITY





Column Detail - AOAV_OUTCOME_COMP_EVENT_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
AOAV_EVENT_ID DOUBLE N Unique identifier for AOAV EVENT
AOAV_OUTCOME_COMP_EVENT_R_ID DOUBLE N PRIMARY KEY
AOAV_OUTCOME_COMP_ID DOUBLE N Unique identifier for AOAV COMPONENT
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 - AOAV_OUTCOME_COMP_EVENT_R


Child Column in AOAV_OUTCOME_COMP_EVENT_R(FK) Parent Table Name Parent Column Name
Parents: AOAV_EVENT_ID AOAV_EVENT AOAV_EVENT_ID
AOAV_OUTCOME_COMP_ID AOAV_OUTCOME_COMP AOAV_OUTCOME_COMP_ID


AOAV_OUTCOME_TYPE_EQ_REF



Column Section Top of Page


Table-level Detail

Description: AOAV OUTCOME TYPE EQUATION REFERENCE
Definition: Table that stores the type of outcome equations reference data
Table Type: REFERENCE





Column Detail - AOAV_OUTCOME_TYPE_EQ_REF


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.
AOAV_OUTCOME_TYPE_CD DOUBLE N Code value for the outcome type
AOAV_OUTCOME_TYPE_EQ_REF_ID DOUBLE N PRIMARY KEY
BEG_EFFECTIVE_DT_TM DATETIME N 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.
END_EFFECTIVE_DT_TM DATETIME N 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.
EQUATION_CD DOUBLE N Code value for the equation
EQUATION_VERSION_NBR DOUBLE Y Version of the equation
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.


AOAV_PERSON_ENCNTR



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV_PERSON_ENCNTR
Definition: This table has all the person and encounter related information of retrieved patients
Table Type: ACTIVITY





Column Detail - AOAV_PERSON_ENCNTR


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 Y 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 Y The person who caused the active_status_cd to be set or change.
AOAV_DISCH_LOC_TYPE_CD DOUBLE N AOAV persons discharge location mapped to location codes from code set 20
AOAV_PERSON_ENCNTR_ID DOUBLE N PRIMARY KEY
AOAV_PRIOR_LOC_TYPE_CD DOUBLE N AOAV persons prior location mapped to location codes from code set 2
AOAV_RACE_CD DOUBLE N Race code of the person mapped to code values from code set 282
AOAV_SEX_CD DOUBLE N Gender code of the person mapped to code values from code set 57
BIRTH_DT_TM DATETIME Y Date of birth of the person
CALCULATED_FLAG DOUBLE N The calculated flag giving the state of the person-encounter data. 0 = needs to be calculated 1 = calculation in progress 2 = calculation done 3 = Calculation ready to summarize 4 = Calculation summarized 5 = Calculation Failed
CALC_BIT_MASK_NBR DOUBLE Y Bits determine which calculations need to be performed for the person
DECEASED_DT_TM DATETIME Y DATE AND TIME PERSON WAS DECEASED
DECEASED_IND DOUBLE N Deceased indicator 0=Not deceased, 1=Deceased
ENCNTR_ID DOUBLE N Unique identifier for the Encounter
FIRST_LEVEL_OF_CARE_DT_TM DATETIME Y The admit date time to the first AOAV level of care in the encounter
HOSP_ADMIT_DT_TM DATETIME Y Hospital admit date time of the encounter
HOSP_DISCH_DT_TM DATETIME Y Hospital discharge date time of the encounter
HOSP_DISCH_IND DOUBLE N Indicator to indicate if the hospital encounter has been discharged.
LOC_FACILITY_CD DOUBLE N Location facility code
PERSON_ID DOUBLE N Unique identifier for the Person
PREV_ENCNTR_CNT DOUBLE Y Number of previous encounters for the person
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 - AOAV_PERSON_ENCNTR


Child Column in AOAV_PERSON_ENCNTR(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


AOAV_PERSON_RETRIEVE_STS



Column Section Top of Page


Table-level Detail

Description: AOAV_PERSON_RETRIEVE_STATUS
Definition: Table that stores the status of the person retrieval
Table Type: ACTIVITY





Column Detail - AOAV_PERSON_RETRIEVE_STS


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.
AOAV_PERSON_RETRIEVE_STS_ID DOUBLE N PRIMARY KEY
RETRIEVE_DT_TM DATETIME Y Date Time the person retrieval was done
RETRIEVE_STATUS_FLAG DOUBLE N Status of person retrieval (0:NOT-STARTED, 1: IN-PROGRESS, 2: COMPLETE, 3: ERROR)
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.