SCR_GVCT_DFT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCR_ID	Character(15)	VARCHAR2(15) NOT NULL	Supplier Change Request ID
2	SCR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Update Sequence Number
3	CERTIF_SOURCE	Character(10)	VARCHAR2(10) NOT NULL	Certification Source Prompt Table: GOV_CERTSRC_VW Set Control Field: SETID
4	GOV_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Government Classification Prompt Table: GOV_CERT_TBL Set Control Field: SETID
5	EFFDT	Date(10)	DATE	Effective Date
6	SCR_EFFDT	Date(10)	DATE	Approved Changes Take Effect
7	SCR_CHG_EFF_WHEN	Character(1)	VARCHAR2(1) NOT NULL	Change Effective I=Approval Date S=Future Date
8	SCR_CHNG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Request for Change Type A=Add D=Delete I=Inactivate U=Update
9	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
10	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
11	GOV_CERTIF_NBR	Character(50)	VARCHAR2(50) NOT NULL	Certification Number
12	CERTIFICATE_EXP_DT	Date(10)	DATE	Certificate Expiration
13	CERTIFICATE_BEG_DT	Date(10)	DATE	Certificate Begin Date
14	SCR_CERTIF_SOURCE	Character(10)	VARCHAR2(10) NOT NULL	Certification Source
15	SCR_GOV_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Government Classification
16	SCR_REMOVE	Character(1)	VARCHAR2(1) NOT NULL	Remove Contact
17	ERR_MSG_NBR	Number(5,0)	INTEGER NOT NULL	Service Purchase Error Number
18	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning
19	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
20	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
21	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
22	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.