PTIASPINTPKGMOL

(SQL Table)
Index Back

Objs to Include INT Package

This contains additional objects to include in an INT change package

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
2 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
3 OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
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

Default Value: 0

14 PTIASPTAKEACTION Number(1,0) SMALLINT NOT NULL Take Upgrade Action

Default Value: 1

15 PTIASPMOLSTATUS Character(1) VARCHAR2(1) NOT NULL Managed Object Status

Default Value: N