GP_PAYGROUPCAL_IDGP_PAY_CAL_VW(SQL View) |
Index Back |
|---|---|
Pay CalendarsThis view is used to show Pay calendars, i.e. calendars with a Calc-Type of 'P'. |
| SELECT A.GP_PAYGROUP , A.CAL_ID FROM PS_GP_CALENDAR A , PS_GP_RUN_TYPE B WHERE A.RUN_TYPE = B.RUN_TYPE AND B.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 |