HCR_JOB_FLD_VW

(SQL View)
Index Back

View of Job and Staging

Union of Job rows and Staging rows of job modernization

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ ,0 ,'PRO' , A.PER_ORG , A.DEPTID , A.JOBCODE , A.POSITION_NBR , A.POSITION_OVERRIDE , A.POSN_CHANGE_RECORD , A.EMPL_STATUS , A.ACTION , A.ACTION_DT , A.ACTION_REASON , A.LOCATION , A.TAX_LOCATION_CD , A.JOB_ENTRY_DT , A.DEPT_ENTRY_DT , A.POSITION_ENTRY_DT , A.SHIFT , A.REG_TEMP , A.FULL_PART_TIME , A.FLSA_STATUS , A.OFFICER_CD , A.COMPANY , A.PAYGROUP , A.BAS_GROUP_ID , A.ELIG_CONFIG1 , A.ELIG_CONFIG2 , A.ELIG_CONFIG3 , A.ELIG_CONFIG4 , A.ELIG_CONFIG5 , A.ELIG_CONFIG6 , A.ELIG_CONFIG7 , A.ELIG_CONFIG8 , A.ELIG_CONFIG9 , A.BEN_STATUS , A.BAS_ACTION , A.COBRA_ACTION , A.EMPL_TYPE , A.HOLIDAY_SCHEDULE , A.STD_HOURS , A.STD_HRS_FREQUENCY , A.EEO_CLASS , A.EMPL_CLASS , A.SAL_ADMIN_PLAN , A.GRADE , A.GRADE_ENTRY_DT , A.STEP , A.STEP_ENTRY_DT , A.GL_PAY_TYPE , A.ACCT_CD , A.EARNS_DIST_TYPE , A.COMP_FREQUENCY , A.COMPRATE , A.CHANGE_AMT , A.CHANGE_PCT , A.ANNUAL_RT , A.MONTHLY_RT , A.DAILY_RT , A.HOURLY_RT , A.ANNL_BENEF_BASE_RT , A.SHIFT_RT , A.SHIFT_FACTOR , A.CURRENCY_CD , A.BUSINESS_UNIT , A.SETID_DEPT , A.SETID_JOBCODE , A.SETID_LOCATION , A.SETID_SALARY , A.FUNCTION_CD , A.HOURLY_RT_FRA , A.ACCDNT_CD_FRA , A.ESTABID , A.REG_REGION , A.DIRECTLY_TIPPED , A.ADDS_TO_FTE_ACTUAL , A.CLASS_INDC , A.FICA_STATUS_EE , A.FTE , A.PRORATE_CNT_AMT , A.ENCUMB_OVERRIDE , A.UNION_FULL_PART , A.UNION_POS , A.PAY_UNION_FEE , A.UNION_CD , A.BARG_UNIT , A.UNION_SENIORITY_DT , A.VALUE_1_FRA , A.VALUE_2_FRA , A.VALUE_3_FRA , A.VALUE_4_FRA , A.VALUE_5_FRA , A.CTG_RATE , A.TARIFF_GER , A.TARIFF_AREA_GER , A.PERFORM_GROUP_GER , A.LABOR_TYPE_GER , A.SPK_COMM_ID_GER , A.ENTRY_DATE , A.LABOR_AGREEMENT , A.EMPL_CTG , A.EMPL_CTG_L1 , A.EMPL_CTG_L2 , A.SETID_LBR_AGRMNT , A.PAY_SYSTEM_FLG , A.BORDER_WALKER , A.LUMP_SUM_PAY , A.CONTRACT_NUM , A.JOB_INDICATOR , A.GP_PAYGROUP , A.GP_DFLT_ELIG_GRP , A.GP_ELIG_GRP , A.GP_DFLT_CURRTTYP , A.CUR_RT_TYPE , A.GP_DFLT_EXRTDT , A.GP_ASOF_DT_EXG_RT , A.BENEFIT_SYSTEM , A.WRKS_CNCL_ROLE_CHE , A.EXEMPT_HOURS_MONTH , A.EXEMPT_JOB_LBR , A.INTERCTR_WRKS_CNCL , A.CURRENCY_CD1 , A.MATRICULA_NBR , A.SOC_SEC_RISK_CODE , A.UNION_FEE_AMOUNT , A.UNION_FEE_END_DT , A.UNION_FEE_START_DT , A.WRKS_CNCL_FUNCTION , A.PAID_HOURS , A.PAID_FTE , A.PAID_HRS_FREQUENCY , A.WORK_DAY_HOURS , A.SUPERVISOR_ID , A.REPORTS_TO , A.FORCE_PUBLISH , A.JOB_DATA_SRC_CD ,'J' , A.APPT_TYPE , A.HR_STATUS , A.LASTUPDOPRID , %DatePart(A.LASTUPDDTTM) FROM PS_JOB A , PS_INSTALLATION WHERE NOT EXISTS ( SELECT 'X' FROM PS_HCR_JOB_STG C WHERE C.EMPLID=A.EMPLID AND C.EMPL_RCD=A.EMPL_rCD AND C.EFFDT=A.EFFDT AND C.EFFSEQ=A.EFFSEQ AND C.HCR_ACTN_SEQN=( SELECT MAX(D.HCR_ACTN_SEQN) FROM PS_HCR_JOB_STG D WHERE D.EMPLID=C.EMPLID AND D.EMPL_RCD=C.EMPL_rCD AND D.EFFDT=C.EFFDT AND D.EFFSEQ=C.EFFSEQ ) AND C.HCR_JOB_WIP_STATUS NOT IN('PRO','COR','DEL','CDE') AND C.HCR_TXN_TYP='J') UNION SELECT B.EMPLID , B.EMPL_RCD , B.EFFDT , B.EFFSEQ ,B.HCR_ACTN_SEQN , B.HCR_JOB_WIP_STATUS , B.PER_ORG , B.DEPTID , B.JOBCODE , B.POSITION_NBR , B.POSITION_OVERRIDE , B.POSN_CHANGE_RECORD , B.EMPL_STATUS , B.ACTION , B.ACTION_DT , B.ACTION_REASON , B.LOCATION , B.TAX_LOCATION_CD , B.JOB_ENTRY_DT , B.DEPT_ENTRY_DT , B.POSITION_ENTRY_DT , B.SHIFT , B.REG_TEMP , B.FULL_PART_TIME , B.FLSA_STATUS , B.OFFICER_CD , B.COMPANY , B.PAYGROUP , B.BAS_GROUP_ID , B.ELIG_CONFIG1 , B.ELIG_CONFIG2 , B.ELIG_CONFIG3 , B.ELIG_CONFIG4 , B.ELIG_CONFIG5 , B.ELIG_CONFIG6 , B.ELIG_CONFIG7 , B.ELIG_CONFIG8 , B.ELIG_CONFIG9 , B.BEN_STATUS , B.BAS_ACTION , B.COBRA_ACTION , B.EMPL_TYPE , B.HOLIDAY_SCHEDULE , B.STD_HOURS , B.STD_HRS_FREQUENCY , B.EEO_CLASS , B.EMPL_CLASS , B.SAL_ADMIN_PLAN , B.GRADE , B.GRADE_ENTRY_DT , B.STEP , B.STEP_ENTRY_DT , B.GL_PAY_TYPE , B.ACCT_CD , B.EARNS_DIST_TYPE , B.COMP_FREQUENCY , B.COMPRATE , B.CHANGE_AMT , B.CHANGE_PCT , B.ANNUAL_RT , B.MONTHLY_RT , B.DAILY_RT , B.HOURLY_RT , B.ANNL_BENEF_BASE_RT , B.SHIFT_RT , B.SHIFT_FACTOR , B.CURRENCY_CD , B.BUSINESS_UNIT , B.SETID_DEPT , B.SETID_JOBCODE , B.SETID_LOCATION , B.SETID_SALARY , B.FUNCTION_CD , B.HOURLY_RT_FRA , B.ACCDNT_CD_FRA , B.ESTABID , B.REG_REGION , B.DIRECTLY_TIPPED , B.ADDS_TO_FTE_ACTUAL , B.CLASS_INDC , B.FICA_STATUS_EE , B.FTE , B.PRORATE_CNT_AMT , B.ENCUMB_OVERRIDE , B.UNION_FULL_PART , B.UNION_POS , B.PAY_UNION_FEE , B.UNION_CD , B.BARG_UNIT , B.UNION_SENIORITY_DT , B.VALUE_1_FRA , B.VALUE_2_FRA , B.VALUE_3_FRA , B.VALUE_4_FRA , B.VALUE_5_FRA , B.CTG_RATE , B.TARIFF_GER , B.TARIFF_AREA_GER , B.PERFORM_GROUP_GER , B.LABOR_TYPE_GER , B.SPK_COMM_ID_GER , B.ENTRY_DATE , B.LABOR_AGREEMENT , B.EMPL_CTG , B.EMPL_CTG_L1 , B.EMPL_CTG_L2 , B.SETID_LBR_AGRMNT , B.PAY_SYSTEM_FLG , B.BORDER_WALKER , B.LUMP_SUM_PAY , B.CONTRACT_NUM , B.JOB_INDICATOR , B.GP_PAYGROUP , B.GP_DFLT_ELIG_GRP , B.GP_ELIG_GRP , B.GP_DFLT_CURRTTYP , B.CUR_RT_TYPE , B.GP_DFLT_EXRTDT , B.GP_ASOF_DT_EXG_RT , B.BENEFIT_SYSTEM , B.WRKS_CNCL_ROLE_CHE , B.EXEMPT_HOURS_MONTH , B.EXEMPT_JOB_LBR , B.INTERCTR_WRKS_CNCL , B.CURRENCY_CD1 , B.MATRICULA_NBR , B.SOC_SEC_RISK_CODE , B.UNION_FEE_AMOUNT , B.UNION_FEE_END_DT , B.UNION_FEE_START_DT , B.WRKS_CNCL_FUNCTION , B.PAID_HOURS , B.PAID_FTE , B.PAID_HRS_FREQUENCY , B.WORK_DAY_HOURS , B.SUPERVISOR_ID , B.REPORTS_TO , B.FORCE_PUBLISH , B.JOB_DATA_SRC_CD ,'S' , B.APPT_TYPE , B.HR_STATUS , B.LASTUPDOPRID , %DatePart(B.LASTUPDDTTM) FROM PS_HCR_JOB_STG B , PS_INSTALLATION WHERE B.HCR_JOB_WIP_STATUS NOT IN ('PRO','DEL','COR') AND B.HCR_TXN_TYP='J'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: NEW

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 HCR_ACTN_SEQN Number(3,0) SMALLINT NOT NULL Sequence number
6 HCR_JOB_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Job Data request work in progress
CDE=Correction Denied
CIN=Correction In-Progress
COR=Corrected
CRP=Correction Row Present
DEL=Deleted
DEN=Denied
INI=In-Progress
PBE=Rework
PBN=Rework
PRO=Completed
PUS=Rework
WIC=Withdrawn
WIT=Withdrawn
7 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest

