LMS_WRKSCH_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
3	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	LMS_HOURS_FROM	Number(7,2)	DECIMAL(6,2) NOT NULL	Hours From
6	LMS_HOURS_TO	Number(7,2)	DECIMAL(6,2) NOT NULL	Hours To
7	LMS_HOURS_RATE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Rate Percent
8	FREQ_ANNUAL_FACTOR	Number(12,7)	DECIMAL(11,7) NOT NULL	Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year.
9	LMS_FREQ_ANNUAL	Number(9,4)	DECIMAL(8,4) NOT NULL	Frequency Annual Factor
10	LMS_SUP_HOURS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Supplementary Hours
11	LMS_FTE_SUP_HRS	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	FTE Supplementary Hours
12	LMS_FTE	Number(15,6)	DECIMAL(14,6) NOT NULL	FTE
13	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
14	FROM_DATE	Date(10)	DATE	From Date
15	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
16	PAID_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Paid Hours
17	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
18	PAID_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Paid Work Period
19	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period