PTAI_ITEM

(SQL Table)
 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 Name PeopleSoft Field Type Database Column Type Description
    1 PTAI_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item ID
    2 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    3 PTAI_LABEL Character(100) VARCHAR2(100) NOT NULL Action Items - Label
    4 PTAI_DESCRLONG Long Character CLOB Action Items - Long Description
    5 PTAI_PRIORITY Character(1) VARCHAR2(1) NOT NULL Action Items - Priority
    1=Low Priority
    2=Medium Priority
    3=High Priority
    6 PTAI_STATUS Character(1) VARCHAR2(1) NOT NULL Action Items - Status
    0=Not Assigned
    1=Assigned
    2=In Progress
    3=On Hold
    4=Completed
    5=Cancelled
    6=Denied
    7 PTAI_DUE_DATE Date(10) DATE Action Items - Due Date
    8 PTAI_ASSIGN_DT Date(10) DATE Action Items - Assigned Date
    9 PTAI_ASSIGN_OPRID Character(30) VARCHAR2(30) NOT NULL Action Items - Assigned to User
    10 PTAI_CATEGORY Character(30) VARCHAR2(30) NOT NULL Action Items - Category
    11 PTAI_RES_DATE Date(10) DATE Action Items - Resolve/Complete Date
    12 PTAI_RES_OPRID Character(30) VARCHAR2(30) NOT NULL Action Items - Resolved By User
    13 PTAI_POST_ID Character(10) VARCHAR2(10) NOT NULL Post ID
    14 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
    15 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    16 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.
    17 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.
    18 PTAI_REQD Character(1) VARCHAR2(1) NOT NULL Required
    N=No
    Y=Yes
    19 PTAI_INACTIVAFTDUE Character(1) VARCHAR2(1) NOT NULL Inactivate action item after due date is passed

    Y/N Table Edit

    Default Value: N

    20 PTAI_LOCKAFTRCOMPL Character(1) VARCHAR2(1) NOT NULL Locak action item after completion

    Y/N Table Edit

    Default Value: N

    21 PTAI_MILESTONE Character(1) VARCHAR2(1) NOT NULL Milestone
    N=No
    Y=Yes
    22 PTAI_START_DT Date(10) DATE Start Date
    23 PTAI_START_TIME Time(15) TIMESTAMP Start Time
    24 PTAI_DUE_TIME Time(15) TIMESTAMP Due Time
    25 PTAI_EST_TIME Number(6,2) DECIMAL(5,2) NOT NULL Estimated Duration
    26 PTAI_EST_UNIT Character(1) VARCHAR2(1) NOT NULL Time Unit
    D=Days
    H=Hours
    M=Months
    27 PTAI_PERC_COMPL Number(3,0) SMALLINT NOT NULL Percent Complete
    28 PTAI_COMPL_TIME Time(15) TIMESTAMP Completed Time
    29 PTAI_SEQ Number(4,0) SMALLINT NOT NULL Sequence
    30 PTAI_SUMMARY Character(1) VARCHAR2(1) NOT NULL Summary
    N=No
    Y=Yes
    31 PTAI_ORIGIN_ID Character(31) VARCHAR2(31) NOT NULL Origin ID
    32 PTAI_TYPE Character(1) VARCHAR2(1) NOT NULL Type
    A=App Class URL
    C=PS Component
    M=Manual
    N=Non PeopleSoft URL
    P=Process
    Q=PS Query
    S=PS Script
    33 PTAI_IMAGE Character(30) VARCHAR2(30) NOT NULL Image Name
    34 PTAI_FIELD1 Character(100) VARCHAR2(100) NOT NULL PTAI_FIELD1
    35 PTAI_FIELD10 Character(1) VARCHAR2(1) NOT NULL PTAI_FIELD10
    36 PTAI_FIELD2 Character(100) VARCHAR2(100) NOT NULL PTAI_FIELD2
    37 PTAI_FIELD3 Character(100) VARCHAR2(100) NOT NULL PTAI_FIELD3
    38 PTAI_FIELD4 Character(100) VARCHAR2(100) NOT NULL PTAI_FIELD4
    39 PTAI_FIELD5 Character(100) VARCHAR2(100) NOT NULL PTAI_FIELD5
    40 PTAI_FIELD6 Character(1) VARCHAR2(1) NOT NULL PTAI_FIELD6
    41 PTAI_FIELD7 Character(1) VARCHAR2(1) NOT NULL PTAI_FIELD7
    42 PTAI_FIELD8 Character(1) VARCHAR2(1) NOT NULL PTAI_FIELD8
    43 PTAI_FIELD9 Character(1) VARCHAR2(1) NOT NULL PTAI_FIELD9
    44 PTAI_TARGET Character(1) VARCHAR2(1) NOT NULL Target
    M=Modal
    N=New Window
    T=Target Frame
    45 PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).
    46 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
    47 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
    48 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    49 PTAI_PREPROC_METH Character(60) VARCHAR2(60) NOT NULL Pre Process Method
    50 PTAI_POSTPROC_METH Character(60) VARCHAR2(60) NOT NULL Post Process Method
    51 PTAI_CURR_STEP Character(1) VARCHAR2(1) NOT NULL Current Step
    N=No
    Y=Yes
    52 PTAI_FORM_SEQ Number(15,0) DECIMAL(15) NOT NULL Form sequence number
    53 PTAI_ASSIGN_TYPE Character(4) VARCHAR2(4) NOT NULL Assign Type
    EMAL=E-Mail
    ROLE=Role
    USER=User
    54 PTAI_ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Action Item Active Flag
    N=Display Inactive Lists
    Y=Display Active Lists

    Default Value: Y

    55 PTAI_RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
    E=Error
    I=Initiated
    PA=Paused After
    PB=Paused Before
    Q=Queued
    R=Processing
    S=Success
    56 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    57 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    58 PTAI_TARGET_NODE Character(30) VARCHAR2(30) NOT NULL Target Node
    59 PTSCHDL_NAME Character(30) VARCHAR2(30) NOT NULL Partition Schedule
    60 PTAI_PAUSE_BEF_FLG Character(1) VARCHAR2(1) NOT NULL Pause Before

    Y/N Table Edit

    61 PTAI_PAUSE_AFT_FLG Character(1) VARCHAR2(1) NOT NULL Pause After

    Y/N Table Edit

    62 PTAI_SKIP_ERR_FLG Character(1) VARCHAR2(1) NOT NULL Skip On Error

    Y/N Table Edit

    63 PTAI_RESUM_ERR_FLG Character(1) VARCHAR2(1) NOT NULL Resume On Error

    Y/N Table Edit

    Default Value: Y

    64 PTAI_RNTM_INP_FLG Character(1) VARCHAR2(1) NOT NULL Allow Runtime Input

    Y/N Table Edit

    65 PTAI_AWE_PROC_ID Character(30) VARCHAR2(30) NOT NULL AWE Process ID
    66 PTAI_AWE_PACKAGE Character(30) VARCHAR2(30) NOT NULL Root Package ID
    67 PTAI_AWE_PATH Character(127) VARCHAR2(127) NOT NULL Qualify Path/Class
    68 PTAI_AWE_CLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    69 PTAI_AWE_APPROVAL Character(30) VARCHAR2(30) NOT NULL Field to store the Approval method name which needs to be executed for approved AWE status.
    70 PTAI_AWE_DENIAL Character(30) VARCHAR2(30) NOT NULL Field to store the Denail method name which needs to be executed for Denied AWE status.
    71 PTAI_QUESTION_ID Character(31) VARCHAR2(31) NOT NULL Questionnaire ID
    72 PTAI_ANSWER Character(1) VARCHAR2(1) NOT NULL Questionnaire Answer
    N=No
    Y=Yes
    73 PTAI_IS_FLUID Character(1) VARCHAR2(1) NOT NULL Action Item Fluid check box.

    Y/N Table Edit

    Default Value: N

    74 PTSF_LAST_UPDDTTM 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.
    75 PTAI_USAGE_STATS Character(1) VARCHAR2(1) NOT NULL Usage Statistics

    Y/N Table Edit

    Default Value: N

    76 PTAI_START_DTTM DateTime(26) TIMESTAMP Step Start DateTime
    77 PTAI_END_DTTM DateTime(26) TIMESTAMP End DateTime
    78 PTAI_ESTM_DUR Number(8,2) DECIMAL(7,2) NOT NULL Estimate Duration
    79 PTAI_ACTL_DUR Number(8,2) DECIMAL(7,2) NOT NULL Elapsed Duration
    80 PTAI_CNT_NUM Number(3,0) SMALLINT NOT NULL Visit Count