LMS_HOURS_RATE

(SQL Table)
Index Back

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