Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

Banner Operational Data Store
Composite View Target: AR_DIRECT_LOAN_SUB_USAGE

Description Source composite view contains Direct loan subsidized usage

Target Column Business Definition Database Data Type Source Name Source Column
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 The date that information in this record was entered or last updated. DATE

RPRDLSU

RPRDLSU_ACTIVITY_DATE

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

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

RPRDLSU

RPRDLSU_ACTUAL_SUP

AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(4)

RPRDLSU

RPRDLSU_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

ANTICIPATED_SUP 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 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 The created date and time for the data in this record as received from COD. DATE

RPRDLSU

RPRDLSU_CREATE_DATE

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

NA

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

RPRDLSU

RPRDLSU_DATA_ORIGIN

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

RPRDLSU

RPRDLSU_DOCUMENT_ID

DOMAIN_VALUE Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

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

RPRDLSU

RPRDLSU_DL_LOAN_ID

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 Indicates the source of the data in this record. VARCHAR2(2)

RPRDLSU

RPRDLSU_SOURCE

LOAN_SULA_DATA_SOURCE_DESC Loan sula data source description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

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

RPRDLSU

RPRDLSU_PIDM

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

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

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

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

SEQUENCE_NUMBER The number assigned to the record when created. NUMBER

RPRDLSU

RPRDLSU_SEQ_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

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

SURROGATE_ID The surrogate id for this record. NUMBER

RPRDLSU

RPRDLSU_SURROGATE_ID

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

RPRDLSU

RPRDLSU_USER_ID

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: