PTIAMDPRJDT_STG

(SQL Table)
 Index Back

Project Item Table

  • Parent record: PSPROJECTDEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
    2 OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
    3 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
    4 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
    5 OBJECTID2 Number(5,0) INTEGER NOT NULL Object Id 2, as OBJECTID1
    6 OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
    7 OBJECTID3 Number(5,0) INTEGER NOT NULL Object Id 3, as OBJECTID1
    8 OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
    9 OBJECTID4 Number(5,0) INTEGER NOT NULL Object Id 4, as OBJECTID1
    10 OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
    11 NODETYPE Number(5,0) INTEGER NOT NULL Node Type
    12 SOURCESTATUS Number(1,0) SMALLINT NOT NULL Source Status
    13 TARGETSTATUS Number(1,0) SMALLINT NOT NULL Target Status
    14 UPGRADEACTION Number(1,0) SMALLINT NOT NULL Upgrade Action
    15 TAKEACTION Number(1,0) SMALLINT NOT NULL Take Action
    16 COPYDONE Number(1,0) SMALLINT NOT NULL Copy Done
    17 PTIACUSTOMIZATION Character(4) VARCHAR2(4) NOT NULL Customization
    N== PPLSOFT
    U=Unknown
    Y=<> PPLSOFT