DBA Data[Home] [Help] [Dependency Information]


TABLE: IGF.IGF_AP_ISIR_INTRFACE_ALL

Object Details
Object Name: IGF_AP_ISIR_INTRFACE_ALL
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.IGF_AP_ISIR_INTRFACE_ALL
Subobject Name:
Status: VALID


IGF_AP_ISIR_INTRFACE_ALL holds the complete ISIR record. - Obsolete


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_AP_ISIR_INTERFACE_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSI_ID
Columns
Name Datatype Length Mandatory Comments
SI_ID NUMBER (15) Yes Identifier for uploaded ISIR
BATCH_YEAR NUMBER (1) Yes Holds batch year
TRANSACTION_NUM VARCHAR2 (2) Yes Holds CPS transaction number of ISIR
RECORD_STATUS VARCHAR2 (10)
Identifies status of ISIR record after initial processing. Values are matched, unmatched, new, or invalid.
SSN_NAME_CHANGE VARCHAR2 (1)
Indicates whether last name, SSN, or both have been changed
ORIGINAL_SSN VARCHAR2 (9)
Holds original SSN as processed by CPS
ORIG_NAME_ID VARCHAR2 (2)
Holds first two letters of last name as on initial application
CURRENT_SSN VARCHAR2 (9)
Holds SSN on transaction
LAST_NAME VARCHAR2 (16)
Last name of applicant student
FIRST_NAME VARCHAR2 (12) Yes Indicates first name of applicant student
MIDDLE_INITIAL VARCHAR2 (1)
Middle name of applicant student
PERM_MAIL_ADD VARCHAR2 (35)
Permanent mailing address of applicant student
PERM_CITY VARCHAR2 (16)
Permanent city of applicant student
PERM_STATE VARCHAR2 (2)
Permanent state of applicant student
PERM_ZIP_CODE VARCHAR2 (5)
Permanent zip code of applicant student
DATE_OF_BIRTH DATE

Date of birth of applicant student
PHONE_NUMBER VARCHAR2 (10)
Contact phone number of applicant student
DRIVER_LICENSE_NUMBER VARCHAR2 (20)
Driver's license number of applicant student if applicable
DRIVER_LICENSE_STATE VARCHAR2 (2)
Driver's license state code of applicant student if applicable
CITIZENSHIP_STATUS VARCHAR2 (1)
Status of student's citizenship
ALIEN_REG_NUMBER VARCHAR2 (9)
Student's alien registration number
S_MARITAL_STATUS 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 VARCHAR2 (1)
Student's enrollment plan for summer term
FALL_ENRL_STATUS VARCHAR2 (1)
Student's enrollment plan for fall term
WINTER_ENRL_STATUS VARCHAR2 (1)
Student's enrollment plan for winter term
SPRING_ENRL_STATUS VARCHAR2 (1)
Student's enrollment plan for spring term
SUMM2_ENRL_STATUS VARCHAR2 (1)
Student's enrollment plan for next summer term
FATHERS_HIGHEST_EDU_LEVEL VARCHAR2 (1)
Father's highest education level completed
MOTHERS_HIGHEST_EDU_LEVEL VARCHAR2 (1)
Mother's highest education level completed
S_STATE_LEGAL_RESIDENCE VARCHAR2 (2)
Student's state of legal residence
LEGAL_RESIDENCE_BEFORE_DATE VARCHAR2 (1)
Student's legal residence before cut-off date. Set by CPS.
S_LEGAL_RESD_DATE DATE

Date on which student's legal residence changed to current
SS_R_U_MALE VARCHAR2 (1)
Indicates whether student is male
SELECTIVE_SERVICE_REG VARCHAR2 (1)
Indicates whether Selective Service should register student
DEGREE_CERTIFICATION VARCHAR2 (1)
Holds student's degree or certificate information
GRADE_LEVEL_IN_COLLEGE VARCHAR2 (1)
Student's grade level in college in current academic year
HIGH_SCHOOL_DIPLOMA_GED VARCHAR2 (1)
Holds student's high school diploma or GED diploma information
FIRST_BACHELOR_DEG_BY_DATE VARCHAR2 (1)
Indicates whether student will obtain first bachelor's degree during current year
INTEREST_IN_LOAN VARCHAR2 (1)
Indicates whether student is interested in student loan
INTEREST_IN_STUD_EMPLOYMENT VARCHAR2 (1)
Indicates whether student is interested in student employment
DRUG_OFFENCE_CONVICTION VARCHAR2 (1)
Indicates whether student has drug conviction
S_TAX_RETURN_STATUS VARCHAR2 (1)
Holds student's tax return status
S_TYPE_TAX_RETURN VARCHAR2 (1)
Indicates type of tax form used by student for filing the tax
S_ELIG_1040EZ VARCHAR2 (1)
Indicates whether student is eligible for 1040A or 1040EZ
S_ADJUSTED_GROSS_INCOME VARCHAR2 (6)
Holds students adjusted gross income from IRS Form
S_FED_TAXES_PAID NUMBER (5)
Holds amount student paid in U.S. income tax
S_EXEMPTIONS NUMBER (2)
Indicates number of tax exemptions student claims
S_INCOME_FROM_WORK VARCHAR2 (6)
Student's income earned from work
SPOUSE_INCOME_FROM_WORK VARCHAR2 (6)
Spouse's income earned from work
S_TOA_AMT_FROM_WSA NUMBER (5)
Student's total amount from Worksheet A
S_TOA_AMT_FROM_WSB NUMBER (5)
Student's total amount from Worksheet B
S_TOA_AMT_FROM_WSC NUMBER (5)
Student's total amount from Worksheet C
S_INVESTMENT_NETWORTH NUMBER (6)
Net worth of investment made by student
S_BUSI_FARM_NETWORTH NUMBER (6)
Net worth of student's business and farm
S_CASH_SAVINGS NUMBER (6)
Savings available for student
VA_MONTHS NUMBER (2)
Indicates number of months student received veteran's education benefit
VA_AMOUNT NUMBER (15)
Stores the Monthly Veterans Education Benefits
STUD_DOB_BEFORE_DATE VARCHAR2 (1)
Indicates whether student was born before cut-off date set by Department of Education for year
DEG_BEYOND_BACHELOR VARCHAR2 (1)
Indicates whether student is working on a degree beyond current academic year
S_MARRIED VARCHAR2 (1)
Indicates whether student is married
S_HAVE_CHILDREN VARCHAR2 (1)
Indicates whether student has children
LEGAL_DEPENDENTS VARCHAR2 (1)
Indicates whether student has legal dependents other than children and spouse
ORPHAN_WARD_OF_COURT VARCHAR2 (1)
Indicates whether student is orphan or ward of court
S_VETERAN VARCHAR2 (1)
Indicates whether student is veteran of U.S. Armed Forces
P_MARITAL_STATUS VARCHAR2 (1)
Holds marital status of student's parents
FATHER_SSN VARCHAR2 (9)
Holds father's SSN
F_LAST_NAME VARCHAR2 (16)
Holds father's last name
MOTHER_SSN VARCHAR2 (9)
Holds mother's SSN
M_LAST_NAME VARCHAR2 (16)
Holds mother's last name
P_NUM_FAMILY_MEMBER NUMBER (2)
Holds number of family members in students' parents' family
P_NUM_IN_COLLEGE NUMBER (1)
Holds number of people in parents' family in college in current year. Excludes parents.
P_STATE_LEGAL_RESIDENCE VARCHAR2 (2)
Holds parents' state of legal residence
P_STATE_LEGAL_RES_BEFORE_DT VARCHAR2 (1)
Parents' legal residence before specific date
P_LEGAL_RES_DATE DATE

Date on which current state became parents' legal residence
AGE_OLDER_PARENT NUMBER (2)
Holds older parent's age
P_TAX_RETURN_STATUS VARCHAR2 (1)
Indicates whether parents filed tax returns
P_TYPE_TAX_RETURN VARCHAR2 (1)
Holds type of tax form used by parents in filing tax returns
P_ELIG_1040AEZ VARCHAR2 (1)
Indicates whether parents are eligible to file 1040A or 1040EZ
P_ADJUSTED_GROSS_INCOME VARCHAR2 (6)
Holds parents adjusted gross income from IRS form
P_TAXES_PAID NUMBER (6)
Holds U.S. income tax parents paid
P_EXEMPTIONS NUMBER (2)
Holds number of exemptions parents claimed
F_INCOME_WORK VARCHAR2 (6)
Holds father's income earned from work
M_INCOME_WORK VARCHAR2 (6)
Holds mother's income earned from work
P_INCOME_WSA NUMBER (5)
Parents' total amount from Worksheet A
P_INCOME_WSB NUMBER (5)
Parents' total amount from Worksheet B
P_INCOME_WSC NUMBER (5)
Parents' total amount from Worksheet C
P_INVESTMENT_NETWORTH NUMBER (6)
Holds net worth of parents' investments
P_BUSINESS_NETWORTH NUMBER (6)
Holds net worth of parents' business and farm
P_CASH_SAVING NUMBER (6)
Holds parents' savings information
S_NUM_FAMILY_MEMBERS NUMBER (2)
Number of family members in student's family
S_NUM_IN_COLLEGE NUMBER (1)
Holds number of people in student's family in college during current year
FIRST_COLLEGE VARCHAR2 (6)
Holds school code of one of schools student wants ISIR data to be sent from CPS
FIRST_HOUSE_PLAN VARCHAR2 (1)
Student's housing plan for first school
SECOND_COLLEGE VARCHAR2 (6)
Holds school code of one of schools student wants ISIR data to be sent from CPS
SECOND_HOUSE_PLAN VARCHAR2 (1)
Student's housing plan for second school
THIRD_COLLEGE VARCHAR2 (6)
Holds school code of one of schools student wants ISIR data to be sent from CPS
THIRD_HOUSE_PLAN VARCHAR2 (1)
Student's housing plan for third school
FOURTH_COLLEGE VARCHAR2 (6)
Holds school code of one of schools student wants ISIR data to be sent from CPS
FOURTH_HOUSE_PLAN VARCHAR2 (1)
Student's housing plan for fourth school
FIFTH_COLLEGE VARCHAR2 (6)
Holds school code of one of schools student wants ISIR data to be sent from CPS
FIFTH_HOUSE_PLAN VARCHAR2 (1)
Student's housing plan for fifth school
SIXTH_COLLEGE VARCHAR2 (6)
Holds school code of one of schools student wants ISIR data to be sent from CPS
SIXTH_HOUSE_PLAN VARCHAR2 (1)
Student's housing plan for sixth school
DATE_APP_COMPLETED DATE

