PTIASPRPTMOLVW

(SQL View)
 Index Back

BUG MOL

This is the modified object list for each BUG

SELECT A.PTIASPRPTNO , A.OBJECTTYPE , B.DESCR254 , A.OBJECTID1 , A.OBJECTVALUE1 , A.OBJECTID2 , A.OBJECTVALUE2 , A.OBJECTID3 , A.OBJECTVALUE3 , A.OBJECTID4 , A.OBJECTVALUE4 , A.UPGRADEACTION , A.PTIASPUPGACTION , A.PTIASPTAKEACTION , %coalesce (C.PTIACUSTVALUE , 0 ) , %coalesce(C.PTIACUSTOMIZATION , ' ') , %coalesce(D.PTIAUMISUSED , 'N') FROM PS_PTIASPRPTMOL A , PS_PTIASPINTCODES B , PS_PTIAMOCUSTREPO C , PS_PTIAUMPMTAGR D WHERE A.OBJECTTYPE = B.PTIASPINTVALUE AND B.PTIASPLOOKUPCODE = 'OBJTYPE' AND A.OBJECTTYPE = C.OBJECTTYPE (+) AND A.OBJECTVALUE1 = C.OBJECTVALUE1(+) AND A.OBJECTVALUE2 = C.OBJECTVALUE2 (+) AND A.OBJECTVALUE3 = C.OBJECTVALUE3 (+) AND A.OBJECTVALUE4 = C.OBJECTVALUE4(+) AND A.OBJECTTYPE = D.OBJECTTYPE (+) AND A.OBJECTVALUE1 = D.OBJECTVALUE1(+) AND A.OBJECTVALUE2 = D.OBJECTVALUE2(+) AND A.OBJECTVALUE3 = D.OBJECTVALUE3(+) AND A.OBJECTVALUE4 = D.OBJECTVALUE4(+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
2 OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
4 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
5 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
6 OBJECTID2 Number(5,0) INTEGER NOT NULL Object Id 2, as OBJECTID1
7 OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
8 OBJECTID3 Number(5,0) INTEGER NOT NULL Object Id 3, as OBJECTID1
9 OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
10 OBJECTID4 Number(5,0) INTEGER NOT NULL Object Id 4, as OBJECTID1
11 OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
12 UPGRADEACTION Number(1,0) SMALLINT NOT NULL Upgrade Action
13 PTIASPUPGACTION Character(1) VARCHAR2(1) NOT NULL Upgrade Action
0=Copy
1=Delete
2=None
3=Copy Property
14 PTIASPTAKEACTION Number(1,0) SMALLINT NOT NULL Take Upgrade Action
15 PTIA_COUNTER Number(10,0) DECIMAL(10) NOT NULL Customization Count
16 PTIACUSTOMIZATION Character(4) VARCHAR2(4) NOT NULL Customization
N== PPLSOFT
U=Unknown
Y=<> PPLSOFT
17 PTIASPRPTUSAGEFLAG Character(1) VARCHAR2(1) NOT NULL Is Used
N=Not Used
Y=Used