LMS_HOURS_RATE (SQL Table)	Index Back
Hours rate Record Salary Forecasting: this record stores rates for supplementary hours.

LMS_HOURS_RATE

(SQL Table)

Hours rate Record

Salary Forecasting: this record stores rates for supplementary hours.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LMS_HOURS_EFFDT Date(10) DATE NOT NULL Hours Rate Effective Date
Default Value: %date

2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

3 LMS_HOURS_FROM Number(7,2) DECIMAL(6,2) NOT NULL Hours From

4 LMS_HOURS_TO Number(7,2) DECIMAL(6,2) NOT NULL Hours To

5 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.
Prompt Table: COMP_FREQ_VW

6 LMS_HOURS_RATE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Rate Percent

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LMS_HOURS_EFFDT	Date(10)	DATE NOT NULL	Hours Rate Effective Date Default Value: %date
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	LMS_HOURS_FROM	Number(7,2)	DECIMAL(6,2) NOT NULL	Hours From
4	LMS_HOURS_TO	Number(7,2)	DECIMAL(6,2) NOT NULL	Hours To
5	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. Prompt Table: COMP_FREQ_VW
6	LMS_HOURS_RATE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Rate Percent