Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	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: