PO_HDR_STG_PHN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: PO_HDR_STG.BUSINESS_UNIT
3	PO_STG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Used in conjunction with PO_STG_ID to make a unique key on the stage tables. O=Other R=Requisition Default Value: O
4	PO_STG_ID	Character(10)	VARCHAR2(10) NOT NULL	Uniqye key to the PO Staging table
5	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
6	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
7	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
8	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
9	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Prompt Table: PO_HDR_VW1