[Home] [Help] [Dependency Information]
Object Name: | DDR_R_GEO_DEMOG# |
---|---|
Object Type: | VIEW |
Owner: | DDR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MFG_ORG_CD | VARCHAR2 | (30) | Yes | |
GEO_DEMOG_ID | NUMBER | Yes | ||
GEO_CD | VARCHAR2 | (30) | Yes | |
GEO_VAL | VARCHAR2 | (40) | Yes | |
GEO_DESC | VARCHAR2 | (240) | ||
ISO_CNTRY_CD | VARCHAR2 | (30) | ||
FMLY_TYP_CD | VARCHAR2 | (30) | ||
FMLY_TYP_CD_DESC | VARCHAR2 | (240) | ||
EDU_LVL_CD | VARCHAR2 | (30) | ||
EDU_LVL_CD_DESC | VARCHAR2 | (240) | ||
INDSTRY_CD | VARCHAR2 | (30) | ||
INDSTRY_CD_DESC | VARCHAR2 | (240) | ||
ANCSTRY_CD | VARCHAR2 | (30) | ||
ANCSTRY_CD_DESC | VARCHAR2 | (240) | ||
ML_TO_FML_RATIO | NUMBER | |||
URBN_TO_RURAL_RATIO | NUMBER | |||
MEDIAN_COMUT_TIME | NUMBER | |||
AUTO_AVLBLTY_NBR | VARCHAR2 | (30) | ||
TOT_POPLTN | NUMBER | |||
PVRTY_TOT | NUMBER | |||
RENT_TO_OWN_RATIO | NUMBER | |||
MEDIAN_RTRMNT_INCM | NUMBER | |||
AVG_RM_NBR_PER_HM | NUMBER | |||
AVG_HSNG_VAL | NUMBER | |||
AVG_HM_BLT_YR | NUMBER | |||
POPLTN_DNSTY | NUMBER | |||
POPLTN_DNSTY_UOM_CD | VARCHAR2 | (30) | ||
POPLTN_RATIO_WHT | NUMBER | |||
POPLTN_RATIO_BLK | NUMBER | |||
POPLTN_RATIO_ASIAN | NUMBER | |||
POPLTN_RATIO_HSPNIC | NUMBER | |||
POPLTN_RATIO_OTHR | NUMBER | |||
POPLTN_MEDIAN_AGE | NUMBER | |||
HH_MEDIAN_SZ | NUMBER | |||
HH_MEDIAN_INCM | NUMBER | |||
HH_AVG_INCM | NUMBER | |||
HH_PER_CPT_INCM | NUMBER | |||
ANNUAL_HTNG_DEG_DAYS | NUMBER | |||
ANNUAL_PRCPTN | NUMBER | |||
ANNUAL_AVG_SNOWFL | NUMBER | |||
AVG_NBR_OF_DAYS_SNOW | NUMBER | |||
AVG_NBR_OF_DAYS_CLR | NUMBER | |||
AVG_NBR_OF_DAYS_RAIN | NUMBER | |||
CRIME_INDX | NUMBER | |||
EFF_FROM_DT | DATE | Yes | ||
EFF_TO_DT | DATE | |||
SRC_SYS_IDNT | VARCHAR2 | (40) | Yes | |
SRC_SYS_DT | DATE | Yes | ||
CRTD_BY_DSR | VARCHAR2 | (30) | Yes | |
LAST_UPDT_BY_DSR | VARCHAR2 | (30) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT MFG_ORG_CD
, GEO_DEMOG_ID
, GEO_CD
, GEO_VAL
, GEO_DESC
, ISO_CNTRY_CD
, FMLY_TYP_CD
, FMLY_TYP_CD_DESC
, EDU_LVL_CD
, EDU_LVL_CD_DESC
, INDSTRY_CD
, INDSTRY_CD_DESC
, ANCSTRY_CD
, ANCSTRY_CD_DESC
, ML_TO_FML_RATIO
, URBN_TO_RURAL_RATIO
, MEDIAN_COMUT_TIME
, AUTO_AVLBLTY_NBR
, TOT_POPLTN
, PVRTY_TOT
, RENT_TO_OWN_RATIO
, MEDIAN_RTRMNT_INCM
, AVG_RM_NBR_PER_HM
, AVG_HSNG_VAL
, AVG_HM_BLT_YR
, POPLTN_DNSTY
, POPLTN_DNSTY_UOM_CD
, POPLTN_RATIO_WHT
, POPLTN_RATIO_BLK
, POPLTN_RATIO_ASIAN
, POPLTN_RATIO_HSPNIC
, POPLTN_RATIO_OTHR
, POPLTN_MEDIAN_AGE
, HH_MEDIAN_SZ
, HH_MEDIAN_INCM
, HH_AVG_INCM
, HH_PER_CPT_INCM
, ANNUAL_HTNG_DEG_DAYS
, ANNUAL_PRCPTN
, ANNUAL_AVG_SNOWFL
, AVG_NBR_OF_DAYS_SNOW
, AVG_NBR_OF_DAYS_CLR
, AVG_NBR_OF_DAYS_RAIN
, CRIME_INDX
, EFF_FROM_DT
, EFF_TO_DT
, SRC_SYS_IDNT
, SRC_SYS_DT
, CRTD_BY_DSR
, LAST_UPDT_BY_DSR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM DDR.DDR_R_GEO_DEMOG#;
|
|
|