HRS_GVT_STP_VW2 (SQL View)	Index Back
Salary Step Table Used as the Prompt for Step on the federalized dbs. It swaps SETID with GVT_PAY_PLAN to get the appropriate prompt values

HRS_GVT_STP_VW2

(SQL View)

Salary Step Table

Used as the Prompt for Step on the federalized dbs. It swaps SETID with GVT_PAY_PLAN to get the appropriate prompt values

SELECT %Substring(A.SETID,1,2) , A.SAL_ADMIN_PLAN , A.GRADE , A.EFFDT , A.STEP FROM PS_SAL_STEP_TBL A

Parent record: SAL_GRADE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
Prompt Table: GVT_PAY_PLAN

2 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
Prompt Table: SAL_PLAN_TBL

3 GRADE_TO Character(3) VARCHAR2(3) NOT NULL To Grade

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 STEP_TO Number(2,0) SMALLINT NOT NULL Step

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GVT_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Pay Plan Prompt Table: GVT_PAY_PLAN
2	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Prompt Table: SAL_PLAN_TBL
3	GRADE_TO	Character(3)	VARCHAR2(3) NOT NULL	To Grade
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	STEP_TO	Number(2,0)	SMALLINT NOT NULL	Step