SCR_CNT_PHN_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	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
4	SCR_EFFDT	Date(10)	DATE	Approved Changes Take Effect
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type BUSN=Business Phone CAMP=Campus Phone CELL=Cellular Phone DORM=Dormitory Phone FAX=FAX HOME=Home Phone MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex Default Value: BUSN
7	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
8	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
9	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
10	SCR_PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type BUSN=Business Phone CAMP=Campus Phone CELL=Cellular Phone DORM=Dormitory Phone FAX=FAX HOME=Home Phone MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex
11	SCR_COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
12	SCR_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
13	SCR_EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
14	SCR_CHG_EFF_WHEN	Character(1)	VARCHAR2(1) NOT NULL	Change Effective I=Approval Date S=Future Date
15	SCR_CHNG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Request for Change Type A=Add D=Delete I=Inactivate U=Update
16	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
17	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
18	ERR_MSG_NBR	Number(5,0)	INTEGER NOT NULL	Service Purchase Error Number
19	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning
20	DESCR30	Character(30)	VARCHAR2(30) NOT NULL	Description
21	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
22	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
23	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
24	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.