eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGSFV_PERSON_PARTY

Object Details

Object Name:	IGSFV_PERSON_PARTY
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_PERSON_PARTY
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Obsolete

[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
_LA:VALIDATED_FLAG	CHAR	(54)		Indicates whethere the information is validated or not (Y/N)
PERSON_PRE_NAME_ADJUNCT	VARCHAR2	(30)		Salutary introduction, such as Mr. or Herr
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)		Academic title that is part of aperson's name, such as Dr. John Smith.
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)		Lookup representing most common personal identification number in a country. For example, Social Security Number in the US
EMAIL_ADDRESS	VARCHAR2	(2000)		E-mail address
SALUTATION	VARCHAR2	(60)		Phrase used to address a party in any correspondence.
_LA:DECEASED_INDICATOR	CHAR	(53)		Indicates whetehre person is deceased.
_LA:ARCHIVE_EXCLUSION_IND	CHAR	(62)		s if the person is excluded from Archive.
ARCHIVE_DATE	DATE			Archive date of the person
PURGE_EXCLN_INDICATOR	CHAR	(60)		Flag indicates whether person is excluded from purging
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 immunizations
LEVEL_OF_QUALIFICATION	NUMBER	(15)		Identifier of level of qualification
_LA:MILITARY_SERVICE_REG	CHAR	(61)		Military Service Registration
_LA:VETERAN	CHAR	(56)		Veteran Indicator
_LA:FUND_AUTHORIZATION	CHAR	(59)		This identifies whether the person has fund authorization or not
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
,      _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_PARTY;

Dependencies

[top of page]

APPS.IGSFV_PERSON_PARTY references the following:

APPS: HZ_PARTIES; IGS_PE_HZ_PARTIES

APPS.IGSFV_PERSON_PARTY is not referenced by any database object