EB_AUD_PHONE

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
3 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
4 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
5 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
6 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
7 PRIMARY_PHONE Character(1) VARCHAR2(1) NOT NULL Primary Phone
8 FS_EVENT_CODE Character(15) VARCHAR2(15) NOT NULL Event code
9 AUDLOG_DTTM DateTime(26) TIMESTAMP Date and time that the event occurred.
10 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
12 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
13 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
14 MESSAGE_TEXT_254 Character(254) VARCHAR2(254) NOT NULL Message Text
15 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text
16 BATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Batch Action
17 PURGE_OPTN Character(1) VARCHAR2(1) NOT NULL Purge History without Archive