IDO_ASOF2JPN_VW (SQL View)	Index Back
Ido As Of Date View This view is used to display Job information as of Org Plan Date.

IDO_ASOF2JPN_VW

(SQL View)

Ido As Of Date View

This view is used to display Job information as of Org Plan Date.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.APPT_TYPE , A.BUSINESS_UNIT , A.DEPTID , A.SUPV_LVL_ID FROM PS_JOB A WHERE A.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB WHERE EMPLID = A.EMPLID AND EMPL_RCD = A.EMPL_RCD AND EFFDT = A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID_JPN Character(11) VARCHAR2(11) NOT NULL Used when a second EMPLID is needed on a record/page.

2 EMPL_RCD_JPN Signed Number(4,0) DECIMAL(3) NOT NULL Tracks the empl_rcd of an additional appointment. This is used in records that also lists the main appointment empl_rcd.

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 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

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

6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

7 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID_JPN	Character(11)	VARCHAR2(11) NOT NULL	Used when a second EMPLID is needed on a record/page.
2	EMPL_RCD_JPN	Signed Number(4,0)	DECIMAL(3) NOT NULL	Tracks the empl_rcd of an additional appointment. This is used in records that also lists the main appointment empl_rcd.
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	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
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
7	SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level ID for use in capability grade system