RSF_TSK3_VW

(SQL View)
 Index Back

View for Oppy Task

Task view for Lead and Oppy Component.

SELECT c.person_id_owner , c.start_date , c.end_date , a.task_id , b.opportunity_id , a.rb_transaction_id , c.descr60 , c.task_type , c.task_status , c.task_priority , c.descrlong , b.opportunity_name , d.sales_user_name , b.name1 , b.name FROM ps_rb_tsk_txn a , ps_rsf_opportunity b , ps_rb_tsk c , ps_rsf_person_vw d WHERE a.rel_txn_syncid = b.syncid AND a.task_id = c.task_id AND a.rb_transaction_id = 'OPPRT' AND a.txn_market = 'GBL' AND c.person_id_owner = d.contact_id UNION ALL SELECT c.person_id_owner , c.start_date , c.end_date , a.task_id , b.opportunity_id , a.rb_transaction_id , c.descr60 , c.task_type , c.task_status , c.task_priority , c.descrlong , b.descr50 , d.sales_user_name , b.name1 , e.bo_name FROM ps_rb_tsk_txn a , PS_RSF_LEAD b , ps_rb_tsk c , ps_rsf_person_vw d , ps_bo_name e WHERE a.rel_txn_syncid = b.syncid AND a.task_id = c.task_id AND a.rb_transaction_id = 'LEAD' AND a.txn_market = 'GBL' AND c.person_id_owner = d.contact_id AND e.bo_id = b.bo_id_contact AND b.bo_id_contact <> 0 UNION ALL SELECT c.person_id_owner , c.start_date , c.end_date , a.task_id , b.opportunity_id , a.rb_transaction_id , c.descr60 , c.task_type , c.task_status , c.task_priority , c.descrlong , b.descr50 , d.sales_user_name , b.name1 , ' ' FROM ps_rb_tsk_txn a , PS_RSF_LEAD b , ps_rb_tsk c , ps_rsf_person_vw d WHERE a.rel_txn_syncid = b.syncid AND a.task_id = c.task_id AND a.rb_transaction_id = 'LEAD' AND a.txn_market = 'GBL' AND c.person_id_owner = d.contact_id AND b.bo_id_contact = 0

  • Related Language Record: RSF_TSK3_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: RB_WORKER_SRCH

    2 START_DATE Date(10) DATE Start Date for Gen Standing PO
    3 END_DATE Date(10) DATE End date field to store an end date.
    4 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.
    5 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
    6 RB_TRANSACTION_ID Character(25) VARCHAR2(25) NOT NULL Transaction ID
    7 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    8 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

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

    Default Value: OPEN

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

    Default Value: 3

    Prompt Table: RB_TSK_PRTY_VW

    11 DESCRLONG Long Character CLOB Long Description
    12 OPPORTUNITY_NAME Character(50) VARCHAR2(50) NOT NULL Opportunity Name - User Enters this field in Mixed Case.
    13 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field
    14 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
    15 NAME Character(50) VARCHAR2(50) NOT NULL Name