DW_LM_PRICING_RULE_D (Preview)

This table requires activation of Learning Management functional area. This table stores the pricing information of the 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 consisting of absence_category_id effective_start_date and effective_end_date
ENTERPRISE_ID NUMBER 38 0 Enterprise identifier
LEARNING_ITEM_TYPE VARCHAR2 64 Indicates the type of learning item for which pricing is set
TOTAL_PRICE NUMBER Indicates the total cost of the pricing rule
CURRENCY VARCHAR2 32 Indicates the currency type of the price