COMP_RATCD_LANG (SQL Table)	Index Back
Related Lang - COMP_RATECD_TBL 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.

COMP_RATCD_LANG

(SQL Table)

Related Lang - COMP_RATECD_TBL

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.

Related Language Record for COMP_RATECD_TBL COMP_RC_NOMX_VW CRC_FA_JPN_VW DEFR_CRC_JPN_VW FO_HRL_COMPRTCD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description