[Home] [Help] [Dependency Information]
Object Name: | CSF_RESOURCE_SKILLS_B |
---|---|
Object Type: | TABLE |
Owner: | CSF |
FND Design Data: | CSF.CSF_RESOURCE_SKILLS_B |
Subobject Name: | |
Status: | VALID |
Used to map skills to resources.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSF_RESOURCE_SKILLS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | RESOURCE_SKILL_ID |
CSF_RESOURCE_SKILLS_B_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SKILL_ID
SKILL_TYPE_ID RESOURCE_ID RESOURCE_TYPE |
CSF_RESOURCE_SKILLS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
RESOURCE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_SKILL_ID | NUMBER | (15) | Yes | Primary key |
SKILL_TYPE_ID | NUMBER | (15) | Yes | Foreign key to the skill type id |
SKILL_ID | NUMBER | (15) | Yes | Foreign key to the skill id |
RESOURCE_TYPE | VARCHAR2 | (30) | Yes | Foreign key to the resource type |
RESOURCE_ID | NUMBER | (15) | Yes | Foreign key to the resource id |
SKILL_LEVEL_ID | NUMBER | (15) | Yes | Foreign key to the skill level id |
START_DATE_ACTIVE | DATE | Yes | Start Active date | |
END_DATE_ACTIVE | DATE | End Date active | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
SECURITY_GROUP_ID | NUMBER | Security group identifier | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield column |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_SKILL_ID
, SKILL_TYPE_ID
, SKILL_ID
, RESOURCE_TYPE
, RESOURCE_ID
, SKILL_LEVEL_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
FROM CSF.CSF_RESOURCE_SKILLS_B;
CSF.CSF_RESOURCE_SKILLS_B does not reference any database object
CSF.CSF_RESOURCE_SKILLS_B is referenced by following:
|
|
|