[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| 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 |
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
| 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 |
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;
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
|
|
|
|