GPTH_DIS_RPT

(SQL Table)
Index Back

Disabled/incap allowance

Disabled/incap allowance report

# 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 GPTH_TAX_ID_L Character(13) VARCHAR2(13) NOT NULL Tax identification number 13
4 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
5 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
7 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
8 GPTH_TX_INCAP Character(1) VARCHAR2(1) NOT NULL Incapacitated

Y/N Table Edit

9 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
10 ROW_NUM Number(3,0) SMALLINT NOT NULL Row Number
11 GPTH_YEAR Number(4,0) SMALLINT NOT NULL Year for Thailand
12 DATE_DUE Date(10) DATE Date Due
13 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
14 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
15 GPTH_NAME1 Character(80) VARCHAR2(80) NOT NULL Tax-Payee's First Name