SFA_ISIR_STU_VW(SQL View) |
Index Back |
|---|---|
Student ISIR View |
| SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.EFFDT , A.EFFSEQ , A.TABLE_ID , B.SFA_FAFSA_UUID , B.SFA_PERSON_UUID , A.DEPNDNCY_STAT , B.SFA_STD_SIGNATURE , B.SFA_TRANSACT_UUID , B.SFA_STD_CONSENT , B.SFA_STD_SIGNDATE , B.SFA_STD_STREET , B.SFA_STD_CITY , B.SFA_STD_ZIPCODE , B.SFA_STD_COUNTRY , B.SFA_STUDENT_SUFFIX , B.SFA_STUDENT_ITIN , B.SFA_STD_PARATT , B.SFA_STD_PARKILL , B.SFA_HIGH_SCHL_DIPL , B.SFA_TEACHER_CERT , B.SFA_STD_UNSUB , B.SFA_ORPHAN_DEC , B.SFA_ORPHAN_WARD , B.SFA_ORPHAN_FOSTER , B.SFA_STD_CIRCUM , B.SFA_HOMELESS_FAA , B.SFA_HOMELESS_TRIO , B.SFA_STD_OTHER , B.SFA_STD_UNUSUAL , B.SFA_STD_ETIC , B.SFA_STD_HOUSING , B.SFA_STD_MEDICAID , B.SFA_STD_36B , B.SFA_STD_FED_NONE , B.SFA_STD_1040 , B.SFA_STD_NON_TAX , B.SFA_STD_JOINT_TAX , B.SFA_STD_TAX_RET , B.SFA_FILED_SCHD1 , B.SFA_TAX_CREDIT1 , B.SFA_SPS_CONSENT , B.SFA_SPS_SIGNATURE , B.SFA_SPS_SIGNDATE , B.SFA_SPS_FIRSTNAME , B.SFA_SPS_MIDDLENAME , B.SFA_SPS_LASTNAME , B.SFA_SPS_SUFFIX , B.SFA_SPS_BIRTHDATE , B.SFA_SPS_SSN , B.SFA_SPS_ITIN , B.SFA_SPS_PHONE , B.SFA_SPS_EMAIL , B.SFA_SPS_STREET , B.SFA_SPS_CITY , B.SFA_SPS_STATE , B.SFA_SPS_ZIPCODE , B.SFA_SPS_COUNTRY , B.SFA_SPS_1040 , B.SFA_SPS_NON_TAX , B.SFA_SPS_TAX_RET , B.SFA_FILED_SCHD2 , A.DT_APP_COMPLETED , A.DRUG_OFFENSE_CONV , A.SFA_HIGH_SCHL_CODE FROM PS_ISIR_STUDENT A , PS_SFA_ISIR_STU B WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND A.TABLE_ID = B.TABLE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | TABLE_ID |
Character(1) | VARCHAR2(1) NOT NULL | Child Table Key |
| 7 | SFA_FAFSA_UUID | Character(36) | VARCHAR2(36) NOT NULL | 2425 FAFSA UUID |
| 8 | SFA_PERSON_UUID | Character(36) | VARCHAR2(36) NOT NULL | 2425 FAFSA UUID |
| 9 | DEPNDNCY_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Dependency Status
1=Independent 2=Dependent 3=Indepenedent/Pro Judgmnt D=Dependent I=Independent X=Dependent Reject Y=Independent Reject Z=Provisional Independent |
| 10 | SFA_STD_SIGNATURE | Character(1) | VARCHAR2(1) NOT NULL | 2425:Signature� |
| 11 | SFA_TRANSACT_UUID | Character(36) | VARCHAR2(36) NOT NULL | 2425 FAFSA UUID |
| 12 | SFA_STD_CONSENT | Character(1) | VARCHAR2(1) NOT NULL | 2425: Consent to Retrieve and Disclose FTI |
| 13 | SFA_STD_SIGNDATE | Date(10) | DATE | 2425:Signature Date |
| 14 | SFA_STD_STREET | Character(40) | VARCHAR2(40) NOT NULL | 2425: Street Address |
| 15 | SFA_STD_CITY | Character(30) | VARCHAR2(30) NOT NULL | 2425:City |
| 16 | SFA_STD_ZIPCODE | Character(10) | VARCHAR2(10) NOT NULL | 2425:Spouse Zip Code |
| 17 | SFA_STD_COUNTRY | Character(2) | VARCHAR2(2) NOT NULL | 2425: Country |
| 18 | SFA_STUDENT_SUFFIX | Character(10) | VARCHAR2(10) NOT NULL | 2425 Student Suffix |
| 19 | SFA_STUDENT_ITIN | Character(9) | VARCHAR2(9) NOT NULL | 2425: Student ITIN |
| 20 | SFA_STD_PARATT | Character(1) | VARCHAR2(1) NOT NULL |
2425:Either Parent Attend College
1=Yes 2=No 3=Dont Know |
| 21 | SFA_STD_PARKILL | Character(1) | VARCHAR2(1) NOT NULL |
2425:Parent Killed in the Line of Duty
1=Yes 2=No |
| 22 | SFA_HIGH_SCHL_DIPL | Character(1) | VARCHAR2(1) NOT NULL | 2425: High School Equivalent Diploma |
| 23 | SFA_TEACHER_CERT | Character(1) | VARCHAR2(1) NOT NULL |
2425: Pursuing Teaher Certification
1=Yes 2=No |
| 24 | SFA_STD_UNSUB | Character(1) | VARCHAR2(1) NOT NULL |
2425: Unsub Only
1=Yes 2=No |
| 25 | SFA_ORPHAN_DEC | Character(1) | VARCHAR2(1) NOT NULL | 2425: Parent Deceased |
| 26 | SFA_ORPHAN_WARD | Character(1) | VARCHAR2(1) NOT NULL |
2425: Ward of Court
1=Yes |
| 27 | SFA_ORPHAN_FOSTER | Character(1) | VARCHAR2(1) NOT NULL | 2425:In Foster Care |
| 28 | SFA_STD_CIRCUM | Character(1) | VARCHAR2(1) NOT NULL |
2425:Personal Circumstances: None of the above
1=Yes 2=No |
| 29 | SFA_HOMELESS_FAA | Character(1) | VARCHAR2(1) NOT NULL |
2425:Unaccompanied and Homeless (FAA)?
1=Yes |
| 30 | SFA_HOMELESS_TRIO | Character(1) | VARCHAR2(1) NOT NULL |
2425:Unaccompanied and Homeless (TRIO)?
1=Yes |
| 31 | SFA_STD_OTHER | Character(1) | VARCHAR2(1) NOT NULL |
2425:None of the above (Other Circumstances)
1=Yes |
| 32 | SFA_STD_UNUSUAL | Character(1) | VARCHAR2(1) NOT NULL |
2425:Unusual Circumstance
1=Yes |
| 33 | SFA_STD_ETIC | Character(1) | VARCHAR2(1) NOT NULL |
2425:Received EITC
1=Yes |
| 34 | SFA_STD_HOUSING | Character(1) | VARCHAR2(1) NOT NULL |
2425:Received Federal Housing Assistance
1=Yes |
| 35 | SFA_STD_MEDICAID | Character(1) | VARCHAR2(1) NOT NULL |
2425:Received Medicaid
1=Yes |
| 36 | SFA_STD_36B | Character(1) | VARCHAR2(1) NOT NULL |
2425:Received Refundable Credit for 36B Health Plan
1=Yes |
| 37 | SFA_STD_FED_NONE | Character(1) | VARCHAR2(1) NOT NULL |
2425:Federal Benefits: None of the Above�
1=Yes |
| 38 | SFA_STD_1040 | Character(1) | VARCHAR2(1) NOT NULL |
2425:Filed 1040 or 1040NR
1=Yes 2=No |
| 39 | SFA_STD_NON_TAX | Character(1) | VARCHAR2(1) NOT NULL |
2425:Filed Non-U.S. Tax Return
1=Yes 2=No |
| 40 | SFA_STD_JOINT_TAX | Character(1) | VARCHAR2(1) NOT NULL |
2425:Filed Joint Return with Current Spouse
1=Yes 2=No |
| 41 | SFA_STD_TAX_RET | Character(1) | VARCHAR2(1) NOT NULL |
2425: Student Tax Return Filing Status
1=Yes 2=No |
| 42 | SFA_FILED_SCHD1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Filed Schedule A, B, D, E, F or H? |
| 43 | SFA_TAX_CREDIT1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Earned Income Tax Credit Received During Tax Year? |
| 44 | SFA_SPS_CONSENT | Character(1) | VARCHAR2(1) NOT NULL | 2425: Consent to Retrieve and Disclose FTI |
| 45 | SFA_SPS_SIGNATURE | Character(1) | VARCHAR2(1) NOT NULL | 2425:Signature� |
| 46 | SFA_SPS_SIGNDATE | Date(10) | DATE | 2425:Signature Date |
| 47 | SFA_SPS_FIRSTNAME | Character(35) | VARCHAR2(35) NOT NULL | 2425: First Name |
| 48 | SFA_SPS_MIDDLENAME | Character(15) | VARCHAR2(15) NOT NULL | 2425:Middle Name� |
| 49 | SFA_SPS_LASTNAME | Character(35) | VARCHAR2(35) NOT NULL | 2425:Last Name |
| 50 | SFA_SPS_SUFFIX | Character(10) | VARCHAR2(10) NOT NULL | 2425 Spouse Suffix |
| 51 | SFA_SPS_BIRTHDATE | Date(10) | DATE | 2425:Spouse Birthdate |
| 52 | SFA_SPS_SSN | Character(9) | VARCHAR2(9) NOT NULL | 2425:Social Security Number |
| 53 | SFA_SPS_ITIN | Character(9) | VARCHAR2(9) NOT NULL | 2425: Spouse ITIN |
| 54 | SFA_SPS_PHONE | Character(10) | VARCHAR2(10) NOT NULL | 2425:Spouse Phone Number |
| 55 | SFA_SPS_EMAIL | Character(50) | VARCHAR2(50) NOT NULL | 2425:Spouse Email Address |
| 56 | SFA_SPS_STREET | Character(40) | VARCHAR2(40) NOT NULL | 2425: Spouse Street Address |
| 57 | SFA_SPS_CITY | Character(30) | VARCHAR2(30) NOT NULL | 2425:Spouse City |
| 58 | SFA_SPS_STATE | Character(2) | VARCHAR2(2) NOT NULL | 2425:Spouse State |
| 59 | SFA_SPS_ZIPCODE | Character(10) | VARCHAR2(10) NOT NULL | 2425:Spouse Zip Code |
| 60 | SFA_SPS_COUNTRY | Character(2) | VARCHAR2(2) NOT NULL | 2425: Spouse Country |
| 61 | SFA_SPS_1040 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Filed 1040 or 1040NR |
| 62 | SFA_SPS_NON_TAX | Character(1) | VARCHAR2(1) NOT NULL | 2425:Filed Non-U.S. Tax Return |
| 63 | SFA_SPS_TAX_RET | Character(1) | VARCHAR2(1) NOT NULL | 2425: Spouse Tax Return Filing Status |
| 64 | SFA_FILED_SCHD2 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Filed Schedule A, B, D, E, F or H? |
| 65 | DT_APP_COMPLETED | Date(10) | DATE | Date Application Completed |
| 66 | DRUG_OFFENSE_CONV | Character(1) | VARCHAR2(1) NOT NULL |
Drug Offense Conviction
1=Eligible 2=Partially Eligible 3=Ineligible or Don't know I=Institutional Override |
| 67 | SFA_HIGH_SCHL_CODE | Character(12) | VARCHAR2(12) NOT NULL | High School Code |