Table Detail Report

AOAV_PROCESS_STS



Column Section Top of Page


Table-level Detail

Description: AOAV PROCESS STATUS
Definition: This table stores the status of various AOAV processes
Table Type: ACTIVITY





Column Detail - AOAV_PROCESS_STS


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_PROCESS_STS_ID DOUBLE N PRIMARY KEY
LOC_FACILITY_CD DOUBLE N Code value for location facility
PROCESS_DT_TM DATETIME Y Date time the process was done
PROCESS_NAME VARCHAR(40) Y The name of the process ("PERSON_FINALIZE","OUTCOMES_SUMMARY","PERSON_RETRIEVE")
PROCESS_STS_FLAG DOUBLE N Status of the given process (0:NOT-STARTED, 1: IN-PROGRESS, 2: COMPLETE, 3: ERROR)
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.


AOAV_UNIT_CONVERSION_REF



Column Section Top of Page


Table-level Detail

Description: AOAV UNIT CONVERSION REFERENCE
Definition: Table stores unit of measure conversion for one unit of measure to another
Table Type: REFERENCE





Column Detail - AOAV_UNIT_CONVERSION_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_COMP_CD DOUBLE N Code value for a component.
AOAV_UNIT_CONVERSION_REF_ID DOUBLE N PRIMARY KEY
CONVERSION_FACTOR VARCHAR(255) Y Factor value for the conversion of measure to be converted conversion
FROM_UNIT_CD DOUBLE N Code value for the unit of measure to be converted from
TO_UNIT_CD DOUBLE N Code value for the unit of measure to be converted to
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.