COMPANYPrompt Table: COMPANY_TBL
EFFDTDefault Value: %date
GPTH_PF_MNGRPrompt Table: GPTH_PF_MRNM_VW
GP_PAYGROUPPrompt Table: GP_PYGRP
GPTH_PF_MRGP(SQL Table) |
Index Back |
|---|---|
Company PF Manger PayGroupCompany PF Manger PayGroup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPTH_PF_MNGR |
Character(50) | VARCHAR2(50) NOT NULL |
Provident Fund Manager Name
Prompt Table: GPTH_PF_MRNM_VW |
| 4 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |