| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TARIFF_GER |
Character(2) |
VARCHAR2(2) NOT NULL |
Tariff
01=Metal Processing
02=Banking
03=Building and Civil Engineering
04=Clothing Industry
05=Chemical Industry
06=Printing Industry
07=Retail Trade
08=Fossil Oil and Gas Extraction
09=Glass Industry
10=Wholesale and Foreign Trade
11=Wood Processing
12=Rubber Processing
13=Ceramics
14=Agriculture
15=Leather Processing
16=Public Sector
17=Paper Industry
18=Paper Processing
19=Sawing Industry
20=German Seaports
21=Hard-Coal Mining
22=Textile Industry
23=Insurance
24=Housing Industry
25=Periodical Publishers
26=Newspaper Publishers
27=Tobacco Industry
|
| 2 |
TARIFF_AREA_GER |
Character(3) |
VARCHAR2(3) NOT NULL |
Tariff Area
Prompt Table:
GPDE_ER_TRFAREA
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
GPDE_ER_DD_PER_MM |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Days per Month
|
| 6 |
GPDE_ER_BASE_MMSTD |
Number(2,0) |
SMALLINT NOT NULL |
Regular Monthly Pay
|
| 7 |
GPDE_ER_DD_PER_WK |
Number(1,0) |
SMALLINT NOT NULL |
Work Days per Week
|
| 8 |
GPDE_ER_WK_PER_MM |
Number(5,3) |
DECIMAL(4,3) NOT NULL |
Weeks per Month
|
| 9 |
GPDE_ER_BASE_MMVAR |
Number(2,0) |
SMALLINT NOT NULL |
Variable Monthly Pay
|
| 10 |
GPDE_ER_FORMEREAST |
Character(1) |
VARCHAR2(1) NOT NULL |
New States
Y/N Table Edit
Default Value: N
|
| 11 |
GPDE_ER_STD_MM_HRS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Standard Monthly Hours
|
| 12 |
GPDE_ER_HRS_DD |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Hours per Day
|
| 13 |
GPDE_ER_HRS_WK |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Hours per Week
|
| 14 |
GPDE_ER_HRS_YEAR |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Hours per Year
|
| 15 |
GPDE_ER_DAYS_YEAR |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Days per Year
|