GP_PAYGROUPRUN_TYPEGPBR_GP_RTY_VW(SQL View) |
Index Back |
|---|---|
Pay Group vs Run TypePay Group vs Run Type |
| SELECT DISTINCT A.GP_PAYGROUP , B.RUN_TYPE FROM PS_GP_CAL_RUN_DTL A , PS_GP_CALENDAR B , PS_GP_RUN_TYPE C WHERE B.GP_PAYGROUP = A.GP_PAYGROUP AND B.CAL_ID = A.CAL_ID AND C.RUN_TYPE = B.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 | RUN_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |