LMS_POPULATION (SQL Table)	Index Back
EE Group Record Salary Forecasting: This record contains a group of EE who are used by the salary forecasting scenario.

LMS_POPULATION

(SQL Table)

EE Group Record

Salary Forecasting: This record contains a group of EE who are used by the salary forecasting scenario.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LMS_SCENARIO_ID Character(10) VARCHAR2(10) NOT NULL LMS - Scenario Id
Prompt Table: LMS_SCENARIO

2 LMS_SCENARIO_DTTM DateTime(26) TIMESTAMP NOT NULL Scenario Run DateTime

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

5 FROM_DATE Date(10) DATE NOT NULL From Date

6 JOB_EFFDT Date(10) DATE Job Effective Date

7 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence

8 LMS_EE_LEAVE_DT Date(10) DATE Employee Leave Date

9 LMS_EE_ENTRY_DT Date(10) DATE Employee Entry Date

10 LMS_FTE Number(15,6) DECIMAL(14,6) NOT NULL FTE

11 LMS_EE_INCEN_DT Date(10) DATE Incentive Date

12 LMS_INCENTGROUP_ID Character(15) VARCHAR2(15) NOT NULL Group ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LMS_SCENARIO_ID	Character(10)	VARCHAR2(10) NOT NULL	LMS - Scenario Id Prompt Table: LMS_SCENARIO
2	LMS_SCENARIO_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Scenario Run DateTime
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	FROM_DATE	Date(10)	DATE NOT NULL	From Date
6	JOB_EFFDT	Date(10)	DATE	Job Effective Date
7	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
8	LMS_EE_LEAVE_DT	Date(10)	DATE	Employee Leave Date
9	LMS_EE_ENTRY_DT	Date(10)	DATE	Employee Entry Date
10	LMS_FTE	Number(15,6)	DECIMAL(14,6) NOT NULL	FTE
11	LMS_EE_INCEN_DT	Date(10)	DATE	Incentive Date
12	LMS_INCENTGROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group ID