Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_YEAR_LENGTH	Academic Year Length	The length of the student's Academic Year at the school, calculated by COD using the Academic Year Begin and End dates reported for this loan.	NUMBER	RPRDLSU	RPRDLSU_AY_LENGTH
ACTIVITY_DATE	Activity Date	The date that information in this record was entered or last updated.	DATE	RPRDLSU	RPRDLSU_ACTIVITY_DATE
ACTUAL_NTC_SUP	Actual NTC Subsidized Usage Period	The actual period of time used by the student for this Non-Credential Teacher Certification Program loan as calculated by COD.	NUMBER	RPRDLSU	RPRDLSU_ACTUAL_NTC_SUP
ACTUAL_SUP	Actual Subsidized Usage Period	The actual period of time used by the student related to this loan as calculated by COD.	NUMBER	RPRDLSU	RPRDLSU_ACTUAL_SUP
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_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)	RPRDLSU	RPRDLSU_AIDY_CODE
AID_YEAR_DESC	Financial Aid Year Description	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ANTICIPATED_NTC_SUP	Anticipated NTC Subsidized Usage Period	The anticipated period of time used by the student for this Non-Credential Teacher Certification Program loan as calculated by COD.	NUMBER	RPRDLSU	RPRDLSU_ANTICIPATED_NTC_SUP
ANTICIPATED_SUP	Anticipated Subsidized Usage Period	The anticipated period of time used by the student for this loan as calculated by COD.	NUMBER	RPRDLSU	RPRDLSU_ANTICIPATED_SUP
CALC_PROGRAM_LENGTH_YRS	Calculated Published Program Length Years	COD's calculated published program length in academic years. When the published program length is submitted as weeks or months, the COD system converts the length to academic years.	NUMBER	RPRDLSU	RPRDLSU_CALC_PGM_LENGTH_YRS
CREATE_DATE	Create Date	The created date and time for the data in this record as received from COD.	DATE	RPRDLSU	RPRDLSU_CREATE_DATE
DATA_ORIGIN	Data Origin	The latest source for the data contained in this record.	VARCHAR2(63)	RPRDLSU	RPRDLSU_DATA_ORIGIN
DOCUMENT_ID	Document ID	The document identification number for the document in which this information was received from COD.	VARCHAR2(63)	RPRDLSU	RPRDLSU_DOCUMENT_ID
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
LOAN_ID	Loan ID	The loan id for the associated direct loan origination record.	VARCHAR2(63)	RPRDLSU	RPRDLSU_DL_LOAN_ID
LOAN_PERIOD_LENGTH	Loan Period Length	The length of the period of time covered by this loan, calculated by COD using the Financial Award Begin and End dates.	NUMBER	RPRDLSU	RPRDLSU_LOAN_PERIOD_LENGTH
LOAN_SULA_DATA_SOURCE	Loan Sula Data Source	Indicates the source of the data in this record.	VARCHAR2(63)	RPRDLSU	RPRDLSU_SOURCE
LOAN_SULA_DATA_SOURCE_DESC	Loan Sula Data Source Description	Loan sula data source description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
MAX_SEP	Max Subsidized Eligibility Period	The maximum period of time in which a student may receive a subsidized loan based on the published program length reported for this loan.	NUMBER	RPRDLSU	RPRDLSU_MAX_SEP
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
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RPRDLSU	RPRDLSU_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
REMAINING_ACTUAL_NTC_SEP	Remaining Actual NTC Subsidized Eligibility Period	Remaining actual period of time a student may receive a Sub. Loan while enrolled in a NTC Program as determined by COD. Equal to Max SEP minus Sum Actual NTC SUP.	NUMBER	RPRDLSU	RPRDLSU_REMAIN_ACTUAL_NTC_SEP
REMAINING_ACTUAL_SEP	Remaining Actual Sub Eligibility Period	The remaining period of time in which the student may receive a Subsidized Loan as determined by COD. This is equal to the Max SEP minus the Sum Actual SUP.	NUMBER	RPRDLSU	RPRDLSU_REMAINING_ACTUAL_SEP
REMAINING_ANTICIPATED_SEP	Remaining Anticipated Sub Eligibility Period	The remaining period of time in which the student may receive a Subsidized Loan as determined by COD. This is equal to the Max SEP minus the Sum Anticipated SUP.	NUMBER	RPRDLSU	RPRDLSU_REMAIN_ANTICIPATED_SEP
REMAINING_ANTICIP_NTC_SEP	Remaining Anticipated NTC Subsidized Eligibility Period	Remaining anticipated period of time a student may receive Sub. Loan while enrolled in NTC Program from COD. Equal to Max SEP minus Sum Anticipated NTC SUP.	NUMBER	RPRDLSU	RPRDLSU_REMAIN_ANTICIP_NTC_SEP
SEQUENCE_NUMBER	Sequence Number	The number assigned to the record when created.	NUMBER	RPRDLSU	RPRDLSU_SEQ_NO
SUM_ANTICIPATED_NTC_SUP	Sum Anticipated NTC Subsidized Usage Period	The sum of all actual NTC SUP for the student plus Anticipated NTC SUP for this loan as calculated by COD.	NUMBER	RPRDLSU	RPRDLSU_SUM_ANTICIP_NTC_SUP
SUM_ANTICIPATED_SUP	Sum Anticipated Sub Usage Periods	The sum of all actual subsidized usage periods for the student plus the anticipated subsidized usage periods for this loan.	NUMBER	RPRDLSU	RPRDLSU_SUM_ANTICIPATED_SUP
SURROGATE_ID	Surrogate ID	The surrogate id for this record.	NUMBER	RPRDLSU	RPRDLSU_SURROGATE_ID
USER_ID	User ID	The user ID of the person who inserted or last updated this record.	VARCHAR2(63)	RPRDLSU	RPRDLSU_USER_ID

Ver: 9.2