RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE Operational Data Store
Composite View Target: AS_RACE

Target Column Business Definition Database Data Type Source Name Source Column
CURRENT_DATE CURRENT_DATE: The current date. DATE    
DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)    
MIF_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)    
MIF_VALUE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)    
PERSON_UID This is the system generated number that is internally generated to uniquely identify the person. NUMBER(8)    
RACE Institution defined race code that breaks the race regulatory code down into sub_groups. VARCHAR2(3)    
RACE_CATEGORY Regulatory Race code. In 1997, the Department of Labor under the Office of Management and Budget (OMB), mandated changes to the collection of race and ethnicity. Specifically, the classifications were changed to separate Race and Ethnicity by redfining the 'Hispanic or Latino' classification from race to ethnicity. VARCHAR2(1)    
RACE_CATEGORY_DESC Regulatory Race code description. VARCHAR2(60)    
RACE_DESC Race sub group description. VARCHAR2(60)    
ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)    


Ver: 3.1