BN_RATETYPE_LNG (SQL Table)	Index Back
Benefit Rate Types - Rel Lang This is a related language table for Benefit Rate Types. A Rate Type defines whether the rates are specified as amounts or percents, and what keys are required to access an individual rate.

BN_RATETYPE_LNG

(SQL Table)

Benefit Rate Types - Rel Lang

This is a related language table for Benefit Rate Types. A Rate Type defines whether the rates are specified as amounts or percents, and what keys are required to access an individual rate.

Related Language Record for BN_RATE_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RATE_TYPE Character(4) VARCHAR2(4) NOT NULL This is used to identify the type of benefit rate in use - the keys, usage, and high-level attributes the govern how a rate behaves.

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RATE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This is used to identify the type of benefit rate in use - the keys, usage, and high-level attributes the govern how a rate behaves.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description