Indicates date application was completed
SIGNED_BY VARCHAR2 (1)
Indicates if applicant, parent, or both signed FAFSA application
PREPARER_SSN VARCHAR2 (9)
Holds SSN of person who prepared application
PREPARER_EMP_ID_NUMBER VARCHAR2 (9)
Holds preparer's employer identification number
PREPARER_SIGN VARCHAR2 (1)
Indicates whether preparer signed transaction
TRANSACTION_RECEIPT_DATE DATE

Holds date transaction was received by Department of Education or school, or date student filled out web form
DEPENDENCY_OVERRIDE_IND VARCHAR2 (1)
Indicates dependency override was requested on transaction
FAA_FEDRAL_SCHL_CODE VARCHAR2 (6)
Holds information about federal school that requested dependency override or adjusted calculated request
FAA_ADJUSTMENT VARCHAR2 (1)
Indicates whether Financial Aid administrator requested EFC adjustment and if it was processed
INPUT_RECORD_TYPE VARCHAR2 (1)
Indicates type of ISIR record. Values are Initial Application, Correction Application, Duplicate Request, History Correction, or Renewal.
SERIAL_NUMBER NUMBER (5)
Sequential position of ISIR in batch, except for SARA files
BATCH_NUMBER VARCHAR2 (23)
Holds unique batch number of ISIR record
EARLY_ANALYSIS_FLAG VARCHAR2 (1)
Indicates whether student requests early admission to institution
APP_ENTRY_SOURCE_CODE VARCHAR2 (1)
Indicates origin of electronic application
ETI_DESTINATION_CODE VARCHAR2 (7)
TG number assigned by Title IV WAN
REJECT_OVERRIDE_B VARCHAR2 (1)
Indicates rejection override used while processing record. Deals with date of birth.
REJECT_OVERRIDE_N VARCHAR2 (1)
Indicates rejection override used while processing record. Deals with missing first or last name.
REJECT_OVERRIDE_W VARCHAR2 (1)
Indicates rejection override used while processing record. Deals with questionable number of family members.
ASSUM_OVERRIDE_1 VARCHAR2 (1)
Indicates assumption made by CPS while processing student record. States that parents' number of family members in college was assumed to be 1 when it is more than 6.
ASSUM_OVERRIDE_2 VARCHAR2 (1)
Indicates assumption made by CPS while processing student record. States that parents' adjusted gross income was assumed to be equal to sum of father and mother's earned income.
ASSUM_OVERRIDE_3 VARCHAR2 (1)
Indicates assumption made by CPS while processing student record. States that student's number of family members in college was assumed to be 1 when it is more than 2.
ASSUM_OVERRIDE_4 VARCHAR2 (1)
Indicates assumption made by CPS while processing student record. States that student's adjusted gross income assumed equal to sum of student and spouse's earned income.
ASSUM_OVERRIDE_5 VARCHAR2 (1)
Indicates assumption made by CPS while processing student record. States that parents' total from Worksheet C assumed to be zero. Allows parents' income from Worksheet C to be less than or equal to parents' total income.
ASSUM_OVERRIDE_6 VARCHAR2 (1)
Indicates assumption made by CPS while processing student record. States that student's total from Worksheet C assumed to be zero. Allows parents' income from Worksheet C to be less than or equal to student's total income.
DEPENDENCY_STATUS VARCHAR2 (1)
Indicates dependency status as determined by CPS based upon data student provided
S_EMAIL_ADDRESS VARCHAR2 (50)
Denotes student's e-mail address
NSLDS_REASON_CODE VARCHAR2 (30)
Indicates eligibility of a student for loan based upon information available with NSLDS
APP_RECEIPT_DATE DATE

Date transaction was received by Department of Education or school, or date student filled out web form
PROCESSED_REC_TYPE VARCHAR2 (1)
Indicates type of application. Values are Initial, Renewal, Correction, History, or Duplicate.
HIST_CORRECTION_FOR_TRAN_ID NUMBER (2)
If record is correction record, indicates transaction number of record which initiated correction.
SYSTEM_GENERATED_INDICATOR VARCHAR2 (1)
Indicates transaction was initiated by CPS without input from applicant
DUP_REQUEST_INDICATOR VARCHAR2 (1)
Indicates transaction is result of duplicate request
SOURCE_OF_CORRECTION VARCHAR2 (1)
Indicates source of correction. Values are Applicant, CPS, or School.
P_CAL_TAX_STATUS VARCHAR2 (1)
Indicates tax filling status as determined by CPS
S_CAL_TAX_STATUS VARCHAR2 (1)
Indicates student's tax status as determined by CPS
GRADUATE_FLAG VARCHAR2 (1)
Indicates that student is graduate
AUTO_ZERO_EFC VARCHAR2 (1)
Indicates that EFC is set to zero based on income criteria provided by student. Zero EFC is automatically set if Simplified Needs Test is met, and taxable income is $12,000 or less.
EFC_CHANGE_FLAG VARCHAR2 (1)
Indicates whether EFC has gone up or down from transaction being applied against. Applicable only if ISIR record is not new application.
SARC_FLAG VARCHAR2 (1)
Indicates if C flag is set for student
SIMPLIFIED_NEED_TEST VARCHAR2 (1)
Indicates that applicant meets certain criteria for tax filing status and income level, and is not required to provide asset information
REJECT_REASON_CODES VARCHAR2 (14)
Indicates why application or correction has been rejected
SELECT_SERVICE_MATCH_FLAG VARCHAR2 (1)
Selective Service match flag. Results from Selective Service match for applicants who met criteria to be sent to match.
SELECT_SERVICE_REG_FLAG VARCHAR2 (1)
Results from student's request to be registered with Selective Service
INS_MATCH_FLAG VARCHAR2 (1)
Results from Immigration and Naturalization Service match for applicants who met criteria to be sent to match
INS_VERIFICATION_NUMBER NUMBER (15)
Identification number provided by Immigration and Naturalization Service indicating that primary verification was performed - No longer used
SEC_INS_MATCH_FLAG VARCHAR2 (1)
Results from Immigration and Naturalization Service match for applicants who were not matched on initial match
SEC_INS_VER_NUMBER NUMBER (15)
Identification number provided by Immigration and Naturalization Service indicating that secondary verification was performed
SSN_MATCH_FLAG VARCHAR2 (1)
Results from SSN match with Social Security Administration
SSA_CITIZENSHIP_FLAG VARCHAR2 (1)
Results from citizenship match with Social Security Administration
SSN_DATE_OF_DEATH DATE

Date of death provided for SSN from Social Security Administration
NSLDS_MATCH_FLAG VARCHAR2 (1)
Results of NSLDS match
VA_MATCH_FLAG VARCHAR2 (1)
Results of Veterans Affairs match
PRISONER_MATCH VARCHAR2 (1)
Indicates information regarding prisoner match
VERIFICATION_FLAG VARCHAR2 (1)
Indicates whether student is selected for verification
SUBSEQUENT_APP_FLAG VARCHAR2 (1)
Indicates that initial or renewal application with same SSN and name identifier as transaction was already present on CPS database.
APP_SOURCE_SITE_CODE VARCHAR2 (2)
Application source site code indicates origin of initial application and site location
TRAN_SOURCE_SITE_CODE VARCHAR2 (2)
Indicates origin of transaction and site location
DRN NUMBER (4)
Data Release Number will only be included when transaction was initiated at destination point.
TRAN_PROCESS_DATE DATE

