LMS_INCREAS_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	LMS_EVENT_FROM_DT	Date(10)	DATE	From Date
10	LMS_EVENT_THRU_DT	Date(10)	DATE	Event Thru Date
11	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	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.
13	COMP_RATECD1	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
14	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
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	AMOUNT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percent Amount
19	POINT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percent of Points
20	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
21	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
22	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number