Default Value: PER_ORG_ASGN.PER_ORG

8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

9 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: JOBCODE_TBL

10 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

Prompt Table: POSITION_DATA

11 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data

Y/N Table Edit

Default Value: N

12 POSN_CHANGE_RECORD Character(1) VARCHAR2(1) NOT NULL Position Management Record

Y/N Table Edit

Default Value: N

13 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

Default Value: A

14 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Default Value: HIR

Prompt Table: ACTION_TBL

15 ACTION_DT Date(10) DATE Action Date

Default Value: %date

16 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

Prompt Table: ACTN_REASON_TBL

17 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

18 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code
19 JOB_ENTRY_DT Date(10) DATE Job Entry Date
20 DEPT_ENTRY_DT Date(10) DATE Department Entry Date
21 POSITION_ENTRY_DT Date(10) DATE Position Entry Date
22 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating

Default Value: N

23 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary

Default Value: R

24 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

Default Value: F

25 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
A=Administrative
C=Computer Employee
E=Executive
H=Highly Compensated Employees
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
V=Nonexempt Alt Overtime
X=No FLSA Required

Default Value: X

26 OFFICER_CD Character(1) VARCHAR2(1) NOT NULL Officer Code
C=Chairman
D=Director
N=None
O=Officer
P=President
S=Secretary
T=Treasurer
V=Vice President

