ROF_OFFER_STOVW(SQL View) |
Index Back |
|---|---|
Offer History ViewView of the offer history table for use in 360 degree view. |
| SELECT A.ROF_OFFER_HIST_ID , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CNTCT , A.ROLE_TYPE_ID_CNTCT , 0 , A.SETID , A.RA_OFFER_ID , B.RA_OFFER_NAME , B.RA_OFFER_TYPE , A.ROF_OFFER_DISP_ID , A.ROF_OFFER_SCORE , A.ROW_ADDED_DTTM , 0 , 0 , 0 , 0 , O.OPRID , %subrec(RB_AUDIT_SBR,A) FROM PS_ROF_OFFER_HIST A , PS_RA_OFFER B , PS_SEC_SETID_OPR O WHERE B.SETID = A.SETID AND B.RA_OFFER_ID = A.RA_OFFER_ID AND A.SETID = O.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ROF_OFFER_HIST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Offer history ID |
| 2 | BO_ID_CUST |
Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 3 | ROLE_TYPE_ID_CUST |
Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 4 | BO_ID_CONTACT |
Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 5 | ROLE_TYPE_ID_CNTCT |
Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 6 | BO_ID_SITE | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 7 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 8 | RA_OFFER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Marketing Offer ID |
| 9 | RA_OFFER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Marketing Offer Name |
| 10 | RA_OFFER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Offer type is used to differentiate between Communication and Promotional Discount offers
C=Communication P=Promotional Discount |
| 11 | ROF_OFFER_DISP_ID | Character(4) | VARCHAR2(4) NOT NULL |
Offer disposition
ACPT=Offer Accepted ADVS=Went to Advisor Dialog BSCR=Went to Branch Script FOPP=Offer Deferred NOTP=Not Presented PRES=Presented, No Action Taken REJC=Offer Rejected |
| 12 | ROF_OFFER_SCORE | Number(6,2) | DECIMAL(5,2) NOT NULL | Offer score value |
| 13 | ROF_PRESENTED_DTTM | DateTime(26) | TIMESTAMP | Date and time at which an offer is presented |
| 14 | BO_ID_PARTNER | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID of Partner Company. |
| 15 | ROLE_TYPE_ID_PART | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the partner |
| 16 | BO_ID_PART_CONT | Signed Number(32,0) | DECIMAL(31) NOT NULL | This is the business object identifier for the partner contact. |
| 17 | ROLE_TYPE_ID_PARTC | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the partner contact |
| 18 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 19 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 20 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 21 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 22 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 23 | 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. |
| 24 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |