EMPLIDPrompt Table: PERS_SRCH_GBL
EMPL_RCDPrompt Table: EMPLOYMENT
SETIDSCHEDULE_IDDURDefault Value: %date
N=Work Shift
Y=Off Shift
ERE_SCHD_VW_ESP(SQL View) |
Index Back |
|---|---|
Permanent ERE employeesEmployee population for a permanent ERE |
| SELECT A.EMPLID , A.EMPL_RCD , B.SETID , B.SCHEDULE_ID , B.DUR , A.EFFDT , A.END_EFFDT , B.OFFDAY_IND FROM PS_SCH_ASSIGN A , PS_SCH_CLND_VW B WHERE A.SETID_SCHED = B.SETID AND A.SCH_ADHOC_IND_ALT = B.SCH_ADHOC_IND AND A.ALT_WRK_SCHED_ID = B.SCHEDULE_ID AND A.ROTATION_ID_ALT = B.ROTATION_ID AND B.DUR <= A.END_EFFDT AND B.DUR >= A.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: EMPLOYMENT |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | SCHEDULE_ID |
Character(16) | VARCHAR2(16) NOT NULL | The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition). |
| 5 | DUR |
Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 6 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 7 | END_EFFDT | Date(10) | DATE | End Effdt |
| 8 | OFFDAY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Off Day Indicator
N=Work Shift Y=Off Shift |