V_RELATION Table

Activity_Date Refresh_Date Relation_Code Relation_Desc

Data element	Definition
Activity_Date Indexed - no Format - Date May be Null? N	The latest date any part of this record was updated in the source. Source field: STVRELT_ACTIVITY_DATE
Refresh_Date Indexed - no Format - Date May be Null? Y	Date of the latest refresh of this warehouse table
Relation_Code Indexed - yes Format - Varchar2(1) May be Null? N	Code for the type of relationship, used for Emergency Contact and Guardian information. Source field: STVRELT_CODE
Relation_Desc Indexed - no Format - Varchar2(30) May be Null? Y	Text description of Relation Code. Source field: STVRELT_DESC

V_RELATION Table