SCC_VOC_ISST_VW

(SQL View)
 Index Back

Vocado Isir Student View

View of isir_student keyed by EMPLID, INSTITUTION, and AID_YEAR.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.DEPNDNCY_STAT FROM %Table(ISIR_STUDENT) A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM %Table(ISIR_STUDENT) B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM %Table(ISIR_STUDENT) C WHERE C.EMPLID = A.EMPLID AND C.INSTITUTION = A.INSTITUTION AND C.AID_YEAR = A.AID_YEAR AND C.EFFDT = A.EFFDT ) AND A.TABLE_ID = '1'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
4 DEPNDNCY_STAT Character(1) VARCHAR2(1) NOT NULL Dependency Status
1=Independent
2=Dependent
3=Indepenedent/Pro Judgmnt
D=Dependent
I=Independent
X=Dependent Reject
Y=Independent Reject
Z=Provisional Independent