BN_OTH_RATE_VW (SQL View)	Index Back
Benefit Other Rate Data This table holds components of individual rates per deduction class of Benefits Rate Table ID.

BN_OTH_RATE_VW

(SQL View)

Benefit Other Rate Data

This table holds components of individual rates per deduction class of Benefits Rate Table ID.

SELECT RATE_TBL_ID ,EFFDT ,BN_RATE_KEY01 ,BN_RATE_KEY02 ,BN_RATE_KEY03 ,DED_CLASS ,OTHER_RATE_ID ,OTHER_TAX_RATE FROM PS_BN_OTH_RT_ATX UNION SELECT RATE_TBL_ID ,EFFDT ,BN_RATE_KEY01 ,BN_RATE_KEY02 ,BN_RATE_KEY03 ,DED_CLASS ,OTHER_RATE_ID ,OTHER_TAX_RATE FROM PS_BN_OTH_RT_BTX UNION SELECT RATE_TBL_ID ,EFFDT ,BN_RATE_KEY01 ,BN_RATE_KEY02 ,BN_RATE_KEY03 ,DED_CLASS ,OTHER_RATE_ID ,OTHER_TAX_RATE FROM PS_BN_OTH_RT_NTX UNION SELECT RATE_TBL_ID ,EFFDT ,BN_RATE_KEY01 ,BN_RATE_KEY02 ,BN_RATE_KEY03 ,DED_CLASS ,OTHER_RATE_ID ,OTHER_TAX_RATE FROM PS_BN_OTH_RT_PTX UNION SELECT RATE_TBL_ID ,EFFDT ,BN_RATE_KEY01 ,BN_RATE_KEY02 ,BN_RATE_KEY03 ,DED_CLASS ,OTHER_RATE_ID ,OTHER_TAX_RATE FROM PS_BN_OTH_RT_TTX

Parent record: BN_RATE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RATE_TBL_ID Character(6) VARCHAR2(6) NOT NULL This is used as the record key that identifies a specific set of benefit rates.
Prompt Table: BN_RATE_TBL

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

3 BN_RATE_KEY01 Character(20) VARCHAR2(20) NOT NULL This field is used as a generic key into a benefits rate table. The key can take on different contexts depending on the Rate Type definition associated with the Rate Table.

4 BN_RATE_KEY02 Character(20) VARCHAR2(20) NOT NULL This field is used as a generic key into a benefits rate table. The key can take on different contexts depending on the Rate Type definition associated with the Rate Table.

5 BN_RATE_KEY03 Character(20) VARCHAR2(20) NOT NULL This field is used as a generic key into a benefits rate table. The key can take on different contexts depending on the Rate Type definition associated with the Rate Table.

6 DED_CLASS Character(1) VARCHAR2(1) NOT NULL Deduction Classification
A=After-Tax
B=Before-Tax
L=QC Taxable Benefit
N=Nontaxable Benefit
P=Nontaxable Btax Benefit
T=Taxable Benefit

7 OTHER_RATE_ID Character(4) VARCHAR2(4) NOT NULL This is used as the record key for Other Benefits Rate Data that recategorize rates from parent record Benefit Rate Data.
SSCH=Children - SS Rate
SSEE=Employee - SS Rate
SSSP=Spouse - SS Rate

8 OTHER_TAX_RATE Number(12,5) DECIMAL(11,5) NOT NULL Other Tax Rate can be amount or percentage rate to define rates per Other Rate ID and Deduction Class in Benefits Other Rate Table.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RATE_TBL_ID	Character(6)	VARCHAR2(6) NOT NULL	This is used as the record key that identifies a specific set of benefit rates. Prompt Table: BN_RATE_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	BN_RATE_KEY01	Character(20)	VARCHAR2(20) NOT NULL	This field is used as a generic key into a benefits rate table. The key can take on different contexts depending on the Rate Type definition associated with the Rate Table.
4	BN_RATE_KEY02	Character(20)	VARCHAR2(20) NOT NULL	This field is used as a generic key into a benefits rate table. The key can take on different contexts depending on the Rate Type definition associated with the Rate Table.
5	BN_RATE_KEY03	Character(20)	VARCHAR2(20) NOT NULL	This field is used as a generic key into a benefits rate table. The key can take on different contexts depending on the Rate Type definition associated with the Rate Table.
6	DED_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Deduction Classification A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit
7	OTHER_RATE_ID	Character(4)	VARCHAR2(4) NOT NULL	This is used as the record key for Other Benefits Rate Data that recategorize rates from parent record Benefit Rate Data. SSCH=Children - SS Rate SSEE=Employee - SS Rate SSSP=Spouse - SS Rate
8	OTHER_TAX_RATE	Number(12,5)	DECIMAL(11,5) NOT NULL	Other Tax Rate can be amount or percentage rate to define rates per Other Rate ID and Deduction Class in Benefits Other Rate Table.