BN_JOB_EFDT_VW (SQL View)	Index Back
Annl Benef Base Rate EffDt Vw This is a view of all effective-dated Annual Benefits Base Rates for primary of an employee in JOB.

BN_JOB_EFDT_VW

(SQL View)

Annl Benef Base Rate EffDt Vw

This is a view of all effective-dated Annual Benefits Base Rates for primary of an employee in JOB.

SELECT A.EMPLID , A.EMPL_RCD , 'PRIM' , A.EFFDT , A.ANNL_BENEF_BASE_RT , A.CURRENCY_CD , A.EFFDT FROM PS_JOB A WHERE A.EFFSEQ = ( SELECT MAX(D.EFFSEQ) FROM PS_JOB D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.EFFDT = A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 BN_ANNL_BENBASE_CD Character(4) VARCHAR2(4) NOT NULL Identifies the type of Annual Benefits Base Rate
Prompt Table: ABBR_TYPE_TBL

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

5 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.

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

7 LAST_UPDATE_DATE Date(10) DATE Date of last update

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	BN_ANNL_BENBASE_CD	Character(4)	VARCHAR2(4) NOT NULL	Identifies the type of Annual Benefits Base Rate Prompt Table: ABBR_TYPE_TBL
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	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.
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update