PTAI_LIST

index back

Action Items Lists

Action Items Lists

  • Related language record: PTAI_LIST_LNG
  • PeopleSoft Field Name Field Type Column Type Description
    PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    PTAI_LABEL Character(100) VARCHAR2(100) NOT NULL Action Items - Label
    PTAI_DESCRLONG Long Character CLOB Action Items - Long Description
    PTAI_NOTIFY_TYPE Character(1) VARCHAR2(1) NOT NULL When this option is on, item assignments get email notification after process is success/error/no success. This field is used only for process type action items.
    A=Automatically Send Email
    N=Do Nothing - No Email Sent
    P=Prompt User to Send Email
    PTAI_AGRENDERTYPE Character(4) VARCHAR2(4) NOT NULL Activity Guide type - Vertical or Horizontal
    HOGP=Horizontal
    NONS=Non Optimized Non Sequential
    NOSP=Non Optimized Sequential
    SNNO=Simple Navigation NonOptimized
    SNOP=Simple Navigation Optimized
    VNSP=Vertical Non Sequential
    VSGP=Vertical Sequential

    Default: NONS

    PTAI_RESTARTAG Character(1) VARCHAR2(1) NOT NULL Restart Activity Guide on revisit

    Y/N Table Edit

    Default: N

    PTAI_SUOW Character(1) VARCHAR2(1) NOT NULL Single Unit of Work

    Y/N Table Edit

    Default: N

    PTAI_ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Action Item Active Flag
    N=Display Inactive Lists
    Y=Display Active Lists

    Y/N Table Edit

    CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
    CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    LAST_UPDATE_DTTM 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.
    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.
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    PTAI_IS_TMPL Character(1) VARCHAR2(1) NOT NULL Template
    N=No
    Y=Yes
    PTAI_PARENT_TMPL Character(31) VARCHAR2(31) NOT NULL Template ID
    PTAI_LIST_STATUS Character(2) VARCHAR2(2) NOT NULL Status
    CA=Cancelled
    CP=Complete
    IP=In Progress
    PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
    QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
    APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    APPCLASSMETHOD Character(60) VARCHAR2(60) NOT NULL Application Class Method Name
    PTAI_INST_PKGROOT Character(30) VARCHAR2(30) NOT NULL Package Name
    PTAI_INST_QUALPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
    PTAI_INST_CLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    PTAI_REOPEN_ITEM Character(1) VARCHAR2(1) NOT NULL Allow Item Reopen
    N=No
    Y=Yes
    PTAI_PGLT_EXCL Character(1) VARCHAR2(1) NOT NULL Include In My List Pagelet
    N=No
    Y=Yes
    PTAI_FIELD1_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 1
    PTAI_FIELD2_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 2
    PTAI_FIELD3_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 3
    PTAI_FIELD4_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 4
    PTAI_FIELD5_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 5
    PTAI_FIELD6_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 1
    PTAI_FIELD7_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 2
    PTAI_FIELD8_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 3
    PTAI_FIELD9_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 4
    PTAI_FIELD10_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 5
    PTAI_PGLT_EXIT Character(1) VARCHAR2(1) NOT NULL Pagelet Exit
    N=No
    Y=Yes
    PTAI_PREPROC_METH Character(60) VARCHAR2(60) NOT NULL Pre Process Method
    PTAI_PGLT_SAVE Character(1) VARCHAR2(1) NOT NULL Pagelet Save
    N=No
    Y=Yes
    PTAI_INST_PROC Character(1) VARCHAR2(1) NOT NULL Instance Processing
    N=No
    Y=Yes
    PTAI_PBVISIBLE Character(1) VARCHAR2(1) NOT NULL Pagelet Progress Bar Visible

    Y/N Table Edit

    Default: Y

    PTAI_START_DT Date(10) DATE Start Date
    PTAI_DUE_DATE Date(10) DATE Action Items - Due Date
    PTAI_GPDS_ID Character(30) VARCHAR2(30) NOT NULL Activity Guide Datasource ID

    Default: PTAI_ACTIVITYGUIDE

    PTAI_SINGLECOMPAG Character(1) VARCHAR2(1) NOT NULL Activity Guide is a single component

    Y/N Table Edit

    Default: N

    PTAI_FIXEDSIDEPNL Character(1) VARCHAR2(1) NOT NULL Side panel fixed

    Y/N Table Edit

    Default: Y

    PTAI_SHOWFLNOTIFY Character(1) VARCHAR2(1) NOT NULL Show Notifications

    Y/N Table Edit

    Default: Y

    PTAI_QUESTIONNAIRE Character(1) VARCHAR2(1) NOT NULL When this option is checked, Questionnaire tab will be displayed to tag questions with AG and Action Items.

    Y/N Table Edit

    Default: N

    PTAI_SYSTEM_DATA Character(1) VARCHAR2(1) NOT NULL Option to mark the AG template as System delivered data.

    Y/N Table Edit

    Default: N

    STYLESHEETNAME Character(30) VARCHAR2(30) NOT NULL Style Sheet Name (see PSSTYLSHEETDEFN).
    PTAI_CTX_DISP_OPT Character(1) VARCHAR2(1) NOT NULL Context Data Display Option
    F=Fixed
    M=Modal
    P=Popup

    Default: F

    PTAI_CTX_PKGROOT Character(30) VARCHAR2(30) NOT NULL Package Name
    PTAI_CTX_QUALPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
    PTAI_CTX_CLASSID Character(30) VARCHAR2(30) NOT NULL Class name
    PTAI_CTX_METHOD Character(60) VARCHAR2(60) NOT NULL Application Class Method Name
    PTAI_GENLNGINST Character(1) VARCHAR2(1) NOT NULL Lang Instances

    Y/N Table Edit

    Default: N

    PTAI_HIDESTEPS Character(1) VARCHAR2(1) NOT NULL Hide Steps

    Y/N Table Edit

    Default: N

    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20