PER064JP_DATA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job 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 NOT NULL	Effective Date Default Value: %date
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
7	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
8	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification
9	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
10	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
11	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
12	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
13	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
14	SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level ID for use in capability grade system
15	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary SetID
16	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
17	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
18	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
19	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
20	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
21	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
22	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number