Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
AID_ENROLLMENT_PERIOD	Financial Aid Enrollment Period	Aid enrollment period associated with the award schedule. This period can span multiple student terms.	VARCHAR2(63)		RORPRST	RORPRST_PERIOD
AID_ENROLLMENT_PERIOD_DESC	Financial Aid Enrollment Period Description	Aid enrollment period description.	VARCHAR2(255)		ROBPRDS	ROBPRDS_DESC
AID_PERIOD	Financial Aid Period	Represents a financial aid period or portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc.	VARCHAR2(63)		RORSTAT	RORSTAT_APRD_CODE
AID_PERIOD_DESC	Financial Aid Period Description	Financial Aid period description.	VARCHAR2(255)		RTVAPRD	RTVAPRD_DESC
AID_YEAR	Financial 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
AID_YEAR_DESC	Financial Aid Year Description	Financial aid year name.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
EXPECTED_ENROLL_STATUS	Expected Enrollment Status	Student's expected enrollment status for the school's aid enrollment period.	VARCHAR2(63)		RORPRST	RORPRST_XES
EXPECTED_ENROLL_STATUS_DESC	Expected Enrollment Status Description	Aid enrollment period expected enrollment status description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERIOD_ALGORITHMIC_RULE	Period Algorithmic Rule	Expected enrollment status algorithmic rule code.	VARCHAR2(63)		RORPRST	RORPRST_XES_ALGO_CODE
PERIOD_FREEZE_IND	Period Freeze Indicator	Indicates whether the aid enrollment period is frozen preventing further updates.	VARCHAR2(1)		RORPRST	RORPRST_PERIOD_FEEZE_IND
PERIOD_LOCKED_IND	Period Locked Indicator	Indicates whether the student's expected enrollment status is locked preventing further updates.	VARCHAR2(1)		RORPRST	RORPRST_XES_LOCK_IND
PERIOD_RULE_SEQUENCE_NUMBER	Period Rule Sequence Number	Expected enrollment status rule sequence number.	NUMBER		RORPRST	RORPRST_XES_SEQ_NO
PERIOD_STATUS_ACTIVITY_DATE	Period Status Activity Date	Date record was inserted or updated.	DATE		RORPRST	RORPRST_ACTIVITY_DATE
PERIOD_STATUS_DATA_ORIGIN	Period Status Data Origin	Source system that created or updated the data.	VARCHAR2(63)		RORPRST	RORPRST_DATA_ORIGIN
PERIOD_STATUS_KEY	Period Status KEY	Unique internal identification number of the aid enrollment period status record.	NUMBER		RORPRST	RORPRST_SURROGATE_ID
PERIOD_STATUS_USER_ID	Period Status User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)		RORPRST	RORPRST_USER_ID
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER		RORPRST	RORPRST_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA

Ver: 9.0