VIEW: DDR.DDR_E_GEO_DEMOG#

Source

View Text - Preformatted

select REC_ID REC_ID, MFG_ORG_CD MFG_ORG_CD, GEO_CD GEO_CD, GEO_VAL GEO_VAL, GEO_DESC GEO_DESC, ISO_CNTRY_CD ISO_CNTRY_CD, FMLY_TYP_CD FMLY_TYP_CD, FMLY_TYP_CD_DESC FMLY_TYP_CD_DESC, EDU_LVL_CD EDU_LVL_CD, EDU_LVL_CD_DESC EDU_LVL_CD_DESC, INDSTRY_CD INDSTRY_CD, INDSTRY_CD_DESC INDSTRY_CD_DESC, ANCSTRY_CD ANCSTRY_CD, ANCSTRY_CD_DESC ANCSTRY_CD_DESC, ML_TO_FML_RATIO ML_TO_FML_RATIO, URBN_TO_RURAL_RATIO URBN_TO_RURAL_RATIO, MEDIAN_COMUT_TIME MEDIAN_COMUT_TIME, AUTO_AVLBLTY_NBR AUTO_AVLBLTY_NBR, TOT_POPLTN TOT_POPLTN, PVRTY_TOT PVRTY_TOT, RENT_TO_OWN_RATIO RENT_TO_OWN_RATIO, MEDIAN_RTRMNT_INCM MEDIAN_RTRMNT_INCM, AVG_RM_NBR_PER_HM AVG_RM_NBR_PER_HM, AVG_HSNG_VAL AVG_HSNG_VAL, AVG_HM_BLT_YR AVG_HM_BLT_YR, POPLTN_DNSTY POPLTN_DNSTY, POPLTN_DNSTY_UOM_CD POPLTN_DNSTY_UOM_CD, POPLTN_RATIO_WHT POPLTN_RATIO_WHT, POPLTN_RATIO_BLK POPLTN_RATIO_BLK, POPLTN_RATIO_ASIAN POPLTN_RATIO_ASIAN, POPLTN_RATIO_HSPNIC POPLTN_RATIO_HSPNIC, POPLTN_RATIO_OTHR POPLTN_RATIO_OTHR, POPLTN_MEDIAN_AGE POPLTN_MEDIAN_AGE, HH_MEDIAN_SZ HH_MEDIAN_SZ, HH_MEDIAN_INCM HH_MEDIAN_INCM, HH_AVG_INCM HH_AVG_INCM, HH_PER_CPT_INCM HH_PER_CPT_INCM, ANNUAL_HTNG_DEG_DAYS ANNUAL_HTNG_DEG_DAYS, ANNUAL_PRCPTN ANNUAL_PRCPTN, ANNUAL_AVG_SNOWFL ANNUAL_AVG_SNOWFL, AVG_NBR_OF_DAYS_SNOW AVG_NBR_OF_DAYS_SNOW, AVG_NBR_OF_DAYS_CLR AVG_NBR_OF_DAYS_CLR, AVG_NBR_OF_DAYS_RAIN AVG_NBR_OF_DAYS_RAIN, CRIME_INDX CRIME_INDX, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, ERR_REASON ERR_REASON, ACTION_FLAG ACTION_FLAG, LOAD_ID LOAD_ID from "DDR"."DDR_E_GEO_DEMOG"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, MFG_ORG_CD MFG_ORG_CD
, GEO_CD GEO_CD
, GEO_VAL GEO_VAL
, GEO_DESC GEO_DESC
, ISO_CNTRY_CD ISO_CNTRY_CD
, FMLY_TYP_CD FMLY_TYP_CD
, FMLY_TYP_CD_DESC FMLY_TYP_CD_DESC
, EDU_LVL_CD EDU_LVL_CD
, EDU_LVL_CD_DESC EDU_LVL_CD_DESC
, INDSTRY_CD INDSTRY_CD
, INDSTRY_CD_DESC INDSTRY_CD_DESC
, ANCSTRY_CD ANCSTRY_CD
, ANCSTRY_CD_DESC ANCSTRY_CD_DESC
, ML_TO_FML_RATIO ML_TO_FML_RATIO
, URBN_TO_RURAL_RATIO URBN_TO_RURAL_RATIO
, MEDIAN_COMUT_TIME MEDIAN_COMUT_TIME
, AUTO_AVLBLTY_NBR AUTO_AVLBLTY_NBR
, TOT_POPLTN TOT_POPLTN
, PVRTY_TOT PVRTY_TOT
, RENT_TO_OWN_RATIO RENT_TO_OWN_RATIO
, MEDIAN_RTRMNT_INCM MEDIAN_RTRMNT_INCM
, AVG_RM_NBR_PER_HM AVG_RM_NBR_PER_HM
, AVG_HSNG_VAL AVG_HSNG_VAL
, AVG_HM_BLT_YR AVG_HM_BLT_YR
, POPLTN_DNSTY POPLTN_DNSTY
, POPLTN_DNSTY_UOM_CD POPLTN_DNSTY_UOM_CD
, POPLTN_RATIO_WHT POPLTN_RATIO_WHT
, POPLTN_RATIO_BLK POPLTN_RATIO_BLK
, POPLTN_RATIO_ASIAN POPLTN_RATIO_ASIAN
, POPLTN_RATIO_HSPNIC POPLTN_RATIO_HSPNIC
, POPLTN_RATIO_OTHR POPLTN_RATIO_OTHR
, POPLTN_MEDIAN_AGE POPLTN_MEDIAN_AGE
, HH_MEDIAN_SZ HH_MEDIAN_SZ
, HH_MEDIAN_INCM HH_MEDIAN_INCM
, HH_AVG_INCM HH_AVG_INCM
, HH_PER_CPT_INCM HH_PER_CPT_INCM
, ANNUAL_HTNG_DEG_DAYS ANNUAL_HTNG_DEG_DAYS
, ANNUAL_PRCPTN ANNUAL_PRCPTN
, ANNUAL_AVG_SNOWFL ANNUAL_AVG_SNOWFL
, AVG_NBR_OF_DAYS_SNOW AVG_NBR_OF_DAYS_SNOW
, AVG_NBR_OF_DAYS_CLR AVG_NBR_OF_DAYS_CLR
, AVG_NBR_OF_DAYS_RAIN AVG_NBR_OF_DAYS_RAIN
, CRIME_INDX CRIME_INDX
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, ERR_REASON ERR_REASON
, ACTION_FLAG ACTION_FLAG
, LOAD_ID LOAD_ID
FROM "DDR"."DDR_E_GEO_DEMOG"