DW_LM_LEARNING_ITEM_PRICING_D (Preview)

This table requires activation of Learning Management functional area. This table stores the pricing information of the Course and Offering Learning Items

Details

Module: Work Life

Key Columns

EFFECTIVE_END_DATE, PRICING_RULE_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PRICING_RULE_ID NUMBER 38 0 True Pricing Rule Identifier
EFFECTIVE_START_DATE DATE True Effective start date
EFFECTIVE_END_DATE DATE True Effective end date
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
ENTERPRISE_ID NUMBER 38 0 Enterprise identifier
USAGE VARCHAR2 64 Indicates the type of learning item for which pricing is set.Allowed values are ORA_CLASS,ORA_COURSE
TOTAL_PRICE NUMBER Indicates the total cost of the pricing rule
CURRENCY VARCHAR2 32 Indicates the currency type of the price