GVT_PAY_TSP (SQL Table)	Index Back
GVT PAY TSP Distribution This table contains TSP deduction information created during the payroll calculation process. A separate record will be created for each TSP deduction code and TSP deduction class per emplooyee.

GVT_PAY_TSP

(SQL Table)

GVT PAY TSP Distribution

This table contains TSP deduction information created during the payroll calculation process. A separate record will be created for each TSP deduction code and TSP deduction class per emplooyee.

Parent record: PAY_DEDUCTION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
Prompt Table: PAYGROUP_TBL

3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
Prompt Table: PAY_CALENDAR

4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
Y/N Table Edit

5 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr

6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr

7 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.

8 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.

9 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
Prompt Table: BEN_PROG_BENPLN

10 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
Prompt Table: BEN_PROG_BENDED

11 DED_CLASS Character(1) VARCHAR2(1) NOT NULL Deduction Classification
A=After-Tax
B=Before-Tax
L=QC Taxable Benefit
N=Nontaxable Benefit
P=Nontaxable Btax Benefit
T=Taxable Benefit

12 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

13 GVT_TSP_TRANS_CD Character(1) VARCHAR2(1) NOT NULL GVT TSP Transaction Code
D=TSP DATA Record
L=TSP LATE Payment
N=TSP Negative Adjustment
P=TSP Current Payment

14 INVESTMENT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Investment Percent

15 DED_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Deduction

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
3	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Prompt Table: PAY_CALENDAR
4	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit
5	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
6	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
7	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
8	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
9	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan Prompt Table: BEN_PROG_BENPLN
10	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code Prompt Table: BEN_PROG_BENDED
11	DED_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Deduction Classification A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit
12	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
13	GVT_TSP_TRANS_CD	Character(1)	VARCHAR2(1) NOT NULL	GVT TSP Transaction Code D=TSP DATA Record L=TSP LATE Payment N=TSP Negative Adjustment P=TSP Current Payment
14	INVESTMENT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Investment Percent
15	DED_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Deduction