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

Banner Operational Data Store
Reporting View Target: STUDENT_SUB_USAGE_LIMIT

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

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
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)

RPRSULA

RPRSULA_AIDY_CODE

NO

NO
AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

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
DATA_ORIGIN The latest source for the data contained in this record. VARCHAR2(63)

RPRSULA

RPRSULA_DATA_ORIGIN

NO

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

RPRSULA

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

RPRSULA

RPRSULA_SOURCE

NO

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

RORMVAL

RORMVAL_DESC

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

RPRSULA

RPRSULA_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
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(63)

RPRSULA

RPRSULA_USER_ID

NO

NO


Ver: 9.2