CAL_RUN_IDCOMPANYGPFR_RED_AR_VW(SQL View) |
Index Back |
|---|---|
Overtime Reduction VWOvertime Reduction VW |
| SELECT CAL_RUN_ID , COMPANY , COUNT(*) FROM PS_JOB A , PS_GP_CAL_RUN_DTL B WHERE A.HR_STATUS = 'A' AND B.COUNTRY = 'FRA' AND B.CALC_TYPE = 'P' AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_JOB X WHERE A.EMPLID = X.EMPLID AND A.EMPL_RCD = X.EMPL_RCD AND X.EFFDT <= %DateAdd((B.PRD_END_DT),1)) AND A.EFFSEQ = ( SELECT MAX(X.EFFSEQ) FROM PS_JOB X WHERE A.EMPLID = X.EMPLID AND A.EMPL_RCD = X.EMPL_RCD AND A.EFFDT = X.EFFDT) GROUP BY CAL_RUN_ID,COMPANY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | TOTAL_FTE | Number(8,2) | DECIMAL(7,2) NOT NULL | Total Budget FTE |