Default Value: N

27 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

28 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: PAYGROUP_TBL

29 BAS_GROUP_ID Character(3) VARCHAR2(3) NOT NULL Identifies a user-defined Benefits Administration group used to facilitate benefits processing. A group can represent the entire participant population of the enterprise, or a specific group of participants. It enables you to control processing by, for example, setting up separate Open Enrollment schedules for each group. If used, a BAS Group ID is assigned to each participant in a benefit program.
30 ELIG_CONFIG1 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
31 ELIG_CONFIG2 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
32 ELIG_CONFIG3 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
33 ELIG_CONFIG4 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
34 ELIG_CONFIG5 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
35 ELIG_CONFIG6 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
36 ELIG_CONFIG7 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
37 ELIG_CONFIG8 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
38 ELIG_CONFIG9 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
39 BEN_STATUS Character(4) VARCHAR2(4) NOT NULL Specifies an employee's status relative to benefits, and is used to determine eligibility for benefits. Some examples of benefit status are Active, Suspended, Leave with Benefits, and Terminated.
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Benefits
Q=Retired With Benefits
R=Retired
S=Suspended
T=Terminated
U=Terminated With Benefits
40 BAS_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment.
41 COBRA_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.
42 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried

Prompt Table: PAYGRP_EMPLTYPE

43 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

