COMP_SP_TMP

#	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 NOT NULL	Effective Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	COMP_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Compensation Eff Sequence
6	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
7	COMP_RATE_POINTS	Number(5,0)	INTEGER NOT NULL	Comp Rate Points
8	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
9	COMP_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Comp Percent
10	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
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	MANUAL_SW	Character(1)	VARCHAR2(1) NOT NULL	Manual Switch
13	CONVERT_COMPRT	Number(19,6)	DECIMAL(18,6) NOT NULL	Converted Comp Rate
14	RATE_CODE_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Rate Code Group Name
15	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
16	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
17	CHANGE_PTS	Signed Number(6,0)	DECIMAL(5) NOT NULL	Change Points
18	FTE_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Apply FTE for Annualization
19	CMP_SRC_IND	Character(1)	VARCHAR2(1) NOT NULL	Rate Code Source Indicator A=Absorbing Premium B=Non-Absorbing Premium C=Combination Rule E=Seniority Pay J=Job Code M=Manual N=None P=Payroll R=Employee Review S=Salary Step
20	SP_PROC_STAT	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