BN_OTH_RT_TTX

(SQL Table)
Index Back

Ben Other After Tax Rate View

# 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

Default Value: T

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.