| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
PHONE_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
TELX=Telex
WORK=Work
|
| 3 |
ADDR_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Address Usage
|
| 4 |
SAE_TARGET_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
SAIP Target ID
|
| 5 |
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
|
| 6 |
SAE_LIS_PHN_LNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
LIS Phone
|
| 7 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 8 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 9 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone number extension
|
| 10 |
PREF_PHONE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred
|
| 11 |
SAE_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Operation Mode
A=Add
C=Change
D=Delete
|