[Home] [Help] [Dependency Information]
Object Name: | OTA_CATEGORY_USAGES |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_CATEGORY_USAGES |
Subobject Name: | |
Status: | VALID |
Categories are entities that allow administrative users to organize their course catalog. Categories are containers for courses and learning paths, and have few attributes. The administrative user can define start and end dates for categories, select which courses appear in which categories in the course catalog, and define learner access based on the category level allowing access to be inherited by all the courses the category contains (though learner access doesnot need to be defined here, it can be defined at the levels of Course, Offering, and Class as well).
You can use a category to define:
1. Searching criteria
2. Program specifications
3. Packaged discounts
Each category can be used for all or none of the above. A category
usage record indicates which of these usages is valid for a particular
activity category.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_CATEGORY_USAGES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CATEGORY_USAGE_ID |
OTA_CATEGORY_USAGES_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARENT_CAT_USAGE_ID |
OTA_CATEGORY_USAGES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BUSINESS_GROUP_ID
TYPE |
OTA_CATEGORY_USAGES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SYNCHRONOUS_FLAG
ONLINE_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CATEGORY_USAGE_ID | NUMBER | (9) | Yes | The system generated surrogatekey for this entry. |
BUSINESS_GROUP_ID | NUMBER | (9) | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS. |
CATEGORY | VARCHAR2 | (240) | The Category that classifies an Activity, Programme or Discount P | |
OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | Version control parameter. |
TYPE | VARCHAR2 | (30) | Yes | The classification of the Category in Use |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Standard Who Column | |
CREATION_DATE | DATE | Standard Who Column | ||
START_DATE_ACTIVE | DATE | Start Date of the Category Usages become active. | ||
END_DATE_ACTIVE | DATE | End Date when the Category Usages become inactive. | ||
PARENT_CAT_USAGE_ID | NUMBER | (9) | Foreign key to OTA_CATEGORY_USAGES | |
SYNCHRONOUS_FLAG | VARCHAR2 | (1) | Determine whether the category is Synchronous or Asynchromous. | |
ONLINE_FLAG | VARCHAR2 | (1) | Determine whether the category is for Online of Offline. | |
DATA_SOURCE | VARCHAR2 | (30) | The module that Category originated in. | |
COMMENTS | VARCHAR2 | (2000) | Comments. | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT CATEGORY_USAGE_ID
, BUSINESS_GROUP_ID
, CATEGORY
, OBJECT_VERSION_NUMBER
, TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PARENT_CAT_USAGE_ID
, SYNCHRONOUS_FLAG
, ONLINE_FLAG
, DATA_SOURCE
, COMMENTS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
FROM OTA.OTA_CATEGORY_USAGES;
OTA.OTA_CATEGORY_USAGES does not reference any database object
OTA.OTA_CATEGORY_USAGES is referenced by following:
|
|
|