DBA Data[Home] [Help] [Dependency Information]

TABLE: DDR.DDR_E_GEO_DEMOG

Object Details
Object Name: DDR_E_GEO_DEMOG
Object Type: TABLE
Owner: DDR
Subobject Name:
Status: VALID


Error table that stores error records from DDR_I_GEO_DEMOG


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
REC_ID NUMBER
Yes Record ID, uniquely identify each records.
MFG_ORG_CD VARCHAR2 (30)
Manufacturer Organization code
GEO_CD VARCHAR2 (30)
Unique identifier for the past code or zip code
GEO_VAL VARCHAR2 (40)
The actual post code zip code
GEO_DESC VARCHAR2 (240)
Description for the post code or the zip code
ISO_CNTRY_CD VARCHAR2 (30)
Two letter ISO (International Organization for Standardization) country codes
FMLY_TYP_CD VARCHAR2 (30)
The family type code for a geographical area
FMLY_TYP_CD_DESC VARCHAR2 (240)
The description of the family type code.
EDU_LVL_CD VARCHAR2 (30)
The cde identifying the average education level for a geographic area.
EDU_LVL_CD_DESC VARCHAR2 (240)
The description of average education level for a geographic area.
INDSTRY_CD VARCHAR2 (30)
The code for the type of industry in a geographical area.
INDSTRY_CD_DESC VARCHAR2 (240)
The description of the industry code.
ANCSTRY_CD VARCHAR2 (30)
The ancestry code for a geographic area.
ANCSTRY_CD_DESC VARCHAR2 (240)
The ancestry code description for a geographic area.
ML_TO_FML_RATIO NUMBER

The male to female ratio for a geographic area.
URBN_TO_RURAL_RATIO NUMBER

The urban to rural ratio for a geographical area.
MEDIAN_COMUT_TIME NUMBER

The average commutes time for a geographic area.
AUTO_AVLBLTY_NBR VARCHAR2 (30)
The auto available number for a geographic area.
TOT_POPLTN NUMBER

The total number of people in a geographical area
PVRTY_TOT NUMBER

The total number of people below poverty line for a geographic area.
RENT_TO_OWN_RATIO NUMBER

The ratio of number of people who rent to the number of people who own houses for a geographic area.
MEDIAN_RTRMNT_INCM NUMBER

The average retirement income for a geographical area.
AVG_RM_NBR_PER_HM NUMBER

The average number of rooms per home.
AVG_HSNG_VAL NUMBER

The average house value for a geographic area.
AVG_HM_BLT_YR NUMBER

The average year a home was built in a geographic area.
POPLTN_DNSTY NUMBER

The density in population in the geographic area
POPLTN_DNSTY_UOM_CD VARCHAR2 (30)
The unit in which the population density is measured in the geographical area
POPLTN_RATIO_WHT NUMBER

The ratio between the white population and total population
POPLTN_RATIO_BLK NUMBER

The ratio between the black population and total population
POPLTN_RATIO_ASIAN NUMBER

The ratio between the asian population and total population
POPLTN_RATIO_HSPNIC NUMBER

The ratio between the hispanic population and total population
POPLTN_RATIO_OTHR NUMBER

The ratio between the other population and total population
POPLTN_MEDIAN_AGE NUMBER

Median of the population age in a particular geographic location identified by post code
HH_MEDIAN_SZ NUMBER

Median size of household in a particular geographic location identified by post code
HH_MEDIAN_INCM NUMBER

Median income of household in a particular geographic location identified by post code
HH_AVG_INCM NUMBER

Average income of household in a particular geographic location identified by post code
HH_PER_CPT_INCM NUMBER

Capital income of household in a particular geographic location identified by post code
ANNUAL_HTNG_DEG_DAYS NUMBER

Number of days the year for which temperature raise high
ANNUAL_PRCPTN NUMBER

Yearly precipitation of rain in a particular geographic location identified by post code
ANNUAL_AVG_SNOWFL NUMBER

A numerical value indicates the average snowfall in a year
AVG_NBR_OF_DAYS_SNOW NUMBER

Average number of days for a geographical area when snow fall occurs
AVG_NBR_OF_DAYS_CLR NUMBER

Number of average sunny days for a geographical area
AVG_NBR_OF_DAYS_RAIN NUMBER

Number of average rainy days for a geographical area
CRIME_INDX NUMBER

Indicates the criminal activity for a geographical area
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
ERR_REASON VARCHAR2 (500) Yes Descriptive reason why the record failed validation and came in error table
ACTION_FLAG VARCHAR2 (1) Yes Flag indicating the status of error record and what needs to be done on it, possible values can be 'N/Y/D', N - Not corrected; Y- Corrected, ready for processing; D- to be deleted
LOAD_ID NUMBER
Yes Load ID is required for identifying each load records
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 does not reference any database object

DDR.DDR_E_GEO_DEMOG is referenced by following:

SchemaAPPS
SynonymDDR_E_GEO_DEMOG