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, EFFECTIVE_START_DATE, PRICING_RULE_ID

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    

Copyright © 2019, 2025, Oracle and/or its affiliates.