PTAI_LISTID_VW

 index back

Action Items Lists

Action Items Lists
SELECT rownum ,ptai_list_id , PORTAL_NAME , PTAI_LABEL , PTAI_NOTIFY_TYPE , PTAI_AGRENDERTYPE , PTAI_RESTARTAG , PTAI_SUOW , PTAI_ACTIVE_FLG , CREATED_DTTM , CREATEOPRID , LAST_UPDATE_DTTM , LASTUPDOPRID , OBJECTOWNERID , PTAI_IS_TMPL , PTAI_PARENT_TMPL , PTAI_LIST_STATUS , PACKAGEROOT , QUALIFYPATH , APPCLASSID , APPCLASSMETHOD , PTAI_INST_PKGROOT , PTAI_INST_QUALPATH , PTAI_INST_CLASSID , URL , PTAI_REOPEN_ITEM , PTAI_PGLT_EXCL , PTAI_FIELD1_LBL , PTAI_FIELD2_LBL , PTAI_FIELD3_LBL , PTAI_FIELD4_LBL , PTAI_FIELD5_LBL , PTAI_FIELD6_LBL , PTAI_FIELD7_LBL , PTAI_FIELD8_LBL , PTAI_FIELD9_LBL , PTAI_FIELD10_LBL , PTAI_PGLT_EXIT , PTAI_PREPROC_METH , PTAI_PGLT_SAVE , PTAI_INST_PROC , PTAI_PBVISIBLE , PTAI_START_DT , PTAI_DUE_DATE , PTAI_GPDS_ID , PTAI_SINGLECOMPAG , PTAI_FIXEDSIDEPNL , PTAI_SHOWFLNOTIFY , PTAI_QUESTIONNAIRE , PTAI_SYSTEM_DATA , STYLESHEETNAME , PTAI_DESCRLONG FROM ( SELECT * FROM PS_PTAI_LIST A WHERE NOT EXISTS ( SELECT B.PORTAL_NAME FROM PSPRDMDEFN B WHERE A.PORTAL_NAME = B.PORTAL_NAME AND B.PORTAL_TYPE IN ('WORKSPACE', 'WORKSPACE_TMPL')) AND A.PTAI_IS_TMPL = 'N' AND A.PTAI_PARENT_TMPL <> 'PTAI_AGTMP'ORDER BY A.PTAI_PARENT_TMPL,LPAD(substr(A.PTAI_LIST_ID,11,LENGTH(A.PTAI_LIST_ID)),10,0))

  • Related language record: PTAI_LISTID_LVW

    • PeopleSoft Field Name Field Type Column Type Description
    NUMROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
    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_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_DESCRLONG Long Character CLOB Action Items - Long Description
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20