Prompt Table: HOLIDAY_TBL

44 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
45 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

Prompt Table: STDHRS_FREQ_VW

46 EEO_CLASS Character(1) VARCHAR2(1) NOT NULL EEO Classification
E=Exclude from Count
N=None of the Above
P=Production Trainee
W=White-Collar Trainee

Default Value: N

47 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
48 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

Prompt Table: SAL_PLAN_TBL

49 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

Prompt Table: SAL_GRADE_TBL

50 GRADE_ENTRY_DT Date(10) DATE Grade Entry Date
51 STEP Number(2,0) SMALLINT NOT NULL Step

Prompt Table: SAL_STEP_TBL

52 STEP_ENTRY_DT Date(10) DATE Step Entry Date
53 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
54 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

Prompt Table: ACCT_CD_TBL

55 EARNS_DIST_TYPE Character(1) VARCHAR2(1) NOT NULL Earnings Distribution Type
A=By Amount
H=By Hours
N=None
P=By Percent

Default Value: N

56 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly

Default Value: INSTALLATION.COMP_FREQUENCY

Prompt Table: COMP_FREQ_VW

57 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
58 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
59 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
60 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
61 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
62 DAILY_RT Number(19,3) DECIMAL(18,3) NOT NULL Daily Rate
63 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
64 ANNL_BENEF_BASE_RT Number(19,3) DECIMAL(18,3) NOT NULL Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.
65 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate
66 SHIFT_FACTOR Number(5,3) DECIMAL(4,3) NOT NULL Shift Differential Factor
67 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

Prompt Table: CURRENCY_CD_TBL

68 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

Prompt Table: BUS_UNIT_TBL_HR

69 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

Default Value: OPR_DEF_TBL_HR.SETID

70 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

Default Value: OPR_DEF_TBL_HR.SETID

71 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
72 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID
73 FUNCTION_CD Character(2) VARCHAR2(2) NOT NULL Function Code
74 HOURLY_RT_FRA Character(3) VARCHAR2(3) NOT NULL HFR
75 ACCDNT_CD_FRA Character(1) VARCHAR2(1) NOT NULL HFR
0=Do not Pay
1=Building
2=Waterproofing
3=Floor Surface
4=Factory Making
5=Laboratory
6=WorkShop
7=Office
76 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
77 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

Default Value: OPR_DEF_TBL_HR.REG_REGION

78 DIRECTLY_TIPPED Character(1) VARCHAR2(1) NOT NULL Tipped
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped

Default Value: JOBCODE_TBL.DIRECTLY_TIPPED

79 ADDS_TO_FTE_ACTUAL Character(1) VARCHAR2(1) NOT NULL Adds to FTE Actual Count

Y/N Table Edit

Default Value: N

80 CLASS_INDC Character(1) VARCHAR2(1) NOT NULL Classified/Unclassified Ind
B=All
C=Classified
T=Temporary
U=Unclassified

Default Value: C

81 FICA_STATUS_EE Character(1) VARCHAR2(1) NOT NULL FICA Status-Employee
E=Exempt
H=ER FICA Exmpt
J=EE FICA Exmpt
K=EE/ER FICA Exmpt
M=Medicare only
N=Subject
82 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
83 PRORATE_CNT_AMT Character(1) VARCHAR2(1) NOT NULL Prorate Contract Change Amount
C=Prorate Over Contract Period
E=Prorate Using Effective Date
N=No Proration of Change Amt.
P=Prorate Over Payment Period

Default Value: N

84 ENCUMB_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Encumbrance Override

Default Value: N

85 UNION_FULL_PART Character(1) VARCHAR2(1) NOT NULL Union Participation
F=Full Time
P=Part Time
86 UNION_POS Character(1) VARCHAR2(1) NOT NULL Union Position
L=Leader of the union
N=National Leader
R=Registered
S=Leader of S.O.C.
87 PAY_UNION_FEE Character(1) VARCHAR2(1) NOT NULL Pay Union Fee
88 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code
89 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2

Prompt Table: GVT_BARG_UNIT

90 UNION_SENIORITY_DT Date(10) DATE Union Seniority Date
91 VALUE_1_FRA Character(5) VARCHAR2(5) NOT NULL HFR
92 VALUE_2_FRA Character(5) VARCHAR2(5) NOT NULL HFR
93 VALUE_3_FRA Character(5) VARCHAR2(5) NOT NULL HCR
94 VALUE_4_FRA Character(5) VARCHAR2(5) NOT NULL HFR
95 VALUE_5_FRA Character(5) VARCHAR2(5) NOT NULL HFR
96 CTG_RATE Number(3,0) SMALLINT NOT NULL Category Rate
97 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
98 TARIFF_AREA_GER Character(3) VARCHAR2(3) NOT NULL Tariff Area
99 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
100 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
101 SPK_COMM_ID_GER Character(9) VARCHAR2(9) NOT NULL Spokesmen Committee ID
102 ENTRY_DATE Date(10) DATE Date Entered
103 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
104 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category
105 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory
106 EMPL_CTG_L2 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory 2
107 SETID_LBR_AGRMNT Character(5) VARCHAR2(5) NOT NULL Labor Agreement SetID
108 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface

