IDO2_JPN_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	ORG_PLAN_JPN	Character(3)	VARCHAR2(3) NOT NULL	Tracks one possible view of the employees in a company.
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
10	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
13	SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level ID for use in capability grade system
14	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
15	START_DATE_JPN	Date(10)	DATE	Tracks the beginning date of an additional appointment assignment.
16	EXP_END_DATE_JPN	Date(10)	DATE	Tracks the date in the future when the additional appointment assignment is expected to be completed.
17	END_DATE_JPN	Date(10)	DATE	The actual date that an additional appointment assignment was completed.
18	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
19	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
20	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
21	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
22	JOBCODE_JPN	Character(6)	VARCHAR2(6) NOT NULL	JobCode for using in IDO processing
23	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
24	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.