PTIAPRJITEMCALC

index back

Project Item Calculation Table

This table is used to calculate MOs in the project

PeopleSoft Field NameField TypeColumn TypeDescription
PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
OBJECTTYPENumber(5,0)INTEGER NOT NULLObject Type
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
PTIASPTAKEACTIONNumber(1,0)SMALLINT NOT NULLTake Upgrade Action
NVSROWNUMNumber(10,0)DECIMAL(10) NOT NULLRow Number
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19