RB_TSK_CNTCT_VW

(SQL View)
Index Back

Task Contacts View

Task Contacts View. Used to fix an Addut. Used by Task Management.

SELECT TASK_ID , PERSON_ID_CNTCT , BO_ID_PERSON , BO_ID_CONTACT , ROLE_TYPE_ID_CNTCT , BO_ID_CUST , ROLE_TYPE_ID_CUST , PRIMARY_IND FROM PS_RB_TSK_CNTCT

  • 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_CNTCT Character(15) VARCHAR2(15) NOT NULL Person ID

    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 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N