PSACTIVITYDEFN

(SQL Table)
Index Back

Activity Description

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

  • Related Language Record: PSACTIVITYLANG
  • Parent record: PSBUSPROCDEFN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    3 ACTVALID Number(5,0) INTEGER NOT NULL Valid
    4 HELPCONTEXTNUM Number(10,0) DECIMAL(10) NOT NULL Help Context Number
    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    6 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    7 FONT Character(80) VARCHAR2(80) NOT NULL Font Name
    8 AUTO_SEQ Number(2,0) SMALLINT NOT NULL auto sequencing flag
    9 ICENABLED Number(2,0) SMALLINT NOT NULL Internet Client Enabled
    10 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.
    11 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.
    12 DESCRLONG Long Character CLOB Long Description