DBA Data[Home] [Help] [Dependency Information]

VIEW: AMS.AMS_DM_AGG_STG#

Object Details
Object Name: AMS_DM_AGG_STG#
Object Type: VIEW
Owner: AMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER
Yes
AGE NUMBER

DAYS_SINCE_LAST_SCHOOL NUMBER

DAYS_SINCE_LAST_EVENT NUMBER

NUM_TIMES_TARGETED NUMBER

LAST_TARGETED_CHANNEL_CODE NUMBER

TIMES_TARGETED_MONTH NUMBER

TIMES_TARGETED_3_MONTHS NUMBER

TIMES_TARGETED_6_MONTHS NUMBER

TIMES_TARGETED_12_MONTHS NUMBER

DAYS_SINCE_LAST_TARGETED NUMBER

AVG_DISC_OFFERED NUMBER

NUM_TYPES_DISC_OFFERED NUMBER

DAYS_SINCE_FIRST_CONTACT NUMBER

DAYS_SINCE_ACCT_ESTABLISHED NUMBER

DAYS_SINCE_ACCT_TERM NUMBER

DAYS_SINCE_ACCT_ACTIVATION NUMBER

DAYS_SINCE_ACCT_SUSPENDED NUMBER

NUM_TIMES_TARGETED_EMAIL NUMBER

NUM_TIMES_TARGETED_TELEMKT NUMBER

NUM_TIMES_TARGETED_DIRECT NUMBER

NUM_TGT_BY_OFFR_TYP1 NUMBER

NUM_TGT_BY_OFFR_TYP2 NUMBER

NUM_TGT_BY_OFFR_TYP3 NUMBER

NUM_TGT_BY_OFFR_TYP4 NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

AMS.AMS_DM_AGG_STG# references the following:

SchemaAMS
TableAMS_DM_AGG_STG
AMS.AMS_DM_AGG_STG# is referenced by following:

SchemaAPPS
SynonymAMS_DM_AGG_STG