EMPLIDSFA_EXT_ACAD_VW(SQL View) |
Index Back |
|---|---|
External Academic Data ViewSFA_EXT_ACAD_VW selects the row with the latest TO_DT from PS_EXT_ACAD_DATA where EXT_CAREER = 'HS' to determine the High School graduation date. This view is used in Financial Aid Equations to determine ASG eligibility. |
| SELECT EMPLID , MAX(TO_DT) FROM PS_EXT_ACAD_DATA WHERE EXT_CAREER = 'HS' AND TO_DT <= %CurrentDateIn GROUP BY EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | TO_DT | Date(10) | DATE | To Date |