EMPLIDPrompt Table: PEOPLE_SRCH
INSTITUTIONPrompt Table: INSTITUTION_TBL
AID_YEARPrompt Table: STUDENT_AID
PELL_TRANS_NBRPELL_EFFDTPELL_EFFSEQO=Official
R=Rejected
U=Unofficial
Z=Provisional
Y=Yes
PELL_INFO_VW4(SQL View) |
Index Back |
|---|---|
Pell Information ViewPell Information View |
| SELECT DISTINCT A.EMPLID, A.INSTITUTION, A.AID_YEAR, A.ISIR_TXN_NBR, A.EFFDT, A.EFFSEQ, A.EFC_STATUS, A.ORIG_SSN, A.NAME_CD, A.PELL_ELIGIBILITY, B.PRIMARY_EFC, B.SECONDARY_EFC FROM PS_ISIR_CONTROL A, PS_ISIR_COMPUTED B WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.EFFDT=B.EFFDT AND A.EFFSEQ=B.EFFSEQ |
| # | 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: STUDENT_AID |
| 4 | PELL_TRANS_NBR |
Number(2,0) | SMALLINT NOT NULL | Transaction Num |
| 5 | PELL_EFFDT |
Date(10) | DATE | Effective Date |
| 6 | PELL_EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 7 | EFC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
EFC Status Indicator
O=Official R=Rejected U=Unofficial Z=Provisional |
| 8 | ORIG_SSN | Character(9) | VARCHAR2(9) NOT NULL | Original SSN |
| 9 | NAME_CD | Character(2) | VARCHAR2(2) NOT NULL | Name Code |
| 10 | PELL_ELIGIBILITY | Character(1) | VARCHAR2(1) NOT NULL |
Federal PELL Eligibility
Y=Yes |
| 11 | PRIMARY_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Primary EFC |
| 12 | SECONDARY_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Secondary EFC |