• Elements

  • Element: Need Based Aid Flag - 01446

Page Name

Indicates if the condition for which any financial aid award received was need based

Load programs on FINANCIAL_AID_DEMO table will value based on FINANCIAL_AID_AWARDS records.

For the RET: This field is stored on every Retention Demographic Record when the individual is tied to a valid SSN. When the Person Identification Number is not tied to a valid SSN, then this field is only stored on the Retention Demographic records having the same REPT_INST (01045) and Person Identification Number.

DERIVED

192001

18-SEP-2008


Associated Submissions, Tables, and Columns

Allowed Values

Excel code
Code
Description
Grouping
'..
MISSING		-
'NNNon-Need Based Financial Aid
'PPAt least one occurrence of Pell Need Based Aid
'XXNo Financial Aid Reported (Retention File)
'YYNeed Based Financial Aid
Download

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
SFAFINANCIAL_AID_DEMO4258Frequency of Values for FINANCIAL_AID_DEMO.NEED_BASED_AID_IND0Frequency Distribution: not an indication of an error
SFAFINANCIAL_AID_DEMO6183Set NEED_BASED_IND to 'P' if AWARD_PROG_IND = '001' 1Generated or Modified during SUDS Edit Process
SFAFINANCIAL_AID_DEMO6350Set NEED_BASED_IND to 'N' if AWARD_COND_IND in ('5', '6', '7', '8','A') 1Generated or Modified during SUDS Edit Process
SFAFINANCIAL_AID_DEMO6351Set NEED_BASED_IND to 'Y' if AWARD_COND_IND in ('1', '2', '3', '4','N') 1Generated or Modified during SUDS Edit Process
  • 1 - 4

Prior Database Information:

VARCHAR2(1)
NEEDBASE
NEED_BASED_AID
Release 2.0