EMPLIDSTDNT_FA_COM_VW(SQL View) |
Index Back |
|---|---|
Student Aid/Communication ViewSTDNT_FA_COM_VW selects stduents from the COMMUNICATION table with Admin_Function of 'FINA' for use in Award Notification. |
| SELECT DISTINCT A.EMPLID , C.NAME FROM PS_STUDENT_AID A , PS_COMMUNICATION B , PS_SCC_PRI_NAME_VW C , PS_VAR_DATA_FINA D WHERE A.EMPLID = B.COMMON_ID AND A.INSTITUTION=B.INSTITUTION AND B.ADMIN_FUNCTION = 'FINA' AND B.COMPLETED_DT IS NULL AND B.COMPLETED_COMM <> 'Y' AND C.EMPLID = A.EMPLID AND B.COMMON_ID = D.COMMON_ID AND B.VAR_DATA_SEQ = D.VAR_DATA_SEQ AND D.AID_YEAR = A.AID_YEAR AND C.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PS_SCC_PRI_NAME_VW X1 WHERE X1.EMPLID = C.EMPLID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |