SCR_ADR_PHN_HST

#	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	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
4	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
5	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
6	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
7	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
8	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
9	SCR_EFFDT	Date(10)	DATE	Approved Changes Take Effect
10	EFFDT	Date(10)	DATE	Effective Date
11	SCR_CHG_EFF_WHEN	Character(1)	VARCHAR2(1) NOT NULL	Change Effective I=Approval Date S=Future Date
12	LOCATION_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Location
13	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
14	SCR_COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
15	SCR_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
16	SCR_EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
17	SCR_REMOVE	Character(1)	VARCHAR2(1) NOT NULL	Remove Contact
18	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
19	ENTERED_DTTM	DateTime(26)	TIMESTAMP	Entered Datetime