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.IGS_SS_PERSON_SEARCH_V

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

The entity is used in Self Service to query for a Person

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person Identifier
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number
FULL_NAME	VARCHAR2	(450)		Full Name
SURNAME	VARCHAR2	(150)		Surname
MIDDLE_NAME	VARCHAR2	(60)		Middle name of the person
GIVEN_NAMES	VARCHAR2	(150)		Given name of the person
PREFERRED_NAME	VARCHAR2	(391)		Preferred name of the person
PREFERRED_GIVEN_NAME	VARCHAR2	(240)		Preferred given name of the person
SEX	VARCHAR2	(80)		Sex of the person
BIRTH_DT	DATE			Birth date of the person
EMAIL_ADDR	VARCHAR2	(2000)		Email address of the person
TITLE	VARCHAR2	(60)		Title of the person
SUFFIX	VARCHAR2	(30)		Suffix of the person
PREFIX	VARCHAR2	(30)		Pre name adjunct
SALUTATION	VARCHAR2	(60)		Salutation of the person
DECEASED_IND	VARCHAR2	(1)		Flag indicates whether the person is deceased or not
API_START_DT	DATE			Indicates the start of the period for that the alternate person ID record applies
API_END_DT	DATE			A date which indicates the end of the period for which the Alternate Person ID record applies.
API_PERSON_ID	VARCHAR2	(20)		Another identification number by that the person is recognized by other systems or organizations
PERSON_ID_TYPE	VARCHAR2	(10)		Identifies the system or organization to that the alternate person ID belongs
DESCRIPTION	VARCHAR2	(60)		Provides an explanation of the person ID Type
PREFERRED_IND	VARCHAR2	(1)		Flag indicates whether this person ID type is preferred or not
DISPLAY_OB_IND	VARCHAR2	(4000)		Obsolete Indicator
ADDR_TYPE	VARCHAR2	(30)		Address Type
ADDR_LINE_1	VARCHAR2	(240)		Address Line 1
ADDR_LINE_2	VARCHAR2	(240)		Address Line 2
ADDR_LINE_3	VARCHAR2	(240)		Address Line 3
ADDR_LINE_4	VARCHAR2	(240)		Address Line 4
CITY	VARCHAR2	(60)		City
STATE	VARCHAR2	(60)		State
PROVINCE	VARCHAR2	(60)		Province
COUNTY	VARCHAR2	(60)		County
COUNTRY	VARCHAR2	(60)		Country
POSTAL_CODE	VARCHAR2	(60)		Postal Code
AD_START_DT	DATE			Address Start Date
AD_END_DT	DATE			Address End Date
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_ID
,      PERSON_NUMBER
,      FULL_NAME
,      SURNAME
,      MIDDLE_NAME
,      GIVEN_NAMES
,      PREFERRED_NAME
,      PREFERRED_GIVEN_NAME
,      SEX
,      BIRTH_DT
,      EMAIL_ADDR
,      TITLE
,      SUFFIX
,      PREFIX
,      SALUTATION
,      DECEASED_IND
,      API_START_DT
,      API_END_DT
,      API_PERSON_ID
,      PERSON_ID_TYPE
,      DESCRIPTION
,      PREFERRED_IND
,      DISPLAY_OB_IND
,      ADDR_TYPE
,      ADDR_LINE_1
,      ADDR_LINE_2
,      ADDR_LINE_3
,      ADDR_LINE_4
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      POSTAL_CODE
,      AD_START_DT
,      AD_END_DT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_SS_PERSON_SEARCH_V;

Dependencies

[top of page]

APPS.IGS_SS_PERSON_SEARCH_V references the following:

APPS: IGS_EN_GEN_003 - show dependent code; IGS_EN_GEN_007 - show dependent code; IGS_PE_ALT_PERS_ID; IGS_PE_PERSON; IGS_PE_PERSON_ADDR; IGS_PE_PERSON_ID_TYP; IGS_PE_VAL_PIGM - show dependent code

APPS.IGS_SS_PERSON_SEARCH_V is not referenced by any database object