DW_LM_RESOURCE_D (Preview)

This table requires activation of Learning Management functional area. Table to store details of resources

Details

Module: Work Life

Key Columns

RESOURCE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RESOURCE_ID NUMBER 38 0 True Resource Identifier    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Unique Source Record Identifier    
STATUS VARCHAR2 128     Status of the resource, should be ORA_ACTIVE or ORA_INACTIVE    
RESOURCE_TYPE VARCHAR2 128     Indicates the type of resource (CLASSROOM, etc)    
LOCATION_ID NUMBER 38 0   Location Id    
CONTACT_ID NUMBER 38 0   Contact Id    
CAPACITY NUMBER       Capacity    
ENTERPRISE_ID NUMBER 38 0   Identifier of Enterprise    
RESOURCE_NUMBER VARCHAR2 128     UserKey to uniquely identify Learning Resource    
ATTRIBUTION_PERSON_ID NUMBER 38 0   Person Identifier    
ADDRESS_ID NUMBER 38 0   Address of the resource    

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