PSDOCLOEVENT_VW

index back

Document Layout Base Event


( SELECT A.IBDOCLAYOUTNAME , IB_SEQUENCE_NBR , A.IB_EVENT_TYPE , A.PACKAGEROOT , A.QUALIFYPATH , A.APPCLASSID , A.APPCLASSMETHOD ,B.IB_PACKAGEROOT ,B.IB_QUALIFYPATH ,B.IB_APPCLASSID ,B.IB_MAPCLASSMETHOD ,B.IB_CUSTOMONLY FROM PSDOCLOBASEVENT A LEFT OUTER JOIN PSDOCLOCUSEVENT B ON A.IBDOCLAYOUTNAME = B.IBDOCLAYOUTNAME) UNION ( SELECT A.IBDOCLAYOUTNAME , IB_SEQUENCE_NBR ,A.IB_EVENT_TYPE , A.PACKAGEROOT , A.QUALIFYPATH , A.APPCLASSID , A.APPCLASSMETHOD ,B.IB_PACKAGEROOT ,B.IB_QUALIFYPATH ,B.IB_APPCLASSID ,B.IB_MAPCLASSMETHOD ,B.IB_CUSTOMONLY FROM PSDOCLOEVENT A LEFT OUTER JOIN PSDOCLOCUSEVENT B ON A.IBDOCLAYOUTNAME = B.IBDOCLAYOUTNAME)

PeopleSoft Field Name Field Type Column Type Description
IBDOCLAYOUTNAME Character(20) VARCHAR2(20) NOT NULL Layout Name (see PSDOCLODEFN).
IB_SEQUENCE_NBR Number(3,0) SMALLINT NOT NULL Sequence Number
IB_EVENT_TYPE Character(30) VARCHAR2(30) NOT NULL Event Type
IB_PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
IB_QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified class Path
IB_APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
IB_MAPCLASSMETHOD Character(60) VARCHAR2(60) NOT NULL App Class Method Name
PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

Prompt Table: PSPACKAGROOT_VW

QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

Prompt Table: PSPACKAGPATH_VW

APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

Prompt Table: PSPACKAGCLAS_VW

APPCLASSMETHOD Character(60) VARCHAR2(60) NOT NULL Application Class Method Name
IB_CUSTOMONLY Number(3,0) SMALLINT NOT NULL Custom Event Only
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20