SP_UPDCOMP_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	EFFDT	Date(10)	DATE	Effective Date
6	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
7	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
8	COMP_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Compensation Eff Sequence
9	COMP_RATE_POINTS	Number(5,0)	INTEGER NOT NULL	Comp Rate Points
10	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
11	COMP_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Comp Percent
12	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
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	MANUAL_SW	Character(1)	VARCHAR2(1) NOT NULL	Manual Switch
15	CONVERT_COMPRT	Number(19,6)	DECIMAL(18,6) NOT NULL	Converted Comp Rate
16	RATE_CODE_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Rate Code Group Name
17	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
18	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
19	CHANGE_PTS	Signed Number(6,0)	DECIMAL(5) NOT NULL	Change Points
20	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
21	SP_PROCESS_NAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
22	COMP_RATE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Rate Code Type FA=Flat Amount HF=Hourly Rate + Flat Amount HR=Hourly Rate PC=Percent PT=Points