[Home] [Help] [Dependency Information]
Object Name: | PSBFV_DATA_EXTRACTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBFV_DATA_EXTRACTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
PSBFV_DATA_EXTRACTS displays the data extract information.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATA_EXTRACT_NAME | VARCHAR2 | (30) | Yes | Data extract name |
DATA_EXTRACT_METHOD | VARCHAR2 | (30) | Yes | Data extract method. Indicates if this is a new extract or a refresh of an existing extract. Values are Create and Refresh. |
SET_OF_BOOKS_NAME | VARCHAR2 | (30) | Yes | Set of Books name associated with data extract |
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | Business group name to which data extract is confined |
POSITION_STRUCTURE | VARCHAR2 | (30) | Yes | Structure of position definition flexfield |
POPULATE_INTERFACE_FLAG | VARCHAR2 | (1) | Indicates if data extract process should populate interface tables | |
POPULATE_DATA_FLAG | VARCHAR2 | (1) | Indicates if data extract process should load data into base tables | |
COPY_DEFAULTS_FLAG | VARCHAR2 | (1) | Indicates if data shoud be copied from some other data extract | |
VALIDATE_DATA_FLAG | VARCHAR2 | (1) | Indicates if the data populated into the interface tables should be validated | |
APPLY_DEFAULTS_FLAG | VARCHAR2 | (1) | Indicates if default rules should be applied to positions | |
POPULATE_INTERFACE_STATUS | VARCHAR2 | (1) | Indicates if population of the interface tables is complete. C indicates Complete, I or null indicates Incomplete. | |
POPULATE_DATA_STATUS | VARCHAR2 | (1) | Indicates if population of the base tables is complete. C indicates Complete, I or null indicates Incomplete. | |
COPY_DEFAULTS_STATUS | VARCHAR2 | (1) | Indicates if data has been copied from some other data extract. C indicates Complete, I or null indicates Incomplete. | |
VALIDATE_DATA_STATUS | VARCHAR2 | (1) | Indicates if data in the interface tables has been validated. C indicates Complete, I or null indicates Incomplete. | |
APPLY_DEFAULTS_STATUS | VARCHAR2 | (1) | Indicates if default rules have been applied to positions. C indicates Complete, I or null indicates Incomplete. | |
DATA_EXTRACT_STATUS | VARCHAR2 | (1) | Status of the complete data extract process. C indicates Complete, I or null indicates Incomplete. | |
REQUIRED_AS_OF_DATE | DATE | Yes | Date as of which the data extracted should be valid | |
DATA_EXTRACT_ID | NUMBER | (20) | Yes | Data extract unique identifier |
SET_OF_BOOKS_ID | NUMBER | (20) | Yes | Set of Books unique identifier |
BUSINESS_GROUP_ID | NUMBER | (20) | Yes | Business group unique identifier |
POSITION_ID_FLEX_NUM | NUMBER | (15) | Yes | Position Key Flexfield structure identifier. Flexfield structure to be used for data extract. |
COPY_DATA_EXTRACT_ID | NUMBER | (20) | Unique identifier of source data extract from which data has to be copied | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT DATA_EXTRACT_NAME
, DATA_EXTRACT_METHOD
, SET_OF_BOOKS_NAME
, BUSINESS_GROUP_NAME
, POSITION_STRUCTURE
, POPULATE_INTERFACE_FLAG
, POPULATE_DATA_FLAG
, COPY_DEFAULTS_FLAG
, VALIDATE_DATA_FLAG
, APPLY_DEFAULTS_FLAG
, POPULATE_INTERFACE_STATUS
, POPULATE_DATA_STATUS
, COPY_DEFAULTS_STATUS
, VALIDATE_DATA_STATUS
, APPLY_DEFAULTS_STATUS
, DATA_EXTRACT_STATUS
, REQUIRED_AS_OF_DATE
, DATA_EXTRACT_ID
, SET_OF_BOOKS_ID
, BUSINESS_GROUP_ID
, POSITION_ID_FLEX_NUM
, COPY_DATA_EXTRACT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.PSBFV_DATA_EXTRACTS;
APPS.PSBFV_DATA_EXTRACTS is not referenced by any database object
|
|
|