GVT_SINQPMS_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	GVT_NFC_ACTN_TYPE	Character(4)	VARCHAR2(4) NOT NULL	NFC PMSO SINQ Action Type INDV=Position Action MSTR=Jobcode Action
5	GVT_NFC_FNCTN_CD	Character(10)	VARCHAR2(10) NOT NULL	Function Code
6	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
7	GVT_SUB_AGENCY	Character(2)	VARCHAR2(2) NOT NULL	Sub-Agency
8	GVT_POI	Character(4)	VARCHAR2(4) NOT NULL	Personnel Office ID
9	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
10	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
11	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
12	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
13	EFFDT	Date(10)	DATE	Effective Date
14	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
15	SSN1	Character(9)	VARCHAR2(9) NOT NULL	SSN
16	GVT_PP_NBR	Number(3,0)	SMALLINT NOT NULL	Pay Period Number
17	GVT_NFC_PASS_NO	Character(2)	VARCHAR2(2) NOT NULL	NFC Processing Sequence
18	GVT_NFC_ERROR_CD	Character(3)	VARCHAR2(3) NOT NULL	Error Code
19	GVT_NFC_ERROR_MSG	Character(100)	VARCHAR2(100) NOT NULL	Error Message
20	GVT_ELEMNTNM_NUM	Character(3)	VARCHAR2(3) NOT NULL	NFC Element No
21	GVT_ELEMNT_NAME	Character(30)	VARCHAR2(30) NOT NULL	NFC Element Name
22	GVT_NFC_DATA_FLD	Character(8)	VARCHAR2(8) NOT NULL	NFC PMSO Element Content
23	GVT_MARK_WORKED	Character(1)	VARCHAR2(1) NOT NULL	Mark as Completed Y/N Table Edit Default Value: N
24	OVERRIDE_BTN	Character(1)	VARCHAR2(1) NOT NULL	Override Y/N Table Edit Default Value: N