PSMAPFIELD

(SQL Table)
Index Back

Map Field

# 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 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
3 MAPTYPE Number(5,0) INTEGER NOT NULL Mapping Type
4 MAPNAME Character(30) VARCHAR2(30) NOT NULL Map Name
5 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
6 FORMFIELDNAME Character(30) VARCHAR2(30) NOT NULL Form Field Name
7 RECFIELDNUM Number(5,0) INTEGER NOT NULL Record Field Number
8 EXPNUM Number(3,0) SMALLINT NOT NULL Expression Number
9 ROLENUM Number(5,0) INTEGER NOT NULL Role Number
10 MAPUSE Number(5,0) INTEGER NOT NULL Mapping Use
11 MAPMETHOD Number(5,0) INTEGER NOT NULL Mapping Method