Default Value: OPR_DEF_TBL_HR.PAY_SYSTEM_FLG

109 BORDER_WALKER Character(1) VARCHAR2(1) NOT NULL Cross Border Worker
110 LUMP_SUM_PAY Character(1) VARCHAR2(1) NOT NULL Lump Sum Retro Payment

Y/N Table Edit

Default Value: N

111 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
112 JOB_INDICATOR Character(1) VARCHAR2(1) NOT NULL This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable
P=Primary Job
S=Secondary Job

Default Value: P

113 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
114 GP_DFLT_ELIG_GRP Character(1) VARCHAR2(1) NOT NULL Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
115 GP_ELIG_GRP Character(10) VARCHAR2(10) NOT NULL Eligibility Group
116 GP_DFLT_CURRTTYP Character(1) VARCHAR2(1) NOT NULL Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
117 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
118 GP_DFLT_EXRTDT Character(1) VARCHAR2(1) NOT NULL Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
119 GP_ASOF_DT_EXG_RT Character(1) VARCHAR2(1) NOT NULL This field is used as a flag to determine whether to use a default exchange rate or not.
B=Pay Period Begin Date
E=Pay Period End Date
P=Payment Date
120 BENEFIT_SYSTEM Character(2) VARCHAR2(2) NOT NULL A flag that indicates whether the benefits for an employee are administered under PeopleSoft Benefits Administration or PeopleSoft Base Benefits.
BA=Benefits Administration
BN=Base Benefits
OT=Not Managed in PeopleSoft
121 WRKS_CNCL_ROLE_CHE Character(30) VARCHAR2(30) NOT NULL Use this field to track the Works Council role for Swiss employments.
122 EXEMPT_HOURS_MONTH Number(3,0) SMALLINT NOT NULL Exempted Hours per Month
123 EXEMPT_JOB_LBR Character(1) VARCHAR2(1) NOT NULL Exempted
124 INTERCTR_WRKS_CNCL Character(1) VARCHAR2(1) NOT NULL InterCtr.Works Council Function
1=Member 1
2=Member 2
3=Member 3
125 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code
126 MATRICULA_NBR Number(5,0) INTEGER NOT NULL Matricula Number
127 SOC_SEC_RISK_CODE Character(3) VARCHAR2(3) NOT NULL Social Security Risk Code
128 UNION_FEE_AMOUNT Number(9,2) DECIMAL(8,2) NOT NULL Union Fee Amount
129 UNION_FEE_END_DT Date(10) DATE Union Fee End Date
130 UNION_FEE_START_DT Date(10) DATE Union Fee Start Date
131 WRKS_CNCL_FUNCTION Character(1) VARCHAR2(1) NOT NULL Works Council Function
M=Member
P=President
S=Secretary
132 PAID_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Paid Hours
133 PAID_FTE Number(8,6) DECIMAL(7,6) NOT NULL This field is si;ilqr to JOB.FTE field however it is computed with PAID_HOURS instead of STD_HOURS. It is a French specific field.
134 PAID_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Paid Work Period
135 WORK_DAY_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Number of Hours in a Work Day
136 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
137 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
138 FORCE_PUBLISH Date(10) DATE Used to Force a publish on a row of data that wouldn't otherwise have been changed. This field is a system field only and will not appear on any Page so it does not need to be translated.
139 JOB_DATA_SRC_CD Character(3) VARCHAR2(3) NOT NULL This field indicates the source of a job row ie. whether the job row was User Generated (ie. online), Batch Generated, Staff Movement generated, etc. A blank in this field implies that the job row is user generated.
000=User Generated
001=Batch Generated
002=Staff Movement Generated
140 HCR_DATA_SRC Character(1) VARCHAR2(1) NOT NULL Job Data Source information
J=Job
S=Staging
141 APPT_TYPE Character(1) VARCHAR2(1) NOT NULL This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers.
0=Core Appointment
1=Japan Kenmu Appointment
2=French Public Sector Appt
3=Staffing
142 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive
143 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
144 HR_JOB_UPDDT Date(10) DATE Last Updated Date