INSTITUTIONAID_YEAREMPLIDFA_STDNT_SRCH(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.INSTITUTION , B.AID_YEAR , A.EMPLID , A.NAME , B.ISIR_TXN_NBR FROM PS_SCC_PRI_NAME_VW A , PS_ISIR_CONTROL B WHERE B.EMPLID = A.EMPLID AND B.ISIR_TXN_NBR = ( SELECT MAX(D.ISIR_TXN_NBR) FROM PS_ISIR_CONTROL D WHERE B.INSTITUTION = D.INSTITUTION AND B.AID_YEAR = D.AID_YEAR AND B.EMPLID = D.EMPLID) AND A.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PS_SCC_PRI_NAME_VW X1 WHERE X1.EMPLID = A.EMPLID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | ISIR_TXN_NBR | Number(2,0) | SMALLINT NOT NULL | Transaction Num |