GPTH_SSO103_TMP(SQL Table) |
Index Back |
|---|---|
Report SSO103 Temp TableReport SSO103 Temp Table |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | GPTH_EMPL_TYPE |
Character(1) | VARCHAR2(1) NOT NULL | GP Thailand Employee Type. Daily or Monthly |
| 6 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 7 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL | Name Prefix |
| 8 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 9 | GPTH_NAME_PRE_CODE | Character(3) | VARCHAR2(3) NOT NULL | GP Thailand - Name Prefix Code Mr ---- 003 Miss --- 004 Mrs --- 005 |
| 10 | GPTH_NAME_PRE_DIS | Character(4) | VARCHAR2(4) NOT NULL | Name prefix description for GP Thailand. |
| 11 | GPTH_NAME1 | Character(80) | VARCHAR2(80) NOT NULL | Tax-Payee's First Name |
| 12 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 13 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 14 | 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 |
| 15 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 16 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 17 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 18 | GPTH_SI_ER_ACCT | Character(10) | VARCHAR2(10) NOT NULL | GPTH_SI_ER_ACCT |
| 19 | GPTH_SI_BRANCH_NO | Character(6) | VARCHAR2(6) NOT NULL | Social Security Branch Number |
| 20 | GPTH_SI_BRANCH_NO2 | Character(6) | VARCHAR2(6) NOT NULL | Social Security Branch Number |
| 21 | GPTH_SI_BRANCH_AP | Character(40) | VARCHAR2(40) NOT NULL | This field will be used to store social security area/province information. |
| 22 | GPTH_SI_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
No work before/No SS Number flag
Y/N Table Edit Default Value: N |
| 23 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 24 | HIRE_DT | Date(10) | DATE | First Start Date |
| 25 | GPTH_TX_CHD_ALO_NO | Number(3,0) | SMALLINT NOT NULL | Number of child for Allowance |
| 26 | DATE1 | Date(10) | DATE | Date 1 |
| 27 | DATE2 | Date(10) | DATE | Date 2 |
| 28 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 29 | GPTH_NATIONAL_CD | Character(3) | VARCHAR2(3) NOT NULL | GP Thailand Nationality Code |
| 30 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 31 | NATIONAL_ID_TYPE | Character(6) | VARCHAR2(6) NOT NULL | National ID Type |
| 32 | ALIEN_REG | Character(1) | VARCHAR2(1) NOT NULL | Alien Registration |
| 33 | PASSPORT_NBR | Character(15) | VARCHAR2(15) NOT NULL | Passport Number |
| 34 | VISA_WRKPMT_NBR | Character(15) | VARCHAR2(15) NOT NULL | Visa/Permit Number |
| 35 | GPTH_HOSPITAL1 | Character(7) | VARCHAR2(7) NOT NULL | Thailand Hospital for SSO |
| 36 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Descr 3 |
| 37 | GPTH_HOSPITAL2 | Character(7) | VARCHAR2(7) NOT NULL | Thailand Hospital for SSO |
| 38 | DESCR4 | Character(30) | VARCHAR2(30) NOT NULL | Descr 4 |
| 39 | GPTH_HOSPITAL3 | Character(7) | VARCHAR2(7) NOT NULL | Thailand Hospital for SSO |
| 40 | DESCR5 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |