DL_PERS_DATA_VW(SQL View) |
Index Back |
|---|---|
Direct Loan Personal Data ViewThis vie is used in Query FA853 - FA865 to grab Borrower Name and EMPLID. |
| SELECT A.EMPLID , A.NAME FROM PS_SCC_PRI_NAME_VW A WHERE 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |