IDO_FUT_JPN_VW (SQL View)	Index Back
Ido Future Update This record tracks the data which will be inserted into the Job Record if the AE program IDO2_JPN is run for that Org Plan.

IDO_FUT_JPN_VW

(SQL View)

Ido Future Update

This record tracks the data which will be inserted into the Job Record if the AE program IDO2_JPN is run for that Org Plan.

SELECT A.ORG_PLAN_JPN , A.EMPLID , A.EMPL_RCD , A.SEQUENCE_JPN , B.NAME , C.APPT_TYPE , A.ACTION , A.ACTION_REASON , A.BUSINESS_UNIT , A.DEPTID , A.SUPV_LVL_ID , A.IDO_ACTION_JPN , A.START_DATE_JPN , A.EXP_END_DATE_JPN , A.END_DATE_JPN , A.COMPANY , A.LOCATION , A.JOBCODE , A.EFFDT , A.PROC_STAT_JPN FROM PS_IDO_FUT_UPD_JPN A , PS_PERSON_NAME B , PS_JOB C WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND A.EMPL_RCD = C.EMPL_RCD AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB WHERE EMPLID = C.EMPLID AND EMPL_RCD = C.EMPL_RCD) AND C.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB WHERE EMPLID = C.EMPLID AND EMPL_RCD = C.EMPL_RCD AND EFFDT = C.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ORG_PLAN_JPN Character(3) VARCHAR2(3) NOT NULL Tracks one possible view of the employees in a company.
Prompt Table: IDO_ORGPLAN_JPN

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: ACTIVE_WRKR_VW

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
Prompt Table: EE_RCD_JPN_VW

4 SEQUENCE_JPN Number(4,0) SMALLINT NOT NULL Sequence
Default Value: 1

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

6 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

7 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: ACTION_TBL

8 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
Prompt Table: ACTN_REASON_TBL

9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUSUNIT_HR_VW

10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

11 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system
Prompt Table: SUPVSR_LVL_TBL

12 IDO_ACTION_JPN Character(2) VARCHAR2(2) NOT NULL Tracks the Action being applied to a Tamatsuki Post.
10=Open Post
20=Assigned
30=Closed Post
40=Create Additional Appointment
Default Value: 20

13 START_DATE_JPN Date(10) DATE Tracks the beginning date of an additional appointment assignment.

14 EXP_END_DATE_JPN Date(10) DATE Tracks the date in the future when the additional appointment assignment is expected to be completed.

15 END_DATE_JPN Date(10) DATE The actual date that an additional appointment assignment was completed.

16 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

17 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: LOCATION_TBL

18 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
Prompt Table: JOBCODE_TBL

19 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

20 PROC_STAT_JPN Character(1) VARCHAR2(1) NOT NULL Tracks the status of rows associated with a process.
E=Error prevented processing
N=Not Processed
W=Row processed but check log
Y=Processed
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ORG_PLAN_JPN	Character(3)	VARCHAR2(3) NOT NULL	Tracks one possible view of the employees in a company. Prompt Table: IDO_ORGPLAN_JPN
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: ACTIVE_WRKR_VW
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: EE_RCD_JPN_VW
4	SEQUENCE_JPN	Number(4,0)	SMALLINT NOT NULL	Sequence Default Value: 1
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	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
7	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
8	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUSUNIT_HR_VW
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
11	SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level ID for use in capability grade system Prompt Table: SUPVSR_LVL_TBL
12	IDO_ACTION_JPN	Character(2)	VARCHAR2(2) NOT NULL	Tracks the Action being applied to a Tamatsuki Post. 10=Open Post 20=Assigned 30=Closed Post 40=Create Additional Appointment Default Value: 20
13	START_DATE_JPN	Date(10)	DATE	Tracks the beginning date of an additional appointment assignment.
14	EXP_END_DATE_JPN	Date(10)	DATE	Tracks the date in the future when the additional appointment assignment is expected to be completed.
15	END_DATE_JPN	Date(10)	DATE	The actual date that an additional appointment assignment was completed.
16	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
17	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
18	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
19	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
20	PROC_STAT_JPN	Character(1)	VARCHAR2(1) NOT NULL	Tracks the status of rows associated with a process. E=Error prevented processing N=Not Processed W=Row processed but check log Y=Processed Default Value: N