Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Identifies the valid term codes within the Year selected.	VARCHAR2(6)	ROBINST RORTPRD RPRATRM SFBETRM SGBSTDN SGRCHRT SGRCOOP SGRSACT SGRSATT SGRSPRT SHRDGMR SHRTRAM SHRTTRM TBBCSTU TBRACCD	ROBINST_CURRENT_TERM_CODE RORTPRD_TERM_CODE RPRATRM_TERM_CODE SFBETRM_TERM_CODE SGBSTDN_TERM_CODE_EFF SGRCHRT_TERM_CODE_EFF SGRCOOP_TERM_CODE SGRSACT_TERM_CODE SGRSATT_TERM_CODE_EFF SGRSPRT_TERM_CODE SHRDGMR_TERM_CODE_GRAD SHRTRAM_TERM_CODE_ENTERED SHRTTRM_TERM_CODE TBBCSTU_TERM_CODE TBRACCD_TERM_CODE
ACADEMIC_PERIOD_DESC	Describes the term code and identifies what it represents. Not used in academic year.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	The year to be associated with information in this record. This may be from any of the year validations in the system.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	The description of the valid year.	VARCHAR2(30)	STVACYR	STVACYR_DESC
CURRENT_DATE	The current date.	DATE	NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
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)	NA	NA
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)	NA	NA
PERSON_UID	The internal number used to uniquely identify an individual.	NUMBER	RORSTAT RPRATRM SFBETRM SGBSTDN SGRCHRT SGRCOOP SGRSACT SGRSATT SGRSPRT SHRDGMR SHRTRAM SHRTTRM TBBCSTU TBRACCD	RORSTAT_PIDM RPRATRM_PIDM SFBETRM_PIDM SGBSTDN_PIDM SGRCHRT_PIDM SGRCOOP_PIDM SGRSACT_PIDM SGRSATT_PIDM SGRSPRT_PIDM SHRDGMR_PIDM SHRTRAM_PIDM SHRTTRM_PIDM TBBCSTU_STU_PIDM TBRACCD_PIDM
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: 8.1