Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Beardata Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: Z_GEO_ORIGIN_MV

Recommended Search Columns PIDM

Target Column Business Definition Database Data Type Source Name Source Column
MO_CNTY If available, Banner equivalent county code from STVCNTY whether their origin is Missouri or not. Could have NULLS. VARCHAR2(117)    
MO_CNTY_DESC Banner county description from STVCNTY VARCHAR2(38)    
NATION If available, student origin nation if outside US from STVNATN. VARCHAR2(65)    
NATION_DESC Banner nation description from STVNATN. VARCHAR2(39)    
PIDM Banner Pidm for student VARCHAR2(23)    
STATE If student origin is within US, Student original state code from first admission from Banner table STVSTAT VARCHAR2(106)    
STATE_DESC Banner state code description from STVSTAT VARCHAR2(42)    


Ver: 8.5