Indicates date CPS computed transaction
CORRECTION_FLAGS VARCHAR2 (120)
Indicates correction done to specific SAR field. Each correction flag corresponds to specific SAR field.
COMPUTER_BATCH_NUMBER NUMBER (3)
Indicates batch number of transaction
HIGHLIGHT_FLAGS VARCHAR2 (120)
Indicates fields highlighted in boldface on SAR
PAID_EFC NUMBER (5)
Holds lower of primary or secondary EFC
PRIMARY_EFC NUMBER (5)
Primary 9 month EFC calculated for student based on SAR information provided by student.
SECONDARY_EFC NUMBER (5)
Secondary 9 month EFC calculated for student based on SAR information provided by student.
FED_PELL_GRANT_EFC_TYPE VARCHAR2 (1)
Identifies which EFC was placed in Paid EFC
PRIMARY_EFC_TYPE VARCHAR2 (1)
Identifies formula type used to calculate primary EFC
SEC_EFC_TYPE VARCHAR2 (1)
Identifies formula type used to calculate secondary EFC
PRIMARY_ALTERNATE_MONTH_1 NUMBER (5)
Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
PRIMARY_ALTERNATE_MONTH_2 NUMBER (5)
Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
PRIMARY_ALTERNATE_MONTH_3 NUMBER (5)
Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
PRIMARY_ALTERNATE_MONTH_4 NUMBER (5)
Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
PRIMARY_ALTERNATE_MONTH_5 NUMBER (5)
Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
PRIMARY_ALTERNATE_MONTH_6 NUMBER (5)
Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
PRIMARY_ALTERNATE_MONTH_7 NUMBER (5)
Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
PRIMARY_ALTERNATE_MONTH_8 NUMBER (5)
Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
PRIMARY_ALTERNATE_MONTH_10 NUMBER (5)
Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
PRIMARY_ALTERNATE_MONTH_11 NUMBER (5)
Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
PRIMARY_ALTERNATE_MONTH_12 NUMBER (5)
Primary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
SEC_ALTERNATE_MONTH_1 NUMBER (5)
Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
SEC_ALTERNATE_MONTH_2 NUMBER (5)
Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
SEC_ALTERNATE_MONTH_3 NUMBER (5)
Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
SEC_ALTERNATE_MONTH_4 NUMBER (5)
Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
SEC_ALTERNATE_MONTH_5 NUMBER (5)
Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
SEC_ALTERNATE_MONTH_6 NUMBER (5)
Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
SEC_ALTERNATE_MONTH_7 NUMBER (5)
Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
SEC_ALTERNATE_MONTH_8 NUMBER (5)
Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
SEC_ALTERNATE_MONTH_10 NUMBER (5)
Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
SEC_ALTERNATE_MONTH_11 NUMBER (5)
Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
SEC_ALTERNATE_MONTH_12 NUMBER (5)
Secondary alternate EFC used by FAO in determining eligibility based on periods of time other than 9 months
TOTAL_INCOME VARCHAR2 (7)
Student's total income
ALLOW_TOTAL_INCOME NUMBER (7)
Allowances against total income
STATE_TAX_ALLOW VARCHAR2 (7)
State and other tax allowance received by student
EMPLOYMENT_ALLOW NUMBER (7)
Employment allowance received by student
INCOME_PROTECTION_ALLOW NUMBER (7)
Income protection allowance received by student
AVAILABLE_INCOME VARCHAR2 (7)
Available income as calculated for student
CONTRIBUTION_FROM_AI VARCHAR2 (7)
Student's contribution from available income
DISCRETIONARY_NETWORTH VARCHAR2 (9)
Student's discretionary net worth
EFC_NETWORTH NUMBER (9)
EFC net worth as calculated by CPS
ASSET_PROTECT_ALLOW NUMBER (9)
Asset protection allowance calculated based on student's assets
PARENTS_CONT_FROM_ASSETS VARCHAR2 (7)
Parents' contribution from assets as calculated by CPS
ADJUSTED_AVAILABLE_INCOME VARCHAR2 (7)
Adjusted available income as calculated by CPS
TOTAL_STUDENT_CONTRIBUTION NUMBER (7)
Total student contribution as calculated by CPS
TOTAL_PARENT_CONTRIBUTION NUMBER (7)
Total parent contribution as calculated by CPS based on financial information provided by student
PARENTS_CONTRIBUTION NUMBER (7)
Parents' contribution as calculated by CPS based on financial information provided by student on FAFSA
STUDENT_TOTAL_INCOME VARCHAR2 (7)
Student's total income as calculated by CPS based on financial information provided by student on FAFSA
SATI VARCHAR2 (7)
Student's allowance against total income as calculated by CPS based on financial information provided by student on FAFSA
SIC NUMBER (7)
Dependent student's income contribution as calculated by CPS based on financial information provided by student on FAFSA
SDNW VARCHAR2 (9)
Student's discretionary net worth as calculated by CPS based on financial information provided by student on FAFSA
SCA VARCHAR2 (7)
Student's contribution from assets as calculated by CPS based on financial information provided by student on FAFSA
FTI VARCHAR2 (7)
FISAP total income as calculated by CPS based on financial information provided by student on FAFSA
SECTI VARCHAR2 (7)
Secondary total income as calculated by CPS based on financial information provided by student on FAFSA
SECATI NUMBER (7)
Secondary allowance against total income as calculated by CPS based on financial information provided by student on FAFSA
SECSTX VARCHAR2 (7)
Secondary state tax allowance as calculated by CPS based on financial information provided by student on FAFSA
SECEA NUMBER (7)
Secondary employment allowance as calculated by CPS based on financial information provided by student on FAFSA
SECIPA NUMBER (7)
Secondary income protection allowance as calculated by CPS based on financial information provided by student on FAFSA
SECAI VARCHAR2 (7)
Secondary available income as calculated by CPS based on financial information provided by student on FAFSA
SECCAI VARCHAR2 (7)
Secondary contribution from available income as calculated by CPS based on financial information provided by student on FAFSA
SECDNW VARCHAR2 (9)
Secondary discretionary net worth as calculated by CPS based on financial information provided by student on FAFSA
SECNW NUMBER (9)
Secondary net worth as calculated by CPS based on financial information provided by student on FAFSA
SECAPA NUMBER (9)
Secondary asset protection allowance as calculated by CPS based on financial information provided by student on FAFSA
SECPCA VARCHAR2 (7)
Secondary parents' contribution from assets as calculated by CPS based on financial information provided by student on FAFSA
SECAAI VARCHAR2 (7)
Secondary adjusted available income as calculated by CPS based on financial information provided by student on FAFSA
SECTSC NUMBER (7)
Secondary total student contribution as calculated by CPS based on financial information provided by student on FAFSA
SECTPC NUMBER (7)
Secondary total parent contribution as calculated by CPS based on financial information provided by student on FAFSA
SECPC NUMBER (7)
Secondary parent contribution as calculated by CPS based on financial information provided by student on FAFSA
SECSTI VARCHAR2 (7)
Secondary student's total income as calculated by CPS based on financial information provided by student on FAFSA
SECSATI VARCHAR2 (7)
Secondary student's allowance against total income as calculated by CPS based on financial information provided by student on FAFSA
SECSIC NUMBER (7)
Secondary student's dependent income contribution as calculated by CPS based on financial information provided by student on FAFSA
SECSDNW VARCHAR2 (9)
Secondary student's discretionary net worth as calculated by CPS based on financial information provided by student on FAFSA
SECSCA VARCHAR2 (7)
Secondary student's contribution from assets as calculated by CPS based on financial information provided by student on FAFSA
SECFTI VARCHAR2 (7)
Secondary FISAP total income as calculated by CPS based on financial information provided by student on FAFSA
A_CITIZENSHIP VARCHAR2 (1)
Citizenship status assumed for student while processing FAFSA application
A_STUDENT_MARITAL_STATUS VARCHAR2 (1)
Marital status assumed for student while processing FAFSA application
A_STUDENT_AGI VARCHAR2 (6)
Adjusted gross income assumed for student while processing application
A_S_US_TAX_PAID NUMBER (5)
Assumed US tax student paid
A_S_INCOME_WORK VARCHAR2 (6)
Student's income from work assumed for processing
A_SPOUSE_INCOME_WORK VARCHAR2 (6)
Spouse's income from work assumed for processing
A_S_TOTAL_WSC NUMBER (5)
Student's income from Worksheet C assumed for processing
A_DATE_OF_BIRTH VARCHAR2 (1)
Indicates whether student's date of birth was assumed to be prior to cut-off date
A_STUDENT_MARRIED VARCHAR2 (1)
Indicates whether student is assumed to be married
A_HAVE_CHILDREN VARCHAR2 (1)
Indicates whether student is assumed to have children to support
A_S_HAVE_DEPENDENTS VARCHAR2 (1)
Indicates whether student is assumed to have dependents other than children while processing student's FAFSA application
A_VA_STATUS VARCHAR2 (1)
Indicates assumed veteran status
A_S_NUM_IN_FAMILY NUMBER (2)
Assumed number of people in student's family while processing
A_S_NUM_IN_COLLEGE NUMBER (1)
Assumed number of student's family members in college
A_P_MARITAL_STATUS VARCHAR2 (1)
Assumed marital status of parents
A_FATHER_SSN VARCHAR2 (9)
Father's assumed SSN
A_MOTHER_SSN VARCHAR2 (9)
Mother's assumed SSN
A_PARENTS_NUM_FAMILY NUMBER (2)
Assumed number of family members in parents' family
A_PARENTS_NUM_COLLEGE NUMBER (1)
Assumed number of family members in college from parents' family
A_PARENTS_AGI VARCHAR2 (6)
Assumed parents' annual gross income for application processing
A_P_US_TAX_PAID NUMBER (6)
Assumed US tax parents paid
A_F_WORK_INCOME VARCHAR2 (6)
Assumed father's income earned from work
A_M_WORK_INCOME VARCHAR2 (6)
Assumed mother's income from work
A_P_TOTAL_WSC NUMBER (5)
Assumed parents' total from Worksheet C
COMMENT_CODES VARCHAR2 (60)
Comments provided by CPS to further communicate important results and processing information
SAR_ACK_COMM_CODE VARCHAR2 (20)
SAR acknowledgment comment codes. Ten 2-digit codes for comments appearing on SAR. Codes are entered from left to right by CPS, and unused positions are filled with zeros.
PELL_GRANT_ELIG_FLAG VARCHAR2 (1)
Indicates transaction has been determined eligible for federal Pell grant
REPROCESS_REASON_CODE VARCHAR2 (2)
Code to identify why ISIR was reprocessed by CPS, which releases definition of codes
DUPLICATE_DATE DATE

