AGGREGATE_AREAPrompt Table: AGGR_LIMIT_TBL
AID_YEAREFFDTAGGREGATE_LEVELPrompt Table: AGGR_LVL_VW
Default Value: AGGR_LVL_LIMITS.AGGREGATE_LIMIT
AGGR_LVL_COPY(SQL View) |
Index Back |
|---|---|
Aggregate Level LimitsCopy record for Aggregate Level Limits from one Aid Year to another. |
| SELECT A.AGGREGATE_AREA , A.AID_YEAR , A.EFFDT , A.AGGREGATE_LEVEL , A.AGGREGATE_LIMIT , A.MAX_TERMS , A.CURRENCY_CD , A.CUM_AGGR_LIMIT , A.SFA_AGGR_DEP_AGLMT , A.SFA_AGGR_PPR_AGLMT , A.SFA_AGGR_AGLMT1 , A.SFA_AGGR_AGLMT2 , A.SFA_AGGR_AGLMT3 , A.SFA_AGGR_AGLMT4 , A.SFA_AGGR_AGLMT5 FROM PS_AGGR_LVL_LIMITS A |
| # | 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 |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective 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
Default Value: AGGR_LVL_LIMITS.AGGREGATE_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 |