[Home] [Help] [Dependency Information]
Object Name: | PSBFV_POSITIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBFV_POSITIONS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
PSBFV_POSITIONS displays information for all positions.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATA_EXTRACT_NAME | VARCHAR2 | (30) | Yes | Data extract name |
POSITION_NAME | VARCHAR2 | (240) | Position name. Concatenated position Key Flexfield segments. | |
START_EFFECTIVE_DATE | DATE | Yes | Effective start date | |
END_EFFECTIVE_DATE | DATE | Effective end date | ||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number in Human Resource Management Systems | |
EMPLOYEE_FULL_NAME | VARCHAR2 | (240) | Employee full name | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive Flexfield column used to store position attribute value | |
NEW_POSITION_FLAG | VARCHAR2 | (1) | Indicates if this is a new position created in Public Sector Budgeting | |
POSITION_ID | NUMBER | (20) | Yes | Position unique identifier |
DATA_EXTRACT_ID | NUMBER | (20) | Yes | Data extract unique identifier |
EMPLOYEE_ID | NUMBER | (20) | Employee unique identifier |
Cut, paste (and edit) the following text to query this object:
SELECT DATA_EXTRACT_NAME
, POSITION_NAME
, START_EFFECTIVE_DATE
, END_EFFECTIVE_DATE
, EMPLOYEE_NUMBER
, EMPLOYEE_FULL_NAME
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, NEW_POSITION_FLAG
, POSITION_ID
, DATA_EXTRACT_ID
, EMPLOYEE_ID
FROM APPS.PSBFV_POSITIONS;
APPS.PSBFV_POSITIONS is not referenced by any database object
|
|
|