[Home] [Help] [Dependency Information]
Object Name: | PSB_ATTRIBUTE_TYPES |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_ATTRIBUTE_TYPES |
Subobject Name: | |
Status: | VALID |
PSB_ATTRIBUTE_TYPES contains select table and column details in Human
Resource Management Systems that pertain to the names of attribute
types such as Key Flexfields, descriptive flexfields, or QuickCodes, or Others.
This is used to get the attribute values relevant to the employees, position, or
assignments.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_ATTRIBUTE_TYPES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ATTRIBUTE_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_TYPE_ID | NUMBER | (15) | Yes | Unique identifier for attribute types |
ATTRIBUTE_TYPE | VARCHAR2 | (20) | Defines attribute type such as KFF (Key Flexfield), DFF (Descriptive Flexfield), or QC (Quick Codes) or Table (Others) | |
NAME | VARCHAR2 | (30) | Name of one of the attributes belonging to the business group | |
SELECT_COLUMN | VARCHAR2 | (50) | Column which has to be selected from the select table in order to fetch the attribute value required for the specified attribute | |
SELECT_TABLE | VARCHAR2 | (50) | Table from which the attribute value assignment is selected | |
SELECT_KEY | VARCHAR2 | (30) | Key column on the select table which has to be joined with the link key column as indicated by the link type | |
SELECT_WHERE | VARCHAR2 | (1500) | Where clause which is to be associated with the select statement involving the select column and select table | |
LINK_KEY | VARCHAR2 | (30) | Key column in the table indicated by the link type, which is joined with the key column on the select table | |
LINK_TYPE | VARCHAR2 | (30) | Link type is A if the attribute is associated to the assignment, E if the attribute is associated to the employee, and P if the attribute is associated to the position. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ATTRIBUTE_TYPE_ID
, ATTRIBUTE_TYPE
, NAME
, SELECT_COLUMN
, SELECT_TABLE
, SELECT_KEY
, SELECT_WHERE
, LINK_KEY
, LINK_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSB.PSB_ATTRIBUTE_TYPES;
PSB.PSB_ATTRIBUTE_TYPES does not reference any database object
PSB.PSB_ATTRIBUTE_TYPES is referenced by following:
|
|
|