HR_TM_GRD_VW

(SQL View)
 Index Back

My Team PG Salary Grade Table

Current active record for the Salary Grade Table used in simplified analytic for My Team.

SELECT SETID , SAL_ADMIN_PLAN , GRADE , EFFDT , EFF_STATUS , SALARY_MATRIX_CD , CURRENCY_CD , MIN_RT_HOURLY , MID_RT_HOURLY , MAX_RT_HOURLY , MIN_RT_MONTHLY , MID_RT_MONTHLY , MAX_RT_MONTHLY , MIN_RT_ANNUAL , MID_RT_ANNUAL , MAX_RT_ANNUAL , STEP_INCREM_TYPE , STEP_INCREM_ACCUM , MIN_RT_DAILY , MID_RT_DAILY , MAX_RT_DAILY , LABOR_AGREEMENT , EMPL_CTG , EMPL_CTG_L1 , EMPL_CTG_L2 , REG_REGION FROM PS_SAL_GRADE_TBL GRD WHERE GRD.EFF_STATUS = 'A' AND GRD.EFFDT = ( SELECT MAX(ED2.EFFDT) FROM PS_SAL_GRADE_TBL ED2 WHERE ED2.SETID = GRD.SETID AND ED2.SAL_ADMIN_PLAN = GRD.SAL_ADMIN_PLAN AND ED2.GRADE = GRD.GRADE AND ED2.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_HR.SETID

Prompt Table: SET_VLD_HR_05

2 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

Prompt Table: SAL_PLAN_TBL

3 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

6 SALARY_MATRIX_CD Character(5) VARCHAR2(5) NOT NULL Salary Matrix Code

Prompt Table: SAL_MATRIX_TBL

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

8 MIN_RT_HOURLY Number(19,6) DECIMAL(18,6) NOT NULL Minimum Pay Rate-Hourly
9 MID_RT_HOURLY Number(19,6) DECIMAL(18,6) NOT NULL Midpoint Pay Rate-Hourly
10 MAX_RT_HOURLY Number(19,6) DECIMAL(18,6) NOT NULL Maximum Pay Rate-Hourly
11 MIN_RT_MONTHLY Number(19,3) DECIMAL(18,3) NOT NULL Minimum Pay Rate-Monthly
12 MID_RT_MONTHLY Number(19,3) DECIMAL(18,3) NOT NULL Midpoint Pay Rate-Monthly
13 MAX_RT_MONTHLY Number(19,3) DECIMAL(18,3) NOT NULL Maximum Pay Rate-Monthly
14 MIN_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Minimum Pay Rate-Annual
15 MID_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Midpoint Pay Rate-Annual
16 MAX_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Maximum Pay Rate-Annual
17 STEP_INCREM_TYPE Character(1) VARCHAR2(1) NOT NULL Step Increment Type
D=Date Based Increment Type
E=Either Hours or Date Based
H=Hours Based Increment Type
M=Manual Based Increment Type
W=Weeks Based Increment Type
18 STEP_INCREM_ACCUM Character(3) VARCHAR2(3) NOT NULL Spec Accum for Step Increments

Prompt Table: SPCL_EARNS_TBL

19 MIN_RT_DAILY Number(19,3) DECIMAL(18,3) NOT NULL Minimum Pay rate-Daily
20 MID_RT_DAILY Number(19,3) DECIMAL(18,3) NOT NULL Midpoint Pay rate-Daily
21 MAX_RT_DAILY Number(19,3) DECIMAL(18,3) NOT NULL Maximum Pay rate-Daily
22 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

Prompt Table: EMPL_CTG

23 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category

Prompt Table: EMPL_CTG_L1

24 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory

Prompt Table: EMPL_CTG_L2

25 EMPL_CTG_L2 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory 2

Prompt Table: EMPL_CTG_L3

26 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

Prompt Table: REG_STANDARD_VW