CPS process date for duplicate transaction requested
ISIR_TRANSACTION_TYPE VARCHAR2 (1)
Indicates from where transaction was generated. Values are Initial Application, Automatic ISIR, Correction, Duplicate Request, or Renewal Application.
FEDRAL_SCHL_CODE_INDICATOR VARCHAR2 (1)
Identifies one of colleges that initiated electronic action to create transaction
MULTI_SCHOOL_CODE_FLAGS VARCHAR2 (6)
Each byte of field corresponds to 6 federal school codes choices.
DUP_SSN_INDICATOR VARCHAR2 (1)
Indicates if another filer is using original SSN in original SSN field. Set to Y if more than one person uses SSN.
NSLDS_TRANSACTION_NUM NUMBER (2)
Holds latest transaction number for which NSLDS data was updated
NSLDS_DATABASE_RESULTS_F VARCHAR2 (1)
Indicates matching record was found in NSLDS database
NSLDS_F VARCHAR2 (1)
Flag set by NSLDS
NSLDS_PELL_OVERPAY_F VARCHAR2 (1)
NSLDS Pell overpayment flag. Indicates if there was overpayment of Pell grant.
NSLDS_PELL_OVERPAY_CONTACT VARCHAR2 (8)
Indicates contact school code for Pell overpayment
NSLDS_SEOG_OVERPAY_F VARCHAR2 (1)
NSLDS SEOG overpayment flag. Indicates if overpayment was made for Education Opportunity Grant.
NSLDS_SEOG_OVERPAY_CONTACT VARCHAR2 (8)
Indicates contact school for SEOG overpayment
NSLDS_PERKINS_OVERPAY_F VARCHAR2 (1)
Indicates if overpayment was made for Perkins grant
NSLDS_PERKINS_OVERPAY_CNTCT VARCHAR2 (8)
Contact school for Perkins overpayment
NSLDS_DEFAULTED_LOAN_F VARCHAR2 (1)
Indicates if student has defaulted NSLDS loan
NSLDS_DISCHARGED_LOAN_F VARCHAR2 (1)
NSLDS discharged loan flag
NSLDS_SATIS_REPAY_F VARCHAR2 (1)
Indicates loan had satisfactory repayment
NSLDS_ACT_BANKRUPTCY_F VARCHAR2 (1)
Indicates if student is bankrupt
NSLDS_AGG_SUBSZ_OUT_PRIN_BAL VARCHAR2 (6)
NSLDS aggregate subsidized outstanding principal balance amount
NSLDS_AGG_UNSBZ_OUT_PRIN_BAL VARCHAR2 (6)
NSLDS aggregate unsubsidized outstanding principal balance amount
NSLDS_AGG_COMB_OUT_PRIN_BAL VARCHAR2 (6)
NSLDS aggregate combined outstanding principal balance amount
NSLDS_AGG_CONS_OUT_PRIN_BAL VARCHAR2 (6)
NSLDS aggregate consolidated outstanding principal balance amount
NSLDS_AGG_SUBSZ_PEND_DISMNT VARCHAR2 (6)
NSLDS aggregate subsidized pending disbursement amount
NSLDS_AGG_UNSBZ_PEND_DISMNT VARCHAR2 (6)
NSLDS aggregate unsubsidized pending disbursement amount
NSLDS_AGG_COMB_PEND_DISMNT VARCHAR2 (6)
NSLDS aggregate combined pending disbursement amount
NSLDS_AGG_SUBSZ_TOTAL VARCHAR2 (6)
NSLDS aggregate subsidized total amount
NSLDS_AGG_UNSBZ_TOTAL VARCHAR2 (6)
NSLDS aggregate unsubsidized total amount
NSLDS_AGG_COMB_TOTAL VARCHAR2 (6)
NSLDS aggregate combined total amount
NSLDS_AGG_CONSD_TOTAL VARCHAR2 (6)
NSLDS aggregate consolidated total amount
NSLDS_PERKINS_OUT_BAL VARCHAR2 (6)
NSLDS Perkins outstanding balance amount
NSLDS_PERKINS_CUR_YR_DISMNT VARCHAR2 (6)
NSLDS Perkins current year disbursement amount
NSLDS_DEFAULT_LOAN_CHNG_F VARCHAR2 (1)
NSLDS defaulted loan change flag
NSLDS_DISCHGED_LOAN_CHNG_F VARCHAR2 (1)
NSLDS discharged loan change flag
NSLDS_SATIS_REPAY_CHNG_F VARCHAR2 (1)
NSLDS satisfactory repayment change flag
NSLDS_ACT_BNKRUPT_CHNG_F VARCHAR2 (1)
NSLDS active bankruptcy flag
NSLDS_OVERPAY_CHNG_F VARCHAR2 (1)
NSLDS overpayments change flag
NSLDS_AGG_LOAN_CHNG_F VARCHAR2 (1)
NSLDS aggregate loan change flag
NSLDS_PERKINS_LOAN_CHNG_F VARCHAR2 (1)
NSLDS Perkins loan change flag
NSLDS_PELL_PAYMNT_CHNG_F VARCHAR2 (1)
NSLDS Pell loan change flag
NSLDS_ADDTNL_PELL_F VARCHAR2 (1)
NSLDS additional Pell flag
NSLDS_ADDTNL_LOAN_F VARCHAR2 (1)
NSLDS additional loan flag
DIRECT_LOAN_MAS_PROM_NT_F VARCHAR2 (1)
Direct Loan master promissory flag
NSLDS_PELL_SEQ_NUM_1 NUMBER (2)
NSLDS Pell sequence number (1)
NSLDS_PELL_VERIFY_F_1 VARCHAR2 (3)
NSLDS Pell verification flag (1)
NSLDS_PELL_EFC_1 NUMBER (6)
NSLDS Pell EFC (1)
NSLDS_PELL_SCHOOL_CODE_1 NUMBER (8)
NSLDS Pell school code (1)
NSLDS_PELL_TRANSCN_NUM_1 NUMBER (2)
NSLDS Pell transaction number (1)
NSLDS_PELL_LAST_UPDT_DT_1 VARCHAR2 (8)
Last update date of NSLDS Pell value (1)
NSLDS_PELL_SCHEDULED_AMT_1 NUMBER (6)
NSLDS Pell scheduled amount (1)
NSLDS_PELL_AMT_PAID_TODT_1 NUMBER (6)
NSLDS Pell amount paid to date (1)
NSLDS_PELL_REMNG_AMT_1 NUMBER (6)
NSLDS Pell remaining amount (1)
NSLDS_PELL_PC_SCHD_AWD_US_1 NUMBER (5)
NSLDS Pell percent scheduled award used (1)
NSLDS_PELL_AWARD_AMT_1 NUMBER (6)
NSLDS Pell award amount (1)
NSLDS_PELL_SEQ_NUM_2 NUMBER (2)
NSLDS Pell sequence number (2)
NSLDS_PELL_VERIFY_F_2 VARCHAR2 (3)
NSLDS Pell verification flag (2)
NSLDS_PELL_EFC_2 NUMBER (6)
NSLDS Pell EFC (2)
NSLDS_PELL_SCHOOL_CODE_2 NUMBER (8)
NSLDS Pell school code (2)
NSLDS_PELL_TRANSCN_NUM_2 NUMBER (2)
NSLDS Pell transaction number (2)
NSLDS_PELL_LAST_UPDT_DT_2 VARCHAR2 (8)
Last update date of NSLDS Pell value (2)
NSLDS_PELL_SCHEDULED_AMT_2 NUMBER (6)
NSLDS Pell scheduled amount (2)
NSLDS_PELL_AMT_PAID_TODT_2 NUMBER (6)
NSLDS Pell amount paid to date (2)
NSLDS_PELL_REMNG_AMT_2 NUMBER (6)
NSLDS Pell remaining amount (2)
NSLDS_PELL_PC_SCHD_AWD_US_2 NUMBER (5)
NSLDS Pell percent scheduled award used (2)
NSLDS_PELL_AWARD_AMT_2 NUMBER (6)
NSLDS Pell award amount (2)
NSLDS_PELL_SEQ_NUM_3 NUMBER (2)
NSDLS Pell sequence number (3)
NSLDS_PELL_VERIFY_F_3 VARCHAR2 (3)
NSLDS Pell verification flag (3)
NSLDS_PELL_EFC_3 NUMBER (6)
NSLDS Pell effective family contribution (3)
NSLDS_PELL_SCHOOL_CODE_3 NUMBER (8)
NSDLS Pell school code (3)
NSLDS_PELL_TRANSCN_NUM_3 NUMBER (2)
NSDLS Pell transaction number (3)
NSLDS_PELL_LAST_UPDT_DT_3 VARCHAR2 (8)
Last update date of NSLDS Pell value (3)
NSLDS_PELL_SCHEDULED_AMT_3 NUMBER (6)
NSDLS Pell scheduled amount (3)
NSLDS_PELL_AMT_PAID_TODT_3 NUMBER (6)
NSDLS Pell amount paid to date (3)
NSLDS_PELL_REMNG_AMT_3 NUMBER (6)
NSDLS Pell remaining amount (3)
NSLDS_PELL_PC_SCHD_AWD_US_3 NUMBER (5)
NSLDS Pell percent scheduled award used (3)
NSLDS_PELL_AWARD_AMT_3 NUMBER (6)
NSDLS Pell award amount (3)
NSLDS_LOAN_SEQ_NUM_1 NUMBER (2)
NSLDS loan (1) sequence number
NSLDS_LOAN_TYPE_CODE_1 VARCHAR2 (1)
NSLDS loan (1) type code
NSLDS_LOAN_CHNG_F_1 VARCHAR2 (1)
NSLDS loan (1) change flag
NSLDS_LOAN_PROG_CODE_1 VARCHAR2 (2)
NSLDS loan (1) program code
NSLDS_LOAN_NET_AMNT_1 NUMBER (6)
NSLDS loan (1) net amount
NSLDS_LOAN_CUR_ST_CODE_1 VARCHAR2 (2)
NSLDS loan (1) current status code
NSLDS_LOAN_CUR_ST_DATE_1 VARCHAR2 (8)
NSLDS loan (1) current status date
NSLDS_LOAN_AGG_PR_BAL_1 VARCHAR2 (6)
NSLDS loan (1) aggregate principal balance amount
NSLDS_LOAN_OUT_PR_BAL_DT_1 VARCHAR2 (8)
NSLDS loan (1) outstanding principal balance date
NSLDS_LOAN_BEGIN_DT_1 VARCHAR2 (8)
NSLDS loan (1) begin date
NSLDS_LOAN_END_DT_1 VARCHAR2 (8)
NSLDS loan (1) end date
NSLDS_LOAN_GA_CODE_1 VARCHAR2 (3)
NSLDS loan (1) GA code
NSLDS_LOAN_CONT_TYPE_1 VARCHAR2 (3)
NSLDS loan (1) contact type
NSLDS_LOAN_SCHOL_CODE_1 VARCHAR2 (8)
NSLDS loan (1) school code
NSLDS_LOAN_CONT_CODE_1 VARCHAR2 (8)
NSLDS loan (1) contact code
NSLDS_LOAN_GRADE_LVL_1 VARCHAR2 (3)
NSLDS loan (1) grade level
NSLDS_LOAN_XTR_UNSBZ_LN_F_1 VARCHAR2 (1)
NSLDS loan (1) extra unsubsidized loan flag
NSLDS_LOAN_CAPITAL_INT_F_1 VARCHAR2 (1)
NSLDS loan (1) capitalized interest flag
NSLDS_LOAN_SEQ_NUM_2 NUMBER (2)
NSLDS loan (2) sequence number
NSLDS_LOAN_TYPE_CODE_2 VARCHAR2 (1)
NSLDS loan (2) type code
NSLDS_LOAN_CHNG_F_2 VARCHAR2 (1)
NSLDS loan (2) change flag
NSLDS_LOAN_PROG_CODE_2 VARCHAR2 (2)
NSLDS loan (2) program code
NSLDS_LOAN_NET_AMNT_2 NUMBER (6)
NSLDS loan (2) net amount
NSLDS_LOAN_CUR_ST_CODE_2 VARCHAR2 (2)
NSLDS loan (2) current status code
NSLDS_LOAN_CUR_ST_DATE_2 VARCHAR2 (8)
NSLDS loan (2) current status date
NSLDS_LOAN_AGG_PR_BAL_2 VARCHAR2 (6)
NSLDS loan (2) aggregate principal balance amount
NSLDS_LOAN_OUT_PR_BAL_DT_2 VARCHAR2 (8)
NSLDS loan (2) outstanding principal balance date
NSLDS_LOAN_BEGIN_DT_2 VARCHAR2 (8)
NSLDS loan (2) begin date
NSLDS_LOAN_END_DT_2 VARCHAR2 (8)
NSLDS loan (2) end date
NSLDS_LOAN_GA_CODE_2 VARCHAR2 (3)
NSLDS loan (2) GA code
NSLDS_LOAN_CONT_TYPE_2 VARCHAR2 (3)
NSLDS loan (2) contact type
NSLDS_LOAN_SCHOL_CODE_2 VARCHAR2 (8)
NSLDS loan (2) school code
NSLDS_LOAN_CONT_CODE_2 VARCHAR2 (8)
NSLDS loan (2) contact code
NSLDS_LOAN_GRADE_LVL_2 VARCHAR2 (3)
NSLDS loan (2) grade level
NSLDS_LOAN_XTR_UNSBZ_LN_F_2 VARCHAR2 (1)
NSLDS loan (2) extra unsubsidized loan flag
NSLDS_LOAN_CAPITAL_INT_F_2 VARCHAR2 (1)
NSLDS loan (2) capitalized interest flag
NSLDS_LOAN_SEQ_NUM_3 NUMBER (2)
NSLDS loan (3) sequence number
NSLDS_LOAN_TYPE_CODE_3 VARCHAR2 (1)
NSLDS loan (3) type code
NSLDS_LOAN_CHNG_F_3 VARCHAR2 (1)
NSLDS loan (3) change flag
NSLDS_LOAN_PROG_CODE_3 VARCHAR2 (2)
NSLDS loan (3) program code
NSLDS_LOAN_NET_AMNT_3 NUMBER (6)
NSLDS loan (3) net amount
NSLDS_LOAN_CUR_ST_CODE_3 VARCHAR2 (2)
NSLDS loan (3) current status code
NSLDS_LOAN_CUR_ST_DATE_3 VARCHAR2 (8)
NSLDS loan (3) current status date
NSLDS_LOAN_AGG_PR_BAL_3 VARCHAR2 (6)
NSLDS loan (3) aggregate principal balance amount
NSLDS_LOAN_OUT_PR_BAL_DT_3 VARCHAR2 (8)
NSLDS loan (3) outstanding principal balance date
NSLDS_LOAN_BEGIN_DT_3 VARCHAR2 (8)
NSLDS loan (3) begin date
NSLDS_LOAN_END_DT_3 VARCHAR2 (8)
NSLDS loan (3) end date
NSLDS_LOAN_GA_CODE_3 VARCHAR2 (3)
NSLDS loan (3) GA code
NSLDS_LOAN_CONT_TYPE_3 VARCHAR2 (3)
NSLDS loan (3) contact type
NSLDS_LOAN_SCHOL_CODE_3 VARCHAR2 (8)
NSLDS loan (3) school code
NSLDS_LOAN_CONT_CODE_3 VARCHAR2 (8)
NSLDS loan (3) contact code
NSLDS_LOAN_GRADE_LVL_3 VARCHAR2 (3)
NSLDS loan (3) grade level
NSLDS_LOAN_XTR_UNSBZ_LN_F_3 VARCHAR2 (1)
NSLDS loan (3) extra unsubsidized loan flag
NSLDS_LOAN_CAPITAL_INT_F_3 VARCHAR2 (1)
NSLDS loan (3) capitalized interest flag
NSLDS_LOAN_SEQ_NUM_4 NUMBER (2)
NSLDS loan (4) sequence number
NSLDS_LOAN_TYPE_CODE_4 VARCHAR2 (1)
NSLDS loan (4) type code
NSLDS_LOAN_CHNG_F_4 VARCHAR2 (1)
NSLDS loan (4) change flag
NSLDS_LOAN_PROG_CODE_4 VARCHAR2 (2)
NSLDS loan (4) program code
NSLDS_LOAN_NET_AMNT_4 NUMBER (6)
NSLDS loan (4) net amount
NSLDS_LOAN_CUR_ST_CODE_4 VARCHAR2 (2)
NSLDS loan (4) current status code
NSLDS_LOAN_CUR_ST_DATE_4 VARCHAR2 (8)
NSLDS loan (4) current status date
NSLDS_LOAN_AGG_PR_BAL_4 VARCHAR2 (6)
NSLDS loan (4) aggregate principal balance amount
NSLDS_LOAN_OUT_PR_BAL_DT_4 VARCHAR2 (8)
NSLDS loan (4) outstanding principal balance date
NSLDS_LOAN_BEGIN_DT_4 VARCHAR2 (8)
NSLDS loan (4) begin date
NSLDS_LOAN_END_DT_4 VARCHAR2 (8)
NSLDS loan (4) end date
NSLDS_LOAN_GA_CODE_4 VARCHAR2 (3)
NSLDS loan (4) GA code
NSLDS_LOAN_CONT_TYPE_4 VARCHAR2 (3)
NSLDS loan (4) contact type
NSLDS_LOAN_SCHOL_CODE_4 VARCHAR2 (8)
NSLDS loan (4) school code
NSLDS_LOAN_CONT_CODE_4 VARCHAR2 (8)
NSLDS loan (4) contact code
NSLDS_LOAN_GRADE_LVL_4 VARCHAR2 (3)
NSLDS loan (4) grade level
NSLDS_LOAN_XTR_UNSBZ_LN_F_4 VARCHAR2 (1)
NSLDS loan (4) extra unsubsidized loan flag
NSLDS_LOAN_CAPITAL_INT_F_4 VARCHAR2 (1)
NSLDS loan (4) capitalized interest flag
NSLDS_LOAN_SEQ_NUM_5 NUMBER (2)
NSLDS loan (5) sequence number
NSLDS_LOAN_TYPE_CODE_5 VARCHAR2 (1)
NSLDS loan (5) type code
NSLDS_LOAN_CHNG_F_5 VARCHAR2 (1)
NSLDS loan (5) change flag
NSLDS_LOAN_PROG_CODE_5 VARCHAR2 (2)
NSLDS loan (5) program code
NSLDS_LOAN_NET_AMNT_5 NUMBER (6)
NSLDS loan (5) net amount
NSLDS_LOAN_CUR_ST_CODE_5 VARCHAR2 (2)
NSLDS loan (5) current status code
NSLDS_LOAN_CUR_ST_DATE_5 VARCHAR2 (8)
NSLDS loan (5) current status date
NSLDS_LOAN_AGG_PR_BAL_5 VARCHAR2 (6)
NSLDS loan (5) aggregate principal balance amount
NSLDS_LOAN_OUT_PR_BAL_DT_5 VARCHAR2 (8)
NSLDS loan (5) outstanding principal balance date
NSLDS_LOAN_BEGIN_DT_5 VARCHAR2 (8)
NSLDS loan (5) begin date
NSLDS_LOAN_END_DT_5 VARCHAR2 (8)
NSLDS loan (5) end date
NSLDS_LOAN_GA_CODE_5 VARCHAR2 (3)
NSLDS loan (5) GA code
NSLDS_LOAN_CONT_TYPE_5 VARCHAR2 (3)
NSLDS loan (5) contact type
NSLDS_LOAN_SCHOL_CODE_5 VARCHAR2 (8)
NSLDS loan (5) school code
NSLDS_LOAN_CONT_CODE_5 VARCHAR2 (8)
NSLDS loan (5) contact code
NSLDS_LOAN_GRADE_LVL_5 VARCHAR2 (3)
NSLDS loan (5) grade level
NSLDS_LOAN_XTR_UNSBZ_LN_F_5 VARCHAR2 (1)
NSLDS loan (5) extra unsubsidized loan flag
NSLDS_LOAN_CAPITAL_INT_F_5 VARCHAR2 (1)
NSLDS loan (5) capitalized interest flag
NSLDS_LOAN_SEQ_NUM_6 NUMBER (2)
NSLDS loan (6) sequence number
NSLDS_LOAN_TYPE_CODE_6 VARCHAR2 (1)
NSLDS loan (6) type code
NSLDS_LOAN_CHNG_F_6 VARCHAR2 (1)
NSLDS loan (6) change flag
NSLDS_LOAN_PROG_CODE_6 VARCHAR2 (2)
NSLDS loan (6) program code
NSLDS_LOAN_NET_AMNT_6 NUMBER (6)
NSLDS loan (6) net amount
NSLDS_LOAN_CUR_ST_CODE_6 VARCHAR2 (2)
NSLDS loan (6) current status code
NSLDS_LOAN_CUR_ST_DATE_6 VARCHAR2 (8)
NSLDS loan (6) current status date
NSLDS_LOAN_AGG_PR_BAL_6 VARCHAR2 (6)
NSLDS loan (6) aggregate principal balance amount
NSLDS_LOAN_OUT_PR_BAL_DT_6 VARCHAR2 (8)
NSLDS loan (6) outstanding principal balance date
NSLDS_LOAN_BEGIN_DT_6 VARCHAR2 (8)
NSLDS loan (6) begin date
NSLDS_LOAN_END_DT_6 VARCHAR2 (8)
NSLDS loan (6) end date
NSLDS_LOAN_GA_CODE_6 VARCHAR2 (3)
NSLDS loan (6) GA code
NSLDS_LOAN_CONT_TYPE_6 VARCHAR2 (3)
NSLDS loan (6) contact type
NSLDS_LOAN_SCHOL_CODE_6 VARCHAR2 (8)
NSLDS loan (6) school code
NSLDS_LOAN_CONT_CODE_6 VARCHAR2 (8)
NSLDS loan (6) contact code
NSLDS_LOAN_GRADE_LVL_6 VARCHAR2 (3)
NSLDS loan (6) grade level
NSLDS_LOAN_XTR_UNSBZ_LN_F_6 VARCHAR2 (1)
NSLDS loan (6) extra unsubsidized loan flag
NSLDS_LOAN_CAPITAL_INT_F_6 VARCHAR2 (1)
NSLDS loan (6) capitalized interest flag
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Standard Who column for concurrent programs
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column for concurrent programs
PROGRAM_ID NUMBER (15)
Standard Who column for concurrent programs
PROGRAM_UPDATE_DATE DATE

