GP_PAYGROUPPrompt Table: GP_PYGRP
EFFDTDefault Value: %date
PIN_ERN_NUMPrompt Table: GP_PIN_ER0_VW
Prompt Table: GP_PIN_AC0_VW
Prompt Table: GP_PIN_FM0_VW
GPMX_NRP_SDI_VW(SQL View) |
Index Back |
|---|---|
Non rule packager Sdi VariableNon rule packager Sdi Variable |
| SELECT GP_PAYGROUP ,EFFDT ,PIN_ERN_NUM + 50000000 ,PIN_ACCUM_NUM + 50000000 ,PIN_FRML_NUM + 50000000 FROM PS_GPMX_VAR_SDI_PA |
| # | 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_PYGRP |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | PIN_ERN_NUM |
Number(8,0) | INTEGER NOT NULL |
Pin Number Earning
Prompt Table: GP_PIN_ER0_VW |
| 4 | PIN_ACCUM_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: GP_PIN_AC0_VW |
| 5 | PIN_FRML_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: GP_PIN_FM0_VW |