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