RD_CR_OPPY_VW

(SQL View)
 Index Back

View for Opportunity

Call Report view for Opportunity Component. Used by Opportunity Component.

SELECT OP.OPPORTUNITY_ID , TX.CALL_REPORT_ID , T.DESCR30 , T.CALL_REPORT_DATE , T.CALLRPT_EVENT_TYPE , T.CALLRPT_LOCATION , T.RELATED_TASK_ID FROM PS_RD_CALL_REPORT T , PS_RD_CALLRPT_TXN TX , PS_RSF_OPPORTUNITY OP WHERE TX.REL_TXN_SYNCID = OP.SYNCID AND TX.RB_TRANSACTION_ID = 'OPPRT' AND TX.TXN_MARKET = 'GBL' AND T.CALL_REPORT_ID = TX.CALL_REPORT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
2 CALL_REPORT_ID Number(15,0) DECIMAL(15) NOT NULL Unique Identifier for Call Reports.

Default Value: 99999999

3 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
4 CALL_REPORT_DATE Date(10) DATE Date

Default Value: %date

5 CALLRPT_EVENT_TYPE Character(4) VARCHAR2(4) NOT NULL Call Report Event Type. Translate values: Meeting, Phone or Other.
MTG=Face to Face Meeting
OTHE=Other
PHON=Telephone

Default Value: MTG

6 CALLRPT_LOCATION Character(30) VARCHAR2(30) NOT NULL Location of the meeting being documented in the Call Report.
7 RELATED_TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskID field. Key for RB_TSK record. Used by Task Management.