OPRIDMTG=Face to Face Meeting
OTHE=Other
PHON=Telephone
RD_OPR_RPT_VW(SQL View) |
Index Back |
|---|---|
User's Call ReportsRetrieving Call Reports for different user. |
| SELECT A.OPRID , B.CALL_REPORT_ID , B.DESCR30 , B.CALLRPT_EVENT_TYPE , B.CALLRPT_LOCATION , B.CALL_REPORT_DATE FROM PS_RD_PRSN_OPR_VW A , PS_RD_CALL_REPORT B , PS_RD_CALLRPT_CONT C WHERE A.BO_ID = C.BO_ID_CONTACT AND B.CALL_REPORT_ID = C.CALL_REPORT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | CALL_REPORT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Unique Identifier for Call Reports. |
| 3 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | 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 |
| 5 | CALLRPT_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Location of the meeting being documented in the Call Report. |
| 6 | CALL_REPORT_DATE | Date(10) | DATE | Date |