EMPLIDPrompt Table: PEOPLE_SRCH
LN_NAME_VW(SQL View) |
Index Back |
|---|---|
Loan Name ViewUsed by the loan application process to select the students name |
| SELECT A.EMPLID , A.FIRST_NAME , A.MIDDLE_NAME , A.LAST_NAME FROM PS_SCC_EQNM_USG_VW A , PS_FA_PRCSDEMO_TBL B WHERE B.FA_PROCESS_NAME = 'L' AND B.NAME_USAGE = A.NAME_USAGE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 3 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |