JOB_CNT_ESP_VW

(SQL View)
 Index Back

View on JOB used in CONTRACT

View on JOB including CONTRACT_NUM in the Key, used in the CONTRACT Panel Context to display JOB selected Information. Active occurence (max effdt)

SELECT A.EMPLID ,A.CONTRACT_NUM ,A.EFFDT ,A.EFFSEQ ,A.EMPL_RCD ,A.ACTION ,A.ACTION_REASON ,A.EMPL_STATUS ,A.COMPANY ,A.ESTABID ,A.SETID_DEPT ,A.DEPTID ,A.SETID_JOBCODE ,A.JOBCODE ,A.REG_TEMP ,A.LOCATION ,A.BUSINESS_UNIT ,A.POSITION_NBR ,A.PAYGROUP ,A.STD_HOURS ,A.STD_HRS_FREQUENCY ,%Truncate(A.HOURLY_RT, 2) ,%Truncate(A.MONTHLY_RT, 2) ,%Truncate(A.ANNUAL_RT, 2) ,A.EMPL_CTG ,A.EMPL_CTG_L1 ,A.GP_PAYGROUP ,%Truncate(A.COMPRATE, 2) ,A.CURRENCY_CD ,A.COMP_FREQUENCY ,A.JOB_INDICATOR ,A.REG_REGION ,A.SETID_LBR_AGRMNT ,A.LABOR_AGREEMENT ,A.APPT_TYPE ,A.FTE ,B.SSN_EMPLOYER ,A.SOC_SEC_RISK_CODE ,A.FULL_PART_TIME FROM PS_JOB A , PS_JOB_JR B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

7 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
8 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
9 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

10 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

Prompt Table: ESTAB_TBL

11 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
13 SETID Character(5) VARCHAR2(5) NOT NULL SetID
14 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: JOBCODE_TBL

15 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
16 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

17 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
18 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
19 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
20 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
21 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
22 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
23 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
24 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
25 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category
26 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory
27 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP

28 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
30 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

Prompt Table: COMP_FREQ_VW

31 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
32 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
33 SETID_LBR_AGRMNT Character(5) VARCHAR2(5) NOT NULL Labor Agreement SetID
34 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

Prompt Table: HR_LABOR_AGRMNT

35 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
36 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
37 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number

Prompt Table: ALL_CCC_ESP_VW

38 SOC_SEC_RISK_CODE Character(3) VARCHAR2(3) NOT NULL Social Security Risk Code

Prompt Table: SOCS_OCUPTN_ESP

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