SAE_LIS_PHNMAP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SAE_TARGET_ID	Character(50)	VARCHAR2(50) NOT NULL	SAIP Target ID
2	SAE_PRSN_DEF_FLAG	Character(4)	VARCHAR2(4) NOT NULL	Default Flag D=Default U=User Defined Default Value: U
3	SAE_LIS_PHN_TYPE	Character(4)	VARCHAR2(4) NOT NULL	LIS Contact Info Type FAX=Facsimile FAXH=FacsimileHome FAXW=FacsimileWork MOB=Mobile MOBH=MobileHome MOBW=MobileWork MOHP=MobileHomePrimary MOHS=MobileHomeSecondary MOWP=MobileWorkPrimary MOWS=MobileWorkSecondary PAG=Pager SMS=SMS TELE=Telephone TELH=TelephoneHome TELP=TelephonePrimary TELS=TelephoneSecondary TELW=TelephoneWork TLHP=TelephoneHomePrimary TLHS=TelephoneHomeSecondary TLWP=TelephoneWorkPrimary TLWS=TelephoneWorkSecondary
4	SAE_CS_PHN_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 PRF=Preferred TELX=Telex WORK=Work