PTAI_LISTID_VW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
    1 NUMROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
    2 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    3 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    4 PTAI_LABEL Character(100) VARCHAR2(100) NOT NULL Action Items - Label
    5 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
    6 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 Value: NONS

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    9 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

    10 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
    11 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    12 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.
    13 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.
    14 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    15 PTAI_IS_TMPL Character(1) VARCHAR2(1) NOT NULL Template
    N=No
    Y=Yes
    16 PTAI_PARENT_TMPL Character(31) VARCHAR2(31) NOT NULL Template ID
    17 PTAI_LIST_STATUS Character(2) VARCHAR2(2) NOT NULL Status
    CA=Cancelled
    CP=Complete
    IP=In Progress
    18 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
    19 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
    20 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    21 APPCLASSMETHOD Character(60) VARCHAR2(60) NOT NULL Application Class Method Name
    22 PTAI_INST_PKGROOT Character(30) VARCHAR2(30) NOT NULL Package Name
    23 PTAI_INST_QUALPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
    24 PTAI_INST_CLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    25 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    26 PTAI_REOPEN_ITEM Character(1) VARCHAR2(1) NOT NULL Allow Item Reopen
    N=No
    Y=Yes
    27 PTAI_PGLT_EXCL Character(1) VARCHAR2(1) NOT NULL Include In My List Pagelet
    N=No
    Y=Yes
    28 PTAI_FIELD1_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 1
    29 PTAI_FIELD2_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 2
    30 PTAI_FIELD3_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 3
    31 PTAI_FIELD4_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 4
    32 PTAI_FIELD5_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 5
    33 PTAI_FIELD6_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 1
    34 PTAI_FIELD7_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 2
    35 PTAI_FIELD8_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 3
    36 PTAI_FIELD9_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 4
    37 PTAI_FIELD10_LBL Character(30) VARCHAR2(30) NOT NULL Field Label 5
    38 PTAI_PGLT_EXIT Character(1) VARCHAR2(1) NOT NULL Pagelet Exit
    N=No
    Y=Yes
    39 PTAI_PREPROC_METH Character(60) VARCHAR2(60) NOT NULL Pre Process Method
    40 PTAI_PGLT_SAVE Character(1) VARCHAR2(1) NOT NULL Pagelet Save
    N=No
    Y=Yes
    41 PTAI_INST_PROC Character(1) VARCHAR2(1) NOT NULL Instance Processing
    N=No
    Y=Yes
    42 PTAI_PBVISIBLE Character(1) VARCHAR2(1) NOT NULL Pagelet Progress Bar Visible

    Y/N Table Edit

    Default Value: Y

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

    Default Value: PTAI_ACTIVITYGUIDE

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

    49 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 Value: N

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

    Y/N Table Edit

    Default Value: N

    51 STYLESHEETNAME Character(30) VARCHAR2(30) NOT NULL Style Sheet Name (see PSSTYLSHEETDEFN).
    52 PTAI_DESCRLONG Long Character CLOB Action Items - Long Description