HZ_ORGANIZATION_PROFILES

Trading CommunityUsed in 44 subject areas27 reporting columns

Trading Community (Parties) (HZ).

Primary key: not yet catalogued for HZ_ORGANIZATION_PROFILES — reference Oracle Tables & Views guide.

Columns

Column	In reports	Description (inferred)
BANK_OR_BRANCH_NUMBER	●	Bank or branch number.
CEO_NAME	●	Name of the ceo.
CEO_TITLE	●	Ceo title.
COMMENTS	●	Comments.
CURR_FY_POTENTIAL_REVENUE	●	Currency fy potential revenue.
DB_RATING	●	Db rating.
DISADV_8A_IND	●	Disadv 8a ind.
FISCAL_YEAREND_MONTH	●	Fiscal yearend month.
GLOBAL_ULTIMATE_DUNS_NUM_C	●	Global ultimate duns number c.
GSA_INDICATOR_FLAG	●	Indicator (Y/N) for the gsa indicator.
HOME_COUNTRY	●	Home country.
HQ_BRANCH_IND	●	Hq branch ind.
INTERNAL_FLAG	●	Indicator (Y/N) for the internal.
LEGAL_STATUS	●	Status of the legal.
LINE_OF_BUSINESS	●	Line of business.
MINORITY_OWNED_IND	●	Minority owned ind.
MINORITY_OWNED_TYPE	●	Type of minority owned.
MISSION_STATEMENT	●	Mission statement.
ORGANIZATION_NAME	●	Name of the organization.
PARENT_DUNS_NUM_C	●	Parent duns number c.
PARTY_NUMBER	●	Party number.
PREF_FUNCTIONAL_CURRENCY	●	Pref functional currency.
PUBLIC_PRIVATE_OWNERSHIP_FLAG	●	Indicator (Y/N) for the public private ownership.
SMALL_BUS_IND	●	Small bus ind.
STOCK_SYMBOL	●	Stock symbol.
WOMAN_OWNED_IND	●	Woman owned ind.
YEAR_ESTABLISHED	●	Year established.

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for HZ_ORGANIZATION_PROFILES?

We ship parameterized SQL, BICC config, and dbt models you own.