EMPLIDPAY_ENTITYBALANCE_GRP_NUMGPAU_TAX_YEARGPAU_PSM_TYPE10=PAYG Non-Business
20=PAYG Voluntary
30=PAYG Foreign
SEQNUMGPAU_PSM_VR_ADP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 3 | BALANCE_GRP_NUM |
Character(3) | VARCHAR2(3) NOT NULL | This field will be used to determine the grouping of balances from the different jobs of the employee. |
| 4 | GPAU_TAX_YEAR |
Number(4,0) | SMALLINT NOT NULL | Tax Year - End of Year Processing |
| 5 | GPAU_PSM_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Type of Payment Summary - Non-Business or Voluntary
10=PAYG Non-Business 20=PAYG Voluntary 30=PAYG Foreign |
| 6 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 7 | GPAU_PSM_NAME | Character(50) | VARCHAR2(50) NOT NULL | Allowance/Deduction Name |
| 8 | GPAU_PSM_AMOUNT | Number(8,0) | INTEGER NOT NULL | Allowance/Deduction Amount |