[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_PE_PERSON

Object Details

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

View Type

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

IGS_PE_PERSON is used to manipulate the information about persons stored in the database

[View Source]

Columns

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
,      VETERAN_MEANING
,      DECEASED_IND
,      FULL_NAME
,      SEX
,      SEX_MEANING
,      DECEASED_DATE
,      BIRTH_DT
,      ARCHIVE_EXCLUSION_IND
,      ARCHIVE_DT
,      PURGE_EXCLUSION_IND
,      PURGE_DT
,      PERSON_ID_TYPE
,      API_PERSON_ID
,      FUND_AUTHORIZATION
,      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
,      BIRTH_CITY
,      BIRTH_COUNTRY
,      BIRTH_COUNTRY_DESC
,      OBJECT_VERSION_NUMBER
,      STATUS
,      FELONY_CONVICTED_FLAG
FROM APPS.IGS_PE_PERSON;

Dependencies

[top of page]

APPS

FND_LOOKUP_VALUES

HZ_PARTIES

HZ_PERSON_PROFILES

IGS_AD_CODE_CLASSES

IGS_EN_GEN_003 - show dependent code

IGS_EN_GEN_007 - show dependent code

IGS_LOOKUP_VALUES

IGS_PE_HZ_PARTIES

IGS_PE_PERSON_ID_TYPE_V

APPS

IGF_AP_APP_ST_APLINST_V

IGF_AP_MATCHING_PROCESS_PKG - show dependent code

IGF_SE_GEN_001 - show dependent code

IGF_SL_CL_ORIG_ACK - show dependent code

IGF_SP_AWARD - show dependent code

IGF_SP_AWARD - show dependent code

IGF_SP_CREATE_BASE_REC - show dependent code

IGF_SP_CREATE_BASE_REC - show dependent code

IGF_SP_GEN_001 - show dependent code

IGF_SP_GEN_001 - show dependent code

IGF_SP_ROLLOVER - show dependent code

IGR_GEN_001 - show dependent code

IGS_AD_GEN_002 - show dependent code

IGS_AD_GEN_004 - show dependent code

IGS_AD_GEN_006 - show dependent code

IGS_AD_GEN_007 - show dependent code

IGS_AD_GEN_010 - show dependent code

IGS_AD_GEN_012 - show dependent code

IGS_AD_GEN_014 - show dependent code

IGS_AD_GEN_014 - show dependent code

IGS_AD_IMP_002 - show dependent code

IGS_AD_IMP_002 - show dependent code

IGS_AD_IMP_007 - show dependent code

IGS_AD_IMP_008 - show dependent code

IGS_AD_IMP_009 - show dependent code

IGS_AD_IMP_025 - show dependent code

IGS_AD_IMP_ADM_DES - show dependent code

IGS_AD_IMP_ADM_DES - show dependent code

IGS_AD_LOCATION_PKG - show dependent code

IGS_AD_LOCATION_PKG - show dependent code

IGS_AD_PRC_TAC_OFFER - show dependent code

IGS_AD_PS_APPL_INST_PKG - show dependent code

IGS_AD_PS_APPL_INST_PKG - show dependent code

IGS_AD_SS_PERSON_PKG - show dependent code

IGS_AD_VAL_ACAI - show dependent code

IGS_AD_VAL_PE - show dependent code

IGS_AS_GEN_004 - show dependent code

IGS_AS_GEN_006 - show dependent code

IGS_AS_GEN_007 - show dependent code

IGS_AS_INS_GRD_ENTRY_V

IGS_AS_SS_DOC_REQUEST - show dependent code

IGS_AS_SUAO_LGCY_PUB - show dependent code

IGS_AS_SUARC_LGCY_PUB - show dependent code

IGS_AS_SUA_ASS_V

IGS_AS_TRNCMT_LGCY_PUB - show dependent code

IGS_AS_UAI_ETISTD_EXAM_V

IGS_AV_GEN_001 - show dependent code

IGS_AV_LVL_LGCY_PUB - show dependent code

IGS_AV_UNT_LGCY_PUB - show dependent code

IGS_AZ_GEN_001 - show dependent code

IGS_CO_ITM_V

IGS_CO_OU_CO_V

IGS_CO_SUBMIT - show dependent code

IGS_CO_VAL_SCOTR - show dependent code

IGS_DA_TRNS_IMP - show dependent code

IGS_DA_UTILS_PKG - show dependent code

IGS_EN_ELGBL_UNIT - show dependent code

IGS_EN_ENROLL_WLST - show dependent code

IGS_EN_GEN_002 - show dependent code

IGS_EN_GEN_003 - show dependent code

IGS_EN_GEN_006 - show dependent code

IGS_EN_GEN_007 - show dependent code

IGS_EN_GEN_008 - show dependent code

IGS_EN_GEN_010 - show dependent code

IGS_EN_GEN_011 - show dependent code

IGS_EN_GEN_012 - show dependent code

IGS_EN_GEN_016 - show dependent code

IGS_EN_GEN_017 - show dependent code

IGS_EN_GEN_018 - show dependent code

IGS_EN_IVR_PUB - show dependent code

IGS_EN_NSC_PKG - show dependent code

IGS_EN_OFR_WLST_OPT - show dependent code

IGS_EN_OFR_WLST_OPT - show dependent code

IGS_EN_PRC_LOAD - show dependent code

IGS_EN_SPA_LGCY_PUB - show dependent code

IGS_EN_SPA_TERMS_API - show dependent code

IGS_EN_SPLACEMENTS_API - show dependent code

IGS_EN_STDNT_PS_ATT_PKG - show dependent code

IGS_EN_SUA_LGCY_PUB - show dependent code

IGS_EN_VAL_BULKRULE - show dependent code

IGS_EN_VAL_CNC - show dependent code

IGS_EN_VAL_ENCMB - show dependent code

IGS_EN_VAL_LC - show dependent code

IGS_EN_VAL_SCA - show dependent code

IGS_EN_VAL_SP - show dependent code

IGS_EN_VAL_SUA - show dependent code

IGS_EN_WLST_GEN_PROC - show dependent code

IGS_EN_WLST_GEN_PROC - show dependent code

IGS_EN_WORKFLOW - show dependent code

IGS_FI_CHARGES_API_PVT - show dependent code

IGS_FI_GEN_007 - show dependent code

IGS_FI_GEN_007 - show dependent code

IGS_FI_GEN_REFUNDS - show dependent code

IGS_FI_GEN_REFUNDS - show dependent code

IGS_FI_GET_SCAEH - show dependent code

IGS_FI_GET_SUAEH - show dependent code

IGS_FI_PRC_DISC_SUA - show dependent code

IGS_FI_PRC_DISC_SUA - show dependent code

IGS_FI_PRC_FIN_LT_CHG - show dependent code

IGS_FI_PRC_FIN_LT_CHG - show dependent code

IGS_FI_PRC_HOLDS - show dependent code

IGS_FI_PRC_HOLDS - show dependent code

IGS_FI_PRC_IMPCLC_ANC_CHGS - show dependent code

IGS_FI_PRC_IMPCLC_ANC_CHGS - show dependent code

IGS_FI_PRC_STDNT_DPSTS - show dependent code

IGS_FI_REFUNDS_PROCESS - show dependent code

IGS_FI_REFUNDS_PROCESS - show dependent code

IGS_GE_GEN_002 - show dependent code

IGS_GE_PRC_TRANSFER - show dependent code

IGS_GR_GRD_LGCY_PUB - show dependent code

IGS_HE_EXTRACT2_PKG - show dependent code

IGS_HE_EXTRACT_FIELDS_PKG - show dependent code

IGS_HE_EXTRACT_FIELDS_PKG - show dependent code

IGS_HE_EXTRACT_PKG - show dependent code

IGS_HE_FTE_CALC_PKG - show dependent code

IGS_HE_IMPORT_DATA - show dependent code

IGS_HE_ST_SPA_DTLS_V

IGS_HE_UCAS_TARIFF_PKG - show dependent code

IGS_HE_VERIFY_RETURN_PKG - show dependent code

IGS_OR_INST_IMP_003_PKG - show dependent code

IGS_OR_INST_IMP_003_PKG - show dependent code

IGS_PE_DUP_PAIRS_V

IGS_PE_GEN_001 - show dependent code

IGS_PE_GEN_001 - show dependent code

IGS_PE_PERSON_PKG - show dependent code

IGS_PE_RELATIONSHIPS_PKG - show dependent code

IGS_PE_USERID_PKG - show dependent code

IGS_PR_ACAD_PROGRAM_V

IGS_PR_CLSRNK_LGCY_PUB - show dependent code

IGS_PR_COHINST_RANK_PKG - show dependent code

IGS_PR_DISPLAY_V

IGS_PR_GEN_004 - show dependent code

IGS_PR_GEN_006 - show dependent code

IGS_PR_PROG_OUT_WF_PKG - show dependent code

IGS_PR_PROUT_LGCY_PUB - show dependent code

IGS_PS_CREATE_GENERIC_PKG - show dependent code

IGS_PS_OFR_OPT_PKG - show dependent code

IGS_PS_UNIT_VER_PKG - show dependent code

IGS_PS_USEC_SCHEDULE - show dependent code

IGS_PS_VALIDATE_LGCY_PKG - show dependent code

IGS_PS_VAL_UOO - show dependent code

IGS_PS_WF_EVENT_HOOK_PKG - show dependent code

IGS_RE_GEN_003 - show dependent code

IGS_RE_SPRVSR_LGCY_PUB - show dependent code

IGS_RE_VAL_RSUP - show dependent code

IGS_RE_VAL_TEX - show dependent code

IGS_RE_WORKFLOW - show dependent code

IGS_RU_GEN_001 - show dependent code

IGS_SC_BULK_ASSIGN - show dependent code

IGS_SS_EN_WRAPPERS - show dependent code

IGS_SS_PERSON_SEARCH_V

IGS_ST_GEN_002 - show dependent code

IGS_ST_GEN_003 - show dependent code

IGS_ST_GEN_004 - show dependent code

IGS_SV_BATCH_PROCESS_PKG - show dependent code

IGS_TR_GEN_002 - show dependent code

IGS_UC_EXPORT_HESA_TO_OSS_PKG - show dependent code

IGS_UC_EXPORT_HESA_TO_OSS_PKG - show dependent code

IGS_UC_EXPORT_TO_OSS - show dependent code

IGS_UC_EXP_APPLICANT_DTLS - show dependent code

IGS_UC_TRX_GEN_HOOK - show dependent code

IGS_UC_TRX_GEN_HOOK - show dependent code