WLF_ASSIGNMENT_RULES

SharedUsed in 0 subject areas26 reporting columnsBICC incremental-ready

Learning (WLF).

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

Columns

Column	Key	In reports	Description (inferred)
ASSIGNMENT_RULE_ID	PK?	●	Identifier for the assignment rule.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
DYN_DUE_DATE		●	Dyn due date.
DYN_DUE_DATE_OPTION		●	Dyn due date option.
DYN_DUE_IN_DAYS		●	Dyn due in days.
DYN_ENABLED		●	Dyn enabled.
DYN_STOP_NEW_DATE		●	Dyn stop new date.
DYN_STOP_WITHDRAW_DATE		●	Dyn stop withdraw date.
DYN_WITHDRAW_OPTION		●	Dyn withdraw option.
ENTERPRISE_ID		●	Identifier for the enterprise.
EXPIRY_DATE		●	Expiry date.
EXPIRY_IN_DAYS		●	Expiry in days.
EXPIRY_IN_NUM_YRS		●	Expiry in number yrs.
EXPIRY_OPTION		●	Expiry option.
INITIAL_DUE_DATE		●	Initial due date.
INITIAL_DUE_DATE_OPTION		●	Initial due date option.
INITIAL_DUE_IN_DAYS		●	Initial due in days.
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.
LEARNING_ITEM_EFFECTIVITY		●	Learning item effectivity.
OBJECT_VERSION_NUMBER		●	Optimistic-locking version number, incremented on each update.
RENEWAL_BEFORE_EXPIRY_DAYS		●	Renewal before expiry days.
RENEWAL_OPTIONS		●	Renewal options.
VALIDITY_OPTION		●	Validity option.

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

Need the extract + dbt staging for WLF_ASSIGNMENT_RULES?

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