PTAI_ITEM

index back

Action Items

Action Items Definition and Properties

  • Related language record: PTAI_ITEM_LNG
  • Parent record of PTAI_ITEMATLNG PTAI_ITEM_ATTR
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTAI_ITEM_IDCharacter(31)VARCHAR2(31) NOT NULLAction Items - Action Item ID
    PTAI_LIST_IDCharacter(31)VARCHAR2(31) NOT NULLAction Items - Action Item List ID
    PTAI_LABELCharacter(100)VARCHAR2(100) NOT NULLAction Items - Label
    PTAI_DESCRLONGLong CharacterCLOBAction Items - Long Description
    PTAI_PRIORITYCharacter(1)VARCHAR2(1) NOT NULLAction Items - Priority
    1=Low Priority
    2=Medium Priority
    3=High Priority
    PTAI_STATUSCharacter(1)VARCHAR2(1) NOT NULLAction Items - Status
    0=Not Assigned
    1=Assigned
    2=In Progress
    3=On Hold
    4=Completed
    5=Cancelled
    PTAI_DUE_DATEDate(10)DATEAction Items - Due Date
    PTAI_ASSIGN_DTDate(10)DATEAction Items - Assigned Date
    PTAI_ASSIGN_OPRIDCharacter(30)VARCHAR2(30) NOT NULLAction Items - Assigned to User
    PTAI_CATEGORYCharacter(30)VARCHAR2(30) NOT NULLAction Items - Category
    PTAI_RES_DATEDate(10)DATEAction Items - Resolve/Complete Date
    PTAI_RES_OPRIDCharacter(30)VARCHAR2(30) NOT NULLAction Items - Resolved By User
    PTAI_POST_IDCharacter(10)VARCHAR2(10) NOT NULLPost ID
    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.
    PTAI_REQDCharacter(1)VARCHAR2(1) NOT NULLRequired
    N=No
    Y=Yes
    PTAI_MILESTONECharacter(1)VARCHAR2(1) NOT NULLMilestone
    N=No
    Y=Yes
    PTAI_START_DTDate(10)DATEStart Date
    PTAI_START_TIMETime(15)TIMESTAMPStart Time
    PTAI_DUE_TIMETime(15)TIMESTAMPDue Time
    PTAI_EST_TIMENumber(6,2)DECIMAL(5,2) NOT NULLEstimated Duration
    PTAI_EST_UNITCharacter(1)VARCHAR2(1) NOT NULLTime Unit
    D=Days
    H=Hours
    M=Months
    PTAI_PERC_COMPLNumber(3,0)SMALLINT NOT NULLPercent Complete
    PTAI_COMPL_TIMETime(15)TIMESTAMPCompleted Time
    PTAI_SEQNumber(4,0)SMALLINT NOT NULLSequence
    PTAI_SUMMARYCharacter(1)VARCHAR2(1) NOT NULLSummary
    N=No
    Y=Yes
    PTAI_ORIGIN_IDCharacter(31)VARCHAR2(31) NOT NULLOrigin ID
    PTAI_TYPECharacter(1)VARCHAR2(1) NOT NULLType
    A=App Class URL
    C=PS Component
    M=Manual
    N=Non PeopleSoft URL
    P=Process
    Q=PS Query
    S=PS Script
    PTAI_IMAGECharacter(30)VARCHAR2(30) NOT NULLImage
    PTAI_FIELD1Character(100)VARCHAR2(100) NOT NULLPTAI_FIELD1
    PTAI_FIELD10Character(1)VARCHAR2(1) NOT NULLPTAI_FIELD10
    PTAI_FIELD2Character(100)VARCHAR2(100) NOT NULLPTAI_FIELD2
    PTAI_FIELD3Character(100)VARCHAR2(100) NOT NULLPTAI_FIELD3
    PTAI_FIELD4Character(100)VARCHAR2(100) NOT NULLPTAI_FIELD4
    PTAI_FIELD5Character(100)VARCHAR2(100) NOT NULLPTAI_FIELD5
    PTAI_FIELD6Character(1)VARCHAR2(1) NOT NULLPTAI_FIELD6
    PTAI_FIELD7Character(1)VARCHAR2(1) NOT NULLPTAI_FIELD7
    PTAI_FIELD8Character(1)VARCHAR2(1) NOT NULLPTAI_FIELD8
    PTAI_FIELD9Character(1)VARCHAR2(1) NOT NULLPTAI_FIELD9
    PTAI_TARGETCharacter(1)VARCHAR2(1) NOT NULLTarget
    M=Modal
    N=New Window
    T=Target Frame
    PTCS_SERVICEIDCharacter(30)VARCHAR2(30) NOT NULLServices ID (see PSPTCSSRVDEFN).
    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
    PTAI_PREPROC_METHCharacter(60)VARCHAR2(60) NOT NULLPre Process Method
    PTAI_POSTPROC_METHCharacter(60)VARCHAR2(60) NOT NULLPost Process Method
    PTAI_CURR_STEPCharacter(1)VARCHAR2(1) NOT NULLCurrent Step
    N=No
    Y=Yes
    PTAI_FORM_SEQNumber(15,0)DECIMAL(15) NOT NULLForm sequence number
    PTAI_ASSIGN_TYPECharacter(4)VARCHAR2(4) NOT NULLAssign Type
    ROLE=Role
    USER=User
    PTAI_ACTIVE_FLGCharacter(1)VARCHAR2(1) NOT NULLAction Item Active Flag
    N=Display Inactive Lists
    Y=Display Active Lists

    Default: Y

    PTAI_RUNSTATUSCharacter(2)VARCHAR2(2) NOT NULLProcess Scheduler Process Run Status
    E=Error
    I=Initiated
    PA=Paused After
    PB=Paused Before
    Q=Queued
    R=Processing
    S=Success
    PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
    PTAI_TARGET_NODECharacter(30)VARCHAR2(30) NOT NULLTarget Node
    PTSCHDL_NAMECharacter(30)VARCHAR2(30) NOT NULLPartition Schedule
    PTAI_PAUSE_BEF_FLGCharacter(1)VARCHAR2(1) NOT NULLPause Before

    Y/N Table Edit

    PTAI_PAUSE_AFT_FLGCharacter(1)VARCHAR2(1) NOT NULLPause After

    Y/N Table Edit

    PTAI_SKIP_ERR_FLGCharacter(1)VARCHAR2(1) NOT NULLSkip On Error

    Y/N Table Edit

    PTAI_RESUM_ERR_FLGCharacter(1)VARCHAR2(1) NOT NULLResume On Error

    Y/N Table Edit

    Default: Y

    PTAI_RNTM_INP_FLGCharacter(1)VARCHAR2(1) NOT NULLAllow Runtime Input

    Y/N Table Edit

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19