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