GP_PAYGROUPPrompt Table: GP_PYGRP
PAY_ENTITYPrompt Table: GP_PYGRP
EFFDTDefault Value: GP_PYGRP_DTL.EFFDT
A=Active
I=Inactive
Default Value: GP_PYGRP_DTL.EFF_STATUS
1=No Participation
2=Normal
3=Immediate Notification
GPCH_AL_PYGRP(SQL Table) |
Index Back |
|---|---|
Pay Groups by EE CategoryPay Groups by EE Category |
| # | 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 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYGRP |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: GP_PYGRP_DTL.EFFDT |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: GP_PYGRP_DTL.EFF_STATUS |
| 5 | GPCH_DV_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
DEUEV Participation Type
1=No Participation 2=Normal 3=Immediate Notification |