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.

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

TABLE: AMS.AMS_DM_GEN_STG_GT

Object Details

Object Name:	AMS_DM_GEN_STG_GT
Object Type:	TABLE
Owner:	AMS
Subobject Name:
Status:	VALID

Temporary Table Details

AMS.AMS_DM_GEN_STG_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_DM_GEN_STG_GT_U1	NORMAL	UNIQUE		PARTY_ID

Columns

Name	Datatype	Length	Mandatory
PARTY_ID	NUMBER		Yes
PARTY_TYPE	VARCHAR2	(30)
GENDER	VARCHAR2	(30)
ETHNICITY	VARCHAR2	(60)
MARITAL_STATUS	VARCHAR2	(30)
PERSONAL_INCOME	NUMBER
HOH_FLAG	VARCHAR2	(1)
HOUSEHOLD_INCOME	NUMBER
HOUSEHOLD_SIZE	NUMBER
APARTMENT_FLAG	VARCHAR2	(1)
RENT_FLAG	VARCHAR2	(1)
DEGREE_RECEIVED	VARCHAR2	(1)
SCHOOL_TYPE	VARCHAR2	(60)
EMPLOYED_FLAG	VARCHAR2	(1)
YEARS_EMPLOYED	NUMBER
OCCUPATION	VARCHAR2	(60)
MILITARY_BRANCH	VARCHAR2	(80)
RESIDENCE_TYPE	VARCHAR2	(30)
RESIDENT_LENGTH	NUMBER
PRESENCE_OF_CHILDREN	NUMBER
COUNTRY	VARCHAR2	(60)
STATE	VARCHAR2	(60)
PROVINCE	VARCHAR2	(60)
COUNTY	VARCHAR2	(60)
ZIP_CODE	VARCHAR2	(60)
REFERENCE_USE_FLAG	VARCHAR2	(1)
PAYDEX_SCORE_YEAR	NUMBER
PAYDEX_SCORE_3_MONTH_AGO	NUMBER
INDUSTRY_PAYDEX_MEDIAN	NUMBER
GLOBAL_FAILURE_SCORE	VARCHAR2	(5)
DNB_SCORE	VARCHAR2	(5)
OUT_OF_BUSINESS_FLAG	VARCHAR2	(1)
CUSTOMER_QUALITY_RANK	NUMBER
FORTUNE_500_RANK	NUMBER
NUM_OF_EMPLOYEES	NUMBER
LEGAL_STATUS	VARCHAR2	(30)
YEAR_ESTABLISHED	NUMBER
SIC_CODE1	VARCHAR2	(30)
MINORITY_BUSINESS_FLAG	VARCHAR2	(1)
SMALL_BUSINESS_FLAG	VARCHAR2	(1)
WOMEN_OWNED_BUS_FLAG	VARCHAR2	(1)
GOV_ORG_FLAG	VARCHAR2	(1)
HQ_SUBSIDIARY_FLAG	VARCHAR2	(1)
FOREIGN_OWNED_FLAG	VARCHAR2	(1)
IMPORT_EXPORT_BUS_FLAG	VARCHAR2	(1)
CREDIT_CHECK_FLAG	VARCHAR2	(1)
TOLERANCE	NUMBER
DISCOUNT_TERMS_FLAG	VARCHAR2	(1)
DUNNING_LETTERS_FLAG	VARCHAR2	(1)
INTEREST_CHARGES_FLAG	VARCHAR2	(1)
SEND_STATEMENTS_FLAG	VARCHAR2	(1)
CREDIT_HOLD_FLAG	VARCHAR2	(1)
CREDIT_RATING	VARCHAR2	(60)
RISK_CODE	VARCHAR2	(60)
INTEREST_PERIOD_DAYS	NUMBER
PAYMENT_GRACE_DAYS	NUMBER
EMAIL_ADDRESS	VARCHAR2	(2000)
ADDRESS1	VARCHAR2	(240)
ADDRESS2	VARCHAR2	(240)
COMPETITOR_FLAG	VARCHAR2	(1)
THIRD_PARTY_FLAG	VARCHAR2	(1)
PERSON_FIRST_NAME	VARCHAR2	(150)
PERSON_MIDDLE_NAME	VARCHAR2	(60)
PERSON_LAST_NAME	VARCHAR2	(150)
PERSON_NAME_SUFFIX	VARCHAR2	(30)
PERSON_TITLE	VARCHAR2	(60)
PERSON_ACADEMIC_TITLE	VARCHAR2	(30)
PERSON_PRE_NAME_ADJUNCT	VARCHAR2	(30)
CONTROL_YR	NUMBER
LINE_OF_BUSINESS	VARCHAR2	(240)
CONG_DIST_CODE	VARCHAR2	(2)
LABOR_SURPLUS_FLAG	VARCHAR2	(1)
DEBARMENT_FLAG	VARCHAR2	(1)
DISADV_8A_FLAG	VARCHAR2	(1)
DEBARMENTS_COUNT	NUMBER
MONTHS_SINCE_LAST_DEBARMENT	NUMBER
GSA_INDICATOR_FLAG	VARCHAR2	(1)
ANALYSIS_FY	VARCHAR2	(5)
FISCAL_YEAREND_MONTH	VARCHAR2	(30)
CURR_FY_POTENTIAL_REVENUE	NUMBER
NEXT_FY_POTENTIAL_REVENUE	NUMBER
ORGANIZATION_TYPE	VARCHAR2	(30)
BUSINESS_SCOPE	VARCHAR2	(20)
CORPORATION_CLASS	VARCHAR2	(60)
REGISTRATION_TYPE	VARCHAR2	(30)
INCORP_YEAR	NUMBER
PUBLIC_PRIVATE_OWNERSHIP_FLAG	VARCHAR2	(1)
INTERNAL_FLAG	VARCHAR2	(1)
HIGH_CREDIT	NUMBER
AVG_HIGH_CREDIT	NUMBER
TOTAL_PAYMENTS	NUMBER
CREDIT_SCORE_CLASS	NUMBER
CREDIT_SCORE_NATL_PERCENTILE	NUMBER
CREDIT_SCORE_INCD_DEFAULT	NUMBER
CREDIT_SCORE_AGE	NUMBER
FAILURE_SCORE_CLASS	NUMBER
FAILURE_SCORE_INCD_DEFAULT	NUMBER
FAILURE_SCORE_AGE	NUMBER
MAXIMUM_CREDIT_RECOMMENDATION	NUMBER
MAXIMUM_CREDIT_CURRENCY_CODE	VARCHAR2	(240)
PARTY_NAME	VARCHAR2	(360)
CITY	VARCHAR2	(120)

