LMS_SENIOR_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
7	JOB_EFFDT	Date(10)	DATE	Job Effective Date
8	COMP_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Compensation Eff Sequence
9	COMP_RATECD_OLD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
10	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
11	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
12	COMP_RATE_POINTS	Number(5,0)	INTEGER NOT NULL	Comp Rate Points
13	COMP_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Comp Percent
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	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
16	FTE_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Apply FTE for Annualization
17	RATE_CODE_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Rate Code Group Name
18	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.
19	FROM_DATE	Date(10)	DATE	From Date
20	THRU_DATE	Date(10)	DATE	Thru Date