eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: AMS.AMS_DM_AGG_STG#

Source

View Text - Preformatted


select PARTY_ID PARTY_ID, AGE AGE, DAYS_SINCE_LAST_SCHOOL DAYS_SINCE_LAST_SCHOOL, DAYS_SINCE_LAST_EVENT DAYS_SINCE_LAST_EVENT, NUM_TIMES_TARGETED NUM_TIMES_TARGETED, LAST_TARGETED_CHANNEL_CODE LAST_TARGETED_CHANNEL_CODE, TIMES_TARGETED_MONTH TIMES_TARGETED_MONTH, TIMES_TARGETED_3_MONTHS TIMES_TARGETED_3_MONTHS, TIMES_TARGETED_6_MONTHS TIMES_TARGETED_6_MONTHS, TIMES_TARGETED_12_MONTHS TIMES_TARGETED_12_MONTHS, DAYS_SINCE_LAST_TARGETED DAYS_SINCE_LAST_TARGETED, AVG_DISC_OFFERED AVG_DISC_OFFERED, NUM_TYPES_DISC_OFFERED NUM_TYPES_DISC_OFFERED, DAYS_SINCE_FIRST_CONTACT DAYS_SINCE_FIRST_CONTACT, DAYS_SINCE_ACCT_ESTABLISHED DAYS_SINCE_ACCT_ESTABLISHED, DAYS_SINCE_ACCT_TERM DAYS_SINCE_ACCT_TERM, DAYS_SINCE_ACCT_ACTIVATION DAYS_SINCE_ACCT_ACTIVATION, DAYS_SINCE_ACCT_SUSPENDED DAYS_SINCE_ACCT_SUSPENDED, NUM_TIMES_TARGETED_EMAIL NUM_TIMES_TARGETED_EMAIL, NUM_TIMES_TARGETED_TELEMKT NUM_TIMES_TARGETED_TELEMKT, NUM_TIMES_TARGETED_DIRECT NUM_TIMES_TARGETED_DIRECT, NUM_TGT_BY_OFFR_TYP1 NUM_TGT_BY_OFFR_TYP1, NUM_TGT_BY_OFFR_TYP2 NUM_TGT_BY_OFFR_TYP2, NUM_TGT_BY_OFFR_TYP3 NUM_TGT_BY_OFFR_TYP3, NUM_TGT_BY_OFFR_TYP4 NUM_TGT_BY_OFFR_TYP4 from "AMS"."AMS_DM_AGG_STG"

View Text - HTML Formatted

SELECT PARTY_ID PARTY_ID
, AGE AGE
, DAYS_SINCE_LAST_SCHOOL DAYS_SINCE_LAST_SCHOOL
, DAYS_SINCE_LAST_EVENT DAYS_SINCE_LAST_EVENT
, NUM_TIMES_TARGETED NUM_TIMES_TARGETED
, LAST_TARGETED_CHANNEL_CODE LAST_TARGETED_CHANNEL_CODE
, TIMES_TARGETED_MONTH TIMES_TARGETED_MONTH
, TIMES_TARGETED_3_MONTHS TIMES_TARGETED_3_MONTHS
, TIMES_TARGETED_6_MONTHS TIMES_TARGETED_6_MONTHS
, TIMES_TARGETED_12_MONTHS TIMES_TARGETED_12_MONTHS
, DAYS_SINCE_LAST_TARGETED DAYS_SINCE_LAST_TARGETED
, AVG_DISC_OFFERED AVG_DISC_OFFERED
, NUM_TYPES_DISC_OFFERED NUM_TYPES_DISC_OFFERED
, DAYS_SINCE_FIRST_CONTACT DAYS_SINCE_FIRST_CONTACT
, DAYS_SINCE_ACCT_ESTABLISHED DAYS_SINCE_ACCT_ESTABLISHED
, DAYS_SINCE_ACCT_TERM DAYS_SINCE_ACCT_TERM
, DAYS_SINCE_ACCT_ACTIVATION DAYS_SINCE_ACCT_ACTIVATION
, DAYS_SINCE_ACCT_SUSPENDED DAYS_SINCE_ACCT_SUSPENDED
, NUM_TIMES_TARGETED_EMAIL NUM_TIMES_TARGETED_EMAIL
, NUM_TIMES_TARGETED_TELEMKT NUM_TIMES_TARGETED_TELEMKT
, NUM_TIMES_TARGETED_DIRECT NUM_TIMES_TARGETED_DIRECT
, NUM_TGT_BY_OFFR_TYP1 NUM_TGT_BY_OFFR_TYP1
, NUM_TGT_BY_OFFR_TYP2 NUM_TGT_BY_OFFR_TYP2
, NUM_TGT_BY_OFFR_TYP3 NUM_TGT_BY_OFFR_TYP3
, NUM_TGT_BY_OFFR_TYP4 NUM_TGT_BY_OFFR_TYP4
FROM "AMS"."AMS_DM_AGG_STG"