Query Text

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


SELECT PARTY_ID
,      PARTY_TYPE
,      GENDER
,      ETHNICITY
,      MARITAL_STATUS
,      PERSONAL_INCOME
,      HOH_FLAG
,      HOUSEHOLD_INCOME
,      HOUSEHOLD_SIZE
,      APARTMENT_FLAG
,      RENT_FLAG
,      DEGREE_RECEIVED
,      SCHOOL_TYPE
,      EMPLOYED_FLAG
,      YEARS_EMPLOYED
,      OCCUPATION
,      MILITARY_BRANCH
,      RESIDENCE_TYPE
,      RESIDENT_LENGTH
,      PRESENCE_OF_CHILDREN
,      COUNTRY
,      STATE
,      PROVINCE
,      COUNTY
,      ZIP_CODE
,      REFERENCE_USE_FLAG
,      PAYDEX_SCORE_YEAR
,      PAYDEX_SCORE_3_MONTH_AGO
,      INDUSTRY_PAYDEX_MEDIAN
,      GLOBAL_FAILURE_SCORE
,      DNB_SCORE
,      OUT_OF_BUSINESS_FLAG
,      CUSTOMER_QUALITY_RANK
,      FORTUNE_500_RANK
,      NUM_OF_EMPLOYEES
,      LEGAL_STATUS
,      YEAR_ESTABLISHED
,      SIC_CODE1
,      MINORITY_BUSINESS_FLAG
,      SMALL_BUSINESS_FLAG
,      WOMEN_OWNED_BUS_FLAG
,      GOV_ORG_FLAG
,      HQ_SUBSIDIARY_FLAG
,      FOREIGN_OWNED_FLAG
,      IMPORT_EXPORT_BUS_FLAG
,      CREDIT_CHECK_FLAG
,      TOLERANCE
,      DISCOUNT_TERMS_FLAG
,      DUNNING_LETTERS_FLAG
,      INTEREST_CHARGES_FLAG
,      SEND_STATEMENTS_FLAG
,      CREDIT_HOLD_FLAG
,      CREDIT_RATING
,      RISK_CODE
,      INTEREST_PERIOD_DAYS
,      PAYMENT_GRACE_DAYS
,      EMAIL_ADDRESS
,      ADDRESS1
,      ADDRESS2
,      COMPETITOR_FLAG
,      THIRD_PARTY_FLAG
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_TITLE
,      PERSON_ACADEMIC_TITLE
,      PERSON_PRE_NAME_ADJUNCT
,      CONTROL_YR
,      LINE_OF_BUSINESS
,      CONG_DIST_CODE
,      LABOR_SURPLUS_FLAG
,      DEBARMENT_FLAG
,      DISADV_8A_FLAG
,      DEBARMENTS_COUNT
,      MONTHS_SINCE_LAST_DEBARMENT
,      GSA_INDICATOR_FLAG
,      ANALYSIS_FY
,      FISCAL_YEAREND_MONTH
,      CURR_FY_POTENTIAL_REVENUE
,      NEXT_FY_POTENTIAL_REVENUE
,      ORGANIZATION_TYPE
,      BUSINESS_SCOPE
,      CORPORATION_CLASS
,      REGISTRATION_TYPE
,      INCORP_YEAR
,      PUBLIC_PRIVATE_OWNERSHIP_FLAG
,      INTERNAL_FLAG
,      HIGH_CREDIT
,      AVG_HIGH_CREDIT
,      TOTAL_PAYMENTS
,      CREDIT_SCORE_CLASS
,      CREDIT_SCORE_NATL_PERCENTILE
,      CREDIT_SCORE_INCD_DEFAULT
,      CREDIT_SCORE_AGE
,      FAILURE_SCORE_CLASS
,      FAILURE_SCORE_INCD_DEFAULT
,      FAILURE_SCORE_AGE
,      MAXIMUM_CREDIT_RECOMMENDATION
,      MAXIMUM_CREDIT_CURRENCY_CODE
,      PARTY_NAME
,      CITY
FROM AMS.AMS_DM_GEN_STG_GT;

Dependencies

[top of page]

AMS.AMS_DM_GEN_STG_GT does not reference any database object

AMS.AMS_DM_GEN_STG_GT is referenced by following:

APPS: AMS_DM_GEN_STG_GT