LMS_HOURS_RATE(SQL Table) |
Index Back |
---|---|
Hours rate RecordSalary 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 |