Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	The date that information in this record was entered or last updated.	DATE	RPRSULA	RPRSULA_ACTIVITY_DATE	NO	NO
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(4)	RPRSULA	RPRSULA_AIDY_CODE	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CREATE_DATE	The created date and time for the data in this record as received from COD.	DATE	RPRSULA	RPRSULA_CREATE_DATE	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	NA	NO	NO
DATA_ORIGIN	The latest source for the data contained in this record.	VARCHAR2(30)	RPRSULA	RPRSULA_DATA_ORIGIN	NO	NO
DOCUMENT_ID	The document identification number for the document in which this information was received from COD.	VARCHAR2(30)	RPRSULA	RPRSULA_DOCUMENT_ID	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
LOAN_SULA_DATA_SOURCE	Indicates the source of the data in this record.	VARCHAR2(2)	RPRSULA	RPRSULA_SOURCE	NO	NO
LOAN_SULA_DATA_SOURCE_DESC	Loan sula data source 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
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RPRSULA	RPRSULA_PIDM	NO	NO
SEQUENCE_NUMBER	The number assigned to the record when created.	NUMBER	RPRSULA	RPRSULA_SEQ_NO	NO	NO
SULA_FLAG	Indicates a student is subject to the 150% Subsidized Usage Limit.	VARCHAR2(1)	RPRSULA	RPRSULA_FLAG	NO	NO
SUM_ACTUAL_NTC_SUP	The sum of all actual non-credential teacher certification program subsidized usage periods for the student.	NUMBER	RPRSULA	RPRSULA_SUM_ACTUAL_NTC_SUP	NO	NO
SUM_ACTUAL_SUP	The sum of all actual subsidized usage periods for the student, excluding those for Non-Credential Teacher Certification programs.	NUMBER	RPRSULA	RPRSULA_SUM_ACTUAL_SUP	NO	NO
SURROGATE_ID	The surrogate id for this record.	NUMBER	RPRSULA	RPRSULA_SURROGATE_ID	NO	NO
USER_ID	The user ID of the person who inserted or last updated this record.	VARCHAR2(30)	RPRSULA	RPRSULA_USER_ID	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: