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

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