RIM_TSKASGN_PER

(SQL View)
 Index Back

Task Assignees View

Task Assignees view used in Data Distribution for RIM Contacts

SELECT ASN.TASK_ID , ASN.PERSON_ID_ASSIGNEE , INV.PERSON_ID_ASSIGNEE , ASN.BO_ID_PERSON , ASN.BO_ID_CONTACT , ASN.ROLE_TYPE_ID_CNTCT , ASN.BO_ID_CUST , ASN.ROLE_TYPE_ID_CUST , ASN.TASK_ASGN_STATUS , ASN.TASK_ATTENDANCE , ASN.REMINDAT , ASN.NOTIFY_STATUS , ASN.OWNER , %subrec(RB_AUDIT_SBR, PER) FROM PS_RB_TSK_ASGN ASN , PS_RB_TSK_ASGN INV , PS_RIM_PERSON_VW PER WHERE INV.PERSON_ID_ASSIGNEE = PER.PERSON_ID AND INV.TASK_ID = ASN.TASK_ID

  • 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    4 BO_ID_PERSON Number(31,0) DECIMAL(31) NOT NULL Business Object ID
    5 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    6 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    7 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    8 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    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 NOTIFY_STATUS Number(4,0) SMALLINT NOT NULL Notify Status

    Default Value: 0

    13 OWNER Character(1) VARCHAR2(1) NOT NULL Owner
    N=No
    Y=Yes
    14 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    15 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    16 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    17 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    18 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.
    19 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time