FP_COMPENSATION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMP_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Compensation Eff Sequence
2	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
3	FP_COMP_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	VARCHAR2(1) NOT NULL I=Individual Premiums J=Job premiums M=Main Salary R=Rank Premiums S=Secondary Salary
4	COMP_RATE_POINTS	Number(5,0)	INTEGER NOT NULL	Comp Rate Points
5	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
6	COMP_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Comp Percent
7	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
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	MANUAL_SW	Character(1)	VARCHAR2(1) NOT NULL	Manual Switch
10	CONVERT_COMPRT	Number(19,6)	DECIMAL(18,6) NOT NULL	Converted Comp Rate
11	RATE_CODE_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Rate Code Group Name
12	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
13	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
14	CHANGE_PTS	Signed Number(6,0)	DECIMAL(5) NOT NULL	Change Points
15	FTE_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Apply FTE for Annualization
16	FP_SHR_TM_RT	Number(5,3)	DECIMAL(4,3) NOT NULL	Proration Ratio