SCHED_IDEMPLIDBAS_ENR_PAR_V1(SQL View) |
Index Back |
|---|---|
BAS Enr RunCtl-Sch Par EmplIDBAS_ENR_PAR_V1 is a view used by the Benefits Administration Run Control panel to return employee IDs for list assignment and option processing. |
| SELECT DISTINCT A.SCHED_ID ,A.EMPLID ,B.NAME FROM PS_BAS_PARTIC A ,PS_PERSON_NAME B WHERE B.EMPLID=A.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCHED_ID |
Character(6) | VARCHAR2(6) NOT NULL | Schedule ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |