GPDE_BV_EE_DTL (SQL Table)	Index Back
Detail BVV Employee Data Detail BVV Employee Data

GPDE_BV_EE_DTL

(SQL Table)

Detail BVV Employee Data

Parent record: GPDE_BV_EE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
Prompt Table: JOB

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

4 GPDE_BV_SINSRNCTYP Character(4) VARCHAR2(4) NOT NULL Supplementary Insurance
AR=Suppl. Pension Insurance
AZV=General Risk Insurance
BR=Risk Insrnc
BRWZ=Risk Insrnc Qualifying Period
DAT=Difference Amount
DZ=DZ - Pens near Suppl.Cntrbtn
FWDA=Voluntary Tariff DA
N=Voluntary/Suppl. Pension
RZV=Suppl. Risk Insurance
ST=Suppl. Insurance - Death Fund
WA=Suppl. Orphan Pension
WI=Suppl. Widow Pension
WIFS=Suppl. Widow Pension/Decrease

5 GPDE_BV_AMT Signed Number(19,2) DECIMAL(17,2) NOT NULL BVV Amount

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: JOB
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	GPDE_BV_SINSRNCTYP	Character(4)	VARCHAR2(4) NOT NULL	Supplementary Insurance AR=Suppl. Pension Insurance AZV=General Risk Insurance BR=Risk Insrnc BRWZ=Risk Insrnc Qualifying Period DAT=Difference Amount DZ=DZ - Pens near Suppl.Cntrbtn FWDA=Voluntary Tariff DA N=Voluntary/Suppl. Pension RZV=Suppl. Risk Insurance ST=Suppl. Insurance - Death Fund WA=Suppl. Orphan Pension WI=Suppl. Widow Pension WIFS=Suppl. Widow Pension/Decrease
5	GPDE_BV_AMT	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	BVV Amount
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code