PROJECTITEM_TAO

(SQL Table)
 Index Back

Project Item Table

Temporary table used to create a New Project based on the contents of an existing Project. Used in CF Configuration to create a new project that will be used in an upgrade CF Configuration extracting the objects used in CF configuration from the Upgrade Compare Projects

  • Parent record: PSPROJECTDEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
    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 NODETYPE Number(5,0) INTEGER NOT NULL Node Type
    13 SOURCESTATUS Number(1,0) SMALLINT NOT NULL Source Status
    14 TARGETSTATUS Number(1,0) SMALLINT NOT NULL Target Status
    15 UPGRADEACTION Number(1,0) SMALLINT NOT NULL Upgrade Action
    16 TAKEACTION Number(1,0) SMALLINT NOT NULL Take Action
    17 COPYDONE Number(1,0) SMALLINT NOT NULL Copy Done