[Home] [Help] [Dependency Information]
Object Name: | OTA_LO_FOLDERS |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_LO_FOLDERS |
Subobject Name: | |
Status: | VALID |
A folder contains learning objects and other folders, and are created in the Content tree by administrators. The primary use of folders is to organize related content. For example, the Math Faculty folder contains Algebra and Calculus folders. Learning Objects related to each area are then created under their respective folders.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_LO_FOLDERS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | FOLDER_ID |
OTA_LO_FOLDERS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARENT_FOLDER_ID |
OTA_LO_FOLDERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | NAME |
OTA_LO_FOLDERS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DATA_SOURCE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FOLDER_ID | NUMBER | (15) | Yes | The system generated surrogatekey for this entry. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS |
PARENT_FOLDER_ID | NUMBER | (15) | Foreign key to OTA_LO_FOLDERS | |
NAME | VARCHAR2 | (240) | Yes | The name associated with this Learning Object Folder of the module |
START_DATE_ACTIVE | DATE | Active Start Date of the Folder | ||
END_DATE_ACTIVE | DATE | Active End Date of the Folder | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Version control parameter |
EXTERNAL_IDENTIFIER | VARCHAR2 | (30) | Identifier of the data based on Learning Object Folder import. | |
EXTERNAL_SOURCE | VARCHAR2 | (30) | Source of the Learning Object Folder import | |
DATA_SOURCE | VARCHAR2 | (30) | The module that Learning Object Folder originated in | |
CREATED_BY | NUMBER | (15) | Standard Who Column | |
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
USER_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT FOLDER_ID
, BUSINESS_GROUP_ID
, PARENT_FOLDER_ID
, NAME
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, OBJECT_VERSION_NUMBER
, EXTERNAL_IDENTIFIER
, EXTERNAL_SOURCE
, DATA_SOURCE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, USER_GROUP_ID
FROM OTA.OTA_LO_FOLDERS;
OTA.OTA_LO_FOLDERS does not reference any database object
OTA.OTA_LO_FOLDERS is referenced by following:
|
|
|