PSPROJECTITEM

index back

Project Item Table


  • Parent record: PSPROJECTDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
    OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
    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
    OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
    OBJECTID2 Number(5,0) INTEGER NOT NULL Object Id 2, as OBJECTID1
    OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
    OBJECTID3 Number(5,0) INTEGER NOT NULL Object Id 3, as OBJECTID1
    OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
    OBJECTID4 Number(5,0) INTEGER NOT NULL Object Id 4, as OBJECTID1
    OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
    NODETYPE Number(5,0) INTEGER NOT NULL Node Type
    SOURCESTATUS Number(1,0) SMALLINT NOT NULL Source Status
    TARGETSTATUS Number(1,0) SMALLINT NOT NULL Target Status
    UPGRADEACTION Number(1,0) SMALLINT NOT NULL Upgrade Action
    TAKEACTION Number(1,0) SMALLINT NOT NULL Take Action
    COPYDONE Number(1,0) SMALLINT NOT NULL Copy Done
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19