EMPLIDN=No
Y=Yes
NSLDS_FATAGGRVW(SQL View) |
Index Back |
|---|---|
NSLDS FA Term Aggregate ViewNSLDS FA Term Aggregate View |
| SELECT A.EMPLID ,A.EFFDT ,A.EFFSEQ ,A.AGGR_SUBSDZD_TOTAL ,A.AGGR_UNSUB_TOTAL ,A.AGGR_COMB_TOTAL ,A.AGGR_CONSL_TOTAL ,A.NSLDS_AGGR_PERKINS ,A.NSLDS_YTD_PERKINS ,A.SFA_LIFETIME_ELIG ,A.SFA_NSLDS_USE_LMT ,A.SFA_NSLDS_LN_ELIG FROM PS_NSLDS_FAT_AGGR A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_NSLDS_FAT_AGGR B WHERE B.EMPLID = A.EMPLID AND B.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_NSLDS_FAT_AGGR C WHERE C.EMPLID = A.EMPLID AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_NSLDS_FAT_AGGR D WHERE D.EMPLID = A.EMPLID AND D.EFFDT <= %CurrentDateIn ) ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT | Date(10) | DATE | Effective Date |
| 3 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 4 | AGGR_SUBSDZD_TOTAL | Number(6,0) | INTEGER NOT NULL | Total Aggregate Subsidized |
| 5 | AGGR_UNSUB_TOTAL | Number(6,0) | INTEGER NOT NULL | Aggregate Unsub Total |
| 6 | AGGR_COMB_TOTAL | Number(6,0) | INTEGER NOT NULL | Aggregate Combined Total |
| 7 | AGGR_CONSL_TOTAL | Number(6,0) | INTEGER NOT NULL | Aggregate Consolidated Total |
| 8 | NSLDS_AGGR_PERKINS | Number(6,0) | INTEGER NOT NULL | NSLDS Aggregate Perkins |
| 9 | NSLDS_YTD_PERKINS | Number(6,0) | INTEGER NOT NULL | NSLDS Perkins YTD |
| 10 | SFA_LIFETIME_ELIG | Number(8,5) | DECIMAL(7,5) NOT NULL | Lifetime Eligibility Used |
| 11 | SFA_NSLDS_USE_LMT | Character(1) | VARCHAR2(1) NOT NULL |
NSLDS Sub Usage Limit Applies
N=No Y=Yes |
| 12 | SFA_NSLDS_LN_ELIG | Number(7,3) | DECIMAL(6,3) NOT NULL | Subsidized Usage Period |