WLF_LI_ENRICHED

Table to store learning item enriched data

Details

• Schema: FUSION

• Object owner: WLF

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
WLF_LI_ENRICHED_PK	LI_ENRICHED_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LI_ENRICHED_ID	NUMBER		18	Yes	System generated unique identifier.
LEARNING_ITEM_ID	NUMBER		18	Yes	Reference to the identifier of the enriched learning item.
SUGGESTED_SKILLS	CLOB				Comma separated list of raw skills that learner will achieve after completing the learning item.
SUGGESTED_FOR_JOBS	CLOB				Comma separated list of raw job names for which the learning is most suitable.
SUGGESTED_TOPICS	CLOB				Comma separated list of raw topics, in which the learning can be organized.
ENRICHED_SUMMARY	CLOB				A 1-2 line summary containing just the highest-signal decision information, i.e. Primary outcome (what the learner will be able to do), Target audience/role or context (who it’s for), Key topic/skill area (what it’s about), optionally include level if characters left.
ENRICHED_DESCRIPTION	CLOB				A paragraph that succinctly describes everything about the learning item, including its purpose, key content areas, target audience, and the skills or knowledge addressed.
ENRICHED_IDEAL_LEARNER	CLOB				Stores generated ideal learner profile text for the learning item.
ENRICHED_LEARN_OBJECT	CLOB				Stores generated enriched learning-object details/content for the learning item.
LAST_RUN_LI_TEXT	CLOB				Stores the last processed learning-item text snapshot used in the most recent enrichment run.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index	Uniqueness	Tablespace	Columns
WLF_LI_ENRICHED_PK	Unique	Default	LI_ENRICHED_ID
WLF_LI_ENRICHED_U1	Unique	Default	LEARNING_ITEM_ID