PTAI_LIST

index back

Action Items Lists

Action Items Lists

  • Related language record: PTAI_LIST_LNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTAI_LIST_IDCharacter(31)VARCHAR2(31) NOT NULLAction Items - Action Item List ID
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
    PTAI_LABELCharacter(100)VARCHAR2(100) NOT NULLAction Items - Label
    PTAI_DESCRLONGLong CharacterCLOBAction Items - Long Description
    PTAI_NOTIFY_TYPECharacter(1)VARCHAR2(1) NOT NULLAction 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_FLGCharacter(1)VARCHAR2(1) NOT NULLAction Item Active Flag
    N=Display Inactive Lists
    Y=Display Active Lists

    Y/N Table Edit

    CREATED_DTTMDateTime(26)TIMESTAMPCreated Datetime
    CREATEOPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
    LAST_UPDATE_DTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    PTAI_IS_TMPLCharacter(1)VARCHAR2(1) NOT NULLTemplate
    N=No
    Y=Yes
    PTAI_PARENT_TMPLCharacter(31)VARCHAR2(31) NOT NULLTemplate ID
    PTAI_LIST_STATUSCharacter(2)VARCHAR2(2) NOT NULLStatus
    CA=Cancelled
    CP=Complete
    IP=In Progress
    PACKAGEROOTCharacter(30)VARCHAR2(30) NOT NULLRoot Package ID
    QUALIFYPATHCharacter(127)VARCHAR2(127) NOT NULLQualified Package/Class Path
    APPCLASSIDCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID
    APPCLASSMETHODCharacter(60)VARCHAR2(60) NOT NULLApplication Class Method Name
    PTAI_INST_PKGROOTCharacter(30)VARCHAR2(30) NOT NULLPackage Name
    PTAI_INST_QUALPATHCharacter(127)VARCHAR2(127) NOT NULLQualified Package/Class Path
    PTAI_INST_CLASSIDCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID
    URLCharacter(254)VARCHAR2(254) NOT NULLInternet URL (Universal Resource Locator)
    PTAI_REOPEN_ITEMCharacter(1)VARCHAR2(1) NOT NULLAllow Item Reopen
    N=No
    Y=Yes
    PTAI_PGLT_EXCLCharacter(1)VARCHAR2(1) NOT NULLInclude In My List Pagelet
    N=No
    Y=Yes
    PTAI_FIELD1_LBLCharacter(30)VARCHAR2(30) NOT NULLField Label 1
    PTAI_FIELD2_LBLCharacter(30)VARCHAR2(30) NOT NULLField Label 2
    PTAI_FIELD3_LBLCharacter(30)VARCHAR2(30) NOT NULLField Label 3
    PTAI_FIELD4_LBLCharacter(30)VARCHAR2(30) NOT NULLField Label 4
    PTAI_FIELD5_LBLCharacter(30)VARCHAR2(30) NOT NULLField Label 5
    PTAI_FIELD6_LBLCharacter(30)VARCHAR2(30) NOT NULLField Label 1
    PTAI_FIELD7_LBLCharacter(30)VARCHAR2(30) NOT NULLField Label 2
    PTAI_FIELD8_LBLCharacter(30)VARCHAR2(30) NOT NULLField Label 3
    PTAI_FIELD9_LBLCharacter(30)VARCHAR2(30) NOT NULLField Label 4
    PTAI_FIELD10_LBLCharacter(30)VARCHAR2(30) NOT NULLField Label 5
    PTAI_PGLT_EXITCharacter(1)VARCHAR2(1) NOT NULLPagelet Exit
    N=No
    Y=Yes
    PTAI_PREPROC_METHCharacter(60)VARCHAR2(60) NOT NULLPre Process Method
    PTAI_PGLT_SAVECharacter(1)VARCHAR2(1) NOT NULLPagelet Save
    N=No
    Y=Yes
    PTAI_INST_PROCCharacter(1)VARCHAR2(1) NOT NULLInstance Processing
    N=No
    Y=Yes
    PTAI_PBVISIBLECharacter(1)VARCHAR2(1) NOT NULLPagelet Progress Bar Visible

    Y/N Table Edit

    Default: Y

    PTAI_START_DTDate(10)DATEStart Date
    PTAI_DUE_DATEDate(10)DATEAction Items - Due Date
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19