RA_DBOFFER_VW(SQL View) |
Index Back |
|---|---|
Offer View for dashboardOffer view for generating information for dashboard |
| SELECT A.SETID , A.RA_OFFER_ID , A.RA_OFFER_NAME , A.RA_OFFER_TYPE , X.XLATLONGNAME , A.RA_OFFER_STATUS , XX.XLATSHORTNAME , A.START_DATE , A.END_DATE FROM PS_RA_OFFER A , PSXLATITEM X , PSXLATITEM XX WHERE X.FIELDNAME = 'RA_OFFER_TYPE' AND X.EFF_STATUS = 'A' AND A.RA_OFFER_TYPE = X.FIELDVALUE AND XX.FIELDNAME = 'RA_OFFER_STATUS' AND XX.EFF_STATUS = 'A' AND A.RA_OFFER_STATUS = XX.FIELDVALUE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | RA_OFFER_ID | Character(15) | VARCHAR2(15) NOT NULL | Marketing Offer ID |
| 3 | RA_OFFER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Marketing Offer Name |
| 4 | 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 |
| 5 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 6 | RA_OFFER_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Marketing Offer status
ARCH=Archived CMPL=Completed DECL=Declined IREV=In Review NEW=New PLAN=Planning |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 9 | END_DATE | Date(10) | DATE | End date field to store an end date. |