LMS_CATRAT_AET(SQL Table) |
Index Back |
|---|---|
LMS Category Ratio AETCategory Ratio AET for LMS - La Masse Salariale |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | LMS_MONTH_1 | Number(2,0) | SMALLINT NOT NULL | 1st Month |
| 3 | LMS_MONTH_2 | Number(2,0) | SMALLINT NOT NULL | 2nd Month |
| 4 | LMS_MONTH_3 | Number(2,0) | SMALLINT NOT NULL | 3rd Month |
| 5 | LMS_MONTH_4 | Number(2,0) | SMALLINT NOT NULL | 4th Month |
| 6 | LMS_MONTH_5 | Number(2,0) | SMALLINT NOT NULL | 5th Month |
| 7 | LMS_MONTH_6 | Number(2,0) | SMALLINT NOT NULL | 6th Month |
| 8 | LMS_MONTH_7 | Number(2,0) | SMALLINT NOT NULL | 7th Month |
| 9 | LMS_MONTH_8 | Number(2,0) | SMALLINT NOT NULL | 8th Month |
| 10 | LMS_MONTH_9 | Number(2,0) | SMALLINT NOT NULL | 9th Month |
| 11 | LMS_MONTH_10 | Number(2,0) | SMALLINT NOT NULL | 10th Month |
| 12 | LMS_MONTH_11 | Number(2,0) | SMALLINT NOT NULL | 11th Month |
| 13 | LMS_MONTH_12 | Number(2,0) | SMALLINT NOT NULL | 12th Month |
| 14 | LMS_SMONTH_1 | Number(2,0) | SMALLINT NOT NULL | 1st Semi Month |
| 15 | LMS_SMONTH_2 | Number(2,0) | SMALLINT NOT NULL | 2nd Semi Month |
| 16 | LMS_SMONTH_3 | Number(2,0) | SMALLINT NOT NULL | 3rd Semi Month |
| 17 | LMS_SMONTH_4 | Number(2,0) | SMALLINT NOT NULL | 4th Semi Month |
| 18 | LMS_SMONTH_5 | Number(2,0) | SMALLINT NOT NULL | 5th Semi Month |
| 19 | LMS_SMONTH_6 | Number(2,0) | SMALLINT NOT NULL | 6th Semi Month |
| 20 | LMS_SMONTH_7 | Number(2,0) | SMALLINT NOT NULL | 7th Semi Month |
| 21 | LMS_SMONTH_8 | Number(2,0) | SMALLINT NOT NULL | 8th Semi Month |
| 22 | LMS_SMONTH_9 | Number(2,0) | SMALLINT NOT NULL | 9th Semi Month |
| 23 | LMS_SMONTH_10 | Number(2,0) | SMALLINT NOT NULL | 10th Semi Month |
| 24 | LMS_SMONTH_11 | Number(2,0) | SMALLINT NOT NULL | 11th Semi Month |
| 25 | LMS_SMONTH_12 | Number(2,0) | SMALLINT NOT NULL | 12th Semi Month |
| 26 | LMS_SMONTH_13 | Number(2,0) | SMALLINT NOT NULL | 13th Semi Month |
| 27 | LMS_SMONTH_14 | Number(2,0) | SMALLINT NOT NULL | 14th Semi Month |
| 28 | LMS_SMONTH_15 | Number(2,0) | SMALLINT NOT NULL | 15th Semi Month |
| 29 | LMS_SMONTH_16 | Number(2,0) | SMALLINT NOT NULL | 16th Semi Month |
| 30 | LMS_SMONTH_17 | Number(2,0) | SMALLINT NOT NULL | 17th Semi Month |
| 31 | LMS_SMONTH_18 | Number(2,0) | SMALLINT NOT NULL | 18th Semi Month |
| 32 | LMS_SMONTH_19 | Number(2,0) | SMALLINT NOT NULL | 19th Semi Month |
| 33 | LMS_SMONTH_20 | Number(2,0) | SMALLINT NOT NULL | 20th Semi Month |
| 34 | LMS_SMONTH_21 | Number(2,0) | SMALLINT NOT NULL | 21st Semi Month |
| 35 | LMS_SMONTH_22 | Number(2,0) | SMALLINT NOT NULL | 22nd Semi Month |
| 36 | LMS_SMONTH_23 | Number(2,0) | SMALLINT NOT NULL | 23rd Semi Month |
| 37 | LMS_SMONTH_24 | Number(2,0) | SMALLINT NOT NULL | 24th Semi Month |
| 38 | LMS_DIVISOR_NBR | Number(2,0) | SMALLINT NOT NULL | / |
| 39 | LMS_MULTIPLE_NBR | Number(2,0) | SMALLINT NOT NULL | Prorate Multiplicator |
| 40 | LMS_CATEGORY_CD | Character(3) | VARCHAR2(3) NOT NULL | Category Code |
| 41 | LMS_CAT_RAT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Category Ratio Flag |
| 42 | LMS_FULL_PRD_COST | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Full Period Cost |
| 43 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 44 | RATE_CODE_CLASS | Character(6) | VARCHAR2(6) NOT NULL | Defines classes of rate codes. A rate code class can be used to bundle and group rate codes defined in the Comp Rate Code Table. |
| 45 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |
| 46 | LMS_PRORATED_COST | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Prorated Cost |