PER062_TMP_JPN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	EFFDT	Date(10)	DATE	Effective Date
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
7	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
8	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
9	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary SetID
10	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
11	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
12	STEP	Number(2,0)	SMALLINT NOT NULL	Step
13	GRADE_ENTRY_DT	Date(10)	DATE	Grade Entry Date
14	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
15	SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level ID for use in capability grade system
16	HIRE_DT	Date(10)	DATE	First Start Date
17	EDUC_LVL_AD_BTD	Date(10)	DATE	Adjusted Birth Date
18	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name