RD_CR_SUSRRE_VW(SQL View) |
Index Back |
---|---|
Call Reports as Wealth UserCall Reports as Wealth Management User (Referral Owner). View. Used for Data Distribution rules in Call Report List page. |
SELECT T.CALL_REPORT_ID ,T.SYNCID , T.SYNCDTTM , P.PERSON_ID FROM PS_RD_CALL_REPORT T , PS_RD_CALLRPT_TXN TA , PS_RSF_LEAD LE , PS_RD_PERSON P WHERE T.CALL_REPORT_ID = TA.CALL_REPORT_ID AND TA.REL_TXN_SYNCID = LE.SYNCID AND LE.PERSON_ID = P.PERSON_ID AND T.APPLICATION_USAGE IN ('SALS') AND LE.REFERRAL_FLG = 'Y' |
# | 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 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
3 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
4 | PERSON_ID_USER | Character(15) | VARCHAR2(15) NOT NULL | Person ID |