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_GEN_STG#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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