PSAPMSGARCHTMP3

(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 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
2 IB_PUBSTATUS Number(2,0) SMALLINT NOT NULL Publication Status
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.