HCR_JOB_FLD_VW(SQL View) |
Index Back |
---|---|
View of Job and StagingUnion 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 |