PTIASPRPTMOLVW

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 FROM PS_PTIASPRPTMOL A , PS_PTIASPINTCODES B WHERE A.OBJECTTYPE = b.PTIASPINTVALUE AND B.PTIASPLOOKUPCODE = 'OBJTYPE'

PeopleSoft Field NameField TypeColumn TypeDescription
PTIASPRPTNONumber(10,0)DECIMAL(10) NOT NULLBUG Number
OBJECTTYPENumber(5,0)INTEGER NOT NULLObject Type
DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
OBJECTID1Number(5,0)INTEGER NOT NULLObject 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
OBJECTVALUE1Character(100)VARCHAR2(100) NOT NULLObject Value 1
OBJECTID2Number(5,0)INTEGER NOT NULLObject Id 2, as OBJECTID1
OBJECTVALUE2Character(100)VARCHAR2(100) NOT NULLObject Value 2
OBJECTID3Number(5,0)INTEGER NOT NULLObject Id 3, as OBJECTID1
OBJECTVALUE3Character(30)VARCHAR2(30) NOT NULLObject Value 3
OBJECTID4Number(5,0)INTEGER NOT NULLObject Id 4, as OBJECTID1
OBJECTVALUE4Character(30)VARCHAR2(30) NOT NULLObject Value 4
UPGRADEACTIONNumber(1,0)SMALLINT NOT NULLUpgrade Action
PTIASPUPGACTIONCharacter(1)VARCHAR2(1) NOT NULLUpgrade Action
0=Copy
1=Delete
2=None
3=Copy Property
PTIASPTAKEACTIONNumber(1,0)SMALLINT NOT NULLTake Upgrade Action
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19