[Home] [Help] [Dependency Information]
Object Name: | IGSFV_PERSON_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_PERSON_DETAILS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
The view returns the valid person details in OSS. Only the basic data is returned
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_IDENTIFIER | NUMBER | (15) | Yes | Person identifier |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Unique identification number for this person |
PERSON_NAME | VARCHAR2 | (360) | Yes | Name of this person |
BIRTH_DATE | DATE | Date the person was born | ||
GENDER | VARCHAR2 | (30) | The gender (male, female, unknown) of the person | |
_LA:VALIDATED_FLAG | CHAR | (54) | Validation Flag | |
PERSON_PRE_NAME_ADJUNCT | VARCHAR2 | (30) | Salutary introduction, such as Mr. or Her | |
PERSON_FIRST_NAME | VARCHAR2 | (150) | First name of the person | |
PERSON_MIDDLE_NAME | VARCHAR2 | (60) | Middle name of the person | |
PERSON_LAST_NAME | VARCHAR2 | (150) | Last or surname of the person | |
PERSON_NAME_SUFFIX | VARCHAR2 | (30) | Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix. | |
PERSON_TITLE | VARCHAR2 | (60) | A professional or family title. For example, Don or The Right Honorable | |
PERSON_ACADEMIC_TITLE | VARCHAR2 | (30) | Person's Academic Title | |
API_PERSON_IDEN_TYPE | VARCHAR2 | (30) | Lookup representing most common personal identification number in a country. For example, Social Security Number in the US | |
API_PERSON_IDENTIFIER | VARCHAR2 | (60) | Value of API_PERSON_IDEN_TYPE | |
EMAIL_ADDRESS | VARCHAR2 | (2000) | E-mail address | |
SALUTATION | VARCHAR2 | (60) | Phrase used to address a party in any correspondence. | |
_LA:DECEASED_INDICATOR | CHAR | (53) | Deceased Indicator | |
_LA:ARCHIVE_EXCLUSION_IND | CHAR | (62) | Archive Exclusion Indicator | |
ARCHIVE_DATE | DATE | Archive date of the person | ||
PURGE_EXCLN_INDICATOR | CHAR | (60) | Indicates if this is the primary language used by a person in day-to-day transactions. Y for the primary language, N for other languages. | |
PURGE_DATE | DATE | Purge date of the person | ||
ORACLE_USERNAME | VARCHAR2 | (100) | Oracle user name | |
_LA:PROOF_OF_INSURANCE | CHAR | (53) | Proof Of Insurance | |
_LA:PROOF_OF_IMMUNIZATION | CHAR | (54) | Proof Of Immunization | |
LEVEL_OF_QUALIFICATION | NUMBER | (15) | Identifier of level of qualification | |
_LA:MILITARY_SERVICE_REG | CHAR | (61) | Military Services | |
_LA:VETERAN | CHAR | (56) | Veteran | |
_LA:FUND_AUTHORIZATION | CHAR | (59) | Fund Authorization | |
BIRTH_CITY | VARCHAR2 | (60) | Birth City | |
BIRTH_COUNTRY | VARCHAR2 | (30) | Birth Country Code | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_IDENTIFIER
, PERSON_NUMBER
, PERSON_NAME
, BIRTH_DATE
, GENDER
, _LA:VALIDATED_FLAG
, PERSON_PRE_NAME_ADJUNCT
, PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME
, PERSON_LAST_NAME
, PERSON_NAME_SUFFIX
, PERSON_TITLE
, PERSON_ACADEMIC_TITLE
, API_PERSON_IDEN_TYPE
, API_PERSON_IDENTIFIER
, EMAIL_ADDRESS
, SALUTATION
, _LA:DECEASED_INDICATOR
, _LA:ARCHIVE_EXCLUSION_IND
, ARCHIVE_DATE
, PURGE_EXCLN_INDICATOR
, PURGE_DATE
, ORACLE_USERNAME
, _LA:PROOF_OF_INSURANCE
, _LA:PROOF_OF_IMMUNIZATION
, LEVEL_OF_QUALIFICATION
, _LA:MILITARY_SERVICE_REG
, _LA:VETERAN
, _LA:FUND_AUTHORIZATION
, BIRTH_CITY
, BIRTH_COUNTRY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGSFV_PERSON_DETAILS;
APPS.IGSFV_PERSON_DETAILS is not referenced by any database object
|
|
|