Table Detail Report

VIRTUAL_VIEW_CRITERIA



Column Section Top of Page


Table-level Detail

Description: VIRTUAL VIEW CRITERIA
Definition: shows the criteria that applies to this row on the parent_entity_name
Table Type: REFERENCE





Column Detail - VIRTUAL_VIEW_CRITERIA


Column Name Type Null? Definition
CRITERIA_TYPE_CD DOUBLE N The type of criteria used.
CRITERIA_VALUE VARCHAR(255) N This is the value for the criteria.
CRITERIA_VALUE_ID DOUBLE N this column is used if the criteria value is an ID or a CD
CRITERIA_VALUE_PARENT_ENTITY VARCHAR(32) Y used on conjunction with the criteria_value_id column
PARENT_ENTITY_ID DOUBLE Y The object that we are entering the criteria for.
PARENT_ENTITY_NAME VARCHAR(32) Y The parent entity of the parent_entity_id number.
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.
VIRTUAL_VIEW_CRITERIA_ID DOUBLE N Unique, sequence generated number that uniquely identifies a row in the table.


VIRTUAL_VIEW_RELTN



Column Section Top of Page


Table-level Detail

Description: VIRTUAL VIEW RELTN
Definition: this relates the criteria to a view
Table Type: REFERENCE





Column Detail - VIRTUAL_VIEW_RELTN


Column Name Type Null? Definition
CRITERIA_TYPE_CD DOUBLE N The type code for the type of criteria
CRITERIA_VALUE VARCHAR(255) N This is the value for the for the criteria if the not an ID or CD
CRITERIA_VALUE_ID DOUBLE N This is the value of the criteria if an ID or CD
CRITERIA_VALUE_PARENT_ENTITY VARCHAR(32) Y The is the parent entity for criteria_value_id
PARENT_ENTITY_NAME VARCHAR(32) Y The parent entity of the item that this criteria belongs to
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.
VIRTUAL_VIEW_ID DOUBLE Y The ID for the view
VIRTUAL_VIEW_RELTN_ID DOUBLE N Unique identifier