PC_SRCHEMP_WRK(SQL Table) |
Index Back |
|---|---|
Employee Search and SelectThis is a work record used on the Standard Employee Search page. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | PERSON_NAME | Character(100) | VARCHAR2(100) NOT NULL | Name |
| 3 | SEARCH_BY | Character(1) | VARCHAR2(1) NOT NULL |
Search by
E=Employee ID F=First Name L=Last Name Default Value: L |
| 4 | SEARCH_EMPL | Character(30) | VARCHAR2(30) NOT NULL | Find this employee |
| 5 | SEARCH_BUTTON | Character(1) | VARCHAR2(1) NOT NULL | Search |
| 6 | CANCEL_BUTTON | Character(1) | VARCHAR2(1) NOT NULL | Cancel Button |
| 7 | CANCEL_PB | Character(1) | VARCHAR2(1) NOT NULL | Cancel Pushbutton |
| 8 | OK_BUTTON | Character(1) | VARCHAR2(1) NOT NULL | OK... |