COMP_RATECD_VW (SQL View)	Index Back
Comp Rate Code View A view of the Comp Rate Code Table.

COMP_RATECD_VW

(SQL View)

Comp Rate Code View

A view of the Comp Rate Code Table.

SELECT A.COMP_RATECD ,A.COMP_BASE_PAY_SW ,A.COMP_RATE_TYPE FROM PS_COMP_RATECD_TBL A WHERE A.EFFDT = (SELECT MAX(EFFDT) FROM PS_COMP_RATECD_TBL B WHERE A.COMP_RATECD = B.COMP_RATECD AND B.EFFDT <= %CURRENTDATEIN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMP_RATECD_OT Character(6) VARCHAR2(6) NOT NULL Overtime Comp Rate Code

2 COMP_BASE_PAY_SW Character(1) VARCHAR2(1) NOT NULL Comp Base Pay Switch

3 COMP_RATE_TYPE Character(2) VARCHAR2(2) NOT NULL Rate Code Type
FA=Flat Amount
HF=Hourly Rate + Flat Amount
HR=Hourly Rate
PC=Percent
PT=Points

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMP_RATECD_OT	Character(6)	VARCHAR2(6) NOT NULL	Overtime Comp Rate Code
2	COMP_BASE_PAY_SW	Character(1)	VARCHAR2(1) NOT NULL	Comp Base Pay Switch
3	COMP_RATE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Rate Code Type FA=Flat Amount HF=Hourly Rate + Flat Amount HR=Hourly Rate PC=Percent PT=Points