PTIAPCMNAME

(SQL Table)
Index Back

PeopleCode Reference Shadow

This is a PeopleCode References Shadow Table used for 3Way Merge feature in Change Assistant.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
3 OBJECTID2 Number(5,0) INTEGER NOT NULL Object Id 2, as OBJECTID1
4 OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
5 OBJECTID3 Number(5,0) INTEGER NOT NULL Object Id 3, as OBJECTID1
6 OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
7 OBJECTID4 Number(5,0) INTEGER NOT NULL Object Id 4, as OBJECTID1
8 OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
9 OBJECTID5 Number(5,0) INTEGER NOT NULL Object Id 5, as OBJECTID1
10 OBJECTVALUE5 Character(30) VARCHAR2(30) NOT NULL Object Value 5
11 OBJECTID6 Number(5,0) INTEGER NOT NULL Object Id 6, as OBJECTID1
12 OBJECTVALUE6 Character(30) VARCHAR2(30) NOT NULL Object Value 6
13 OBJECTID7 Number(5,0) INTEGER NOT NULL Object Id 7, as OBJECTID1
14 OBJECTVALUE7 Character(30) VARCHAR2(30) NOT NULL Object Value 7
15 NAMENUM Number(4,0) SMALLINT NOT NULL Name Number
16 PTMRGOBJVER Character(30) VARCHAR2(30) NOT NULL This field is to keep the version of shadow table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.
17 OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
18 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
19 REFNAME Character(30) VARCHAR2(30) NOT NULL PeopleCode Reference Name
20 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
21 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
22 APPCLASSMETHOD Character(60) VARCHAR2(60) NOT NULL Application Class Method Name