PSAPMSGARCHTMP3 - App Message Archive Temp - PeopleTools Table Reference

PSAPMSGARCHTMP3	index back
App Message Archive Temp

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

PeopleSoft Field Name Field Type Column Type Description

IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID

IB_PUBSTATUS Number(2,0) SMALLINT NOT NULL Publication Status

SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes
Default: N

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.

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

PeopleSoft Field Name	Field Type	Column Type	Description
IBTRANSACTIONID	Character(36)	VARCHAR2(36) NOT NULL	Transaction ID
IB_PUBSTATUS	Number(2,0)	SMALLINT NOT NULL	Publication Status
SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes Default: N
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.