[Home] [Help] [Dependency Information]
Object Name: | OTA_CERT_PRD_ENROLLMENTS |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_CERT_PRD_ENROLLMENTS |
Subobject Name: | |
Status: | VALID |
This is a child of certification enrollment. When a learner enroll into certification for for the first time, one row is created that defines the first period. Each time the learner renew to the certification, another record will be created for the new period. Purpose of this is to keep the history of the certain period completion for the certification.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_CERT_PRD_ENROLLMENTS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CERT_PRD_ENROLLMENT_ID |
OTA_CERT_PRD_ENROLLMENTS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CERT_ENROLLMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CERT_PRD_ENROLLMENT_ID | NUMBER | (15) | Yes | System generated surrogate key for each distinct module version. |
CERT_ENROLLMENT_ID | NUMBER | (15) | Yes | Foreign key to OTA_CERT_ENROLLMENTS |
PERIOD_STATUS_CODE | VARCHAR2 | (30) | Yes | Determine the status of a particular certification period enrollment |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Version control parameter |
COMPLETION_DATE | DATE | Determine the date when the enrollment for the period is complete | ||
CERT_PERIOD_START_DATE | DATE | Determine when the period start | ||
CERT_PERIOD_END_DATE | DATE | Determine when the period is over | ||
EXPIRATION_DATE | DATE | Determine when the certification for the preiod is expired | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | 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 CERT_PRD_ENROLLMENT_ID
, CERT_ENROLLMENT_ID
, PERIOD_STATUS_CODE
, BUSINESS_GROUP_ID
, OBJECT_VERSION_NUMBER
, COMPLETION_DATE
, CERT_PERIOD_START_DATE
, CERT_PERIOD_END_DATE
, EXPIRATION_DATE
, 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_CERT_PRD_ENROLLMENTS;
OTA.OTA_CERT_PRD_ENROLLMENTS does not reference any database object
OTA.OTA_CERT_PRD_ENROLLMENTS is referenced by following:
|
|
|