[Home] [Help] [Dependency Information]
Object Name: | HRFV_PERSON_SPECIAL_INFO |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HRFV_PERSON_SPECIAL_INFO |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows types of special information held for people in your enterprise.
Effective dates for the special information are shown if they have
been entered.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
PERSON_NAME | VARCHAR2 | (240) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
INFORMATION_TYPE | VARCHAR2 | (30) | Yes | |
_DF:PERANS | CHAR | (30) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
ID_FLEX_NUM | NUMBER | (15) | Yes | |
PERSON_ID | NUMBER | (10) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, PERSON_NAME
, START_DATE
, END_DATE
, INFORMATION_TYPE
, _DF:PERANS
, BUSINESS_GROUP_ID
, ID_FLEX_NUM
, PERSON_ID
FROM APPS.HRFV_PERSON_SPECIAL_INFO;
APPS.HRFV_PERSON_SPECIAL_INFO is not referenced by any database object
|
|
|