GPIN_NPS_BENEF (SQL Table)	Index Back
NPS beneficiary names This record stores the information related to Benificiary detials and there individual percent benifits.

GPIN_NPS_BENEF

(SQL Table)

NPS beneficiary names

This record stores the information related to Benificiary detials and there individual percent benifits.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default
Prompt Table: DEPENDENT_VW
Set Control Field: NAME

4 BENEF_PCT Number(3,0) SMALLINT NOT NULL Percent Beneficiary Paid

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default Prompt Table: DEPENDENT_VW Set Control Field: NAME
4	BENEF_PCT	Number(3,0)	SMALLINT NOT NULL	Percent Beneficiary Paid