Reporting View Target: LOV_Z_ALUMNI_STATUS

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

SGHE Banner Operational Data Store
Reporting View Target: LOV_Z_ALUMNI_STATUS - LOV_Z_ALUMNI_STATUS

Description List of values for alumni status
Key & Frequency Loaded Daily from BANNER tables

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

TABLE_NAME STVDEGC Banner Transactional Table (STVDEGC view in SATURN schema) CHAR

VALUE STUDENT DEGREE Student degree value from the ODS degree view CHAR

VALUE_DESCRIPTION Alumnus Type Calculated Value based on the STVDEGC_DLEV_CODE value from BANNER CHAR UNDERGRADUATE, GRADUTE, NON-DEGREE, ND (NOT DEFINED)

Ver: 9.0

Description	List of values for alumni status
Key & Frequency	Loaded Daily from BANNER tables

Target Column	Business Name	Business Definition	Database Data Type	Domain Value
TABLE_NAME	STVDEGC	Banner Transactional Table (STVDEGC view in SATURN schema)	CHAR
VALUE	STUDENT DEGREE	Student degree value from the ODS degree view	CHAR
VALUE_DESCRIPTION	Alumnus Type	Calculated Value based on the STVDEGC_DLEV_CODE value from BANNER	CHAR	UNDERGRADUATE, GRADUTE, NON-DEGREE, ND (NOT DEFINED)