EMPLIDEMPL_RCDGP_PAYGROUPCAL_IDTRN_COL_CAL_VW(SQL View) |
Index Back |
|---|---|
Training Calendar ViewThis View is used to retrieve the corresponding calendar for each Session Cuts. |
| SELECT D.EMPLID , D.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , E.CAL_PRD_ID , E.DESCR , E.PRD_BGN_DT , E.PRD_END_DT ,G.RUN_FINALIZED_IND FROM PS_GP_CALENDAR A , PS_GP_RUN_TYPE B , PS_JOB D , PS_GP_CAL_PRD E ,PS_GP_CAL_RUN_DTL F , PS_GP_CAL_RUN G WHERE A.RUN_TYPE = B.RUN_TYPE AND B.CALC_TYPE ='P' AND A.CAL_PRD_ID = E.CAL_PRD_ID AND A.CAL_PRD_ID=E.CAL_PRD_ID AND A.GP_PAYGROUP = D.GP_PAYGROUP AND D.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_JOB E WHERE E.EMPLID = D.EMPLID AND E.EMPL_RCD = D.EMPL_RCD AND E.EFFDT <= %CurrentDateIn) AND D.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB WHERE EMPLID = D.EMPLID AND EMPL_RCD = D.EMPL_RCD AND EFFDT = D.EFFDT) AND A.CAL_ID=F.CAL_ID AND F.CAL_RUN_ID=G.CAL_RUN_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 4 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 5 | CAL_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 8 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 9 | RUN_FINALIZED_IND | Character(1) | VARCHAR2(1) NOT NULL | Finalized Run |