GVT_TSP_01_HIST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
4	BIRTHDATE	Date(10)	DATE	Date of Birth
5	PAY_END_DT	Date(10)	DATE	Pay Period End Date
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
7	GVT_TSP_SSNPRV	Character(9)	VARCHAR2(9) NOT NULL	Previous SSN
8	GVT_TSP_DOBERR	Date(10)	DATE	DOBERR
9	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
10	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
11	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
12	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
13	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
14	ZIP	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
15	GVT_TSP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	TSP Status
16	STATUS_DT	Date(10)	DATE	Status Date
17	GVT_AGY_TSP_ID	Character(2)	VARCHAR2(2) NOT NULL	Agency TSP ID
18	GVT_SUB_AGENCY	Character(2)	VARCHAR2(2) NOT NULL	Sub-Agency
19	GVT_POI	Character(4)	VARCHAR2(4) NOT NULL	Personnel Office ID
20	GVT_AGY_LOC_CODE	Character(8)	VARCHAR2(8) NOT NULL	Agency Location Code
21	GVT_SCD_TSP	Date(10)	DATE	Service Comp Date - TSP
22	GVT_TSP_VEST	Number(1,0)	SMALLINT NOT NULL	Vest
23	GVT_RETIRE_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Retirement Plan
24	GVT_TSP_SEPCODE	Character(1)	VARCHAR2(1) NOT NULL	Sep Code
25	GVT_TSP_SEPDATE	Date(10)	DATE	Sep Date
26	GVT_TSP_DEPTPRV	Character(2)	VARCHAR2(2) NOT NULL	Dept Previous
27	GVT_TSP_AGYPRV	Character(2)	VARCHAR2(2) NOT NULL	Previous Agency