GP_PAYGROUPCAL_IDTRGT_CAL_IDGP_TRGTU_CAL_VW(SQL View) |
Index Back |
|---|---|
GP Target Calendar ID ViewView to provide list of values for Target Calendar ID |
| SELECT A.GP_PAYGROUP , A.CAL_ID , B.CAL_ID FROM PS_GP_CALENDAR A , PS_GP_CALENDAR B , PS_GP_RUN_TYPE C WHERE A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID <> B.CAL_ID AND B.RUN_TYPE = C.RUN_TYPE AND C.CALC_TYPE = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 2 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 3 | TRGT_CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar to which retro deltas are targeted or forwarded |