| # |
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 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 4 |
GPTH_EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
GP Thailand Employee Type.
Daily or Monthly
|
| 5 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 6 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
|
| 7 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 8 |
GPTH_NAME_PRE_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
GP Thailand - Name Prefix Code
Mr ---- 003
Miss --- 004
Mrs --- 005
|
| 9 |
GPTH_NAME_PRE_DIS |
Character(4) |
VARCHAR2(4) NOT NULL |
Name prefix description for GP Thailand.
|
| 10 |
GPTH_NAME1 |
Character(80) |
VARCHAR2(80) NOT NULL |
Tax-Payee's First Name
|
| 11 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 12 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 13 |
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
|
| 14 |
DESCR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr
|
| 15 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 16 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 17 |
GPTH_SI_ER_ACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
GPTH_SI_ER_ACCT
|
| 18 |
GPTH_SI_BRANCH_NO |
Character(6) |
VARCHAR2(6) NOT NULL |
Social Security Branch Number
|
| 19 |
GPTH_SI_BRANCH_AP |
Character(40) |
VARCHAR2(40) NOT NULL |
This field will be used to store social security area/province information.
|
| 20 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
|
| 21 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 22 |
GPTH_TX_CHD_ALO_NO |
Number(3,0) |
SMALLINT NOT NULL |
Number of child for Allowance
|
| 23 |
DATE1 |
Date(10) |
DATE |
Date 1
|
| 24 |
DATE2 |
Date(10) |
DATE |
Date 2
|
| 25 |
GPTH_NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
GP Thailand - Name Prefix
|
| 26 |
GPTH_NAME2 |
Character(80) |
VARCHAR2(80) NOT NULL |
Tax-Payee's First Name
|
| 27 |
GPTH_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
GP Thailand - First Name
|
| 28 |
GPTH_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
GP Thailand - Last Name
|
| 29 |
GPTH_MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marry 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
|
| 30 |
GPTH_NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
GP Thailand - National ID
|
| 31 |
GPTH_NM_PREFIX_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Change flag
N=N
Y=Y
|
| 32 |
GPTH_FIRST_NM_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Change flag
N=N
Y=Y
|
| 33 |
GPTH_LAST_NM_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Change flag
N=N
Y=Y
|
| 34 |
GPTH_MAR_STAT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Change flag
N=N
Y=Y
|
| 35 |
GPTH_NID_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Change flag
N=N
Y=Y
|
| 36 |
NATIONAL_ID_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
National ID Type
|
| 37 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 38 |
GPTH_NATIONAL_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
GP Thailand Nationality Code
|