BO_IDCALL_REPORT_IDMTG=Face to Face Meeting
OTHE=Other
PHON=Telephone
RD_PRSN_CALLRPT(SQL View) |
Index Back |
|---|---|
Person Call Report ViewThis is a view lists out all the call reports for persons. |
| SELECT A.BO_ID_CONTACT , B.CALL_REPORT_ID , B.DESCR30 , B.CALL_REPORT_DATE , B.CALLRPT_EVENT_TYPE , B.CALLRPT_LOCATION FROM PS_RD_CALLRPT_CONT A , PS_RD_CALL_REPORT B WHERE B.CALL_REPORT_ID = A.CALL_REPORT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 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 | CALL_REPORT_DATE | Date(10) | DATE | 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 |
| 6 | CALLRPT_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Location of the meeting being documented in the Call Report. |