JOB_SUM_JPN_VW

(SQL View)
 Index Back

Vw-JOB w/out PeopleCode

JOB_VW is a view of the Job record, which screens out most PeopleCode for the Position Management application. All text, numeric, and required date fields are included. This record is in a work scroll on the Position Data 1 panel, and is used to control the cross-update to Job from Position_Data. Please note: if you modify the Job record to add columns, this view will need to be changed to include the new fields if Position Management is used. Audits: If you currently audit the Job record, the same audit flags should be set on this record to trap changes from the position side.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.DEPTID , A.JOBCODE , A.POSITION_NBR ,A.APPT_TYPE ,A.MAIN_APPT_NUM_JPN , A.POSITION_OVERRIDE , A.POSN_CHANGE_RECORD , A.EMPL_STATUS , A.ACTION , A.ACTION_DT , A.ACTION_REASON , A.LOCATION , A.POSITION_ENTRY_DT , A.REG_TEMP , A.FULL_PART_TIME , A.COMPANY , A.PAYGROUP , A.EMPL_TYPE , A.STD_HOURS , A.STD_HRS_FREQUENCY , A.EMPL_CLASS , A.SAL_ADMIN_PLAN , A.GRADE , A.GRADE_ENTRY_DT , A.STEP , A.STEP_ENTRY_DT , A.COMP_FREQUENCY , A.COMPRATE , A.CHANGE_AMT , A.CHANGE_PCT , A.ANNUAL_RT , A.MONTHLY_RT , A.DAILY_RT , A.HOURLY_RT , A.CURRENCY_CD , A.BUSINESS_UNIT , A.SETID_DEPT , A.SETID_JOBCODE , A.SETID_LOCATION , A.SETID_SALARY , A.ESTABID , A.REG_REGION , A.FTE , A.PAY_SYSTEM_FLG , A.JOB_INDICATOR , A.SUPERVISOR_ID , A.REPORTS_TO , A.SETID_SUPV_LVL , A.SUPV_LVL_ID , B.OTHER_ID_JPN , A.ABSENCE_SYSTEM_CD , A.POI_TYPE 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

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 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

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

Prompt Table: JOBCODE_TBL

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

Prompt Table: POSITION_DATA

8 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

9 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.
10 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

12 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

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

Default Value: HIR

Prompt Table: ACTION_TBL

14 ACTION_DT Date(10) DATE Action Date

Default Value: %date

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

Prompt Table: ACTN_REASON_TBL

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

Prompt Table: LOCATION_TBL

17 POSITION_ENTRY_DT Date(10) DATE Position Entry Date
18 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary

Default Value: R

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

Default Value: F

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

Prompt Table: COMPANY_TBL

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

Prompt Table: PAYGROUP_TBL

22 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried

Prompt Table: PAYGRP_EMPLTYPE

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

Prompt Table: STDHRS_FREQ_VW

25 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
26 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

Prompt Table: SAL_PLAN_TBL

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

Prompt Table: SAL_GRADE_TBL

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

Prompt Table: SAL_STEP_TBL

30 STEP_ENTRY_DT Date(10) DATE Step Entry Date
31 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

32 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
33 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
34 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
35 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
36 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
37 DAILY_RT Number(19,3) DECIMAL(18,3) NOT NULL Daily Rate
38 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
39 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

Prompt Table: CURRENCY_CD_TBL

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

Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

Prompt Table: BUS_UNIT_TBL_HR

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

Default Value: OPR_DEF_TBL_HR.SETID

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

Default Value: OPR_DEF_TBL_HR.SETID

43 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
44 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID
45 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
46 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
47 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
48 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
49 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
50 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
51 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
52 SETID_SUPV_LVL Character(5) VARCHAR2(5) NOT NULL Stored setid for the Supervisor Level.
53 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system
54 OTHER_ID_JPN Character(11) VARCHAR2(11) NOT NULL Other Identifier
55 ABSENCE_SYSTEM_CD Character(3) VARCHAR2(3) NOT NULL What Absence System this Assignment is tied to.
AM=Absence Management
OT=Other
56 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.