| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 3 |
GPGB_TAX_BGN_YR |
Number(4,0) |
SMALLINT NOT NULL |
Tax Year Begins In This Calendar Year
|
| 4 |
GPGB_ER_TAXNUM |
Number(3,0) |
SMALLINT NOT NULL |
Employer's Tax Number
|
| 5 |
GPGB_ER_PAYE_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Employer's PAE reference number
|
| 6 |
GPGB_ACCT_OFF_NBR |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Accounts Office Number
|
| 7 |
GPGB_COTAXREF |
Number(10,0) |
DECIMAL(10) NOT NULL |
Corporation Tax Reference
|
| 8 |
GPGB_RTIX_SNDRID |
Character(100) |
VARCHAR2(100) NOT NULL |
RTI XML Sender ID
|
| 9 |
GPGB_RTIX_AUTHMTH |
Character(4) |
VARCHAR2(4) NOT NULL |
Authentication Method
CLEA=Clear
MD5=MD5
|
| 10 |
GPGB_RTIX_ROLE |
Character(50) |
VARCHAR2(50) NOT NULL |
RTI XML Header- Role
|
| 11 |
GPGB_RTIX_PSWD |
Character(254) |
VARCHAR2(254) NOT NULL |
RTI XML Header Password
|
| 12 |
GPGB_RTIX_EMAIL |
Character(129) |
VARCHAR2(129) NOT NULL |
RTI XML Header- Email
|
| 13 |
GPGB_RTIX_SNDR_FLD |
Character(4) |
VARCHAR2(4) NOT NULL |
RTI XML Header Sender Field
ACTG=Acting in Capacity
AGEN=Agent
BURE=Bureau
COMP=Company
EMPR=Employer
GOVR=Government
IND=Individual
OTHR=Other
PART=Partnership
TRUS=Trust
|
| 14 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 15 |
GPGB_EDI_TRANS |
Character(4) |
VARCHAR2(4) NOT NULL |
EDI Transaction Types
EDI=EDI Extraction
EXPT=P46 Expat Starter Notification
P14=P14
P35=P35
P451=P45 Leaver Notification
P453=P45 Starter Notification
P46=P46 Starters
P6=P6
P6B=P6B
P9=P9
PEN=P46 Pension Starter
PGL1=PGL1 Start Notice
PGL2=PGL2 Stop Notice
SL1=SL1 Start Notice
SL2=SL2 Stop Notice
WNU=Works Number Update
|
| 16 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 17 |
NAME_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Name Title
|
| 18 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 19 |
NAME1_AC |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1 Alternate Char Set
|
| 20 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 21 |
E_ADDR_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Email Type
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
|
| 22 |
PREF_EMAIL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred
N=No
Y=Yes
|
| 23 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 24 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone number extension
|
| 25 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 26 |
PREF_PHONE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred
N=No
Y=Yes
|
| 27 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 28 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 29 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 30 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 31 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 32 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 33 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 34 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 35 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 36 |
NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 2
|
| 37 |
NAME3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 3
|
| 38 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 39 |
PHONE1 |
Character(24) |
VARCHAR2(24) NOT NULL |
Phone number field for discounts and perks eligibility file.
|
| 40 |
GPGB_PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
GPGB RTI XML- Phone Type
|
| 41 |
GPGB_EDI_SENDER_ID |
Character(35) |
VARCHAR2(35) NOT NULL |
GP UK EDI Sender ID.
|
| 42 |
GPGB_EDI_VENDOR_ID |
Number(4,0) |
SMALLINT NOT NULL |
EDI - Vendor Id.
|
| 43 |
GPGB_REL_TAX_YEAR |
Character(5) |
VARCHAR2(5) NOT NULL |
GPGB RTIXML Related Tax Year
|
| 44 |
DESCR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr
|
| 45 |
DESCR2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr2
|
| 46 |
DESCR3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr 3
|
| 47 |
DESCR4 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr 4
|
| 48 |
DESCR5 |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used in a complex query that shows many descr fields.
|
| 49 |
DESCR6 |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used in a complex query that shows many descr fields.
|
| 50 |
DESCR7 |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used in a complex query that shows many descr fields.
|
| 51 |
DESCR8 |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used in a complex query that shows many descr fields.
|
| 52 |
EMAIL_ADDR2 |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 53 |
GPGB_ER_ECON |
Character(9) |
VARCHAR2(9) NOT NULL |
Employers Contracted Out Number
|