RIM_CRPT_CONT(SQL View) |
Index Back |
---|---|
Call ReportDenormalized 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. |