[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGFFV_ISIRS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGFFV_ISIRS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds the complete ISIR record of the students
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_YEAR | NUMBER | (1) | Yes | Holds batch year |
| TRANSACTION_NUMBER | VARCHAR2 | (2) | Yes | Holds CPS transaction number of ISIR |
| CURRENT_SSN | VARCHAR2 | (9) | Yes | Holds SSN on transaction |
| _LA:SSN_LAST_NAME_CHNGE_FLAG | CHAR | (69) | Indicates whether last name, SSN, or both have been changed | |
| ORIGINAL_SSN | VARCHAR2 | (9) | Holds original SSN as processed by CPS | |
| ORIGINAL_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 | |
| PERMANENT_MAIL_ADDRESS | VARCHAR2 | (35) | Permanent mailing address of applicant student | |
| PERMANENT_CITY | VARCHAR2 | (16) | Permanent city of applicant student | |
| _LA:PERMANENT_STATE | CHAR | (64) | Lookup tag that indicates Permanent state of applicant student | |
| PERMANENT_ZIP_CODE | VARCHAR2 | (5) | Permanent zip code of applicant student | |
| DATE_OF_BIRTH | DATE | Date of birth of applicant student | ||
| PERMANENT_PHONE_NUMBER | VARCHAR2 | (10) | Contact phone number of applicant student | |
| DRIVERS_LICENSE_NUMBER | VARCHAR2 | (20) | Driver's license number of applicant student if applicable | |
| _LA:DRIVERS_LICENSE_STATE | CHAR | (74) | Lookup tag that indicates Driver's license state code of applicant student if applicable | |
| _LA:CITIZENSHIP_STATUS | CHAR | (74) | Lookup tag that indicates Status of student's citizenship | |
| ALIEN_REGISTRATION_NUMBER | VARCHAR2 | (9) | Student's alien registration number | |
| _LA:MARITAL_STATUS | CHAR | (76) | Lookup tag that indicates Student's marital status | |
| MARITAL_STATUS_DATE | DATE | Date on which student's marital status changed to current status | ||
| _LA:SUMMER_ENROLLMENT_STATUS | CHAR | (82) | Lookup tag that indicates Student's enrollment plan for summer term | |
| _LA:FALL_ENROLLMENT_STATUS | CHAR | (70) | Lookup tag that indicates Student's enrollment plan for fall term | |
| _LA:WINTER_ENROLLMENT_STATUS | CHAR | (72) | Lookup tag that indicates Student's enrollment plan for winter term | |
| _LA:SPRING_ENROLLMENT_STATUS | CHAR | (72) | Lookup tag that indicates Student's enrollment plan for spring Term | |
| _LA:SUMMER2_ENROLMENT_STATUS | CHAR | (71) | Lookup tag that indicates Student's enrollment plan for Summer Term | |
| _LA:FATHERS_HIGH_GRADE_LEVEL | CHAR | (83) | Lookup tag that indicates Father's highest education level completed | |
| _LA:MOTHERS_HIGH_GRADE_LEVEL | CHAR | (83) | Lookup tag that indicates Mother's highest education level completed | |
| _LA:STATE_LEGAL_RESIDENCE | CHAR | (77) | Lookup tag that indicates Student's state of legal residence | |
| _LA:LEGAL_RESIDN_BEFORE_DATE | CHAR | (76) | Student legal residence before date ? | |
| LEGAL_RESIDENCE_DATE | DATE | Student's legal residence date | ||
| _LA:ARE_YOU_MALE | CHAR | (60) | Lookup tag that indicates is student a male? | |
| _LA:SELECT_SERVICE_REG_FLAG | CHAR | (70) | Lookup tag for Selective Service to register the student? | |
| _LA:DEGREE_CERTIFICATION | CHAR | (73) | Lookup tag that indicates Student's degree/certificate | |
| _LA:GRADE_LEVEL_IN_COLLEGE | CHAR | (76) | Lookup tag that indicates Student's grade level in college in 2001-2002 | |
| _LA:HS_DIPLOMA_GED_RECEIVED | CHAR | (72) | Lookup tag that indicates Student has received a HS diploma or GED? | |
| _LA:FIRST_BACHELOR_DEG_DATE | CHAR | (75) | Lookup tag that indicates First Bachelor's Degree by 2003-2004? | |
| _LA:INTERESTED_IN_LOANS | CHAR | (65) | Lookup tag that indicates Interested in Student Loan? | |
| _LA:INTERESTED_IN_EMPLOYMENT | CHAR | (76) | Lookup tag that indicates Interested in Student Employment? | |
| _LA:DRUG_OFENCE_CONVICT_ELIG | CHAR | (84) | Lookup tag that indicates Indicates whether student has drug conviction. | |
| _LA:TAX_RETURN_STATUS | CHAR | (76) | Lookup tag that indicates Student's tax return status | |
| _LA:TYPE_OF_TAX_RETURN_FORM | CHAR | (70) | Lookup tag that indicates Student's type of Tax Form used | |
| _LA:ELIGIBLE_TO_FILE_1040EZ | CHAR | (76) | Lookup tag that indicates Is student eligible for 1040A or 1040EZ? | |
| ADJUSTED_IRS_GROSS_INCOME | NUMBER | (12) | Student' s Adjusted Gross Income from IRS Form | |
| FEDERAL_TAXES_PAID | NUMBER | (12) | Student' s U.S. Income Tax paid | |
| EXEMPTIONS_CLAIMED | NUMBER | (2) | Student' s Exemptions claimed | |
| INCOME_EARNED_FROM_WORK | NUMBER | (12) | Student' s Income earned form work | |
| SPOUSE_INCOME_EARN_FROM_WORK | NUMBER | (12) | Spouse's Income earned from work | |
| TOTAL_AMOUNT_FROM_WORKSHEET_A | NUMBER | (12) | Student' s Total amount from Worksheet A | |
| TOTAL_AMOUNT_FROM_WORKSHEET_B | NUMBER | (12) | Student' s Total amount from Worksheet B | |
| TOTAL_AMOUNT_FROM_WORKSHEET_C | NUMBER | (12) | Student' s Total amount from Worksheet C | |
| INVESTMENT_NETWORTH | NUMBER | (12) | Student' s Investment Net Worth | |
| BUSINESS_INVEST_FARM_NETWORTH | NUMBER | (12) | Student' s Business and Investment Farm Net Worth | |
| CASH_SAVINGS_CHECKING | NUMBER | (12) | Student's Cash, Savings and Checking | |
| NUMBER_OF_VETERAN_MONTHS | NUMBER | (2) | Number of Months Veterans Education Benefit Received | |
| MONTHLY_VETERANS_EDU_BENFITS | NUMBER | (15) | Monthly Veteran Education Benefits | |
| _LA:BORN_BEFORE_DATE | CHAR | (69) | Lookup tag that indicates whether student born before 01-01-1980 | |
| _LA:DEGREE_BEYOND_BACHELOR | CHAR | (68) | Lookup tag that indicates Whether student working on a degree beyond 2003-2004 | |
| _LA:IS_STUDENT_MARRIED | CHAR | (58) | Lookup tag that indicates Is student married? | |
| _LA:HAVE_CHILDREN_YOU_SUPORT | CHAR | (64) | Lookup tag that indicates Does student has children | |
| _LA:LEGAL_DEPENDENTS | CHAR | (65) | Lookup tag that indicates Whether student has legal dependents other than children or spouse | |
| _LA:ORPHAN_WARD_OF_COURT | CHAR | (69) | Lookup tag that indicates Is student orphan or ward of court? | |
| _LA:VETERAN_OF_USA_FORCES | CHAR | (58) | Lookup tag that indicates Is student a Veteran of U.S. Armed Forces | |
| _LA:PARENT_MARITAL_STATUS | CHAR | (75) | Lookup tag that indicates Parents' Marital Status | |
| FATHER_SSN | VARCHAR2 | (9) | Father's Social Security Number | |
| FATHER_LAST_NAME | VARCHAR2 | (16) | Father's Last Name | |
| MOTHER_SSN | VARCHAR2 | (9) | Mother's Social Security Number | |
| MOTHER_LAST_NAME | VARCHAR2 | (16) | Mother's Last Name | |
| PARENTS_NUMBER_FAMILY_MEMBERS | NUMBER | (2) | Parents' Number of family members | |
| PARENTS_NUMBER_IN_COLLEGE | NUMBER | (1) | Parents' number in College for the award year in context excluding parents | |
| _LA:PARENTS_ST_LEGL_RESDENCE | CHAR | (77) | Lookup tag that indicates Parents' State of legal Residence | |
| PARENTS_LEGAL_RESID_BEFORE_DT | VARCHAR2 | (2) | Parents' legal residence before specified date for the award year in context. | |
| PARENTS_LEGAL_RESIDENCE_DATE | DATE | Parents' legal Residence Date | ||
| AGE_OF_OLDER_PARENT | NUMBER | (2) | Age of Older parent | |
| _LA:PARENTS_TAX_RETUN_STATUS | CHAR | (76) | Lookup tag that indicates Is parents 'Tax return filled? | |
| _LA:PARENTS_TYPE_TAX_RETURN | CHAR | (70) | Lookup tag that indicates Parents' type of 2000 Tax form used | |
| _LA:PARENTS_ELIGIBLE_1040AEZ | CHAR | (77) | Lookup tag that indicates Are Parents' eligible to file 040A or 1040EZ? | |
| PARENTS_ADJUSTED_GROSS_INCOME | NUMBER | (12) | Parents' Adjusted gross income from IRS form | |
| PARENTS_TAXES_PAID | NUMBER | (12) | Parents' U.S. Income tax paid | |
| PARENTS_EXEMPTIONS_CLAIMED | NUMBER | (2) | Parents' Exemptions claimed | |
| FATHER_INCOME_FROM_WORK | NUMBER | (12) | Father's income earned from work | |
| MOTHER_INCOME_FROM_WORK | NUMBER | (12) | Mother's income earned from work | |
| PARENT_INCOME_FROM_WORKSHEET_A | NUMBER | (12) | Parents' Total amount from Worksheet A | |
| PARENT_INCOME_FROM_WORKSHEET_B | NUMBER | (12) | Parents' Total amount from Worksheet B | |
| PARENT_INCOME_FROM_WORKSHEET_C | NUMBER | (12) | Parents' Total amount from Worksheet C | |
| PPARENT_INVESTMENT_NETWORTH | NUMBER | (12) | Parents' Investment Net Worth | |
| PARENT_BUSINESS_NETWORTH | NUMBER | (12) | Parents' Business and Investment Farm Net Worth | |
| PARENT_CASH_SAVING_CHECKING | NUMBER | (12) | Parents' Cash, Savings and Checking | |
| STUDENT_NUMBER_FAMILY_MEMBERS | NUMBER | (2) | Student's Number of family members | |
| STUDENT_NUMBER_IN_COLLEGE | NUMBER | (1) | Student Number in college 2001-2002 | |
| FEDERAL_1_SCHOOL_CODE | VARCHAR2 | (30) | Federal School code #1 | |
| _LA:FEDERAL_1_HOUSING_PLAN | CHAR | (71) | Lookup tag that indicates Federal School code #1 Housing Plans | |
| FEDERAL_2_SCHOOL_CODE | VARCHAR2 | (30) | Federal School code #2 | |
| _LA:FEDERAL_2_HOUSING_PLAN | CHAR | (72) | Lookup tag that indicates Federal School code #2 Housing Plans | |
| FEDERAL_3_SCHOOL_CODE | VARCHAR2 | (30) | Federal School code #3 | |
| _LA:FEDERAL_3_HOUSING_PLAN | CHAR | (71) | Lookup tag that indicates Federal School code #3 Housing Plans | |
| FEDERAL_4_SCHOOL_CODE | VARCHAR2 | (30) | Federal School code #4 | |
| _LA:FEDERAL_4_HOUSING_PLAN | CHAR | (72) | Lookup tag that indicates Federal School code #4 Housing Plans | |
| FEDERAL_5_SCHOOL_CODE | VARCHAR2 | (30) | Federal School code #5 | |
| _LA:FEDERAL_5_HOUSING_PLAN | CHAR | (71) | Lookup tag that indicates Federal School code #5 Housing Plans | |
| FEDERAL_6_SCHOOL_CODE | VARCHAR2 | (30) | Federal School code #6 | |
| _LA:FEDERAL_6_HOUSING_PLAN | CHAR | (71) | Lookup tag that indicates Federal School code #6 Housing Plans | |
| DATE_APPLICATION_COMPLETED | DATE | Date Application completed | ||
| _LA:SIGNED_BY | CHAR | (58) | Indicates if only by the applicant or only the parent or both signed the transaction | |
| PREPARER_SSN | VARCHAR2 | (9) | Repairer's Social Security Number | |
| PREPARER_EMPLOYEE_ID_NUMBER | VARCHAR2 | (9) | Repairer's Employer Identification Number | |
| PREPARER_SIGNATURE | VARCHAR2 | (1) | Indicates that a prepared signed the transaction | |
| TRANSACTION_RECEIPT_DATE | DATE | Date the transaction was received by the MDE or School or student filled up a web form | ||
| _LA:DEPENDENCY_OVERRIDE_IND | CHAR | (78) | Indicates a dependency Override was requested on this transaction | |
| FAA_FEDRAL_SCHOOL_CODE | VARCHAR2 | (30) | Federal school that requested a dependency override or Adjusted Calculated request | |
| _LA:FAA_ADJUSTMENT | CHAR | (66) | Whether a FAA requested a calculation | |
| _LA:INPUT_RECORD_TYPE | CHAR | (77) | Input Record Type | |
| SERIAL_NUMBER | NUMBER | (15) | Sequential position of the ISIR in the batch, except in SARA files | |
| BATCH_NUMBER | VARCHAR2 | (23) | Batch Number | |
| _LA:EARLY_ANALYSIS_FLAG | CHAR | (81) | Student requesting early admission to institution | |
| APPLICATION_ENTRY_SOURCE_CODE | VARCHAR2 | (30) | Electronic Application Entry Source Code | |
| ETI_DESTINATION_CODE | VARCHAR2 | (7) | TG number assigned by Title IV WAN | |
| REJECT_OVERRIDE_B | VARCHAR2 | (1) | Date of birth since sep.1,1985 | |
| REJECT_OVERRIDE_N | VARCHAR2 | (1) | Missing first or last name | |
| REJECT_OVERRIDE_W | VARCHAR2 | (1) | Questionable no. of family members | |
| ASSUMPTION_1_OVERRIDE | VARCHAR2 | (1) | Parent's no. in college assumed to be 1 when it is more than 6 | |
| ASSUMPTION_2_OVERRIDE | VARCHAR2 | (1) | Parent's AGI assumed equal to sum of father and mother earned income. | |
| ASSUMPTION_3_OVERRIDE | VARCHAR2 | (1) | Student's no. in college assumed to be 1 when it is more than 2 | |
| ASSUMPTION_4_OVERRIDE | VARCHAR2 | (1) | Student's AGI assumed equal to sum of student and spouse earned income. | |
| ASSUMPTION_5_OVERRIDE | VARCHAR2 | (1) | Parent's total from Wks C assumed to be zero. Allow parent's income from Wks C to be less than or equal | |
| ASSUMPTION_6_OVERRIDE | VARCHAR2 | (1) | Student's total from Wks C assumed to be zero. Allow parent's income from Wks C to be less than or equal | |
| _LA:DEPENDENCY_STATUS | CHAR | (70) | Lookup tag that indicates Determined by CPS based on data provided | |
| STUDENT_EMAIL_ADDRESS | VARCHAR2 | (50) | Student's e-mail address | |
| NSLDS_REASON_CODE | VARCHAR2 | (30) | Student's eligibility has changed since initial reasoning | |
| APPLICATION_RECEIPT_DATE | DATE | Date the transaction was received by the MDE or School or student filled up a web form | ||
| PROCESSED_RECORD_TYPE | VARCHAR2 | (30) | Processed Record Type | |
| HIST_CORRECTION_FOR_TRAN_ID | NUMBER | (2) | History correction applied against Transaction Number | |
| SYSTEM_GENERATED_INDICATOR | VARCHAR2 | (30) | Transaction initiated by the CPS with no input from the applicant | |
| DUPLICATE_REQUEST_INDICATOR | VARCHAR2 | (1) | Duplicate Request Number. Indicates this transaction is a result of a duplicate request | |
| SOURCE_OF_CORRECTION | VARCHAR2 | (30) | Source of correction | |
| PARENT_CALCULATED_TAX_STATUS | VARCHAR2 | (30) | CPS determination of tax filling status | |
| STUDENT_CALCULATED_TAX_STATUS | VARCHAR2 | (30) | Student's Calculated 2000 Tax status | |
| GRADUATE_FLAG | VARCHAR2 | (1) | Graduate Flag | |
| AUTOMATIC_ZERO_EFC | VARCHAR2 | (1) | Zero EFC is automatically set if SNT met and taxable income is $12,000 or less | |
| EFC_CHANGE_FLAG | VARCHAR2 | (30) | EFC change flag | |
| SAR_C_FLAG | VARCHAR2 | (1) | SARC flag | |
| SIMPLIFIED_NEEDS_TEST | VARCHAR2 | (1) | Applicant meets certain criteria for tax filling status and income level and is not required to provide | |
| 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 SS Match for applicants who met the criteria to be sent to | |
| SELECT_SERVICE_REGISTR_FLAG | VARCHAR2 | (30) | Selective Service Registration Flag. Results from Student's request to be registered with SS | |
| INS_MATCH_FLAG | VARCHAR2 | (1) | INS Match Flag. Results from INS Match for applicants who met the criteria to be sent to match | |
| INS_VERIFICATION_NUMBER | NUMBER | (15) | Identification number provided b the Immigration and Naturalization Service indicating that primary | |
| SECONDARY_INS_MATCH_FLAG | VARCHAR2 | (1) | Secondary INS Match Flag. Results from INS Match for applicants who were not matched on the initial | |
| SECONDARY_INS_VER_NUMBER | NUMBER | (15) | Identification number provided b the Immigration and Naturalization Service indicating that primary | |
| SSN_MATCH_FLAG | VARCHAR2 | (30) | Results from SSN Match with Social Security Administration | |
| SSA_CITIZENSHIP_FLAG | VARCHAR2 | (30) | Results from citizenship match with SSA | |
| SSN_DATE_OF_DEATH | DATE | Date of death provided for this SSN from Social Security Administration | ||
| NSLDS_MATCH_FLAG | VARCHAR2 | (30) | Results of the NSLDS Match | |
| VA_MATCH_FLAG | VARCHAR2 | (30) | Results of the Veterans Affair Match | |
| PRISONER_MATCH | VARCHAR2 | (30) | Prisoner Match | |
| VERIFICATION_TRACKING_FLAG | VARCHAR2 | (1) | Student is selected for Verification | |
| SUBSEQUENT_APPLICATION_FLAG | VARCHAR2 | (1) | Indicates that an initial or renewal application with the same SSN and name ID as a transaction already exists | |
| APP_DATA_SOURCE_SITE_CODE | VARCHAR2 | (30) | Application Source site code. Indicates the origin of the initial application and the site location | |
| TRANSACTION_SOURCE_SITE_CODE | VARCHAR2 | (30) | Transaction Source Site Code. Indicates the origin of the transaction and the site location | |
| DATA_RELEASE_NUMBER | NUMBER | (4) | Data Release Number (DRN) will only be included when the transaction was initiated at the destination | |
| TRANSACTION_PROCESSED_DATE | DATE | Transaction Processed Date. date that CPS computed this transaction | ||
| CORRECTION_FLAGS | VARCHAR2 | (120) | Correction Flags | |
| COMPUTER_BATCH_NUMBER | NUMBER | (3) | Compute Batch Number | |
| HIGHLIGHT_FLAGS | VARCHAR2 | (120) | Indicates fields highlighted in boldface on the SAR. | |
| PAID_EFC | NUMBER | (12) | Primary or secondary EFC whichever is lower | |
| PRIMARY_EFC | NUMBER | (12) | The primary 9 month EFC calculated. FNT unless SNT met | |
| SECONDARY_EFC | NUMBER | (12) | The secondary 9 month EFC calculated. FNT only if SNT is met and asset information provided | |
| FEDERAL_PELL_GRANT_EFC_TYPE | VARCHAR2 | (1) | Federal Pell Grant paid EFC type | |
| PRIMARY_EFC_TYPE | VARCHAR2 | (30) | Identifies formula type used to calculate the primary EFC | |
| SECONDARY_EFC_TYPE | VARCHAR2 | (1) | Identifies formula type used to calculate the secondary EFC | |
| PRIMARY_ALTERNATE_MONTH_1 | NUMBER | (5) | Primary Alternate Month 1 | |
| PRIMARY_ALTERNATE_MONTH_2 | NUMBER | (5) | Primary Alternate Month 2 | |
| PRIMARY_ALTERNATE_MONTH_3 | NUMBER | (5) | Primary Alternate Month 3 | |
| PRIMARY_ALTERNATE_MONTH_4 | NUMBER | (5) | Primary Alternate Month 4 | |
| PRIMARY_ALTERNATE_MONTH_5 | NUMBER | (5) | Primary Alternate Month 5 | |
| PRIMARY_ALTERNATE_MONTH_6 | NUMBER | (5) | Primary Alternate Month 6 | |
| PRIMARY_ALTERNATE_MONTH_7 | NUMBER | (5) | Primary Alternate Month 7 | |
| PRIMARY_ALTERNATE_MONTH_8 | NUMBER | (5) | Primary Alternate Month 8 | |
| PRIMARY_ALTERNATE_MONTH_10 | NUMBER | (5) | Primary Alternate Month 10 | |
| PRIMARY_ALTERNATE_MONTH_11 | NUMBER | (5) | Primary Alternate Month 11 | |
| PRIMARY_ALTERNATE_MONTH_12 | NUMBER | (5) | Primary Alternate Month 12 | |
| SECONDARY_ALTERNATE_MONTH_1 | NUMBER | (5) | Secondary Alternate Month 1 | |
| SECONDARY_ALTERNATE_MONTH_2 | NUMBER | (5) | Secondary Alternate Month 2 | |
| SECONDARY_ALTERNATE_MONTH_3 | NUMBER | (5) | Secondary Alternate Month 3 | |
| SECONDARY_ALTERNATE_MONTH_4 | NUMBER | (5) | Secondary Alternate Month 4 | |
| SECONDARY_ALTERNATE_MONTH_5 | NUMBER | (5) | Secondary Alternate Month 5 | |
| SECONDARY_ALTERNATE_MONTH_6 | NUMBER | (5) | Secondary Alternate Month 6 | |
| SECONDARY_ALTERNATE_MONTH_7 | NUMBER | (5) | Secondary Alternate Month 7 | |
| SECONDARY_ALTERNATE_MONTH_8 | NUMBER | (5) | Secondary Alternate Month 8 | |
| SECONDARY_ALTERNATE_MONTH_10 | NUMBER | (5) | Secondary Alternate Month 10 | |
| SECONDARY_ALTERNATE_MONTH_11 | NUMBER | (5) | Secondary Alternate Month 11 | |
| SECONDARY_ALTERNATE_MONTH_12 | NUMBER | (5) | Secondary Alternate Month 12 | |
| TOTAL_INCOME | NUMBER | (12) | Total Income | |
| ALLOWANCES_TOTAL_INCOME | NUMBER | (12) | Allowances against Total Income | |
| STATE_AND_OTHER_TAX_ALLOWANCE | NUMBER | (12) | State and other Tax Allowance | |
| EMPLOYMENT_ALLOWANCE | NUMBER | (12) | Employment Allowance | |
| INCOME_PROTECTION_ALLOWANCE | NUMBER | (12) | Income Protection Allowance | |
| AVAILABLE_INCOME | NUMBER | (12) | Available Income | |
| CONTRIBUTION_FROM_AI | NUMBER | (12) | Contribution from Available Income | |
| DISCRETIONARY_NET_WORTH | NUMBER | (12) | Discretionary Net Worth | |
| EFC_NET_WORTH | NUMBER | (12) | EFC Net Worth | |
| ASSET_PROTECT_ALLOWANCE | NUMBER | (12) | Asset Protection Allowance | |
| PARENTS_CONT_FROM_ASSETS | NUMBER | (12) | Parents' Contribution from Assets | |
| ADJUSTED_AVAILABLE_INCOME | NUMBER | (12) | Adjusted Available Income | |
| TOTAL_STUDENT_CONTRIBUTION | NUMBER | (12) | Total student Contribution | |
| TOTAL_PARENT_CONTRIBUTION | NUMBER | (12) | Total Parent Contribution | |
| PARENTS_CONTRIBUTION | NUMBER | (12) | Parents' Contribution | |
| STUDENT_TOTAL_INCOME | NUMBER | (12) | Student's Total Income | |
| STUDENT_ATI | NUMBER | (12) | Students allowance against total income | |
| STU_DEPENDENET_INCOME_CONTIBUT | NUMBER | (12) | Dependent Students Income Contribution | |
| STU_DISCRETIONARY_NET_WORTH | NUMBER | (12) | Students Discretionary Net Worth | |
| STU_CONTRIBUTION_FROM_ASSETS | NUMBER | (12) | Student's contribution from assets | |
| FISAP_TOTAL_INCOME | NUMBER | (12) | FISAP Total Income | |
| SECONDARY_TOTAL_INCOME | NUMBER | (12) | Secondary Total Income | |
| SEC_ALLOW_AGAINST_TOTAL_INCOME | NUMBER | (12) | secondary Allowance against total income | |
| SEC_STATE_TAX_ALLOWANCE | NUMBER | (12) | Secondary State Tax Allowance | |
| SEC_EMPLOYMENT_ALLOWANCE | NUMBER | (12) | Secondary Employment Allowance | |
| SEC_INCOME_PROTECT_ALLOWANCE | NUMBER | (12) | Secondary Income Protection allowance | |
| SEC_AVAILABLE_INCOME | NUMBER | (12) | Secondary Available Income | |
| SEC_CONTR_FROM_AVAIAL_INCOME | NUMBER | (12) | Secondary contribution from Available Income | |
| SEC_DISCRETIONARY_NET_WORTH | NUMBER | (12) | Secondary Discretionary Net worth | |
| SEC_NET_WORTH | NUMBER | (12) | Secondary Net Worth | |
| SEC_ASSET_PROTECT_ALLOWANCE | NUMBER | (12) | Secondary Asset Protection Allowance | |
| SEC_PARENTS_CONT_FROM_ASSETS | NUMBER | (12) | Secondary Parents Contribution from Assets | |
| SEC_ADJUSTED_AVAILABLE_INCOME | NUMBER | (12) | Secondary Available Income | |
| SEC_TOTAL_STUDENT_CONTRIBUTION | NUMBER | (12) | secondary Total Student Contribution | |
| SEC_TOTAL_PARENT_CONTRIBUTION | NUMBER | (12) | Secondary Total Parent Contribution | |
| SEC_PARENTS_CONTRIBUTION | NUMBER | (12) | Secondary Parent Contribution | |
| SEC_STUDENT_TOTAL_INCOME | NUMBER | (12) | Secondary Students Total Income | |
| SEC_STUDENT_ALLOWANCE_ATI | NUMBER | (12) | Secondary Students Allowance against Total Income | |
| SEC_STUD_DEPEN_INCOME_CONTIBUT | NUMBER | (12) | Secondary Student's Dependent Income Contribution | |
| SEC_STUD_DISCRET_NET_WORTH | NUMBER | (12) | Secondary Students Discretionary Net worth | |
| SEC_STUD_CONTRIB_FROM_ASSETS | NUMBER | (12) | Secondary Students Contribution from Assets | |
| SEC_STUD_FISAP_TOTAL_INCOME | NUMBER | (12) | Secondary FISAP Total Income | |
| ASSUMED_CITIZENSHIP | VARCHAR2 | (30) | Assumed Citizenship | |
| ASSUMED_STUDENT_MARITAL_STATUS | VARCHAR2 | (30) | Students assumed marital status | |
| ASSUMED_STUDENT_AGI | NUMBER | (12) | Assumed Students Adjusted Gross Income | |
| ASSUMED_STUDENT_US_TAX_PAID | NUMBER | (12) | Assumed student tax paid | |
| ASSUMED_STUDENT_INCOME_WORK | NUMBER | (12) | Assumed Students income from work | |
| ASSUMED_SPOUSE_INCOME_WORK | NUMBER | (12) | Assumed Spouse income from work | |
| ASSUMED_STUDENT_TOTAL_WSC | NUMBER | (12) | Assumed students income from worksheet C | |
| ASSUMED_DATE_OF_BIRTH | VARCHAR2 | (30) | Assumed Students Date to Birth prior | |
| ASSUMED_STUDENT_MARRIED | VARCHAR2 | (30) | Assumed student is married | |
| ASSUMED_HAVE_CHILDREN | VARCHAR2 | (30) | Assumed do u have children? | |
| ASSUMED_STUDENT_HAVE_DEPENDENT | VARCHAR2 | (30) | Assumed Student have dependents | |
| ASSUMED_VA_STATUS | VARCHAR2 | (30) | Assumed VA Status | |
| ASSUMED_STUDENT_NUM_IN_FAMILY | NUMBER | (2) | Assumed student's number in family | |
| ASSUMED_STUDENT_NUM_IN_COLLEGE | NUMBER | (2) | Assumed student's Number in College | |
| ASSUMED_PARENT_MARITAL_STATUS | VARCHAR2 | (30) | Assumed Parents Marital Status | |
| ASSUMED_FATHER_SSN | VARCHAR2 | (9) | Assumed Father's SSN | |
| ASSUMED_MOTHER_SSN | VARCHAR2 | (9) | Assumed Mother's SSN | |
| ASSUMED_PARENT_NUMBER_FAMILY | NUMBER | (2) | Assumed parents' number in family | |
| ASSUMED_PARENT_NUMBER_COLLEGE | NUMBER | (1) | Assumed parents' number in college | |
| ASSUMED_PARENT_AGI | NUMBER | (12) | Assumed parents' Annual Gross Income | |
| ASSUMED_PARENT_US_TAX_PAID | NUMBER | (12) | Assumed Parents' US tax Paid | |
| ASSUMED_FATHER_WORK_INCOME | NUMBER | (12) | Assumed Father's Earned income from work | |
| ASSUMED_MOTHER_WORK_INCOME | NUMBER | (12) | Assumed Mother's income from work | |
| ASSUMED_PARENT_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_ACKNOWLEDGE_COMMENT_CODES | VARCHAR2 | (20) | SAR Acknowledgment Comment Codes | |
| PELL_GRANT_ELIGIBILITY_FLAG | VARCHAR2 | (30) | Indicates that the transaction has been determined eligible for a federal Pell grant | |
| REPROCESSED_REASON_CODE | VARCHAR2 | (2) | The code to identify why ISIR was reprocessed | |
| DUPLICATE_DATE | DATE | CPS Process date for duplicate transaction requested. | ||
| _LA:ISIR_TRANSACTION_TYPE | CHAR | (80) | Indicates where the transaction was generated from | |
| FEDRAL_SCHOOL_CODE_INDICATOR | VARCHAR2 | (30) | identifies one of the colleges listed in the fields 91,93,95,97,99,101 that caused this transaction to be sent in the ESFN non-resident file. | |
| MULTI_SCHOOL_CODE_FLAGS | VARCHAR2 | (6) | Each byte of this field corresponds to the 6 federal school codes choices. | |
| DUPLICATE_SSN_INDICATOR | VARCHAR2 | (1) | Y when more than one person uses this 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 | |
| VERIFICATION_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 | ||
| _LA:LEGACY_RECORD_FLAG | CHAR | (61) | Indicates weather the record was imported through a legacy process or not | |
| FATHER_STEP_FIRST_NAME_INITIAL | VARCHAR2 | (1) | Father's/Stepfather's First Name Initial | |
| FATHER_STEP_FATHER_BIRTH_DATE | DATE | Father's/Stepfather's Date of Birth | ||
| MOTHER_STEP_FIRST_NAME_INITIAL | 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 | 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_TRANSACT_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. | |
| _LA:REJECT_OVERRIDE_G_FLAG | CHAR | (85) | Reject Override G Flag | |
| _LA:REJECT_OVERRIDE_3_FLAG | CHAR | (85) | Reject Overrides 3 Flag | |
| _LA:REJECT_OVERRIDE_12_FLAG | CHAR | (86) | Reject Overrides 12 Flag | |
| _LA:REJECT_OVERRIDE_J_FLAG | CHAR | (85) | Reject Overrides J Flag | |
| _LA:REJECT_OVERRIDE_K_FLAG | CHAR | (85) | Reject Overrides K Flag | |
| REJECTED_STATUS_CHANGE_FLAG | VARCHAR2 | (1) | Rejected Status change Flag | |
| VERIFICATION_SELECTION_FLAG | VARCHAR2 | (1) | Verification Selection flag | |
| AWARD_YEAR | VARCHAR2 | (10) | Alternate short reference code for identifying a calendar instance | |
| AWARD_YEAR_DESCRIPTION | VARCHAR2 | (30) | Description for the Calendar Instance | |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Unique identification number |
| DATA_FILE_NAME | VARCHAR2 | (30) | Name of Data File used for Importing the ISIR | |
| MESSAGE_CLASS | VARCHAR2 | (30) | Message Class associated with the data file sent by CPS | |
| BASE_ID | NUMBER | (15) | Yes | Unique identifier for student financial aid record |
| ISIR_ID | NUMBER | (15) | Yes | Identifier for ISIR student record |
| CREATED_BY | NUMBER | (15) | Yes | WHO column |
| CREATION_DATE | DATE | Yes | WHO column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | WHO column |
| LAST_UPDATE_DATE | DATE | Yes | WHO column | |
| PERSON_ID | NUMBER | (15) | Yes | Person identifier |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_YEAR
, TRANSACTION_NUMBER
, CURRENT_SSN
, _LA:SSN_LAST_NAME_CHNGE_FLAG
, ORIGINAL_SSN
, ORIGINAL_NAME_ID
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL
, PERMANENT_MAIL_ADDRESS
, PERMANENT_CITY
, _LA:PERMANENT_STATE
, PERMANENT_ZIP_CODE
, DATE_OF_BIRTH
, PERMANENT_PHONE_NUMBER
, DRIVERS_LICENSE_NUMBER
, _LA:DRIVERS_LICENSE_STATE
, _LA:CITIZENSHIP_STATUS
, ALIEN_REGISTRATION_NUMBER
, _LA:MARITAL_STATUS
, MARITAL_STATUS_DATE
, _LA:SUMMER_ENROLLMENT_STATUS
, _LA:FALL_ENROLLMENT_STATUS
, _LA:WINTER_ENROLLMENT_STATUS
, _LA:SPRING_ENROLLMENT_STATUS
, _LA:SUMMER2_ENROLMENT_STATUS
, _LA:FATHERS_HIGH_GRADE_LEVEL
, _LA:MOTHERS_HIGH_GRADE_LEVEL
, _LA:STATE_LEGAL_RESIDENCE
, _LA:LEGAL_RESIDN_BEFORE_DATE
, LEGAL_RESIDENCE_DATE
, _LA:ARE_YOU_MALE
, _LA:SELECT_SERVICE_REG_FLAG
, _LA:DEGREE_CERTIFICATION
, _LA:GRADE_LEVEL_IN_COLLEGE
, _LA:HS_DIPLOMA_GED_RECEIVED
, _LA:FIRST_BACHELOR_DEG_DATE
, _LA:INTERESTED_IN_LOANS
, _LA:INTERESTED_IN_EMPLOYMENT
, _LA:DRUG_OFENCE_CONVICT_ELIG
, _LA:TAX_RETURN_STATUS
, _LA:TYPE_OF_TAX_RETURN_FORM
, _LA:ELIGIBLE_TO_FILE_1040EZ
, ADJUSTED_IRS_GROSS_INCOME
, FEDERAL_TAXES_PAID
, EXEMPTIONS_CLAIMED
, INCOME_EARNED_FROM_WORK
, SPOUSE_INCOME_EARN_FROM_WORK
, TOTAL_AMOUNT_FROM_WORKSHEET_A
, TOTAL_AMOUNT_FROM_WORKSHEET_B
, TOTAL_AMOUNT_FROM_WORKSHEET_C
, INVESTMENT_NETWORTH
, BUSINESS_INVEST_FARM_NETWORTH
, CASH_SAVINGS_CHECKING
, NUMBER_OF_VETERAN_MONTHS
, MONTHLY_VETERANS_EDU_BENFITS
, _LA:BORN_BEFORE_DATE
, _LA:DEGREE_BEYOND_BACHELOR
, _LA:IS_STUDENT_MARRIED
, _LA:HAVE_CHILDREN_YOU_SUPORT
, _LA:LEGAL_DEPENDENTS
, _LA:ORPHAN_WARD_OF_COURT
, _LA:VETERAN_OF_USA_FORCES
, _LA:PARENT_MARITAL_STATUS
, FATHER_SSN
, FATHER_LAST_NAME
, MOTHER_SSN
, MOTHER_LAST_NAME
, PARENTS_NUMBER_FAMILY_MEMBERS
, PARENTS_NUMBER_IN_COLLEGE
, _LA:PARENTS_ST_LEGL_RESDENCE
, PARENTS_LEGAL_RESID_BEFORE_DT
, PARENTS_LEGAL_RESIDENCE_DATE
, AGE_OF_OLDER_PARENT
, _LA:PARENTS_TAX_RETUN_STATUS
, _LA:PARENTS_TYPE_TAX_RETURN
, _LA:PARENTS_ELIGIBLE_1040AEZ
, PARENTS_ADJUSTED_GROSS_INCOME
, PARENTS_TAXES_PAID
, PARENTS_EXEMPTIONS_CLAIMED
, FATHER_INCOME_FROM_WORK
, MOTHER_INCOME_FROM_WORK
, PARENT_INCOME_FROM_WORKSHEET_A
, PARENT_INCOME_FROM_WORKSHEET_B
, PARENT_INCOME_FROM_WORKSHEET_C
, PPARENT_INVESTMENT_NETWORTH
, PARENT_BUSINESS_NETWORTH
, PARENT_CASH_SAVING_CHECKING
, STUDENT_NUMBER_FAMILY_MEMBERS
, STUDENT_NUMBER_IN_COLLEGE
, FEDERAL_1_SCHOOL_CODE
, _LA:FEDERAL_1_HOUSING_PLAN
, FEDERAL_2_SCHOOL_CODE
, _LA:FEDERAL_2_HOUSING_PLAN
, FEDERAL_3_SCHOOL_CODE
, _LA:FEDERAL_3_HOUSING_PLAN
, FEDERAL_4_SCHOOL_CODE
, _LA:FEDERAL_4_HOUSING_PLAN
, FEDERAL_5_SCHOOL_CODE
, _LA:FEDERAL_5_HOUSING_PLAN
, FEDERAL_6_SCHOOL_CODE
, _LA:FEDERAL_6_HOUSING_PLAN
, DATE_APPLICATION_COMPLETED
, _LA:SIGNED_BY
, PREPARER_SSN
, PREPARER_EMPLOYEE_ID_NUMBER
, PREPARER_SIGNATURE
, TRANSACTION_RECEIPT_DATE
, _LA:DEPENDENCY_OVERRIDE_IND
, FAA_FEDRAL_SCHOOL_CODE
, _LA:FAA_ADJUSTMENT
, _LA:INPUT_RECORD_TYPE
, SERIAL_NUMBER
, BATCH_NUMBER
, _LA:EARLY_ANALYSIS_FLAG
, APPLICATION_ENTRY_SOURCE_CODE
, ETI_DESTINATION_CODE
, REJECT_OVERRIDE_B
, REJECT_OVERRIDE_N
, REJECT_OVERRIDE_W
, ASSUMPTION_1_OVERRIDE
, ASSUMPTION_2_OVERRIDE
, ASSUMPTION_3_OVERRIDE
, ASSUMPTION_4_OVERRIDE
, ASSUMPTION_5_OVERRIDE
, ASSUMPTION_6_OVERRIDE
, _LA:DEPENDENCY_STATUS
, STUDENT_EMAIL_ADDRESS
, NSLDS_REASON_CODE
, APPLICATION_RECEIPT_DATE
, PROCESSED_RECORD_TYPE
, HIST_CORRECTION_FOR_TRAN_ID
, SYSTEM_GENERATED_INDICATOR
, DUPLICATE_REQUEST_INDICATOR
, SOURCE_OF_CORRECTION
, PARENT_CALCULATED_TAX_STATUS
, STUDENT_CALCULATED_TAX_STATUS
, GRADUATE_FLAG
, AUTOMATIC_ZERO_EFC
, EFC_CHANGE_FLAG
, SAR_C_FLAG
, SIMPLIFIED_NEEDS_TEST
, REJECT_REASON_CODES
, SELECT_SERVICE_MATCH_FLAG
, SELECT_SERVICE_REGISTR_FLAG
, INS_MATCH_FLAG
, INS_VERIFICATION_NUMBER
, SECONDARY_INS_MATCH_FLAG
, SECONDARY_INS_VER_NUMBER
, SSN_MATCH_FLAG
, SSA_CITIZENSHIP_FLAG
, SSN_DATE_OF_DEATH
, NSLDS_MATCH_FLAG
, VA_MATCH_FLAG
, PRISONER_MATCH
, VERIFICATION_TRACKING_FLAG
, SUBSEQUENT_APPLICATION_FLAG
, APP_DATA_SOURCE_SITE_CODE
, TRANSACTION_SOURCE_SITE_CODE
, DATA_RELEASE_NUMBER
, TRANSACTION_PROCESSED_DATE
, CORRECTION_FLAGS
, COMPUTER_BATCH_NUMBER
, HIGHLIGHT_FLAGS
, PAID_EFC
, PRIMARY_EFC
, SECONDARY_EFC
, FEDERAL_PELL_GRANT_EFC_TYPE
, PRIMARY_EFC_TYPE
, SECONDARY_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
, SECONDARY_ALTERNATE_MONTH_1
, SECONDARY_ALTERNATE_MONTH_2
, SECONDARY_ALTERNATE_MONTH_3
, SECONDARY_ALTERNATE_MONTH_4
, SECONDARY_ALTERNATE_MONTH_5
, SECONDARY_ALTERNATE_MONTH_6
, SECONDARY_ALTERNATE_MONTH_7
, SECONDARY_ALTERNATE_MONTH_8
, SECONDARY_ALTERNATE_MONTH_10
, SECONDARY_ALTERNATE_MONTH_11
, SECONDARY_ALTERNATE_MONTH_12
, TOTAL_INCOME
, ALLOWANCES_TOTAL_INCOME
, STATE_AND_OTHER_TAX_ALLOWANCE
, EMPLOYMENT_ALLOWANCE
, INCOME_PROTECTION_ALLOWANCE
, AVAILABLE_INCOME
, CONTRIBUTION_FROM_AI
, DISCRETIONARY_NET_WORTH
, EFC_NET_WORTH
, ASSET_PROTECT_ALLOWANCE
, PARENTS_CONT_FROM_ASSETS
, ADJUSTED_AVAILABLE_INCOME
, TOTAL_STUDENT_CONTRIBUTION
, TOTAL_PARENT_CONTRIBUTION
, PARENTS_CONTRIBUTION
, STUDENT_TOTAL_INCOME
, STUDENT_ATI
, STU_DEPENDENET_INCOME_CONTIBUT
, STU_DISCRETIONARY_NET_WORTH
, STU_CONTRIBUTION_FROM_ASSETS
, FISAP_TOTAL_INCOME
, SECONDARY_TOTAL_INCOME
, SEC_ALLOW_AGAINST_TOTAL_INCOME
, SEC_STATE_TAX_ALLOWANCE
, SEC_EMPLOYMENT_ALLOWANCE
, SEC_INCOME_PROTECT_ALLOWANCE
, SEC_AVAILABLE_INCOME
, SEC_CONTR_FROM_AVAIAL_INCOME
, SEC_DISCRETIONARY_NET_WORTH
, SEC_NET_WORTH
, SEC_ASSET_PROTECT_ALLOWANCE
, SEC_PARENTS_CONT_FROM_ASSETS
, SEC_ADJUSTED_AVAILABLE_INCOME
, SEC_TOTAL_STUDENT_CONTRIBUTION
, SEC_TOTAL_PARENT_CONTRIBUTION
, SEC_PARENTS_CONTRIBUTION
, SEC_STUDENT_TOTAL_INCOME
, SEC_STUDENT_ALLOWANCE_ATI
, SEC_STUD_DEPEN_INCOME_CONTIBUT
, SEC_STUD_DISCRET_NET_WORTH
, SEC_STUD_CONTRIB_FROM_ASSETS
, SEC_STUD_FISAP_TOTAL_INCOME
, ASSUMED_CITIZENSHIP
, ASSUMED_STUDENT_MARITAL_STATUS
, ASSUMED_STUDENT_AGI
, ASSUMED_STUDENT_US_TAX_PAID
, ASSUMED_STUDENT_INCOME_WORK
, ASSUMED_SPOUSE_INCOME_WORK
, ASSUMED_STUDENT_TOTAL_WSC
, ASSUMED_DATE_OF_BIRTH
, ASSUMED_STUDENT_MARRIED
, ASSUMED_HAVE_CHILDREN
, ASSUMED_STUDENT_HAVE_DEPENDENT
, ASSUMED_VA_STATUS
, ASSUMED_STUDENT_NUM_IN_FAMILY
, ASSUMED_STUDENT_NUM_IN_COLLEGE
, ASSUMED_PARENT_MARITAL_STATUS
, ASSUMED_FATHER_SSN
, ASSUMED_MOTHER_SSN
, ASSUMED_PARENT_NUMBER_FAMILY
, ASSUMED_PARENT_NUMBER_COLLEGE
, ASSUMED_PARENT_AGI
, ASSUMED_PARENT_US_TAX_PAID
, ASSUMED_FATHER_WORK_INCOME
, ASSUMED_MOTHER_WORK_INCOME
, ASSUMED_PARENT_TOTAL_WSC
, COMMENT_CODES
, SAR_ACKNOWLEDGE_COMMENT_CODES
, PELL_GRANT_ELIGIBILITY_FLAG
, REPROCESSED_REASON_CODE
, DUPLICATE_DATE
, _LA:ISIR_TRANSACTION_TYPE
, FEDRAL_SCHOOL_CODE_INDICATOR
, MULTI_SCHOOL_CODE_FLAGS
, DUPLICATE_SSN_INDICATOR
, PAYMENT_ISIR
, RECEIPT_STATUS
, ISIR_RECEIPT_COMPLETED
, SYSTEM_RECORD_TYPE
, VERIFICATION_TRACK_FLAG
, ACTIVE_ISIR
, REJECT_OVERRIDE_A
, FAFSA_DATA_VERIFY_FLAGS
, REJECT_OVERRIDE_C
, PARENT_MARITAL_STATUS_DATE
, _LA:LEGACY_RECORD_FLAG
, FATHER_STEP_FIRST_NAME_INITIAL
, FATHER_STEP_FATHER_BIRTH_DATE
, MOTHER_STEP_FIRST_NAME_INITIAL
, MOTHER_STEP_MOTHER_BIRTH_DATE
, PARENTS_EMAIL_ADDRESS
, ADDRESS_CHANGE_TYPE
, CPS_PUSHED_ISIR_FLAG
, ELECTRONIC_TRANSACT_TYPE
, SAR_C_CHANGE_TYPE
, FATHER_SSN_MATCH_TYPE
, MOTHER_SSN_MATCH_TYPE
, _LA:REJECT_OVERRIDE_G_FLAG
, _LA:REJECT_OVERRIDE_3_FLAG
, _LA:REJECT_OVERRIDE_12_FLAG
, _LA:REJECT_OVERRIDE_J_FLAG
, _LA:REJECT_OVERRIDE_K_FLAG
, REJECTED_STATUS_CHANGE_FLAG
, VERIFICATION_SELECTION_FLAG
, AWARD_YEAR
, AWARD_YEAR_DESCRIPTION
, PERSON_NUMBER
, DATA_FILE_NAME
, MESSAGE_CLASS
, BASE_ID
, ISIR_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, PERSON_ID
FROM APPS.IGFFV_ISIRS;
APPS
HZ_PARTIES
IGF_AP_FA_BASE_REC_ALL
IGF_AP_ISIR_MATCHED_ALL
IGS_CA_INST_ALL
APPS.IGFFV_ISIRS is not referenced by any database object
|
|
|
|