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_AD_SS_INTPER_V

Object Details

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

View Type

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

INS Dependent details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id
PERSON_ID	NUMBER	(15)	Yes	Person Id
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number
PERSON_NAME	VARCHAR2	(360)	Yes	Person Name
PARTY_TYPE	VARCHAR2	(30)	Yes	Party Type
STUDENT_IND	VARCHAR2	(1)		Student Indicator
ENCUMBERED_IND	VARCHAR2	(1)		Encumbered Indicator
STAFF_MEMBER_IND	VARCHAR2	(1)		Staff Member Indicator
VALIDATED_FLAG	VARCHAR2	(1)		Validated Flag
SURNAME	VARCHAR2	(150)		Surname
GIVEN_NAMES	VARCHAR2	(150)		Given Names
MIDDLE_NAME	VARCHAR2	(60)		Middle Name
SUFFIX	VARCHAR2	(30)		Suffix
PRE_NAME_ADJUNCT	VARCHAR2	(30)		Pre Name Adjunct Code
PRE_NAME_ADJUNCT_MEANING	VARCHAR2	(80)		Pre Name Adjunct Meaning
TITLE	VARCHAR2	(60)		Title
TITLE_NAME	VARCHAR2	(362)		Title Name
INITIAL_NAME	VARCHAR2	(161)		Initial Name
INITIAL_LAST_NAME	VARCHAR2	(162)		Initial Last Name
CONTEXT_BLOCK_NAME	VARCHAR2	(455)		Context Block Name
EMAIL_ADDR	VARCHAR2	(2000)		Email Address
SALUTATION	VARCHAR2	(60)		Salutation
PREFERRED_NAME	VARCHAR2	(391)		Preferred Name
PREFERRED_GIVEN_NAME	VARCHAR2	(240)		Preferred Given Name
PROOF_OF_INS	VARCHAR2	(1)		INS Proof
PROOF_OF_IMMU	VARCHAR2	(1)		Immunization Proof
LEVEL_OF_QUAL_ID	NUMBER	(15)		Qualification Level Id
MILITARY_SERVICE_REG	VARCHAR2	(1)		Military Service Registration
VETERAN	VARCHAR2	(30)		Veteran
DECEASED_IND	VARCHAR2	(1)		Deceased Indicator
FULL_NAME	VARCHAR2	(450)		Full Name
SEX	VARCHAR2	(30)		Gender Code
SEX_MEANING	VARCHAR2	(80)		Gender Meaning
MARITAL_STATUS	VARCHAR2	(30)		Marital Status
MARITAL_STATUS_EFFECTIVE_DATE	DATE			Marital Status Effective Date
DECLARED_ETHNICITY	VARCHAR2	(60)		Ethnicity Declaration
DECEASED_DATE	DATE			Deceased Date
BIRTH_DT	DATE			Date of Birth
PLACE_OF_BIRTH	VARCHAR2	(60)		Place of Birth
ARCHIVE_EXCLUSION_IND	VARCHAR2	(1)		Archive Exclusion Indicator
ARCHIVE_DT	DATE			Archive Date
PURGE_EXCLUSION_IND	VARCHAR2	(1)		Purge Exclusion Indicator
PURGE_DT	DATE			Purge Date
PERSON_ID_TYPE	VARCHAR2	(10)		Person Id Type
API_PERSON_ID	VARCHAR2	(20)		API Person Id
CREATED_BY	NUMBER	(15)	Yes	WHO Column
CREATION_DATE	DATE		Yes	WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	WHO Column
LAST_UPDATE_DATE	DATE		Yes	WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		WHO Column
REQUEST_ID	NUMBER	(15)		Request Identifier
PROGRAM_APPLICATION_ID	NUMBER	(15)		Program Application Identifier
PROGRAM_ID	NUMBER	(15)		Program Identifier
PROGRAM_UPDATE_DATE	DATE			Program Update Date
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category for Descriptive Flex Field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flex Field Attribute1
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flex Field Attribute2
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flex Field Attribute3
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flex Field Attribute4
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flex Field Attribute5
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flex Field Attribute6
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flex Field Attribute7
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flex Field Attribute8
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flex Field Attribute9
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flex Field Attribute10
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flex Field Attribute11
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flex Field Attribute12
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flex Field Attribute13
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flex Field Attribute14
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flex Field Attribute15
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flex Field Attribute16
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flex Field Attribute17
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flex Field Attribute18
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flex Field Attribute19
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flex Field Attribute20
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flex Field Attribute21
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flex Field Attribute22
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flex Field Attribute23
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flex Field Attribute24
WH_UPDATE_DATE	DATE			Obsolete
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Global Attribute Category
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Global Attribute1
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Global Attribute2
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Global Attribute3
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Global Attribute4
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Global Attribute5
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Global Attribute6
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Global Attribute7
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Global Attribute8
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Global Attribute9
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Global Attribute10
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Global Attribute11
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Global Attribute12
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Global Attribute13
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Global Attribute14
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Global Attribute15
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Global Attribute16
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Global Attribute17
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Global Attribute18
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Global Attribute19
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Global Attribute20
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)	Yes	Original System Reference
PERSON_MIDDLE_NAME	VARCHAR2	(60)		Person Middle Name
PERSON_ACADEMIC_TITLE	VARCHAR2	(30)		Person Academic Title
PERSON_PREVIOUS_LAST_NAME	VARCHAR2	(150)		Previous Last Name of the Person
PERSON_IDEN_TYPE	VARCHAR2	(30)		Person Identification Type
PERSON_IDENTIFIER	VARCHAR2	(60)		Person Identifier
CATEGORY_CODE	VARCHAR2	(30)		Category Code
LEVEL_OF_QUAL	VARCHAR2	(30)		Qualification Level
ORACLE_USERNAME	VARCHAR2	(100)		Oracle User Name
RELATIONSHIP_TYPE	VARCHAR2	(0)		Relationship Type
START_DATE	VARCHAR2	(0)		Start Date
END_DATE	VARCHAR2	(0)		End Date
LOGIN_PERSON	VARCHAR2	(0)		Login Person
RECIPROCAL_FLAG	VARCHAR2	(30)	Yes	Reciprocal Flag
RELATIONSHIP_NAME	VARCHAR2	(80)		Relationship Name
RELATIONSHIP_ID	NUMBER	(15)	Yes	Relationship Identifier
SUBJECT_ID	NUMBER	(15)	Yes	Subject Identifier
OBJECT_VERSION_NUMBER	NUMBER			HZ_PARTIES Object Version Number. Internally used for locking the record

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      PERSON_NUMBER
,      PERSON_NAME
,      PARTY_TYPE
,      STUDENT_IND
,      ENCUMBERED_IND
,      STAFF_MEMBER_IND
,      VALIDATED_FLAG
,      SURNAME
,      GIVEN_NAMES
,      MIDDLE_NAME
,      SUFFIX
,      PRE_NAME_ADJUNCT
,      PRE_NAME_ADJUNCT_MEANING
,      TITLE
,      TITLE_NAME
,      INITIAL_NAME
,      INITIAL_LAST_NAME
,      CONTEXT_BLOCK_NAME
,      EMAIL_ADDR
,      SALUTATION
,      PREFERRED_NAME
,      PREFERRED_GIVEN_NAME
,      PROOF_OF_INS
,      PROOF_OF_IMMU
,      LEVEL_OF_QUAL_ID
,      MILITARY_SERVICE_REG
,      VETERAN
,      DECEASED_IND
,      FULL_NAME
,      SEX
,      SEX_MEANING
,      MARITAL_STATUS
,      MARITAL_STATUS_EFFECTIVE_DATE
,      DECLARED_ETHNICITY
,      DECEASED_DATE
,      BIRTH_DT
,      PLACE_OF_BIRTH
,      ARCHIVE_EXCLUSION_IND
,      ARCHIVE_DT
,      PURGE_EXCLUSION_IND
,      PURGE_DT
,      PERSON_ID_TYPE
,      API_PERSON_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      WH_UPDATE_DATE
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      ORIG_SYSTEM_REFERENCE
,      PERSON_MIDDLE_NAME
,      PERSON_ACADEMIC_TITLE
,      PERSON_PREVIOUS_LAST_NAME
,      PERSON_IDEN_TYPE
,      PERSON_IDENTIFIER
,      CATEGORY_CODE
,      LEVEL_OF_QUAL
,      ORACLE_USERNAME
,      RELATIONSHIP_TYPE
,      START_DATE
,      END_DATE
,      LOGIN_PERSON
,      RECIPROCAL_FLAG
,      RELATIONSHIP_NAME
,      RELATIONSHIP_ID
,      SUBJECT_ID
,      OBJECT_VERSION_NUMBER
FROM APPS.IGS_AD_SS_INTPER_V;

Dependencies

[top of page]

APPS.IGS_AD_SS_INTPER_V references the following:

APPS: FND_LOOKUP_VALUES; HZ_PARTIES; HZ_PERSON_PROFILES; HZ_RELATIONSHIPS; IGS_EN_GEN_003 - show dependent code; IGS_EN_GEN_007 - show dependent code; IGS_GE_GEN_002 - show dependent code; IGS_PE_CODE_CLASSES; IGS_PE_HZ_PARTIES; IGS_PE_PERSON_ID_TYPE_V

APPS.IGS_AD_SS_INTPER_V is not referenced by any database object