DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGSFV_PERSON_DETAILS

Object Details
Object Name: IGSFV_PERSON_DETAILS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSFV_PERSON_DETAILS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


The view returns the valid person details in OSS. Only the basic data is returned


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.IGSFV_PERSON_DETAILS references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_PERSON_PROFILES
SynonymIGS_PE_HZ_PARTIES

APPS.IGSFV_PERSON_DETAILS is not referenced by any database object