LMS_RESULT_AET(SQL Table) |
Index Back |
|---|---|
LMS - Result TableSalary Forecasting: This record contains results of the salary forecasting simulation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | LMS_HEAD_COUNT | Number(11,2) | DECIMAL(10,2) NOT NULL | Head Count |
| 3 | LMS_FTE | Number(15,6) | DECIMAL(14,6) NOT NULL | FTE |
| 4 | LMS_AVG_SALARY | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Average Salary |
| 5 | LMS_MED_SALARY | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Medium Salary |
| 6 | LMS_RATECD_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Elementary Period Amount |
| 7 | LMS_REF_AVG_SALARY | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Average Salary |
| 8 | LMS_REF_AVG_FTE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Average FTE |
| 9 | LMS_REF_AVG_COUNT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Average Headcount |
| 10 | LMS_REF_TOTAL_COMP | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Total Compensation |
| 11 | LMS_REF_MED_SALARY | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Medium Salary |
| 12 | LMS_ANA_TOTAL_COMP | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Total Compensation |
| 13 | LMS_ANA_AVG_SALARY | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Average Salary |
| 14 | LMS_ANA_MED_SALARY | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Medium Salary |
| 15 | LMS_ANA_AVG_FTE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Average FTE |
| 16 | LMS_ANA_AVG_COUNT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Average Count |
| 17 | LMS_MAX_SALARY | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Maximum Salary |
| 18 | LMS_MIN_SALARY | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Minimum Salary |
| 19 | LMS_COUNTER | Number(3,0) | SMALLINT NOT NULL | Counter |
| 20 | LMS_EVENT_ID | Character(12) | VARCHAR2(12) NOT NULL | LMS Event Id |
| 21 | LMS_CATEGORY_CD | Character(3) | VARCHAR2(3) NOT NULL | Category Code |
| 22 | LMS_PRORATED_COST | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Prorated Cost |
| 23 | LMS_FULL_PRD_COST | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Full Period Cost |
| 24 | LMS_LEVEL_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Level Effect |
| 25 | LMS_MASS_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Mass Effect |
| 26 | LMS_CAROVR_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Carry-over Effect |
| 27 | LMS_COUNT_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Headcount Effect |
| 28 | LMS_STRUCT_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Structure Effect |
| 29 | LMS_NORIA_EFF_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Noria Effect |
| 30 | LMS_LEVEL_TOT_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Level Effect Total |
| 31 | LMS_MASS_TOT_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Mass Effect Total |
| 32 | LMS_CAROVR_TOT_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Carry-over Effect Total |
| 33 | LMS_PARENT_CAT_CD | Character(3) | VARCHAR2(3) NOT NULL | Parent Category Code |
| 34 | LMS_ASM_AVG_FTE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Average FTE |
| 35 | LMS_ASM_TOTAL_COMP | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Total Compensation |
| 36 | LMS_RSM_AVG_FTE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Average FTE |
| 37 | LMS_RSM_TOTAL_COMP | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Total Compensation |
| 38 | LMS_RSM_TOTAL_MFTE | Signed Number(23,6) | DECIMAL(21,6) NOT NULL | Total Compensation |