RS_WRKR_SRCH(SQL Table) |
Index Back |
|---|---|
Standard Worker SearchThis is a work record used on the Standard Worker 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 | POOL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Pool ID field.
Prompt Table: RS_POOL_ACTIVE |
| 7 | CANCEL_BUTTON | Character(1) | VARCHAR2(1) NOT NULL | Cancel Button |
| 8 | CANCEL_PB | Character(1) | VARCHAR2(1) NOT NULL | Cancel Pushbutton |
| 9 | OK_BUTTON | Character(1) | VARCHAR2(1) NOT NULL | OK... |
| 10 | SEARCH_BY_ASSET | Character(1) | VARCHAR2(1) NOT NULL | Search by Asset |
| 11 | MEMBER_ID | Number(6,0) | INTEGER NOT NULL | Member ID. |