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 Action Items - When this field is checked on, then notify users when a change/save occurs on the Action Items details page.
    A=Automatically Send Email
    N=Do Nothing - No Email Sent
    P=Prompt User to Send Email
    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
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19