Standard Who column for concurrent programs
ORG_ID NUMBER (15)
Operating unit identifier
NSLDS_LOAN_LAST_D_AMT_1 NUMBER (15)
NSLDS Loan (1) Last Disbursement Amount
NSLDS_LOAN_LAST_D_DATE_1 DATE

NSLDS Loan (1) Last Disbursement Date
NSLDS_LOAN_LAST_D_AMT_2 NUMBER (15)
NSLDS Loan (2) Last Disbursement Amount
NSLDS_LOAN_LAST_D_DATE_2 DATE

NSLDS Loan (2) Last Disbursement Date
NSLDS_LOAN_LAST_D_AMT_3 NUMBER (15)
NSLDS Loan (3) Last Disbursement Amount
NSLDS_LOAN_LAST_D_DATE_3 DATE

NSLDS Loan (3) Last Disbursement Date
NSLDS_LOAN_LAST_D_AMT_4 NUMBER (15)
NSLDS Loan (4) Last Disbursement Amount
NSLDS_LOAN_LAST_D_DATE_4 DATE

NSLDS Loan (4) Last Disbursement Date
NSLDS_LOAN_LAST_D_AMT_5 NUMBER (15)
NSLDS Loan (5) Last Disbursement Amount
NSLDS_LOAN_LAST_D_DATE_5 DATE

