GVT_SINQPAC_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RUN_DT	Date(10)	DATE	Run Date
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	GVT_NFC_SEQNUM	Number(6,0)	INTEGER NOT NULL	Sequence Number
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Default Value: 0
6	EFFDT	Date(10)	DATE	Effective Date
7	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
8	GVT_SUB_AGENCY	Character(2)	VARCHAR2(2) NOT NULL	Sub-Agency
9	GVT_POI	Character(4)	VARCHAR2(4) NOT NULL	Personnel Office ID
10	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
11	GVT_NFC_DOC_TYPE	Character(3)	VARCHAR2(3) NOT NULL	NFC Document Type
12	GVT_NOA_CODE	Character(3)	VARCHAR2(3) NOT NULL	Nature of Action Code
13	GVT_NFC_AUTHCTN_DT	Date(10)	DATE	Federal NFC Field
14	GVT_STATUS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Status Type CAN=Cancelled COM=Completed COR=Corrected IRR=IRR Reported WIP=Work-in-progress
15	BATCH_NUM	Number(4,0)	SMALLINT NOT NULL	Batch Number
16	GVT_NFC_ERROR_CD	Character(3)	VARCHAR2(3) NOT NULL	Error Code
17	GVT_NFC_ERROR_MSG	Character(100)	VARCHAR2(100) NOT NULL	Error Message
18	GVT_PP_NBR	Number(3,0)	SMALLINT NOT NULL	Pay Period Number
19	GVT_MARK_WORKED	Character(1)	VARCHAR2(1) NOT NULL	Mark as Completed Y/N Table Edit Default Value: N
20	OVERRIDE_BTN	Character(1)	VARCHAR2(1) NOT NULL	Override Y/N Table Edit Default Value: N