RB_TSK_EDIT_VW

(SQL View)
 Index Back

View for editable tasks in Grd

This record is used by task page which allow editing of tasks in a grid.

SELECT B.TASK_ID , B.RB_TRANSACTION_ID , B.TXN_MARKET , A.DESCR60 , A.TASK_TYPE , A.TASK_STATUS , A.TASK_PRIORITY , A.START_DATE , A.START_TIME , A.END_DATE , A.END_TIME , ' ' , A.TASK_LOCATION , A.PERSON_ID_OWNER , A.DESCRLONG , A.ROW_ADDED_DTTM , A.SYNCID , A.SYNCDTTM , B.REL_TXN_SYNCID FROM PS_RB_TSK A , PS_RB_TSK_TXN B WHERE A.TASK_ID = B.TASK_ID

  • Related Language Record: RB_TSK_EDIT_LVW

    • # 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.
    2 RB_TRANSACTION_ID Character(25) VARCHAR2(25) NOT NULL Transaction ID
    3 TXN_MARKET Character(3) VARCHAR2(3) NOT NULL Transaction Market. Used by Task Management.
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    5 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"

    Prompt Table: RSF_TSK_TYPE_VW

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

    Default Value: OPEN

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

    Prompt Table: RB_TSK_PRTY_VW

    8 START_DATE Date(10) DATE Start Date
    9 START_TIME Time(15) TIMESTAMP Start Time
    10 END_DATE Date(10) DATE End date field to store an end date.
    11 END_TIME Time(15) TIMESTAMP End Time
    12 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
    13 TASK_LOCATION Character(30) VARCHAR2(30) NOT NULL Task Location. Used by Task Management.
    14 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: RB_WORKER_SRCH
    Set Control Field: PERSON_ID

    15 DESCRLONG Long Character CLOB Long Description
    16 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    17 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    18 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    19 REL_TXN_SYNCID Number(10,0) DECIMAL(10) NOT NULL SYNCID of the related transaction. Used by Task Management.