CAL_RUN_IDCAL_SEQ_NUMTL_ABS_CALDTL_V(SQL View) |
Index Back |
|---|---|
Calendar Group DetailsThis view brings both on-cycle and off-cycle calendar details |
| SELECT CGRP.CAL_RUN_ID , DTL.CAL_SEQ_NUM , CAL.CAL_ID , CAL.GP_PAYGROUP , ENT.PAY_ENTITY , CAL.CAL_PRD_ID , PRD.PRD_BGN_DT , PRD.PRD_END_DT , CGRP.OFF_CYCLE , ' ' , CGRP.RUN_OPEN_IND , CGRP.PRC_NUM FROM PS_GP_CAL_RUN CGRP , PS_GP_CAL_RUN_DTL DTL , PS_GP_CALENDAR CAL , PS_GP_CAL_PRD PRD , PS_GP_PYGRP PGP , PS_GP_PYENT ENT WHERE CGRP.CAL_RUN_ID = DTL.CAL_RUN_ID AND PRD.CAL_PRD_ID = CAL.CAL_PRD_ID AND CAL.CAL_ID = DTL.CAL_ID AND CAL.GP_PAYGROUP = DTL.GP_PAYGROUP AND CGRP.USE_AS_TMPLT_IND = 'N' AND PGP.GP_PAYGROUP = CAL.GP_PAYGROUP AND PGP.PAY_ENTITY = ENT.PAY_ENTITY UNION SELECT CGRP.CAL_RUN_ID , OFF1.CAL_SEQ_NUM , OFF1.OFF_CYCLE_ID , OFF1.GP_PAYGROUP , ENT.PAY_ENTITY , PRD.CAL_PRD_ID , PRD.PRD_BGN_DT , PRD.PRD_END_DT , CGRP.OFF_CYCLE , OFF1.OFF_CYCLE_ID , CGRP.RUN_OPEN_IND , CGRP.PRC_NUM FROM PS_GP_CAL_RUN CGRP , PS_GP_CAL_RUN_OFF OFF1 , PS_GP_CAL_PRD PRD , PS_GP_PYGRP PGP , PS_GP_PYENT ENT WHERE CGRP.CAL_RUN_ID = OFF1.CAL_RUN_ID AND PRD.CAL_PRD_ID = OFF1.CAL_PRD_ID AND PGP.GP_PAYGROUP = OFF1.GP_PAYGROUP AND CGRP.USE_AS_TMPLT_IND = 'N' AND CGRP.OFF_CYCLE = 'Y' AND PGP.PAY_ENTITY = ENT.PAY_ENTITY |
| # | 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_SEQ_NUM |
Number(8,0) | INTEGER NOT NULL | Calendar Sequence Number |
| 3 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 4 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 5 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 6 | CAL_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |
| 7 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 8 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 9 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 10 | OFF_CYCLE_ID | Character(18) | VARCHAR2(18) NOT NULL | Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments |
| 11 | RUN_OPEN_IND | Character(1) | VARCHAR2(1) NOT NULL | Y/N Indicates that processing has been initiated for given run (calendar group). |
| 12 | PRC_NUM | Number(5,0) | INTEGER NOT NULL | Process Number |