PSMSGAGTDEFN

(SQL Table)
Index Back

Message Agent Definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
2 INPUTNAME Character(30) VARCHAR2(30) NOT NULL Input Name
3 REPLYOK Number(5,0) INTEGER NOT NULL Reply OK
4 REPLYERR Number(5,0) INTEGER NOT NULL Reply Error
5 SRCTYPE Number(5,0) INTEGER NOT NULL Source Type
6 VERIFYORIGID Number(5,0) INTEGER NOT NULL Verify Originator ID
7 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
8 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
9 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
10 DFLTACTION Number(5,0) INTEGER NOT NULL Default srch action-internet
11 SEARCHRECNAME Character(15) VARCHAR2(15) NOT NULL Search Record Name
12 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
13 MAPFIELDCNT Number(5,0) INTEGER NOT NULL Mapping Field Count
14 MAPEXPRCNT Number(5,0) INTEGER NOT NULL Mapping Expression Count
15 MAPRECFIELDCNT Number(5,0) INTEGER NOT NULL Mapping Record Field Count
16 MAPROLENAMECNT Number(5,0) INTEGER NOT NULL Mapping Role Name Count
17 MAPLEVELCNT Number(5,0) INTEGER NOT NULL Mapping Level Count