LMS_PROMO_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	FTE_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Apply FTE for Annualization
3	RATE_CODE_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Rate Code Group Name Prompt Table: COMPRT_GRP_TBL
4	COMP_RATE_POINTS	Number(5,0)	INTEGER NOT NULL	Comp Rate Points
5	COMP_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Comp Percent
6	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
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 Prompt Table: FREQUENCY_TBL
8	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
9	USE_RTCD_GROUP_SW	Character(1)	VARCHAR2(1) NOT NULL	Use Rate Code Groups
10	LMS_EVENT_FROM_DT	Date(10)	DATE	From Date
11	LMS_EVENT_THRU_DT	Date(10)	DATE	Event Thru Date
12	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	RATE_CODE_CLASS1	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.
14	COMP_RATECD1	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
15	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company