RB_TSK_WAP_VW

(SQL View)
 Index Back

WAP Task View

Main view for WAP Task. Used by Task Management.

SELECT T.TASK_ID , TA.PERSON_ID_ASSIGNEE , TA.BO_ID_PERSON , TA.OWNER , TA.TASK_ASGN_STATUS , T.DESCR60 , T.TASK_TYPE , T.TASK_STATUS , T.TASK_PRIORITY , T.START_DATE , T.START_TIME , T.END_DATE , T.END_TIME , T.TIMEZONE , T.TASK_LOCATION , T.PERSON_ID_OWNER , T.REPEAT_TYPE FROM PS_RB_TSK T , PS_RB_TSK_ASGN TA WHERE T.TASK_ID = TA.TASK_ID

  • Related Language Record: RB_TSK_WAP_LNVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.

    Default Value: 999999999999

    2 PERSON_ID_ASSIGNEE Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: RD_PERSON_PN_VW

    3 BO_ID_PERSON Number(31,0) DECIMAL(31) NOT NULL Business Object ID
    4 OWNER Character(1) VARCHAR2(1) NOT NULL Owner
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    5 TASK_ASGN_STATUS Character(4) VARCHAR2(4) NOT NULL Task Assignment Status. Used by Task Management.
    ACPT=Accepted
    CMPL=Completed
    DCLN=Declined
    OPEN=Assigned
    6 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    7 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"

    Prompt Table: RB_TSK_TYPE

    8 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
    CMPL=Completed
    CNCL=Canceled
    INPR=In Progress
    OPEN=Open

    Default Value: OPEN

    9 TASK_PRIORITY Character(4) VARCHAR2(4) NOT NULL Task Priority indicator for Task. Used in Task Management.

    Prompt Table: RB_TSK_PRTY_VW

    10 START_DATE Date(10) DATE Start Date
    11 START_TIME Time(15) TIMESTAMP Start Time
    12 END_DATE Date(10) DATE End date field to store an end date.
    13 END_TIME Time(15) TIMESTAMP End Time
    14 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    15 TASK_LOCATION Character(30) VARCHAR2(30) NOT NULL Task Location. Used by Task Management.
    16 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: RB_WORKER_SRCH

    17 REPEAT_TYPE Character(4) VARCHAR2(4) NOT NULL Repeat Type. Used by Task Management.
    CUST=Custom
    DAIL=Daily
    MNTH=Monthly
    NONE=Does Not Repeat
    WEEK=Weekly
    YEAR=Yearly

    Default Value: NONE