BN_ABBR_WK (SQL Table)	Index Back
Used for managing Salary Cache This work record is used as the basis for managing a cache of job/salary information for benefit cost calculations. This work record is intended for use in association with SQL BN_CACHE_ABBR.

BN_ABBR_WK

(SQL Table)

Used for managing Salary Cache

This work record is used as the basis for managing a cache of job/salary information for benefit cost calculations. This work record is intended for use in association with SQL BN_CACHE_ABBR.

Parent record: JOB

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

2 BN_ANNL_BENBASE_CD Character(4) VARCHAR2(4) NOT NULL Identifies the type of Annual Benefits Base Rate

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 ANNL_BENEF_BASE_RT Number(19,3) DECIMAL(18,3) NOT NULL Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
2	BN_ANNL_BENBASE_CD	Character(4)	VARCHAR2(4) NOT NULL	Identifies the type of Annual Benefits Base Rate
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	ANNL_BENEF_BASE_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.