CAL_RUN_IDCAL_IDCOMPANYGPFR_FNAL_AR_VW(SQL View) |
Index Back |
|---|
| SELECT CAL_RUN_ID , CAL_ID , COMPANY , COUNT(*) FROM PS_JOB A , PS_GP_CAL_RUN_DTL B WHERE A.HR_STATUS = 'A' AND A.GP_PAYGROUP = B.GP_PAYGROUP AND B.COUNTRY = 'FRA' 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(%datein(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, CAL_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 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 3 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 4 | TOTAL_FTE | Number(8,2) | DECIMAL(7,2) NOT NULL | Total Budget FTE |