[Home] [Help] [Dependency Information]
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 |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ISIR_ID | NUMBER | (15) | Yes | |
BASE_ID | NUMBER | (15) | Yes | |
ORIGINAL_SSN | VARCHAR2 | (9) | ||
ORIG_NAME_ID | VARCHAR2 | (2) | ||
TRANSACTION_NUM | VARCHAR2 | (2) | Yes | |
PAID_EFC | NUMBER | (12) | ||
TRAN_SOURCE_SITE_CODE | VARCHAR2 | (30) | ||
LAST_NAME | VARCHAR2 | (16) | ||
FIRST_NAME | VARCHAR2 | (12) | ||
MIDDLE_INITIAL | VARCHAR2 | (1) | ||
PERM_MAIL_ADD | VARCHAR2 | (35) | ||
PERM_CITY | VARCHAR2 | (16) | ||
PERM_STATE | VARCHAR2 | (2) | ||
PERM_ZIP_CODE | VARCHAR2 | (5) | ||
CURRENT_SSN | VARCHAR2 | (9) | Yes | |
DATE_OF_BIRTH | DATE | |||
PHONE_NUMBER | VARCHAR2 | (10) | ||
DRIVER_LICENSE_STATE | VARCHAR2 | (30) | ||
CITIZENSHIP_STATUS | VARCHAR2 | (30) | ||
ALIEN_REG_NUMBER | VARCHAR2 | (9) | ||
S_MARITAL_STATUS | VARCHAR2 | (30) | ||
S_MARITAL_STATUS_DATE | DATE | |||
SUMM_ENRL_STATUS | VARCHAR2 | (30) | ||
FALL_ENRL_STATUS | VARCHAR2 | (30) | ||
WINTER_ENRL_STATUS | VARCHAR2 | (30) | ||
SPRING_ENRL_STATUS | VARCHAR2 | (30) | ||
SUMM2_ENRL_STATUS | VARCHAR2 | (30) | ||
FATHERS_HIGHEST_EDU_LEVEL | VARCHAR2 | (1) | ||
MOTHERS_HIGHEST_EDU_LEVEL | VARCHAR2 | (1) | ||
S_STATE_LEGAL_RESIDENCE | VARCHAR2 | (30) | ||
LEGAL_RESIDENCE_BEFORE_DATE | VARCHAR2 | (2) | ||
S_LEGAL_RESD_DATE | DATE | |||
SS_R_U_MALE | VARCHAR2 | (1) | ||
DEGREE_CERTIFICATION | VARCHAR2 | (30) | ||
GRADE_LEVEL_IN_COLLEGE | VARCHAR2 | (30) | ||
HIGH_SCHOOL_DIPLOMA_GED | VARCHAR2 | (1) | ||
FIRST_BACHELOR_DEG_BY_DATE | VARCHAR2 | (1) | ||
INTEREST_IN_STUD_EMPLOYMENT | VARCHAR2 | (1) | ||
DRUG_OFFENCE_CONVICTION | VARCHAR2 | (30) | ||
S_TAX_RETURN_STATUS | VARCHAR2 | (30) | ||
S_TYPE_TAX_RETURN | VARCHAR2 | (30) | ||
S_ELIG_1040EZ | VARCHAR2 | (30) | ||
S_ADJUSTED_GROSS_INCOME | NUMBER | (12) | ||
S_FED_TAXES_PAID | NUMBER | (12) | ||
S_EXEMPTIONS | NUMBER | (2) | ||
S_INCOME_FROM_WORK | NUMBER | (12) | ||
SPOUSE_INCOME_FROM_WORK | NUMBER | (12) | ||
S_TOA_AMT_FROM_WSA | NUMBER | (12) | ||
S_TOA_AMT_FROM_WSB | NUMBER | (12) | ||
S_TOA_AMT_FROM_WSC | NUMBER | (12) | ||
S_INVESTMENT_NETWORTH | NUMBER | (12) | ||
S_BUSI_FARM_NETWORTH | NUMBER | (12) | ||
S_CASH_SAVINGS | NUMBER | (12) | ||
VA_MONTHS | NUMBER | (2) | ||
VA_AMOUNT | NUMBER | (15) | ||
STUD_DOB_BEFORE_DATE | VARCHAR2 | (1) | ||
DEG_BEYOND_BACHELOR | VARCHAR2 | (1) | ||
S_MARRIED | VARCHAR2 | (1) | ||
S_HAVE_CHILDREN | VARCHAR2 | (1) | ||
ORPHAN_WARD_OF_COURT | VARCHAR2 | (1) | ||
S_VETERAN | VARCHAR2 | (1) | ||
P_MARITAL_STATUS | VARCHAR2 | (30) | ||
FATHER_SSN | VARCHAR2 | (9) | ||
F_LAST_NAME | VARCHAR2 | (16) | ||
MOTHER_SSN | VARCHAR2 | (9) | ||
M_LAST_NAME | VARCHAR2 | (16) | ||
P_NUM_FAMILY_MEMBER | NUMBER | (2) | ||
P_NUM_IN_COLLEGE | NUMBER | (1) | ||
P_STATE_LEGAL_RESIDENCE | VARCHAR2 | (30) | ||
AGE_OLDER_PARENT | NUMBER | (2) | ||
P_TAX_RETURN_STATUS | VARCHAR2 | (30) | ||
P_TYPE_TAX_RETURN | VARCHAR2 | (1) | ||
P_ELIG_1040AEZ | VARCHAR2 | (30) | ||
P_ADJUSTED_GROSS_INCOME | NUMBER | (12) | ||
P_TAXES_PAID | NUMBER | (12) | ||
P_EXEMPTIONS | NUMBER | (2) | ||
F_INCOME_WORK | NUMBER | (12) | ||
M_INCOME_WORK | NUMBER | (12) | ||
P_INCOME_WSA | NUMBER | (12) | ||
P_INCOME_WSB | NUMBER | (12) | ||
P_INCOME_WSC | NUMBER | (12) | ||
P_INVESTMENT_NETWORTH | NUMBER | (12) | ||
P_BUSINESS_NETWORTH | NUMBER | (12) | ||
P_CASH_SAVING | NUMBER | (12) | ||
S_NUM_FAMILY_MEMBERS | NUMBER | (2) | ||
S_NUM_IN_COLLEGE | NUMBER | (1) | ||
FIRST_COLLEGE | VARCHAR2 | (30) | ||
FIRST_HOUSE_PLAN | VARCHAR2 | (30) | ||
SECOND_COLLEGE | VARCHAR2 | (30) | ||
SECOND_HOUSE_PLAN | VARCHAR2 | (30) | ||
THIRD_COLLEGE | VARCHAR2 | (30) | ||
THIRD_HOUSE_PLAN | VARCHAR2 | (30) | ||
FOURTH_COLLEGE | VARCHAR2 | (30) | ||
FOURTH_HOUSE_PLAN | VARCHAR2 | (30) | ||
FIFTH_COLLEGE | VARCHAR2 | (30) | ||
FIFTH_HOUSE_PLAN | VARCHAR2 | (30) | ||
SIXTH_COLLEGE | VARCHAR2 | (30) | ||
SIXTH_HOUSE_PLAN | VARCHAR2 | (30) | ||
DATE_APP_COMPLETED | DATE | |||
SIGNED_BY | VARCHAR2 | (30) | ||
PREPARER_SSN | VARCHAR2 | (9) | ||
PREPARER_EMP_ID_NUMBER | VARCHAR2 | (9) | ||
PREPARER_SIGN | VARCHAR2 | (1) | ||
TRANSACTION_RECEIPT_DATE | DATE | |||
FAA_FEDRAL_SCHL_CODE | VARCHAR2 | (30) | ||
FAA_ADJUSTMENT | VARCHAR2 | (1) | ||
SSN_NAME_CHANGE | VARCHAR2 | (30) | ||
EARLY_ANALYSIS_FLAG | VARCHAR2 | (1) | ||
SERIAL_NUMBER | NUMBER | (15) | ||
DEPENDENCY_STATUS | VARCHAR2 | (30) | ||
VERIFICATION_FLAG | VARCHAR2 | (1) | ||
DRIVER_LICENSE_NUMBER | VARCHAR2 | (20) | ||
SELECTIVE_SERVICE_REG | VARCHAR2 | (1) | ||
INTEREST_IN_LOAN | VARCHAR2 | (1) | ||
P_STATE_LEGAL_RES_BEFORE_DT | VARCHAR2 | (2) | ||
P_LEGAL_RES_DATE | DATE | |||
DEPENDENCY_OVERRIDE_IND | VARCHAR2 | (30) | ||
LEGAL_DEPENDENTS | VARCHAR2 | (1) | ||
SYSTEM_RECORD_TYPE | VARCHAR2 | (30) | ||
TRANSACTION_ID | VARCHAR2 | (13) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
VERIF_TRACK_FLAG | VARCHAR2 | (30) |
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;
APPS.IGF_AP_ISIR_SAR_V is not referenced by any database object
|
|
|