[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_ISIR_INTS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_AP_ISIR_INTS_ALL
|
| Subobject Name: | |
| Status: | VALID |
ISIR Interface table for holding ISIRs received from CPS
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_AP_ISIR_INTS_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 SI_ID
|
| IGF_AP_ISIR_INTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BATCH_YEAR_NUM
RECORD_STATUS
|
| IGF_AP_ISIR_INTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INPUT_RECORD_TYPE
|
| IGF_AP_ISIR_INTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DATA_FILE_NAME_TXT
|
| IGF_AP_ISIR_INTS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_REQ_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SI_ID | NUMBER | Yes | Identifier for uploaded ISIR | |
| BATCH_YEAR_NUM | NUMBER | (2) | Yes | Holds batch year |
| TRANSACTION_NUM_TXT | VARCHAR2 | (2) | Yes | Holds CPS transaction number of ISIR |
| SSN_NAME_CHANGE_TYPE | VARCHAR2 | (1) | Indicates whether last name, SSN, or both have been changed | |
| ORIGINAL_SSN_TXT | VARCHAR2 | (9) | Holds original SSN as processed by CPS | |
| ORIG_NAME_ID_TXT | VARCHAR2 | (2) | Holds first two letters of last name as on initial application | |
| CURRENT_SSN_TXT | VARCHAR2 | (9) | Holds SSN on transaction | |
| LAST_NAME | VARCHAR2 | (16) | Last name of applicant student | |
| FIRST_NAME | VARCHAR2 | (12) | Yes | Indicates first name of applicant student |
| MIDDLE_INITIAL_TXT | VARCHAR2 | (1) | Middle name of applicant student | |
| PERM_MAIL_ADDRESS_TXT | VARCHAR2 | (35) | Permanent mailing address of applicant student | |
| PERM_CITY_TXT | VARCHAR2 | (16) | Permanent city of applicant student | |
| PERM_STATE_TXT | VARCHAR2 | (2) | Permanent state of applicant student | |
| PERM_ZIP_CD | VARCHAR2 | (5) | Permanent zip code of applicant student | |
| BIRTH_DATE | DATE | Date of birth of applicant student | ||
| PHONE_NUMBER_TXT | VARCHAR2 | (10) | Contact phone number of applicant student | |
| DRIVER_LICENSE_NUMBER_TXT | VARCHAR2 | (20) | Driver's license number of applicant student if applicable | |
| DRIVER_LICENSE_STATE_TXT | VARCHAR2 | (2) | Driver's license state code of applicant student if applicable | |
| CITIZENSHIP_STATUS_TYPE | VARCHAR2 | (1) | Status of student's citizenship | |
| ALIEN_REG_NUMBER_TXT | VARCHAR2 | (9) | Student's alien registration number | |
| S_MARITAL_STATUS_TYPE | VARCHAR2 | (1) | Student's marital status | |
| S_MARITAL_STATUS_DATE | DATE | Date on which student's marital status changed to current status | ||
| SUMM_ENRL_STATUS_TYPE | VARCHAR2 | (1) | Student's enrollment plan for summer term | |
| FALL_ENRL_STATUS_TYPE | VARCHAR2 | (1) | Student's enrollment plan for fall term | |
| WINTER_ENRL_STATUS_TYPE | VARCHAR2 | (1) | Student's enrollment plan for winter term | |
| SPRING_ENRL_STATUS_TYPE | VARCHAR2 | (1) | Student's enrollment plan for spring term | |
| SUMM2_ENRL_STATUS_TYPE | VARCHAR2 | (1) | Student's enrollment plan for next summer term | |
| FATHERS_HIGHST_EDU_LVL_TYPE | VARCHAR2 | (1) | Father's highest education level completed | |
| MOTHERS_HIGHST_EDU_LVL_TYPE | VARCHAR2 | (1) | Mother's highest education level completed | |
| S_STATE_LEGAL_RESIDENCE | VARCHAR2 | (2) | Student's state of legal residence | |
| LEGAL_RES_BEFORE_YEAR_FLAG | VARCHAR2 | (1) | Student's legal residence before cut-off date. Set by CPS. | |
| S_LEGAL_RESD_DATE | DATE | Date on which student's legal residence changed to current | ||
| SS_R_U_MALE_FLAG | VARCHAR2 | (1) | Indicates whether student is male | |
| SELECTIVE_SERVICE_REG_FLAG | VARCHAR2 | (1) | Indicates whether Selective Service should register student | |
| DEGREE_CERTIFICATION_TYPE | VARCHAR2 | (1) | Holds student's degree or certificate information | |
| GRADE_LEVEL_IN_COLLEGE_TYPE | VARCHAR2 | (1) | Student's grade level in college in current academic year | |
| HIGH_SCHL_DIPLOMA_GED_FLAG | VARCHAR2 | (1) | Holds student's high school diploma or GED diploma information | |
| FIRST_BACHLR_DEG_YEAR_FLAG | VARCHAR2 | (1) | Indicates whether student will obtain first bachelor's degree during current year | |
| INTEREST_IN_LOAN_FLAG | VARCHAR2 | (1) | Indicates whether student is interested in student loan | |
| INTEREST_IN_STU_EMPLOY_FLAG | VARCHAR2 | (1) | Indicates whether student is interested in student employment | |
| DRUG_OFFENCE_CONVICT_TYPE | VARCHAR2 | (1) | Indicates whether student has drug conviction | |
| S_TAX_RETURN_STATUS_TYPE | VARCHAR2 | (1) | Holds student's tax return status | |
| S_TYPE_TAX_RETURN_TYPE | VARCHAR2 | (1) | Indicates type of tax form used by student for filing the tax | |
| S_ELIG_1040EZ_TYPE | VARCHAR2 | (1) | Indicates whether student is eligible for 1040A or 1040EZ | |
| S_ADJUSTED_GROSS_INCOME_AMT | NUMBER | (6) | Holds students adjusted gross income from IRS Form | |
| S_FED_TAXES_PAID_AMT | NUMBER | (5) | Holds amount student paid in U.S. income tax | |
| S_EXEMPTIONS_AMT | NUMBER | (2) | Indicates number of tax exemptions student claims | |
| S_INCOME_FROM_WORK_AMT | NUMBER | (6) | Student's income earned from work | |
| SPOUSE_INCOME_FROM_WORK_AMT | NUMBER | (6) | Spouse's income earned from work | |
| S_TOTAL_FROM_WSA_AMT | NUMBER | (5) | Student's total amount from Worksheet A | |
| S_TOTAL_FROM_WSB_AMT | NUMBER | (5) | Student's total amount from Worksheet B | |
| S_TOTAL_FROM_WSC_AMT | NUMBER | (5) | Student's total amount from Worksheet C | |
| S_INVESTMENT_NETWORTH_AMT | NUMBER | (6) | Net worth of investment made by student | |
| S_BUSI_FARM_NETWORTH_AMT | NUMBER | (6) | Net worth of student's business and farm | |
| S_CASH_SAVINGS_AMT | NUMBER | (6) | Savings available for student | |
| VA_MONTHS_NUM | NUMBER | (2) | Indicates number of months student received veteran's education benefit | |
| VA_AMT | NUMBER | (15) | Stores the Monthly Veterans Education Benefits | |
| STUD_DOB_BEFORE_YEAR_FLAG | VARCHAR2 | (1) | Indicates whether student was born before cut-off date set by Department of Education for year | |
| DEG_BEYOND_BACHELOR_FLAG | VARCHAR2 | (1) | Indicates whether student is working on a degree beyond current academic year | |
| S_MARRIED_FLAG | VARCHAR2 | (1) | Indicates whether student is married | |
| S_HAVE_CHILDREN_FLAG | VARCHAR2 | (1) | Indicates whether student has children | |
| LEGAL_DEPENDENTS_FLAG | VARCHAR2 | (1) | Indicates whether student has legal dependents other than children and spouse | |
| ORPHAN_WARD_OF_COURT_FLAG | VARCHAR2 | (1) | Indicates whether student is orphan or ward of court | |
| S_VETERAN_FLAG | VARCHAR2 | (1) | Indicates whether student is veteran of U.S. Armed Forces | |
| P_MARITAL_STATUS_TYPE | VARCHAR2 | (1) | Holds marital status of student's parents | |
| FATHER_SSN_TXT | VARCHAR2 | (9) | Holds father's SSN | |
| F_LAST_NAME | VARCHAR2 | (16) | Holds father's last name | |
| MOTHER_SSN_TXT | VARCHAR2 | (9) | Holds mother's SSN | |
| M_LAST_NAME | VARCHAR2 | (16) | Holds mother's last name | |
| P_FAMILY_MEMBERS_NUM | NUMBER | (2) | Holds number of family members in students' parents' family | |
| P_IN_COLLEGE_NUM | NUMBER | (1) | Holds number of people in parents' family in college in current year. Excludes parents. | |
| P_STATE_LEGAL_RESIDENCE_TXT | VARCHAR2 | (2) | Holds parents' state of legal residence | |
| P_LEGAL_RES_BEFORE_DT_FLAG | VARCHAR2 | (1) | Parents' legal residence before specific date | |
| P_LEGAL_RES_DATE | DATE | Date on which current state became parents' legal residence | ||
| AGE_OLDER_PARENT_NUM | NUMBER | (2) | Holds older parent's age | |
| P_TAX_RETURN_STATUS_TYPE | VARCHAR2 | (1) | Indicates whether parents filed tax returns | |
| P_TYPE_TAX_RETURN_TYPE | VARCHAR2 | (1) | Holds type of tax form used by parents in filing tax returns | |
| P_ELIG_1040AEZ_TYPE | VARCHAR2 | (1) | Indicates whether parents are eligible to file 1040A or 1040EZ | |
| P_ADJUSTED_GROSS_INCOME_AMT | NUMBER | (6) | Holds parents adjusted gross income from IRS form | |
| P_TAXES_PAID_AMT | NUMBER | (6) | Holds U.S. income tax parents paid | |
| P_EXEMPTIONS_AMT | NUMBER | (2) | Holds number of exemptions parents claimed | |
| F_INCOME_WORK_AMT | NUMBER | (6) | Holds father's income earned from work | |
| M_INCOME_WORK_AMT | NUMBER | (6) | Holds mother's income earned from work | |
| P_INCOME_WSA_AMT | NUMBER | (5) | Parents' total amount from Worksheet A | |
| P_INCOME_WSB_AMT | NUMBER | (5) | Parents' total amount from Worksheet B | |
| P_INCOME_WSC_AMT | NUMBER | (5) | Parents' total amount from Worksheet C | |
| P_INVESTMENT_NETWORTH_AMT | NUMBER | (6) | Holds net worth of parents' investments | |
| P_BUSINESS_NETWORTH_AMT | NUMBER | (6) | Holds net worth of parents' business and farm | |
| P_CASH_SAVING_AMT | NUMBER | (6) | Holds parents' savings information | |
| S_FAMILY_MEMBERS_NUM | NUMBER | (2) | Number of family members in student's family | |
| S_IN_COLLEGE_NUM | NUMBER | (1) | Holds number of people in student's family in college during current year | |
| FIRST_COLLEGE_CD | VARCHAR2 | (6) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
| FIRST_HOUSE_PLAN_TYPE | VARCHAR2 | (1) | Student's housing plan for first school | |
| SECOND_COLLEGE_CD | VARCHAR2 | (6) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
| SECOND_HOUSE_PLAN_TYPE | VARCHAR2 | (1) | Student's housing plan for second school | |
| THIRD_COLLEGE_CD | VARCHAR2 | (6) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
| THIRD_HOUSE_PLAN_TYPE | VARCHAR2 | (1) | Student's housing plan for third school | |
| FOURTH_COLLEGE_CD | VARCHAR2 | (6) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
| FOURTH_HOUSE_PLAN_TYPE | VARCHAR2 | (1) | Student's housing plan for fourth school | |
| FIFTH_COLLEGE_CD | VARCHAR2 | (6) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
| FIFTH_HOUSE_PLAN_TYPE | VARCHAR2 | (1) | Student's housing plan for fifth school | |
| SIXTH_COLLEGE_CD | VARCHAR2 | (6) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
| SIXTH_HOUSE_PLAN_TYPE | VARCHAR2 | (1) | Student's housing plan for sixth school | |
| APP_COMPLETED_DATE | DATE | Indicates date application was completed | ||
| SIGNED_BY_TYPE | VARCHAR2 | (1) | Indicates if applicant, parent, or both signed FAFSA application | |
| PREPARER_SSN_TXT | VARCHAR2 | (9) | Holds SSN of person who prepared application | |
| PREPARER_EMP_ID_NUMBER_TXT | VARCHAR2 | (9) | Holds preparer's employer identification number | |
| PREPARER_SIGN_FLAG | VARCHAR2 | (1) | Indicates whether preparer signed transaction | |
| TRANSACTION_RECEIPT_DATE | DATE | Holds date transaction was received by Department of Education or school, or date student filled out web form | ||
| DEPENDENCY_OVERRIDE_TYPE | VARCHAR2 | (1) | Indicates dependency override was requested on transaction | |
| FAA_FEDRAL_SCHL_CD | VARCHAR2 | (6) | Holds information about federal school that requested dependency override or adjusted calculated request | |
| FAA_ADJUSTMENT_TYPE | VARCHAR2 | (1) | Indicates whether Financial Aid administrator requested EFC adjustment and if it was processed | |
| INPUT_RECORD_TYPE | VARCHAR2 | (1) | Indicates type of ISIR record. Values are Initial Application, Correction Application, Duplicate Request, History Correction, or Renewal. | |
| SERIAL_NUM | NUMBER | (5) | Sequential position of ISIR in batch, except for SARA files | |
| BATCH_NUMBER_TXT | VARCHAR2 | (23) | Holds unique batch number of ISIR record | |
| EARLY_ANALYSIS_FLAG | VARCHAR2 | (1) | Indicates whether student requests early admission to institution | |
| APP_ENTRY_SOURCE_TYPE | VARCHAR2 | (1) | Indicates origin of electronic application | |
| ETI_DESTINATION_CD | VARCHAR2 | (7) | TG number assigned by Title IV WAN | |
| REJECT_OVERRIDE_B_FLAG | VARCHAR2 | (1) | Indicates rejection override used while processing record. Deals with date of birth. | |
| REJECT_OVERRIDE_N_FLAG | VARCHAR2 | (1) | Indicates rejection override used while processing record. Deals with missing first or last name. | |
| REJECT_OVERRIDE_W_FLAG | VARCHAR2 | (1) | Indicates rejection override used while processing record. Deals with questionable number of family members. | |
| ASSUM_OVERRIDE_1_FLAG | VARCHAR2 | (1) | Indicates assumption made by CPS while processing student record. States that parents' number of family members in college was assumed to be 1 when it is more than 6. | |
| ASSUM_OVERRIDE_2_FLAG | VARCHAR2 | (1) | Indicates assumption made by CPS while processing student record. States that parents' adjusted gross income was assumed to be equal to sum of father and mother's earned income. | |
| ASSUM_OVERRIDE_3_FLAG | VARCHAR2 | (1) | Indicates assumption made by CPS while processing student record. States that student's number of family members in college was assumed to be 1 when it is more than 2. | |
| ASSUM_OVERRIDE_4_FLAG | VARCHAR2 | (1) | Indicates assumption made by CPS while processing student record. States that student's adjusted gross income assumed equal to sum of student and spouse's earned income. | |
| ASSUM_OVERRIDE_5_FLAG | VARCHAR2 | (1) | Indicates assumption made by CPS while processing student record. States that parents' total from Worksheet C assumed to be zero. Allows parents' income from Worksheet C to be less than or equal to parents' total income. | |
| ASSUM_OVERRIDE_6_FLAG | VARCHAR2 | (1) | Indicates assumption made by CPS while processing student record. States that student's total from Worksheet C assumed to be zero. Allows parents' income from Worksheet C to be less than or equal to student's total income. | |
| DEPENDENCY_STATUS_TYPE | VARCHAR2 | (1) | Indicates dependency status as determined by CPS based upon data student provided | |
| S_EMAIL_ADDRESS_TXT | VARCHAR2 | (50) | Denotes student's e-mail address | |
| NSLDS_REASON_CD | VARCHAR2 | (30) | Indicates eligibility of a student for loan based upon information available with NSLDS | |
| APP_RECEIPT_DATE | DATE | Date transaction was received by Department of Education or school, or date student filled out web form | ||
| PROCESSED_REC_TYPE | VARCHAR2 | (1) | Indicates type of application. Values are Initial, Renewal, Correction, History, or Duplicate. | |
| HIST_CORR_FOR_TRAN_NUM | NUMBER | (2) | If record is correction record, indicates transaction number of record, which initiated correction. | |
| SYS_GENERATED_INDICATOR_TYPE | VARCHAR2 | (1) | Indicates transaction was initiated by CPS without input from applicant | |
| DUP_REQUEST_INDICATOR_TYPE | VARCHAR2 | (1) | Indicates transaction is result of duplicate request | |
| SOURCE_OF_CORRECTION_TYPE | VARCHAR2 | (1) | Indicates source of correction. Values are Applicant, CPS, or School. | |
| P_CAL_TAX_STATUS_TYPE | VARCHAR2 | (1) | Indicates tax filling status as determined by CPS | |
| S_CAL_TAX_STATUS_TYPE | VARCHAR2 | (1) | Indicates student's tax status as determined by CPS | |
| GRADUATE_FLAG | VARCHAR2 | (1) | Indicates that student is graduate | |
| AUTO_ZERO_EFC_FLAG | VARCHAR2 | (1) | Indicates that EFC is set to zero based on income criteria provided by student. Zero EFC is automatically set if Simplified Needs Test is met, and taxable income is $12,000 or less. | |
| EFC_CHANGE_FLAG | VARCHAR2 | (1) | Indicates whether EFC has gone up or down from transaction being applied against. Applicable only if ISIR record is not new application | |
| SARC_FLAG | VARCHAR2 | (1) | Indicates if C flag is set for student | |
| SIMPLIFIED_NEED_TEST_FLAG | VARCHAR2 | (1) | Indicates that applicant meets certain criteria for tax filing status and income level, and is not required to provide asset information | |
| REJECT_REASON_CODES_TXT | VARCHAR2 | (14) | Indicates why application or correction has been rejected | |
| SELECT_SERVICE_MATCH_TYPE | VARCHAR2 | (1) | Selective Service match flag. Results from Selective Service match for applicants who met criteria to be sent to match. | |
| SELECT_SERVICE_REG_TYPE | VARCHAR2 | (1) | Results from student's request to be registered with Selective Service | |
| INS_MATCH_FLAG | VARCHAR2 | (1) | Results from Immigration and Naturalization Service match for applicants who met criteria to be sent to match | |
| INS_VERIFICATION_NUM | NUMBER | (15) | Identification number provided by Immigration and Naturalization Service indicating that primary verification was performed - No longer used | |
| SEC_INS_MATCH_TYPE | VARCHAR2 | (1) | Results from Immigration and Naturalization Service match for applicants who were not matched on initial match | |
| SEC_INS_VER_NUM | NUMBER | (15) | Identification number provided by Immigration and Naturalization Service indicating that secondary verification was performed | |
| SSN_MATCH_TYPE | VARCHAR2 | (1) | Results from SSN match with Social Security Administration | |
| SSA_CITIZENSHIP_TYPE | VARCHAR2 | (1) | Results from citizenship match with Social Security Administration | |
| SSN_DEATH_DATE | DATE | Date of death provided for SSN from Social Security Administration | ||
| NSLDS_MATCH_TYPE | VARCHAR2 | (1) | Results of NSLDS match | |
| VA_MATCH_TYPE | VARCHAR2 | (1) | Results of Veterans Affairs match | |
| PRISONER_MATCH_FLAG | VARCHAR2 | (1) | Indicates information regarding prisoner match | |
| VERIFICATION_FLAG | VARCHAR2 | (1) | Indicates whether student is selected for verification | |
| SUBSEQUENT_APP_FLAG | VARCHAR2 | (1) | Indicates that initial or renewal application with same SSN and name identifier as transaction was already present on CPS database. | |
| APP_SOURCE_SITE_CD | VARCHAR2 | (2) | Application source site code indicates origin of initial application and site location | |
| TRAN_SOURCE_SITE_CD | VARCHAR2 | (2) | Indicates origin of transaction and site location | |
| DRN_NUM | NUMBER | (4) | Data Release Number will only be included when transaction was initiated at destination point. | |
| TRAN_PROCESS_DATE | DATE | Indicates date CPS computed transaction | ||
| CORRECTION_FLAGS_TXT | VARCHAR2 | (120) | Indicates correction done to specific SAR field. Each correction flag corresponds to specific SAR field. | |
| COMPUTER_BATCH_NUM | NUMBER | (3) | Indicates batch number of transaction | |
| HIGHLIGHT_FLAGS_TXT | VARCHAR2 | (120) | Indicates fields highlighted in boldface on SAR | |
| PAID_EFC_AMT | NUMBER | (5) | Holds lower of primary or secondary EFC | |
| PRIMARY_EFC_AMT | NUMBER | (5) | Primary 9 month EFC calculated for student based on SAR information provided by student. | |
| SECONDARY_EFC_AMT | NUMBER | (5) | Secondary 9 month EFC calculated for student based on SAR information provided by student. | |
| FED_PELL_GRANT_EFC_TYPE | VARCHAR2 | (1) | Identifies which EFC was placed in Paid EFC | |
| PRIMARY_EFC_TYPE | VARCHAR2 | (1) | Identifies formula type used to calculate primary EFC | |
| SEC_EFC_TYPE | VARCHAR2 | (1) | Identifies formula type used to calculate secondary EFC | |
| PRIMARY_ALT_MONTH_1_AMT | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALT_MONTH_2_AMT | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALT_MONTH_3_AMT | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALT_MONTH_4_AMT | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALT_MONTH_5_AMT | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALT_MONTH_6_AMT | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALT_MONTH_7_AMT | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALT_MONTH_8_AMT | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALT_MONTH_10_AMT | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALT_MONTH_11_AMT | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALT_MONTH_12_AMT | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_1_AMT | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_2_AMT | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_3_AMT | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_4_AMT | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_5_AMT | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_6_AMT | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_7_AMT | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_8_AMT | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_10_AMT | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_11_AMT | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_12_AMT | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| TOTAL_INCOME_AMT | NUMBER | (7) | Student's total income | |
| ALLOW_TOTAL_INCOME_AMT | NUMBER | (7) | Allowances against total income | |
| STATE_TAX_ALLOW_AMT | NUMBER | (7) | State and other tax allowance received by student | |
| EMPLOYMENT_ALLOW_AMT | NUMBER | (7) | Employment allowance received by student | |
| INCOME_PROTECTION_ALLOW_AMT | NUMBER | (7) | Income protection allowance received by student | |
| AVAILABLE_INCOME_AMT | NUMBER | (7) | Available income as calculated for student | |
| CONTRIBUTION_FROM_AI_AMT | NUMBER | (7) | Student's contribution from available income | |
| DISCRETIONARY_NETWORTH_AMT | NUMBER | (9) | Student's discretionary net worth | |
| EFC_NETWORTH_AMT | NUMBER | (9) | EFC net worth as calculated by CPS | |
| ASSET_PROTECT_ALLOW_AMT | NUMBER | (9) | Asset protection allowance calculated based on student's assets | |
| PARENTS_CONT_FROM_ASSETS_AMT | NUMBER | (7) | Parents' contribution from assets as calculated by CPS | |
| ADJUSTED_AVAIL_INCOME_AMT | NUMBER | (7) | Adjusted available income as calculated by CPS | |
| TOTAL_STUDENT_CONTRIB_AMT | NUMBER | (7) | Total student contribution as calculated by CPS | |
| TOTAL_PARENT_CONTRIB_AMT | NUMBER | (7) | Total parent contribution as calculated by CPS based on financial information provided by student | |
| PARENTS_CONTRIBUTION_AMT | NUMBER | (7) | Parents' contribution as calculated by CPS based on financial information provided by student on FAFSA | |
| STUDENT_TOTAL_INCOME_AMT | NUMBER | (7) | Student's total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SATI_AMT | NUMBER | (7) | Student's allowance against total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SIC_AMT | NUMBER | (7) | Dependent student's income contribution as calculated by CPS based on financial information provided by student on FAFSA | |
| SDNW_AMT | NUMBER | (9) | Student's discretionary net worth as calculated by CPS based on financial information provided by student on FAFSA | |
| SCA_AMT | NUMBER | (7) | Student's contribution from assets as calculated by CPS based on financial information provided by student on FAFSA | |
| FTI_AMT | NUMBER | (7) | FISAP total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECTI_AMT | NUMBER | (7) | Secondary total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECATI_AMT | NUMBER | (7) | Secondary allowance against total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECSTX_AMT | NUMBER | (7) | Secondary state tax allowance as calculated by CPS based on financial information provided by student on FAFSA | |
| SECEA_AMT | NUMBER | (7) | Secondary employment allowance as calculated by CPS based on financial information provided by student on FAFSA | |
| SECIPA_AMT | NUMBER | (7) | Secondary income protection allowance as calculated by CPS based on financial information provided by student on FAFSA | |
| SECAI_AMT | NUMBER | (7) | Secondary available income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECCAI_AMT | NUMBER | (7) | Secondary contribution from available income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECDNW_AMT | NUMBER | (9) | Secondary discretionary net worth as calculated by CPS based on financial information provided by student on FAFSA | |
| SECNW_AMT | NUMBER | (9) | Secondary net worth as calculated by CPS based on financial information provided by student on FAFSA | |
| SECAPA_AMT | NUMBER | (9) | Secondary asset protection allowance as calculated by CPS based on financial information provided by student on FAFSA | |
| SECPCA_AMT | NUMBER | (7) | Secondary parents' contribution from assets as calculated by CPS based on financial information provided by student on FAFSA | |
| SECAAI_AMT | NUMBER | (7) | Secondary adjusted available income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECTSC_AMT | NUMBER | (7) | Secondary total student contribution as calculated by CPS based on financial information provided by student on FAFSA | |
| SECTPC_AMT | NUMBER | (7) | Secondary total parent contribution as calculated by CPS based on financial information provided by student on FAFSA | |
| SECPC_AMT | NUMBER | (7) | Secondary parent contribution as calculated by CPS based on financial information provided by student on FAFSA | |
| SECSTI_AMT | NUMBER | (7) | Secondary student's total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECSATI_AMT | NUMBER | (7) | Secondary student's allowance against total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECSIC_AMT | NUMBER | (7) | Secondary student's dependent income contribution as calculated by CPS based on financial information provided by student on FAFSA | |
| SECSDNW_AMT | NUMBER | (9) | Secondary student's discretionary net worth as calculated by CPS based on financial information provided by student on FAFSA | |
| SECSCA_AMT | NUMBER | (7) | Secondary student's contribution from assets as calculated by CPS based on financial information provided by student on FAFSA | |
| SECFTI_AMT | NUMBER | (7) | Secondary FISAP total income as calculated by CPS based on financial information provided by student on FAFSA | |
| A_CITIZENSHIP_FLAG | VARCHAR2 | (1) | Citizenship status assumed for student while processing FAFSA application | |
| A_STUDNT_MARITAL_STATUS_FLAG | VARCHAR2 | (1) | Marital status assumed for student while processing FAFSA application | |
| A_STUDENT_AGI_AMT | NUMBER | (6) | Adjusted gross income assumed for student while processing application | |
| A_S_US_TAX_PAID_AMT | NUMBER | (5) | Assumed US tax student paid | |
| A_S_INCOME_WORK_AMT | NUMBER | (6) | Student's income from work assumed for processing | |
| A_SPOUSE_INCOME_WORK_AMT | NUMBER | (6) | Spouse's income from work assumed for processing | |
| A_S_TOTAL_WSC_AMT | NUMBER | (5) | Student's income from Worksheet C assumed for processing | |
| A_DATE_OF_BIRTH_FLAG | VARCHAR2 | (1) | Indicates whether student's date of birth was assumed to be prior to cut-off date | |
| A_STUDENT_MARRIED_FLAG | VARCHAR2 | (1) | Indicates whether student is assumed to be married | |
| A_HAVE_CHILDREN_FLAG | VARCHAR2 | (1) | Indicates whether student is assumed to have children to support | |
| A_S_HAVE_DEPENDENTS_FLAG | VARCHAR2 | (1) | Indicates whether student is assumed to have dependents other than children while processing student's FAFSA application | |
| A_VA_STATUS_FLAG | VARCHAR2 | (1) | Indicates assumed veteran status | |
| A_S_IN_FAMILY_NUM | NUMBER | (2) | Assumed number of people in student's family while processing | |
| A_S_IN_COLLEGE_NUM | NUMBER | (1) | Assumed number of student's family members in college | |
| A_P_MARITAL_STATUS_FLAG | VARCHAR2 | (1) | Assumed marital status of parents | |
| A_FATHER_SSN_TXT | VARCHAR2 | (9) | Father's assumed SSN | |
| A_MOTHER_SSN_TXT | VARCHAR2 | (9) | Mother's assumed SSN | |
| A_PARENTS_FAMILY_NUM | NUMBER | (2) | Assumed number of family members in parents' family | |
| A_PARENTS_COLLEGE_NUM | NUMBER | (1) | Assumed number of family members in college from parents' family | |
| A_PARENTS_AGI_AMT | NUMBER | (6) | Assumed parents' annual gross income for application processing | |
| A_P_US_TAX_PAID_AMT | NUMBER | (6) | Assumed US tax parents paid | |
| A_F_WORK_INCOME_AMT | NUMBER | (6) | Assumed father's income earned from work | |
| A_M_WORK_INCOME_AMT | NUMBER | (6) | Assumed mother's income from work | |
| A_P_TOTAL_WSC_AMT | NUMBER | (5) | Assumed parents' total from Worksheet C | |
| COMMENT_CODES_TXT | VARCHAR2 | (60) | Comments provided by CPS to further communicate important results and processing information | |
| SAR_ACK_COMM_CODES_TXT | VARCHAR2 | (20) | SAR acknowledgment comment codes. Ten 2-digit codes for comments appearing on SAR. Codes are entered from left to right by CPS, and unused positions are filled with zeros. | |
| PELL_GRANT_ELIG_FLAG | VARCHAR2 | (1) | Indicates transaction has been determined eligible for federal Pell grant | |
| REPROCESS_REASON_CD | VARCHAR2 | (2) | Code to identify why ISIR was reprocessed by CPS, which releases definition of codes | |
| DUPLICATE_DATE | DATE | CPS process date for duplicate transaction requested | ||
| ISIR_TRANSACTION_TYPE | VARCHAR2 | (1) | Indicates from where transaction was generated. Values are Initial Application, Automatic ISIR, Correction, Duplicate Request, or Renewal Application. | |
| FEDRAL_SCHL_TYPE | VARCHAR2 | (1) | Identifies one of colleges that initiated electronic action to create transaction | |
| MULTI_SCHOOL_CD_FLAGS_TXT | VARCHAR2 | (6) | Each byte of field corresponds to 6 federal school codes choices. | |
| DUP_SSN_INDICATOR_FLAG | VARCHAR2 | (1) | Indicates if another filer is using original SSN in original SSN field. Set to Y if more than one person uses SSN. | |
| NSLDS_TRANSACTION_NUM | NUMBER | (2) | Holds latest transaction number for which NSLDS data was updated | |
| NSLDS_DATABASE_RESULTS_TYPE | VARCHAR2 | (1) | Indicates matching record was found in NSLDS database | |
| NSLDS_FLAG | VARCHAR2 | (1) | Flag set by NSLDS | |
| NSLDS_PELL_OVERPAY_TYPE | VARCHAR2 | (1) | NSLDS Pell overpayment flag. Indicates if there was overpayment of Pell grant. | |
| NSLDS_PELL_OVERPAY_CONT_TXT | VARCHAR2 | (8) | Indicates contact school code for Pell overpayment | |
| NSLDS_SEOG_OVERPAY_TYPE | VARCHAR2 | (1) | NSLDS SEOG overpayment flag. Indicates if overpayment was made for Education Opportunity Grant. | |
| NSLDS_SEOG_OVERPAY_CONT_TXT | VARCHAR2 | (8) | Indicates contact school for SEOG overpayment | |
| NSLDS_PERKINS_OVERPAY_TYPE | VARCHAR2 | (1) | Indicates if overpayment was made for Perkins grant | |
| NSLDS_PERK_OVRPAY_CNTCT_TXT | VARCHAR2 | (8) | Contact school for Perkins overpayment | |
| NSLDS_DEFAULTED_LOAN_FLAG | VARCHAR2 | (1) | Indicates if student has defaulted NSLDS loan | |
| NSLDS_DISCHARGED_LOAN_TYPE | VARCHAR2 | (1) | NSLDS discharged loan flag | |
| NSLDS_SATIS_REPAY_FLAG | VARCHAR2 | (1) | Indicates loan had satisfactory repayment | |
| NSLDS_ACT_BANKRUPTCY_FLAG | VARCHAR2 | (1) | Indicates if student is bankrupt | |
| NSLDS_AGG_SUBSZ_OUT_PBAL_AMT | NUMBER | (6) | NSLDS aggregate subsidized outstanding principal balance amount | |
| NSLDS_AGG_UNSBZ_OUT_PBAL_AMT | NUMBER | (6) | NSLDS aggregate unsubsidized outstanding principal balance amount | |
| NSLDS_AGG_COMB_OUT_PBAL_AMT | NUMBER | (6) | NSLDS aggregate combined outstanding principal balance amount | |
| NSLDS_AGG_CONS_OUT_PBAL_AMT | NUMBER | (6) | NSLDS aggregate consolidated outstanding principal balance amount | |
| NSLDS_AGG_SUBSZ_PND_DISB_AMT | NUMBER | (6) | NSLDS aggregate subsidized pending disbursement amount | |
| NSLDS_AGG_UNSBZ_PND_DISB_AMT | NUMBER | (6) | NSLDS aggregate unsubsidized pending disbursement amount | |
| NSLDS_AGG_COMB_PEND_DISB_AMT | NUMBER | (6) | NSLDS aggregate combined pending disbursement amount | |
| NSLDS_AGG_SUBSZ_TOTAL_AMT | NUMBER | (6) | NSLDS aggregate subsidized total amount | |
| NSLDS_AGG_UNSBZ_TOTAL_AMT | NUMBER | (6) | NSLDS aggregate unsubsidized total amount | |
| NSLDS_AGG_COMB_TOTAL_AMT | NUMBER | (6) | NSLDS aggregate combined total amount | |
| NSLDS_AGG_CONSD_TOTAL_AMT | NUMBER | (6) | NSLDS aggregate consolidated total amount | |
| NSLDS_PERKINS_OUT_BAL_AMT | NUMBER | (6) | NSLDS Perkins outstanding balance amount | |
| NSLDS_PERKIN_CUR_YR_DISB_AMT | NUMBER | (6) | NSLDS Perkins current year disbursement amount | |
| NSLDS_DEFAULT_LOAN_CHNG_FLAG | VARCHAR2 | (1) | NSLDS defaulted loan change flag | |
| NSLDS_DISCHGD_LOAN_CHNG_FLAG | VARCHAR2 | (1) | NSLDS discharged loan change flag | |
| NSLDS_SATIS_REPAY_CHNG_FLAG | VARCHAR2 | (1) | NSLDS satisfactory repayment change flag | |
| NSLDS_ACT_BNKRUPT_CHNG_FLAG | VARCHAR2 | (1) | NSLDS active bankruptcy flag | |
| NSLDS_OVERPAY_CHNG_FLAG | VARCHAR2 | (1) | NSLDS overpayments change flag | |
| NSLDS_AGG_LOAN_CHNG_FLAG | VARCHAR2 | (1) | NSLDS aggregate loan change flag | |
| NSLDS_PERKINS_LOAN_CHNG_FLAG | VARCHAR2 | (1) | NSLDS Perkins loan change flag | |
| NSLDS_PELL_PAYMNT_CHNG_FLAG | VARCHAR2 | (1) | NSLDS Pell loan change flag | |
| NSLDS_ADDTNL_PELL_FLAG | VARCHAR2 | (1) | NSLDS additional Pell flag | |
| NSLDS_ADDTNL_LOAN_FLAG | VARCHAR2 | (1) | NSLDS additional loan flag | |
| DIRECT_LOAN_MAS_PROM_NT_TYPE | VARCHAR2 | (1) | Direct Loan master promissory flag | |
| NSLDS_PELL_1_SEQ_NUM | NUMBER | (2) | NSLDS Pell sequence number (1) | |
| NSLDS_PELL_1_VERIFY_F_TXT | VARCHAR2 | (3) | NSLDS Pell verification flag (1) | |
| NSLDS_PELL_1_EFC_AMT | NUMBER | (6) | NSLDS Pell EFC (1) | |
| NSLDS_PELL_1_SCHOOL_NUM | NUMBER | (8) | NSLDS Pell school code (1) | |
| NSLDS_PELL_1_TRANSCN_NUM | NUMBER | (2) | NSLDS Pell transaction number (1) | |
| NSLDS_PELL_1_LAST_UPDT_DATE | DATE | Last update date of NSLDS Pell value (1) | ||
| NSLDS_PELL_1_SCHEDULED_AMT | NUMBER | (6) | NSLDS Pell scheduled amount (1) | |
| NSLDS_PELL_1_PAID_TODT_AMT | NUMBER | (6) | NSLDS Pell amount paid to date (1) | |
| NSLDS_PELL_1_REMNG_AMT | NUMBER | (6) | NSLDS Pell remaining amount (1) | |
| NSLDS_PELL_1_PC_SCWD_USE_AMT | NUMBER | (5) | NSLDS Pell percent scheduled award used (1) | |
| NSLDS_PELL_1_AWARD_AMT | NUMBER | (6) | NSLDS Pell award amount (1) | |
| NSLDS_PELL_2_SEQ_NUM | NUMBER | (2) | NSLDS Pell sequence number (2) | |
| NSLDS_PELL_2_VERIFY_F_TXT | VARCHAR2 | (3) | NSLDS Pell verification flag (2) | |
| NSLDS_PELL_2_EFC_AMT | NUMBER | (6) | NSLDS Pell EFC (2) | |
| NSLDS_PELL_2_SCHOOL_NUM | NUMBER | (8) | NSLDS Pell school code (2) | |
| NSLDS_PELL_2_TRANSCN_NUM | NUMBER | (2) | NSLDS Pell transaction number (2) | |
| NSLDS_PELL_2_LAST_UPDT_DATE | DATE | Last update date of NSLDS Pell value (2) | ||
| NSLDS_PELL_2_SCHEDULED_AMT | NUMBER | (6) | NSLDS Pell scheduled amount (2) | |
| NSLDS_PELL_2_PAID_TODT_AMT | NUMBER | (6) | NSLDS Pell amount paid to date (2) | |
| NSLDS_PELL_2_REMNG_AMT | NUMBER | (6) | NSLDS Pell remaining amount (2) | |
| NSLDS_PELL_2_PC_SCWD_USE_AMT | NUMBER | (5) | NSLDS Pell percent scheduled award used (2) | |
| NSLDS_PELL_2_AWARD_AMT | NUMBER | (6) | NSLDS Pell award amount (2) | |
| NSLDS_PELL_3_SEQ_NUM | NUMBER | (2) | NSDLS Pell sequence number (3) | |
| NSLDS_PELL_3_VERIFY_F_TXT | VARCHAR2 | (3) | NSLDS Pell verification flag (3) | |
| NSLDS_PELL_3_EFC_AMT | NUMBER | (6) | NSLDS Pell effective family contribution (3) | |
| NSLDS_PELL_3_SCHOOL_NUM | NUMBER | (8) | NSDLS Pell school code (3) | |
| NSLDS_PELL_3_TRANSCN_NUM | NUMBER | (2) | NSDLS Pell transaction number (3) | |
| NSLDS_PELL_3_LAST_UPDT_DATE | DATE | Last update date of NSLDS Pell value (3) | ||
| NSLDS_PELL_3_SCHEDULED_AMT | NUMBER | (6) | NSDLS Pell scheduled amount (3) | |
| NSLDS_PELL_3_PAID_TODT_AMT | NUMBER | (6) | NSDLS Pell amount paid to date (3) | |
| NSLDS_PELL_3_REMNG_AMT | NUMBER | (6) | NSDLS Pell remaining amount (3) | |
| NSLDS_PELL_3_PC_SCWD_USE_AMT | NUMBER | (5) | NSLDS Pell percent scheduled award used (3) | |
| NSLDS_PELL_3_AWARD_AMT | NUMBER | (6) | NSDLS Pell award amount (3) | |
| NSLDS_LOAN_1_SEQ_NUM | NUMBER | (2) | NSLDS loan (1) sequence number | |
| NSLDS_LOAN_1_TYPE | VARCHAR2 | (1) | NSLDS loan (1) type code | |
| NSLDS_LOAN_1_CHNG_FLAG | VARCHAR2 | (1) | NSLDS loan (1) change flag | |
| NSLDS_LOAN_1_PROG_CD | VARCHAR2 | (2) | NSLDS loan (1) program code | |
| NSLDS_LOAN_1_NET_AMT | NUMBER | (6) | NSLDS loan (1) net amount | |
| NSLDS_LOAN_1_CUR_ST_CD | VARCHAR2 | (2) | NSLDS loan (1) current status code | |
| NSLDS_LOAN_1_CUR_ST_DATE | DATE | NSLDS loan (1) current status date | ||
| NSLDS_LOAN_1_AGG_PR_BAL_AMT | NUMBER | (6) | NSLDS loan (1) aggregate principal balance amount | |
| NSLDS_LOAN_1_OUT_PR_BAL_DATE | DATE | NSLDS loan (1) outstanding principal balance date | ||
| NSLDS_LOAN_1_BEGIN_DATE | DATE | NSLDS loan (1) begin date | ||
| NSLDS_LOAN_1_END_DATE | DATE | NSLDS loan (1) end date | ||
| NSLDS_LOAN_1_GA_CD | VARCHAR2 | (3) | NSLDS loan (1) GA code | |
| NSLDS_LOAN_1_CONT_TYPE | VARCHAR2 | (3) | NSLDS loan (1) contact type | |
| NSLDS_LOAN_1_SCHOL_CD | VARCHAR2 | (8) | NSLDS loan (1) school code | |
| NSLDS_LOAN_1_CONT_CD | VARCHAR2 | (8) | NSLDS loan (1) contact code | |
| NSLDS_LOAN_1_GRADE_LVL_TXT | VARCHAR2 | (3) | NSLDS loan (1) grade level | |
| NSLDS_LOAN_1_X_UNSBZ_LN_TYPE | VARCHAR2 | (1) | NSLDS loan (1) extra unsubsidized loan flag | |
| NSLDS_LOAN_1_CAPTAL_INT_FLAG | VARCHAR2 | (1) | NSLDS loan (1) capitalized interest flag | |
| NSLDS_LOAN_2_SEQ_NUM | NUMBER | (2) | NSLDS loan (2) sequence number | |
| NSLDS_LOAN_2_TYPE | VARCHAR2 | (1) | NSLDS loan (2) type code | |
| NSLDS_LOAN_2_CHNG_FLAG | VARCHAR2 | (1) | NSLDS loan (2) change flag | |
| NSLDS_LOAN_2_PROG_CD | VARCHAR2 | (2) | NSLDS loan (2) program code | |
| NSLDS_LOAN_2_NET_AMT | NUMBER | (6) | NSLDS loan (2) net amount | |
| NSLDS_LOAN_2_CUR_ST_CD | VARCHAR2 | (2) | NSLDS loan (2) current status code | |
| NSLDS_LOAN_2_CUR_ST_DATE | DATE | NSLDS loan (2) current status date | ||
| NSLDS_LOAN_2_AGG_PR_BAL_AMT | NUMBER | (6) | NSLDS loan (2) aggregate principal balance amount | |
| NSLDS_LOAN_2_OUT_PR_BAL_DATE | DATE | NSLDS loan (2) outstanding principal balance date | ||
| NSLDS_LOAN_2_BEGIN_DATE | DATE | NSLDS loan (2) begin date | ||
| NSLDS_LOAN_2_END_DATE | DATE | NSLDS loan (2) end date | ||
| NSLDS_LOAN_2_GA_CD | VARCHAR2 | (3) | NSLDS loan (2) GA code | |
| NSLDS_LOAN_2_CONT_TYPE | VARCHAR2 | (3) | NSLDS loan (2) contact type | |
| NSLDS_LOAN_2_SCHOL_CD | VARCHAR2 | (8) | NSLDS loan (2) school code | |
| NSLDS_LOAN_2_CONT_CD | VARCHAR2 | (8) | NSLDS loan (2) contact code | |
| NSLDS_LOAN_2_GRADE_LVL_TXT | VARCHAR2 | (3) | NSLDS loan (2) grade level | |
| NSLDS_LOAN_2_X_UNSBZ_LN_TYPE | VARCHAR2 | (1) | NSLDS loan (2) extra unsubsidized loan flag | |
| NSLDS_LOAN_2_CAPTAL_INT_FLAG | VARCHAR2 | (1) | NSLDS loan (2) capitalized interest flag | |
| NSLDS_LOAN_3_SEQ_NUM | NUMBER | (2) | NSLDS loan (3) sequence number | |
| NSLDS_LOAN_3_TYPE | VARCHAR2 | (1) | NSLDS loan (3) type code | |
| NSLDS_LOAN_3_CHNG_FLAG | VARCHAR2 | (1) | NSLDS loan (3) change flag | |
| NSLDS_LOAN_3_PROG_CD | VARCHAR2 | (2) | NSLDS loan (3) program code | |
| NSLDS_LOAN_3_NET_AMT | NUMBER | (6) | NSLDS loan (3) net amount | |
| NSLDS_LOAN_3_CUR_ST_CD | VARCHAR2 | (2) | NSLDS loan (3) current status code | |
| NSLDS_LOAN_3_CUR_ST_DATE | DATE | NSLDS loan (3) current status date | ||
| NSLDS_LOAN_3_AGG_PR_BAL_AMT | NUMBER | (6) | NSLDS loan (3) aggregate principal balance amount | |
| NSLDS_LOAN_3_OUT_PR_BAL_DATE | DATE | NSLDS loan (3) outstanding principal balance date | ||
| NSLDS_LOAN_3_BEGIN_DATE | DATE | NSLDS loan (3) begin date | ||
| NSLDS_LOAN_3_END_DATE | DATE | NSLDS loan (3) end date | ||
| NSLDS_LOAN_3_GA_CD | VARCHAR2 | (3) | NSLDS loan (3) GA code | |
| NSLDS_LOAN_3_CONT_TYPE | VARCHAR2 | (3) | NSLDS loan (3) contact type | |
| NSLDS_LOAN_3_SCHOL_CD | VARCHAR2 | (8) | NSLDS loan (3) school code | |
| NSLDS_LOAN_3_CONT_CD | VARCHAR2 | (8) | NSLDS loan (3) contact code | |
| NSLDS_LOAN_3_GRADE_LVL_TXT | VARCHAR2 | (3) | NSLDS loan (3) grade level | |
| NSLDS_LOAN_3_X_UNSBZ_LN_TYPE | VARCHAR2 | (1) | NSLDS loan (3) extra unsubsidized loan flag | |
| NSLDS_LOAN_3_CAPTAL_INT_FLAG | VARCHAR2 | (1) | NSLDS loan (3) capitalized interest flag | |
| NSLDS_LOAN_4_SEQ_NUM | NUMBER | (2) | NSLDS loan (4) sequence number | |
| NSLDS_LOAN_4_TYPE | VARCHAR2 | (1) | NSLDS loan (4) type code | |
| NSLDS_LOAN_4_CHNG_FLAG | VARCHAR2 | (1) | NSLDS loan (4) change flag | |
| NSLDS_LOAN_4_PROG_CD | VARCHAR2 | (2) | NSLDS loan (4) program code | |
| NSLDS_LOAN_4_NET_AMT | NUMBER | (6) | NSLDS loan (4) net amount | |
| NSLDS_LOAN_4_CUR_ST_CD | VARCHAR2 | (2) | NSLDS loan (4) current status code | |
| NSLDS_LOAN_4_CUR_ST_DATE | DATE | NSLDS loan (4) current status date | ||
| NSLDS_LOAN_4_AGG_PR_BAL_AMT | NUMBER | (6) | NSLDS loan (4) aggregate principal balance amount | |
| NSLDS_LOAN_4_OUT_PR_BAL_DATE | DATE | NSLDS loan (4) outstanding principal balance date | ||
| NSLDS_LOAN_4_BEGIN_DATE | DATE | NSLDS loan (4) begin date | ||
| NSLDS_LOAN_4_END_DATE | DATE | NSLDS loan (4) end date | ||
| NSLDS_LOAN_4_GA_CD | VARCHAR2 | (3) | NSLDS loan (4) GA code | |
| NSLDS_LOAN_4_CONT_TYPE | VARCHAR2 | (3) | NSLDS loan (4) contact type | |
| NSLDS_LOAN_4_SCHOL_CD | VARCHAR2 | (8) | NSLDS loan (4) school code | |
| NSLDS_LOAN_4_CONT_CD | VARCHAR2 | (8) | NSLDS loan (4) contact code | |
| NSLDS_LOAN_4_GRADE_LVL_TXT | VARCHAR2 | (3) | NSLDS loan (4) grade level | |
| NSLDS_LOAN_4_X_UNSBZ_LN_TYPE | VARCHAR2 | (1) | NSLDS loan (4) extra unsubsidized loan flag | |
| NSLDS_LOAN_4_CAPTAL_INT_FLAG | VARCHAR2 | (1) | NSLDS loan (4) capitalized interest flag | |
| NSLDS_LOAN_5_SEQ_NUM | NUMBER | (2) | NSLDS loan (5) sequence number | |
| NSLDS_LOAN_5_TYPE | VARCHAR2 | (1) | NSLDS loan (5) type code | |
| NSLDS_LOAN_5_CHNG_FLAG | VARCHAR2 | (1) | NSLDS loan (5) change flag | |
| NSLDS_LOAN_5_PROG_CD | VARCHAR2 | (2) | NSLDS loan (5) program code | |
| NSLDS_LOAN_5_NET_AMT | NUMBER | (6) | NSLDS loan (5) net amount | |
| NSLDS_LOAN_5_CUR_ST_CD | VARCHAR2 | (2) | NSLDS loan (5) current status code | |
| NSLDS_LOAN_5_CUR_ST_DATE | DATE | NSLDS loan (5) current status date | ||
| NSLDS_LOAN_5_AGG_PR_BAL_AMT | NUMBER | (6) | NSLDS loan (5) aggregate principal balance amount | |
| NSLDS_LOAN_5_OUT_PR_BAL_DATE | DATE | NSLDS loan (5) outstanding principal balance date | ||
| NSLDS_LOAN_5_BEGIN_DATE | DATE | NSLDS loan (5) begin date | ||
| NSLDS_LOAN_5_END_DATE | DATE | NSLDS loan (5) end date | ||
| NSLDS_LOAN_5_GA_CD | VARCHAR2 | (3) | NSLDS loan (5) GA code | |
| NSLDS_LOAN_5_CONT_TYPE | VARCHAR2 | (3) | NSLDS loan (5) contact type | |
| NSLDS_LOAN_5_SCHOL_CD | VARCHAR2 | (8) | NSLDS loan (5) school code | |
| NSLDS_LOAN_5_CONT_CD | VARCHAR2 | (8) | NSLDS loan (5) contact code | |
| NSLDS_LOAN_5_GRADE_LVL_TXT | VARCHAR2 | (3) | NSLDS loan (5) grade level | |
| NSLDS_LOAN_5_X_UNSBZ_LN_TYPE | VARCHAR2 | (1) | NSLDS loan (5) extra unsubsidized loan flag | |
| NSLDS_LOAN_5_CAPTAL_INT_FLAG | VARCHAR2 | (1) | NSLDS loan (5) capitalized interest flag | |
| NSLDS_LOAN_6_SEQ_NUM | NUMBER | (2) | NSLDS loan (6) sequence number | |
| NSLDS_LOAN_6_TYPE | VARCHAR2 | (1) | NSLDS loan (6) type code | |
| NSLDS_LOAN_6_CHNG_FLAG | VARCHAR2 | (1) | NSLDS loan (6) change flag | |
| NSLDS_LOAN_6_PROG_CD | VARCHAR2 | (2) | NSLDS loan (6) program code | |
| NSLDS_LOAN_6_NET_AMT | NUMBER | (6) | NSLDS loan (6) net amount | |
| NSLDS_LOAN_6_CUR_ST_CD | VARCHAR2 | (2) | NSLDS loan (6) current status code | |
| NSLDS_LOAN_6_CUR_ST_DATE | DATE | NSLDS loan (6) current status date | ||
| NSLDS_LOAN_6_AGG_PR_BAL_AMT | NUMBER | (6) | NSLDS loan (6) aggregate principal balance amount | |
| NSLDS_LOAN_6_OUT_PR_BAL_DATE | DATE | NSLDS loan (6) outstanding principal balance date | ||
| NSLDS_LOAN_6_BEGIN_DATE | DATE | NSLDS loan (6) begin date | ||
| NSLDS_LOAN_6_END_DATE | DATE | NSLDS loan (6) end date | ||
| NSLDS_LOAN_6_GA_CD | VARCHAR2 | (3) | NSLDS loan (6) GA code | |
| NSLDS_LOAN_6_CONT_TYPE | VARCHAR2 | (3) | NSLDS loan (6) contact type | |
| NSLDS_LOAN_6_SCHOL_CD | VARCHAR2 | (8) | NSLDS loan (6) school code | |
| NSLDS_LOAN_6_CONT_CD | VARCHAR2 | (8) | NSLDS loan (6) contact code | |
| NSLDS_LOAN_6_GRADE_LVL_TXT | VARCHAR2 | (3) | NSLDS loan (6) grade level | |
| NSLDS_LOAN_6_X_UNSBZ_LN_TYPE | VARCHAR2 | (1) | NSLDS loan (6) extra unsubsidized loan flag | |
| NSLDS_LOAN_6_CAPTAL_INT_FLAG | VARCHAR2 | (1) | NSLDS loan (6) capitalized interest flag | |
| REQUEST_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
| PROGRAM_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
| PROGRAM_UPDATE_DATE | DATE | Standard Who column for concurrent programs | ||
| NSLDS_LOAN_1_LAST_DISB_AMT | NUMBER | (15) | NSLDS Loan (1) Last Disbursement Amount | |
| NSLDS_LOAN_1_LAST_DISB_DATE | DATE | NSLDS Loan (1) Last Disbursement Date | ||
| NSLDS_LOAN_2_LAST_DISB_AMT | NUMBER | (15) | NSLDS Loan (2) Last Disbursement Amount | |
| NSLDS_LOAN_2_LAST_DISB_DATE | DATE | NSLDS Loan (2) Last Disbursement Date | ||
| NSLDS_LOAN_3_LAST_DISB_AMT | NUMBER | (15) | NSLDS Loan (3) Last Disbursement Amount | |
| NSLDS_LOAN_3_LAST_DISB_DATE | DATE | NSLDS Loan (3) Last Disbursement Date | ||
| NSLDS_LOAN_4_LAST_DISB_AMT | NUMBER | (15) | NSLDS Loan (4) Last Disbursement Amount | |
| NSLDS_LOAN_4_LAST_DISB_DATE | DATE | NSLDS Loan (4) Last Disbursement Date | ||
| NSLDS_LOAN_5_LAST_DISB_AMT | NUMBER | (15) | NSLDS Loan (5) Last Disbursement Amount | |
| NSLDS_LOAN_5_LAST_DISB_DATE | DATE | NSLDS Loan (5) Last Disbursement Date | ||
| NSLDS_LOAN_6_LAST_DISB_AMT | NUMBER | (15) | NSLDS Loan (6) Last Disbursement Amount | |
| NSLDS_LOAN_6_LAST_DISB_DATE | DATE | NSLDS Loan (6) Last Disbursement Date | ||
| VERIF_TRACK_TYPE | VARCHAR2 | (4) | Verification Tracking Flag | |
| FAFSA_DATA_VERIFICATION_TXT | VARCHAR2 | (255) | Stores the FAFSA Data Verification related flags | |
| REJECT_OVERRIDE_A_FLAG | VARCHAR2 | (1) | Indicates the Reject Override A Status | |
| REJECT_OVERRIDE_C_FLAG | VARCHAR2 | (1) | Indicates the Reject Override C Status | |
| PARENT_MARITAL_STATUS_DATE | DATE | Stores the parents Marital Status date | ||
| DLP_MASTER_PROM_NOTE_TYPE | VARCHAR2 | (1) | Indicates the Direct Loan Plus Master Promissory Note Flag | |
| FATHR_FIRST_NAME_INITIAL_TXT | VARCHAR2 | (1) | Father's/Stepfather's First Name Initial | |
| FATHR_STEP_FATHER_BIRTH_DATE | DATE | Father's/Stepfather's Date of Birth | ||
| MOTHR_FIRST_NAME_INITIAL_TXT | VARCHAR2 | (1) | Mother's/Stepmother's First Name Initial | |
| MOTHR_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' 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 Security indicating that primary verification was performed. | |
| RECORD_STATUS | VARCHAR2 | (10) | Identifies status of ISIR record after initial processing. Values are matched, unmatched, new, or invalid. | |
| DATA_FILE_NAME_TXT | VARCHAR2 | (30) | Name of Data File used for Importing the ISIR | |
| MATCH_CODE | VARCHAR2 | (30) | Name of Record Matching criteria used for Importing the ISIR | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| REJECT_OVERRIDE_3_FLAG | VARCHAR2 | (1) | Reject Overrides 3 Flag | |
| REJECT_OVERRIDE_12_FLAG | VARCHAR2 | (1) | Reject Overrides 12 Flag | |
| REJECT_OVERRIDE_J_FLAG | VARCHAR2 | (1) | Reject Overrides J Flag | |
| REJECT_OVERRIDE_K_FLAG | VARCHAR2 | (1) | Reject Overrides K Flag | |
| REJECTED_STATUS_CHANGE_FLAG | VARCHAR2 | (1) | Rejected Status change Flag | |
| VERIFICATION_SELECTION_FLAG | VARCHAR2 | (1) | Verification Selection flag | |
| PARENT_REQ_ID | NUMBER | (22) | Parent Process Request ID | |
| SUB_REQ_NUM | NUMBER | (22) | Sub Process Request ID |
Cut, paste (and edit) the following text to query this object:
SELECT SI_ID
, BATCH_YEAR_NUM
, TRANSACTION_NUM_TXT
, SSN_NAME_CHANGE_TYPE
, ORIGINAL_SSN_TXT
, ORIG_NAME_ID_TXT
, CURRENT_SSN_TXT
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL_TXT
, PERM_MAIL_ADDRESS_TXT
, PERM_CITY_TXT
, PERM_STATE_TXT
, PERM_ZIP_CD
, BIRTH_DATE
, PHONE_NUMBER_TXT
, DRIVER_LICENSE_NUMBER_TXT
, DRIVER_LICENSE_STATE_TXT
, CITIZENSHIP_STATUS_TYPE
, ALIEN_REG_NUMBER_TXT
, S_MARITAL_STATUS_TYPE
, S_MARITAL_STATUS_DATE
, SUMM_ENRL_STATUS_TYPE
, FALL_ENRL_STATUS_TYPE
, WINTER_ENRL_STATUS_TYPE
, SPRING_ENRL_STATUS_TYPE
, SUMM2_ENRL_STATUS_TYPE
, FATHERS_HIGHST_EDU_LVL_TYPE
, MOTHERS_HIGHST_EDU_LVL_TYPE
, S_STATE_LEGAL_RESIDENCE
, LEGAL_RES_BEFORE_YEAR_FLAG
, S_LEGAL_RESD_DATE
, SS_R_U_MALE_FLAG
, SELECTIVE_SERVICE_REG_FLAG
, DEGREE_CERTIFICATION_TYPE
, GRADE_LEVEL_IN_COLLEGE_TYPE
, HIGH_SCHL_DIPLOMA_GED_FLAG
, FIRST_BACHLR_DEG_YEAR_FLAG
, INTEREST_IN_LOAN_FLAG
, INTEREST_IN_STU_EMPLOY_FLAG
, DRUG_OFFENCE_CONVICT_TYPE
, S_TAX_RETURN_STATUS_TYPE
, S_TYPE_TAX_RETURN_TYPE
, S_ELIG_1040EZ_TYPE
, S_ADJUSTED_GROSS_INCOME_AMT
, S_FED_TAXES_PAID_AMT
, S_EXEMPTIONS_AMT
, S_INCOME_FROM_WORK_AMT
, SPOUSE_INCOME_FROM_WORK_AMT
, S_TOTAL_FROM_WSA_AMT
, S_TOTAL_FROM_WSB_AMT
, S_TOTAL_FROM_WSC_AMT
, S_INVESTMENT_NETWORTH_AMT
, S_BUSI_FARM_NETWORTH_AMT
, S_CASH_SAVINGS_AMT
, VA_MONTHS_NUM
, VA_AMT
, STUD_DOB_BEFORE_YEAR_FLAG
, DEG_BEYOND_BACHELOR_FLAG
, S_MARRIED_FLAG
, S_HAVE_CHILDREN_FLAG
, LEGAL_DEPENDENTS_FLAG
, ORPHAN_WARD_OF_COURT_FLAG
, S_VETERAN_FLAG
, P_MARITAL_STATUS_TYPE
, FATHER_SSN_TXT
, F_LAST_NAME
, MOTHER_SSN_TXT
, M_LAST_NAME
, P_FAMILY_MEMBERS_NUM
, P_IN_COLLEGE_NUM
, P_STATE_LEGAL_RESIDENCE_TXT
, P_LEGAL_RES_BEFORE_DT_FLAG
, P_LEGAL_RES_DATE
, AGE_OLDER_PARENT_NUM
, P_TAX_RETURN_STATUS_TYPE
, P_TYPE_TAX_RETURN_TYPE
, P_ELIG_1040AEZ_TYPE
, P_ADJUSTED_GROSS_INCOME_AMT
, P_TAXES_PAID_AMT
, P_EXEMPTIONS_AMT
, F_INCOME_WORK_AMT
, M_INCOME_WORK_AMT
, P_INCOME_WSA_AMT
, P_INCOME_WSB_AMT
, P_INCOME_WSC_AMT
, P_INVESTMENT_NETWORTH_AMT
, P_BUSINESS_NETWORTH_AMT
, P_CASH_SAVING_AMT
, S_FAMILY_MEMBERS_NUM
, S_IN_COLLEGE_NUM
, FIRST_COLLEGE_CD
, FIRST_HOUSE_PLAN_TYPE
, SECOND_COLLEGE_CD
, SECOND_HOUSE_PLAN_TYPE
, THIRD_COLLEGE_CD
, THIRD_HOUSE_PLAN_TYPE
, FOURTH_COLLEGE_CD
, FOURTH_HOUSE_PLAN_TYPE
, FIFTH_COLLEGE_CD
, FIFTH_HOUSE_PLAN_TYPE
, SIXTH_COLLEGE_CD
, SIXTH_HOUSE_PLAN_TYPE
, APP_COMPLETED_DATE
, SIGNED_BY_TYPE
, PREPARER_SSN_TXT
, PREPARER_EMP_ID_NUMBER_TXT
, PREPARER_SIGN_FLAG
, TRANSACTION_RECEIPT_DATE
, DEPENDENCY_OVERRIDE_TYPE
, FAA_FEDRAL_SCHL_CD
, FAA_ADJUSTMENT_TYPE
, INPUT_RECORD_TYPE
, SERIAL_NUM
, BATCH_NUMBER_TXT
, EARLY_ANALYSIS_FLAG
, APP_ENTRY_SOURCE_TYPE
, ETI_DESTINATION_CD
, REJECT_OVERRIDE_B_FLAG
, REJECT_OVERRIDE_N_FLAG
, REJECT_OVERRIDE_W_FLAG
, ASSUM_OVERRIDE_1_FLAG
, ASSUM_OVERRIDE_2_FLAG
, ASSUM_OVERRIDE_3_FLAG
, ASSUM_OVERRIDE_4_FLAG
, ASSUM_OVERRIDE_5_FLAG
, ASSUM_OVERRIDE_6_FLAG
, DEPENDENCY_STATUS_TYPE
, S_EMAIL_ADDRESS_TXT
, NSLDS_REASON_CD
, APP_RECEIPT_DATE
, PROCESSED_REC_TYPE
, HIST_CORR_FOR_TRAN_NUM
, SYS_GENERATED_INDICATOR_TYPE
, DUP_REQUEST_INDICATOR_TYPE
, SOURCE_OF_CORRECTION_TYPE
, P_CAL_TAX_STATUS_TYPE
, S_CAL_TAX_STATUS_TYPE
, GRADUATE_FLAG
, AUTO_ZERO_EFC_FLAG
, EFC_CHANGE_FLAG
, SARC_FLAG
, SIMPLIFIED_NEED_TEST_FLAG
, REJECT_REASON_CODES_TXT
, SELECT_SERVICE_MATCH_TYPE
, SELECT_SERVICE_REG_TYPE
, INS_MATCH_FLAG
, INS_VERIFICATION_NUM
, SEC_INS_MATCH_TYPE
, SEC_INS_VER_NUM
, SSN_MATCH_TYPE
, SSA_CITIZENSHIP_TYPE
, SSN_DEATH_DATE
, NSLDS_MATCH_TYPE
, VA_MATCH_TYPE
, PRISONER_MATCH_FLAG
, VERIFICATION_FLAG
, SUBSEQUENT_APP_FLAG
, APP_SOURCE_SITE_CD
, TRAN_SOURCE_SITE_CD
, DRN_NUM
, TRAN_PROCESS_DATE
, CORRECTION_FLAGS_TXT
, COMPUTER_BATCH_NUM
, HIGHLIGHT_FLAGS_TXT
, PAID_EFC_AMT
, PRIMARY_EFC_AMT
, SECONDARY_EFC_AMT
, FED_PELL_GRANT_EFC_TYPE
, PRIMARY_EFC_TYPE
, SEC_EFC_TYPE
, PRIMARY_ALT_MONTH_1_AMT
, PRIMARY_ALT_MONTH_2_AMT
, PRIMARY_ALT_MONTH_3_AMT
, PRIMARY_ALT_MONTH_4_AMT
, PRIMARY_ALT_MONTH_5_AMT
, PRIMARY_ALT_MONTH_6_AMT
, PRIMARY_ALT_MONTH_7_AMT
, PRIMARY_ALT_MONTH_8_AMT
, PRIMARY_ALT_MONTH_10_AMT
, PRIMARY_ALT_MONTH_11_AMT
, PRIMARY_ALT_MONTH_12_AMT
, SEC_ALTERNATE_MONTH_1_AMT
, SEC_ALTERNATE_MONTH_2_AMT
, SEC_ALTERNATE_MONTH_3_AMT
, SEC_ALTERNATE_MONTH_4_AMT
, SEC_ALTERNATE_MONTH_5_AMT
, SEC_ALTERNATE_MONTH_6_AMT
, SEC_ALTERNATE_MONTH_7_AMT
, SEC_ALTERNATE_MONTH_8_AMT
, SEC_ALTERNATE_MONTH_10_AMT
, SEC_ALTERNATE_MONTH_11_AMT
, SEC_ALTERNATE_MONTH_12_AMT
, TOTAL_INCOME_AMT
, ALLOW_TOTAL_INCOME_AMT
, STATE_TAX_ALLOW_AMT
, EMPLOYMENT_ALLOW_AMT
, INCOME_PROTECTION_ALLOW_AMT
, AVAILABLE_INCOME_AMT
, CONTRIBUTION_FROM_AI_AMT
, DISCRETIONARY_NETWORTH_AMT
, EFC_NETWORTH_AMT
, ASSET_PROTECT_ALLOW_AMT
, PARENTS_CONT_FROM_ASSETS_AMT
, ADJUSTED_AVAIL_INCOME_AMT
, TOTAL_STUDENT_CONTRIB_AMT
, TOTAL_PARENT_CONTRIB_AMT
, PARENTS_CONTRIBUTION_AMT
, STUDENT_TOTAL_INCOME_AMT
, SATI_AMT
, SIC_AMT
, SDNW_AMT
, SCA_AMT
, FTI_AMT
, SECTI_AMT
, SECATI_AMT
, SECSTX_AMT
, SECEA_AMT
, SECIPA_AMT
, SECAI_AMT
, SECCAI_AMT
, SECDNW_AMT
, SECNW_AMT
, SECAPA_AMT
, SECPCA_AMT
, SECAAI_AMT
, SECTSC_AMT
, SECTPC_AMT
, SECPC_AMT
, SECSTI_AMT
, SECSATI_AMT
, SECSIC_AMT
, SECSDNW_AMT
, SECSCA_AMT
, SECFTI_AMT
, A_CITIZENSHIP_FLAG
, A_STUDNT_MARITAL_STATUS_FLAG
, A_STUDENT_AGI_AMT
, A_S_US_TAX_PAID_AMT
, A_S_INCOME_WORK_AMT
, A_SPOUSE_INCOME_WORK_AMT
, A_S_TOTAL_WSC_AMT
, A_DATE_OF_BIRTH_FLAG
, A_STUDENT_MARRIED_FLAG
, A_HAVE_CHILDREN_FLAG
, A_S_HAVE_DEPENDENTS_FLAG
, A_VA_STATUS_FLAG
, A_S_IN_FAMILY_NUM
, A_S_IN_COLLEGE_NUM
, A_P_MARITAL_STATUS_FLAG
, A_FATHER_SSN_TXT
, A_MOTHER_SSN_TXT
, A_PARENTS_FAMILY_NUM
, A_PARENTS_COLLEGE_NUM
, A_PARENTS_AGI_AMT
, A_P_US_TAX_PAID_AMT
, A_F_WORK_INCOME_AMT
, A_M_WORK_INCOME_AMT
, A_P_TOTAL_WSC_AMT
, COMMENT_CODES_TXT
, SAR_ACK_COMM_CODES_TXT
, PELL_GRANT_ELIG_FLAG
, REPROCESS_REASON_CD
, DUPLICATE_DATE
, ISIR_TRANSACTION_TYPE
, FEDRAL_SCHL_TYPE
, MULTI_SCHOOL_CD_FLAGS_TXT
, DUP_SSN_INDICATOR_FLAG
, NSLDS_TRANSACTION_NUM
, NSLDS_DATABASE_RESULTS_TYPE
, NSLDS_FLAG
, NSLDS_PELL_OVERPAY_TYPE
, NSLDS_PELL_OVERPAY_CONT_TXT
, NSLDS_SEOG_OVERPAY_TYPE
, NSLDS_SEOG_OVERPAY_CONT_TXT
, NSLDS_PERKINS_OVERPAY_TYPE
, NSLDS_PERK_OVRPAY_CNTCT_TXT
, NSLDS_DEFAULTED_LOAN_FLAG
, NSLDS_DISCHARGED_LOAN_TYPE
, NSLDS_SATIS_REPAY_FLAG
, NSLDS_ACT_BANKRUPTCY_FLAG
, NSLDS_AGG_SUBSZ_OUT_PBAL_AMT
, NSLDS_AGG_UNSBZ_OUT_PBAL_AMT
, NSLDS_AGG_COMB_OUT_PBAL_AMT
, NSLDS_AGG_CONS_OUT_PBAL_AMT
, NSLDS_AGG_SUBSZ_PND_DISB_AMT
, NSLDS_AGG_UNSBZ_PND_DISB_AMT
, NSLDS_AGG_COMB_PEND_DISB_AMT
, NSLDS_AGG_SUBSZ_TOTAL_AMT
, NSLDS_AGG_UNSBZ_TOTAL_AMT
, NSLDS_AGG_COMB_TOTAL_AMT
, NSLDS_AGG_CONSD_TOTAL_AMT
, NSLDS_PERKINS_OUT_BAL_AMT
, NSLDS_PERKIN_CUR_YR_DISB_AMT
, NSLDS_DEFAULT_LOAN_CHNG_FLAG
, NSLDS_DISCHGD_LOAN_CHNG_FLAG
, NSLDS_SATIS_REPAY_CHNG_FLAG
, NSLDS_ACT_BNKRUPT_CHNG_FLAG
, NSLDS_OVERPAY_CHNG_FLAG
, NSLDS_AGG_LOAN_CHNG_FLAG
, NSLDS_PERKINS_LOAN_CHNG_FLAG
, NSLDS_PELL_PAYMNT_CHNG_FLAG
, NSLDS_ADDTNL_PELL_FLAG
, NSLDS_ADDTNL_LOAN_FLAG
, DIRECT_LOAN_MAS_PROM_NT_TYPE
, NSLDS_PELL_1_SEQ_NUM
, NSLDS_PELL_1_VERIFY_F_TXT
, NSLDS_PELL_1_EFC_AMT
, NSLDS_PELL_1_SCHOOL_NUM
, NSLDS_PELL_1_TRANSCN_NUM
, NSLDS_PELL_1_LAST_UPDT_DATE
, NSLDS_PELL_1_SCHEDULED_AMT
, NSLDS_PELL_1_PAID_TODT_AMT
, NSLDS_PELL_1_REMNG_AMT
, NSLDS_PELL_1_PC_SCWD_USE_AMT
, NSLDS_PELL_1_AWARD_AMT
, NSLDS_PELL_2_SEQ_NUM
, NSLDS_PELL_2_VERIFY_F_TXT
, NSLDS_PELL_2_EFC_AMT
, NSLDS_PELL_2_SCHOOL_NUM
, NSLDS_PELL_2_TRANSCN_NUM
, NSLDS_PELL_2_LAST_UPDT_DATE
, NSLDS_PELL_2_SCHEDULED_AMT
, NSLDS_PELL_2_PAID_TODT_AMT
, NSLDS_PELL_2_REMNG_AMT
, NSLDS_PELL_2_PC_SCWD_USE_AMT
, NSLDS_PELL_2_AWARD_AMT
, NSLDS_PELL_3_SEQ_NUM
, NSLDS_PELL_3_VERIFY_F_TXT
, NSLDS_PELL_3_EFC_AMT
, NSLDS_PELL_3_SCHOOL_NUM
, NSLDS_PELL_3_TRANSCN_NUM
, NSLDS_PELL_3_LAST_UPDT_DATE
, NSLDS_PELL_3_SCHEDULED_AMT
, NSLDS_PELL_3_PAID_TODT_AMT
, NSLDS_PELL_3_REMNG_AMT
, NSLDS_PELL_3_PC_SCWD_USE_AMT
, NSLDS_PELL_3_AWARD_AMT
, NSLDS_LOAN_1_SEQ_NUM
, NSLDS_LOAN_1_TYPE
, NSLDS_LOAN_1_CHNG_FLAG
, NSLDS_LOAN_1_PROG_CD
, NSLDS_LOAN_1_NET_AMT
, NSLDS_LOAN_1_CUR_ST_CD
, NSLDS_LOAN_1_CUR_ST_DATE
, NSLDS_LOAN_1_AGG_PR_BAL_AMT
, NSLDS_LOAN_1_OUT_PR_BAL_DATE
, NSLDS_LOAN_1_BEGIN_DATE
, NSLDS_LOAN_1_END_DATE
, NSLDS_LOAN_1_GA_CD
, NSLDS_LOAN_1_CONT_TYPE
, NSLDS_LOAN_1_SCHOL_CD
, NSLDS_LOAN_1_CONT_CD
, NSLDS_LOAN_1_GRADE_LVL_TXT
, NSLDS_LOAN_1_X_UNSBZ_LN_TYPE
, NSLDS_LOAN_1_CAPTAL_INT_FLAG
, NSLDS_LOAN_2_SEQ_NUM
, NSLDS_LOAN_2_TYPE
, NSLDS_LOAN_2_CHNG_FLAG
, NSLDS_LOAN_2_PROG_CD
, NSLDS_LOAN_2_NET_AMT
, NSLDS_LOAN_2_CUR_ST_CD
, NSLDS_LOAN_2_CUR_ST_DATE
, NSLDS_LOAN_2_AGG_PR_BAL_AMT
, NSLDS_LOAN_2_OUT_PR_BAL_DATE
, NSLDS_LOAN_2_BEGIN_DATE
, NSLDS_LOAN_2_END_DATE
, NSLDS_LOAN_2_GA_CD
, NSLDS_LOAN_2_CONT_TYPE
, NSLDS_LOAN_2_SCHOL_CD
, NSLDS_LOAN_2_CONT_CD
, NSLDS_LOAN_2_GRADE_LVL_TXT
, NSLDS_LOAN_2_X_UNSBZ_LN_TYPE
, NSLDS_LOAN_2_CAPTAL_INT_FLAG
, NSLDS_LOAN_3_SEQ_NUM
, NSLDS_LOAN_3_TYPE
, NSLDS_LOAN_3_CHNG_FLAG
, NSLDS_LOAN_3_PROG_CD
, NSLDS_LOAN_3_NET_AMT
, NSLDS_LOAN_3_CUR_ST_CD
, NSLDS_LOAN_3_CUR_ST_DATE
, NSLDS_LOAN_3_AGG_PR_BAL_AMT
, NSLDS_LOAN_3_OUT_PR_BAL_DATE
, NSLDS_LOAN_3_BEGIN_DATE
, NSLDS_LOAN_3_END_DATE
, NSLDS_LOAN_3_GA_CD
, NSLDS_LOAN_3_CONT_TYPE
, NSLDS_LOAN_3_SCHOL_CD
, NSLDS_LOAN_3_CONT_CD
, NSLDS_LOAN_3_GRADE_LVL_TXT
, NSLDS_LOAN_3_X_UNSBZ_LN_TYPE
, NSLDS_LOAN_3_CAPTAL_INT_FLAG
, NSLDS_LOAN_4_SEQ_NUM
, NSLDS_LOAN_4_TYPE
, NSLDS_LOAN_4_CHNG_FLAG
, NSLDS_LOAN_4_PROG_CD
, NSLDS_LOAN_4_NET_AMT
, NSLDS_LOAN_4_CUR_ST_CD
, NSLDS_LOAN_4_CUR_ST_DATE
, NSLDS_LOAN_4_AGG_PR_BAL_AMT
, NSLDS_LOAN_4_OUT_PR_BAL_DATE
, NSLDS_LOAN_4_BEGIN_DATE
, NSLDS_LOAN_4_END_DATE
, NSLDS_LOAN_4_GA_CD
, NSLDS_LOAN_4_CONT_TYPE
, NSLDS_LOAN_4_SCHOL_CD
, NSLDS_LOAN_4_CONT_CD
, NSLDS_LOAN_4_GRADE_LVL_TXT
, NSLDS_LOAN_4_X_UNSBZ_LN_TYPE
, NSLDS_LOAN_4_CAPTAL_INT_FLAG
, NSLDS_LOAN_5_SEQ_NUM
, NSLDS_LOAN_5_TYPE
, NSLDS_LOAN_5_CHNG_FLAG
, NSLDS_LOAN_5_PROG_CD
, NSLDS_LOAN_5_NET_AMT
, NSLDS_LOAN_5_CUR_ST_CD
, NSLDS_LOAN_5_CUR_ST_DATE
, NSLDS_LOAN_5_AGG_PR_BAL_AMT
, NSLDS_LOAN_5_OUT_PR_BAL_DATE
, NSLDS_LOAN_5_BEGIN_DATE
, NSLDS_LOAN_5_END_DATE
, NSLDS_LOAN_5_GA_CD
, NSLDS_LOAN_5_CONT_TYPE
, NSLDS_LOAN_5_SCHOL_CD
, NSLDS_LOAN_5_CONT_CD
, NSLDS_LOAN_5_GRADE_LVL_TXT
, NSLDS_LOAN_5_X_UNSBZ_LN_TYPE
, NSLDS_LOAN_5_CAPTAL_INT_FLAG
, NSLDS_LOAN_6_SEQ_NUM
, NSLDS_LOAN_6_TYPE
, NSLDS_LOAN_6_CHNG_FLAG
, NSLDS_LOAN_6_PROG_CD
, NSLDS_LOAN_6_NET_AMT
, NSLDS_LOAN_6_CUR_ST_CD
, NSLDS_LOAN_6_CUR_ST_DATE
, NSLDS_LOAN_6_AGG_PR_BAL_AMT
, NSLDS_LOAN_6_OUT_PR_BAL_DATE
, NSLDS_LOAN_6_BEGIN_DATE
, NSLDS_LOAN_6_END_DATE
, NSLDS_LOAN_6_GA_CD
, NSLDS_LOAN_6_CONT_TYPE
, NSLDS_LOAN_6_SCHOL_CD
, NSLDS_LOAN_6_CONT_CD
, NSLDS_LOAN_6_GRADE_LVL_TXT
, NSLDS_LOAN_6_X_UNSBZ_LN_TYPE
, NSLDS_LOAN_6_CAPTAL_INT_FLAG
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, NSLDS_LOAN_1_LAST_DISB_AMT
, NSLDS_LOAN_1_LAST_DISB_DATE
, NSLDS_LOAN_2_LAST_DISB_AMT
, NSLDS_LOAN_2_LAST_DISB_DATE
, NSLDS_LOAN_3_LAST_DISB_AMT
, NSLDS_LOAN_3_LAST_DISB_DATE
, NSLDS_LOAN_4_LAST_DISB_AMT
, NSLDS_LOAN_4_LAST_DISB_DATE
, NSLDS_LOAN_5_LAST_DISB_AMT
, NSLDS_LOAN_5_LAST_DISB_DATE
, NSLDS_LOAN_6_LAST_DISB_AMT
, NSLDS_LOAN_6_LAST_DISB_DATE
, VERIF_TRACK_TYPE
, FAFSA_DATA_VERIFICATION_TXT
, REJECT_OVERRIDE_A_FLAG
, REJECT_OVERRIDE_C_FLAG
, PARENT_MARITAL_STATUS_DATE
, DLP_MASTER_PROM_NOTE_TYPE
, FATHR_FIRST_NAME_INITIAL_TXT
, FATHR_STEP_FATHER_BIRTH_DATE
, MOTHR_FIRST_NAME_INITIAL_TXT
, MOTHR_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
, RECORD_STATUS
, DATA_FILE_NAME_TXT
, MATCH_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REJECT_OVERRIDE_3_FLAG
, REJECT_OVERRIDE_12_FLAG
, REJECT_OVERRIDE_J_FLAG
, REJECT_OVERRIDE_K_FLAG
, REJECTED_STATUS_CHANGE_FLAG
, VERIFICATION_SELECTION_FLAG
, PARENT_REQ_ID
, SUB_REQ_NUM
FROM IGF.IGF_AP_ISIR_INTS_ALL;
IGF.IGF_AP_ISIR_INTS_ALL does not reference any database object
IGF.IGF_AP_ISIR_INTS_ALL is referenced by following:
APPS
IGF_AP_ISIR_INTS_ALL
|
|
|
|