NSLDS Loan (5) Last Disbursement Date
NSLDS_LOAN_LAST_D_AMT_6 NUMBER (15)
NSLDS Loan (6) Last Disbursement Amount
NSLDS_LOAN_LAST_D_DATE_6 DATE

NSLDS Loan (6) Last Disbursement Date
VERIF_TRACK_FLAG VARCHAR2 (30)
Verification Tracking Flag
FAFSA_DATA_VERIFY_FLAGS VARCHAR2 (255)
Stores the FAFSA Data Verification related flags
REJECT_OVERRIDE_A VARCHAR2 (30)
Indicates the Reject Override A Status
REJECT_OVERRIDE_C VARCHAR2 (30)
Indicates the Reject Override C Status
PARENT_MARITAL_STATUS_DATE DATE

Stores the parents Marital Status date
DLP_MASTER_PROM_NOTE_FLAG VARCHAR2 (30)
Indicates the Direct Loan Plus Master Promissory Note Flag
FATHER_FIRST_NAME_INITIAL_TXT VARCHAR2 (1)
Father's/Stepfather's First Name Initial
FATHER_STEP_FATHER_BIRTH_DATE DATE

Father's/Stepfather's Date of Birth
MOTHER_FIRST_NAME_INITIAL_TXT VARCHAR2 (1)
Mother's/Stepmother's First Name Initial
MOTHER_STEP_MOTHER_BIRTH_DATE DATE

