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_PE_API_ALT_PERS_API_ID_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

IGS_PE_API_ALT_PERS_API_ID_V is used to manipulate the API alternate ID of the API person IDs

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person identifier
STAFF_MEMBER_IND	VARCHAR2	(4000)		Staff member indicator
STUDENT_IND	VARCHAR2	(4000)		Student indicator
FIRST_ENROLMENT_YEAR	DATE			Year of first enrollment
CURRENT_ENROLMENT_YEAR	DATE			Current enrollment year
ENCUMBERED_IND	VARCHAR2	(4000)		Encumbered indicator
PE_SURNAME	VARCHAR2	(150)		Surname of the person
PE_GIVEN_NAMES	VARCHAR2	(150)		Given name of the person
PREFERRED_GIVEN_NAME	VARCHAR2	(240)		Preferred given name of the person
PE_TITLE	VARCHAR2	(60)		Title of the person
SEX	VARCHAR2	(30)		Sex of the person
BIRTH_DT	DATE			Birth date of the person
DECEASED_IND	VARCHAR2	(1)		Deceased indicator
SALUTATION	VARCHAR2	(60)		Salutation of the person
ORACLE_USERNAME	VARCHAR2	(100)		Internal oracle username
EMAIL_ADDR	VARCHAR2	(2000)		Email address of the person
PE_FULL_NAME	VARCHAR2	(301)		Fullname of the person
PE_PREFERRED_NAME	VARCHAR2	(391)		Preferred name of the person
PE_TITLE_NAME	VARCHAR2	(362)		Tiitle name of the person
PE_INITIAL_NAME	VARCHAR2	(4000)		Initial name of the person
PE_DISPLAY_NAME	VARCHAR2	(365)		Display name of the person
PAL_SEQUENCE_NUMBER	NUMBER	(6)		Sequence number
PAL_START_DT	DATE			Start date
PAL_END_DT	DATE			End date
PAL_SURNAME	VARCHAR2	(150)		Surname of the person
PAL_GIVEN_NAMES	VARCHAR2	(150)		Given name of the person
PAL_TITLE	VARCHAR2	(60)		Title of the person
PAL_COMMENT	VARCHAR2	(60)		Comment field
API_START_DT	DATE			Start date
API_END_DT	DATE			End date
API_PERSON_ID	VARCHAR2	(20)		Internal API person identifier
API_PERSON_ID_TYPE	VARCHAR2	(10)		Internal API person identifier type
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			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
,      STAFF_MEMBER_IND
,      STUDENT_IND
,      FIRST_ENROLMENT_YEAR
,      CURRENT_ENROLMENT_YEAR
,      ENCUMBERED_IND
,      PE_SURNAME
,      PE_GIVEN_NAMES
,      PREFERRED_GIVEN_NAME
,      PE_TITLE
,      SEX
,      BIRTH_DT
,      DECEASED_IND
,      SALUTATION
,      ORACLE_USERNAME
,      EMAIL_ADDR
,      PE_FULL_NAME
,      PE_PREFERRED_NAME
,      PE_TITLE_NAME
,      PE_INITIAL_NAME
,      PE_DISPLAY_NAME
,      PAL_SEQUENCE_NUMBER
,      PAL_START_DT
,      PAL_END_DT
,      PAL_SURNAME
,      PAL_GIVEN_NAMES
,      PAL_TITLE
,      PAL_COMMENT
,      API_START_DT
,      API_END_DT
,      API_PERSON_ID
,      API_PERSON_ID_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_PE_API_ALT_PERS_API_ID_V;

Dependencies

[top of page]

APPS.IGS_PE_API_ALT_PERS_API_ID_V references the following:

APPS: HZ_PARTIES; HZ_PERSON_PROFILES; IGS_EN_GEN_003 - show dependent code; IGS_EN_GEN_005 - show dependent code; IGS_EN_GEN_007 - show dependent code; IGS_GE_GEN_002 - show dependent code; IGS_PE_ALT_PERS_ID; IGS_PE_HZ_PARTIES; IGS_PE_PERSON_ALIAS

APPS.IGS_PE_API_ALT_PERS_API_ID_V is not referenced by any database object