AA_COMPARE_JPN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	ADD_APPT_ID	Number(3,0)	SMALLINT NOT NULL	Additional Appointment ID
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
8	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
9	SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level ID for use in capability grade system
10	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
11	COMPANY2	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: INTCPX_CPY_JPN
12	DEPTID2	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_ADD_VW_JPN
13	SUPV_LVL_ID2	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level Prompt Table: INTCPX_SPV_JPN
14	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
15	EXP_END_DATE	Date(10)	DATE	Expected End Date
16	END_DATE	Date(10)	DATE	End Date
17	COST_RATE	Number(2,0)	SMALLINT NOT NULL	Cost Rate
18	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.
19	ROW_NUM	Number(3,0)	SMALLINT NOT NULL	Row Number
20	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action