Analytics Catalog/Data dictionary/HZ_GEOGRAPHIES
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

HZ_GEOGRAPHIES

Trading CommunityUsed in 0 subject areas102 reporting columnsBICC incremental-ready

Trading Community (Parties) (HZ).

Primary key: GEOGRAPHY_ID · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
ATTRIBUTE1●Descriptive flexfield segment.
ATTRIBUTE10●Descriptive flexfield segment.
ATTRIBUTE11●Descriptive flexfield segment.
ATTRIBUTE12●Descriptive flexfield segment.
ATTRIBUTE13●Descriptive flexfield segment.
ATTRIBUTE14●Descriptive flexfield segment.
ATTRIBUTE15●Descriptive flexfield segment.
ATTRIBUTE16●Descriptive flexfield segment.
ATTRIBUTE17●Descriptive flexfield segment.
ATTRIBUTE18●Descriptive flexfield segment.
ATTRIBUTE19●Descriptive flexfield segment.
ATTRIBUTE2●Descriptive flexfield segment.
ATTRIBUTE20●Descriptive flexfield segment.
ATTRIBUTE21●Descriptive flexfield segment.
ATTRIBUTE22●Descriptive flexfield segment.
ATTRIBUTE23●Descriptive flexfield segment.
ATTRIBUTE24●Descriptive flexfield segment.
ATTRIBUTE25●Descriptive flexfield segment.
ATTRIBUTE26●Descriptive flexfield segment.
ATTRIBUTE27●Descriptive flexfield segment.
ATTRIBUTE28●Descriptive flexfield segment.
ATTRIBUTE29●Descriptive flexfield segment.
ATTRIBUTE3●Descriptive flexfield segment.
ATTRIBUTE30●Descriptive flexfield segment.
ATTRIBUTE4●Descriptive flexfield segment.
ATTRIBUTE5●Descriptive flexfield segment.
ATTRIBUTE6●Descriptive flexfield segment.
ATTRIBUTE7●Descriptive flexfield segment.
ATTRIBUTE8●Descriptive flexfield segment.
ATTRIBUTE9●Descriptive flexfield segment.
ATTRIBUTE_CATEGORY●Descriptive flexfield context (structure definition).
ATTRIBUTE_DATE1●Descriptive flexfield segment.
ATTRIBUTE_DATE10●Descriptive flexfield segment.
ATTRIBUTE_DATE11●Descriptive flexfield segment.
ATTRIBUTE_DATE12●Descriptive flexfield segment.
ATTRIBUTE_DATE2●Descriptive flexfield segment.
ATTRIBUTE_DATE3●Descriptive flexfield segment.
ATTRIBUTE_DATE4●Descriptive flexfield segment.
ATTRIBUTE_DATE5●Descriptive flexfield segment.
ATTRIBUTE_DATE6●Descriptive flexfield segment.
ATTRIBUTE_DATE7●Descriptive flexfield segment.
ATTRIBUTE_DATE8●Descriptive flexfield segment.
ATTRIBUTE_DATE9●Descriptive flexfield segment.
ATTRIBUTE_NUMBER1●Descriptive flexfield segment.
ATTRIBUTE_NUMBER10●Descriptive flexfield segment.
ATTRIBUTE_NUMBER11●Descriptive flexfield segment.
ATTRIBUTE_NUMBER12●Descriptive flexfield segment.
ATTRIBUTE_NUMBER2●Descriptive flexfield segment.
ATTRIBUTE_NUMBER3●Descriptive flexfield segment.
ATTRIBUTE_NUMBER4●Descriptive flexfield segment.
ATTRIBUTE_NUMBER5●Descriptive flexfield segment.
ATTRIBUTE_NUMBER6●Descriptive flexfield segment.
ATTRIBUTE_NUMBER7●Descriptive flexfield segment.
ATTRIBUTE_NUMBER8●Descriptive flexfield segment.
ATTRIBUTE_NUMBER9●Descriptive flexfield segment.
COUNTRY_CODE●Code identifying the country.
CREATED_BY●User who created the row.
CREATED_BY_MODULE●Created by module.
CREATION_DATE●Date and time the row was created.
END_DATE●End date.
GEOCODE_FLAG●Indicator (Y/N) for the geocode.
GEOGRAPHY_CODE●Code identifying the geography.
GEOGRAPHY_ELEMENT1●Geography element1.
GEOGRAPHY_ELEMENT10●Geography element10.
GEOGRAPHY_ELEMENT10_ID●Identifier for the geography element10.
GEOGRAPHY_ELEMENT1_CODE●Code identifying the geography element1.
GEOGRAPHY_ELEMENT1_ID●Identifier for the geography element1.
GEOGRAPHY_ELEMENT2●Geography element2.
GEOGRAPHY_ELEMENT2_CODE●Code identifying the geography element2.
GEOGRAPHY_ELEMENT2_ID●Identifier for the geography element2.
GEOGRAPHY_ELEMENT3●Geography element3.
GEOGRAPHY_ELEMENT3_CODE●Code identifying the geography element3.
GEOGRAPHY_ELEMENT3_ID●Identifier for the geography element3.
GEOGRAPHY_ELEMENT4●Geography element4.
GEOGRAPHY_ELEMENT4_CODE●Code identifying the geography element4.
GEOGRAPHY_ELEMENT4_ID●Identifier for the geography element4.
GEOGRAPHY_ELEMENT5●Geography element5.
GEOGRAPHY_ELEMENT5_CODE●Code identifying the geography element5.
GEOGRAPHY_ELEMENT5_ID●Identifier for the geography element5.
GEOGRAPHY_ELEMENT6●Geography element6.
GEOGRAPHY_ELEMENT6_ID●Identifier for the geography element6.
GEOGRAPHY_ELEMENT7●Geography element7.
GEOGRAPHY_ELEMENT7_ID●Identifier for the geography element7.
GEOGRAPHY_ELEMENT8●Geography element8.
GEOGRAPHY_ELEMENT8_ID●Identifier for the geography element8.
GEOGRAPHY_ELEMENT9●Geography element9.
GEOGRAPHY_ELEMENT9_ID●Identifier for the geography element9.
GEOGRAPHY_IDPK●Identifier for the geography.
GEOGRAPHY_NAME●Name of the geography.
GEOGRAPHY_NUMBER●Geography number.
GEOGRAPHY_TYPE●Type of geography.
GEOGRAPHY_USE●Geography use.
JOB_DEFINITION_NAME●Name of the job definition.
JOB_DEFINITION_PACKAGE●Job definition package.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATEINCR●Date and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGIN●Session login of the user who last updated the row.
MULTIPLE_PARENT_FLAG●Indicator (Y/N) for the multiple parent.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
REQUEST_ID●Identifier of the process that created or last updated the row.
START_DATE●Start date.
TIMEZONE_CODE●Code identifying the timezone.

1 report read from this table

Change a column here and these are the reports that move with it, the blast radius for any change to HZ_GEOGRAPHIES.

Subject areas

Need the extract + dbt staging for HZ_GEOGRAPHIES?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
Aging as of any date · Reporting without memory · The export ceiling