GPSC_CI_DFL_AET(SQL Table) |
Index Back |
|---|---|
GP Install CE DefaultGP Install CE Default |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | INSTALLED_GP_ARG | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Argentina.
(Reserved field for possible future country extension development).
Y/N Table Edit |
| 3 | INSTALLED_GP_AUS | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Australia
Y/N Table Edit |
| 4 | INSTALLED_GP_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Brazil
Y/N Table Edit |
| 5 | INSTALLED_GP_CHE | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Switzerland
Y/N Table Edit |
| 6 | INSTALLED_GP_CHN | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll China
Y/N Table Edit |
| 7 | INSTALLED_GP_DEU | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Germany
Y/N Table Edit |
| 8 | INSTALLED_GP_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Spain
Y/N Table Edit |
| 9 | INSTALLED_GP_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll France
Y/N Table Edit |
| 10 | INSTALLED_GP_HKG | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Hong Kong
Y/N Table Edit |
| 11 | INSTALLED_GP_IND | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll India
Y/N Table Edit |
| 12 | INSTALLED_GP_ITA | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Italy
Y/N Table Edit |
| 13 | INSTALLED_GP_JPN | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Japan
Y/N Table Edit |
| 14 | INSTALLED_GP_MEX | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Mexico
Y/N Table Edit |
| 15 | INSTALLED_GP_MYS | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Malaysia
Y/N Table Edit |
| 16 | INSTALLED_GP_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Netherlands
Y/N Table Edit |
| 17 | INSTALLED_GP_NZL | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll New Zealand
Y/N Table Edit |
| 18 | INSTALLED_GP_SGP | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Singapore
Y/N Table Edit |
| 19 | INSTALLED_GP_THA | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Thailand
Y/N Table Edit |
| 20 | INSTALLED_GP_UK | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll United Kingdom
Y/N Table Edit |
| 21 | INSTALLED_GP_USA | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll United States
Y/N Table Edit |
| 22 | GPSC_CI_CEPSHOME | Character(100) | VARCHAR2(100) NOT NULL | Install GPCE PSHOME |
| 23 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |