PSBUSPROCDEFN

(SQL Table)
Index Back

Business Process Definition

*** IMPORTANT *** please remove HELPCONTEXTNUM and make corresponding code changes with next required table alteration.

  • Related Language Record: PSBUSPROCLANG
  • Parent Record Of PSACTIVIMGLANG PSACTIVITYDEFN PSACTIVITYDEL PSACTIVITYLANG PSBUSPRIMG PSEVENTDEFN PSWORKLIST PSWORKLIST_HST
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    3 NAVIGATORBP Number(5,0) INTEGER NOT NULL Navigator Business Process
    4 HOMEPAGE Number(3,0) SMALLINT NOT NULL Home page enabled
    5 HELPCONTEXTNUM Number(10,0) DECIMAL(10) NOT NULL Help Context Number
    6 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    7 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    8 FONT Character(80) VARCHAR2(80) NOT NULL Font Name
    9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    10 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    11 DESCRLONG Long Character CLOB Long Description