AGGREGATE_AREAPrompt Table: AGGR_LIMIT_TBL
AID_YEARDefault Value: 1998
Prompt Table: AGGR_LIMIT_TBL
EFFDTDefault Value: %date
AGGREGATE_LEVELPrompt Table: AGGR_LVL_VW
AGGR_LVL_LIMITS(SQL Table) |
Index Back |
|---|---|
Aggregate Level LimitsThis record contains all of the user defined aggregate types for financial aid awards and their associated limits for specified aggregate levels. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AGGREGATE_AREA |
Character(10) | VARCHAR2(10) NOT NULL |
Aggregate Area
Prompt Table: AGGR_LIMIT_TBL |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: 1998 Prompt Table: AGGR_LIMIT_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | AGGREGATE_LEVEL |
Character(2) | VARCHAR2(2) NOT NULL |
Aggregate Level
Prompt Table: AGGR_LVL_VW |
| 5 | AGGREGATE_LIMIT | Number(9,0) | DECIMAL(9) NOT NULL | Aggregate Limit |
| 6 | MAX_TERMS | Number(2,0) | SMALLINT NOT NULL | Max Terms |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | CUM_AGGR_LIMIT | Number(9,0) | DECIMAL(9) NOT NULL | Cumulative Limit |
| 9 | SFA_AGGR_DEP_AGLMT | Number(9,0) | DECIMAL(9) NOT NULL | Dependent Annual Limit |
| 10 | SFA_AGGR_PPR_AGLMT | Number(9,0) | DECIMAL(9) NOT NULL | Preparatory Annual Limit |
| 11 | SFA_AGGR_AGLMT1 | Number(9,0) | DECIMAL(9) NOT NULL | Annual Limit 1 |
| 12 | SFA_AGGR_AGLMT2 | Number(9,0) | DECIMAL(9) NOT NULL | Annual Limit 2 |
| 13 | SFA_AGGR_AGLMT3 | Number(9,0) | DECIMAL(9) NOT NULL | Annual Limit 3 |
| 14 | SFA_AGGR_AGLMT4 | Number(9,0) | DECIMAL(9) NOT NULL | Annual Limit 4 |
| 15 | SFA_AGGR_AGLMT5 | Number(9,0) | DECIMAL(9) NOT NULL | Annual Limit 5 |