Mother's/Stepmother's Date of Birth
PARENTS_EMAIL_ADDRESS_TXT VARCHAR2 (50)
Parent's E-mail Address
ADDRESS_CHANGE_TYPE VARCHAR2 (1)
Address Only Change Flag
CPS_PUSHED_ISIR_FLAG VARCHAR2 (1)
This Flag is set to identify transactions that are automatically sent to schools
ELECTRONIC_TRANSACTION_TYPE VARCHAR2 (1)
To indicate if the school receiving the ISIR submitted input to generate the ISIR transaction, or did not generate the transaction but was listed on the record. It also indicates whether the type of ISIR is a daily, requested, or pushed ISIR.
SAR_C_CHANGE_TYPE VARCHAR2 (1)
This Flag is set to identify SAR changes
FATHER_SSN_MATCH_TYPE VARCHAR2 (1)
To indicate the Father's/Stepfather' results from SSN Match with Social Security Administration.
MOTHER_SSN_MATCH_TYPE VARCHAR2 (1)
To indicate the Mother's/Stepmother's results from SSN Match with Social Security Administration.
SUBSIDIZED_LOAN_LIMIT_TYPE VARCHAR2 (1)
Subsidized Loan Limit Flag
COMBINED_LOAN_LIMIT_TYPE VARCHAR2 (1)
Combined Loan Limit Flag
REJECT_OVERRIDE_G_FLAG VARCHAR2 (1)
Reject Override G Flag
DHS_VERIFICATION_NUM_TXT VARCHAR2 (15)
Identification Number provided by the Department of Homeland Securityindicating that primary verification wasperformed.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SI_ID
,      BATCH_YEAR
,      TRANSACTION_NUM
,      RECORD_STATUS
,      SSN_NAME_CHANGE
,      ORIGINAL_SSN
,      ORIG_NAME_ID
,      CURRENT_SSN
,      LAST_NAME
,      FIRST_NAME
,      MIDDLE_INITIAL
,      PERM_MAIL_ADD
,      PERM_CITY
,      PERM_STATE
,      PERM_ZIP_CODE
,      DATE_OF_BIRTH
,      PHONE_NUMBER
,      DRIVER_LICENSE_NUMBER
,      DRIVER_LICENSE_STATE
,      CITIZENSHIP_STATUS
,      ALIEN_REG_NUMBER
,      S_MARITAL_STATUS
,      S_MARITAL_STATUS_DATE
,      SUMM_ENRL_STATUS
,      FALL_ENRL_STATUS
,      WINTER_ENRL_STATUS
,      SPRING_ENRL_STATUS
,      SUMM2_ENRL_STATUS
,      FATHERS_HIGHEST_EDU_LEVEL
,      MOTHERS_HIGHEST_EDU_LEVEL
,      S_STATE_LEGAL_RESIDENCE
,      LEGAL_RESIDENCE_BEFORE_DATE
,      S_LEGAL_RESD_DATE
,      SS_R_U_MALE
,      SELECTIVE_SERVICE_REG
,      DEGREE_CERTIFICATION
,      GRADE_LEVEL_IN_COLLEGE
,      HIGH_SCHOOL_DIPLOMA_GED
,      FIRST_BACHELOR_DEG_BY_DATE
,      INTEREST_IN_LOAN
,      INTEREST_IN_STUD_EMPLOYMENT
,      DRUG_OFFENCE_CONVICTION
,      S_TAX_RETURN_STATUS
,      S_TYPE_TAX_RETURN
,      S_ELIG_1040EZ
,      S_ADJUSTED_GROSS_INCOME
,      S_FED_TAXES_PAID
,      S_EXEMPTIONS
,      S_INCOME_FROM_WORK
,      SPOUSE_INCOME_FROM_WORK
,      S_TOA_AMT_FROM_WSA
,      S_TOA_AMT_FROM_WSB
,      S_TOA_AMT_FROM_WSC
,      S_INVESTMENT_NETWORTH
,      S_BUSI_FARM_NETWORTH
,      S_CASH_SAVINGS
,      VA_MONTHS
,      VA_AMOUNT
,      STUD_DOB_BEFORE_DATE
,      DEG_BEYOND_BACHELOR
,      S_MARRIED
,      S_HAVE_CHILDREN
,      LEGAL_DEPENDENTS
,      ORPHAN_WARD_OF_COURT
,      S_VETERAN
,      P_MARITAL_STATUS
,      FATHER_SSN
,      F_LAST_NAME
,      MOTHER_SSN
,      M_LAST_NAME
,      P_NUM_FAMILY_MEMBER
,      P_NUM_IN_COLLEGE
,      P_STATE_LEGAL_RESIDENCE
,      P_STATE_LEGAL_RES_BEFORE_DT
,      P_LEGAL_RES_DATE
,      AGE_OLDER_PARENT
,      P_TAX_RETURN_STATUS
,      P_TYPE_TAX_RETURN
,      P_ELIG_1040AEZ
,      P_ADJUSTED_GROSS_INCOME
,      P_TAXES_PAID
,      P_EXEMPTIONS
,      F_INCOME_WORK
,      M_INCOME_WORK
,      P_INCOME_WSA
,      P_INCOME_WSB
,      P_INCOME_WSC
,      P_INVESTMENT_NETWORTH
,      P_BUSINESS_NETWORTH
,      P_CASH_SAVING
,      S_NUM_FAMILY_MEMBERS
,      S_NUM_IN_COLLEGE
,      FIRST_COLLEGE
,      FIRST_HOUSE_PLAN
,      SECOND_COLLEGE
,      SECOND_HOUSE_PLAN
,      THIRD_COLLEGE
,      THIRD_HOUSE_PLAN
,      FOURTH_COLLEGE
,      FOURTH_HOUSE_PLAN
,      FIFTH_COLLEGE
,      FIFTH_HOUSE_PLAN
,      SIXTH_COLLEGE
,      SIXTH_HOUSE_PLAN
,      DATE_APP_COMPLETED
,      SIGNED_BY
,      PREPARER_SSN
,      PREPARER_EMP_ID_NUMBER
,      PREPARER_SIGN
,      TRANSACTION_RECEIPT_DATE
,      DEPENDENCY_OVERRIDE_IND
,      FAA_FEDRAL_SCHL_CODE
,      FAA_ADJUSTMENT
,      INPUT_RECORD_TYPE
,      SERIAL_NUMBER
,      BATCH_NUMBER
,      EARLY_ANALYSIS_FLAG
,      APP_ENTRY_SOURCE_CODE
,      ETI_DESTINATION_CODE
,      REJECT_OVERRIDE_B
,      REJECT_OVERRIDE_N
,      REJECT_OVERRIDE_W
,      ASSUM_OVERRIDE_1
,      ASSUM_OVERRIDE_2
,      ASSUM_OVERRIDE_3
,      ASSUM_OVERRIDE_4
,      ASSUM_OVERRIDE_5
,      ASSUM_OVERRIDE_6
,      DEPENDENCY_STATUS
,      S_EMAIL_ADDRESS
,      NSLDS_REASON_CODE
,      APP_RECEIPT_DATE
,      PROCESSED_REC_TYPE
,      HIST_CORRECTION_FOR_TRAN_ID
,      SYSTEM_GENERATED_INDICATOR
,      DUP_REQUEST_INDICATOR
,      SOURCE_OF_CORRECTION
,      P_CAL_TAX_STATUS
,      S_CAL_TAX_STATUS
,      GRADUATE_FLAG
,      AUTO_ZERO_EFC
,      EFC_CHANGE_FLAG
,      SARC_FLAG
,      SIMPLIFIED_NEED_TEST
,      REJECT_REASON_CODES
,      SELECT_SERVICE_MATCH_FLAG
,      SELECT_SERVICE_REG_FLAG
,      INS_MATCH_FLAG
,      INS_VERIFICATION_NUMBER
,      SEC_INS_MATCH_FLAG
,      SEC_INS_VER_NUMBER
,      SSN_MATCH_FLAG
,      SSA_CITIZENSHIP_FLAG
,      SSN_DATE_OF_DEATH
,      NSLDS_MATCH_FLAG
,      VA_MATCH_FLAG
,      PRISONER_MATCH
,      VERIFICATION_FLAG
,      SUBSEQUENT_APP_FLAG
,      APP_SOURCE_SITE_CODE
,      TRAN_SOURCE_SITE_CODE
,      DRN
,      TRAN_PROCESS_DATE
,      CORRECTION_FLAGS
,      COMPUTER_BATCH_NUMBER
,      HIGHLIGHT_FLAGS
,      PAID_EFC
,      PRIMARY_EFC
,      SECONDARY_EFC
,      FED_PELL_GRANT_EFC_TYPE
,      PRIMARY_EFC_TYPE
,      SEC_EFC_TYPE
,      PRIMARY_ALTERNATE_MONTH_1
,      PRIMARY_ALTERNATE_MONTH_2
,      PRIMARY_ALTERNATE_MONTH_3
,      PRIMARY_ALTERNATE_MONTH_4
,      PRIMARY_ALTERNATE_MONTH_5
,      PRIMARY_ALTERNATE_MONTH_6
,      PRIMARY_ALTERNATE_MONTH_7
,      PRIMARY_ALTERNATE_MONTH_8
,      PRIMARY_ALTERNATE_MONTH_10
,      PRIMARY_ALTERNATE_MONTH_11
,      PRIMARY_ALTERNATE_MONTH_12
,      SEC_ALTERNATE_MONTH_1
,      SEC_ALTERNATE_MONTH_2
,      SEC_ALTERNATE_MONTH_3
,      SEC_ALTERNATE_MONTH_4
,      SEC_ALTERNATE_MONTH_5
,      SEC_ALTERNATE_MONTH_6
,      SEC_ALTERNATE_MONTH_7
,      SEC_ALTERNATE_MONTH_8
,      SEC_ALTERNATE_MONTH_10
,      SEC_ALTERNATE_MONTH_11
,      SEC_ALTERNATE_MONTH_12
,      TOTAL_INCOME
,      ALLOW_TOTAL_INCOME
,      STATE_TAX_ALLOW
,      EMPLOYMENT_ALLOW
,      INCOME_PROTECTION_ALLOW
,      AVAILABLE_INCOME
,      CONTRIBUTION_FROM_AI
,      DISCRETIONARY_NETWORTH
,      EFC_NETWORTH
,      ASSET_PROTECT_ALLOW
,      PARENTS_CONT_FROM_ASSETS
,      ADJUSTED_AVAILABLE_INCOME
,      TOTAL_STUDENT_CONTRIBUTION
,      TOTAL_PARENT_CONTRIBUTION
,      PARENTS_CONTRIBUTION
,      STUDENT_TOTAL_INCOME
,      SATI
,      SIC
,      SDNW
,      SCA
,      FTI
,      SECTI
,      SECATI
,      SECSTX
,      SECEA
,      SECIPA
,      SECAI
,      SECCAI
,      SECDNW
,      SECNW
,      SECAPA
,      SECPCA
,      SECAAI
,      SECTSC
,      SECTPC
,      SECPC
,      SECSTI
,      SECSATI
,      SECSIC
,      SECSDNW
,      SECSCA
,      SECFTI
,      A_CITIZENSHIP
,      A_STUDENT_MARITAL_STATUS
,      A_STUDENT_AGI
,      A_S_US_TAX_PAID
,      A_S_INCOME_WORK
,      A_SPOUSE_INCOME_WORK
,      A_S_TOTAL_WSC
,      A_DATE_OF_BIRTH
,      A_STUDENT_MARRIED
,      A_HAVE_CHILDREN
,      A_S_HAVE_DEPENDENTS
,      A_VA_STATUS
,      A_S_NUM_IN_FAMILY
,      A_S_NUM_IN_COLLEGE
,      A_P_MARITAL_STATUS
,      A_FATHER_SSN
,      A_MOTHER_SSN
,      A_PARENTS_NUM_FAMILY
,      A_PARENTS_NUM_COLLEGE
,      A_PARENTS_AGI
,      A_P_US_TAX_PAID
,      A_F_WORK_INCOME
,      A_M_WORK_INCOME
,      A_P_TOTAL_WSC
,      COMMENT_CODES
,      SAR_ACK_COMM_CODE
,      PELL_GRANT_ELIG_FLAG
,      REPROCESS_REASON_CODE
,      DUPLICATE_DATE
,      ISIR_TRANSACTION_TYPE
,      FEDRAL_SCHL_CODE_INDICATOR
,      MULTI_SCHOOL_CODE_FLAGS
,      DUP_SSN_INDICATOR
,      NSLDS_TRANSACTION_NUM
,      NSLDS_DATABASE_RESULTS_F
,      NSLDS_F
,      NSLDS_PELL_OVERPAY_F
,      NSLDS_PELL_OVERPAY_CONTACT
,      NSLDS_SEOG_OVERPAY_F
,      NSLDS_SEOG_OVERPAY_CONTACT
,      NSLDS_PERKINS_OVERPAY_F
,      NSLDS_PERKINS_OVERPAY_CNTCT
,      NSLDS_DEFAULTED_LOAN_F
,      NSLDS_DISCHARGED_LOAN_F
,      NSLDS_SATIS_REPAY_F
,      NSLDS_ACT_BANKRUPTCY_F
,      NSLDS_AGG_SUBSZ_OUT_PRIN_BAL
,      NSLDS_AGG_UNSBZ_OUT_PRIN_BAL
,      NSLDS_AGG_COMB_OUT_PRIN_BAL
,      NSLDS_AGG_CONS_OUT_PRIN_BAL
,      NSLDS_AGG_SUBSZ_PEND_DISMNT
,      NSLDS_AGG_UNSBZ_PEND_DISMNT
,      NSLDS_AGG_COMB_PEND_DISMNT
,      NSLDS_AGG_SUBSZ_TOTAL
,      NSLDS_AGG_UNSBZ_TOTAL
,      NSLDS_AGG_COMB_TOTAL
,      NSLDS_AGG_CONSD_TOTAL
,      NSLDS_PERKINS_OUT_BAL
,      NSLDS_PERKINS_CUR_YR_DISMNT
,      NSLDS_DEFAULT_LOAN_CHNG_F
,      NSLDS_DISCHGED_LOAN_CHNG_F
,      NSLDS_SATIS_REPAY_CHNG_F
,      NSLDS_ACT_BNKRUPT_CHNG_F
,      NSLDS_OVERPAY_CHNG_F
,      NSLDS_AGG_LOAN_CHNG_F
,      NSLDS_PERKINS_LOAN_CHNG_F
,      NSLDS_PELL_PAYMNT_CHNG_F
,      NSLDS_ADDTNL_PELL_F
,      NSLDS_ADDTNL_LOAN_F
,      DIRECT_LOAN_MAS_PROM_NT_F
,      NSLDS_PELL_SEQ_NUM_1
,      NSLDS_PELL_VERIFY_F_1
,      NSLDS_PELL_EFC_1
,      NSLDS_PELL_SCHOOL_CODE_1
,      NSLDS_PELL_TRANSCN_NUM_1
,      NSLDS_PELL_LAST_UPDT_DT_1
,      NSLDS_PELL_SCHEDULED_AMT_1
,      NSLDS_PELL_AMT_PAID_TODT_1
,      NSLDS_PELL_REMNG_AMT_1
,      NSLDS_PELL_PC_SCHD_AWD_US_1
,      NSLDS_PELL_AWARD_AMT_1
,      NSLDS_PELL_SEQ_NUM_2
,      NSLDS_PELL_VERIFY_F_2
,      NSLDS_PELL_EFC_2
,      NSLDS_PELL_SCHOOL_CODE_2
,      NSLDS_PELL_TRANSCN_NUM_2
,      NSLDS_PELL_LAST_UPDT_DT_2
,      NSLDS_PELL_SCHEDULED_AMT_2
,      NSLDS_PELL_AMT_PAID_TODT_2
,      NSLDS_PELL_REMNG_AMT_2
,      NSLDS_PELL_PC_SCHD_AWD_US_2
,      NSLDS_PELL_AWARD_AMT_2
,      NSLDS_PELL_SEQ_NUM_3
,      NSLDS_PELL_VERIFY_F_3
,      NSLDS_PELL_EFC_3
,      NSLDS_PELL_SCHOOL_CODE_3
,      NSLDS_PELL_TRANSCN_NUM_3
,      NSLDS_PELL_LAST_UPDT_DT_3
,      NSLDS_PELL_SCHEDULED_AMT_3
,      NSLDS_PELL_AMT_PAID_TODT_3
,      NSLDS_PELL_REMNG_AMT_3
,      NSLDS_PELL_PC_SCHD_AWD_US_3
,      NSLDS_PELL_AWARD_AMT_3
,      NSLDS_LOAN_SEQ_NUM_1
,      NSLDS_LOAN_TYPE_CODE_1
,      NSLDS_LOAN_CHNG_F_1
,      NSLDS_LOAN_PROG_CODE_1
,      NSLDS_LOAN_NET_AMNT_1
,      NSLDS_LOAN_CUR_ST_CODE_1
,      NSLDS_LOAN_CUR_ST_DATE_1
,      NSLDS_LOAN_AGG_PR_BAL_1
,      NSLDS_LOAN_OUT_PR_BAL_DT_1
,      NSLDS_LOAN_BEGIN_DT_1
,      NSLDS_LOAN_END_DT_1
,      NSLDS_LOAN_GA_CODE_1
,      NSLDS_LOAN_CONT_TYPE_1
,      NSLDS_LOAN_SCHOL_CODE_1
,      NSLDS_LOAN_CONT_CODE_1
,      NSLDS_LOAN_GRADE_LVL_1
,      NSLDS_LOAN_XTR_UNSBZ_LN_F_1
,      NSLDS_LOAN_CAPITAL_INT_F_1
,      NSLDS_LOAN_SEQ_NUM_2
,      NSLDS_LOAN_TYPE_CODE_2
,      NSLDS_LOAN_CHNG_F_2
,      NSLDS_LOAN_PROG_CODE_2
,      NSLDS_LOAN_NET_AMNT_2
,      NSLDS_LOAN_CUR_ST_CODE_2
,      NSLDS_LOAN_CUR_ST_DATE_2
,      NSLDS_LOAN_AGG_PR_BAL_2
,      NSLDS_LOAN_OUT_PR_BAL_DT_2
,      NSLDS_LOAN_BEGIN_DT_2
,      NSLDS_LOAN_END_DT_2
,      NSLDS_LOAN_GA_CODE_2
,      NSLDS_LOAN_CONT_TYPE_2
,      NSLDS_LOAN_SCHOL_CODE_2
,      NSLDS_LOAN_CONT_CODE_2
,      NSLDS_LOAN_GRADE_LVL_2
,      NSLDS_LOAN_XTR_UNSBZ_LN_F_2
,      NSLDS_LOAN_CAPITAL_INT_F_2
,      NSLDS_LOAN_SEQ_NUM_3
,      NSLDS_LOAN_TYPE_CODE_3
,      NSLDS_LOAN_CHNG_F_3
,      NSLDS_LOAN_PROG_CODE_3
,      NSLDS_LOAN_NET_AMNT_3
,      NSLDS_LOAN_CUR_ST_CODE_3
,      NSLDS_LOAN_CUR_ST_DATE_3
,      NSLDS_LOAN_AGG_PR_BAL_3
,      NSLDS_LOAN_OUT_PR_BAL_DT_3
,      NSLDS_LOAN_BEGIN_DT_3
,      NSLDS_LOAN_END_DT_3
,      NSLDS_LOAN_GA_CODE_3
,      NSLDS_LOAN_CONT_TYPE_3
,      NSLDS_LOAN_SCHOL_CODE_3
,      NSLDS_LOAN_CONT_CODE_3
,      NSLDS_LOAN_GRADE_LVL_3
,      NSLDS_LOAN_XTR_UNSBZ_LN_F_3
,      NSLDS_LOAN_CAPITAL_INT_F_3
,      NSLDS_LOAN_SEQ_NUM_4
,      NSLDS_LOAN_TYPE_CODE_4
,      NSLDS_LOAN_CHNG_F_4
,      NSLDS_LOAN_PROG_CODE_4
,      NSLDS_LOAN_NET_AMNT_4
,      NSLDS_LOAN_CUR_ST_CODE_4
,      NSLDS_LOAN_CUR_ST_DATE_4
,      NSLDS_LOAN_AGG_PR_BAL_4
,      NSLDS_LOAN_OUT_PR_BAL_DT_4
,      NSLDS_LOAN_BEGIN_DT_4
,      NSLDS_LOAN_END_DT_4
,      NSLDS_LOAN_GA_CODE_4
,      NSLDS_LOAN_CONT_TYPE_4
,      NSLDS_LOAN_SCHOL_CODE_4
,      NSLDS_LOAN_CONT_CODE_4
,      NSLDS_LOAN_GRADE_LVL_4
,      NSLDS_LOAN_XTR_UNSBZ_LN_F_4
,      NSLDS_LOAN_CAPITAL_INT_F_4
,      NSLDS_LOAN_SEQ_NUM_5
,      NSLDS_LOAN_TYPE_CODE_5
,      NSLDS_LOAN_CHNG_F_5
,      NSLDS_LOAN_PROG_CODE_5
,      NSLDS_LOAN_NET_AMNT_5
,      NSLDS_LOAN_CUR_ST_CODE_5
,      NSLDS_LOAN_CUR_ST_DATE_5
,      NSLDS_LOAN_AGG_PR_BAL_5
,      NSLDS_LOAN_OUT_PR_BAL_DT_5
,      NSLDS_LOAN_BEGIN_DT_5
,      NSLDS_LOAN_END_DT_5
,      NSLDS_LOAN_GA_CODE_5
,      NSLDS_LOAN_CONT_TYPE_5
,      NSLDS_LOAN_SCHOL_CODE_5
,      NSLDS_LOAN_CONT_CODE_5
,      NSLDS_LOAN_GRADE_LVL_5
,      NSLDS_LOAN_XTR_UNSBZ_LN_F_5
,      NSLDS_LOAN_CAPITAL_INT_F_5
,      NSLDS_LOAN_SEQ_NUM_6
,      NSLDS_LOAN_TYPE_CODE_6
,      NSLDS_LOAN_CHNG_F_6
,      NSLDS_LOAN_PROG_CODE_6
,      NSLDS_LOAN_NET_AMNT_6
,      NSLDS_LOAN_CUR_ST_CODE_6
,      NSLDS_LOAN_CUR_ST_DATE_6
,      NSLDS_LOAN_AGG_PR_BAL_6
,      NSLDS_LOAN_OUT_PR_BAL_DT_6
,      NSLDS_LOAN_BEGIN_DT_6
,      NSLDS_LOAN_END_DT_6
,      NSLDS_LOAN_GA_CODE_6
,      NSLDS_LOAN_CONT_TYPE_6
,      NSLDS_LOAN_SCHOL_CODE_6
,      NSLDS_LOAN_CONT_CODE_6
,      NSLDS_LOAN_GRADE_LVL_6
,      NSLDS_LOAN_XTR_UNSBZ_LN_F_6
,      NSLDS_LOAN_CAPITAL_INT_F_6
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      NSLDS_LOAN_LAST_D_AMT_1
,      NSLDS_LOAN_LAST_D_DATE_1
,      NSLDS_LOAN_LAST_D_AMT_2
,      NSLDS_LOAN_LAST_D_DATE_2
,      NSLDS_LOAN_LAST_D_AMT_3
,      NSLDS_LOAN_LAST_D_DATE_3
,      NSLDS_LOAN_LAST_D_AMT_4
,      NSLDS_LOAN_LAST_D_DATE_4
,      NSLDS_LOAN_LAST_D_AMT_5
,      NSLDS_LOAN_LAST_D_DATE_5
,      NSLDS_LOAN_LAST_D_AMT_6
,      NSLDS_LOAN_LAST_D_DATE_6
,      VERIF_TRACK_FLAG
,      FAFSA_DATA_VERIFY_FLAGS
,      REJECT_OVERRIDE_A
,      REJECT_OVERRIDE_C
,      PARENT_MARITAL_STATUS_DATE
,      DLP_MASTER_PROM_NOTE_FLAG
,      FATHER_FIRST_NAME_INITIAL_TXT
,      FATHER_STEP_FATHER_BIRTH_DATE
,      MOTHER_FIRST_NAME_INITIAL_TXT
,      MOTHER_STEP_MOTHER_BIRTH_DATE
,      PARENTS_EMAIL_ADDRESS_TXT
,      ADDRESS_CHANGE_TYPE
,      CPS_PUSHED_ISIR_FLAG
,      ELECTRONIC_TRANSACTION_TYPE
,      SAR_C_CHANGE_TYPE
,      FATHER_SSN_MATCH_TYPE
,      MOTHER_SSN_MATCH_TYPE
,      SUBSIDIZED_LOAN_LIMIT_TYPE
,      COMBINED_LOAN_LIMIT_TYPE
,      REJECT_OVERRIDE_G_FLAG
,      DHS_VERIFICATION_NUM_TXT
FROM IGF.IGF_AP_ISIR_INTRFACE_ALL;

Dependencies

[top of page]

IGF.IGF_AP_ISIR_INTRFACE_ALL does not reference any database object

IGF.IGF_AP_ISIR_INTRFACE_ALL is referenced by following:

SchemaAPPS
SynonymIGF_AP_ISIR_INTRFACE_ALL