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]

VIEW: DDR.DDR_E_GEO_DEMOG#

Object Details

Object Name:	DDR_E_GEO_DEMOG#
Object Type:	VIEW
Owner:	DDR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
REC_ID	NUMBER		Yes
MFG_ORG_CD	VARCHAR2	(30)
GEO_CD	VARCHAR2	(30)
GEO_VAL	VARCHAR2	(40)
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
SRC_SYS_IDNT	VARCHAR2	(40)	Yes
SRC_SYS_DT	DATE		Yes
ERR_REASON	VARCHAR2	(500)	Yes
ACTION_FLAG	VARCHAR2	(1)	Yes
LOAD_ID	NUMBER		Yes

Query Text

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


SELECT REC_ID
,      MFG_ORG_CD
,      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
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      ERR_REASON
,      ACTION_FLAG
,      LOAD_ID
FROM DDR.DDR_E_GEO_DEMOG#;

Dependencies

[top of page]

DDR.DDR_E_GEO_DEMOG# references the following:

DDR: DDR_E_GEO_DEMOG

DDR.DDR_E_GEO_DEMOG# is referenced by following:

APPS: DDR_E_GEO_DEMOG