|
SELECT JOB.EMPLID , JOB.EMPL_RCD , JOB.EFFDT , JOB.EFFSEQ , JOB.PER_ORG , JOB.DEPTID , JOB.JOBCODE , JOB.POSITION_NBR , JOB.SUPERVISOR_ID , JOB.HR_STATUS , JOB.APPT_TYPE , JOB.MAIN_APPT_NUM_JPN , JOB.POSITION_OVERRIDE , JOB.POSN_CHANGE_RECORD , JOB.EMPL_STATUS , JOB.ACTION , JOB.ACTION_DT , JOB.ACTION_REASON , JOB.LOCATION , JOB.TAX_LOCATION_CD , JOB.JOB_ENTRY_DT , JOB.DEPT_ENTRY_DT , JOB.POSITION_ENTRY_DT , JOB.SHIFT , JOB.REG_TEMP , JOB.FULL_PART_TIME , JOB.COMPANY , JOB.PAYGROUP , JOB.BAS_GROUP_ID , JOB.ELIG_CONFIG1 , JOB.ELIG_CONFIG2 , JOB.ELIG_CONFIG3 , JOB.ELIG_CONFIG4 , JOB.ELIG_CONFIG5 , JOB.ELIG_CONFIG6 , JOB.ELIG_CONFIG7 , JOB.ELIG_CONFIG8 , JOB.ELIG_CONFIG9 , JOB.BEN_STATUS , JOB.BAS_ACTION , JOB.COBRA_ACTION , JOB.EMPL_TYPE , JOB.HOLIDAY_SCHEDULE , JOB.STD_HOURS , JOB.STD_HRS_FREQUENCY , JOB.OFFICER_CD , JOB.EMPL_CLASS , JOB.SAL_ADMIN_PLAN , JOB.GRADE , JOB.GRADE_ENTRY_DT , JOB.STEP , JOB.STEP_ENTRY_DT , JOB.GL_PAY_TYPE , JOB.ACCT_CD , JOB.EARNS_DIST_TYPE , JOB.COMP_FREQUENCY , JOB.COMPRATE , JOB.CHANGE_AMT , JOB.CHANGE_PCT , JOB.ANNUAL_RT , JOB.MONTHLY_RT , JOB.DAILY_RT , JOB.HOURLY_RT , JOB.ANNL_BENEF_BASE_RT , JOB.SHIFT_RT , JOB.SHIFT_FACTOR , JOB.CURRENCY_CD , JOB.BUSINESS_UNIT , JOB.SETID_DEPT , JOB.SETID_JOBCODE , JOB.SETID_LOCATION , JOB.SETID_SALARY , JOB.SETID_EMPL_CLASS , JOB.REG_REGION , JOB.DIRECTLY_TIPPED , JOB.FLSA_STATUS , JOB.EEO_CLASS , JOB.FUNCTION_CD , JOB.TARIFF_GER , JOB.TARIFF_AREA_GER , JOB.PERFORM_GROUP_GER , JOB.LABOR_TYPE_GER , JOB.SPK_COMM_ID_GER , JOB.HOURLY_RT_FRA , JOB.ACCDNT_CD_FRA , JOB.VALUE_1_FRA , JOB.VALUE_2_FRA , JOB.VALUE_3_FRA , JOB.VALUE_4_FRA , JOB.VALUE_5_FRA , JOB.CTG_RATE , JOB.PAID_HOURS , JOB.PAID_FTE , JOB.PAID_HRS_FREQUENCY , JOB.UNION_FULL_PART , JOB.UNION_POS , JOB.MATRICULA_NBR , JOB.SOC_SEC_RISK_CODE , JOB.UNION_FEE_AMOUNT , JOB.UNION_FEE_START_DT , JOB.UNION_FEE_END_DT , JOB.EXEMPT_JOB_LBR , JOB.EXEMPT_HOURS_MONTH , JOB.WRKS_CNCL_FUNCTION , JOB.INTERCTR_WRKS_CNCL , JOB.CURRENCY_CD1 , JOB.PAY_UNION_FEE , JOB.UNION_CD , JOB.BARG_UNIT , JOB.UNION_SENIORITY_DT , JOB.ENTRY_DATE , JOB.LABOR_AGREEMENT , JOB.EMPL_CTG , JOB.EMPL_CTG_L1 , JOB.EMPL_CTG_L2 , JOB.SETID_LBR_AGRMNT , JOB.WPP_STOP_FLAG , JOB.LABOR_FACILITY_ID , JOB.LBR_FAC_ENTRY_DT , JOB.LAYOFF_EXEMPT_FLAG , JOB.LAYOFF_EXEMPT_RSN , JOB.GP_PAYGROUP , JOB.GP_DFLT_ELIG_GRP , JOB.GP_ELIG_GRP , JOB.GP_DFLT_CURRTTYP , JOB.CUR_RT_TYPE , JOB.GP_DFLT_EXRTDT , JOB.GP_ASOF_DT_EXG_RT , JOB.ADDS_TO_FTE_ACTUAL , JOB.CLASS_INDC , JOB.ENCUMB_OVERRIDE , JOB.FICA_STATUS_EE , JOB.FTE , JOB.PRORATE_CNT_AMT , JOB.PAY_SYSTEM_FLG , JOB.BORDER_WALKER , JOB.LUMP_SUM_PAY , JOB.CONTRACT_NUM , JOB.JOB_INDICATOR , JOB.WRKS_CNCL_ROLE_CHE , JOB.BENEFIT_SYSTEM , JOB.WORK_DAY_HOURS , JOB.REPORTS_TO , JOB.FORCE_PUBLISH , JOB.JOB_DATA_SRC_CD , JOB.ESTABID , JOB.SUPV_LVL_ID , JOB.SETID_SUPV_LVL , JOB.ABSENCE_SYSTEM_CD , JOB.POI_TYPE , JOB.HIRE_DT , JOB.LAST_HIRE_DT , JOB.TERMINATION_DT , JOB.ASGN_START_DT , JOB.LST_ASGN_START_DT , JOB.ASGN_END_DT , JOB.LDW_OVR , JOB.LAST_DATE_WORKED , JOB.EXPECTED_RETURN_DT , JOB.EXPECTED_END_DATE , JOB.AUTO_END_FLG , JOB.LASTUPDDTTM , JOB.LASTUPDOPRID FROM PS_JOB JOB , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = JOB.EMPLID AND ASG.EMPL_RCD = JOB.EMPL_RCD AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PER_ORG_ASGN.EMPLID
Prompt Table:
PERS_SRCH_GBL
|
| 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 |
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
|
| 6 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 7 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 8 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSN_DATA_VW
|
| 9 |
SUPERVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Supervisor ID
Prompt Table:
HCR_SUP_ID_DVW
|
| 10 |
HR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Status
A=Active
I=Inactive
Default Value: A
|
| 11 |
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
Default Value: 0
|
| 12 |
MAIN_APPT_NUM_JPN |
Number(3,0) |
SMALLINT NOT NULL |
Tracks the empl_rcd for the Main Appointment of this row. For a Main Appointment, this field stores the same value as the current empl_rcd, for an Additional Appointment, it stores the value of a different empl_rcd.
|
| 13 |
POSITION_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Position Data
Y/N Table Edit
Default Value: N
|
| 14 |
POSN_CHANGE_RECORD |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Management Record
Y/N Table Edit
Default Value: N
|
| 15 |
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
|
| 16 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 17 |
ACTION_DT |
Date(10) |
DATE |
Action Date
Default Value: %date
|
| 18 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 19 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 20 |
TAX_LOCATION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code
Prompt Table:
%RECNAME_EDIT
|
| 21 |
JOB_ENTRY_DT |
Date(10) |
DATE |
Job Entry Date
|
| 22 |
DEPT_ENTRY_DT |
Date(10) |
DATE |
Department Entry Date
|
| 23 |
POSITION_ENTRY_DT |
Date(10) |
DATE |
Position Entry Date
|
| 24 |
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
|
| 25 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
Default Value: R
|
| 26 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
Default Value: F
|
| 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:
%EDITTABLE5
|
| 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.
Prompt Table:
BAS_GROUP_TBL
|
| 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:
PYGRP_EMPTYP_VW
|
| 43 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
Holiday Schedule
Prompt Table:
HOLIDAY_VW
|
| 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 |
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
|
| 47 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
Prompt Table:
EMPL_CLASS_TBL
Set Control Field: REG_REGION
|
| 48 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table:
%EDITTABLE7
|
| 49 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table:
%EDITTABLE8
|
| 50 |
GRADE_ENTRY_DT |
Date(10) |
DATE |
Grade Entry Date
|
| 51 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
Prompt Table:
%EDITTABLE9
|
| 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:
%EDITTABLE2
|
| 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:
BUSUNIT_HR_VW
|
| 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 |
SETID_EMPL_CLASS |
Character(5) |
VARCHAR2(5) NOT NULL |
Employee class Set ID
Default Value: EMPL_CLASS_TBL.SETID
|
| 74 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Default Value: OPR_DEF_TBL_HR.REG_REGION
Prompt Table:
REG_STANDARD_VW
|
| 75 |
DIRECTLY_TIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tipped
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped
Default Value: JOBCODE_TBL.DIRECTLY_TIPPED
|
| 76 |
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
|
| 77 |
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
|
| 78 |
FUNCTION_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Function Code
Prompt Table:
FUNCTION_CD_TBL
|
| 79 |
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
|
| 80 |
TARIFF_AREA_GER |
Character(3) |
VARCHAR2(3) NOT NULL |
Tariff Area
Prompt Table:
TARIFF_AREA_GER
|
| 81 |
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
|
| 82 |
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
|
| 83 |
SPK_COMM_ID_GER |
Character(9) |
VARCHAR2(9) NOT NULL |
Spokesmen Committee ID
Prompt Table:
SPK_COMM_GER
|
| 84 |
HOURLY_RT_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
HFR
Prompt Table:
HOURS_TYPE_FRA
|
| 85 |
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
|
| 86 |
VALUE_1_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 87 |
VALUE_2_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 88 |
VALUE_3_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HCR
|
| 89 |
VALUE_4_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 90 |
VALUE_5_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
HFR
|
| 91 |
CTG_RATE |
Number(3,0) |
SMALLINT NOT NULL |
Category Rate
|
| 92 |
PAID_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Paid Hours
|
| 93 |
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.
|
| 94 |
PAID_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Paid Work Period
Prompt Table:
STDHRS_FREQ_VW
|
| 95 |
UNION_FULL_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
Union Participation
F=Full Time
P=Part Time
|
| 96 |
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.
|
| 97 |
MATRICULA_NBR |
Number(5,0) |
INTEGER NOT NULL |
Matricula Number
|
| 98 |
SOC_SEC_RISK_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Social Security Risk Code
Prompt Table:
%EDITTABLE12
|
| 99 |
UNION_FEE_AMOUNT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Union Fee Amount
|
| 100 |
UNION_FEE_START_DT |
Date(10) |
DATE |
Union Fee Start Date
|
| 101 |
UNION_FEE_END_DT |
Date(10) |
DATE |
Union Fee End Date
|
| 102 |
EXEMPT_JOB_LBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempted
Y/N Table Edit
Default Value: N
|
| 103 |
EXEMPT_HOURS_MONTH |
Number(3,0) |
SMALLINT NOT NULL |
Exempted Hours per Month
|
| 104 |
WRKS_CNCL_FUNCTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Works Council Function
M=Member
P=President
S=Secretary
|
| 105 |
INTERCTR_WRKS_CNCL |
Character(1) |
VARCHAR2(1) NOT NULL |
InterCtr.Works Council Function
1=Member 1
2=Member 2
3=Member 3
|
| 106 |
CURRENCY_CD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 107 |
PAY_UNION_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Union Fee
Y/N Table Edit
|
| 108 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
Prompt Table:
UNION_TBL
|
| 109 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
Prompt Table:
HR_BARG_UNIT
|
| 110 |
UNION_SENIORITY_DT |
Date(10) |
DATE |
Union Seniority Date
|
| 111 |
ENTRY_DATE |
Date(10) |
DATE |
Date Entered
|
| 112 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
HR_LABOR_AGRMNT
|
| 113 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
Prompt Table:
EMPL_CTG_L1_VW
|
| 114 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
Prompt Table:
EMPL_CTG_L2_VW
|
| 115 |
EMPL_CTG_L2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory 2
Prompt Table:
EMPL_CTG_L3_VW
|
| 116 |
SETID_LBR_AGRMNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Labor Agreement SetID
|
| 117 |
WPP_STOP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Flag to indicated that Wage Progression is stopped on this Assignment.
Y/N Table Edit
Default Value: N
|
| 118 |
LABOR_FACILITY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Labor Facility ID
Prompt Table:
HR_LBR_FAC_VW
|
| 119 |
LBR_FAC_ENTRY_DT |
Date(10) |
DATE |
Date the Person was added to this Labor Facility.
|
| 120 |
LAYOFF_EXEMPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Flag to indicate if a Person's Assignment is exempt from Layoff.
Y/N Table Edit
Default Value: N
|
| 121 |
LAYOFF_EXEMPT_RSN |
Character(11) |
VARCHAR2(11) NOT NULL |
Reason for the Exemption from Layoff
Prompt Table:
HR_LAY_EXEM_TBL
|
| 122 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
%EDITTABLE6
|
| 123 |
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)
Y/N Table Edit
Default Value: Y
|
| 124 |
GP_ELIG_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Eligibility Group
Prompt Table:
GP_ELIG_GRP
|
| 125 |
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)
Y/N Table Edit
Default Value: Y
|
| 126 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 127 |
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)
Y/N Table Edit
Default Value: Y
|
| 128 |
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
|
| 129 |
ADDS_TO_FTE_ACTUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Adds to FTE Actual Count
Y/N Table Edit
Default Value: N
|
| 130 |
CLASS_INDC |
Character(1) |
VARCHAR2(1) NOT NULL |
Classified/Unclassified Ind
B=All
C=Classified
T=Temporary
U=Unclassified
Default Value: C
|
| 131 |
ENCUMB_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Encumbrance Override
Y/N Table Edit
Default Value: N
|
| 132 |
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
|
| 133 |
FTE |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
This field represent Full Time Equivalence
|
| 134 |
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
|
| 135 |
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
|
| 136 |
BORDER_WALKER |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Border Worker
Y/N Table Edit
Default Value: N
|
| 137 |
LUMP_SUM_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Lump Sum Retro Payment
Y/N Table Edit
Default Value: N
|
| 138 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
Prompt Table:
CNT_ACTIVE_VW
|
| 139 |
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
|
| 140 |
WRKS_CNCL_ROLE_CHE |
Character(30) |
VARCHAR2(30) NOT NULL |
Use this field to track the Works Council role for Swiss employments.
|
| 141 |
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
|
| 142 |
WORK_DAY_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Number of Hours in a Work Day
|
| 143 |
REPORTS_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
Reports To Position Number
Prompt Table:
POSITION_DATA
|
| 144 |
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.
|
| 145 |
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
|
| 146 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
%EDITTABLE3
|
| 147 |
SUPV_LVL_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Supervisor Level ID for use in capability grade system
Prompt Table:
SUPVSR_LVL_TBL
|
| 148 |
SETID_SUPV_LVL |
Character(5) |
VARCHAR2(5) NOT NULL |
Stored setid for the Supervisor Level.
|
| 149 |
ABSENCE_SYSTEM_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
What Absence System this Assignment is tied to.
AM=Absence Management
OT=Other
Default Value: OT
|
| 150 |
POI_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines the Transactional usage of POIs in HRMS.
|
| 151 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 152 |
LAST_HIRE_DT |
Date(10) |
DATE |
Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD.
|
| 153 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 154 |
ASGN_START_DT |
Date(10) |
DATE |
Start date of the specific EMPL_RCD assignment. This is different from the Person's Hire date.
|
| 155 |
LST_ASGN_START_DT |
Date(10) |
DATE |
Lastest start date of the specific EMPL_RCD assignment. This is different from the Person's organizational instance Last Hire Date.
|
| 156 |
ASGN_END_DT |
Date(10) |
DATE |
End date of the specific EMPL_RCD assignment. This is different from the Person's Termination date.
|
| 157 |
LDW_OVR |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate whether the user has overridden the Last Date Worked - ON THIS JOB_DATES row. It will only be set to 'Y' on the row where the date is entered, it will be 'N' on the later rows.
This allows us to identify which JOB_DATES row is the row where the Date was either set or updated without having to look at the previous row. If the LDW = ( EFFDT - 1 ) or the LDW_OVR is 'Y', then this is the row where the LDW was set - and therefore can be corrected.
Y/N Table Edit
Default Value: N
|
| 158 |
LAST_DATE_WORKED |
Date(10) |
DATE |
Last Date Worked
|
| 159 |
EXPECTED_RETURN_DT |
Date(10) |
DATE |
Expected Return Date
|
| 160 |
EXPECTED_END_DATE |
Date(10) |
DATE |
Expected End Date of a job.
|
| 161 |
AUTO_END_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is on the Job page and it allows the users to indicate whether they want the system to automatically end this job on the Expected End Date of the job.
This field is dependent on the Expected End Date having a value.
Y/N Table Edit
Default Value: N
|
| 162 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime
|
| 163 |
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.
|