Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
AID_ENROLLMENT_PERIOD	Aid enrollment period associated with the award schedule. This period can span multiple student terms.	VARCHAR2(63)	RORPRST	RORPRST_PERIOD	NO	NO
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(63)	FUNCTION	ROKODSF.F_GET_FINAID_PROC_YEAR	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	NA	NO	NO
DOMAIN_VALUE	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EXPECTED_ENROLL_STATUS	Student's expected enrollment status for the school's aid enrollment period.	VARCHAR2(63)	RORPRST	RORPRST_XES	NO	NO
EXPECTED_ENROLL_STATUS_DESC	Aid enrollment period expected enrollment status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
PERIOD_ALGORITHMIC_RULE	Expected enrollment status algorithmic rule code.	VARCHAR2(63)	RORPRST	RORPRST_XES_ALGO_CODE	NO	NO
PERIOD_FREEZE_IND	Indicates whether the aid enrollment period is frozen preventing further updates.	VARCHAR2(1)	RORPRST	RORPRST_PERIOD_FEEZE_IND	NO	NO
PERIOD_LOCKED_IND	Indicates whether the student's expected enrollment status is locked preventing further updates.	VARCHAR2(1)	RORPRST	RORPRST_XES_LOCK_IND	NO	NO
PERIOD_RULE_SEQUENCE_NUMBER	Expected enrollment status rule sequence number.	NUMBER	RORPRST	RORPRST_XES_SEQ_NO	NO	NO
PERIOD_STATUS_ACTIVITY_DATE	Date record was inserted or updated.	DATE	RORPRST	RORPRST_ACTIVITY_DATE	NO	NO
PERIOD_STATUS_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(63)	RORPRST	RORPRST_DATA_ORIGIN	NO	NO
PERIOD_STATUS_KEY	Unique internal identification number of the aid enrollment period status record.	NUMBER	RORPRST	RORPRST_SURROGATE_ID	NO	NO
PERIOD_STATUS_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	RORPRST	RORPRST_USER_ID	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RORPRST	RORPRST_PIDM	NO	NO
YEAR_IN_COLLEGE	The student's year in college for the period.	VARCHAR2(1)	RORPRST	RORPRST_YR_IN_COLL	NO	NO
YEAR_IN_COLLEGE_DESC	Year In College description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
YEAR_IN_COLLEGE_LOCK	Identifies if the year in college is locked preventing further updates.	VARCHAR2(1)	RORPRST	RORPRST_YR_IN_COLL_LOCK_IND	NO	NO
YEAR_IN_COLLEGE_RULE_CODE	The algorithmic rule code used to calculate the year in college.	VARCHAR2(63)	RORPRST	RORPRST_YR_IN_COLL_ALGO_CODE	NO	NO
YEAR_IN_COLLEGE_RULE_SEQ_NUM	The sequence number of the rule code used to calculate the year in college.	NUMBER	RORPRST	RORPRST_YR_IN_COLL_SEQ_NO	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: