[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OTA_ANNOUNCEMENTS |
|---|---|
| Object Type: | TABLE |
| Owner: | OTA |
| FND Design Data: |  OTA.OTA_ANNOUNCEMENTS
|
| Subobject Name: | |
| Status: | VALID |
Announcements can contain text or HTML to deliver timely information to learners.
They are only displayed to learners during the start and end dates specified by the administrator.
The text is displayed to all learners in the business group after logging into Oracle iLearning.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OTA_ANOUNCEMENTS_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ANNOUNCEMENT_ID
|
| OTA_ANNOUNCEMENTS_FK1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BUSINESS_GROUP_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ANNOUNCEMENT_ID | NUMBER | (15) | Yes | System generated surrogate key for each distinct module version. |
| BUSINESS_GROUP_ID | NUMBER | (15) | Foreign key to HR_ALL_ORGANIZATION_UNITS | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Version control parameter. |
| START_DATE_ACTIVE | DATE | Yes | The Date when the Announcement become active. | |
| END_DATE_ACTIVE | DATE | The Date when the Announcement become inactive. | ||
| OWNER_ID | NUMBER | (10) | Owner of the announcement | |
| 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. |
Cut, paste (and edit) the following text to query this object:
SELECT ANNOUNCEMENT_ID
, BUSINESS_GROUP_ID
, OBJECT_VERSION_NUMBER
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, OWNER_ID
, 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
FROM OTA.OTA_ANNOUNCEMENTS;
OTA.OTA_ANNOUNCEMENTS does not reference any database object
OTA.OTA_ANNOUNCEMENTS is referenced by following:
APPS
OTA_ANNOUNCEMENTS
OTA_ANNOUNCEMENTS_WHO
|
|
|
|