HR_OBD_ITEM_VW

(SQL View)
 Index Back

Action Items

Action Items Definition and Properties

SELECT A.PTAI_ITEM_ID , A.PTAI_LIST_ID , B.PTAI_LABEL , A.PTAI_STATUS , A.PTAI_DUE_DATE , A.PTAI_RES_DATE , A.PTAI_RES_OPRID , A.CREATED_DTTM , A.CREATEOPRID , A.LAST_UPDATE_DTTM , A.LASTUPDOPRID , A.PTAI_REQD , A.PTAI_SEQ , A.PTAI_SUMMARY , A.PTAI_ORIGIN_ID , A.PTCS_SERVICEID , A.PTAI_ACTIVE_FLG FROM PS_PTAI_ITEM A , PS_PTAI_ITEM B WHERE B.PTAI_ITEM_ID = A.PTAI_ORIGIN_ID

  • Related Language Record: HR_OBD_ITEM_VWL

    • # 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_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
    5 PTAI_DUE_DATE Date(10) DATE Action Items - Due Date
    6 PTAI_RES_DATE Date(10) DATE Action Items - Resolve/Complete Date
    7 PTAI_RES_OPRID Character(30) VARCHAR2(30) NOT NULL Action Items - Resolved By User
    8 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
    9 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    10 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.
    11 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.
    12 PTAI_REQD Character(1) VARCHAR2(1) NOT NULL Required
    N=No
    Y=Yes
    13 PTAI_SEQ Number(4,0) SMALLINT NOT NULL Sequence
    14 PTAI_SUMMARY Character(1) VARCHAR2(1) NOT NULL Summary
    N=No
    Y=Yes
    15 PTAI_ORIGIN_ID Character(31) VARCHAR2(31) NOT NULL Origin ID
    16 PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).
    17 PTAI_ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Action Item Active Flag
    N=Display Inactive Lists
    Y=Display Active Lists