GPAU_GRP_ENTPrompt Table: GP_PYENT_OPR_VW
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Y/N Table Edit
Default Value: Y
GPAU_GRP_ENT(SQL Table) |
Index Back |
|---|---|
SPT Group Entity Parent recordState Payroll Tax Group Entity parent record for each Pay Entity in the group. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPAU_GRP_ENT |
Character(10) | VARCHAR2(10) NOT NULL |
State Payroll Tax Group Entity
Prompt Table: GP_PYENT_OPR_VW |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | GPAU_TOT_GRP_EARN | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | State Payroll Tax, total earnings for the Group |
| 6 | GPAU_APPTN_DED | Character(1) | VARCHAR2(1) NOT NULL |
State Payroll Tax Pay Entity Apportion Deduction field
Y/N Table Edit Default Value: Y |