HRQ_QUESTIONNAIRES_B

SharedUsed in 0 subject areas27 reporting columnsBICC incremental-ready

base table — language-neutral data (paired with _TL labels and the _VL view).

Likely primary key: QUESTIONNAIRE_ID (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

Columns

Column	Key	In reports	Description (inferred)
BUSINESS_GROUP_ID		●	Identifier for the business group.
CATEGORY_ID		●	Identifier for the category.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
IN_USE		●	In use.
LAST_UPDATED_BY		●	User who last updated the row.
LAST_UPDATE_DATE	INCR	●	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.
LATEST_VERSION		●	Latest version.
MAX_POSSIBLE_SCORE		●	Max possible score.
MODULE_ID		●	Identifier for the module.
OBJECT_VERSION_NUMBER		●	Optimistic-locking version number, incremented on each update.
OWNER		●	Owner.
PAGE_LAYOUT		●	Page layout.
PRIVACY_FLAG		●	Indicator (Y/N) for the privacy.
QSTNR_TEMPLATE_ID		●	Identifier for the qstnr template.
QSTNR_VERSION_NUM		●	Qstnr version number.
QSTNS_PER_PAGE		●	Qstns per page.
QUESTIONNAIRE_CODE		●	Code identifying the questionnaire.
QUESTIONNAIRE_ID	PK?	●	Identifier for the questionnaire.
SECTION_ORDER		●	Section order.
SECTION_PRESENTATION		●	Section presentation.
STATUS		●	Status.
SUBSCRIBER_ID		●	Identifier for the subscriber.
TEMPLATE_FLAG		●	Indicator (Y/N) for the template.
UPDATE_ALLOWED		●	Update allowed.
VERSION_DESCRIPTION		●	Description of the version.

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

Need the extract + dbt staging for HRQ_QUESTIONNAIRES_B?

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