PSDOCLOEVENT_VW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 IBDOCLAYOUTNAME Character(20) VARCHAR2(20) NOT NULL Layout Name (see PSDOCLODEFN).
2 IB_SEQUENCE_NBR Number(3,0) SMALLINT NOT NULL Sequence Number
3 IB_EVENT_TYPE Character(30) VARCHAR2(30) NOT NULL Event Type
4 IB_PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
5 IB_QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified class Path
6 IB_APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
7 IB_MAPCLASSMETHOD Character(60) VARCHAR2(60) NOT NULL App Class Method Name
8 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

Prompt Table: PSPACKAGROOT_VW

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

Prompt Table: PSPACKAGPATH_VW

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

Prompt Table: PSPACKAGCLAS_VW

11 APPCLASSMETHOD Character(60) VARCHAR2(60) NOT NULL Application Class Method Name
12 IB_CUSTOMONLY Number(3,0) SMALLINT NOT NULL Custom Event Only