PELL_INFO_VW

(SQL View)
 Index Back

Pell Information View

Pell Information View

select distinct a.emplid, a.institution, a.aid_year, a.isir_txn_nbr, a.effseq, a.orig_ssn, a.effdt, a.name_cd, a.pell_eligibility, a.efc_status, 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 and a.effdt = (select max(a1.effdt) from PS_ISIR_CONTROL a1 where a1.emplid = a.emplid and a1.institution = a.institution and a1.aid_year = a.aid_year and a1.effdt <= %CURRENTDATEIN) and a.effseq = (select max(a2.effseq) from PS_ISIR_CONTROL a2 where a2.emplid = a.emplid and a2.institution = a.institution and a2.aid_year = a.aid_year and a2.effdt = a.effdt and a2.isir_txn_nbr = a.isir_txn_nbr) and a.efc_status = 'O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: HCR_PERSON_I

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 ISIR_TXN_NBR Number(2,0) SMALLINT NOT NULL Transaction Num
5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
6 ORIG_SSN Character(9) VARCHAR2(9) NOT NULL Original SSN
7 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

8 NAME_CD Character(2) VARCHAR2(2) NOT NULL Name Code
9 PELL_ELIGIBILITY Character(1) VARCHAR2(1) NOT NULL Federal PELL Eligibility
Y=Yes
10 EFC_STATUS Character(1) VARCHAR2(1) NOT NULL EFC Status Indicator
O=Official
R=Rejected
U=Unofficial
Z=Provisional
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