PSAPMSGARCHTMP4

(SQL Table)
Index Back

App Message Archive Temp

This is a table used by the App Messaging Archive process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
2 TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
3 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
C=C
N=N
Y=Y

Default Value: N

4 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.