[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_LI_ISIR_INTS |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_AP_LI_ISIR_INTS
|
| Subobject Name: | |
| Status: | VALID |
Interface table used to import ISIR data into the system
Scope: public
Product: IGF
Lifecycle: active
Display Name: Legacy - ISIR Import Process using Legacy Interface Tables
Category: BUSINESS_ENTITY IGF_ISIR
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_AP_LI_ISIR_INTS_PK | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 ISRINT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_NUM | NUMBER | (15) | Yes | Batch Identifier, used to identify the set of records to be processed. |
| ISRINT_ID | NUMBER | Yes | Uniquely identify each record in the interface table. | |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Identifier for student |
| BATCH_YEAR_NUM | NUMBER | (1) | 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_NUM | NUMBER | (9) | Holds original SSN as processed by CPS - No Longer Used | |
| ORIG_NAME_ID_TXT | VARCHAR2 | (2) | Holds first two letters of last name as on initial application | |
| CURRENT_SSN_NUM | NUMBER | (9) | Holds SSN on transaction- No Longer Used | |
| LAST_NAME | VARCHAR2 | (16) | Last name of applicant student | |
| FIRST_NAME | VARCHAR2 | (12) | 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 Summer Term | |
| FATHERS_HIGHEST_EDU_LEVEL_TYPE | VARCHAR2 | (1) | Father's highest education level completed | |
| MOTHERS_HIGHEST_EDU_LEVEL_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 legal residence before 01-01-1998 ? | |
| S_LEGAL_RESD_DATE | DATE | Student's legal residence date | ||
| SS_R_U_MALE_FLAG | VARCHAR2 | (1) | Is student a male? | |
| SELECTIVE_SERVICE_REG_FLAG | VARCHAR2 | (1) | Should Selective Service to register the student? | |
| DEGREE_CERTIFICATION_TYPE | VARCHAR2 | (1) | Student's degree/certificate | |
| GRADE_LEVEL_IN_COLLEGE_TYPE | VARCHAR2 | (1) | Student's grade level in college in 2001-2002 | |
| HIGH_SCHOOL_DIPLOMA_GED_FLAG | VARCHAR2 | (1) | Student has received a HS diploma or GED? | |
| FIRST_BACHELOR_DEG_YEAR_FLAG | VARCHAR2 | (1) | First Bachelor's Degree by 2003-2004? | |
| INTEREST_IN_LOAN_FLAG | VARCHAR2 | (1) | Interested in Student Loan? | |
| INTEREST_IN_STU_EMPLOYMNT_FLAG | VARCHAR2 | (1) | Interested in Student Employment? | |
| DRUG_OFFENCE_CONVICTION_TYPE | VARCHAR2 | (1) | Indicates whether student has drug conviction. | |
| S_TAX_RETURN_STATUS_TYPE | VARCHAR2 | (1) | Student's tax return status | |
| S_TYPE_TAX_RETURN_TYPE | VARCHAR2 | (1) | Student's type of Tax Form used | |
| S_ELIG_1040EZ_TYPE | VARCHAR2 | (1) | Is student eligible for 1040A or 1040EZ? | |
| S_ADJUSTED_GROSS_INCOME_AMT | NUMBER | (6) | Student' s Adjusted Gross Income from IRS Form | |
| S_FED_TAXES_PAID_AMT | NUMBER | (5) | Student' s U.S. Income Tax paid | |
| S_EXEMPTIONS_AMT | NUMBER | (2) | Student' s Exemptions claimed | |
| S_INCOME_FROM_WORK_AMT | NUMBER | (6) | Student' s Income earned form 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) | Student' s Investment Net Worth | |
| S_BUSI_FARM_NETWORTH_AMT | NUMBER | (6) | Student' s Business and Investment Farm Net Worth | |
| S_CASH_SAVINGS_AMT | NUMBER | (6) | Student's Cash, Savings and Checking | |
| VA_MONTHS_NUM | NUMBER | (2) | Number of Months Veterans Education Benefit Received | |
| VA_AMT | NUMBER | (15) | Monthly Veteran Education Benefits | |
| STUD_DOB_BEFORE_YEAR_FLAG | VARCHAR2 | (1) | whether student born before 01-01-1980 | |
| DEG_BEYOND_BACHELOR_FLAG | VARCHAR2 | (1) | Whether student working on a degree beyond 2003-2004 | |
| S_MARRIED_FLAG | VARCHAR2 | (1) | Is student married? | |
| S_HAVE_CHILDREN_FLAG | VARCHAR2 | (1) | Does student has children | |
| LEGAL_DEPENDENTS_FLAG | VARCHAR2 | (1) | Whether student has legal dependents other than children or spouse | |
| ORPHAN_WARD_OF_COURT_FLAG | VARCHAR2 | (1) | Is student orphan or ward of court? | |
| S_VETERAN_FLAG | VARCHAR2 | (1) | Is student a Veteran of U.S. Armed Forces | |
| P_MARITAL_STATUS_TYPE | VARCHAR2 | (1) | Parents' Marital Status | |
| FATHER_SSN_NUM | NUMBER | (9) | Father's Social Security Number- No Longer Used | |
| F_LAST_NAME | VARCHAR2 | (16) | Father's Last Name | |
| MOTHER_SSN_NUM | NUMBER | (9) | Mother's Social Security Number- No Longer Used | |
| M_LAST_NAME | VARCHAR2 | (16) | Mother's Last Name | |
| P_FAMILY_MEMBERS_NUM | NUMBER | (2) | Parents' Number of family members | |
| P_IN_COLLEGE_NUM | NUMBER | (1) | Parents' number in College for the award year in context excluding parents | |
| P_STATE_LEGAL_RESIDENCE_TXT | VARCHAR2 | (2) | Parents' State of legal Residence | |
| P_LEGAL_RES_BEFORE_DT_FLAG | VARCHAR2 | (1) | Parents' legal residence before specified date for the award year in context. | |
| P_LEGAL_RES_DATE | DATE | Parents' legal Residence Date | ||
| AGE_OLDER_PARENT_NUM | NUMBER | (2) | Age of Older parent | |
| P_TAX_RETURN_STATUS_TYPE | VARCHAR2 | (1) | Is parents 'Tax return filled? | |
| P_TYPE_TAX_RETURN_TYPE | VARCHAR2 | (1) | Parents' type of 2000 Tax form used | |
| P_ELIG_1040AEZ_TYPE | VARCHAR2 | (1) | Are Parents' eligible to file 040A or 1040EZ? | |
| P_ADJUSTED_GROSS_INCOME_AMT | NUMBER | (6) | Parents' Adjusted gross income from IRS form | |
| P_TAXES_PAID_AMT | NUMBER | (6) | Parents' U.S. Income tax paid | |
| P_EXEMPTIONS_AMT | NUMBER | (2) | Parents' Exemptions claimed | |
| F_INCOME_WORK_AMT | NUMBER | (6) | Father's income earned from work | |
| M_INCOME_WORK_AMT | NUMBER | (6) | 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) | Parents' Investment Net Worth | |
| P_BUSINESS_NETWORTH_AMT | NUMBER | (6) | Parents' Business and Investment Farm Net Worth | |
| P_CASH_SAVING_AMT | NUMBER | (6) | Parents' Cash, Savings and Checking | |
| S_FAMILY_MEMBERS_NUM | NUMBER | (2) | Student's Number of family members | |
| S_IN_COLLEGE_NUM | NUMBER | (1) | Student Number in college 2001-2002 | |
| FIRST_COLLEGE_CD | VARCHAR2 | (6) | Federal School code #1 | |
| FIRST_HOUSE_PLAN_TYPE | VARCHAR2 | (1) | Federal School code #1 Housing Plans | |
| SECOND_COLLEGE_CD | VARCHAR2 | (6) | Federal School code #2 | |
| SECOND_HOUSE_PLAN_TYPE | VARCHAR2 | (1) | Federal School code #2 Housing Plans | |
| THIRD_COLLEGE_CD | VARCHAR2 | (6) | Federal School code #3 | |
| THIRD_HOUSE_PLAN_TYPE | VARCHAR2 | (1) | Federal School code #3 Housing Plans | |
| FOURTH_COLLEGE_CD | VARCHAR2 | (6) | Federal School code #4 | |
| FOURTH_HOUSE_PLAN_TYPE | VARCHAR2 | (1) | Federal School code #4 Housing Plans | |
| FIFTH_COLLEGE_CD | VARCHAR2 | (6) | Federal School code #5 | |
| FIFTH_HOUSE_PLAN_TYPE | VARCHAR2 | (1) | Federal School code #5 Housing Plans | |
| SIXTH_COLLEGE_CD | VARCHAR2 | (6) | Federal School code #6 | |
| SIXTH_HOUSE_PLAN_TYPE | VARCHAR2 | (1) | Federal School code #6 Housing Plans | |
| APP_COMPLETED_DATE | DATE | Date Application completed | ||
| SIGNED_BY_TYPE | VARCHAR2 | (1) | Indicates if only by the applicant or only the parent or both signed the transaction | |
| PREPARER_SSN_NUM | NUMBER | (9) | Preparer's Social Security Number - No Longer Used | |
| PREPARER_EMP_ID_NUMBER_TXT | VARCHAR2 | (9) | Preparer's Employer Identification Number | |
| PREPARER_SIGN_FLAG | VARCHAR2 | (1) | Indicates that a preparer signed the transaction | |
| TRANSACTION_RECEIPT_DATE | DATE | Date the transaction was received by the MDE or School or student filled up a web form | ||
| DEPENDENCY_OVERRIDE_TYPE | VARCHAR2 | (1) | Indicates a dependency Override was requested on this transaction | |
| FAA_FEDRAL_SCHL_CD | VARCHAR2 | (6) | Federal school that requested a dependency override or Adjusted Calculated request | |
| FAA_ADJUSTMENT_TYPE | VARCHAR2 | (1) | Whether a FAA requested a calculation | |
| INPUT_RECORD_TYPE | VARCHAR2 | (1) | Input Record Type | |
| SERIAL_NUM | NUMBER | (5) | Sequential position of the ISIR in the batch, except in SARA files | |
| BATCH_NUMBER_TXT | VARCHAR2 | (23) | Batch Number | |
| EARLY_ANALYSIS_FLAG | VARCHAR2 | (1) | Student requesting early admission to institution | |
| APP_ENTRY_SOURCE_TYPE | VARCHAR2 | (1) | Electronic Application Entry Source Code | |
| ETI_DESTINATION_CD | VARCHAR2 | (7) | TG number assigned by Title IV WAN | |
| REJECT_OVERRIDE_B_FLAG | VARCHAR2 | (1) | Date of birth since sep.1,1985 | |
| REJECT_OVERRIDE_N_FLAG | VARCHAR2 | (1) | Missing first or last name | |
| REJECT_OVERRIDE_W_FLAG | VARCHAR2 | (1) | Questionable no. of family members | |
| ASSUM_OVERRIDE_1_FLAG | VARCHAR2 | (1) | Parent's no. in college assumed to be 1 when it is more than 6 | |
| ASSUM_OVERRIDE_2_FLAG | VARCHAR2 | (1) | Parent's AGI assumed equal to sum of father and mother earned income. | |
| ASSUM_OVERRIDE_3_FLAG | VARCHAR2 | (1) | Student's no. in college assumed to be 1 when it is more than 2 | |
| ASSUM_OVERRIDE_4_FLAG | VARCHAR2 | (1) | Student's AGI assumed equal to sum of student and spouse earned income. | |
| ASSUM_OVERRIDE_5_FLAG | 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 | |
| ASSUM_OVERRIDE_6_FLAG | 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 | |
| DEPENDENCY_STATUS_TYPE | VARCHAR2 | (1) | Determined by CPS based on data provided | |
| S_EMAIL_ADDRESS_TXT | VARCHAR2 | (50) | Student's e-mail address | |
| NSLDS_REASON_CD | VARCHAR2 | (30) | Student's eligibility has changed since initial reasoning | |
| APP_RECEIPT_DATE | DATE | Date the transaction was received by the MDE or School or student filled up a web form | ||
| PROCESSED_REC_TYPE | VARCHAR2 | (1) | Processed Record Type | |
| HIST_CORR_FOR_TRAN_NUM | NUMBER | (2) | History correction applied against Transaction Number | |
| SYS_GENERATED_INDICATOR_TYPE | VARCHAR2 | (1) | Transaction initiated by the CPS with no input from the applicant | |
| DUP_REQUEST_INDICATOR_TYPE | VARCHAR2 | (1) | Duplicate Request Number. Indicates this transaction is a result of a duplicate request | |
| SOURCE_OF_CORRECTION_TYPE | VARCHAR2 | (1) | Source of correction | |
| P_CAL_TAX_STATUS_TYPE | VARCHAR2 | (1) | CPS determination of tax filling status | |
| S_CAL_TAX_STATUS_TYPE | VARCHAR2 | (1) | Student's Calculated 2000 Tax status | |
| GRADUATE_FLAG | VARCHAR2 | (1) | Graduate Flag | |
| AUTO_ZERO_EFC_FLAG | VARCHAR2 | (1) | Zero EFC is automatically set if SNT met and taxable income is $12,000 or less | |
| EFC_CHANGE_FLAG | VARCHAR2 | (1) | EFC change flag | |
| SARC_FLAG | VARCHAR2 | (1) | SARC_FLAG | |
| SIMPLIFIED_NEED_TEST_FLAG | VARCHAR2 | (1) | Applicant meets certain criteria for tax filling status and income level and is not required to provide | |
| REJECT_REASON_CODES_TXT | VARCHAR2 | (14) | Indicates why an application or correction has been rejected | |
| SELECT_SERVICE_MATCH_TYPE | VARCHAR2 | (1) | Selective Service Match Flag .Results from SS Match for applicants who met the criteria to be sent to | |
| SELECT_SERVICE_REG_TYPE | VARCHAR2 | (1) | 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_NUM | NUMBER | (15) | Identification number provided by the Immigration and Naturalization Service indicating that primary - No longer used | |
| SEC_INS_MATCH_TYPE | VARCHAR2 | (1) | Secondary INS Match Flag .Results from INS Match for applicants who were not matched on the initial | |
| SEC_INS_VER_NUM | NUMBER | (15) | Identification number provided b the Immigration and Naturalization Service indicating that primary | |
| SSN_MATCH_TYPE | VARCHAR2 | (1) | Results from SSN Match with Social Security Administration | |
| SSA_CITIZENSHIP_TYPE | VARCHAR2 | (1) | Results from citizenship match with SSA | |
| SSN_DEATH_DATE | DATE | Date of death provided for this SSN from Social Security Administration | ||
| NSLDS_MATCH_TYPE | VARCHAR2 | (1) | Results of the NSLDS Match | |
| VA_MATCH_TYPE | VARCHAR2 | (1) | Results of the Veterans Affair Match | |
| PRISONER_MATCH_FLAG | VARCHAR2 | (1) | Prisoner Match | |
| VERIFICATION_FLAG | VARCHAR2 | (1) | Student is selected for Verification | |
| SUBSEQUENT_APP_FLAG | VARCHAR2 | (1) | Indicates that an initial or renewal application with the same SSN and name ID as a transaction already exists | |
| APP_SOURCE_SITE_CD | VARCHAR2 | (2) | Application Source site code. Indicates the origin of the initial application and the site location | |
| TRAN_SOURCE_SITE_CD | VARCHAR2 | (2) | Transaction Source Site Code. Indicates the origin of the transaction and the site location | |
| DRN_NUM | NUMBER | (4) | Data Release Number (DRN) will only be included when the transaction was initiated at the destination | |
| TRAN_PROCESS_DATE | DATE | Transaction Processed Date. date that CPS computed this transaction | ||
| CORRECTION_FLAGS_TXT | VARCHAR2 | (120) | Correction Flags | |
| COMPUTER_BATCH_NUM | NUMBER | (3) | Compute Batch Number | |
| HIGHLIGHT_FLAGS_TXT | VARCHAR2 | (120) | Indicates fields highlighted in boldface on the SAR. | |
| PAID_EFC_AMT | NUMBER | (5) | Primary or secondary EFC whichever is lower | |
| PRIMARY_EFC_AMT | NUMBER | (5) | The primary 9 month EFC calculated. FNT unless SNT met | |
| SECONDARY_EFC_AMT | NUMBER | (5) | The secondary 9 month EFC calculated. FNT only if SNT is met and asset information provided | |
| FED_PELL_GRANT_EFC_TYPE | VARCHAR2 | (1) | Federal Pell Grant paid EFC type | |
| PRIMARY_EFC_TYPE | VARCHAR2 | (1) | Identifies formula type used to calculate the primary EFC | |
| SEC_EFC_TYPE | VARCHAR2 | (1) | Identifies formula type used to calculate the secondary EFC | |
| PRIMARY_ALT_MONTH_1_AMT | NUMBER | (5) | Primary Alternate Month 1 | |
| PRIMARY_ALT_MONTH_2_AMT | NUMBER | (5) | Primary Alternate Month 2 | |
| PRIMARY_ALT_MONTH_3_AMT | NUMBER | (5) | Primary Alternate Month 3 | |
| PRIMARY_ALT_MONTH_4_AMT | NUMBER | (5) | Primary Alternate Month 4 | |
| PRIMARY_ALT_MONTH_5_AMT | NUMBER | (5) | Primary Alternate Month 5 | |
| PRIMARY_ALT_MONTH_6_AMT | NUMBER | (5) | Primary Alternate Month 6 | |
| PRIMARY_ALT_MONTH_7_AMT | NUMBER | (5) | Primary Alternate Month 7 | |
| PRIMARY_ALT_MONTH_8_AMT | NUMBER | (5) | Primary Alternate Month 8 | |
| PRIMARY_ALT_MONTH_10_AMT | NUMBER | (5) | Primary Alternate Month 10 | |
| PRIMARY_ALT_MONTH_11_AMT | NUMBER | (5) | Primary Alternate Month 11 | |
| PRIMARY_ALT_MONTH_12_AMT | NUMBER | (5) | Primary Alternate Month 12 | |
| SEC_ALTERNATE_MONTH_1_AMT | NUMBER | (5) | Secondary Alternate Month 1 | |
| SEC_ALTERNATE_MONTH_2_AMT | NUMBER | (5) | Secondary Alternate Month 2 | |
| SEC_ALTERNATE_MONTH_3_AMT | NUMBER | (5) | Secondary Alternate Month 3 | |
| SEC_ALTERNATE_MONTH_4_AMT | NUMBER | (5) | Secondary Alternate Month 4 | |
| SEC_ALTERNATE_MONTH_5_AMT | NUMBER | (5) | Secondary Alternate Month 5 | |
| SEC_ALTERNATE_MONTH_6_AMT | NUMBER | (5) | Secondary Alternate Month 6 | |
| SEC_ALTERNATE_MONTH_7_AMT | NUMBER | (5) | Secondary Alternate Month 7 | |
| SEC_ALTERNATE_MONTH_8_AMT | NUMBER | (5) | Secondary Alternate Month 8 | |
| SEC_ALTERNATE_MONTH_10_AMT | NUMBER | (5) | Secondary Alternate Month 10 | |
| SEC_ALTERNATE_MONTH_11_AMT | NUMBER | (5) | Secondary Alternate Month 11 | |
| SEC_ALTERNATE_MONTH_12_AMT | NUMBER | (5) | Secondary Alternate Month 12 | |
| TOTAL_INCOME_AMT | NUMBER | (7) | Total Income | |
| ALLOW_TOTAL_INCOME_AMT | NUMBER | (7) | Allowances against Total Income | |
| STATE_TAX_ALLOW_AMT | NUMBER | (7) | State and other Tax Allowance | |
| EMPLOYMENT_ALLOW_AMT | NUMBER | (7) | Employment Allowance | |
| INCOME_PROTECTION_ALLOW_AMT | NUMBER | (7) | Income Protection Allowance | |
| AVAILABLE_INCOME_AMT | NUMBER | (7) | Available Income | |
| CONTRIBUTION_FROM_AI_AMT | NUMBER | (7) | Contribution from Available Income | |
| DISCRETIONARY_NETWORTH_AMT | NUMBER | (9) | Discretionary Net Worth | |
| EFC_NETWORTH_AMT | NUMBER | (9) | EFC Net Worth | |
| ASSET_PROTECT_ALLOW_AMT | NUMBER | (9) | Asset Protection Allowance | |
| PARENTS_CONT_FROM_ASSETS_AMT | NUMBER | (7) | Parents' Contribution from Assets | |
| ADJUSTED_AVAILABLE_INCOME_AMT | NUMBER | (7) | Adjusted Available Income | |
| TOTAL_STUDENT_CONTRIBUTION_AMT | NUMBER | (7) | Total student Contribution | |
| TOTAL_PARENT_CONTRIBUTION_AMT | NUMBER | (7) | Total Parent Contribution | |
| PARENTS_CONTRIBUTION_AMT | NUMBER | (7) | Parents' Contribution | |
| STUDENT_TOTAL_INCOME_AMT | NUMBER | (7) | Student's Total Income | |
| SATI_AMT | NUMBER | (7) | Students allowance against total income | |
| SIC_AMT | NUMBER | (7) | Dependent Students Income Contribution | |
| SDNW_AMT | NUMBER | (9) | Students Discretionary Net Worth | |
| SCA_AMT | NUMBER | (7) | Student's contribution from assets | |
| FTI_AMT | NUMBER | (7) | FISAP Total Income | |
| SECTI_AMT | NUMBER | (7) | Secondary Total Income | |
| SECATI_AMT | NUMBER | (7) | secondary Allowance against total income | |
| SECSTX_AMT | NUMBER | (7) | Secondary State Tax Allowance | |
| SECEA_AMT | NUMBER | (7) | Secondary Employment Allowance | |
| SECIPA_AMT | NUMBER | (7) | Secondary Income Protection allowance | |
| SECAI_AMT | NUMBER | (7) | Secondary Available Income | |
| SECCAI_AMT | NUMBER | (7) | Secondary contribution from Available Income | |
| SECDNW_AMT | NUMBER | (9) | Secondary Discretionary Net worth | |
| SECNW_AMT | NUMBER | (9) | Secondary Net Worth | |
| SECAPA_AMT | NUMBER | (9) | Secondary Asset Protection Allowance | |
| SECPCA_AMT | NUMBER | (7) | Secondary Parents Contribution from Assets | |
| SECAAI_AMT | NUMBER | (7) | Secondary Available Income | |
| SECTSC_AMT | NUMBER | (7) | secondary Total Student Contribution | |
| SECTPC_AMT | NUMBER | (7) | Secondary Total Parent Contribution | |
| SECPC_AMT | NUMBER | (7) | Secondary Parent Contribution | |
| SECSTI_AMT | NUMBER | (7) | Secondary Students Total Income | |
| SECSATI_AMT | NUMBER | (7) | Secondary Students Allowance against Total Income | |
| SECSIC_AMT | NUMBER | (7) | Secondary Student's Dependent Income Contribution | |
| SECSDNW_AMT | NUMBER | (9) | Secondary Students Discretionary Net worth | |
| SECSCA_AMT | NUMBER | (7) | Secondary Students Contribution from Assets | |
| SECFTI_AMT | NUMBER | (7) | Secondary FISAP Total Income | |
| A_CITIZENSHIP_FLAG | VARCHAR2 | (1) | Assumed Citizenship | |
| A_STUDENT_MARITAL_STATUS_FLAG | VARCHAR2 | (1) | Students assumed marital status | |
| A_STUDENT_AGI_AMT | NUMBER | (6) | Assumed Students Adjusted Gross Income | |
| A_S_US_TAX_PAID_AMT | NUMBER | (5) | Assumed student tax paid | |
| A_S_INCOME_WORK_AMT | NUMBER | (6) | Assumed Students income from work | |
| A_SPOUSE_INCOME_WORK_AMT | NUMBER | (6) | Assumed Spouse income from work | |
| A_S_TOTAL_WSC_AMT | NUMBER | (5) | Assumed students income from worksheet C | |
| A_DATE_OF_BIRTH_FLAG | VARCHAR2 | (1) | Assumed Students Date to Birth prior | |
| A_STUDENT_MARRIED_FLAG | VARCHAR2 | (1) | Assumed student is married | |
| A_HAVE_CHILDREN_FLAG | VARCHAR2 | (1) | Assumed do u have children? | |
| A_S_HAVE_DEPENDENTS_FLAG | VARCHAR2 | (1) | Assumed Student have dependents | |
| A_VA_STATUS_FLAG | VARCHAR2 | (1) | Assumed VA Status | |
| A_S_IN_FAMILY_NUM | NUMBER | (2) | Assumed student's number in family | |
| A_S_IN_COLLEGE_NUM | NUMBER | (1) | Assumed student's Number in College | |
| A_P_MARITAL_STATUS_FLAG | VARCHAR2 | (1) | Assumed Parents Marital Status | |
| A_FATHER_SSN_NUM | NUMBER | (9) | Assumed Father's SSN - No Longer Used | |
| A_MOTHER_SSN_NUM | NUMBER | (9) | Assumed Mother's SSN - No Longer Used | |
| A_PARENTS_FAMILY_NUM | NUMBER | (2) | Assumed parents' number in family | |
| A_PARENTS_COLLEGE_NUM | NUMBER | (1) | Assumed parents' number in college | |
| A_PARENTS_AGI_AMT | NUMBER | (6) | Assumed parents' Annual Gross Income | |
| A_P_US_TAX_PAID_AMT | NUMBER | (6) | Assumed Parents' US tax Paid | |
| A_F_WORK_INCOME_AMT | NUMBER | (6) | Assumed Father's Earned income 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 | |
| PELL_GRANT_ELIG_FLAG | VARCHAR2 | (1) | Indicates that the transaction has been determined eligible for a federal Pell grant | |
| REPROCESS_REASON_CD | VARCHAR2 | (2) | The code to identify why ISIR was reprocessed | |
| DUPLICATE_DATE | DATE | CPS Process date for duplicate transaction requested. | ||
| ISIR_TRANSACTION_TYPE | VARCHAR2 | (1) | Indicates where the transaction was generated from | |
| FEDRAL_SCHL_TYPE | VARCHAR2 | (1) | 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_CD_FLAGS_TXT | VARCHAR2 | (6) | Each byte of this field corresponds to the 6 federal school codes choices. | |
| DUP_SSN_INDICATOR_FLAG | VARCHAR2 | (1) | Y when more than one person uses this SSN | |
| NSLDS_TRANSACTION_NUM | NUMBER | (2) | Reflects the latest transaction number for which NSLDS updated information | |
| NSLDS_DATABASE_RESULTS_TYPE | VARCHAR2 | (1) | NSLDS Database results flag | |
| NSLDS_FLAG | VARCHAR2 | (1) | NSLDS flag for NSLDS use only | |
| NSLDS_PELL_OVERPAY_TYPE | VARCHAR2 | (1) | NSLDS Pell overpayment flag | |
| NSLDS_PELL_OVERPAY_CONTACT_TXT | VARCHAR2 | (8) | NSLDS Pell overpayment contact | |
| NSLDS_SEOG_OVERPAY_TYPE | VARCHAR2 | (1) | NSLDS SEOG overpayment type | |
| NSLDS_SEOG_OVERPAY_CONTACT_TXT | VARCHAR2 | (8) | NSLDS SEOG overpayment contact | |
| NSLDS_PERKINS_OVERPAY_TYPE | VARCHAR2 | (1) | NSLDS Perkins overpayment type | |
| NSLDS_PERKINS_OVRPAY_CNTCT_TXT | VARCHAR2 | (8) | NSLDS Perkins overpayment contact | |
| NSLDS_DEFAULTED_LOAN_FLAG | VARCHAR2 | (1) | NSLDS Defaulted loan flag | |
| NSLDS_DISCHARGED_LOAN_TYPE | VARCHAR2 | (1) | NSLDS Discharged loan type | |
| NSLDS_SATIS_REPAY_FLAG | VARCHAR2 | (1) | NSLDS loan satisfactory repayment flag | |
| NSLDS_ACT_BANKRUPTCY_FLAG | VARCHAR2 | (1) | Active bankruptcy flag | |
| NSLDS_AGG_SUBSZ_OUT_PBAL_AMT | NUMBER | (6) | NSLDS Aggregate subsidized outstanding principle balance | |
| NSLDS_AGG_UNSBZ_OUT_PBAL_AMT | NUMBER | (6) | NSLDS Aggregate unsubsidized outstanding principle balance | |
| NSLDS_AGG_COMB_OUT_PBAL_AMT | NUMBER | (6) | NSLDS Aggregate combined outstanding principle balance | |
| NSLDS_AGG_CONS_OUT_PBAL_AMT | NUMBER | (6) | NSLDS Aggregate consolidated outstanding principle balance | |
| NSLDS_AGG_SUBSZ_PEND_DISB_AMT | NUMBER | (6) | NSLDS Aggregate subsidized pending disbursement | |
| NSLDS_AGG_UNSBZ_PEND_DISB_AMT | NUMBER | (6) | NSLDS Aggregate unsubsidized pending disbursement | |
| NSLDS_AGG_COMB_PEND_DISB_AMT | NUMBER | (6) | NSLDS Aggregate combined pending disbursement | |
| NSLDS_AGG_SUBSZ_TOTAL_AMT | NUMBER | (6) | NSLDS Aggregate subsidized total | |
| NSLDS_AGG_UNSBZ_TOTAL_AMT | NUMBER | (6) | NSLDS Aggregate unsubsidized total | |
| NSLDS_AGG_COMB_TOTAL_AMT | NUMBER | (6) | NSLDS Aggregate combined total | |
| NSLDS_AGG_CONSD_TOTAL_AMT | NUMBER | (6) | NSLDS Aggregate consolidated total | |
| NSLDS_PERKINS_OUT_BAL_AMT | NUMBER | (6) | NSLDS Perkins outstanding balance amount | |
| NSLDS_PERKINS_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_DISCHGED_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 payment loan change flag | |
| NSLDS_ADDTNL_PELL_FLAG | VARCHAR2 | (1) | NSLDS Additional Pell flag | |
| NSLDS_ADDTNL_LOAN_FLAG | VARCHAR2 | (1) | NSLDS Additional Loans flag | |
| DIRECT_LOAN_MAS_PROM_NT_TYPE | VARCHAR2 | (1) | Direct loan master-Prom flag | |
| NSLDS_PELL_1_SEQ_NUM | NUMBER | (2) | NSLDS Pell Sequence Number (1) | |
| NSLDS_PELL_1_VERIFY_F_TXT | VARCHAR2 | (3) | NSLDS Pell Verification code number (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 | NSLDS Pell Last Update date(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_SCHAWD_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 | |
| NSLDS_PELL_2_LAST_UPDT_DATE | DATE | NSLDS Pell Last Update date(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_SCHAWD_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) | NSLDS 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 EFC(3) | |
| NSLDS_PELL_3_SCHOOL_NUM | NUMBER | (8) | NSLDS Pell School code(3) | |
| NSLDS_PELL_3_TRANSCN_NUM | NUMBER | (2) | NSLDS Pell Transaction number(3) | |
| NSLDS_PELL_3_LAST_UPDT_DATE | DATE | NSLDS Pell Last Update date(3) | ||
| NSLDS_PELL_3_SCHEDULED_AMT | NUMBER | (6) | NSLDS Pell Scheduled amount(3) | |
| NSLDS_PELL_3_PAID_TODT_AMT | NUMBER | (6) | NSLDS Pell amount paid to date(3) | |
| NSLDS_PELL_3_REMNG_AMT | NUMBER | (6) | NSLDS Pell remaining amount (3) | |
| NSLDS_PELL_3_PC_SCHAWD_USE_AMT | NUMBER | (5) | NSLDS Pell Percent Scheduled Award used (3) | |
| NSLDS_PELL_3_AWARD_AMT | NUMBER | (6) | NSLDS 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 Principle balance | |
| NSLDS_LOAN_1_OUT_PR_BAL_DATE | DATE | NSLDS Loan (1) Outstanding Principle 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 Code | |
| NSLDS_LOAN_1_CONT_CD | VARCHAR2 | (8) | NSLDS Loan (1) Contact Code | |
| NSLDS_LOAN_1_SCHOL_CD | VARCHAR2 | (8) | NSLDS Loan (1) School Code | |
| NSLDS_LOAN_1_GRADE_LVL_TXT | VARCHAR2 | (3) | NSLDS Loan (1) grade level | |
| NSLDS_LOAN_1_XTR_UNSBZ_LN_TYPE | VARCHAR2 | (1) | NSLDS Loan (1) Extra Unsubsidized Loan Flag | |
| NSLDS_LOAN_1_CAPITAL_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 Principle balance | |
| NSLDS_LOAN_2_OUT_PR_BAL_DATE | DATE | NSLDS Loan (2) Outstanding Principle 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_CONT_CD | VARCHAR2 | (8) | NSLDS Loan (2) Contact Code | |
| NSLDS_LOAN_2_SCHOL_CD | VARCHAR2 | (8) | NSLDS Loan (2) School Code | |
| NSLDS_LOAN_2_GRADE_LVL_TXT | VARCHAR2 | (3) | NSLDS Loan (2) Grade Level | |
| NSLDS_LOAN_2_XTR_UNSBZ_LN_TYPE | VARCHAR2 | (1) | NSLDS Loan (2) Extra Unsubsidized Loan Flag | |
| NSLDS_LOAN_2_CAPITAL_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 Principle balance | |
| NSLDS_LOAN_3_OUT_PR_BAL_DATE | DATE | NSLDS Loan (3) Outstanding Principle 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_CONT_CD | VARCHAR2 | (8) | NSLDS Loan (3) Contact Code | |
| NSLDS_LOAN_3_SCHOL_CD | VARCHAR2 | (8) | NSLDS Loan (3) School Code | |
| NSLDS_LOAN_3_GRADE_LVL_TXT | VARCHAR2 | (3) | NSLDS Loan (3) Grade Level | |
| NSLDS_LOAN_3_XTR_UNSBZ_LN_TYPE | VARCHAR2 | (1) | NSLDS Loan (3) Extra Unsubsidized Loan Flag | |
| NSLDS_LOAN_3_CAPITAL_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) Net Amount | |
| 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 Principle balance | |
| NSLDS_LOAN_4_OUT_PR_BAL_DATE | DATE | NSLDS Loan (4) Outstanding Principle 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_CONT_CD | VARCHAR2 | (8) | NSLDS Loan (4) Contact Code | |
| NSLDS_LOAN_4_SCHOL_CD | VARCHAR2 | (8) | NSLDS Loan (4) School Code | |
| NSLDS_LOAN_4_GRADE_LVL_TXT | VARCHAR2 | (3) | NSLDS Loan (4) Grade Level | |
| NSLDS_LOAN_4_XTR_UNSBZ_LN_TYPE | VARCHAR2 | (1) | NSLDS Loan (4) Extra Unsubsidized Loan Flag | |
| NSLDS_LOAN_4_CAPITAL_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 Principle balance | |
| NSLDS_LOAN_5_OUT_PR_BAL_DATE | DATE | NSLDS Loan (5) Outstanding Principle 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_CONT_CD | VARCHAR2 | (8) | NSLDS Loan (5) Contact Code | |
| NSLDS_LOAN_5_SCHOL_CD | VARCHAR2 | (8) | NSLDS Loan (5) School Code | |
| NSLDS_LOAN_5_GRADE_LVL_TXT | VARCHAR2 | (3) | NSLDS Loan (5) Grade Level | |
| NSLDS_LOAN_5_XTR_UNSBZ_LN_TYPE | VARCHAR2 | (1) | NSLDS Loan (5) Extra Unsubsidized Loan Flag | |
| NSLDS_LOAN_5_CAPITAL_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 Principle balance | |
| NSLDS_LOAN_6_OUT_PR_BAL_DATE | DATE | NSLDS Loan (6) Outstanding Principle 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_CONT_CD | VARCHAR2 | (8) | NSLDS Loan (6) Contact Code | |
| NSLDS_LOAN_6_SCHOL_CD | VARCHAR2 | (8) | NSLDS Loan (6) School Code | |
| NSLDS_LOAN_6_GRADE_LVL_TXT | VARCHAR2 | (3) | NSLDS Loan (6) Grade Level | |
| NSLDS_LOAN_6_XTR_UNSBZ_LN_TYPE | VARCHAR2 | (1) | NSLDS Loan (6) Extra Unsubsidized Loan Flag | |
| NSLDS_LOAN_6_CAPITAL_INT_FLAG | VARCHAR2 | (1) | NSLDS Loan (6) Capitalized Interest Flag | |
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_DATE | DATE | 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 | ||
| 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_DISB_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 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 martial status date | ||
| DLP_MASTER_PROM_NOTE_TYPE | VARCHAR2 | (1) | Indicates the Direct Loan Plus Master Promissory Note Flag | |
| IMPORT_STATUS_TYPE | VARCHAR2 | (1) | Yes | Record's Import status |
| IMPORT_RECORD_TYPE | VARCHAR2 | (1) | Determines whether this record has to update the System record if found in the system.Can have a value of U or Null | |
| 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 | (240) | To indicate the Mother's/Stepmother's results from SSN Match with Social Security Administration. | |
| SUBSIDIZED_LOAN_LIMIT_TYPE | VARCHAR2 | (1) | Subsidized Loan Limit Flag | |
| COMBINED_LOAN_LIMIT_TYPE | VARCHAR2 | (1) | Combined Loan Limit Flag | |
| REJECT_OVERRIDE_G_FLAG | VARCHAR2 | (1) | Reject Override G Flag | |
| DHS_VERIFICATION_NUM_TXT | VARCHAR2 | (15) | Identification Number provided by the Department of Homeland Securityindicating that primary verification wasperformed. | |
| ORIGINAL_SSN_TXT | VARCHAR2 | (9) | Holds original SSN as processed by CPS | |
| CURRENT_SSN_TXT | VARCHAR2 | (9) | Holds SSN on transaction | |
| FATHER_SSN_TXT | VARCHAR2 | (9) | Father's Social Security Number | |
| MOTHER_SSN_TXT | VARCHAR2 | (9) | Mother's Social Security Number | |
| PREPARER_SSN_TXT | VARCHAR2 | (9) | Preparer's Social Security Number | |
| A_FATHER_SSN_TXT | VARCHAR2 | (9) | Assumed Father's SSN | |
| A_MOTHER_SSN_TXT | VARCHAR2 | (9) | Assumed Mother's SSN | |
| 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 BATCH_NUM
, ISRINT_ID
, PERSON_NUMBER
, BATCH_YEAR_NUM
, TRANSACTION_NUM_TXT
, SSN_NAME_CHANGE_TYPE
, ORIGINAL_SSN_NUM
, ORIG_NAME_ID_TXT
, CURRENT_SSN_NUM
, 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_HIGHEST_EDU_LEVEL_TYPE
, MOTHERS_HIGHEST_EDU_LEVEL_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_SCHOOL_DIPLOMA_GED_FLAG
, FIRST_BACHELOR_DEG_YEAR_FLAG
, INTEREST_IN_LOAN_FLAG
, INTEREST_IN_STU_EMPLOYMNT_FLAG
, DRUG_OFFENCE_CONVICTION_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_NUM
, F_LAST_NAME
, MOTHER_SSN_NUM
, 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_NUM
, 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_AVAILABLE_INCOME_AMT
, TOTAL_STUDENT_CONTRIBUTION_AMT
, TOTAL_PARENT_CONTRIBUTION_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_STUDENT_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_NUM
, A_MOTHER_SSN_NUM
, 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_CONTACT_TXT
, NSLDS_SEOG_OVERPAY_TYPE
, NSLDS_SEOG_OVERPAY_CONTACT_TXT
, NSLDS_PERKINS_OVERPAY_TYPE
, NSLDS_PERKINS_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_PEND_DISB_AMT
, NSLDS_AGG_UNSBZ_PEND_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_PERKINS_CUR_YR_DISB_AMT
, NSLDS_DEFAULT_LOAN_CHNG_FLAG
, NSLDS_DISCHGED_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_SCHAWD_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_SCHAWD_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_SCHAWD_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_CONT_CD
, NSLDS_LOAN_1_SCHOL_CD
, NSLDS_LOAN_1_GRADE_LVL_TXT
, NSLDS_LOAN_1_XTR_UNSBZ_LN_TYPE
, NSLDS_LOAN_1_CAPITAL_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_CONT_CD
, NSLDS_LOAN_2_SCHOL_CD
, NSLDS_LOAN_2_GRADE_LVL_TXT
, NSLDS_LOAN_2_XTR_UNSBZ_LN_TYPE
, NSLDS_LOAN_2_CAPITAL_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_CONT_CD
, NSLDS_LOAN_3_SCHOL_CD
, NSLDS_LOAN_3_GRADE_LVL_TXT
, NSLDS_LOAN_3_XTR_UNSBZ_LN_TYPE
, NSLDS_LOAN_3_CAPITAL_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_CONT_CD
, NSLDS_LOAN_4_SCHOL_CD
, NSLDS_LOAN_4_GRADE_LVL_TXT
, NSLDS_LOAN_4_XTR_UNSBZ_LN_TYPE
, NSLDS_LOAN_4_CAPITAL_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_CONT_CD
, NSLDS_LOAN_5_SCHOL_CD
, NSLDS_LOAN_5_GRADE_LVL_TXT
, NSLDS_LOAN_5_XTR_UNSBZ_LN_TYPE
, NSLDS_LOAN_5_CAPITAL_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_CONT_CD
, NSLDS_LOAN_6_SCHOL_CD
, NSLDS_LOAN_6_GRADE_LVL_TXT
, NSLDS_LOAN_6_XTR_UNSBZ_LN_TYPE
, NSLDS_LOAN_6_CAPITAL_INT_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, 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
, IMPORT_STATUS_TYPE
, IMPORT_RECORD_TYPE
, FATHER_FIRST_NAME_INITIAL_TXT
, FATHER_STEP_FATHER_BIRTH_DATE
, MOTHER_FIRST_NAME_INITIAL_TXT
, MOTHER_STEP_MOTHER_BIRTH_DATE
, PARENTS_EMAIL_ADDRESS_TXT
, ADDRESS_CHANGE_TYPE
, CPS_PUSHED_ISIR_FLAG
, ELECTRONIC_TRANSACTION_TYPE
, SAR_C_CHANGE_TYPE
, FATHER_SSN_MATCH_TYPE
, MOTHER_SSN_MATCH_TYPE
, SUBSIDIZED_LOAN_LIMIT_TYPE
, COMBINED_LOAN_LIMIT_TYPE
, REJECT_OVERRIDE_G_FLAG
, DHS_VERIFICATION_NUM_TXT
, ORIGINAL_SSN_TXT
, CURRENT_SSN_TXT
, FATHER_SSN_TXT
, MOTHER_SSN_TXT
, PREPARER_SSN_TXT
, A_FATHER_SSN_TXT
, A_MOTHER_SSN_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_LI_ISIR_INTS;
IGF.IGF_AP_LI_ISIR_INTS does not reference any database object
IGF.IGF_AP_LI_ISIR_INTS is referenced by following:
APPS
IGF_AP_LI_ISIR_INTS
|
|
|
|