| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 4 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 5 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 6 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 7 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 8 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 9 |
GP_RPT_KEY |
Character(22) |
VARCHAR2(22) NOT NULL |
Output Result Key
|
| 10 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 11 |
INSTANCE |
Number(3,0) |
SMALLINT NOT NULL |
Instance Number
|
| 12 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
|
| 13 |
GPTH_NAME1 |
Character(80) |
VARCHAR2(80) NOT NULL |
Tax-Payee's First Name
|
| 14 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 15 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
MIDDLE_NAME
|
| 16 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 17 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 18 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 19 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 20 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 21 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 22 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 23 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 24 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 25 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 26 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 27 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 28 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 29 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone number extension
|
| 30 |
HOME_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Home Phone #
|
| 31 |
GPTH_HOME_EXT |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone number extension
|
| 32 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 33 |
GPTH_PER_TAX_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Person Tax ID
|
| 34 |
GPTH_SPO_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Marriy Status
DIE=Died during tax year
DIV=Divorce during tax year
MAR=Married during tax year
NA=Not available
WHO=Married for the whole tax year
|
| 35 |
GPTH_TX_SPO_IND |
Number(1,0) |
SMALLINT NOT NULL |
Claim spouse allowance
Default Value: 0
|
| 36 |
GPTH_TX_PAFA |
Character(1) |
VARCHAR2(1) NOT NULL |
Declare for Payee's Father
Y/N Table Edit
Default Value: N
|
| 37 |
GPTH_TX_PAMOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Declare for Payee's Mother
Y/N Table Edit
Default Value: N
|
| 38 |
GPTH_TX_SPO_FA |
Character(1) |
VARCHAR2(1) NOT NULL |
Declare for Spouse's Father
Y/N Table Edit
Default Value: N
|
| 39 |
GPTH_TX_SPO_MOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Declare for Spouse's Mother
Y/N Table Edit
Default Value: N
|
| 40 |
GPTH_TX_HI_PAFA |
Character(1) |
VARCHAR2(1) NOT NULL |
Declare HI for Payee's Father
|
| 41 |
GPTH_TX_HI_PAMO |
Character(1) |
VARCHAR2(1) NOT NULL |
Declare HI for Payee's Mother
|
| 42 |
GPTH_TX_HI_SPOFA |
Character(1) |
VARCHAR2(1) NOT NULL |
Declare HI for Spouse's Father
|
| 43 |
GPTH_TX_HI_SPOMO |
Character(1) |
VARCHAR2(1) NOT NULL |
Declare HI for Spouse's Mother
|
| 44 |
GPTH_FHOUSE_PRICE |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
First House, house price
|
| 45 |
GPTH_FA_ID |
Character(13) |
VARCHAR2(13) NOT NULL |
Father ID No
|
| 46 |
GPTH_M_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Mother's National ID
|
| 47 |
GPTH_FI_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID of Father in law
|
| 48 |
GPTH_MI_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID Mother in law
|
| 49 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
|
| 50 |
GPTH_SPIN |
Character(13) |
VARCHAR2(13) NOT NULL |
National ID of Spouse
|
| 51 |
GPTH_STIN |
Character(13) |
VARCHAR2(13) NOT NULL |
Tax ID No of Spouse
|
| 52 |
GPTH_SP_BIRTHDATE |
Date(10) |
DATE |
Spouse's Birthdate
|
| 53 |
GPTH_SPREFIX |
Character(10) |
VARCHAR2(10) NOT NULL |
Spouse Name Prefix
|
| 54 |
GPTH_NAME2 |
Character(80) |
VARCHAR2(80) NOT NULL |
Tax-Payee's First Name
|
| 55 |
GPTH_SPO_FIRSTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Spouse's First Name
|
| 56 |
GPTH_SPO_LASTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Spouse's Last Name
|
| 57 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
|
| 58 |
PRD_BGN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 59 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 60 |
SEG_BGN_DT |
Date(10) |
DATE |
Payee Process Segment's Begin Date
|
| 61 |
SEG_END_DT |
Date(10) |
DATE |
Payee Process Segment's End Date
|
| 62 |
PYMT_DT |
Date(10) |
DATE |
Payment Date
|
| 63 |
CAL_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
|
| 64 |
PIN_GROSS_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Gross Pay Value
|
| 65 |
PIN_NET_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Net Pay Value
|
| 66 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 67 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 68 |
RUN_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Run Type Name
|
| 69 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 70 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 71 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 72 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 73 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 74 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 75 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
|
| 76 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 77 |
GPTH_GOV |
Character(1) |
VARCHAR2(1) NOT NULL |
This field represents that if the report is an Government report
|
| 78 |
GPTH_SEQ_NUM |
Character(6) |
VARCHAR2(6) NOT NULL |
Sequence number for tax report
|
| 79 |
GPTH_TAX_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax identification number
|
| 80 |
GPTH_TAX_BRANCH |
Character(6) |
VARCHAR2(6) NOT NULL |
Tax branch number
|
| 81 |
GPTH_TAX_ID_L |
Character(13) |
VARCHAR2(13) NOT NULL |
Tax identification number 13
|
| 82 |
ACM_FROM_DT |
Date(10) |
DATE |
From Date
|
| 83 |
ACM_THRU_DT |
Date(10) |
DATE |
Through Date
|
| 84 |
SLICE_BGN_DT |
Date(10) |
DATE |
Element Slice Begin Date
|
| 85 |
SLICE_END_DT |
Date(10) |
DATE |
Element Slice End Date
|
| 86 |
CALC_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 87 |
BASE_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculated Base Value
|
| 88 |
RATE_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Rate Result Value
|
| 89 |
UNIT_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Number of units used in result calculation
|
| 90 |
PCT_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Percent Result Value
|
| 91 |
RSLT_ADD_ARR |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount Added To Arrears
|
| 92 |
RSLT_NOT_TKN |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount Not Taken
|
| 93 |
RSLT_PAYBK |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Payback Amount Result
|
| 94 |
RSLT_XFER_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Bank Transfer Value of Deduct
|
| 95 |
BASE_ADJ_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Base Adjustment
|
| 96 |
CALC_ADJ_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Adjustment Value
|
| 97 |
UNIT_ADJ_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Unit Adjustment
|
| 98 |
USER_ADJ_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
User Adjustment Value
|
| 99 |
USER_KEY1 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Key 1
|
| 100 |
USER_KEY2 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Key 2
|
| 101 |
PIN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Element Type
|
| 102 |
PIN_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
Element Name field
|
| 103 |
PIN_CODE |
Character(22) |
VARCHAR2(22) NOT NULL |
Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across.
Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
|
| 104 |
PIN_CUSTOM1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Customer FIelds
|
| 105 |
GPTH_TX_PP |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee's party donation
|
| 106 |
GPTH_TX_PP_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Payee's party donation - Party ID
|
| 107 |
GPTH_TX_SPP |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee's spouse party donation
|
| 108 |
GPTH_TX_SPP_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Payee's spouse party donation - Party ID
|
| 109 |
DT_OF_DEATH |
Date(10) |
DATE |
Date of Death
|
| 110 |
GPTH_PF_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Provident Fund Type for GP Thailand
CPF=Company Provident Fund
GPF=Goverment Provident Fund
NSF=National Savings Fund
PSF=Private School Teacher PF
|
| 111 |
GPTH_CHILD1_ID |
Character(13) |
VARCHAR2(13) NOT NULL |
Child ID No
|
| 112 |
GPTH_CHILD2_ID |
Character(13) |
VARCHAR2(13) NOT NULL |
Child ID No
|
| 113 |
GPTH_CHILD3_ID |
Character(13) |
VARCHAR2(13) NOT NULL |
Child ID No
|
| 114 |
GPTH_STUDENT1_ID |
Character(13) |
VARCHAR2(13) NOT NULL |
Student ID No
|
| 115 |
GPTH_STUDENT2_ID |
Character(13) |
VARCHAR2(13) NOT NULL |
Student ID No
|
| 116 |
GPTH_STUDENT3_ID |
Character(13) |
VARCHAR2(13) NOT NULL |
Student ID No
|