[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_ISIR_MATCHED_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_AP_ISIR_MATCHED_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGF_AP_ISIR_MATCHED_ALL holds the complete ISIR record of the matched students.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_AP_ISIR_MATCHED_ALL_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ISIR_ID
|
| IGF_AP_ISIR_MATCHED_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BASE_ID
TRANSACTION_NUM
|
| IGF_AP_ISIR_MATCHED_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORIGINAL_SSN
ORIG_NAME_ID
SYSTEM_RECORD_TYPE
BATCH_YEAR
|
| IGF_AP_ISIR_MATCHED_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MESSAGE_CLASS_TXT
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ISIR_ID | NUMBER | (15) | Yes | Identifier for ISIR student record |
| BASE_ID | NUMBER | (15) | Yes | Unique identifier for student financial aid record |
| BATCH_YEAR | NUMBER | (1) | Yes | Holds batch year |
| TRANSACTION_NUM | VARCHAR2 | (2) | Yes | Holds CPS transaction number of ISIR |
| CURRENT_SSN | VARCHAR2 | (9) | Yes | Holds student SSN for current ISIR record |
| SSN_NAME_CHANGE | VARCHAR2 | (30) | Indicates if last name, SSN, or both have changed | |
| ORIGINAL_SSN | VARCHAR2 | (9) | Holds original SSN as processed by CPS | |
| ORIG_NAME_ID | VARCHAR2 | (2) | Holds first two letters of last name as on initial application | |
| LAST_NAME | VARCHAR2 | (16) | Last name of applicant student | |
| FIRST_NAME | VARCHAR2 | (12) | Indicates first name of applicant student | |
| MIDDLE_INITIAL | VARCHAR2 | (1) | Middle name of applicant student | |
| PERM_MAIL_ADD | VARCHAR2 | (35) | Permanent mailing address of applicant student | |
| PERM_CITY | VARCHAR2 | (16) | Permanent city of applicant student | |
| PERM_STATE | VARCHAR2 | (2) | Permanent state of applicant student | |
| PERM_ZIP_CODE | VARCHAR2 | (5) | Permanent zip code of applicant student | |
| DATE_OF_BIRTH | DATE | Date of birth of applicant student | ||
| PHONE_NUMBER | VARCHAR2 | (10) | Contact phone number of applicant student | |
| DRIVER_LICENSE_NUMBER | VARCHAR2 | (20) | Driver's license number of applicant student if applicable | |
| DRIVER_LICENSE_STATE | VARCHAR2 | (30) | Driver's license state code of applicant student if applicable | |
| CITIZENSHIP_STATUS | VARCHAR2 | (30) | Status of student's citizenship | |
| ALIEN_REG_NUMBER | VARCHAR2 | (9) | Student's alien registration number | |
| S_MARITAL_STATUS | VARCHAR2 | (30) | Student's marital status | |
| S_MARITAL_STATUS_DATE | DATE | Date on which student's marital status changed to current status | ||
| SUMM_ENRL_STATUS | VARCHAR2 | (30) | Student's enrollment plan for summer term | |
| FALL_ENRL_STATUS | VARCHAR2 | (30) | Student's enrollment plan for fall term | |
| WINTER_ENRL_STATUS | VARCHAR2 | (30) | Student's enrollment plan for winter term | |
| SPRING_ENRL_STATUS | VARCHAR2 | (30) | Student's enrollment plan for spring term | |
| SUMM2_ENRL_STATUS | VARCHAR2 | (30) | Student's enrollment plan for next summer term | |
| FATHERS_HIGHEST_EDU_LEVEL | VARCHAR2 | (1) | Father's highest education level completed | |
| MOTHERS_HIGHEST_EDU_LEVEL | VARCHAR2 | (1) | Mother's highest education level completed | |
| S_STATE_LEGAL_RESIDENCE | VARCHAR2 | (30) | Student's state of legal residence | |
| LEGAL_RESIDENCE_BEFORE_DATE | VARCHAR2 | (2) | 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 | VARCHAR2 | (1) | Indicates whether student is male | |
| SELECTIVE_SERVICE_REG | VARCHAR2 | (1) | Indicates whether Selective Service should register student | |
| DEGREE_CERTIFICATION | VARCHAR2 | (30) | Holds the student's degree or certificate information | |
| GRADE_LEVEL_IN_COLLEGE | VARCHAR2 | (30) | Student's grade level in college in current academic year | |
| HIGH_SCHOOL_DIPLOMA_GED | VARCHAR2 | (1) | Holds student's high school or GED diploma information | |
| FIRST_BACHELOR_DEG_BY_DATE | VARCHAR2 | (1) | Indicates if student will obtain first bachelor's degree within current year | |
| INTEREST_IN_LOAN | VARCHAR2 | (1) | Indicates whether student is interested in student loan | |
| INTEREST_IN_STUD_EMPLOYMENT | VARCHAR2 | (1) | Indicates whether student is interested in student employment | |
| DRUG_OFFENCE_CONVICTION | VARCHAR2 | (30) | Indicates whether student has drug conviction | |
| S_TAX_RETURN_STATUS | VARCHAR2 | (30) | Holds student's tax return status | |
| S_TYPE_TAX_RETURN | VARCHAR2 | (30) | Indicates type of tax form used by student in filing tax returns | |
| S_ELIG_1040EZ | VARCHAR2 | (30) | Indicates whether student is eligible for 1040A or 1040EZ | |
| S_ADJUSTED_GROSS_INCOME | NUMBER | (12) | Holds student's adjusted gross income from IRS Form | |
| S_FED_TAXES_PAID | NUMBER | (12) | Holds amount student paid in U.S. income tax | |
| S_EXEMPTIONS | NUMBER | (2) | Indicates number of tax exemptions claimed by student | |
| S_INCOME_FROM_WORK | NUMBER | (12) | Student' s income earned from work | |
| SPOUSE_INCOME_FROM_WORK | NUMBER | (12) | Spouse's income earned from work | |
| S_TOA_AMT_FROM_WSA | NUMBER | (12) | Student's total amount from Worksheet A | |
| S_TOA_AMT_FROM_WSB | NUMBER | (12) | Student's total amount from Worksheet B | |
| S_TOA_AMT_FROM_WSC | NUMBER | (12) | Student's total amount from Worksheet C | |
| S_INVESTMENT_NETWORTH | NUMBER | (12) | Net worth of investment made by student | |
| S_BUSI_FARM_NETWORTH | NUMBER | (12) | Net worth of student's business and farm | |
| S_CASH_SAVINGS | NUMBER | (12) | Savings available to student | |
| VA_MONTHS | NUMBER | (2) | Indicates number of months student received veterans' education benefit | |
| VA_AMOUNT | NUMBER | (15) | Stores the Monthly Veterans Education Benefits | |
| STUD_DOB_BEFORE_DATE | VARCHAR2 | (1) | Indicates whether student was born before cut-off date set by Department of Education for year | |
| DEG_BEYOND_BACHELOR | VARCHAR2 | (1) | Indicates whether student is working on degree beyond current academic year | |
| S_MARRIED | VARCHAR2 | (1) | Indicates whether student is married | |
| S_HAVE_CHILDREN | VARCHAR2 | (1) | Indicates whether student has children | |
| LEGAL_DEPENDENTS | VARCHAR2 | (1) | Indicates whether student has legal dependents other than children and spouse | |
| ORPHAN_WARD_OF_COURT | VARCHAR2 | (1) | Indicates whether student is orphan or ward of court | |
| S_VETERAN | VARCHAR2 | (1) | Indicates whether student is veteran of U.S. Armed Forces | |
| P_MARITAL_STATUS | VARCHAR2 | (30) | Holds marital status of student's parents | |
| FATHER_SSN | VARCHAR2 | (9) | Holds father's SSN | |
| F_LAST_NAME | VARCHAR2 | (16) | Holds father's last name | |
| MOTHER_SSN | VARCHAR2 | (9) | Holds mother's SSN | |
| M_LAST_NAME | VARCHAR2 | (16) | Holds mother's last name | |
| P_NUM_FAMILY_MEMBER | NUMBER | (2) | Holds number of family members in student's parents' family | |
| P_NUM_IN_COLLEGE | NUMBER | (1) | Holds number of people in parents' family in college in current year. Excludes parents. | |
| P_STATE_LEGAL_RESIDENCE | VARCHAR2 | (30) | Holds parents' state of legal residence | |
| P_STATE_LEGAL_RES_BEFORE_DT | VARCHAR2 | (2) | Parents' legal residence before specific date | |
| P_LEGAL_RES_DATE | DATE | Date on which current state became parents' legal residence | ||
| AGE_OLDER_PARENT | NUMBER | (2) | Holds age of older parent | |
| P_TAX_RETURN_STATUS | VARCHAR2 | (30) | Indicates whether parents' filed tax returns | |
| P_TYPE_TAX_RETURN | VARCHAR2 | (1) | Holds type of tax form used by parents' in filing tax returns | |
| P_ELIG_1040AEZ | VARCHAR2 | (30) | Indicates whether parents are eligible to file 1040A or 1040EZ | |
| P_ADJUSTED_GROSS_INCOME | NUMBER | (12) | Holds parents' adjusted gross income from IRS form | |
| P_TAXES_PAID | NUMBER | (12) | Holds U.S. income tax parents paid | |
| P_EXEMPTIONS | NUMBER | (2) | Holds number of exemptions parents claimed | |
| F_INCOME_WORK | NUMBER | (12) | Holds father's income earned from work | |
| M_INCOME_WORK | NUMBER | (12) | Holds mother's income earned from work | |
| P_INCOME_WSA | NUMBER | (12) | Parents' total amount from Worksheet A | |
| P_INCOME_WSB | NUMBER | (12) | Parents' total amount from Worksheet B | |
| P_INCOME_WSC | NUMBER | (12) | Parents' total amount from Worksheet C | |
| P_INVESTMENT_NETWORTH | NUMBER | (12) | Holds net worth of parent's investments | |
| P_BUSINESS_NETWORTH | NUMBER | (12) | Holds net worth of parents' business and farm | |
| P_CASH_SAVING | NUMBER | (12) | Holds parents' savings information | |
| S_NUM_FAMILY_MEMBERS | NUMBER | (2) | Number of family members in student's family | |
| S_NUM_IN_COLLEGE | NUMBER | (1) | Holds number of people from student's family in college during current year | |
| FIRST_COLLEGE | VARCHAR2 | (30) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
| FIRST_HOUSE_PLAN | VARCHAR2 | (30) | Student's housing plan for first school | |
| SECOND_COLLEGE | VARCHAR2 | (30) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
| SECOND_HOUSE_PLAN | VARCHAR2 | (30) | Student's housing plan for second school | |
| THIRD_COLLEGE | VARCHAR2 | (30) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
| THIRD_HOUSE_PLAN | VARCHAR2 | (30) | Student's housing plan for third school | |
| FOURTH_COLLEGE | VARCHAR2 | (30) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
| FOURTH_HOUSE_PLAN | VARCHAR2 | (30) | Student's housing plan for fourth school | |
| FIFTH_COLLEGE | VARCHAR2 | (30) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
| FIFTH_HOUSE_PLAN | VARCHAR2 | (30) | Student's housing plan for fifth school | |
| SIXTH_COLLEGE | VARCHAR2 | (30) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
| SIXTH_HOUSE_PLAN | VARCHAR2 | (30) | Student's housing plan for sixth school | |
| DATE_APP_COMPLETED | DATE | Indicates date application was completed | ||
| SIGNED_BY | VARCHAR2 | (30) | Indicates if applicant, parent, or both signed FAFSA application | |
| PREPARER_SSN | VARCHAR2 | (9) | Holds SSN of person who prepared application | |
| PREPARER_EMP_ID_NUMBER | VARCHAR2 | (9) | Holds preparer's employer identification number | |
| PREPARER_SIGN | 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_IND | VARCHAR2 | (30) | Indicates dependency override was requested on transaction | |
| FAA_FEDRAL_SCHL_CODE | VARCHAR2 | (30) | Holds information about federal school that requested dependency override or adjusted calculated request | |
| FAA_ADJUSTMENT | VARCHAR2 | (1) | Indicates whether financial aid administrator requested EFC adjustment, and if it was processed | |
| INPUT_RECORD_TYPE | VARCHAR2 | (30) | Indicates type of ISIR record. Values are Initial Application, Correction Application, Duplicate Request, History Correction, or Renewal. | |
| SERIAL_NUMBER | NUMBER | (15) | Sequential position of ISIR in batch, except for SARA files | |
| BATCH_NUMBER | 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_CODE | VARCHAR2 | (30) | Indicates origin of electronic application | |
| ETI_DESTINATION_CODE | VARCHAR2 | (7) | TG number assigned by Title IV WAN | |
| REJECT_OVERRIDE_B | VARCHAR2 | (1) | Indicates rejection override used while processing record. Deals with date of birth. | |
| REJECT_OVERRIDE_N | VARCHAR2 | (1) | Indicates rejection override used while processing record. Deals with missing first or last name. | |
| REJECT_OVERRIDE_W | VARCHAR2 | (1) | Indicates rejection override used while processing record. Deals with questionable number of family members. | |
| ASSUM_OVERRIDE_1 | VARCHAR2 | (1) | Indicates assumption made by CPS while processing student record. States that parent's number of family members in college was assumed to be 1 when it is more than 6. | |
| ASSUM_OVERRIDE_2 | VARCHAR2 | (1) | Indicates assumption made by CPS while processing student record. States that parent's adjusted gross income was assumed to be equal to sum of father and mother earned income. | |
| ASSUM_OVERRIDE_3 | 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 | 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 | VARCHAR2 | (1) | Indicates assumption made by CPS while processing student record. States that parent's total from worksheet C assumed to be zero. Allows parent's income from Worksheet C to be less than or equal to parents' total income. | |
| ASSUM_OVERRIDE_6 | VARCHAR2 | (1) | Student's total from Worksheet C assumed to be zero. Indicates assumptions made by CPS while processing student record. States that student's total from Worksheet C assumed to be zero. Allows parent's income from Worksheet C to be less. | |
| DEPENDENCY_STATUS | VARCHAR2 | (30) | Indicates dependency status as determined by CPS based on data provided by student | |
| S_EMAIL_ADDRESS | VARCHAR2 | (50) | Student's e-mail address | |
| NSLDS_REASON_CODE | VARCHAR2 | (30) | Indicates student's eligibility for loan based on 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 | (30) | Indicates type of application. Values are Initial, Renewal, Correction, History, or Correction or Duplicate. | |
| HIST_CORRECTION_FOR_TRAN_ID | NUMBER | (2) | If record is correction record, indicates transaction number of record that initiated correction. | |
| SYSTEM_GENERATED_INDICATOR | VARCHAR2 | (30) | Indicates transaction was initiated by CPS with no input from applicant | |
| DUP_REQUEST_INDICATOR | VARCHAR2 | (1) | Indicates transaction is result of duplicate request | |
| SOURCE_OF_CORRECTION | VARCHAR2 | (30) | Indicates source of correction. Values are Applicant, CPS, or School. | |
| P_CAL_TAX_STATUS | VARCHAR2 | (30) | Indicates tax filing status as determined by CPS | |
| S_CAL_TAX_STATUS | VARCHAR2 | (30) | Indicates student's tax status as determined by CPS | |
| GRADUATE_FLAG | VARCHAR2 | (1) | Indicates student is graduate | |
| AUTO_ZERO_EFC | VARCHAR2 | (1) | Indicates 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 | (30) | 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 | VARCHAR2 | (1) | Indicates applicant meets certain criteria for tax filing status and income level, and is not required to provide asset information | |
| REJECT_REASON_CODES | VARCHAR2 | (14) | Indicates why an application or correction has been rejected | |
| SELECT_SERVICE_MATCH_FLAG | VARCHAR2 | (30) | Selective Service match flag. Results from Selective Service match for applicants who met criteria to be sent to match. | |
| SELECT_SERVICE_REG_FLAG | VARCHAR2 | (30) | 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_NUMBER | NUMBER | (15) | Identification number provided by Immigration and Naturalization Service indicating primary verification was performed - No longer used | |
| SEC_INS_MATCH_FLAG | VARCHAR2 | (1) | Results from Immigration and Naturalization Service match for applicants who were not matched on initial match | |
| SEC_INS_VER_NUMBER | NUMBER | (15) | Identification number provided by Immigration and Naturalization Service indicating secondary verification was performed | |
| SSN_MATCH_FLAG | VARCHAR2 | (30) | Results from SSN match with Social Security Administration | |
| SSA_CITIZENSHIP_FLAG | VARCHAR2 | (30) | Results from citizenship match with Social Security Administration | |
| SSN_DATE_OF_DEATH | DATE | Date of death provided for SSN from Social Security Administration | ||
| NSLDS_MATCH_FLAG | VARCHAR2 | (30) | Results of NSLDS match | |
| VA_MATCH_FLAG | VARCHAR2 | (30) | Results of Veterans Affairs match | |
| PRISONER_MATCH | VARCHAR2 | (30) | 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_CODE | VARCHAR2 | (30) | Application source site code indicates origin of initial application and site location | |
| TRAN_SOURCE_SITE_CODE | VARCHAR2 | (30) | Indicates origin of transaction and site location | |
| DRN | NUMBER | (4) | Included only when transaction was initiated at destination point | |
| TRAN_PROCESS_DATE | DATE | Indicates date CPS computed transaction | ||
| CORRECTION_FLAGS | VARCHAR2 | (120) | Indicates correction done to specific SAR field. Each correction flag corresponds to specific SAR field. | |
| COMPUTER_BATCH_NUMBER | NUMBER | (3) | Indicates batch number of transaction | |
| HIGHLIGHT_FLAGS | VARCHAR2 | (120) | Indicates fields highlighted in boldface on SAR | |
| PAID_EFC | NUMBER | (12) | Holds lower of primary or secondary EFC | |
| PRIMARY_EFC | NUMBER | (12) | Primary 9 month EFC calculated for student based on SAR information provided by student | |
| SECONDARY_EFC | NUMBER | (12) | 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 | (30) | Identifies formula type used to calculate primary EFC | |
| SEC_EFC_TYPE | VARCHAR2 | (1) | Identifies formula type used to calculate secondary EFC | |
| PRIMARY_ALTERNATE_MONTH_1 | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALTERNATE_MONTH_2 | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALTERNATE_MONTH_3 | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALTERNATE_MONTH_4 | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALTERNATE_MONTH_5 | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALTERNATE_MONTH_6 | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALTERNATE_MONTH_7 | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALTERNATE_MONTH_8 | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALTERNATE_MONTH_10 | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALTERNATE_MONTH_11 | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| PRIMARY_ALTERNATE_MONTH_12 | NUMBER | (5) | Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_1 | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_2 | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_3 | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_4 | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_5 | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_6 | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_7 | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_8 | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_10 | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_11 | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| SEC_ALTERNATE_MONTH_12 | NUMBER | (5) | Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months | |
| TOTAL_INCOME | NUMBER | (12) | Student's total income | |
| ALLOW_TOTAL_INCOME | NUMBER | (12) | Allowances against total income | |
| STATE_TAX_ALLOW | NUMBER | (12) | State and other tax allowance student received | |
| EMPLOYMENT_ALLOW | NUMBER | (12) | Employment allowance student received | |
| INCOME_PROTECTION_ALLOW | NUMBER | (12) | Income protection allowance student received | |
| AVAILABLE_INCOME | NUMBER | (12) | Available income as calculated for student | |
| CONTRIBUTION_FROM_AI | NUMBER | (12) | Student's contribution from available income | |
| DISCRETIONARY_NETWORTH | NUMBER | (12) | Student's discretionary net worth | |
| EFC_NETWORTH | NUMBER | (12) | EFC net worth as calculated by CPS | |
| ASSET_PROTECT_ALLOW | NUMBER | (12) | Asset protection allowance calculated on student's assets | |
| PARENTS_CONT_FROM_ASSETS | NUMBER | (12) | Parents' contribution from assets as calculated by CPS | |
| ADJUSTED_AVAILABLE_INCOME | NUMBER | (12) | Adjusted available income as calculated by CPS | |
| TOTAL_STUDENT_CONTRIBUTION | NUMBER | (12) | Total student contribution as calculated by CPS | |
| TOTAL_PARENT_CONTRIBUTION | NUMBER | (12) | Total parent contribution as calculated by CPS based on financial information provided by student | |
| PARENTS_CONTRIBUTION | NUMBER | (12) | Parents' contribution as calculated by CPS based on financial information provided by student on FAFSA | |
| STUDENT_TOTAL_INCOME | NUMBER | (12) | Student's total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SATI | NUMBER | (12) | Student's allowance against total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SIC | NUMBER | (12) | Dependent student's income contribution as calculated by CPS based on financial information provided by student on FAFSA | |
| SDNW | NUMBER | (12) | Student's discretionary net worth as calculated by CPS based on financial information provided by student on FAFSA | |
| SCA | NUMBER | (12) | Student's contribution from assets as calculated by CPS based on financial information provided by student on FAFSA | |
| FTI | NUMBER | (12) | FISAP total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECTI | NUMBER | (12) | Secondary total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECATI | NUMBER | (12) | Secondary allowance against total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECSTX | NUMBER | (12) | Secondary state tax allowance as calculated by CPS based on financial information provided by student on FAFSA | |
| SECEA | NUMBER | (12) | Secondary employment allowance as calculated by CPS based on financial information provided by student on FAFSA | |
| SECIPA | NUMBER | (12) | Secondary income protection allowance as calculated by CPS based on financial information provided by student on FAFSA | |
| SECAI | NUMBER | (12) | Secondary available income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECCAI | NUMBER | (12) | Secondary contribution from Available Income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECDNW | NUMBER | (12) | Secondary discretionary net worth as calculated by CPS based on financial information provided by student on FAFSA | |
| SECNW | NUMBER | (12) | Secondary net worth as calculated by CPS based on financial information provided by student on FAFSA | |
| SECAPA | NUMBER | (12) | Secondary asset protection allowance as calculated by CPS based on financial information provided by student on FAFSA | |
| SECPCA | NUMBER | (12) | Secondary parents' contribution from assets as calculated by CPS based on financial information provided by student on FAFSA | |
| SECAAI | NUMBER | (12) | Secondary adjusted available income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECTSC | NUMBER | (12) | Secondary total student contribution as calculated by CPS based on financial information provided by student on FAFSA | |
| SECTPC | NUMBER | (12) | Secondary total parent contribution as calculated by CPS based on financial information provided by student on FAFSA | |
| SECPC | NUMBER | (12) | Secondary parent contribution as calculated by CPS based on financial information provided by student on FAFSA | |
| SECSTI | NUMBER | (12) | Secondary student's total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECSATI | NUMBER | (12) | Secondary student's allowance against total income as calculated by CPS based on financial information provided by student on FAFSA | |
| SECSIC | NUMBER | (12) | Secondary student's dependent income contribution as calculated by CPS based on financial information provided by student on FAFSA | |
| SECSDNW | NUMBER | (12) | Secondary student's discretionary net worth as calculated by CPS based on financial information provided by student on FAFSA | |
| SECSCA | NUMBER | (12) | Secondary student's contribution from assets as calculated by CPS based on financial information provided by student on FAFSA | |
| SECFTI | NUMBER | (12) | Secondary FISAP total income as calculated by CPS based on financial information provided by student on FAFSA | |
| A_CITIZENSHIP | VARCHAR2 | (30) | Citizenship status assumed for student while processing FAFSA application | |
| A_STUDENT_MARITAL_STATUS | VARCHAR2 | (30) | Marital status assumed for student while processing FAFSA application | |
| A_STUDENT_AGI | NUMBER | (12) | Adjusted gross income assumed for student while processing application | |
| A_S_US_TAX_PAID | NUMBER | (12) | Assumed US tax student paid | |
| A_S_INCOME_WORK | NUMBER | (12) | Student's income from work assumed for processing | |
| A_SPOUSE_INCOME_WORK | NUMBER | (12) | Spouse's income from work assumed for processing | |
| A_S_TOTAL_WSC | NUMBER | (12) | Student's income from Worksheet C assumed for processing | |
| A_DATE_OF_BIRTH | VARCHAR2 | (30) | Indicates whether student's date of birth was assumed to be prior to cut-off date | |
| A_STUDENT_MARRIED | VARCHAR2 | (30) | Indicates whether student was assumed to be married | |
| A_HAVE_CHILDREN | VARCHAR2 | (30) | Indicates whether student was assumed to have children to support | |
| A_S_HAVE_DEPENDENTS | VARCHAR2 | (30) | Indicates whether student is assumed to have dependents other than children while processing student FAFSA application | |
| A_VA_STATUS | VARCHAR2 | (30) | Indicates assumed veteran status | |
| A_S_NUM_IN_FAMILY | NUMBER | (2) | Assumed number of people in students' family while processing | |
| A_S_NUM_IN_COLLEGE | NUMBER | (2) | Assumed number of student's family members in college | |
| A_P_MARITAL_STATUS | VARCHAR2 | (30) | Assumed marital status of parents | |
| A_FATHER_SSN | VARCHAR2 | (9) | Father's assumed SSN | |
| A_MOTHER_SSN | VARCHAR2 | (9) | Mother's assumed SSN | |
| A_PARENTS_NUM_FAMILY | NUMBER | (2) | Assumed number of family members in parents' family | |
| A_PARENTS_NUM_COLLEGE | NUMBER | (1) | Assumed number of family members in college from parents' family | |
| A_PARENTS_AGI | NUMBER | (12) | Assumed parents' annual gross income for application processing | |
| A_P_US_TAX_PAID | NUMBER | (12) | Assumed US tax parents paid | |
| A_F_WORK_INCOME | NUMBER | (12) | Assumed father's income earned from work | |
| A_M_WORK_INCOME | NUMBER | (12) | Assumed mother's income from work | |
| A_P_TOTAL_WSC | NUMBER | (12) | Assumed parents' total from Worksheet C | |
| COMMENT_CODES | VARCHAR2 | (60) | Comments provided by CPS to further communicate important results and processing information | |
| SAR_ACK_COMM_CODE | VARCHAR2 | (20) | SAR acknowledgment comment codes. Ten 2-digit codes for comments appearing on Student Aid Report. Codes are entered from left to right by CPS, and unused positions are filled with zeros. | |
| PELL_GRANT_ELIG_FLAG | VARCHAR2 | (30) | Indicates that transaction has been determined eligible for federal Pell grant | |
| REPROCESS_REASON_CODE | VARCHAR2 | (2) | Code to identify why ISIR was reprocessed by CPS. CPS releases definition of codes. | |
| DUPLICATE_DATE | DATE | CPS process date for duplicate transaction requested | ||
| ISIR_TRANSACTION_TYPE | VARCHAR2 | (30) | Indicates from where transaction was generated. Values are Initial Application, Automatic ISIR, Correction, Duplicate Request, or Renewal Application. | |
| FEDRAL_SCHL_CODE_INDICATOR | VARCHAR2 | (30) | Identifies one of colleges that initiated electronic action to create transaction | |
| MULTI_SCHOOL_CODE_FLAGS | VARCHAR2 | (6) | Each byte of field corresponds to 6 federal school codes choices. | |
| DUP_SSN_INDICATOR | VARCHAR2 | (1) | Indicates if another filer is using original SSN in original SSN field. Set to Y when more than one person uses SSN. | |
| PAYMENT_ISIR | VARCHAR2 | (1) | Identifies whether current ISIR student is identified as payment ISIR | |
| RECEIPT_STATUS | VARCHAR2 | (10) | Identifies old record from new one | |
| ISIR_RECEIPT_COMPLETED | VARCHAR2 | (1) | Flag to denote import process was completed | |
| SYSTEM_RECORD_TYPE | VARCHAR2 | (30) | Indicates whether the record is original record or correction record. | |
| 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 | |
| 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 | ||
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| VERIF_TRACK_FLAG | VARCHAR2 | (30) | Verification Tracking Flag | |
| ACTIVE_ISIR | VARCHAR2 | (30) | Indicates the ISIR is the Active ISIR | |
| REJECT_OVERRIDE_A | VARCHAR2 | (30) | Indicates the Reject Override A status | |
| FAFSA_DATA_VERIFY_FLAGS | VARCHAR2 | (255) | Stores FAFSA data verification related flags | |
| REJECT_OVERRIDE_C | VARCHAR2 | (30) | Indicates the Reject override C status | |
| PARENT_MARITAL_STATUS_DATE | DATE | Stores the parents martial status date | ||
| LEGACY_RECORD_FLAG | VARCHAR2 | (1) | Indicates weather the record was imported through a legacy process or not | |
| 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. | |
| 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. | |
| DATA_FILE_NAME_TXT | VARCHAR2 | (30) | Name of Data File used for Importing the ISIR | |
| MESSAGE_CLASS_TXT | VARCHAR2 | (30) | Message Class associated with the data file sent by CPS | |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT ISIR_ID
, BASE_ID
, BATCH_YEAR
, TRANSACTION_NUM
, CURRENT_SSN
, SSN_NAME_CHANGE
, ORIGINAL_SSN
, ORIG_NAME_ID
, 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
, PAYMENT_ISIR
, RECEIPT_STATUS
, ISIR_RECEIPT_COMPLETED
, SYSTEM_RECORD_TYPE
, 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
, VERIF_TRACK_FLAG
, ACTIVE_ISIR
, REJECT_OVERRIDE_A
, FAFSA_DATA_VERIFY_FLAGS
, REJECT_OVERRIDE_C
, PARENT_MARITAL_STATUS_DATE
, LEGACY_RECORD_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
, REJECT_OVERRIDE_G_FLAG
, DHS_VERIFICATION_NUM_TXT
, DATA_FILE_NAME_TXT
, MESSAGE_CLASS_TXT
, REJECT_OVERRIDE_3_FLAG
, REJECT_OVERRIDE_12_FLAG
, REJECT_OVERRIDE_J_FLAG
, REJECT_OVERRIDE_K_FLAG
, REJECTED_STATUS_CHANGE_FLAG
, VERIFICATION_SELECTION_FLAG
FROM IGF.IGF_AP_ISIR_MATCHED_ALL;
IGF.IGF_AP_ISIR_MATCHED_ALL does not reference any database object
IGF.IGF_AP_ISIR_MATCHED_ALL is referenced by following:
APPS
IGF_AP_ISIR_MATCHED_ALL
|
|
|
|