Search Results cong_dist_code

Overview

AMS_DM_GEN_STG is a staging table owned by the AMS (Marketing) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as the generic detail container for party-level information used by the Mining Collection Pack, holding enriched attribute rows that correspond to records in AMS_DM_DRV_STG. In the Oracle EBS data model, staging tables such as this one are populated by concurrent collection programs that gather prospect, customer, and business data from internal and third-party sources before it is validated, deduplicated, and promoted to the operational marketing tables.

The documented object is classified as VALID and exposes 102 columns in the 12.2.2 physical schema. The ETRM metadata assigns a heuristic Data Vault classification of standalone, meaning the table has no mined foreign key relationships to other objects within the documented structure. As a modeling suggestion, this positions AMS_DM_GEN_STG as neither a classic hub, link, nor satellite, but rather as an isolated staging artifact whose primary key (PARTY_ID) acts as both the surrogate identifier and the natural business key candidate.

Key Information Stored

The table is anchored by its primary key constraint AMS_DM_GEN_STG_PK on PARTY_ID, which is also the sole unique index (AMS_DM_GEN_STG_U1) and therefore the only documented business-key candidate. Among the 102 columns, the most operationally significant fall into several groups:

Party identification: PARTY_ID, PARTY_NAME, PARTY_TYPE, PERSON_FIRST_NAME, PERSON_LAST_NAME, PERSON_TITLE, and ORGANIZATION_TYPE.
Demographic and household attributes: GENDER, ETHNICITY, MARITAL_STATUS, HOUSEHOLD_INCOME, HOUSEHOLD_SIZE, PRESENCE_OF_CHILDREN, and DEGREE_RECEIVED.
Location: ADDRESS1, ADDRESS2, CITY, STATE, PROVINCE, COUNTY, COUNTRY, and ZIP_CODE.
Credit and risk scoring: PAYDEX_SCORE_YEAR, DNB_SCORE, GLOBAL_FAILURE_SCORE, CUSTOMER_QUALITY_RANK, CREDIT_RATING, RISK_CODE, HIGH_CREDIT, and MAXIMUM_CREDIT_RECOMMENDATION.
Business classification: SIC_CODE1, NUM_OF_EMPLOYEES, YEAR_ESTABLISHED, LEGAL_STATUS, MINORITY_BUSINESS_FLAG, SMALL_BUSINESS_FLAG, WOMEN_OWNED_BUS_FLAG, and GOV_ORG_FLAG.
Contact and analysis metadata: EMAIL_ADDRESS, ANALYSIS_FY, LINE_OF_BUSINESS, and INTERNAL_FLAG.

Together these columns supply the enrichment payload that mining processes evaluate when scoring or segmenting a party.

Common Use Cases and Queries

Typical usage centers on inspecting or troubleshooting a mining collection run before data is promoted out of staging. Analysts often retrieve the most recently loaded attribute set for a set of parties, or validate that demographic and credit fields were populated correctly.

Lookup by business key: SELECT * FROM AMS.AMS_DM_GEN_STG WHERE PARTY_ID = :p_party_id;
Credit-review reporting: SELECT PARTY_ID, PARTY_NAME, DNB_SCORE, GLOBAL_FAILURE_SCORE, CREDIT_RATING FROM AMS.AMS_DM_GEN_STG WHERE CREDIT_RATING IS NOT NULL ORDER BY DNB_SCORE DESC;
Segmentation by business attributes: SELECT PARTY_ID, SIC_CODE1, NUM_OF_EMPLOYEES FROM AMS.AMS_DM_GEN_STG WHERE SMALL_BUSINESS_FLAG = 'Y' AND WOMEN_OWNED_BUS_FLAG = 'Y';
Data-quality checks confirming staging completeness prior to promotion.

Because the table is transient, reports should generally read from the post-staging target rather than this object.

Related Objects

The metadata documents AMS_DM_GEN_STG as standalone with no mined foreign keys, so relationships are functional rather than enforced. The most significant associated objects are:

AMS_DM_DRV_STG — the companion staging table whose rows are detailed by records in this table; PARTY_ID is the logical join key.
AMS_DM_DRV_TP_STG and other mining staging tables sharing the PARTY_ID convention within the Mining Collection Pack.
HZ_PARTIES — the master party entity that PARTY_ID ultimately resolves to after promotion.
HZ_CUST_ACCOUNTS and HZ_LOCATIONS — customer and address entities populated from the location and party columns.
AMS_DM_GEN_STG_PK / AMS_DM_GEN_STG_U1 — the primary key and unique index that enforce PARTY_ID uniqueness.
Mining collection concurrent programs that truncate, load, and extract this staging table.

