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_TYPE_MAPPINGS

Object Details

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

View Type

A Business Intelligence System view

This entity contains information about the mapping between the Student System defined person types and HRMS defined person types.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_TYPE_CODE	VARCHAR2	(30)	Yes
LA:SYSTEM_TYPE	CHAR	(64)		Meaning of the System Type associated with a Student System Person Type.
PERSON_TYPE_DESCRIPTION	VARCHAR2	(240)	Yes	Description of a Student System Person Type.
HR_PERSON_TYPE	VARCHAR2	(80)	Yes	Person type defined in Oracle HRMS.
HR_PERSON_TYPE_ID	NUMBER	(15)	Yes	Unique identifier of the person type defined in Oracle HRMS.
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERSON_TYPE_CODE
,      LA:SYSTEM_TYPE
,      PERSON_TYPE_DESCRIPTION
,      HR_PERSON_TYPE
,      HR_PERSON_TYPE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_PERSON_TYPE_MAPPINGS;

Dependencies

[top of page]

APPS.IGSFV_PERSON_TYPE_MAPPINGS references the following:

APPS: IGS_PE_PERSON_TYPES; IGS_PE_PER_TYPE_MAP; PER_PERSON_TYPES

APPS.IGSFV_PERSON_TYPE_MAPPINGS is not referenced by any database object