GPGB_TXUP_AET(SQL Table) |
Index Back |
|---|---|
State Record for Code NumberState record for Code Number Changes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 3 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | LANGUAGE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Language Option
O=Specified Language R=Recipient's Language Default Value: O |
| 6 | GPGB_TAXUPL_SEL | Character(3) | VARCHAR2(3) NOT NULL |
Selection for Tax Uplift or Wk1Mnt1
TUP=Tax Uplift WM=Week 1/Month 1 Default Value: TUP |
| 7 | GPGB_TXUP_TAX_SRC | Character(4) | VARCHAR2(4) NOT NULL |
Tax Uplift process
P7X=P7X P9X=P9X |
| 8 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |
| 9 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GP_CAL_OPR_VW |
| 10 | GPGB_CODE_LETTER | Character(1) | VARCHAR2(1) NOT NULL | GP GBR - Tax Code Letter |
| 11 | GPGB_TAX_AMOUNT | Signed Number(5,0) | DECIMAL(4) NOT NULL | GP GBR - Tax Amount |
| 12 | GPGB_UPLIFT_DATE | Date(10) | DATE | GP GBR - Tax Uplift Date |
| 13 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 14 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 15 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 16 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 17 | GPGB_TAX_CD_SRC | Character(4) | VARCHAR2(4) NOT NULL |
How Employee was notified of Tax Code eg P45, P46 or P38s
OTH=OTH P38S=P38S P45=P45 P46=P46 P6=P6 P6B=P6B P6T=P6T P7X=P7X P9=P9 P9T=P9T P9X=P9X |
| 18 | TAXCODE_UK | Character(15) | VARCHAR2(15) NOT NULL | Tax Code |
| 19 | TAX_BASIS_UK | Character(1) | VARCHAR2(1) NOT NULL |
Tax Basis
0=Cumulative 1=Week 1/Month 1 |
| 20 | GPGB_SV_TAX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Scottish Variable Tax Indicator - Y/N. If this is set to Y then the Tax Code entered should be prefixed with an 'S'
Y/N Table Edit |
| 21 | GPGB_TAX_CD_ALPHA | Character(2) | VARCHAR2(2) NOT NULL | Alpha part of Tax Code - this field will be hiiden from view and is used in the calculation of Tax. It has been included in the table as the Formulae functionality of GP cannot currently support the Substring and Numeric Conversion type functions that would be required. |
| 22 | GPGB_TAX_CD_NUM | Number(6,0) | INTEGER NOT NULL | Numeric part of Tax Code - this field will be hidden from view and is used in the calculation of Tax. It has been included in the table as the Formulae functionality of GP cannot currently support the Substring and Numeric Conversion type functions that would be required. |
| 23 | GPGB_TAX_CD_ISSUE | Date(10) | DATE | Tax Code Issue Date |
| 24 | GPGB_P45_CAL_RUN | Character(18) | VARCHAR2(18) NOT NULL | P45 Calendar Group Id |
| 25 | GPGB_EDI_REF | Number(14,0) | DECIMAL(14) NOT NULL | GPUK EDI stores EDI transaction number |
| 26 | LEAVE_DT | Date(10) | DATE | Leave Date |
| 27 | GPGB_MSGTEXT | Character(100) | VARCHAR2(100) NOT NULL | Inland Revenue Message Log |