SFA_ADM_APPL_VW (SQL View)	Index Back
Admission Application Data VW SFA_ADM_APPL_VW joins PS_ADM_APPL_DATA and PS_EXT_ORG_TBL_ADM to select the row with the latest/maximum graduation date from PS_ADM_APPL_DATA, grouped by EMPLID and LS_SCHOOL_TYPE. The view is used in Financial Aid Equations to determine a valid High School graduation date for ACG eligibility.

SFA_ADM_APPL_VW

(SQL View)

Admission Application Data VW

SFA_ADM_APPL_VW joins PS_ADM_APPL_DATA and PS_EXT_ORG_TBL_ADM to select the row with the latest/maximum graduation date from PS_ADM_APPL_DATA, grouped by EMPLID and LS_SCHOOL_TYPE. The view is used in Financial Aid Equations to determine a valid High School graduation date for ACG eligibility.

SELECT A.EMPLID , B.LS_SCHOOL_TYPE , MAX(A.GRADUATION_DT) FROM PS_ADM_APPL_DATA A , PS_EXT_ORG_TBL_ADM B WHERE A.LAST_SCH_ATTEND = B.EXT_ORG_ID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_EXT_ORG_TBL B1 WHERE B1.EXT_ORG_ID = B.EXT_ORG_ID AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' GROUP BY A.EMPLID, B.LS_SCHOOL_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 LS_SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL School Type

3 GRADUATION_DT Date(10) DATE Graduation Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	LS_SCHOOL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	School Type
3	GRADUATION_DT	Date(10)	DATE	Graduation Date