V_ORIG_DEPT Table

Activity_Date Orig_Dept_Code Orig_Dept_Desc Refresh_Date

Data element	Definition
Activity_Date Indexed - no Format - Date May be Null? N	Latest date the record was entered or updated in the source. Source field: STVORIG_ACTIVITY_DATE
Orig_Dept_Code Indexed - no Format - Varchar2(4) May be Null? N	Code for the originating department. Source field: STVORIG_CODE
Orig_Dept_Desc Indexed - no Format - Varchar2(30) May be Null? Y	Descriptive text title of the originating department. Source field: STVORIG_DESC
Refresh_Date Indexed - no Format - Date May be Null? Y	Date this table in the warehouse was last refreshed.

V_ORIG_DEPT Table