STDNT_AGGR_LIFE(SQL Table) |
Index Back |
|---|---|
Lifetime Aggregate AwardsLifetime totals by aggregate area for awards given to a student. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | AGGREGATE_AREA |
Character(10) | VARCHAR2(10) NOT NULL |
Aggregate Area
Prompt Table: AGGR_LIMIT_VW |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: FED_AID_YR_TBL |
| 4 | UNDRGRAD_TOTAL | Number(12,2) | DECIMAL(11,2) NOT NULL | Total Undergrad |
| 5 | GRADUATE_TOTAL | Number(12,2) | DECIMAL(11,2) NOT NULL | Total Graduate |
| 6 | TOTAL_TERMS | Number(2,0) | SMALLINT NOT NULL | Total Terms |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY |
| 8 | SFA_NSLDS_AGGR_AMT | Number(12,2) | DECIMAL(11,2) NOT NULL | FA-Aggregate: NSLDS Total |
| 9 | OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Copy Method
Y/N Table Edit |
| 10 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 11 | SFA_NSLDS_UPDDTTM | DateTime(26) | TIMESTAMP | FA-Aggregates: NSLDS Total Override Date/Time |
| 12 | SFA_NSLDS_PUSH_DT | Date(10) | DATE | FA-Aggregates: Date NSLDS Data was pushed. |
| 13 | SFA_PKG_DEP_STAT | Character(1) | VARCHAR2(1) NOT NULL |
FA-Aggregates: Dependency Status used during Award Packaging
D=Dependent I=Independent M=Married S=Sole Support |
| 14 | PAR_CREDIT_WORTHY | Character(1) | VARCHAR2(1) NOT NULL |
Parent Credit Worthiness
I=Institutional Override |
| 15 | DL_HEAL_LN_SW | Character(1) | VARCHAR2(1) NOT NULL | HEAL Eligible |
| 16 | SFA_NSLDS_GRAD_AMT | Number(12,2) | DECIMAL(11,2) NOT NULL | FA-Aggregate: NSLDS Graduate Total |
| 17 | SFA_GRAD_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
FA Aggregates - override indicator for NSLDS graduate total
Y/N Table Edit Default Value: N |
| 18 | SFA_PRCNT_USED_RPT | Number(8,4) | DECIMAL(7,4) NOT NULL | Reported Percent Scheduled Used |
| 19 | SFA_PRCNT_USED_TOT | Number(8,4) | DECIMAL(7,4) NOT NULL | Total Percent Scheduled Used |
| 20 | SFA_PRCNT_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Percent Scheduled Used Override flag.
Y/N Table Edit |
| 21 | SFA_LEU_NSLDS | Number(9,4) | DECIMAL(8,4) NOT NULL | Lifetime Eligibility Used |
| 22 | SFA_LEU_NSLDS_OVRD | Character(1) | VARCHAR2(1) NOT NULL |
Percent Scheduled Used Override flag.
Y/N Table Edit |