COMPRATECDT_UPG (SQL Table)	Index Back
Comp Rate Code Table In this table, the user will define rates which will be available to the entire employee population for pay earnings calculations. All rates that are to be used by payroll processing at job code or employee levels must first be defined in this table.

COMPRATECDT_UPG

(SQL Table)

Comp Rate Code Table

In this table, the user will define rates which will be available to the entire employee population for pay earnings calculations. All rates that are to be used by payroll processing at job code or employee levels must first be defined in this table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

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

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

6 COMP_BASE_PAY_SW Character(1) VARCHAR2(1) NOT NULL Comp Base Pay Switch
Y/N Table Edit
Default Value: N

7 USE_HIGHEST_RT_SW Character(1) VARCHAR2(1) NOT NULL Use Highest Rate
Y/N Table Edit
Default Value: N

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

9 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate

10 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent

11 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
Prompt Table: COMP_FREQ_VW

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

13 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
Prompt Table: COMP_RT_ERNS_VW

14 FTE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Apply FTE for Annualization
Y/N Table Edit
Default Value: N

15 RATE_CODE_CLASS Character(6) VARCHAR2(6) NOT NULL Defines classes of rate codes. A rate code class can be used to bundle and group rate codes defined in the Comp Rate Code Table.
Prompt Table: RATECD_CLS_TBL

16 SENIORITY_CALC Character(1) VARCHAR2(1) NOT NULL This field defines by what date seniority should be calculated for the Seniority Pay compensation component.
B=Birth Date
E=EdclvlaBDt (for Japan only)
H=Hire Date
P=Professional Experience Date
S=Company Seniority Date

17 SAL_PKG_WARN Character(1) VARCHAR2(1) NOT NULL Sal package - Maintained via Package Only
Y/N Table Edit
Default Value: N

18 CMP_NON_UPD_IND Character(1) VARCHAR2(1) NOT NULL Non-Updateable Component Indicator
Y/N Table Edit
Default Value: N

19 CMP_CALC_BY Character(2) VARCHAR2(2) NOT NULL Calculated By
Default Value: ZZ

20 CMP_PAYABLE_SW Character(1) VARCHAR2(1) NOT NULL Payable Switch
Y/N Table Edit
Default Value: Y

21 LOOKUP_ID Character(15) VARCHAR2(15) NOT NULL Main unique identifier for Configurable Matrices.
Prompt Table: WCS_RATE_MX_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	COMP_BASE_PAY_SW	Character(1)	VARCHAR2(1) NOT NULL	Comp Base Pay Switch Y/N Table Edit Default Value: N
7	USE_HIGHEST_RT_SW	Character(1)	VARCHAR2(1) NOT NULL	Use Highest Rate Y/N Table Edit Default Value: N
8	COMP_RATE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Comp Rate Type FA=Flat Amount HF=Hourly Rate + Flat Amount HR=Hourly Rate PC=Percent PT=Points
9	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
10	COMP_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Comp Percent
11	COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly Prompt Table: COMP_FREQ_VW
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
13	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code Prompt Table: COMP_RT_ERNS_VW
14	FTE_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Apply FTE for Annualization Y/N Table Edit Default Value: N
15	RATE_CODE_CLASS	Character(6)	VARCHAR2(6) NOT NULL	Defines classes of rate codes. A rate code class can be used to bundle and group rate codes defined in the Comp Rate Code Table. Prompt Table: RATECD_CLS_TBL
16	SENIORITY_CALC	Character(1)	VARCHAR2(1) NOT NULL	This field defines by what date seniority should be calculated for the Seniority Pay compensation component. B=Birth Date E=EdclvlaBDt (for Japan only) H=Hire Date P=Professional Experience Date S=Company Seniority Date
17	SAL_PKG_WARN	Character(1)	VARCHAR2(1) NOT NULL	Sal package - Maintained via Package Only Y/N Table Edit Default Value: N
18	CMP_NON_UPD_IND	Character(1)	VARCHAR2(1) NOT NULL	Non-Updateable Component Indicator Y/N Table Edit Default Value: N
19	CMP_CALC_BY	Character(2)	VARCHAR2(2) NOT NULL	Calculated By Default Value: ZZ
20	CMP_PAYABLE_SW	Character(1)	VARCHAR2(1) NOT NULL	Payable Switch Y/N Table Edit Default Value: Y
21	LOOKUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Main unique identifier for Configurable Matrices. Prompt Table: WCS_RATE_MX_VW