STP06_JPN_TMP

#	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 Record
4	COMP_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Compensation Eff Sequence
5	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
6	JOB_EFFDT	Date(10)	DATE	Job Effective Date
7	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
8	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
9	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary Set ID
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	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly
15	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
16	MONTHLY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Monthly Rate
17	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
18	COMP_RATE_POINTS	Number(5,0)	INTEGER NOT NULL	Comp Rate Points
19	COMP_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Comp Percent
20	RATE_CODE_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Rate Code Group Name
21	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
22	DAILY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Daily Rate