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: DDR.DDR_R_GEO_DEMOG

Object Details

Object Name:	DDR_R_GEO_DEMOG
Object Type:	TABLE
Owner:	DDR
Subobject Name:
Status:	VALID

Stores classification for a geo-demographic profile attributes

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DDR_R_GEO_DEMOG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GEO_DEMOG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MFG_ORG_CD	VARCHAR2	(30)	Yes	Manufacturer Organization Code
GEO_DEMOG_ID	NUMBER		Yes	Geography Demographic ID
GEO_CD	VARCHAR2	(30)	Yes	Geographic level information for which the value is being reported
GEO_VAL	VARCHAR2	(40)	Yes	Geographic Value
GEO_DESC	VARCHAR2	(240)		Geographic Description
ISO_CNTRY_CD	VARCHAR2	(30)		ISO Country Code
FMLY_TYP_CD	VARCHAR2	(30)		Family Type
FMLY_TYP_CD_DESC	VARCHAR2	(240)		Family Type Description
EDU_LVL_CD	VARCHAR2	(30)		Education Level
EDU_LVL_CD_DESC	VARCHAR2	(240)		Education Level Description
INDSTRY_CD	VARCHAR2	(30)		Industry Code
INDSTRY_CD_DESC	VARCHAR2	(240)		Industry Description
ANCSTRY_CD	VARCHAR2	(30)		Ancestry Code
ANCSTRY_CD_DESC	VARCHAR2	(240)		Ancestry Description
ML_TO_FML_RATIO	NUMBER			Male to female ratio
URBN_TO_RURAL_RATIO	NUMBER			Urban to Rural Ratio
MEDIAN_COMUT_TIME	NUMBER			Median Commute Time
AUTO_AVLBLTY_NBR	VARCHAR2	(30)		Automobile Availability Number
TOT_POPLTN	NUMBER			Total population
PVRTY_TOT	NUMBER			Total number at poverty level
RENT_TO_OWN_RATIO	NUMBER			Rent to Own Ratio
MEDIAN_RTRMNT_INCM	NUMBER			Median Retirement Income
AVG_RM_NBR_PER_HM	NUMBER			Average room number per home
AVG_HSNG_VAL	NUMBER			Average housing value
AVG_HM_BLT_YR	NUMBER			Average Home Built Year
POPLTN_DNSTY	NUMBER			Population Density
POPLTN_DNSTY_UOM_CD	VARCHAR2	(30)		Population Density UOM Code
POPLTN_RATIO_WHT	NUMBER			Population Ratio - White
POPLTN_RATIO_BLK	NUMBER			Population Ratio - Black
POPLTN_RATIO_ASIAN	NUMBER			Population Ratio - Asian
POPLTN_RATIO_HSPNIC	NUMBER			Population Ratio - Hispanic
POPLTN_RATIO_OTHR	NUMBER			Population Ratio - Other
POPLTN_MEDIAN_AGE	NUMBER			Population Median Age
HH_MEDIAN_SZ	NUMBER			Median household size
HH_MEDIAN_INCM	NUMBER			Median household income
HH_AVG_INCM	NUMBER			Average household income
HH_PER_CPT_INCM	NUMBER			Per Capita Household Income
ANNUAL_HTNG_DEG_DAYS	NUMBER			Annual Heating Degree Days
ANNUAL_PRCPTN	NUMBER			Annual precipitation
ANNUAL_AVG_SNOWFL	NUMBER			Annual average snowfall
AVG_NBR_OF_DAYS_SNOW	NUMBER			Average number of days with snow
AVG_NBR_OF_DAYS_CLR	NUMBER			Average number of days with clear skies
AVG_NBR_OF_DAYS_RAIN	NUMBER			Average number of days with rain
CRIME_INDX	NUMBER			Crime index
EFF_FROM_DT	DATE		Yes	Effective from date
EFF_TO_DT	DATE			Effective thru date
SRC_SYS_IDNT	VARCHAR2	(40)	Yes	Source file name or system that provided the data. It can be used to cross-reference the data with the source system, mainly for auditing purpose
SRC_SYS_DT	DATE		Yes	The date that the data was created. It can be used to cross-reference the data with the source system, mainly for auditing purpose
CRTD_BY_DSR	VARCHAR2	(30)	Yes	User Information of who loaded the data, for auditing purpose
LAST_UPDT_BY_DSR	VARCHAR2	(30)	Yes	User Information of last updated by, for auditing purpose
CREATED_BY	NUMBER	(15)	Yes	Number code of who last loaded the data, for auditing purpose
CREATION_DATE	DATE		Yes	Date on which the data was loaded in target table, for auditing purpose
LAST_UPDATED_BY	NUMBER	(15)	Yes	Number code of who last updated the data in target table, for auditing purpose
LAST_UPDATE_DATE	DATE		Yes	Date on which the data was last updated in target table, for auditing purpose
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Login ID of the User who last updated the data in target table, for auditing purpose

Query Text

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;

Dependencies

[top of page]

DDR.DDR_R_GEO_DEMOG does not reference any database object

DDR.DDR_R_GEO_DEMOG is referenced by following:

APPS: DDR_R_GEO_DEMOG