| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
PAY_UNION_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Union Fee
Y/N Table Edit
Default Value: N
|
| 7 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
Prompt Table:
UNION_TBL
|
| 8 |
POSN_CHANGE_RECORD |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Management Record
Y/N Table Edit
Default Value: N
|
| 9 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
|
| 10 |
UNION_SENIORITY_DT |
Date(10) |
DATE |
Union Seniority Date
|
| 11 |
VALUE_1_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 12 |
VALUE_2_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 13 |
VALUE_3_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HCR
|
| 14 |
VALUE_4_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 15 |
VALUE_5_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 16 |
CTG_RATE |
Number(3,0) |
SMALLINT NOT NULL |
Category Rate
|
| 17 |
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
|
| 18 |
TARIFF_AREA_GER |
Character(3) |
VARCHAR2(3) NOT NULL |
Tariff Area
Prompt Table:
TARIFF_AREA_GER
|
| 19 |
PERFORM_GROUP_GER |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is used for German employees to track the Performance Group associated to the Job Labor agreement.
A1=Blue Collar Performance Grp. 1
A2=Blue Collar Performance Grp. 2
A3=Blue Collar Performance Grp. 3
K1=Commercial White Collar Grp. 1
K2=Commercial White Collar Grp. 2
K3=Commercial White Collar Grp. 3
K4=Commercial White Collar Grp. 4
K5=Commerical White Collar Grp. 5
T1=Technical White Collar Grp. 1
T2=Technical White Collar Grp. 2
T3=Technical White Collar Grp. 3
T4=Technical White Collar Grp. 4
T5=Technical White Collar Grp. 5
|
| 20 |
LABOR_TYPE_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to track whether a Job is a management or non-management position.
M=Management
N=Non-Management
|
| 21 |
SPK_COMM_ID_GER |
Character(9) |
VARCHAR2(9) NOT NULL |
Spokesmen Committee ID
Prompt Table:
SPK_COMM_GER
|