RB_TSK_ASN_O_VW

(SQL View)
Index Back

Task Assignees only View.

Since Owner info is also stored in Assignee record, this view gives list of Assignees only.

SELECT TASK_ID , PERSON_ID_ASSIGNEE , BO_ID_PERSON , BO_ID_CONTACT , ROLE_TYPE_ID_CNTCT , BO_ID_CUST , ROLE_TYPE_ID_CUST , OWNER , TASK_ASGN_STATUS , TASK_ATTENDANCE , REMINDAT , REMINDER_DURATION , REMINDER_UNITS , NOTIFY_STATUS , INVITE_TYPE , READ_SW , %subrec(RB_AUDIT_SBR, PS_RB_TSK_ASGN) FROM PS_RB_TSK_ASGN WHERE OWNER = 'N'

  • Parent record: RB_TSK
  • # 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 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 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    5 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    6 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    7 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    8 OWNER Character(1) VARCHAR2(1) NOT NULL Owner
    N=No
    Y=Yes

    Default Value: N

    9 TASK_ASGN_STATUS Character(4) VARCHAR2(4) NOT NULL Task Assignment Status. Used by Task Management.
    ACPT=Accepted
    CMPL=Completed
    DCLN=Declined
    OPEN=Assigned

    Default Value: OPEN

    10 TASK_ATTENDANCE Character(4) VARCHAR2(4) NOT NULL Note Task Attendance. Used by Task Management.
    ABSN=Absent
    ATND=Attended
    11 REMINDAT DateTime(26) TIMESTAMP Time Field. for reminder. Useb by Task Management.
    12 REMINDER_DURATION Number(6,0) INTEGER NOT NULL Reminder Duration. Used by Task Management.
    13 REMINDER_UNITS Character(4) VARCHAR2(4) NOT NULL Reminder Units. Used by Task Management.
    DAYS=Days
    HOUR=Hours
    MINS=Minutes
    14 NOTIFY_STATUS Number(4,0) SMALLINT NOT NULL Notify Status

    Default Value: 0

    15 INVITE_TYPE Character(4) VARCHAR2(4) NOT NULL Task Invitation Type. Used by Task Management.
    FYI=FYI
    OPTL=Optional
    REQR=Required

    Default Value: REQR

    16 READ_SW Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether a CRM worklist notification has been read by the user.

    Y/N Table Edit

    Default Value: N

    17 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    18 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    19 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    20 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    21 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.
    22 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time