PERIOD_IDPrompt Table: LMS_PERIOD_TBL
LMS_ELEMNT_PD_TYPEPrompt Table: LMS_FREQUENC_VW
12=12 Months
13=13 Months
14=14 Months
15=15 Months
Default Value: 12
LMS_PRORATE_TBL(SQL Table) |
Index Back |
|---|---|
Proration RecordSalary Forecasting: this record stores prorate factor and the number of month to take in account during the simulation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERIOD_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Time Period ID
Prompt Table: LMS_PERIOD_TBL |
| 2 | LMS_ELEMNT_PD_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Type of Elementary Period
Prompt Table: LMS_FREQUENC_VW |
| 3 | LMS_PRORATE_MONTHS | Character(2) | VARCHAR2(2) NOT NULL |
Pro-Ration Months
12=12 Months 13=13 Months 14=14 Months 15=15 Months Default Value: 12 |
| 4 | LMS_MONTH_1 | Number(2,0) | SMALLINT NOT NULL | 1st Month |
| 5 | LMS_MONTH_2 | Number(2,0) | SMALLINT NOT NULL | 2nd Month |
| 6 | LMS_MONTH_3 | Number(2,0) | SMALLINT NOT NULL | 3rd Month |
| 7 | LMS_MONTH_4 | Number(2,0) | SMALLINT NOT NULL | 4th Month |
| 8 | LMS_MONTH_5 | Number(2,0) | SMALLINT NOT NULL | 5th Month |
| 9 | LMS_MONTH_6 | Number(2,0) | SMALLINT NOT NULL | 6th Month |
| 10 | LMS_MONTH_7 | Number(2,0) | SMALLINT NOT NULL | 7th Month |
| 11 | LMS_MONTH_8 | Number(2,0) | SMALLINT NOT NULL | 8th Month |
| 12 | LMS_MONTH_9 | Number(2,0) | SMALLINT NOT NULL | 9th Month |
| 13 | LMS_MONTH_10 | Number(2,0) | SMALLINT NOT NULL | 10th Month |
| 14 | LMS_MONTH_11 | Number(2,0) | SMALLINT NOT NULL | 11th Month |
| 15 | LMS_MONTH_12 | Number(2,0) | SMALLINT NOT NULL | 12th Month |
| 16 | LMS_SMONTH_1 | Number(2,0) | SMALLINT NOT NULL | 1st Semi Month |
| 17 | LMS_SMONTH_2 | Number(2,0) | SMALLINT NOT NULL | 2nd Semi Month |
| 18 | LMS_SMONTH_3 | Number(2,0) | SMALLINT NOT NULL | 3rd Semi Month |
| 19 | LMS_SMONTH_4 | Number(2,0) | SMALLINT NOT NULL | 4th Semi Month |
| 20 | LMS_SMONTH_5 | Number(2,0) | SMALLINT NOT NULL | 5th Semi Month |
| 21 | LMS_SMONTH_6 | Number(2,0) | SMALLINT NOT NULL | 6th Semi Month |
| 22 | LMS_SMONTH_7 | Number(2,0) | SMALLINT NOT NULL | 7th Semi Month |
| 23 | LMS_SMONTH_8 | Number(2,0) | SMALLINT NOT NULL | 8th Semi Month |
| 24 | LMS_SMONTH_9 | Number(2,0) | SMALLINT NOT NULL | 9th Semi Month |
| 25 | LMS_SMONTH_10 | Number(2,0) | SMALLINT NOT NULL | 10th Semi Month |
| 26 | LMS_SMONTH_11 | Number(2,0) | SMALLINT NOT NULL | 11th Semi Month |
| 27 | LMS_SMONTH_12 | Number(2,0) | SMALLINT NOT NULL | 12th Semi Month |
| 28 | LMS_SMONTH_13 | Number(2,0) | SMALLINT NOT NULL | 13th Semi Month |
| 29 | LMS_SMONTH_14 | Number(2,0) | SMALLINT NOT NULL | 14th Semi Month |
| 30 | LMS_SMONTH_15 | Number(2,0) | SMALLINT NOT NULL | 15th Semi Month |
| 31 | LMS_SMONTH_16 | Number(2,0) | SMALLINT NOT NULL | 16th Semi Month |
| 32 | LMS_SMONTH_17 | Number(2,0) | SMALLINT NOT NULL | 17th Semi Month |
| 33 | LMS_SMONTH_18 | Number(2,0) | SMALLINT NOT NULL | 18th Semi Month |
| 34 | LMS_SMONTH_19 | Number(2,0) | SMALLINT NOT NULL | 19th Semi Month |
| 35 | LMS_SMONTH_20 | Number(2,0) | SMALLINT NOT NULL | 20th Semi Month |
| 36 | LMS_SMONTH_21 | Number(2,0) | SMALLINT NOT NULL | 21st Semi Month |
| 37 | LMS_SMONTH_22 | Number(2,0) | SMALLINT NOT NULL | 22nd Semi Month |
| 38 | LMS_SMONTH_23 | Number(2,0) | SMALLINT NOT NULL | 23rd Semi Month |
| 39 | LMS_SMONTH_24 | Number(2,0) | SMALLINT NOT NULL | 24th Semi Month |
| 40 | LMS_DIVISOR_NBR | Number(2,0) | SMALLINT NOT NULL | / |