JOB_CONTRACT_OL

(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.EMPL_RCD ,A.EFFDT ,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 ,A.HOURLY_RT ,A.MONTHLY_RT ,A.ANNUAL_RT ,A.EMPL_CTG ,A.GP_PAYGROUP ,A.COMPRATE ,A.CURRENCY_CD ,A.COMP_FREQUENCY ,A.JOB_INDICATOR ,A.REG_REGION ,A.LABOR_AGREEMENT ,A.APPT_TYPE ,A.FTE FROM PS_JOB A

# 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

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

Prompt Table: ACTION_TBL

6 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
7 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
8 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
9 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
10 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
12 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
13 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
14 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
15 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
16 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
17 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
18 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
19 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
20 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
21 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
22 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
23 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
24 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category
25 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
26 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
27 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
28 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
29 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
30 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
31 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
32 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
33 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence