JOB_LABOR

(SQL View)
 Index Back

Labor Agreement View

This view selects all fields that used to be on JOB_LABOR (r7.5), but now are on JOB (r8). It is used to avoid recoding in reports, but not online.

SELECT EMPLID ,EMPL_RCD ,EFFDT ,EFFSEQ ,'A' ,PAY_UNION_FEE ,UNION_CD ,POSN_CHANGE_RECORD ,BARG_UNIT ,UNION_SENIORITY_DT ,VALUE_1_FRA ,VALUE_2_FRA ,VALUE_3_FRA ,VALUE_4_FRA ,VALUE_5_FRA ,CTG_RATE ,TARIFF_GER ,TARIFF_AREA_GER ,EMPL_CTG ,EMPL_CTG_L1 ,PERFORM_GROUP_GER ,LABOR_TYPE_GER ,SPK_COMM_ID_GER ,REG_REGION FROM PS_JOB WHERE UNION_CD <> ' '

# 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
19 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category
20 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory
21 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
22 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
23 SPK_COMM_ID_GER Character(9) VARCHAR2(9) NOT NULL Spokesmen Committee ID
24 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

Prompt Table: REG_STANDARD_VW