SCHED_IDEMPLIDBAS_PRNT_PAR_V1(SQL View) |
Index Back |
|---|---|
BAS Prnt Partic-Sch Par EmplidBAS_PRNT_PAR_V1 is a view used by the Benefits Administration Statement Print panel to return employee IDs for the print list. The print list will be used in printing Enrollment or Confirmation statements. |
| SELECT DISTINCT A.SCHED_ID ,A.EMPLID ,B.NAME FROM PS_BAS_PARTIC A ,PS_PERSON_NAME B WHERE B.EMPLID=A.EMPLID AND A.BAS_PROCESS_STATUS IN ('PR','NT','EE','RE','ET','FE') |
| # | 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 |