Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Financial Aid Reporting View Reports

Banner Operational Data Store
Reporting View Target: DIRECT_LOAN_SUB_USAGE

Description Contains Direct loan subsidized usage
Key & Frequency One row per person per aid year per loan id per sequence number.
Recommended Search Columns PERSON_UID,AID_YEAR,LOAN_ID,SEQUENCE_NUMBER
DOCUMENT_ID
PERSON_UID,AID_YEAR,LOAN_ID,SEQUENCE_NUMBER,CREATE_DATE

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
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

NO

NO
ACTIVITY_DATE The date that information in this record was entered or last updated. DATE

RPRDLSU

RPRDLSU_ACTIVITY_DATE

NO

NO
ACTUAL_NTC_SUP 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

NO

NO
ACTUAL_SUP The actual period of time used by the student related to this loan as calculated by COD. NUMBER

RPRDLSU

RPRDLSU_ACTUAL_SUP

NO

NO
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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)

RPRDLSU

RPRDLSU_AIDY_CODE

NO

NO
AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
ANTICIPATED_NTC_SUP 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

NO

NO
ANTICIPATED_SUP The anticipated period of time used by the student for this loan as calculated by COD. NUMBER

RPRDLSU

RPRDLSU_ANTICIPATED_SUP

NO

NO
CALC_PROGRAM_LENGTH_YRS 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

NO

NO
CREATE_DATE The created date and time for the data in this record as received from COD. DATE

RPRDLSU

RPRDLSU_CREATE_DATE

NO

NO
DATA_ORIGIN The latest source for the data contained in this record. VARCHAR2(63)

RPRDLSU

RPRDLSU_DATA_ORIGIN

NO

NO
DOCUMENT_ID The document identification number for the document in which this information was received from COD. VARCHAR2(63)

RPRDLSU

RPRDLSU_DOCUMENT_ID

NO

NO
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

NO

NO
LOAN_ID The loan id for the associated direct loan origination record. VARCHAR2(63)

RPRDLSU

RPRDLSU_DL_LOAN_ID

NO

NO
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

NO

NO
LOAN_SULA_DATA_SOURCE Indicates the source of the data in this record. VARCHAR2(63)

RPRDLSU

RPRDLSU_SOURCE

NO

NO
LOAN_SULA_DATA_SOURCE_DESC Loan sula data source description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

NO

NO
MAX_SEP 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

NO

NO
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

RPRDLSU

RPRDLSU_PIDM

NO

NO
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
REMAINING_ACTUAL_NTC_SEP 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

NO

NO
REMAINING_ACTUAL_SEP 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

NO

NO
REMAINING_ANTICIPATED_SEP 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

NO

NO
REMAINING_ANTICIP_NTC_SEP 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

NO

NO
SEQUENCE_NUMBER The number assigned to the record when created. NUMBER

RPRDLSU

RPRDLSU_SEQ_NO

NO

NO
SUM_ANTICIPATED_NTC_SUP 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

NO

NO
SUM_ANTICIPATED_SUP 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

NO

NO
SURROGATE_ID The surrogate id for this record. NUMBER

RPRDLSU

RPRDLSU_SURROGATE_ID

NO

NO
USER_ID The user ID of the person who inserted or last updated this record. VARCHAR2(63)

RPRDLSU

RPRDLSU_USER_ID

NO

NO


Ver: 9.2