COUNTRYGP_PAYGROUPPrompt Table: GP_PYGRP
GP_CNT_PYGRP_VW(SQL View) |
Index Back |
|---|---|
View of GP Pay GroupView of GP Pay Group for ALL Countries |
| SELECT PE.COUNTRY , PG.GP_PAYGROUP ,PG.DESCR FROM PS_GP_PYGRP PG , PS_GP_PYENT PE WHERE PG.PAY_ENTITY=PE.PAY_ENTITY UNION SELECT 'ALL' , PG1.GP_PAYGROUP ,PG1.DESCR FROM PS_GP_PYGRP PG1 , PS_GP_PYENT PE1 WHERE PG1.PAY_ENTITY=PE1.PAY_ENTITY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |