SAL_SIM_JPN_VW3 (SQL View)	Index Back
Salary Increase Run View3 This is the View to select GroupID, to output Bonus Report and to update JOB/COMPENSATION record according to the result of Salary Increase Simulation.

SAL_SIM_JPN_VW3

(SQL View)

Salary Increase Run View3

This is the View to select GroupID, to output Bonus Report and to update JOB/COMPENSATION record according to the result of Salary Increase Simulation.

SELECT DISTINCT SAL_INC_ID , CALC_NUM , GB_GROUP_ID FROM PS_SALINC_SIML_JPN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SAL_INC_ID Character(12) VARCHAR2(12) NOT NULL Salary Increase ID

2 CALC_NUM Number(3,0) SMALLINT NOT NULL Calculation Number

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SAL_INC_ID	Character(12)	VARCHAR2(12) NOT NULL	Salary Increase ID
2	CALC_NUM	Number(3,0)	SMALLINT NOT NULL	Calculation Number
3	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.