RA_CM_METRIC_VW(SQL View) |
Index Back |
---|---|
Campaign Metrics RecordsView of campaign metric records - last sequence number for metric - metric id part of key |
SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_METRIC_ID , A.RA_FORECAST_AMT , A.RA_ACTUAL_AMT FROM PS_RA_CMPGN_METRIC A WHERE A.SEQNO =( SELECT MAX(SEQNO) FROM PS_RA_CMPGN_METRIC WHERE A.BUSINESS_UNIT = BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = RA_CAMPAIGN_ID AND A.RA_METRIC_ID = RA_METRIC_ID) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RA_NONVW |
2 | RA_CAMPAIGN_ID | Character(15) | VARCHAR2(15) NOT NULL | Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id. |
3 | RA_METRIC_ID | Character(15) | VARCHAR2(15) NOT NULL |
Metric ID
Prompt Table: RA_MET_CMPGN_VW |
4 | RA_FORECAST_AMT | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Marketing - Costs Amounts |
5 | RA_ACTUAL_AMT | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Campaign Actual Cost / Value |