SUDS Data Dictionary
APEX_PUBLIC_USER
---
Sign Out
Home
Elements
Edits
Elements
Element: Financial Aid Award Condition I.D. - 01254
Page Name
Description:
A code to identify the condition for which the student received the financial aid award.
Coding Instructions:
Beginning in Summer 2010 this element identifies condition based on Need (N) and Non-need (A). The appropriate code to use for Condition ID for each Financial Aid Award Program Identifier (01253) is shown in the Edit Values for that element.
Prior to Summer 2010, Need and Non-need were further categorized into:
Merit - based on academic achievement.
Performance - based on talent, i.e.: athletics, music, art, etc.
Categorical - being in a group by virtue of a membership, i.e.: R.O.T.C., Seminole Indian, Confederate Survivors, etc.
Algorithm:
Usage Type:
ELEMENT
Begin Term:
192001
End Term:
Last Modified:
31-AUG-2010
Associated Submissions, Tables, and Columns
Go
Actions
Submission
Ascending
Table Name
Column name
Element ID
Tab column id
Table id
Submission name
Student Financial Aid (SFA)
FINANCIAL_AID_AWARDS (FAWD)
AWARD_COND_ID
155
551
18
Student Financial Aid
1 - 1
Search
Allowed Values
Excel code
Code
Description
Grouping
'.
.
MISSING
-
'A
A
Non-Need Based
any award that does not require demonstration of financial need for eligibility
Non-Need Based
'N
N
Need Based
any award that requires a demonstration of financial need for eligibility; include awards that have both need-based and non-need-based criteria
Need Based
Download
1 - 3
Edit Values
Go
Actions
Submission Code
Ascending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
SFA
FINANCIAL_AID_AWARDS
0008
Missing or Invalid Value
9
Critical Error: may cause submission to be rejected
SFA
FINANCIAL_AID_AWARDS
0551
Award Condition Identifier must be valid for the Award Program Identifier (01253) as indicated in the Grouping for Award Program Identifier
9
Critical Error: may cause submission to be rejected
1 - 2
Search
Prior Database Information:
Physical Description:
VARCHAR2(1)
Short Name:
AWCOND
Column Name:
AWARD_COND_ID