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