LMS_SUBGRP_TMP (SQL Table)	Index Back
LMS - Group Result temp table Salary Forecasting: This record store group version number for process HR_LMSSCENAR.

LMS_SUBGRP_TMP

(SQL Table)

LMS - Group Result temp table

Salary Forecasting: This record store group version number for process HR_LMSSCENAR.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LMS_SCENARIO_ID Character(10) VARCHAR2(10) NOT NULL LMS - Scenario Id

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

3 FROM_DATE Date(10) DATE NOT NULL From Date

4 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

5 VERSIONGBQDM Number(10,0) DECIMAL(10) NOT NULL Version Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LMS_SCENARIO_ID	Character(10)	VARCHAR2(10) NOT NULL	LMS - Scenario Id
2	LMS_SCENARIO_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Scenario Run DateTime
3	FROM_DATE	Date(10)	DATE NOT NULL	From Date
4	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
5	VERSIONGBQDM	Number(10,0)	DECIMAL(10) NOT NULL	Version Number