[Home] [Help] [Dependency Information]
Object Name: | CSF_REQUIRED_SKILLS_B |
---|---|
Object Type: | TABLE |
Owner: | CSF |
FND Design Data: | CSF.CSF_REQUIRED_SKILLS_B |
Subobject Name: | |
Status: | VALID |
This table is used to see which object has required skills
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSF_REQUIRED_SKILLS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUIRED_SKILL_ID |
CSF_REQUIRED_SKILLS_B_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
HAS_SKILL_ID
HAS_SKILL_TYPE SKILL_ID SKILL_TYPE_ID |
CSF_REQUIRED_SKILLS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SKILL_ID
SKILL_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUIRED_SKILL_ID | NUMBER | (15) | Yes | Primary key of the table |
SKILL_TYPE_ID | NUMBER | (15) | Yes | Foreign key to the skill type |
SKILL_ID | NUMBER | (15) | Yes | Foreign key to skill |
HAS_SKILL_TYPE | VARCHAR2 | (30) | Yes | Skill owner object type identifier. Column HAS_SKILL_TYPE identifies the type of id that is stored in column HAS_SKILL_ID. For example, if column HAS_SKILL_TYPE has value 'TASK' then column HAS_SKILL_ID contains a TASK_ID. In that case, the skill represented by this row is a required skill for the given task. |
HAS_SKILL_ID | NUMBER | (15) | Yes | Column HAS_SKILL_ID stores the ID-value of the skill owner object. For instance, if the skill is required for a task, column HAS_SKILL_ID contains a TASK_ID. |
SKILL_LEVEL_ID | NUMBER | (15) | Yes | Foreign key to skill level |
SKILL_REQUIRED_FLAG | VARCHAR2 | (1) | Flag indicating whether the skll as such is mandatory for a task | |
LEVEL_REQUIRED_FLAG | VARCHAR2 | (1) | Flag indicating whether the specific skill level is mandatory for a task | |
DISABLED_FLAG | VARCHAR2 | (1) | Flag indicating whether the assignment is disabled: soft removal | |
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 | Foreign key to the skill type id |
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 REQUIRED_SKILL_ID
, SKILL_TYPE_ID
, SKILL_ID
, HAS_SKILL_TYPE
, HAS_SKILL_ID
, SKILL_LEVEL_ID
, SKILL_REQUIRED_FLAG
, LEVEL_REQUIRED_FLAG
, DISABLED_FLAG
, 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_REQUIRED_SKILLS_B;
CSF.CSF_REQUIRED_SKILLS_B does not reference any database object
CSF.CSF_REQUIRED_SKILLS_B is referenced by following:
|
|
|