[Home] [Help] [Dependency Information]

VIEW: APPS.IGF_AP_ISIR_SAR_V

Object Details

Object Name:	IGF_AP_ISIR_SAR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_AP_ISIR_SAR_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ISIR_ID
,      BASE_ID
,      ORIGINAL_SSN
,      ORIG_NAME_ID
,      TRANSACTION_NUM
,      PAID_EFC
,      TRAN_SOURCE_SITE_CODE
,      LAST_NAME
,      FIRST_NAME
,      MIDDLE_INITIAL
,      PERM_MAIL_ADD
,      PERM_CITY
,      PERM_STATE
,      PERM_ZIP_CODE
,      CURRENT_SSN
,      DATE_OF_BIRTH
,      PHONE_NUMBER
,      DRIVER_LICENSE_STATE
,      CITIZENSHIP_STATUS
,      ALIEN_REG_NUMBER
,      S_MARITAL_STATUS
,      S_MARITAL_STATUS_DATE
,      SUMM_ENRL_STATUS
,      FALL_ENRL_STATUS
,      WINTER_ENRL_STATUS
,      SPRING_ENRL_STATUS
,      SUMM2_ENRL_STATUS
,      FATHERS_HIGHEST_EDU_LEVEL
,      MOTHERS_HIGHEST_EDU_LEVEL
,      S_STATE_LEGAL_RESIDENCE
,      LEGAL_RESIDENCE_BEFORE_DATE
,      S_LEGAL_RESD_DATE
,      SS_R_U_MALE
,      DEGREE_CERTIFICATION
,      GRADE_LEVEL_IN_COLLEGE
,      HIGH_SCHOOL_DIPLOMA_GED
,      FIRST_BACHELOR_DEG_BY_DATE
,      INTEREST_IN_STUD_EMPLOYMENT
,      DRUG_OFFENCE_CONVICTION
,      S_TAX_RETURN_STATUS
,      S_TYPE_TAX_RETURN
,      S_ELIG_1040EZ
,      S_ADJUSTED_GROSS_INCOME
,      S_FED_TAXES_PAID
,      S_EXEMPTIONS
,      S_INCOME_FROM_WORK
,      SPOUSE_INCOME_FROM_WORK
,      S_TOA_AMT_FROM_WSA
,      S_TOA_AMT_FROM_WSB
,      S_TOA_AMT_FROM_WSC
,      S_INVESTMENT_NETWORTH
,      S_BUSI_FARM_NETWORTH
,      S_CASH_SAVINGS
,      VA_MONTHS
,      VA_AMOUNT
,      STUD_DOB_BEFORE_DATE
,      DEG_BEYOND_BACHELOR
,      S_MARRIED
,      S_HAVE_CHILDREN
,      ORPHAN_WARD_OF_COURT
,      S_VETERAN
,      P_MARITAL_STATUS
,      FATHER_SSN
,      F_LAST_NAME
,      MOTHER_SSN
,      M_LAST_NAME
,      P_NUM_FAMILY_MEMBER
,      P_NUM_IN_COLLEGE
,      P_STATE_LEGAL_RESIDENCE
,      AGE_OLDER_PARENT
,      P_TAX_RETURN_STATUS
,      P_TYPE_TAX_RETURN
,      P_ELIG_1040AEZ
,      P_ADJUSTED_GROSS_INCOME
,      P_TAXES_PAID
,      P_EXEMPTIONS
,      F_INCOME_WORK
,      M_INCOME_WORK
,      P_INCOME_WSA
,      P_INCOME_WSB
,      P_INCOME_WSC
,      P_INVESTMENT_NETWORTH
,      P_BUSINESS_NETWORTH
,      P_CASH_SAVING
,      S_NUM_FAMILY_MEMBERS
,      S_NUM_IN_COLLEGE
,      FIRST_COLLEGE
,      FIRST_HOUSE_PLAN
,      SECOND_COLLEGE
,      SECOND_HOUSE_PLAN
,      THIRD_COLLEGE
,      THIRD_HOUSE_PLAN
,      FOURTH_COLLEGE
,      FOURTH_HOUSE_PLAN
,      FIFTH_COLLEGE
,      FIFTH_HOUSE_PLAN
,      SIXTH_COLLEGE
,      SIXTH_HOUSE_PLAN
,      DATE_APP_COMPLETED
,      SIGNED_BY
,      PREPARER_SSN
,      PREPARER_EMP_ID_NUMBER
,      PREPARER_SIGN
,      TRANSACTION_RECEIPT_DATE
,      FAA_FEDRAL_SCHL_CODE
,      FAA_ADJUSTMENT
,      SSN_NAME_CHANGE
,      EARLY_ANALYSIS_FLAG
,      SERIAL_NUMBER
,      DEPENDENCY_STATUS
,      VERIFICATION_FLAG
,      DRIVER_LICENSE_NUMBER
,      SELECTIVE_SERVICE_REG
,      INTEREST_IN_LOAN
,      P_STATE_LEGAL_RES_BEFORE_DT
,      P_LEGAL_RES_DATE
,      DEPENDENCY_OVERRIDE_IND
,      LEGAL_DEPENDENTS
,      SYSTEM_RECORD_TYPE
,      TRANSACTION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      VERIF_TRACK_FLAG
FROM APPS.IGF_AP_ISIR_SAR_V;

Dependencies

[top of page]

APPS

IGF_AP_ISIR_MATCHED

APPS.IGF_AP_ISIR_SAR_V is not referenced by any database object