PTIASPRPTPMOLVW

index back

PACKAGE MOL

This is the modified object list for all bugs in PACKAGE
SELECT A.PROJECTNAME , A.OBJECTTYPE , B.DESCR254 , A.OBJECTID1 , A.OBJECTVALUE1 , A.OBJECTID2 , A.OBJECTVALUE2 , A.OBJECTID3 , A.OBJECTVALUE3 , A.OBJECTID4 , A.OBJECTVALUE4 , %NumToChar(A.UPGRADEACTION) AS PTIASPUPGACTION , A.TAKEACTION AS PTIASPTAKEACTION FROM PSPROJECTITEM A , PS_PTIASPINTCODES B , PS_PTIASPPKGS C WHERE A.OBJECTTYPE = B.PTIASPINTVALUE AND A.PROJECTNAME = C.PTIASPPKGNAME AND B.PTIASPLOOKUPCODE = 'OBJTYPE'

PeopleSoft Field Name Field Type Column Type Description
PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
OBJECTID1 Number(5,0) INTEGER NOT NULL Object Id 1
1=Record
2=Field
3=Menu
4=Bar Name
5=Item Name
9=Page
10=Component
12=Event
20=Database Type
21=Effective Date
39=Market
60=Message
66=Application Engine Program
74=Component Interface
77=Section
78=Step
87=Subscription
104=Application Package
105=Class
106=Class
107=Class
OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
OBJECTID2 Number(5,0) INTEGER NOT NULL Object Id 2, as OBJECTID1
OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
OBJECTID3 Number(5,0) INTEGER NOT NULL Object Id 3, as OBJECTID1
OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
OBJECTID4 Number(5,0) INTEGER NOT NULL Object Id 4, as OBJECTID1
OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
PTIASPUPGACTION Character(1) VARCHAR2(1) NOT NULL Upgrade Action
0=Copy
1=Delete
2=None
3=Copy Property
PTIASPTAKEACTION Number(1,0) SMALLINT NOT NULL Take Upgrade Action
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19