[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_ISIR_INTRFACE |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGF_AP_ISIR_INTRFACE
|
| Subobject Name: | |
| Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| SI_ID | NUMBER | (15) | Yes | |
| BATCH_YEAR | NUMBER | (1) | Yes | |
| TRANSACTION_NUM | VARCHAR2 | (2) | Yes | |
| RECORD_STATUS | VARCHAR2 | (10) | ||
| SSN_NAME_CHANGE | VARCHAR2 | (1) | ||
| ORIGINAL_SSN | VARCHAR2 | (9) | ||
| ORIG_NAME_ID | VARCHAR2 | (2) | ||
| CURRENT_SSN | VARCHAR2 | (9) | ||
| LAST_NAME | VARCHAR2 | (16) | ||
| FIRST_NAME | VARCHAR2 | (12) | Yes | |
| MIDDLE_INITIAL | VARCHAR2 | (1) | ||
| PERM_MAIL_ADD | VARCHAR2 | (35) | ||
| PERM_CITY | VARCHAR2 | (16) | ||
| PERM_STATE | VARCHAR2 | (2) | ||
| PERM_ZIP_CODE | VARCHAR2 | (5) | ||
| DATE_OF_BIRTH | DATE | |||
| PHONE_NUMBER | VARCHAR2 | (10) | ||
| DRIVER_LICENSE_NUMBER | VARCHAR2 | (20) | ||
| DRIVER_LICENSE_STATE | VARCHAR2 | (2) | ||
| CITIZENSHIP_STATUS | VARCHAR2 | (1) | ||
| ALIEN_REG_NUMBER | VARCHAR2 | (9) | ||
| S_MARITAL_STATUS | VARCHAR2 | (1) | ||
| S_MARITAL_STATUS_DATE | DATE | |||
| SUMM_ENRL_STATUS | VARCHAR2 | (1) | ||
| FALL_ENRL_STATUS | VARCHAR2 | (1) | ||
| WINTER_ENRL_STATUS | VARCHAR2 | (1) | ||
| SPRING_ENRL_STATUS | VARCHAR2 | (1) | ||
| SUMM2_ENRL_STATUS | VARCHAR2 | (1) | ||
| FATHERS_HIGHEST_EDU_LEVEL | VARCHAR2 | (1) | ||
| MOTHERS_HIGHEST_EDU_LEVEL | VARCHAR2 | (1) | ||
| S_STATE_LEGAL_RESIDENCE | VARCHAR2 | (2) | ||
| LEGAL_RESIDENCE_BEFORE_DATE | VARCHAR2 | (1) | ||
| S_LEGAL_RESD_DATE | DATE | |||
| SS_R_U_MALE | VARCHAR2 | (1) | ||
| SELECTIVE_SERVICE_REG | VARCHAR2 | (1) | ||
| DEGREE_CERTIFICATION | VARCHAR2 | (1) | ||
| GRADE_LEVEL_IN_COLLEGE | VARCHAR2 | (1) | ||
| HIGH_SCHOOL_DIPLOMA_GED | VARCHAR2 | (1) | ||
| FIRST_BACHELOR_DEG_BY_DATE | VARCHAR2 | (1) | ||
| INTEREST_IN_LOAN | VARCHAR2 | (1) | ||
| INTEREST_IN_STUD_EMPLOYMENT | VARCHAR2 | (1) | ||
| DRUG_OFFENCE_CONVICTION | VARCHAR2 | (1) | ||
| S_TAX_RETURN_STATUS | VARCHAR2 | (1) | ||
| S_TYPE_TAX_RETURN | VARCHAR2 | (1) | ||
| S_ELIG_1040EZ | VARCHAR2 | (1) | ||
| S_ADJUSTED_GROSS_INCOME | VARCHAR2 | (6) | ||
| S_FED_TAXES_PAID | NUMBER | (5) | ||
| S_EXEMPTIONS | NUMBER | (2) | ||
| S_INCOME_FROM_WORK | VARCHAR2 | (6) | ||
| SPOUSE_INCOME_FROM_WORK | VARCHAR2 | (6) | ||
| S_TOA_AMT_FROM_WSA | NUMBER | (5) | ||
| S_TOA_AMT_FROM_WSB | NUMBER | (5) | ||
| S_TOA_AMT_FROM_WSC | NUMBER | (5) | ||
| S_INVESTMENT_NETWORTH | NUMBER | (6) | ||
| S_BUSI_FARM_NETWORTH | NUMBER | (6) | ||
| S_CASH_SAVINGS | NUMBER | (6) | ||
| 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) | ||
| LEGAL_DEPENDENTS | VARCHAR2 | (1) | ||
| ORPHAN_WARD_OF_COURT | VARCHAR2 | (1) | ||
| S_VETERAN | VARCHAR2 | (1) | ||
| P_MARITAL_STATUS | VARCHAR2 | (1) | ||
| 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 | (2) | ||
| P_STATE_LEGAL_RES_BEFORE_DT | VARCHAR2 | (1) | ||
| P_LEGAL_RES_DATE | DATE | |||
| AGE_OLDER_PARENT | NUMBER | (2) | ||
| P_TAX_RETURN_STATUS | VARCHAR2 | (1) | ||
| P_TYPE_TAX_RETURN | VARCHAR2 | (1) | ||
| P_ELIG_1040AEZ | VARCHAR2 | (1) | ||
| P_ADJUSTED_GROSS_INCOME | VARCHAR2 | (6) | ||
| P_TAXES_PAID | NUMBER | (6) | ||
| P_EXEMPTIONS | NUMBER | (2) | ||
| F_INCOME_WORK | VARCHAR2 | (6) | ||
| M_INCOME_WORK | VARCHAR2 | (6) | ||
| P_INCOME_WSA | NUMBER | (5) | ||
| P_INCOME_WSB | NUMBER | (5) | ||
| P_INCOME_WSC | NUMBER | (5) | ||
| P_INVESTMENT_NETWORTH | NUMBER | (6) | ||
| P_BUSINESS_NETWORTH | NUMBER | (6) | ||
| P_CASH_SAVING | NUMBER | (6) | ||
| S_NUM_FAMILY_MEMBERS | NUMBER | (2) | ||
| S_NUM_IN_COLLEGE | NUMBER | (1) | ||
| FIRST_COLLEGE | VARCHAR2 | (6) | ||
| FIRST_HOUSE_PLAN | VARCHAR2 | (1) | ||
| SECOND_COLLEGE | VARCHAR2 | (6) | ||
| SECOND_HOUSE_PLAN | VARCHAR2 | (1) | ||
| THIRD_COLLEGE | VARCHAR2 | (6) | ||
| THIRD_HOUSE_PLAN | VARCHAR2 | (1) | ||
| FOURTH_COLLEGE | VARCHAR2 | (6) | ||
| FOURTH_HOUSE_PLAN | VARCHAR2 | (1) | ||
| FIFTH_COLLEGE | VARCHAR2 | (6) | ||
| FIFTH_HOUSE_PLAN | VARCHAR2 | (1) | ||
| SIXTH_COLLEGE | VARCHAR2 | (6) | ||
| SIXTH_HOUSE_PLAN | VARCHAR2 | (1) | ||
| DATE_APP_COMPLETED | DATE | |||
| SIGNED_BY | VARCHAR2 | (1) | ||
| PREPARER_SSN | VARCHAR2 | (9) | ||
| PREPARER_EMP_ID_NUMBER | VARCHAR2 | (9) | ||
| PREPARER_SIGN | VARCHAR2 | (1) | ||
| TRANSACTION_RECEIPT_DATE | DATE | |||
| DEPENDENCY_OVERRIDE_IND | VARCHAR2 | (1) | ||
| FAA_FEDRAL_SCHL_CODE | VARCHAR2 | (6) | ||
| FAA_ADJUSTMENT | VARCHAR2 | (1) | ||
| INPUT_RECORD_TYPE | VARCHAR2 | (1) | ||
| SERIAL_NUMBER | NUMBER | (5) | ||
| BATCH_NUMBER | VARCHAR2 | (23) | ||
| EARLY_ANALYSIS_FLAG | VARCHAR2 | (1) | ||
| APP_ENTRY_SOURCE_CODE | VARCHAR2 | (1) | ||
| ETI_DESTINATION_CODE | VARCHAR2 | (7) | ||
| REJECT_OVERRIDE_B | VARCHAR2 | (1) | ||
| REJECT_OVERRIDE_N | VARCHAR2 | (1) | ||
| REJECT_OVERRIDE_W | VARCHAR2 | (1) | ||
| ASSUM_OVERRIDE_1 | VARCHAR2 | (1) | ||
| ASSUM_OVERRIDE_2 | VARCHAR2 | (1) | ||
| ASSUM_OVERRIDE_3 | VARCHAR2 | (1) | ||
| ASSUM_OVERRIDE_4 | VARCHAR2 | (1) | ||
| ASSUM_OVERRIDE_5 | VARCHAR2 | (1) | ||
| ASSUM_OVERRIDE_6 | VARCHAR2 | (1) | ||
| DEPENDENCY_STATUS | VARCHAR2 | (1) | ||
| S_EMAIL_ADDRESS | VARCHAR2 | (50) | ||
| NSLDS_REASON_CODE | VARCHAR2 | (30) | ||
| APP_RECEIPT_DATE | DATE | |||
| PROCESSED_REC_TYPE | VARCHAR2 | (1) | ||
| HIST_CORRECTION_FOR_TRAN_ID | NUMBER | (2) | ||
| SYSTEM_GENERATED_INDICATOR | VARCHAR2 | (1) | ||
| DUP_REQUEST_INDICATOR | VARCHAR2 | (1) | ||
| SOURCE_OF_CORRECTION | VARCHAR2 | (1) | ||
| P_CAL_TAX_STATUS | VARCHAR2 | (1) | ||
| S_CAL_TAX_STATUS | VARCHAR2 | (1) | ||
| GRADUATE_FLAG | VARCHAR2 | (1) | ||
| AUTO_ZERO_EFC | VARCHAR2 | (1) | ||
| EFC_CHANGE_FLAG | VARCHAR2 | (1) | ||
| SARC_FLAG | VARCHAR2 | (1) | ||
| SIMPLIFIED_NEED_TEST | VARCHAR2 | (1) | ||
| REJECT_REASON_CODES | VARCHAR2 | (14) | ||
| SELECT_SERVICE_MATCH_FLAG | VARCHAR2 | (1) | ||
| SELECT_SERVICE_REG_FLAG | VARCHAR2 | (1) | ||
| INS_MATCH_FLAG | VARCHAR2 | (1) | ||
| INS_VERIFICATION_NUMBER | VARCHAR2 | (0) | Identification number provided by Immigration and Naturalization Service indicating primary verification was performed - No longer used | |
| SEC_INS_MATCH_FLAG | VARCHAR2 | (1) | ||
| SEC_INS_VER_NUMBER | NUMBER | (15) | ||
| SSN_MATCH_FLAG | VARCHAR2 | (1) | ||
| SSA_CITIZENSHIP_FLAG | VARCHAR2 | (1) | ||
| SSN_DATE_OF_DEATH | DATE | |||
| NSLDS_MATCH_FLAG | VARCHAR2 | (1) | ||
| VA_MATCH_FLAG | VARCHAR2 | (1) | ||
| PRISONER_MATCH | VARCHAR2 | (1) | ||
| VERIFICATION_FLAG | VARCHAR2 | (1) | ||
| SUBSEQUENT_APP_FLAG | VARCHAR2 | (1) | ||
| APP_SOURCE_SITE_CODE | VARCHAR2 | (2) | ||
| TRAN_SOURCE_SITE_CODE | VARCHAR2 | (2) | ||
| DRN | NUMBER | (4) | ||
| TRAN_PROCESS_DATE | DATE | |||
| CORRECTION_FLAGS | VARCHAR2 | (120) | ||
| COMPUTER_BATCH_NUMBER | NUMBER | (3) | ||
| HIGHLIGHT_FLAGS | VARCHAR2 | (120) | ||
| PAID_EFC | NUMBER | (5) | ||
| PRIMARY_EFC | NUMBER | (5) | ||
| SECONDARY_EFC | NUMBER | (5) | ||
| FED_PELL_GRANT_EFC_TYPE | VARCHAR2 | (1) | ||
| PRIMARY_EFC_TYPE | VARCHAR2 | (1) | ||
| SEC_EFC_TYPE | VARCHAR2 | (1) | ||
| PRIMARY_ALTERNATE_MONTH_1 | NUMBER | (5) | ||
| PRIMARY_ALTERNATE_MONTH_2 | NUMBER | (5) | ||
| PRIMARY_ALTERNATE_MONTH_3 | NUMBER | (5) | ||
| PRIMARY_ALTERNATE_MONTH_4 | NUMBER | (5) | ||
| PRIMARY_ALTERNATE_MONTH_5 | NUMBER | (5) | ||
| PRIMARY_ALTERNATE_MONTH_6 | NUMBER | (5) | ||
| PRIMARY_ALTERNATE_MONTH_7 | NUMBER | (5) | ||
| PRIMARY_ALTERNATE_MONTH_8 | NUMBER | (5) | ||
| PRIMARY_ALTERNATE_MONTH_10 | NUMBER | (5) | ||
| PRIMARY_ALTERNATE_MONTH_11 | NUMBER | (5) | ||
| PRIMARY_ALTERNATE_MONTH_12 | NUMBER | (5) | ||
| SEC_ALTERNATE_MONTH_1 | NUMBER | (5) | ||
| SEC_ALTERNATE_MONTH_2 | NUMBER | (5) | ||
| SEC_ALTERNATE_MONTH_3 | NUMBER | (5) | ||
| SEC_ALTERNATE_MONTH_4 | NUMBER | (5) | ||
| SEC_ALTERNATE_MONTH_5 | NUMBER | (5) | ||
| SEC_ALTERNATE_MONTH_6 | NUMBER | (5) | ||
| SEC_ALTERNATE_MONTH_7 | NUMBER | (5) | ||
| SEC_ALTERNATE_MONTH_8 | NUMBER | (5) | ||
| SEC_ALTERNATE_MONTH_10 | NUMBER | (5) | ||
| SEC_ALTERNATE_MONTH_11 | NUMBER | (5) | ||
| SEC_ALTERNATE_MONTH_12 | NUMBER | (5) | ||
| TOTAL_INCOME | VARCHAR2 | (7) | ||
| ALLOW_TOTAL_INCOME | NUMBER | (7) | ||
| STATE_TAX_ALLOW | VARCHAR2 | (7) | ||
| EMPLOYMENT_ALLOW | NUMBER | (7) | ||
| INCOME_PROTECTION_ALLOW | NUMBER | (7) | ||
| AVAILABLE_INCOME | VARCHAR2 | (7) | ||
| CONTRIBUTION_FROM_AI | VARCHAR2 | (7) | ||
| DISCRETIONARY_NETWORTH | VARCHAR2 | (9) | ||
| EFC_NETWORTH | NUMBER | (9) | ||
| ASSET_PROTECT_ALLOW | NUMBER | (9) | ||
| PARENTS_CONT_FROM_ASSETS | VARCHAR2 | (7) | ||
| ADJUSTED_AVAILABLE_INCOME | VARCHAR2 | (7) | ||
| TOTAL_STUDENT_CONTRIBUTION | NUMBER | (7) | ||
| TOTAL_PARENT_CONTRIBUTION | NUMBER | (7) | ||
| PARENTS_CONTRIBUTION | NUMBER | (7) | ||
| STUDENT_TOTAL_INCOME | VARCHAR2 | (7) | ||
| SATI | VARCHAR2 | (7) | ||
| SIC | NUMBER | (7) | ||
| SDNW | VARCHAR2 | (9) | ||
| SCA | VARCHAR2 | (7) | ||
| FTI | VARCHAR2 | (7) | ||
| SECTI | VARCHAR2 | (7) | ||
| SECATI | NUMBER | (7) | ||
| SECSTX | VARCHAR2 | (7) | ||
| SECEA | NUMBER | (7) | ||
| SECIPA | NUMBER | (7) | ||
| SECAI | VARCHAR2 | (7) | ||
| SECCAI | VARCHAR2 | (7) | ||
| SECDNW | VARCHAR2 | (9) | ||
| SECNW | NUMBER | (9) | ||
| SECAPA | NUMBER | (9) | ||
| SECPCA | VARCHAR2 | (7) | ||
| SECAAI | VARCHAR2 | (7) | ||
| SECTSC | NUMBER | (7) | ||
| SECTPC | NUMBER | (7) | ||
| SECPC | NUMBER | (7) | ||
| SECSTI | VARCHAR2 | (7) | ||
| SECSATI | VARCHAR2 | (7) | ||
| SECSIC | NUMBER | (7) | ||
| SECSDNW | VARCHAR2 | (9) | ||
| SECSCA | VARCHAR2 | (7) | ||
| SECFTI | VARCHAR2 | (7) | ||
| A_CITIZENSHIP | VARCHAR2 | (1) | ||
| A_STUDENT_MARITAL_STATUS | VARCHAR2 | (1) | ||
| A_STUDENT_AGI | VARCHAR2 | (6) | ||
| A_S_US_TAX_PAID | NUMBER | (5) | ||
| A_S_INCOME_WORK | VARCHAR2 | (6) | ||
| A_SPOUSE_INCOME_WORK | VARCHAR2 | (6) | ||
| A_S_TOTAL_WSC | NUMBER | (5) | ||
| A_DATE_OF_BIRTH | VARCHAR2 | (1) | ||
| A_STUDENT_MARRIED | VARCHAR2 | (1) | ||
| A_HAVE_CHILDREN | VARCHAR2 | (1) | ||
| A_S_HAVE_DEPENDENTS | VARCHAR2 | (1) | ||
| A_VA_STATUS | VARCHAR2 | (1) | ||
| A_S_NUM_IN_FAMILY | NUMBER | (2) | ||
| A_S_NUM_IN_COLLEGE | NUMBER | (1) | ||
| A_P_MARITAL_STATUS | VARCHAR2 | (1) | ||
| A_FATHER_SSN | VARCHAR2 | (9) | ||
| A_MOTHER_SSN | VARCHAR2 | (9) | ||
| A_PARENTS_NUM_FAMILY | NUMBER | (2) | ||
| A_PARENTS_NUM_COLLEGE | NUMBER | (1) | ||
| A_PARENTS_AGI | VARCHAR2 | (6) | ||
| A_P_US_TAX_PAID | NUMBER | (6) | ||
| A_F_WORK_INCOME | VARCHAR2 | (6) | ||
| A_M_WORK_INCOME | VARCHAR2 | (6) | ||
| A_P_TOTAL_WSC | NUMBER | (5) | ||
| COMMENT_CODES | VARCHAR2 | (60) | ||
| SAR_ACK_COMM_CODE | VARCHAR2 | (20) | ||
| PELL_GRANT_ELIG_FLAG | VARCHAR2 | (1) | ||
| REPROCESS_REASON_CODE | VARCHAR2 | (2) | ||
| DUPLICATE_DATE | DATE | |||
| ISIR_TRANSACTION_TYPE | VARCHAR2 | (1) | ||
| FEDRAL_SCHL_CODE_INDICATOR | VARCHAR2 | (1) | ||
| MULTI_SCHOOL_CODE_FLAGS | VARCHAR2 | (6) | ||
| DUP_SSN_INDICATOR | VARCHAR2 | (1) | ||
| NSLDS_TRANSACTION_NUM | NUMBER | (2) | ||
| NSLDS_DATABASE_RESULTS_F | VARCHAR2 | (1) | ||
| NSLDS_F | VARCHAR2 | (1) | ||
| NSLDS_PELL_OVERPAY_F | VARCHAR2 | (1) | ||
| NSLDS_PELL_OVERPAY_CONTACT | VARCHAR2 | (8) | ||
| NSLDS_SEOG_OVERPAY_F | VARCHAR2 | (1) | ||
| NSLDS_SEOG_OVERPAY_CONTACT | VARCHAR2 | (8) | ||
| NSLDS_PERKINS_OVERPAY_F | VARCHAR2 | (1) | ||
| NSLDS_PERKINS_OVERPAY_CNTCT | VARCHAR2 | (8) | ||
| NSLDS_DEFAULTED_LOAN_F | VARCHAR2 | (1) | ||
| NSLDS_DISCHARGED_LOAN_F | VARCHAR2 | (1) | ||
| NSLDS_SATIS_REPAY_F | VARCHAR2 | (1) | ||
| NSLDS_ACT_BANKRUPTCY_F | VARCHAR2 | (1) | ||
| NSLDS_AGG_SUBSZ_OUT_PRIN_BAL | VARCHAR2 | (6) | ||
| NSLDS_AGG_UNSBZ_OUT_PRIN_BAL | VARCHAR2 | (6) | ||
| NSLDS_AGG_COMB_OUT_PRIN_BAL | VARCHAR2 | (6) | ||
| NSLDS_AGG_CONS_OUT_PRIN_BAL | VARCHAR2 | (6) | ||
| NSLDS_AGG_SUBSZ_PEND_DISMNT | VARCHAR2 | (6) | ||
| NSLDS_AGG_UNSBZ_PEND_DISMNT | VARCHAR2 | (6) | ||
| NSLDS_AGG_COMB_PEND_DISMNT | VARCHAR2 | (6) | ||
| NSLDS_AGG_SUBSZ_TOTAL | VARCHAR2 | (6) | ||
| NSLDS_AGG_UNSBZ_TOTAL | VARCHAR2 | (6) | ||
| NSLDS_AGG_COMB_TOTAL | VARCHAR2 | (6) | ||
| NSLDS_AGG_CONSD_TOTAL | VARCHAR2 | (6) | ||
| NSLDS_PERKINS_OUT_BAL | VARCHAR2 | (6) | ||
| NSLDS_PERKINS_CUR_YR_DISMNT | VARCHAR2 | (6) | ||
| NSLDS_DEFAULT_LOAN_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_DISCHGED_LOAN_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_SATIS_REPAY_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_ACT_BNKRUPT_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_OVERPAY_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_AGG_LOAN_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_PERKINS_LOAN_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_PELL_PAYMNT_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_ADDTNL_PELL_F | VARCHAR2 | (1) | ||
| NSLDS_ADDTNL_LOAN_F | VARCHAR2 | (1) | ||
| DIRECT_LOAN_MAS_PROM_NT_F | VARCHAR2 | (1) | ||
| NSLDS_PELL_SEQ_NUM_1 | NUMBER | (2) | ||
| NSLDS_PELL_VERIFY_F_1 | VARCHAR2 | (3) | ||
| NSLDS_PELL_EFC_1 | NUMBER | (6) | ||
| NSLDS_PELL_SCHOOL_CODE_1 | NUMBER | (8) | ||
| NSLDS_PELL_TRANSCN_NUM_1 | NUMBER | (2) | ||
| NSLDS_PELL_LAST_UPDT_DT_1 | VARCHAR2 | (8) | ||
| NSLDS_PELL_SCHEDULED_AMT_1 | NUMBER | (6) | ||
| NSLDS_PELL_AMT_PAID_TODT_1 | NUMBER | (6) | ||
| NSLDS_PELL_REMNG_AMT_1 | NUMBER | (6) | ||
| NSLDS_PELL_PC_SCHD_AWD_US_1 | NUMBER | (5) | ||
| NSLDS_PELL_AWARD_AMT_1 | NUMBER | (6) | ||
| NSLDS_PELL_SEQ_NUM_2 | NUMBER | (2) | ||
| NSLDS_PELL_VERIFY_F_2 | VARCHAR2 | (3) | ||
| NSLDS_PELL_EFC_2 | NUMBER | (6) | ||
| NSLDS_PELL_SCHOOL_CODE_2 | NUMBER | (8) | ||
| NSLDS_PELL_TRANSCN_NUM_2 | NUMBER | (2) | ||
| NSLDS_PELL_LAST_UPDT_DT_2 | VARCHAR2 | (8) | ||
| NSLDS_PELL_SCHEDULED_AMT_2 | NUMBER | (6) | ||
| NSLDS_PELL_AMT_PAID_TODT_2 | NUMBER | (6) | ||
| NSLDS_PELL_REMNG_AMT_2 | NUMBER | (6) | ||
| NSLDS_PELL_PC_SCHD_AWD_US_2 | NUMBER | (5) | ||
| NSLDS_PELL_AWARD_AMT_2 | NUMBER | (6) | ||
| NSLDS_PELL_SEQ_NUM_3 | NUMBER | (2) | ||
| NSLDS_PELL_VERIFY_F_3 | VARCHAR2 | (3) | ||
| NSLDS_PELL_EFC_3 | NUMBER | (6) | ||
| NSLDS_PELL_SCHOOL_CODE_3 | NUMBER | (8) | ||
| NSLDS_PELL_TRANSCN_NUM_3 | NUMBER | (2) | ||
| NSLDS_PELL_LAST_UPDT_DT_3 | VARCHAR2 | (8) | ||
| NSLDS_PELL_SCHEDULED_AMT_3 | NUMBER | (6) | ||
| NSLDS_PELL_AMT_PAID_TODT_3 | NUMBER | (6) | ||
| NSLDS_PELL_REMNG_AMT_3 | NUMBER | (6) | ||
| NSLDS_PELL_PC_SCHD_AWD_US_3 | NUMBER | (5) | ||
| NSLDS_PELL_AWARD_AMT_3 | NUMBER | (6) | ||
| NSLDS_LOAN_SEQ_NUM_1 | NUMBER | (2) | ||
| NSLDS_LOAN_TYPE_CODE_1 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CHNG_F_1 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_PROG_CODE_1 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_NET_AMNT_1 | NUMBER | (6) | ||
| NSLDS_LOAN_CUR_ST_CODE_1 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_CUR_ST_DATE_1 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_AGG_PR_BAL_1 | VARCHAR2 | (6) | ||
| NSLDS_LOAN_OUT_PR_BAL_DT_1 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_BEGIN_DT_1 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_END_DT_1 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GA_CODE_1 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_CONT_TYPE_1 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_SCHOL_CODE_1 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_CONT_CODE_1 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GRADE_LVL_1 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_XTR_UNSBZ_LN_F_1 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CAPITAL_INT_F_1 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_SEQ_NUM_2 | NUMBER | (2) | ||
| NSLDS_LOAN_TYPE_CODE_2 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CHNG_F_2 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_PROG_CODE_2 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_NET_AMNT_2 | NUMBER | (6) | ||
| NSLDS_LOAN_CUR_ST_CODE_2 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_CUR_ST_DATE_2 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_AGG_PR_BAL_2 | VARCHAR2 | (6) | ||
| NSLDS_LOAN_OUT_PR_BAL_DT_2 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_BEGIN_DT_2 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_END_DT_2 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GA_CODE_2 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_CONT_TYPE_2 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_SCHOL_CODE_2 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_CONT_CODE_2 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GRADE_LVL_2 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_XTR_UNSBZ_LN_F_2 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CAPITAL_INT_F_2 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_SEQ_NUM_3 | NUMBER | (2) | ||
| NSLDS_LOAN_TYPE_CODE_3 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CHNG_F_3 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_PROG_CODE_3 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_NET_AMNT_3 | NUMBER | (6) | ||
| NSLDS_LOAN_CUR_ST_CODE_3 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_CUR_ST_DATE_3 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_AGG_PR_BAL_3 | VARCHAR2 | (6) | ||
| NSLDS_LOAN_OUT_PR_BAL_DT_3 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_BEGIN_DT_3 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_END_DT_3 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GA_CODE_3 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_CONT_TYPE_3 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_SCHOL_CODE_3 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_CONT_CODE_3 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GRADE_LVL_3 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_XTR_UNSBZ_LN_F_3 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CAPITAL_INT_F_3 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_SEQ_NUM_4 | NUMBER | (2) | ||
| NSLDS_LOAN_TYPE_CODE_4 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CHNG_F_4 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_PROG_CODE_4 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_NET_AMNT_4 | NUMBER | (6) | ||
| NSLDS_LOAN_CUR_ST_CODE_4 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_CUR_ST_DATE_4 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_AGG_PR_BAL_4 | VARCHAR2 | (6) | ||
| NSLDS_LOAN_OUT_PR_BAL_DT_4 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_BEGIN_DT_4 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_END_DT_4 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GA_CODE_4 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_CONT_TYPE_4 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_SCHOL_CODE_4 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_CONT_CODE_4 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GRADE_LVL_4 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_XTR_UNSBZ_LN_F_4 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CAPITAL_INT_F_4 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_SEQ_NUM_5 | NUMBER | (2) | ||
| NSLDS_LOAN_TYPE_CODE_5 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CHNG_F_5 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_PROG_CODE_5 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_NET_AMNT_5 | NUMBER | (6) | ||
| NSLDS_LOAN_CUR_ST_CODE_5 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_CUR_ST_DATE_5 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_AGG_PR_BAL_5 | VARCHAR2 | (6) | ||
| NSLDS_LOAN_OUT_PR_BAL_DT_5 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_BEGIN_DT_5 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_END_DT_5 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GA_CODE_5 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_CONT_TYPE_5 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_SCHOL_CODE_5 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_CONT_CODE_5 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GRADE_LVL_5 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_XTR_UNSBZ_LN_F_5 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CAPITAL_INT_F_5 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_SEQ_NUM_6 | NUMBER | (2) | ||
| NSLDS_LOAN_TYPE_CODE_6 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CHNG_F_6 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_PROG_CODE_6 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_NET_AMNT_6 | NUMBER | (6) | ||
| NSLDS_LOAN_CUR_ST_CODE_6 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_CUR_ST_DATE_6 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_AGG_PR_BAL_6 | VARCHAR2 | (6) | ||
| NSLDS_LOAN_OUT_PR_BAL_DT_6 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_BEGIN_DT_6 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_END_DT_6 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GA_CODE_6 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_CONT_TYPE_6 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_SCHOL_CODE_6 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_CONT_CODE_6 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GRADE_LVL_6 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_XTR_UNSBZ_LN_F_6 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CAPITAL_INT_F_6 | VARCHAR2 | (1) | ||
| 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) | ||
| REQUEST_ID | NUMBER | (15) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
| PROGRAM_ID | NUMBER | (15) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| ORG_ID | NUMBER | (15) | ||
| NSLDS_LOAN_LAST_D_AMT_1 | NUMBER | (15) | NSLDS Loan (1) Last Disbursement Amount | |
| NSLDS_LOAN_LAST_D_DATE_1 | DATE | NSLDS Loan (1) Last Disbursement Date | ||
| NSLDS_LOAN_LAST_D_AMT_2 | NUMBER | (15) | NSLDS Loan (2) Last Disbursement Amount | |
| NSLDS_LOAN_LAST_D_DATE_2 | DATE | NSLDS Loan (2) Last Disbursement Date | ||
| NSLDS_LOAN_LAST_D_AMT_3 | NUMBER | (15) | NSLDS Loan (3) Last Disbursement Amount | |
| NSLDS_LOAN_LAST_D_DATE_3 | DATE | NSLDS Loan (3) Last Disbursement Date | ||
| NSLDS_LOAN_LAST_D_AMT_4 | NUMBER | (15) | NSLDS Loan (4) Last Disbursement Amount | |
| NSLDS_LOAN_LAST_D_DATE_4 | DATE | NSLDS Loan (4) Last Disbursement Date | ||
| NSLDS_LOAN_LAST_D_AMT_5 | NUMBER | (15) | NSLDS Loan (5) Last Disbursement Amount | |
| NSLDS_LOAN_LAST_D_DATE_5 | DATE | NSLDS Loan (5) Last Disbursement Date | ||
| NSLDS_LOAN_LAST_D_AMT_6 | NUMBER | (15) | NSLDS Loan (6) Last Disbursement Amount | |
| NSLDS_LOAN_LAST_D_DATE_6 | DATE | NSLDS Loan (6) Last Disbursement Date | ||
| VERIF_TRACK_FLAG | VARCHAR2 | (30) | ||
| FAFSA_DATA_VERIFY_FLAGS | VARCHAR2 | (255) | Stores the FAFSA Data Verification related flags | |
| REJECT_OVERRIDE_A | VARCHAR2 | (30) | Indicates the Reject Override A Status | |
| REJECT_OVERRIDE_C | VARCHAR2 | (30) | Indicates the Reject Override C Status | |
| PARENT_MARITAL_STATUS_DATE | DATE | Stores the parents Marital Status date | ||
| DLP_MASTER_PROM_NOTE_FLAG | VARCHAR2 | (30) | Indicates the Direct Loan Plus Master Promissory Note Flag | |
| FATHER_FIRST_NAME_INITIAL_TXT | VARCHAR2 | (1) | Father's/Stepfather's First Name Initial | |
| FATHER_STEP_FATHER_BIRTH_DATE | DATE | Father's/Stepfather's Date of Birth | ||
| MOTHER_FIRST_NAME_INITIAL_TXT | VARCHAR2 | (1) | Mother's/Stepmother's First Name Initial | |
| MOTHER_STEP_MOTHER_BIRTH_DATE | DATE | Mother's/Stepmother's Date of Birth | ||
| PARENTS_EMAIL_ADDRESS_TXT | VARCHAR2 | (50) | Parent's E-mail Address | |
| ADDRESS_CHANGE_TYPE | VARCHAR2 | (1) | Address Only Change Flag | |
| CPS_PUSHED_ISIR_FLAG | VARCHAR2 | (1) | This Flag is set to identify transactions that are automatically sent to schools | |
| ELECTRONIC_TRANSACTION_TYPE | VARCHAR2 | (1) | To indicate if the school receiving the ISIR submitted input to generate the ISIR transaction, or did not generate the transaction but was listed on the record. It also indicates whether the type of ISIR is a daily, requested, or pushed ISIR. | |
| SAR_C_CHANGE_TYPE | VARCHAR2 | (1) | This Flag is set to identify SAR changes | |
| FATHER_SSN_MATCH_TYPE | VARCHAR2 | (1) | To indicate the Father's/Stepfather's results from SSN Match with Social Security Administration. | |
| MOTHER_SSN_MATCH_TYPE | VARCHAR2 | (1) | To indicate the Mother's/Stepmother's results from SSN Match with Social Security Administration. | |
| SUBSIDIZED_LOAN_LIMIT_TYPE | VARCHAR2 | (1) | Subsidized Loan Limit Flag | |
| COMBINED_LOAN_LIMIT_TYPE | VARCHAR2 | (1) | Combined Loan Limit Flag | |
| REJECT_OVERRIDE_G_FLAG | VARCHAR2 | (1) | Reject Override G Flag | |
| DHS_VERIFICATION_NUM_TXT | VARCHAR2 | (15) | Identification Number provided by the Department of Homeland Securityindicating that primary verification wasperformed. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, SI_ID
, BATCH_YEAR
, TRANSACTION_NUM
, RECORD_STATUS
, SSN_NAME_CHANGE
, ORIGINAL_SSN
, ORIG_NAME_ID
, CURRENT_SSN
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL
, PERM_MAIL_ADD
, PERM_CITY
, PERM_STATE
, PERM_ZIP_CODE
, DATE_OF_BIRTH
, PHONE_NUMBER
, DRIVER_LICENSE_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
, SELECTIVE_SERVICE_REG
, DEGREE_CERTIFICATION
, GRADE_LEVEL_IN_COLLEGE
, HIGH_SCHOOL_DIPLOMA_GED
, FIRST_BACHELOR_DEG_BY_DATE
, INTEREST_IN_LOAN
, 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
, LEGAL_DEPENDENTS
, 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
, P_STATE_LEGAL_RES_BEFORE_DT
, P_LEGAL_RES_DATE
, 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
, DEPENDENCY_OVERRIDE_IND
, FAA_FEDRAL_SCHL_CODE
, FAA_ADJUSTMENT
, INPUT_RECORD_TYPE
, SERIAL_NUMBER
, BATCH_NUMBER
, EARLY_ANALYSIS_FLAG
, APP_ENTRY_SOURCE_CODE
, ETI_DESTINATION_CODE
, REJECT_OVERRIDE_B
, REJECT_OVERRIDE_N
, REJECT_OVERRIDE_W
, ASSUM_OVERRIDE_1
, ASSUM_OVERRIDE_2
, ASSUM_OVERRIDE_3
, ASSUM_OVERRIDE_4
, ASSUM_OVERRIDE_5
, ASSUM_OVERRIDE_6
, DEPENDENCY_STATUS
, S_EMAIL_ADDRESS
, NSLDS_REASON_CODE
, APP_RECEIPT_DATE
, PROCESSED_REC_TYPE
, HIST_CORRECTION_FOR_TRAN_ID
, SYSTEM_GENERATED_INDICATOR
, DUP_REQUEST_INDICATOR
, SOURCE_OF_CORRECTION
, P_CAL_TAX_STATUS
, S_CAL_TAX_STATUS
, GRADUATE_FLAG
, AUTO_ZERO_EFC
, EFC_CHANGE_FLAG
, SARC_FLAG
, SIMPLIFIED_NEED_TEST
, REJECT_REASON_CODES
, SELECT_SERVICE_MATCH_FLAG
, SELECT_SERVICE_REG_FLAG
, INS_MATCH_FLAG
, INS_VERIFICATION_NUMBER
, SEC_INS_MATCH_FLAG
, SEC_INS_VER_NUMBER
, SSN_MATCH_FLAG
, SSA_CITIZENSHIP_FLAG
, SSN_DATE_OF_DEATH
, NSLDS_MATCH_FLAG
, VA_MATCH_FLAG
, PRISONER_MATCH
, VERIFICATION_FLAG
, SUBSEQUENT_APP_FLAG
, APP_SOURCE_SITE_CODE
, TRAN_SOURCE_SITE_CODE
, DRN
, TRAN_PROCESS_DATE
, CORRECTION_FLAGS
, COMPUTER_BATCH_NUMBER
, HIGHLIGHT_FLAGS
, PAID_EFC
, PRIMARY_EFC
, SECONDARY_EFC
, FED_PELL_GRANT_EFC_TYPE
, PRIMARY_EFC_TYPE
, SEC_EFC_TYPE
, PRIMARY_ALTERNATE_MONTH_1
, PRIMARY_ALTERNATE_MONTH_2
, PRIMARY_ALTERNATE_MONTH_3
, PRIMARY_ALTERNATE_MONTH_4
, PRIMARY_ALTERNATE_MONTH_5
, PRIMARY_ALTERNATE_MONTH_6
, PRIMARY_ALTERNATE_MONTH_7
, PRIMARY_ALTERNATE_MONTH_8
, PRIMARY_ALTERNATE_MONTH_10
, PRIMARY_ALTERNATE_MONTH_11
, PRIMARY_ALTERNATE_MONTH_12
, SEC_ALTERNATE_MONTH_1
, SEC_ALTERNATE_MONTH_2
, SEC_ALTERNATE_MONTH_3
, SEC_ALTERNATE_MONTH_4
, SEC_ALTERNATE_MONTH_5
, SEC_ALTERNATE_MONTH_6
, SEC_ALTERNATE_MONTH_7
, SEC_ALTERNATE_MONTH_8
, SEC_ALTERNATE_MONTH_10
, SEC_ALTERNATE_MONTH_11
, SEC_ALTERNATE_MONTH_12
, TOTAL_INCOME
, ALLOW_TOTAL_INCOME
, STATE_TAX_ALLOW
, EMPLOYMENT_ALLOW
, INCOME_PROTECTION_ALLOW
, AVAILABLE_INCOME
, CONTRIBUTION_FROM_AI
, DISCRETIONARY_NETWORTH
, EFC_NETWORTH
, ASSET_PROTECT_ALLOW
, PARENTS_CONT_FROM_ASSETS
, ADJUSTED_AVAILABLE_INCOME
, TOTAL_STUDENT_CONTRIBUTION
, TOTAL_PARENT_CONTRIBUTION
, PARENTS_CONTRIBUTION
, STUDENT_TOTAL_INCOME
, SATI
, SIC
, SDNW
, SCA
, FTI
, SECTI
, SECATI
, SECSTX
, SECEA
, SECIPA
, SECAI
, SECCAI
, SECDNW
, SECNW
, SECAPA
, SECPCA
, SECAAI
, SECTSC
, SECTPC
, SECPC
, SECSTI
, SECSATI
, SECSIC
, SECSDNW
, SECSCA
, SECFTI
, A_CITIZENSHIP
, A_STUDENT_MARITAL_STATUS
, A_STUDENT_AGI
, A_S_US_TAX_PAID
, A_S_INCOME_WORK
, A_SPOUSE_INCOME_WORK
, A_S_TOTAL_WSC
, A_DATE_OF_BIRTH
, A_STUDENT_MARRIED
, A_HAVE_CHILDREN
, A_S_HAVE_DEPENDENTS
, A_VA_STATUS
, A_S_NUM_IN_FAMILY
, A_S_NUM_IN_COLLEGE
, A_P_MARITAL_STATUS
, A_FATHER_SSN
, A_MOTHER_SSN
, A_PARENTS_NUM_FAMILY
, A_PARENTS_NUM_COLLEGE
, A_PARENTS_AGI
, A_P_US_TAX_PAID
, A_F_WORK_INCOME
, A_M_WORK_INCOME
, A_P_TOTAL_WSC
, COMMENT_CODES
, SAR_ACK_COMM_CODE
, PELL_GRANT_ELIG_FLAG
, REPROCESS_REASON_CODE
, DUPLICATE_DATE
, ISIR_TRANSACTION_TYPE
, FEDRAL_SCHL_CODE_INDICATOR
, MULTI_SCHOOL_CODE_FLAGS
, DUP_SSN_INDICATOR
, NSLDS_TRANSACTION_NUM
, NSLDS_DATABASE_RESULTS_F
, NSLDS_F
, NSLDS_PELL_OVERPAY_F
, NSLDS_PELL_OVERPAY_CONTACT
, NSLDS_SEOG_OVERPAY_F
, NSLDS_SEOG_OVERPAY_CONTACT
, NSLDS_PERKINS_OVERPAY_F
, NSLDS_PERKINS_OVERPAY_CNTCT
, NSLDS_DEFAULTED_LOAN_F
, NSLDS_DISCHARGED_LOAN_F
, NSLDS_SATIS_REPAY_F
, NSLDS_ACT_BANKRUPTCY_F
, NSLDS_AGG_SUBSZ_OUT_PRIN_BAL
, NSLDS_AGG_UNSBZ_OUT_PRIN_BAL
, NSLDS_AGG_COMB_OUT_PRIN_BAL
, NSLDS_AGG_CONS_OUT_PRIN_BAL
, NSLDS_AGG_SUBSZ_PEND_DISMNT
, NSLDS_AGG_UNSBZ_PEND_DISMNT
, NSLDS_AGG_COMB_PEND_DISMNT
, NSLDS_AGG_SUBSZ_TOTAL
, NSLDS_AGG_UNSBZ_TOTAL
, NSLDS_AGG_COMB_TOTAL
, NSLDS_AGG_CONSD_TOTAL
, NSLDS_PERKINS_OUT_BAL
, NSLDS_PERKINS_CUR_YR_DISMNT
, NSLDS_DEFAULT_LOAN_CHNG_F
, NSLDS_DISCHGED_LOAN_CHNG_F
, NSLDS_SATIS_REPAY_CHNG_F
, NSLDS_ACT_BNKRUPT_CHNG_F
, NSLDS_OVERPAY_CHNG_F
, NSLDS_AGG_LOAN_CHNG_F
, NSLDS_PERKINS_LOAN_CHNG_F
, NSLDS_PELL_PAYMNT_CHNG_F
, NSLDS_ADDTNL_PELL_F
, NSLDS_ADDTNL_LOAN_F
, DIRECT_LOAN_MAS_PROM_NT_F
, NSLDS_PELL_SEQ_NUM_1
, NSLDS_PELL_VERIFY_F_1
, NSLDS_PELL_EFC_1
, NSLDS_PELL_SCHOOL_CODE_1
, NSLDS_PELL_TRANSCN_NUM_1
, NSLDS_PELL_LAST_UPDT_DT_1
, NSLDS_PELL_SCHEDULED_AMT_1
, NSLDS_PELL_AMT_PAID_TODT_1
, NSLDS_PELL_REMNG_AMT_1
, NSLDS_PELL_PC_SCHD_AWD_US_1
, NSLDS_PELL_AWARD_AMT_1
, NSLDS_PELL_SEQ_NUM_2
, NSLDS_PELL_VERIFY_F_2
, NSLDS_PELL_EFC_2
, NSLDS_PELL_SCHOOL_CODE_2
, NSLDS_PELL_TRANSCN_NUM_2
, NSLDS_PELL_LAST_UPDT_DT_2
, NSLDS_PELL_SCHEDULED_AMT_2
, NSLDS_PELL_AMT_PAID_TODT_2
, NSLDS_PELL_REMNG_AMT_2
, NSLDS_PELL_PC_SCHD_AWD_US_2
, NSLDS_PELL_AWARD_AMT_2
, NSLDS_PELL_SEQ_NUM_3
, NSLDS_PELL_VERIFY_F_3
, NSLDS_PELL_EFC_3
, NSLDS_PELL_SCHOOL_CODE_3
, NSLDS_PELL_TRANSCN_NUM_3
, NSLDS_PELL_LAST_UPDT_DT_3
, NSLDS_PELL_SCHEDULED_AMT_3
, NSLDS_PELL_AMT_PAID_TODT_3
, NSLDS_PELL_REMNG_AMT_3
, NSLDS_PELL_PC_SCHD_AWD_US_3
, NSLDS_PELL_AWARD_AMT_3
, NSLDS_LOAN_SEQ_NUM_1
, NSLDS_LOAN_TYPE_CODE_1
, NSLDS_LOAN_CHNG_F_1
, NSLDS_LOAN_PROG_CODE_1
, NSLDS_LOAN_NET_AMNT_1
, NSLDS_LOAN_CUR_ST_CODE_1
, NSLDS_LOAN_CUR_ST_DATE_1
, NSLDS_LOAN_AGG_PR_BAL_1
, NSLDS_LOAN_OUT_PR_BAL_DT_1
, NSLDS_LOAN_BEGIN_DT_1
, NSLDS_LOAN_END_DT_1
, NSLDS_LOAN_GA_CODE_1
, NSLDS_LOAN_CONT_TYPE_1
, NSLDS_LOAN_SCHOL_CODE_1
, NSLDS_LOAN_CONT_CODE_1
, NSLDS_LOAN_GRADE_LVL_1
, NSLDS_LOAN_XTR_UNSBZ_LN_F_1
, NSLDS_LOAN_CAPITAL_INT_F_1
, NSLDS_LOAN_SEQ_NUM_2
, NSLDS_LOAN_TYPE_CODE_2
, NSLDS_LOAN_CHNG_F_2
, NSLDS_LOAN_PROG_CODE_2
, NSLDS_LOAN_NET_AMNT_2
, NSLDS_LOAN_CUR_ST_CODE_2
, NSLDS_LOAN_CUR_ST_DATE_2
, NSLDS_LOAN_AGG_PR_BAL_2
, NSLDS_LOAN_OUT_PR_BAL_DT_2
, NSLDS_LOAN_BEGIN_DT_2
, NSLDS_LOAN_END_DT_2
, NSLDS_LOAN_GA_CODE_2
, NSLDS_LOAN_CONT_TYPE_2
, NSLDS_LOAN_SCHOL_CODE_2
, NSLDS_LOAN_CONT_CODE_2
, NSLDS_LOAN_GRADE_LVL_2
, NSLDS_LOAN_XTR_UNSBZ_LN_F_2
, NSLDS_LOAN_CAPITAL_INT_F_2
, NSLDS_LOAN_SEQ_NUM_3
, NSLDS_LOAN_TYPE_CODE_3
, NSLDS_LOAN_CHNG_F_3
, NSLDS_LOAN_PROG_CODE_3
, NSLDS_LOAN_NET_AMNT_3
, NSLDS_LOAN_CUR_ST_CODE_3
, NSLDS_LOAN_CUR_ST_DATE_3
, NSLDS_LOAN_AGG_PR_BAL_3
, NSLDS_LOAN_OUT_PR_BAL_DT_3
, NSLDS_LOAN_BEGIN_DT_3
, NSLDS_LOAN_END_DT_3
, NSLDS_LOAN_GA_CODE_3
, NSLDS_LOAN_CONT_TYPE_3
, NSLDS_LOAN_SCHOL_CODE_3
, NSLDS_LOAN_CONT_CODE_3
, NSLDS_LOAN_GRADE_LVL_3
, NSLDS_LOAN_XTR_UNSBZ_LN_F_3
, NSLDS_LOAN_CAPITAL_INT_F_3
, NSLDS_LOAN_SEQ_NUM_4
, NSLDS_LOAN_TYPE_CODE_4
, NSLDS_LOAN_CHNG_F_4
, NSLDS_LOAN_PROG_CODE_4
, NSLDS_LOAN_NET_AMNT_4
, NSLDS_LOAN_CUR_ST_CODE_4
, NSLDS_LOAN_CUR_ST_DATE_4
, NSLDS_LOAN_AGG_PR_BAL_4
, NSLDS_LOAN_OUT_PR_BAL_DT_4
, NSLDS_LOAN_BEGIN_DT_4
, NSLDS_LOAN_END_DT_4
, NSLDS_LOAN_GA_CODE_4
, NSLDS_LOAN_CONT_TYPE_4
, NSLDS_LOAN_SCHOL_CODE_4
, NSLDS_LOAN_CONT_CODE_4
, NSLDS_LOAN_GRADE_LVL_4
, NSLDS_LOAN_XTR_UNSBZ_LN_F_4
, NSLDS_LOAN_CAPITAL_INT_F_4
, NSLDS_LOAN_SEQ_NUM_5
, NSLDS_LOAN_TYPE_CODE_5
, NSLDS_LOAN_CHNG_F_5
, NSLDS_LOAN_PROG_CODE_5
, NSLDS_LOAN_NET_AMNT_5
, NSLDS_LOAN_CUR_ST_CODE_5
, NSLDS_LOAN_CUR_ST_DATE_5
, NSLDS_LOAN_AGG_PR_BAL_5
, NSLDS_LOAN_OUT_PR_BAL_DT_5
, NSLDS_LOAN_BEGIN_DT_5
, NSLDS_LOAN_END_DT_5
, NSLDS_LOAN_GA_CODE_5
, NSLDS_LOAN_CONT_TYPE_5
, NSLDS_LOAN_SCHOL_CODE_5
, NSLDS_LOAN_CONT_CODE_5
, NSLDS_LOAN_GRADE_LVL_5
, NSLDS_LOAN_XTR_UNSBZ_LN_F_5
, NSLDS_LOAN_CAPITAL_INT_F_5
, NSLDS_LOAN_SEQ_NUM_6
, NSLDS_LOAN_TYPE_CODE_6
, NSLDS_LOAN_CHNG_F_6
, NSLDS_LOAN_PROG_CODE_6
, NSLDS_LOAN_NET_AMNT_6
, NSLDS_LOAN_CUR_ST_CODE_6
, NSLDS_LOAN_CUR_ST_DATE_6
, NSLDS_LOAN_AGG_PR_BAL_6
, NSLDS_LOAN_OUT_PR_BAL_DT_6
, NSLDS_LOAN_BEGIN_DT_6
, NSLDS_LOAN_END_DT_6
, NSLDS_LOAN_GA_CODE_6
, NSLDS_LOAN_CONT_TYPE_6
, NSLDS_LOAN_SCHOL_CODE_6
, NSLDS_LOAN_CONT_CODE_6
, NSLDS_LOAN_GRADE_LVL_6
, NSLDS_LOAN_XTR_UNSBZ_LN_F_6
, NSLDS_LOAN_CAPITAL_INT_F_6
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, NSLDS_LOAN_LAST_D_AMT_1
, NSLDS_LOAN_LAST_D_DATE_1
, NSLDS_LOAN_LAST_D_AMT_2
, NSLDS_LOAN_LAST_D_DATE_2
, NSLDS_LOAN_LAST_D_AMT_3
, NSLDS_LOAN_LAST_D_DATE_3
, NSLDS_LOAN_LAST_D_AMT_4
, NSLDS_LOAN_LAST_D_DATE_4
, NSLDS_LOAN_LAST_D_AMT_5
, NSLDS_LOAN_LAST_D_DATE_5
, NSLDS_LOAN_LAST_D_AMT_6
, NSLDS_LOAN_LAST_D_DATE_6
, VERIF_TRACK_FLAG
, FAFSA_DATA_VERIFY_FLAGS
, REJECT_OVERRIDE_A
, REJECT_OVERRIDE_C
, PARENT_MARITAL_STATUS_DATE
, DLP_MASTER_PROM_NOTE_FLAG
, FATHER_FIRST_NAME_INITIAL_TXT
, FATHER_STEP_FATHER_BIRTH_DATE
, MOTHER_FIRST_NAME_INITIAL_TXT
, MOTHER_STEP_MOTHER_BIRTH_DATE
, PARENTS_EMAIL_ADDRESS_TXT
, ADDRESS_CHANGE_TYPE
, CPS_PUSHED_ISIR_FLAG
, ELECTRONIC_TRANSACTION_TYPE
, SAR_C_CHANGE_TYPE
, FATHER_SSN_MATCH_TYPE
, MOTHER_SSN_MATCH_TYPE
, SUBSIDIZED_LOAN_LIMIT_TYPE
, COMBINED_LOAN_LIMIT_TYPE
, REJECT_OVERRIDE_G_FLAG
, DHS_VERIFICATION_NUM_TXT
FROM APPS.IGF_AP_ISIR_INTRFACE;
APPS
IGF_AP_ISIR_INTRFACE_ALL
APPS
IGF_AP_ISIR_GEN_PKG
- show dependent code
IGF_AP_REVIEW_DET_V
|
|
|
|