RIM_CRPT_CONT

(SQL View)
Index Back

Call Report

Denormalized datastucture for Call Report Contact data model. This view is used for get last updated date time for parent child rows.

SELECT A.CALL_REPORT_ID , A.DESCR30 , A.CALL_REPORT_DATE , A.CALLRPT_EVENT_TYPE , B.PERSON_ID , B.BO_ID_CONTACT , A.ROW_LASTMANT_DTTM , B.ROW_LASTMANT_DTTM , C.ROW_LASTMANT_DTTM FROM PS_RD_CALLRPT_CONT B LEFT OUTER JOIN PS_RD_CALL_REPORT A ON B.CALL_REPORT_ID = A.CALL_REPORT_ID LEFT OUTER JOIN PS_RD_CALLRPT_NOTE C ON B.CALL_REPORT_ID = C.CALL_REPORT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CALL_REPORT_ID Number(15,0) DECIMAL(15) NOT NULL Unique Identifier for Call Reports.
2 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
3 CALL_REPORT_DATE Date(10) DATE Date
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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
6 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
7 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
8 ROW_CRCTLASTM_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
9 ROW_CRNTLASTM_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.