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

Banner Operational Data Store
Reporting View Target: APPLICANT_PERIOD_STATUS

Description Contains expected enrollment status and if the period is locked or frozen for the student by aid enrollment period.
Key & Frequency One row per person per aid enrollment period.
Recommended Search Columns PERSON_UID,AID_ENROLLMENT_PERIOD
EXPECTED_ENROLL_STATUS
PERSON_UID,AID_YEAR,AID_PERIOD,AID_ENROLLMENT_PERIOD

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
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_ENROLLMENT_PERIOD Aid enrollment period associated with the award schedule. This period can span multiple student terms. VARCHAR2(63)

RORPRST

RORPRST_PERIOD

NO

NO
AID_ENROLLMENT_PERIOD_DESC Aid enrollment period description. VARCHAR2(255)

ROBPRDS

ROBPRDS_DESC

NO

NO
AID_PERIOD Represents a financial aid period or portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc. VARCHAR2(63)

RORSTAT

RORSTAT_APRD_CODE

NO

NO
AID_PERIOD_DESC Financial Aid period description. VARCHAR2(255)

RTVAPRD

RTVAPRD_DESC

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)

FUNCTION

ROKODSF.F_GET_FINAID_PROC_YEAR

NO

NO
AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
EXPECTED_ENROLL_STATUS Student's expected enrollment status for the school's aid enrollment period. VARCHAR2(63)

RORPRST

RORPRST_XES

NO

NO
EXPECTED_ENROLL_STATUS_DESC Aid enrollment period expected enrollment status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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
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
PERIOD_ALGORITHMIC_RULE Expected enrollment status algorithmic rule code. VARCHAR2(63)

RORPRST

RORPRST_XES_ALGO_CODE

NO

NO
PERIOD_FREEZE_IND Indicates whether the aid enrollment period is frozen preventing further updates. VARCHAR2(1)

RORPRST

RORPRST_PERIOD_FEEZE_IND

NO

NO
PERIOD_LOCKED_IND Indicates whether the student's expected enrollment status is locked preventing further updates. VARCHAR2(1)

RORPRST

RORPRST_XES_LOCK_IND

NO

NO
PERIOD_RULE_SEQUENCE_NUMBER Expected enrollment status rule sequence number. NUMBER

RORPRST

RORPRST_XES_SEQ_NO

NO

NO
PERIOD_STATUS_ACTIVITY_DATE Date record was inserted or updated. DATE

RORPRST

RORPRST_ACTIVITY_DATE

NO

NO
PERIOD_STATUS_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(63)

RORPRST

RORPRST_DATA_ORIGIN

NO

NO
PERIOD_STATUS_KEY Unique internal identification number of the aid enrollment period status record. NUMBER

RORPRST

RORPRST_SURROGATE_ID

NO

NO
PERIOD_STATUS_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

RORPRST

RORPRST_USER_ID

NO

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

RORPRST

RORPRST_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
YEAR_IN_COLLEGE The student's year in college for the period. VARCHAR2(1)

RORPRST

RORPRST_YR_IN_COLL

NO

NO
YEAR_IN_COLLEGE_DESC Year In College description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

NO

NO
YEAR_IN_COLLEGE_LOCK Identifies if the year in college is locked preventing further updates. VARCHAR2(1)

RORPRST

RORPRST_YR_IN_COLL_LOCK_IND

NO

NO
YEAR_IN_COLLEGE_RULE_CODE The algorithmic rule code used to calculate the year in college. VARCHAR2(63)

RORPRST

RORPRST_YR_IN_COLL_ALGO_CODE

NO

NO
YEAR_IN_COLLEGE_RULE_SEQ_NUM The sequence number of the rule code used to calculate the year in college. NUMBER

RORPRST

RORPRST_YR_IN_COLL_SEQ_NO

NO

NO


Ver: 9.2