UPG_FED_RET_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	EFFDT	Date(10)	DATE	Effective Date
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	GVT_AWD_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Award Classification A=Award B=Bonus
7	OTH_PAY	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Other Pay
8	OTH_HRS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Other Hours
9	GOAL_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Goal Amount
10	EARNINGS_END_DT	Date(10)	DATE	Earnings End Date
11	GVT_USE_BY_DATE	Date(10)	DATE	Use By Date
12	GVT_AWARD_GROUP	Character(4)	VARCHAR2(4) NOT NULL	Award Group
13	GVT_TANG_BEN_AMT	Number(8,0)	INTEGER NOT NULL	Tangible Benefit
14	GVT_INTANG_BEN_AMT	Number(8,0)	INTEGER NOT NULL	Intangible Benefit
15	GVT_SUGGESTION_NBR	Character(10)	VARCHAR2(10) NOT NULL	Suggestion Number
16	GVT_OBLIG_EXPIR_DT	Date(10)	DATE	Obligation Expiration
17	GL_PAY_TYPE	Character(6)	VARCHAR2(6) NOT NULL	General Ledger Pay Type
18	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
19	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
20	GVT_SEPCHK_IND	Character(1)	VARCHAR2(1) NOT NULL	Pay in Separate Paycheck?
21	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate check number.
22	DED_TAKEN	Character(1)	VARCHAR2(1) NOT NULL	Deductions Taken D=Deduction Table Governs N=None R=No Override S=Deduction Table Subset Governs
23	DED_TAKEN_GENL	Character(1)	VARCHAR2(1) NOT NULL	General Deductions Taken D=Deduction Table Governs N=None R=No Override S=Deduction Table Subset Governs
24	DISABLE_DIR_DEP	Character(1)	VARCHAR2(1) NOT NULL	Disable Direct Deposit
25	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross-Up
26	ADDL_SEQ	Number(2,0)	SMALLINT NOT NULL	Additional Pay Sequence Number
27	COMMENTS	Long Character	CLOB	Comment
28	GVT_AWD_CODE	Character(4)	VARCHAR2(4) NOT NULL	Federal field for Award data
29	FROM_DT	Date(10)	DATE	From Date
30	TO_DATE	Date(10)	DATE	Latest Date to be sent to PYR
31	GVT_GENERT_PAYMENT	Character(1)	VARCHAR2(1) NOT NULL	Federal field for Award data
32	GVT_CHK_MAILAD_IND	Character(1)	VARCHAR2(1) NOT NULL	Federal field for Award data 1=Submitting Office 2=Check Mail Address 3=Specified Address 4=Designated Agent
33	GVT_DATE_WRK	Date(10)	DATE	Action Taken
34	GVT_TRK_SEQUENCE	Number(2,0)	SMALLINT NOT NULL	WIP Sequence Number
35	GVT_EE_TRK_DT	Date(10)	DATE	10/2000: Represents the date the record was added to EE_DATA_TRK. Exactly the same as GVT_DATE_WRK except that it is cannot be modified by the user in the Data Tracking panel.. This field was originally created and added to the GVT_EE_DATA_TRK record to support CPDF Dynamic Processing. Used to assure that an action is sent to the CPDF during the appropriate processing window.
36	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
37	GVT_WIP_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Work-in-Progress Status
38	DEPENDENT_ID	Character(2)	VARCHAR2(2) NOT NULL	Dependent ID
39	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
40	CITIZENSHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Citizenship Status
41	GVT_SUB_AGENCY	Character(2)	VARCHAR2(2) NOT NULL	Sub-Agency
42	GVT_NFC_RELBON_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Federal NFC Field
43	GVT_OPRID_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Operator Emplid
44	GVT_TRK_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Emplid of Tracking Row
45	GVT_TRK_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rec# of Tracking Row
46	GVT_NFC_RECBON_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Federal NFC Field
47	PERCENT_OF_AWARD	Number(6,2)	DECIMAL(5,2) NOT NULL	Percent of Award