[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_ISIR_MATCHED |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_AP_ISIR_MATCHED |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ISIR_ID | NUMBER | (15) | Yes | Identifier for ISIR student record |
BASE_ID | NUMBER | (15) | Yes | Identifier for student financial aid record |
BATCH_YEAR | NUMBER | (1) | Yes | Holds batch year |
TRANSACTION_NUM | VARCHAR2 | (2) | Yes | Holds CPS transaction number of ISIR |
CURRENT_SSN | VARCHAR2 | (9) | Yes | Holds student SSN for current ISIR record |
SSN_NAME_CHANGE | VARCHAR2 | (30) | Indicates if last name, SSN, or both have changed | |
ORIGINAL_SSN | VARCHAR2 | (9) | Holds original SSN as processed by CPS | |
ORIG_NAME_ID | VARCHAR2 | (2) | Holds first two letters of last name as on initial application | |
LAST_NAME | VARCHAR2 | (16) | Last name of applicant student | |
FIRST_NAME | VARCHAR2 | (12) | First name of applicant student | |
MIDDLE_INITIAL | VARCHAR2 | (1) | Middle name of applicant student | |
PERM_MAIL_ADD | VARCHAR2 | (35) | Permanent mailing address of applicant student | |
PERM_CITY | VARCHAR2 | (16) | Permanent city of applicant student | |
PERM_STATE | VARCHAR2 | (2) | Permanent state of applicant student | |
PERM_ZIP_CODE | VARCHAR2 | (5) | Permanent zip code of applicant student | |
DATE_OF_BIRTH | DATE | Date of birth of applicant student | ||
PHONE_NUMBER | VARCHAR2 | (10) | Contact phone number of applicant student | |
DRIVER_LICENSE_NUMBER | VARCHAR2 | (20) | Driver's license number of applicant student if applicable | |
DRIVER_LICENSE_STATE | VARCHAR2 | (30) | Driver's license state code of applicant student if applicable | |
CITIZENSHIP_STATUS | VARCHAR2 | (30) | Status of student's citizenship | |
ALIEN_REG_NUMBER | VARCHAR2 | (9) | Student's alien registration number | |
S_MARITAL_STATUS | VARCHAR2 | (30) | Student's marital status | |
S_MARITAL_STATUS_DATE | DATE | Date on which student's marital status changed to current status | ||
SUMM_ENRL_STATUS | VARCHAR2 | (30) | Student's enrollment plan for summer term | |
FALL_ENRL_STATUS | VARCHAR2 | (30) | Student's enrollment plan for fall term | |
WINTER_ENRL_STATUS | VARCHAR2 | (30) | Student's enrollment plan for winter term | |
SPRING_ENRL_STATUS | VARCHAR2 | (30) | Student's enrollment plan for spring term | |
SUMM2_ENRL_STATUS | VARCHAR2 | (30) | Student's enrollment plan for next summer term | |
FATHERS_HIGHEST_EDU_LEVEL | VARCHAR2 | (1) | Father's highest education level completed | |
MOTHERS_HIGHEST_EDU_LEVEL | VARCHAR2 | (1) | Mother's highest education level completed | |
S_STATE_LEGAL_RESIDENCE | VARCHAR2 | (30) | Student's state of legal residence | |
LEGAL_RESIDENCE_BEFORE_DATE | VARCHAR2 | (2) | Student's legal residence before cut-off date. Set by CPS. | |
S_LEGAL_RESD_DATE | DATE | Date on which student's legal residence changed to current | ||
SS_R_U_MALE | VARCHAR2 | (1) | Indicates whether student is male | |
SELECTIVE_SERVICE_REG | VARCHAR2 | (1) | Indicates whether Selective Service should register student | |
DEGREE_CERTIFICATION | VARCHAR2 | (30) | Holds the student's degree or certificate information | |
GRADE_LEVEL_IN_COLLEGE | VARCHAR2 | (30) | Student's grade level in college in current academic year | |
HIGH_SCHOOL_DIPLOMA_GED | VARCHAR2 | (1) | Holds student's high school or GED diploma information | |
FIRST_BACHELOR_DEG_BY_DATE | VARCHAR2 | (1) | Indicates if student will obtain first bachelor's degree within current year | |
INTEREST_IN_LOAN | VARCHAR2 | (1) | Indicates whether student is interested in student loan | |
INTEREST_IN_STUD_EMPLOYMENT | VARCHAR2 | (1) | Indicates whether student is interested in student employment | |
DRUG_OFFENCE_CONVICTION | VARCHAR2 | (30) | Indicates whether student has drug conviction | |
S_TAX_RETURN_STATUS | VARCHAR2 | (30) | Holds student's tax return status | |
S_TYPE_TAX_RETURN | VARCHAR2 | (30) | Indicates type of tax form used by student in filing tax returns | |
S_ELIG_1040EZ | VARCHAR2 | (30) | Indicates whether student is eligible for 1040A or 1040EZ | |
S_ADJUSTED_GROSS_INCOME | NUMBER | (12) | Holds student's adjusted gross income from IRS Form | |
S_FED_TAXES_PAID | NUMBER | (12) | Holds amount student paid in U.S. income tax | |
S_EXEMPTIONS | NUMBER | (2) | Indicates number of tax exemptions claimed by student | |
S_INCOME_FROM_WORK | NUMBER | (12) | Student' s income earned from work | |
SPOUSE_INCOME_FROM_WORK | NUMBER | (12) | Spouse's income earned from work | |
S_TOA_AMT_FROM_WSA | NUMBER | (12) | Student's total amount from Worksheet A | |
S_TOA_AMT_FROM_WSB | NUMBER | (12) | Student's total amount from Worksheet B | |
S_TOA_AMT_FROM_WSC | NUMBER | (12) | Student's total amount from Worksheet C | |
S_INVESTMENT_NETWORTH | NUMBER | (12) | Net worth of investment made by student | |
S_BUSI_FARM_NETWORTH | NUMBER | (12) | Net worth of student's business and farm | |
S_CASH_SAVINGS | NUMBER | (12) | Savings available to student | |
VA_MONTHS | NUMBER | (2) | Indicates number of months student received veterans' education benefit | |
VA_AMOUNT | NUMBER | (15) | Indicates monthly veteran education benefits student received | |
STUD_DOB_BEFORE_DATE | VARCHAR2 | (1) | Indicates whether student was born before cut-off date set by Department of Education for year | |
DEG_BEYOND_BACHELOR | VARCHAR2 | (1) | Indicates whether student is working on degree beyond current academic year | |
S_MARRIED | VARCHAR2 | (1) | Indicates whether student is married | |
S_HAVE_CHILDREN | VARCHAR2 | (1) | Indicates whether student has children | |
LEGAL_DEPENDENTS | VARCHAR2 | (1) | Indicates whether student has legal dependents other than children and spouse | |
ORPHAN_WARD_OF_COURT | VARCHAR2 | (1) | Indicates whether student is orphan or ward of court | |
S_VETERAN | VARCHAR2 | (1) | Indicates whether student is veteran of U.S. Armed Forces | |
P_MARITAL_STATUS | VARCHAR2 | (30) | Holds marital status of student's parents | |
FATHER_SSN | VARCHAR2 | (9) | Holds father's SSN | |
F_LAST_NAME | VARCHAR2 | (16) | Holds father's last name | |
MOTHER_SSN | VARCHAR2 | (9) | Holds mother's SSN | |
M_LAST_NAME | VARCHAR2 | (16) | Holds mother's last name | |
P_NUM_FAMILY_MEMBER | NUMBER | (2) | Holds number of family members in student's parents' family | |
P_NUM_IN_COLLEGE | NUMBER | (1) | Holds number of people in parents' family in college in current year. Excludes parents. | |
P_STATE_LEGAL_RESIDENCE | VARCHAR2 | (30) | Holds parents' state of legal residence | |
P_STATE_LEGAL_RES_BEFORE_DT | VARCHAR2 | (2) | Parents' legal residence before specific date | |
P_LEGAL_RES_DATE | DATE | Date on which current state became parents' legal residence | ||
AGE_OLDER_PARENT | NUMBER | (2) | Holds age of older parent | |
P_TAX_RETURN_STATUS | VARCHAR2 | (30) | Indicates whether parents' filed tax returns | |
P_TYPE_TAX_RETURN | VARCHAR2 | (1) | Holds type of tax form used by parents' in filing tax returns | |
P_ELIG_1040AEZ | VARCHAR2 | (30) | Indicates whether parents are eligible to file 1040A or 1040EZ | |
P_ADJUSTED_GROSS_INCOME | NUMBER | (12) | Holds parents' adjusted gross income from IRS form | |
P_TAXES_PAID | NUMBER | (12) | Holds U.S. income tax parents paid | |
P_EXEMPTIONS | NUMBER | (2) | Holds number of exemptions parents claimed | |
F_INCOME_WORK | NUMBER | (12) | Holds father's income earned from work | |
M_INCOME_WORK | NUMBER | (12) | Holds mother's income earned from work | |
P_INCOME_WSA | NUMBER | (12) | Parents' total amount from Worksheet A | |
P_INCOME_WSB | NUMBER | (12) | Parents' total amount from Worksheet B | |
P_INCOME_WSC | NUMBER | (12) | Parents' total amount from Worksheet C | |
P_INVESTMENT_NETWORTH | NUMBER | (12) | Holds net worth of parent's investments | |
P_BUSINESS_NETWORTH | NUMBER | (12) | Holds net worth of parents' business and farm | |
P_CASH_SAVING | NUMBER | (12) | Holds parents' savings information | |
S_NUM_FAMILY_MEMBERS | NUMBER | (2) | Number of family members in student's family | |
S_NUM_IN_COLLEGE | NUMBER | (1) | Holds number of people from student's family in college during current year | |
FIRST_COLLEGE | VARCHAR2 | (30) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
FIRST_HOUSE_PLAN | VARCHAR2 | (30) | Student's housing plan for first school | |
SECOND_COLLEGE | VARCHAR2 | (30) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
SECOND_HOUSE_PLAN | VARCHAR2 | (30) | Student's housing plan for second school | |
THIRD_COLLEGE | VARCHAR2 | (30) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
THIRD_HOUSE_PLAN | VARCHAR2 | (30) | Student's housing plan for third school | |
FOURTH_COLLEGE | VARCHAR2 | (30) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
FOURTH_HOUSE_PLAN | VARCHAR2 | (30) | Student's housing plan for fourth school | |
FIFTH_COLLEGE | VARCHAR2 | (30) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
FIFTH_HOUSE_PLAN | VARCHAR2 | (30) | Student's housing plan for fifth school | |
SIXTH_COLLEGE | VARCHAR2 | (30) | Holds school code of one of schools student wants ISIR data to be sent from CPS | |
SIXTH_HOUSE_PLAN | VARCHAR2 | (30) | Student's housing plan for sixth school | |
DATE_APP_COMPLETED | DATE | Indicates date application was completed | ||
SIGNED_BY | VARCHAR2 | (30) | Indicates if applicant, parent, or both signed FAFSA application | |
PREPARER_SSN | VARCHAR2 | (9) | ||
PREPARER_EMP_ID_NUMBER | VARCHAR2 | (9) | ||
PREPARER_SIGN | VARCHAR2 | (1) | ||
TRANSACTION_RECEIPT_DATE | DATE | |||
DEPENDENCY_OVERRIDE_IND | VARCHAR2 | (30) | ||
FAA_FEDRAL_SCHL_CODE | VARCHAR2 | (30) | ||
FAA_ADJUSTMENT | VARCHAR2 | (1) | ||
INPUT_RECORD_TYPE | VARCHAR2 | (30) | ||
SERIAL_NUMBER | NUMBER | (15) | ||
BATCH_NUMBER | VARCHAR2 | (23) | ||
EARLY_ANALYSIS_FLAG | VARCHAR2 | (1) | ||
APP_ENTRY_SOURCE_CODE | VARCHAR2 | (30) | ||
ETI_DESTINATION_CODE | VARCHAR2 | (7) | ||
REJECT_OVERRIDE_B | VARCHAR2 | (1) | ||
REJECT_OVERRIDE_N | VARCHAR2 | (1) | ||
REJECT_OVERRIDE_W | VARCHAR2 | (1) | ||
ASSUM_OVERRIDE_1 | VARCHAR2 | (1) | ||
ASSUM_OVERRIDE_2 | VARCHAR2 | (1) | ||
ASSUM_OVERRIDE_3 | VARCHAR2 | (1) | ||
ASSUM_OVERRIDE_4 | VARCHAR2 | (1) | ||
ASSUM_OVERRIDE_5 | VARCHAR2 | (1) | ||
ASSUM_OVERRIDE_6 | VARCHAR2 | (1) | ||
DEPENDENCY_STATUS | VARCHAR2 | (30) | ||
S_EMAIL_ADDRESS | VARCHAR2 | (50) | ||
NSLDS_REASON_CODE | VARCHAR2 | (30) | ||
APP_RECEIPT_DATE | DATE | |||
PROCESSED_REC_TYPE | VARCHAR2 | (30) | ||
HIST_CORRECTION_FOR_TRAN_ID | NUMBER | (2) | ||
SYSTEM_GENERATED_INDICATOR | VARCHAR2 | (30) | ||
DUP_REQUEST_INDICATOR | VARCHAR2 | (1) | ||
SOURCE_OF_CORRECTION | VARCHAR2 | (30) | ||
P_CAL_TAX_STATUS | VARCHAR2 | (30) | ||
S_CAL_TAX_STATUS | VARCHAR2 | (30) | ||
GRADUATE_FLAG | VARCHAR2 | (1) | ||
AUTO_ZERO_EFC | VARCHAR2 | (1) | ||
EFC_CHANGE_FLAG | VARCHAR2 | (30) | ||
SARC_FLAG | VARCHAR2 | (1) | ||
SIMPLIFIED_NEED_TEST | VARCHAR2 | (1) | ||
REJECT_REASON_CODES | VARCHAR2 | (14) | ||
SELECT_SERVICE_MATCH_FLAG | VARCHAR2 | (30) | ||
SELECT_SERVICE_REG_FLAG | VARCHAR2 | (30) | ||
INS_MATCH_FLAG | VARCHAR2 | (1) | ||
INS_VERIFICATION_NUMBER | VARCHAR2 | (0) | Identification number provided by Immigration and Naturalization Service indicating primary verification was performed - No longer used | |
SEC_INS_MATCH_FLAG | VARCHAR2 | (1) | ||
SEC_INS_VER_NUMBER | NUMBER | (15) | ||
SSN_MATCH_FLAG | VARCHAR2 | (30) | ||
SSA_CITIZENSHIP_FLAG | VARCHAR2 | (30) | ||
SSN_DATE_OF_DEATH | DATE | |||
NSLDS_MATCH_FLAG | VARCHAR2 | (30) | ||
VA_MATCH_FLAG | VARCHAR2 | (30) | ||
PRISONER_MATCH | VARCHAR2 | (30) | ||
VERIFICATION_FLAG | VARCHAR2 | (1) | ||
SUBSEQUENT_APP_FLAG | VARCHAR2 | (1) | ||
APP_SOURCE_SITE_CODE | VARCHAR2 | (30) | ||
TRAN_SOURCE_SITE_CODE | VARCHAR2 | (30) | ||
DRN | NUMBER | (4) | ||
TRAN_PROCESS_DATE | DATE | |||
CORRECTION_FLAGS | VARCHAR2 | (120) | ||
COMPUTER_BATCH_NUMBER | NUMBER | (3) | ||
HIGHLIGHT_FLAGS | VARCHAR2 | (120) | ||
PAID_EFC | NUMBER | (12) | ||
PRIMARY_EFC | NUMBER | (12) | ||
SECONDARY_EFC | NUMBER | (12) | ||
FED_PELL_GRANT_EFC_TYPE | VARCHAR2 | (1) | ||
PRIMARY_EFC_TYPE | VARCHAR2 | (30) | ||
SEC_EFC_TYPE | VARCHAR2 | (1) | ||
PRIMARY_ALTERNATE_MONTH_1 | NUMBER | (5) | ||
PRIMARY_ALTERNATE_MONTH_2 | NUMBER | (5) | ||
PRIMARY_ALTERNATE_MONTH_3 | NUMBER | (5) | ||
PRIMARY_ALTERNATE_MONTH_4 | NUMBER | (5) | ||
PRIMARY_ALTERNATE_MONTH_5 | NUMBER | (5) | ||
PRIMARY_ALTERNATE_MONTH_6 | NUMBER | (5) | ||
PRIMARY_ALTERNATE_MONTH_7 | NUMBER | (5) | ||
PRIMARY_ALTERNATE_MONTH_8 | NUMBER | (5) | ||
PRIMARY_ALTERNATE_MONTH_10 | NUMBER | (5) | ||
PRIMARY_ALTERNATE_MONTH_11 | NUMBER | (5) | ||
PRIMARY_ALTERNATE_MONTH_12 | NUMBER | (5) | ||
SEC_ALTERNATE_MONTH_1 | NUMBER | (5) | ||
SEC_ALTERNATE_MONTH_2 | NUMBER | (5) | ||
SEC_ALTERNATE_MONTH_3 | NUMBER | (5) | ||
SEC_ALTERNATE_MONTH_4 | NUMBER | (5) | ||
SEC_ALTERNATE_MONTH_5 | NUMBER | (5) | ||
SEC_ALTERNATE_MONTH_6 | NUMBER | (5) | ||
SEC_ALTERNATE_MONTH_7 | NUMBER | (5) | ||
SEC_ALTERNATE_MONTH_8 | NUMBER | (5) | ||
SEC_ALTERNATE_MONTH_10 | NUMBER | (5) | ||
SEC_ALTERNATE_MONTH_11 | NUMBER | (5) | ||
SEC_ALTERNATE_MONTH_12 | NUMBER | (5) | ||
TOTAL_INCOME | NUMBER | (12) | ||
ALLOW_TOTAL_INCOME | NUMBER | (12) | ||
STATE_TAX_ALLOW | NUMBER | (12) | ||
EMPLOYMENT_ALLOW | NUMBER | (12) | ||
INCOME_PROTECTION_ALLOW | NUMBER | (12) | ||
AVAILABLE_INCOME | NUMBER | (12) | ||
CONTRIBUTION_FROM_AI | NUMBER | (12) | ||
DISCRETIONARY_NETWORTH | NUMBER | (12) | ||
EFC_NETWORTH | NUMBER | (12) | ||
ASSET_PROTECT_ALLOW | NUMBER | (12) | ||
PARENTS_CONT_FROM_ASSETS | NUMBER | (12) | ||
ADJUSTED_AVAILABLE_INCOME | NUMBER | (12) | ||
TOTAL_STUDENT_CONTRIBUTION | NUMBER | (12) | ||
TOTAL_PARENT_CONTRIBUTION | NUMBER | (12) | ||
PARENTS_CONTRIBUTION | NUMBER | (12) | ||
STUDENT_TOTAL_INCOME | NUMBER | (12) | ||
SATI | NUMBER | (12) | ||
SIC | NUMBER | (12) | ||
SDNW | NUMBER | (12) | ||
SCA | NUMBER | (12) | ||
FTI | NUMBER | (12) | ||
SECTI | NUMBER | (12) | ||
SECATI | NUMBER | (12) | ||
SECSTX | NUMBER | (12) | ||
SECEA | NUMBER | (12) | ||
SECIPA | NUMBER | (12) | ||
SECAI | NUMBER | (12) | ||
SECCAI | NUMBER | (12) | ||
SECDNW | NUMBER | (12) | ||
SECNW | NUMBER | (12) | ||
SECAPA | NUMBER | (12) | ||
SECPCA | NUMBER | (12) | ||
SECAAI | NUMBER | (12) | ||
SECTSC | NUMBER | (12) | ||
SECTPC | NUMBER | (12) | ||
SECPC | NUMBER | (12) | ||
SECSTI | NUMBER | (12) | ||
SECSATI | NUMBER | (12) | ||
SECSIC | NUMBER | (12) | ||
SECSDNW | NUMBER | (12) | ||
SECSCA | NUMBER | (12) | ||
SECFTI | NUMBER | (12) | ||
A_CITIZENSHIP | VARCHAR2 | (30) | ||
A_STUDENT_MARITAL_STATUS | VARCHAR2 | (30) | ||
A_STUDENT_AGI | NUMBER | (12) | ||
A_S_US_TAX_PAID | NUMBER | (12) | ||
A_S_INCOME_WORK | NUMBER | (12) | ||
A_SPOUSE_INCOME_WORK | NUMBER | (12) | ||
A_S_TOTAL_WSC | NUMBER | (12) | ||
A_DATE_OF_BIRTH | VARCHAR2 | (30) | ||
A_STUDENT_MARRIED | VARCHAR2 | (30) | ||
A_HAVE_CHILDREN | VARCHAR2 | (30) | ||
A_S_HAVE_DEPENDENTS | VARCHAR2 | (30) | ||
A_VA_STATUS | VARCHAR2 | (30) | ||
A_S_NUM_IN_FAMILY | NUMBER | (2) | ||
A_S_NUM_IN_COLLEGE | NUMBER | (2) | ||
A_P_MARITAL_STATUS | VARCHAR2 | (30) | ||
A_FATHER_SSN | VARCHAR2 | (9) | ||
A_MOTHER_SSN | VARCHAR2 | (9) | ||
A_PARENTS_NUM_FAMILY | NUMBER | (2) | ||
A_PARENTS_NUM_COLLEGE | NUMBER | (1) | ||
A_PARENTS_AGI | NUMBER | (12) | ||
A_P_US_TAX_PAID | NUMBER | (12) | ||
A_F_WORK_INCOME | NUMBER | (12) | ||
A_M_WORK_INCOME | NUMBER | (12) | ||
A_P_TOTAL_WSC | NUMBER | (12) | ||
COMMENT_CODES | VARCHAR2 | (60) | ||
SAR_ACK_COMM_CODE | VARCHAR2 | (20) | ||
PELL_GRANT_ELIG_FLAG | VARCHAR2 | (30) | ||
REPROCESS_REASON_CODE | VARCHAR2 | (2) | ||
DUPLICATE_DATE | DATE | |||
ISIR_TRANSACTION_TYPE | VARCHAR2 | (30) | ||
FEDRAL_SCHL_CODE_INDICATOR | VARCHAR2 | (30) | ||
MULTI_SCHOOL_CODE_FLAGS | VARCHAR2 | (6) | ||
DUP_SSN_INDICATOR | VARCHAR2 | (1) | ||
PAYMENT_ISIR | VARCHAR2 | (1) | ||
RECEIPT_STATUS | VARCHAR2 | (10) | ||
ISIR_RECEIPT_COMPLETED | VARCHAR2 | (1) | ||
SYSTEM_RECORD_TYPE | VARCHAR2 | (30) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
ORG_ID | NUMBER | (15) | ||
VERIF_TRACK_FLAG | VARCHAR2 | (30) | ||
ACTIVE_ISIR | VARCHAR2 | (30) | Indicates the ISIR is the Active ISIR | |
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 | Store the parents Marital Status date | ||
LEGACY_RECORD_FLAG | VARCHAR2 | (1) | Indicates this Student Award Record is imported through Legacy import process | |
FATHER_FIRST_NAME_INITIAL_TXT | VARCHAR2 | (1) | Father's/Stepfather's First Name Initial | |
FATHER_STEP_FATHER_BIRTH_DATE | DATE | Father's/Stepfather's Date of Birth | ||
MOTHER_FIRST_NAME_INITIAL_TXT | VARCHAR2 | (1) | Mother's/Stepmother's First Name Initial | |
MOTHER_STEP_MOTHER_BIRTH_DATE | DATE | Mother's/Stepmother's Date of Birth | ||
PARENTS_EMAIL_ADDRESS_TXT | VARCHAR2 | (50) | Parent's E-mail Address | |
ADDRESS_CHANGE_TYPE | VARCHAR2 | (1) | Address Only Change Flag | |
CPS_PUSHED_ISIR_FLAG | VARCHAR2 | (1) | This Flag is set to identify transactions that are automatically sent to schools | |
ELECTRONIC_TRANSACTION_TYPE | VARCHAR2 | (1) | To indicate if the school receiving the ISIR submitted input to generate the ISIR transaction, or did not generate the transaction but was listed on the record. It also indicates whether the type of ISIR is a daily, requested, or pushed ISIR. | |
SAR_C_CHANGE_TYPE | VARCHAR2 | (1) | This Flag is set to identify SAR changes | |
FATHER_SSN_MATCH_TYPE | VARCHAR2 | (1) | To indicate the Father's/Stepfather's results from SSN Match with Social Security Administration. | |
MOTHER_SSN_MATCH_TYPE | VARCHAR2 | (1) | To indicate the Mother's/Stepmother's results from SSN Match with Social Security Administration. | |
REJECT_OVERRIDE_G_FLAG | VARCHAR2 | (1) | Reject Override G Flag | |
DHS_VERIFICATION_NUM_TXT | VARCHAR2 | (15) | Identification Number provided by the Department of Homeland Securityindicating that primary verification wasperformed. | |
DATA_FILE_NAME_TXT | VARCHAR2 | (30) | Name of Data File used for Importing the ISIR | |
MESSAGE_CLASS_TXT | VARCHAR2 | (30) | Message Class associated with the data file sent by CPS | |
REJECT_OVERRIDE_3_FLAG | VARCHAR2 | (1) | Reject Overrides 3 Flag | |
REJECT_OVERRIDE_12_FLAG | VARCHAR2 | (1) | Reject Overrides 12 Flag | |
REJECT_OVERRIDE_J_FLAG | VARCHAR2 | (1) | Reject Overrides J Flag | |
REJECT_OVERRIDE_K_FLAG | VARCHAR2 | (1) | Reject Overrides K Flag | |
REJECTED_STATUS_CHANGE_FLAG | VARCHAR2 | (1) | Rejected Status change Flag | |
VERIFICATION_SELECTION_FLAG | VARCHAR2 | (1) | Verification Selection flag |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ISIR_ID
, BASE_ID
, BATCH_YEAR
, TRANSACTION_NUM
, CURRENT_SSN
, SSN_NAME_CHANGE
, ORIGINAL_SSN
, ORIG_NAME_ID
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL
, PERM_MAIL_ADD
, PERM_CITY
, PERM_STATE
, PERM_ZIP_CODE
, DATE_OF_BIRTH
, PHONE_NUMBER
, DRIVER_LICENSE_NUMBER
, DRIVER_LICENSE_STATE
, CITIZENSHIP_STATUS
, ALIEN_REG_NUMBER
, S_MARITAL_STATUS
, S_MARITAL_STATUS_DATE
, SUMM_ENRL_STATUS
, FALL_ENRL_STATUS
, WINTER_ENRL_STATUS
, SPRING_ENRL_STATUS
, SUMM2_ENRL_STATUS
, FATHERS_HIGHEST_EDU_LEVEL
, MOTHERS_HIGHEST_EDU_LEVEL
, S_STATE_LEGAL_RESIDENCE
, LEGAL_RESIDENCE_BEFORE_DATE
, S_LEGAL_RESD_DATE
, SS_R_U_MALE
, SELECTIVE_SERVICE_REG
, DEGREE_CERTIFICATION
, GRADE_LEVEL_IN_COLLEGE
, HIGH_SCHOOL_DIPLOMA_GED
, FIRST_BACHELOR_DEG_BY_DATE
, INTEREST_IN_LOAN
, INTEREST_IN_STUD_EMPLOYMENT
, DRUG_OFFENCE_CONVICTION
, S_TAX_RETURN_STATUS
, S_TYPE_TAX_RETURN
, S_ELIG_1040EZ
, S_ADJUSTED_GROSS_INCOME
, S_FED_TAXES_PAID
, S_EXEMPTIONS
, S_INCOME_FROM_WORK
, SPOUSE_INCOME_FROM_WORK
, S_TOA_AMT_FROM_WSA
, S_TOA_AMT_FROM_WSB
, S_TOA_AMT_FROM_WSC
, S_INVESTMENT_NETWORTH
, S_BUSI_FARM_NETWORTH
, S_CASH_SAVINGS
, VA_MONTHS
, VA_AMOUNT
, STUD_DOB_BEFORE_DATE
, DEG_BEYOND_BACHELOR
, S_MARRIED
, S_HAVE_CHILDREN
, LEGAL_DEPENDENTS
, ORPHAN_WARD_OF_COURT
, S_VETERAN
, P_MARITAL_STATUS
, FATHER_SSN
, F_LAST_NAME
, MOTHER_SSN
, M_LAST_NAME
, P_NUM_FAMILY_MEMBER
, P_NUM_IN_COLLEGE
, P_STATE_LEGAL_RESIDENCE
, P_STATE_LEGAL_RES_BEFORE_DT
, P_LEGAL_RES_DATE
, AGE_OLDER_PARENT
, P_TAX_RETURN_STATUS
, P_TYPE_TAX_RETURN
, P_ELIG_1040AEZ
, P_ADJUSTED_GROSS_INCOME
, P_TAXES_PAID
, P_EXEMPTIONS
, F_INCOME_WORK
, M_INCOME_WORK
, P_INCOME_WSA
, P_INCOME_WSB
, P_INCOME_WSC
, P_INVESTMENT_NETWORTH
, P_BUSINESS_NETWORTH
, P_CASH_SAVING
, S_NUM_FAMILY_MEMBERS
, S_NUM_IN_COLLEGE
, FIRST_COLLEGE
, FIRST_HOUSE_PLAN
, SECOND_COLLEGE
, SECOND_HOUSE_PLAN
, THIRD_COLLEGE
, THIRD_HOUSE_PLAN
, FOURTH_COLLEGE
, FOURTH_HOUSE_PLAN
, FIFTH_COLLEGE
, FIFTH_HOUSE_PLAN
, SIXTH_COLLEGE
, SIXTH_HOUSE_PLAN
, DATE_APP_COMPLETED
, SIGNED_BY
, PREPARER_SSN
, PREPARER_EMP_ID_NUMBER
, PREPARER_SIGN
, TRANSACTION_RECEIPT_DATE
, DEPENDENCY_OVERRIDE_IND
, FAA_FEDRAL_SCHL_CODE
, FAA_ADJUSTMENT
, INPUT_RECORD_TYPE
, SERIAL_NUMBER
, BATCH_NUMBER
, EARLY_ANALYSIS_FLAG
, APP_ENTRY_SOURCE_CODE
, ETI_DESTINATION_CODE
, REJECT_OVERRIDE_B
, REJECT_OVERRIDE_N
, REJECT_OVERRIDE_W
, ASSUM_OVERRIDE_1
, ASSUM_OVERRIDE_2
, ASSUM_OVERRIDE_3
, ASSUM_OVERRIDE_4
, ASSUM_OVERRIDE_5
, ASSUM_OVERRIDE_6
, DEPENDENCY_STATUS
, S_EMAIL_ADDRESS
, NSLDS_REASON_CODE
, APP_RECEIPT_DATE
, PROCESSED_REC_TYPE
, HIST_CORRECTION_FOR_TRAN_ID
, SYSTEM_GENERATED_INDICATOR
, DUP_REQUEST_INDICATOR
, SOURCE_OF_CORRECTION
, P_CAL_TAX_STATUS
, S_CAL_TAX_STATUS
, GRADUATE_FLAG
, AUTO_ZERO_EFC
, EFC_CHANGE_FLAG
, SARC_FLAG
, SIMPLIFIED_NEED_TEST
, REJECT_REASON_CODES
, SELECT_SERVICE_MATCH_FLAG
, SELECT_SERVICE_REG_FLAG
, INS_MATCH_FLAG
, INS_VERIFICATION_NUMBER
, SEC_INS_MATCH_FLAG
, SEC_INS_VER_NUMBER
, SSN_MATCH_FLAG
, SSA_CITIZENSHIP_FLAG
, SSN_DATE_OF_DEATH
, NSLDS_MATCH_FLAG
, VA_MATCH_FLAG
, PRISONER_MATCH
, VERIFICATION_FLAG
, SUBSEQUENT_APP_FLAG
, APP_SOURCE_SITE_CODE
, TRAN_SOURCE_SITE_CODE
, DRN
, TRAN_PROCESS_DATE
, CORRECTION_FLAGS
, COMPUTER_BATCH_NUMBER
, HIGHLIGHT_FLAGS
, PAID_EFC
, PRIMARY_EFC
, SECONDARY_EFC
, FED_PELL_GRANT_EFC_TYPE
, PRIMARY_EFC_TYPE
, SEC_EFC_TYPE
, PRIMARY_ALTERNATE_MONTH_1
, PRIMARY_ALTERNATE_MONTH_2
, PRIMARY_ALTERNATE_MONTH_3
, PRIMARY_ALTERNATE_MONTH_4
, PRIMARY_ALTERNATE_MONTH_5
, PRIMARY_ALTERNATE_MONTH_6
, PRIMARY_ALTERNATE_MONTH_7
, PRIMARY_ALTERNATE_MONTH_8
, PRIMARY_ALTERNATE_MONTH_10
, PRIMARY_ALTERNATE_MONTH_11
, PRIMARY_ALTERNATE_MONTH_12
, SEC_ALTERNATE_MONTH_1
, SEC_ALTERNATE_MONTH_2
, SEC_ALTERNATE_MONTH_3
, SEC_ALTERNATE_MONTH_4
, SEC_ALTERNATE_MONTH_5
, SEC_ALTERNATE_MONTH_6
, SEC_ALTERNATE_MONTH_7
, SEC_ALTERNATE_MONTH_8
, SEC_ALTERNATE_MONTH_10
, SEC_ALTERNATE_MONTH_11
, SEC_ALTERNATE_MONTH_12
, TOTAL_INCOME
, ALLOW_TOTAL_INCOME
, STATE_TAX_ALLOW
, EMPLOYMENT_ALLOW
, INCOME_PROTECTION_ALLOW
, AVAILABLE_INCOME
, CONTRIBUTION_FROM_AI
, DISCRETIONARY_NETWORTH
, EFC_NETWORTH
, ASSET_PROTECT_ALLOW
, PARENTS_CONT_FROM_ASSETS
, ADJUSTED_AVAILABLE_INCOME
, TOTAL_STUDENT_CONTRIBUTION
, TOTAL_PARENT_CONTRIBUTION
, PARENTS_CONTRIBUTION
, STUDENT_TOTAL_INCOME
, SATI
, SIC
, SDNW
, SCA
, FTI
, SECTI
, SECATI
, SECSTX
, SECEA
, SECIPA
, SECAI
, SECCAI
, SECDNW
, SECNW
, SECAPA
, SECPCA
, SECAAI
, SECTSC
, SECTPC
, SECPC
, SECSTI
, SECSATI
, SECSIC
, SECSDNW
, SECSCA
, SECFTI
, A_CITIZENSHIP
, A_STUDENT_MARITAL_STATUS
, A_STUDENT_AGI
, A_S_US_TAX_PAID
, A_S_INCOME_WORK
, A_SPOUSE_INCOME_WORK
, A_S_TOTAL_WSC
, A_DATE_OF_BIRTH
, A_STUDENT_MARRIED
, A_HAVE_CHILDREN
, A_S_HAVE_DEPENDENTS
, A_VA_STATUS
, A_S_NUM_IN_FAMILY
, A_S_NUM_IN_COLLEGE
, A_P_MARITAL_STATUS
, A_FATHER_SSN
, A_MOTHER_SSN
, A_PARENTS_NUM_FAMILY
, A_PARENTS_NUM_COLLEGE
, A_PARENTS_AGI
, A_P_US_TAX_PAID
, A_F_WORK_INCOME
, A_M_WORK_INCOME
, A_P_TOTAL_WSC
, COMMENT_CODES
, SAR_ACK_COMM_CODE
, PELL_GRANT_ELIG_FLAG
, REPROCESS_REASON_CODE
, DUPLICATE_DATE
, ISIR_TRANSACTION_TYPE
, FEDRAL_SCHL_CODE_INDICATOR
, MULTI_SCHOOL_CODE_FLAGS
, DUP_SSN_INDICATOR
, PAYMENT_ISIR
, RECEIPT_STATUS
, ISIR_RECEIPT_COMPLETED
, SYSTEM_RECORD_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, VERIF_TRACK_FLAG
, ACTIVE_ISIR
, FAFSA_DATA_VERIFY_FLAGS
, REJECT_OVERRIDE_A
, REJECT_OVERRIDE_C
, PARENT_MARITAL_STATUS_DATE
, LEGACY_RECORD_FLAG
, FATHER_FIRST_NAME_INITIAL_TXT
, FATHER_STEP_FATHER_BIRTH_DATE
, MOTHER_FIRST_NAME_INITIAL_TXT
, MOTHER_STEP_MOTHER_BIRTH_DATE
, PARENTS_EMAIL_ADDRESS_TXT
, ADDRESS_CHANGE_TYPE
, CPS_PUSHED_ISIR_FLAG
, ELECTRONIC_TRANSACTION_TYPE
, SAR_C_CHANGE_TYPE
, FATHER_SSN_MATCH_TYPE
, MOTHER_SSN_MATCH_TYPE
, REJECT_OVERRIDE_G_FLAG
, DHS_VERIFICATION_NUM_TXT
, DATA_FILE_NAME_TXT
, MESSAGE_CLASS_TXT
, REJECT_OVERRIDE_3_FLAG
, REJECT_OVERRIDE_12_FLAG
, REJECT_OVERRIDE_J_FLAG
, REJECT_OVERRIDE_K_FLAG
, REJECTED_STATUS_CHANGE_FLAG
, VERIFICATION_SELECTION_FLAG
FROM APPS.IGF_AP_ISIR_MATCHED;
|
|
|