GVT_TSP_VCH_DET(SQL Table) |
Index Back |
|---|---|
GVT TSP Voucher Detail Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Default Value: INSTALLATION.COMPANY Prompt Table: COMPANY_TBL |
| 2 | GVT_TSP_SEQ_YR |
Number(2,0) | SMALLINT NOT NULL | TSP Voucher Number |
| 3 | GVT_TSP_SEQ_NO |
Number(4,0) | SMALLINT NOT NULL | Voucher Seq No |
| 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 | GVT_TSP_REC_EE | Number(12,2) | DECIMAL(11,2) NOT NULL | GVT TSP EE Pay Contributions |
| 6 | GVT_TSP_REC_AGY_B | Number(12,2) | DECIMAL(11,2) NOT NULL | Agency Basic |
| 7 | GVT_TSP_REC_AGY_M | Number(12,2) | DECIMAL(11,2) NOT NULL | Agency Matching |
| 8 | GVT_TSP_NEG_EE | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | GVT TSP EE Negative Adjustment |
| 9 | GVT_TSP_NEG_AGY_B | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | GVT TSP Agy Basic Negative Adj |
| 10 | GVT_TSP_NEG_AGY_M | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | GVT TSP Agy Matching Neg Adj |
| 11 | GVT_ROTH_REC_EE | Number(12,2) | DECIMAL(11,2) NOT NULL | EE ROTH contribution. |
| 12 | GVT_ROTH_NEG_EE | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Negative adjustment for EE ROTH contribution. |