SFA_CORERSP_VW(SQL View) |
Index Back |
|---|---|
FA Core Response ViewFA Core Response View |
| SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.PROCESSING_STATUS ,A.SAT_ACADEMIC_PRG ,B.FANLTR_STATUS FROM PS_STDNT_AID_ATRBT A ,PS_STDNT_AWD_PER B WHERE A.EMPLID=B.EMPLID AND A.INSTITUTION=B.INSTITUTION AND A.AID_YEAR=B.AID_YEAR AND A.TABLE_ID='1' AND B.AWARD_PERIOD='A' |
| # | 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 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: AID_YEAR_TBL |
| 4 | PROCESSING_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Aid Package Processing Status
0=No Electronic Application 1=Applied 2=Ready For Counselor Review 3=Ready for Packaging 4=Repackage 9=Packaging Completed Default Value: 0 |
| 5 | SAT_ACADEMIC_PRG | Character(1) | VARCHAR2(1) NOT NULL |
Used on Packaging Status Summary to note current Satisfactory Academic Progress status.
A=Academic Plan N=Not Meeting Satis Acad Prgrs P=Probation U=SAP Undetermined W=Warning Y=Meeting Satis Acad Progress Default Value: U |
| 6 | FANLTR_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Fin Aid Award Notification Letter (FANLTR) Status
HOLD=Hold INIT=Initial PRTD=Printed REV=Revised |