EMPLIDPrompt Table: PERSON
EMPL_RCDPrompt Table: PER_ORG_ASGN_VW
EFFDTINVESTMENT_OPTC=Common Stock - C Fund
F=Thrift Savings Plan - F Fund
G=Thrift Savings Plan - G Fund
I=Thrift Savings Plan - I Fund
S=Thrift Savings Plan - S Fund
GVT_TSP_INV_DTA(SQL Table) |
Index Back |
|---|---|
TSP Investments ChoicesSAVINGS_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%. |
| # | 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 |
| 4 | INVESTMENT_OPT |
Character(6) | VARCHAR2(6) NOT NULL |
Investment Option
C=Common Stock - C Fund F=Thrift Savings Plan - F Fund G=Thrift Savings Plan - G Fund I=Thrift Savings Plan - I Fund S=Thrift Savings Plan - S Fund |
| 5 | INVESTMENT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Investment Percent |