GP_PAYGROUPPrompt Table: %GP_EDIT_FLD2
LANGUAGE_CDGP_PYGRP_CAL_VL(SQL View) |
Index Back |
|---|---|
Related Language-Paygroup ViewRelated Language View for GP_PYGRP6_VW (which is used in GP_CAL_PYE_DTL.GP_PAYGROUP) |
| SELECT A.GP_PAYGROUP , B.LANGUAGE_CD , B.DESCR FROM PS_GP_PYGRP A , PS_GP_PYGRP_LANG B WHERE A.GP_PAYGROUP = B.GP_PAYGROUP AND EXISTS ( SELECT 'X' FROM PS_GP_CAL_RUN_DTL C WHERE C.GP_PAYGROUP = A.GP_PAYGROUP) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: %GP_EDIT_FLD2 |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |