GVT_TSP_INV_EFF (SQL Table)	Index Back
TSP Investments Effective Date SAVINGS_INVEST is a record that defines an employee's investment option and percentage within an enrolled savings plan. It is populated in the Base benefits system using the Savings Plans 2 panel. There can be multiple investment records per savings plan, although the total of all investment percentages must be 100%.

GVT_TSP_INV_EFF

(SQL Table)

TSP Investments Effective Date

SAVINGS_INVEST is a record that defines an employee's investment option and percentage within an enrolled savings plan. It is populated in the Base benefits system using the Savings Plans 2 panel. There can be multiple investment records per savings plan, although the total of all investment percentages must be 100%.

Parent record: SAVINGS_PLAN

# 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: PER_ORG_ASGN_VW

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

4 GVT_INPUT_SOURCE Character(1) VARCHAR2(1) NOT NULL Input Source
A=Benefits Administration
B=Base Benefits
U=User Input
Default Value: U

#	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: PER_ORG_ASGN_VW
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	GVT_INPUT_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Input Source A=Benefits Administration B=Base Benefits U=User Input Default Value: U