These dependencies confirm the table's role as a transient enrichment buffer within the AMS marketing mining pipeline.

Table: AMS_DM_GEN_STG 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DM_GEN_STG, object_name:AMS_DM_GEN_STG, status:VALID, product: AMS - Marketing , description: Container for the generic details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack. This is a staging table. , implementation_dba_data: AMS.AMS_DM_GEN_STG ,
Table: AMS_DM_GEN_STG 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DM_GEN_STG, object_name:AMS_DM_GEN_STG, status:VALID, product: AMS - Marketing , description: Container for the generic details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack. This is a staging table. , implementation_dba_data: AMS.AMS_DM_GEN_STG ,
Table: AMS_DM_PARTY_DETAILS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DM_PARTY_DETAILS, object_name:AMS_DM_PARTY_DETAILS, status:VALID, product: AMS - Marketing , description: Container for the generic details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack. This is a staging table. , implementation_dba_data: AMS.AMS_DM_PARTY_DETAILS ,
Table: AMS_DM_PARTY_DETAILS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DM_PARTY_DETAILS, object_name:AMS_DM_PARTY_DETAILS, status:VALID, product: AMS - Marketing , description: Container for the generic details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack. This is a staging table. , implementation_dba_data: AMS.AMS_DM_PARTY_DETAILS ,
View: AMS_P_ORG_PROFILES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_P_ORG_PROFILES_V, object_name:AMS_P_ORG_PROFILES_V, status:VALID, product: AMS - Marketing , description: This public view returns an organization profile for an organization. Used for list generation. , implementation_dba_data: APPS.AMS_P_ORG_PROFILES_V ,
View: AMS_ORG_PROFILES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_ORG_PROFILES_V, object_name:AMS_ORG_PROFILES_V, status:VALID, product: AMS - Marketing , description: This public view returns an organization profile for an organization. Used for list generation. , implementation_dba_data: APPS.AMS_ORG_PROFILES_V ,
View: AMS_P_ORG_PROFILES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_P_ORG_PROFILES_V, object_name:AMS_P_ORG_PROFILES_V, status:VALID, product: AMS - Marketing , description: This public view returns an organization profile for an organization. Used for list generation. , implementation_dba_data: APPS.AMS_P_ORG_PROFILES_V ,
View: AMS_ORG_PROFILES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_ORG_PROFILES_V, object_name:AMS_ORG_PROFILES_V, status:VALID, product: AMS - Marketing , description: This public view returns an organization profile for an organization. Used for list generation. , implementation_dba_data: APPS.AMS_ORG_PROFILES_V ,
View: AMS_DM_ORGANIZATIONS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_DM_ORGANIZATIONS_V, object_name:AMS_DM_ORGANIZATIONS_V, status:VALID, product: AMS - Marketing , description: This view is no longer used for seeded data sources. (15-Jul-2004)View used by the seeded data mining data source for organizations and organization contacts in the Trading Community Architecture. , implementation_dba_data: APPS.AMS_DM_ORGANIZATIONS_V ,
View: AMS_DM_ORGANIZATIONS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_DM_ORGANIZATIONS_V, object_name:AMS_DM_ORGANIZATIONS_V, status:VALID, product: AMS - Marketing , description: This view is no longer used for seeded data sources. (15-Jul-2004)View used by the seeded data mining data source for organizations and organization contacts in the Trading Community Architecture. , implementation_dba_data: APPS.AMS_DM_ORGANIZATIONS_V ,
View: AMS_LT_ORG_PROFILES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_LT_ORG_PROFILES_V, object_name:AMS_LT_ORG_PROFILES_V, status:VALID, product: AMS - Marketing , description: Data Source view based on hz_organization_profiles , implementation_dba_data: APPS.AMS_LT_ORG_PROFILES_V ,
View: AMS_LT_ORG_PROFILES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_LT_ORG_PROFILES_V, object_name:AMS_LT_ORG_PROFILES_V, status:VALID, product: AMS - Marketing , description: Data Source view based on hz_organization_profiles , implementation_dba_data: APPS.AMS_LT_ORG_PROFILES_V ,
View: AMS_ORG_DETAILS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_ORG_DETAILS_V, object_name:AMS_ORG_DETAILS_V, status:VALID, product: AMS - Marketing , description: This view list the details of an Organization , implementation_dba_data: APPS.AMS_ORG_DETAILS_V ,
View: AMS_ORG_DETAILS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_ORG_DETAILS_V, object_name:AMS_ORG_DETAILS_V, status:VALID, product: AMS - Marketing , description: This view list the details of an Organization , implementation_dba_data: APPS.AMS_ORG_DETAILS_V ,