TC_COMP_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	COMP_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Compensation Eff Sequence
4	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
5	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
6	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID
7	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
8	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
9	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
10	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
11	COMP_RATE_POINTS	Number(5,0)	INTEGER NOT NULL	Comp Rate Points
12	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
13	COMP_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Comp Percent
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	RATE_CODE_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Rate Code Group Name
16	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
17	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
18	CHANGE_PTS	Signed Number(6,0)	DECIMAL(5) NOT NULL	Change Points
19	RATE_CODE_CLASS	Character(6)	VARCHAR2(6) NOT NULL	Defines classes of rate codes. A rate code class can be used to bundle and group rate codes defined in the Comp Rate Code Table.
20	FTE_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Apply FTE for Annualization
21	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
22	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
23	PRD_END_DT	Date(10)	DATE	Pay Period End Date
24	VC_TARGET_PAYOUT	Character(10)	VARCHAR2(10) NOT NULL	Target Payout
25	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
26	VC_TARGET_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	Target Value
27	VC_AWARD_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	Variable Comp Award Value