PSSUBDEFN

index back

Subscription Definition

PSSUBDEFN

PeopleSoft Field Name Field Type Column Type Description
MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
SUBNAME Character(30) VARCHAR2(30) NOT NULL Name of a Subscription, which defines which subscription process is invoked when you receive an application message.
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
SUBOWNER Character(30) VARCHAR2(30) NOT NULL Subscription Owner
ACTIONTYPE Character(30) VARCHAR2(30) NOT NULL Action Type
ACTIONNAME Character(30) VARCHAR2(30) NOT NULL Action Name
ACTIONLOCATION Number(1,0) SMALLINT NOT NULL Action Location
SUBTIMEOUTMIN Number(5,0) INTEGER NOT NULL Subscription time-out minutes
PROCESSLOCALPUB Number(1,0) SMALLINT NOT NULL Process Local Publicaiton
RETRYONFAIL Number(1,0) SMALLINT NOT NULL Retry on Failure
SUBSTATUS Number(1,0) SMALLINT NOT NULL Subscription Status
GENSUBPROC Number(1,0) SMALLINT NOT NULL Generate Subscription Process
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.
LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made 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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19