PTAI_ITEM_ATTR

(SQL Table)
Index Back

Action Items Attributes

Long char attributes, such as Remarks and Resolution Description, for Action Items.

  • Related Language Record: PTAI_ITEMATLNG
  • Parent record: PTAI_ITEM
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTAI_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item ID
    2 PTAI_ATTR_TYPE Character(3) VARCHAR2(3) NOT NULL Action Items - Attribute Name
    CHG=Change Log
    GRT=Grants Log
    REM=Remarks
    3 PTAI_VALUE_LONG Long Character CLOB Action Items - Long Char attribute value