LMS_AET(SQL Table) |
Index Back |
|---|---|
Salary Forcasting Cache recordSalary Forcasting Cache record used by process HR_LMSSCENAR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | LMS_SCENARIO_ID | Character(10) | VARCHAR2(10) NOT NULL | LMS - Scenario Id |
| 5 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 6 | LMS_WRK_PERIOD_ID | Character(10) | VARCHAR2(10) NOT NULL | Working Periods ID |
| 7 | LMS_REFERENCE_PD | Character(12) | VARCHAR2(12) NOT NULL | LMS Reference Period |
| 8 | LMS_FORECASTED_PD | Character(12) | VARCHAR2(12) NOT NULL | LMS Forecasted Period |
| 9 | PERIOD_START_DATE | Date(10) | DATE | Start Date |
| 10 | PERIOD_END_DATE | Date(10) | DATE | Period End Date |
| 11 | LMS_PERIOD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
LMS - Period Type
M=Month Q=Quarter S=Semester Y=Year |
| 12 | LMS_ELEMNT_PD_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Type of Elementary Period |
| 13 | FROM_DATE | Date(10) | DATE | From Date |
| 14 | THRU_DATE | Date(10) | DATE | Thru Date |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | CURRENCY_CD_AMT | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 17 | LMS_EXCHG_RT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Fixed Exchange Rate
Y/N Table Edit |
| 18 | ASOFDATE | Date(10) | DATE | As of Date |
| 19 | LMS_RECALC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Re-Extraction
Y/N Table Edit |
| 20 | VERSIONGBQDM | Number(10,0) | DECIMAL(10) NOT NULL | Version Number |
| 21 | LMS_FREQ_FACTOR | Number(9,4) | DECIMAL(8,4) NOT NULL | Frequency Annual Factor |
| 22 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 23 | LMS_COMPUTED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Calculated Data
Y/N Table Edit |
| 24 | LMS_EVENT_ID | Character(12) | VARCHAR2(12) NOT NULL | LMS Event Id |
| 25 | LMS_EVENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
LMS Event Type
C=Increase of component of pay E=Headcount Increases I=Incentives L=Headcount Decreases P=Promotion S=Seniority W=Working Schedule |
| 26 | SUB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Subgroup ID |
| 27 | LMS_STRUCTURE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Structure Effect |
| 28 | LMS_REPORT_FACTOR | Number(6,2) | DECIMAL(5,2) NOT NULL | Carry-Over Factor |
| 29 | LMS_SCENARIO_DTTM | DateTime(26) | TIMESTAMP | Scenario Run DateTime |
| 30 | LMS_SCENARIO_DT | Date(10) | DATE | Scenario Run Date |
| 31 | LMS_HEAD_COUNT | Number(11,2) | DECIMAL(10,2) NOT NULL | Head Count |
| 32 | LMS_GRP_HEAD_COUNT | Number(11,2) | DECIMAL(10,2) NOT NULL | Head Count |
| 33 | LMS_FTE | Number(15,6) | DECIMAL(14,6) NOT NULL | FTE |
| 34 | LMS_PREV_DT_FTE | Number(15,6) | DECIMAL(14,6) NOT NULL | Previous Date FTE |
| 35 | LMS_PREV_DT_HEAD | Number(6,0) | INTEGER NOT NULL | Previous Date Head Count |
| 36 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 37 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 38 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 39 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 40 | FROM_CURR_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 41 | MCOP_CURR_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 42 | 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. |
| 43 | LMS_MCOP_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Compensation Amount |
| 44 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |
| 45 | LMS_FROM_VC_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | From Amount |
| 46 | LMS_TO_VC_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | To Amount |
| 47 | LMS_LAST_SCEN_DTTM | DateTime(26) | TIMESTAMP | Last Scenario DateTime |
| 48 | LMS_LAST_SCENAR_DT | Date(10) | DATE | Last Scenario Date |
| 49 | LMS_PREV_FROM_DT | Date(10) | DATE | Previous From Date |
| 50 | LMS_AVG_SALARY | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Average Salary |
| 51 | LMS_MED_SALARY | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Medium Salary |
| 52 | LMS_RATECD_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Elementary Period Amount |
| 53 | LMS_REF_PD_NBR | Number(3,0) | SMALLINT NOT NULL | Reference Period Number |
| 54 | LMS_SETID_FROM | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL |
| 55 | LMS_FROM_JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Current Job Code
Prompt Table:
JOBCODE_TBL
|
| 56 | LMS_SETID_TO | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL |
| 57 | LMS_TO_JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Forecasted Job Code
Prompt Table:
JOBCODE_TBL
|
| 58 | COMP_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly |
| 59 | JOB_EFFDT | Date(10) | DATE | Job Effective Date |
| 60 | JOB_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Job Effective Sequence |
| 61 | PAID_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Paid Hours |
| 62 | PAID_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Paid Work Period |
| 63 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 64 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Standard Work Period |
| 65 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 66 | AE_TEST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Test Flag |
| 67 | LMS_BASSAL_ACUM1 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Base Salary Accumulator 1 |
| 68 | LMS_BASSAL_ACUM2 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Base Salary Accumulator 2 |
| 69 | LMS_REGBON_ACUM1 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Regular Bonus Accumulator 1 |
| 70 | LMS_REGBON_ACUM2 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Regular Bonus Accumulator 2 |
| 71 | LMS_SENPAY_ACUM1 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Seniority Accumulator 1 |
| 72 | LMS_SENPAY_ACUM2 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Seniority Accumulator 2 |
| 73 | LMS_INCENTIV_ACUM1 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Incentive Accumulator 1 |
| 74 | LMS_INCENTIV_ACUM2 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Incentive Accumulator 2 |
| 75 | LMS_BASSAL_AMT_AC1 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Base Salary Amount/Point Acc.1 |
| 76 | LMS_BASSAL_AMT_AC2 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Base Salary Amount/Point Acc.2 |
| 77 | LMS_BASSAL_PCT_AC1 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Base Salary Percent Accum. 1 |
| 78 | LMS_BASSAL_PCT_AC2 | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Base Salary Percent Accum. 2 |
| 79 | 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. |
| 80 | LMS_INDIV_MEAS_FLG | Character(1) | VARCHAR2(1) NOT NULL | Individual Measure |
| 81 | RATE_CODE_GROUP | Character(6) | VARCHAR2(6) NOT NULL | Rate Code Group Name |
| 82 | LMS_MCOP_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Compensation Frequency |
| 83 | LMS_MCOP_FTE_IND | Character(1) | VARCHAR2(1) NOT NULL | Apply FTE for Annualization |
| 84 | LMS_MCOP_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Comp Percent |
| 85 | LMS_MCOP_RATE_PTS | Number(5,0) | INTEGER NOT NULL | Comp Rate Points |
| 86 | LMS_MCOP_RATECDGRP | Character(6) | VARCHAR2(6) NOT NULL | Rate Code Group Name |
| 87 | FTE | Number(8,6) | DECIMAL(7,6) NOT NULL | This field represent Full Time Equivalence |
| 88 | PAID_FTE | Number(8,6) | DECIMAL(7,6) NOT NULL | This field is si;ilqr to JOB.FTE field however it is computed with PAID_HOURS instead of STD_HOURS. It is a French specific field. |
| 89 | LMS_INCENTIVE_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Incentive |
| 90 | LMS_INCENTGROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group ID |
| 91 | LMS_ACTIVATION_DT | Date(10) | DATE | Triggering Period |
| 92 | LMS_PRIORITY_NUM | Number(1,0) | SMALLINT NOT NULL | Processing Priority |