PSMSGPARTS

(SQL Table)
Index Back

Message Parts

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
2 APMSGVER Character(30) VARCHAR2(30) NOT NULL Message Version
3 IB_MSGNAME Character(30) VARCHAR2(30) NOT NULL Message Name
4 IB_MSGVERSION Character(30) VARCHAR2(30) NOT NULL Message Version
5 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
6 IB_SCHEMAMIN Signed Number(8,0) DECIMAL(7) NOT NULL Minimum Occurs
7 IB_SCHEMAMAX Signed Number(8,0) DECIMAL(7) NOT NULL Maximum Occurs

Default Value: 1

8 IB_ROOTELEMENT Character(50) VARCHAR2(50) NOT NULL Root Element