EMPLIDPrompt Table: PERSON
TCD_SUPERVISR_IDTL_SUPERV_SRCH(SQL View) |
Index Back |
|---|---|
Time & Labor TCD Supervisors |
| SELECT DISTINCT A.EMPLID ,B.TCD_SUPERVISR_ID , A.NAME FROM PS_PERSON_NAME A , PS_TL_TCD_SUPERV B WHERE A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | TCD_SUPERVISR_ID |
Character(20) | VARCHAR2(20) NOT NULL | TCD Supervisor ID |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |