DEFINITIONS AND CODES FOR DATA ELEMENTS - SBCTC

  • Doc File 347.50KByte



FINANCIAL AID

The SBCTC updates the financial aid database quarterly, replacing all records with the latest quarter’s data. The colleges run an MIS job at the close of each quarter to create these files for the SBCTC.

AWARD DETAIL Table: For each student, the amount of financial aid awarded to that student by code by award session year, with the award status and amount. The SBCTC does most of its data analysis from this table.

|COLLEGE (PK) |Data Type: text |

| |Size: 3 |

| |Allow Null: No |

| |Definition: A three-digit code used to identify each community or technical college in the state of |

| |Washington. College codes begin with the two-digit district code. |

| | |

| |Valid Codes: |

| |010 |

| |PENINSULA |

| |150 |

| |WENATCHEE VALLEY |

| | |

| |020 |

| |GRAYS HARBOR |

| |160 |

| |YAKIMA VALLEY |

| | |

| |030 |

| |OLYMPIC |

| |170 |

| |SPOKANE A DISTRICT |

| | |

| |040 |

| |SKAGIT VALLEY |

| |171 |

| |SPOKANE COMMUNITY |

| | |

| |050 |

| |EVERETT |

| |172 |

| |SPOKANE FALLS |

| | |

| |060 |

| |SEATTLE A DISTRICT |

| |180 |

| |BIG BEND |

| | |

| |062 |

| |SEATTLE CENTRAL |

| |190 |

| |COLUMBIA BASIN |

| | |

| |063 |

| |SEATTLE NORTH |

| |200 |

| |WALLA WALLA |

| | |

| |064 |

| |SEATTLE SOUTH |

| |210 |

| |WHATCOM |

| | |

| |065 |

| |SEATTLE OC INSTITUTE |

| |220 |

| |TACOMA |

| | |

| |070 |

| |SHORELINE |

| |230 |

| |EDMONDS |

| | |

| |080 |

| |BELLEVUE |

| |240 |

| |SOUTH PUGET SOUND |

| | |

| |090 |

| |HIGHLINE |

| |250 |

| |BELLINGHAM |

| | |

| |100 |

| |GREEN RIVER |

| |260 |

| |LAKE WASHINGTON |

| | |

| |110 |

| |PIERCE DISTRICT |

| |270 |

| |RENTON |

| | |

| |111 |

| |PIERCE / STEILACOOM |

| |280 |

| |BATES |

| | |

| |112 |

| |PIERCE / PUYALLUP |

| |290 |

| |CLOVER PARK |

| | |

| |121 |

| |CENTRALIA |

| |300 |

| |CASCADIA |

| | |

| |130 |

| |LOWER COLUMBIA |

| |890 |

| |SBCTC |

| | |

| |140 |

| |CLARK |

| |895 |

| |CIS |

| | |

|STD_ID_NO (PK) |Data Type: text |

| |Size: 9 |

| |Allow Null: No |

| |Definition: Student Identification Number. This is the nine-digit social security number for a student. |

|AWD_CODE (PK) |Data Type: text |

| |Size: 2 |

| |Allow Null: No |

| |Definition: Award Code. This is the college-assigned award code for the types of financial aid. These |

| |codes vary from college to college. |

| | |

| |Pell is standard across system as “01” |

|AWD_STATUS (PK) |Data Type: text |

| |Size: 1 |

| |Allow Null: No |

| |Definition: Award Status. This is the status of a financial aid award. Code 2 is used for system |

| |reporting including, but not limited to: IPEDS, Opportunity Grant, Perkins, Work First, Worker Retraining |

| | |

| |Note: The award status codes above 5 are college defined.  Please check with your Financial Aid office to |

| |see how they have them defined. |

| | |

| | |

| |Valid Codes: |

| |1 |

| |Offered |

| | |

| |2 |

| |Accepted |

| |Used for System Reporting including, but not limited to: |

| |IPEDS |

| |Opportunity Grant |

| |Perkins |

| |Work First |

| |Worker Retraining |

| | |

| |3 |

| |Certified or Offered |

| | |

| |4 |

| |Cancelled by staff |

| | |

| |5 |

| |Award rejected or cancelled |

| | |

| | |

| | |

| | |

|AWD_AMT |Data Type: number |

| |Size: decimal Precision: 8 Scale: 2 |

| |Allow Null: No |

| |Definition: Award Amount. This is the dollar amount of the financial aid award. |

|YR_SES (PK) |Data Type: text |

| |Size: 4 |

| |Allow Null: No |

| |Definition: Award Session. This is the year quarter of the financial aid award. For example, in |

| |2009-10, the award sessions are A901 (Summer), A902 (Fall), A903 (Winter), A904 (Spring), and A905 (Summer|

| |2). |

| |For reporting purposes, the SBCTC combines Summer2 from the previous year with Summer from the reporting |

| |year. For example, if reporting Summer 2009-10, A895 is combined with A901. If reporting the entire |

| |2009-10 year, SBCTC includes A895 and A901-A904. |

|TRANS_DATE |Data Type: text |

| |Size: 8 |

| |Allow Null: Yes |

| |Definition: Transaction Date. This is the last date an award amount was changed or the date of the |

| |initial award if no change was made. |

|AWD_SUB_CODE |Data Type: text |

| |Size: 6 |

| |Allow Null: Yes |

| |Definition: Award Sub Code. This is the budget program code related to the financial aid award. |

|STD_CODE |Data Type: text |

| |Size: 2 |

|Moved from AWARD_CODES table to|Allow Null: Yes |

|AWARD_DETAIL table effective |Definition: Standard Code. This is a two-digit code assigned by SBCTC. It is SBCTC’s translation of the|

|B01 |college-assigned Award Code (AWD_CODE) to a common coding structure for use in IPEDS reporting and |

| |analysis by SBCTC. |

| |For a list of valid codes, see STANDARD AWARD CODES Table at the bottom of this document. |

|STATUS |Data Type: text |

| |Size: 3 |

|Added to AWARD_DETAIL table |Allow Null: No |

|effective B01 |Definition: Status of financial aid award |

| |Valid Codes: |

| |O |

| |Aid Awarded/Offered |

| | |

| |R |

| |Aid Received/Accepted |

| | |

| |X |

| |Other |

| | |

AWARD CODES Table: for every college, the financial aid award codes used, along with the names and type of award. This table also includes a standard code created by the SBCTC to make it easier to summarize data on a system level.

|COLLEGE (PK) |Data Type: text |

| |Size: 3 |

| |Allow Null: No |

| |Definition: A three-digit code used to identify each community or technical college in the state of |

| |Washington. College codes begin with the two-digit district code. |

| | |

| |Valid Codes: |

| |010 |

| |PENINSULA |

| |150 |

| |WENATCHEE VALLEY |

| | |

| |020 |

| |GRAYS HARBOR |

| |160 |

| |YAKIMA VALLEY |

| | |

| |030 |

| |OLYMPIC |

| |170 |

| |SPOKANE A DISTRICT |

| | |

| |040 |

| |SKAGIT VALLEY |

| |171 |

| |SPOKANE COMMUNITY |

| | |

| |050 |

| |EVERETT |

| |172 |

| |SPOKANE FALLS |

| | |

| |060 |

| |SEATTLE A DISTRICT |

| |180 |

| |BIG BEND |

| | |

| |062 |

| |SEATTLE CENTRAL |

| |190 |

| |COLUMBIA BASIN |

| | |

| |063 |

| |SEATTLE NORTH |

| |200 |

| |WALLA WALLA |

| | |

| |064 |

| |SEATTLE SOUTH |

| |210 |

| |WHATCOM |

| | |

| |065 |

| |SEATTLE OC INSTITUTE |

| |220 |

| |TACOMA |

| | |

| |070 |

| |SHORELINE |

| |230 |

| |EDMONDS |

| | |

| |080 |

| |BELLEVUE |

| |240 |

| |SOUTH PUGET SOUND |

| | |

| |090 |

| |HIGHLINE |

| |250 |

| |BELLINGHAM |

| | |

| |100 |

| |GREEN RIVER |

| |260 |

| |LAKE WASHINGTON |

| | |

| |110 |

| |PIERCE DISTRICT |

| |270 |

| |RENTON |

| | |

| |111 |

| |PIERCE / STEILACOOM |

| |280 |

| |BATES |

| | |

| |112 |

| |PIERCE / PUYALLUP |

| |290 |

| |CLOVER PARK |

| | |

| |121 |

| |CENTRALIA |

| |300 |

| |CASCADIA |

| | |

| |130 |

| |LOWER COLUMBIA |

| |890 |

| |SBCTC |

| | |

| |140 |

| |CLARK |

| |895 |

| |CIS |

| | |

|AWD_CODE (PK) |Data Type: text |

| |Size: 2 |

| |Allow Null: No |

| |Definition: Award Code. This is award code assigned by the college for the types of financial aid. |

| |These codes vary from college to college. |

|AWD_NAME |Data Type: text |

| |Size: 26 |

| |Allow Null: Yes |

| |Definition: Award Name. This is the name or title for the college-assigned award code. These vary from |

| |college to college. |

|AWD_TYPE |Data Type: text |

| |Size: 2 |

| |Allow Null: Yes |

| |Definition: Award Type. This is the type of financial aid award and this data element varies from |

| |college to college. |

| | |

| |Valid Codes: |

| | |

| |GT Grant |

| |GS Guaranteed Student Loan |

| |LN Loan |

| |SC Scholarship |

| |TA Tuition Assistance |

| |WK Work Study |

|AWD_NAME_ |Data Type: text |

|SHORT |Size: 8 |

| |Allow Null: Yes |

| |Definition: Award Name Short. This is a shortened name for the type of award, with a length of 8 |

| |characters. |

|STD_CODE |Data Type: text |

| |Size: 2 |

|Moved from AWARD_CODES table to|Allow Null: Yes |

|AWARD_DETAIL table effective |Definition: Standard Code. This is a two-digit code assigned by SBCTC. It is SBCTC’s translation of the|

|B01 |college-assigned Award Code (AWD_CODE) to a common coding structure for use in IPEDS reporting and |

| |analysis by SBCTC. |

| |For a list of valid codes, see STANDARD AWARD CODES Table at the bottom of this document. |

|IPEDS_CAT |Data Type: text |

| |Size: 9 |

|Retired effective B01 |Allow Null: Yes |

| |Definition: IPEDS Category. |

| | |

| |Example of Use: This category code is used to identify the different types of aid that are used in IPEDS |

| |reporting. |

| |For a list of valid IPEDS categories, see STANDARD AWARD CODES Table at the bottom of this document. |

AWARD SUMMARY Table: for each student, the dollar amount awarded for financial aid during the year (derived from the AWARD_DETAIL table where AWD_STATUS = “2”).

|STD_ID_NO |Data Type: text |

| |Size: 9 |

| |Allow Null: No |

| |Definition: Student Identification Number. This is the nine-digit social security number for a student. |

| | |

|YTD_TOTAL |Data Type: number |

| |Size: decimal Precision: 8 Scale: 2 |

| |Allow Null: Yes |

| |Definition: Year to Date Total. This is the year to date dollar amount awarded in financial aid to a |

| |student. |

MASTER Table: For every student (by college), demographic information about the student. The SBCTC typically links to the STUDENT Table for demographic information, rather than to the MASTER Table. However, some of these data elements are unique to this table.

|COLLEGE (PK) |Data Type: text |

| |Size: 3 |

| |Allow Null: No |

| |Definition: A three-digit code used to identify each community or technical college in the state of |

| |Washington. College codes begin with the two-digit district code. |

| | |

| |Valid Codes: |

| |010 |

| |PENINSULA |

| |150 |

| |WENATCHEE VALLEY |

| | |

| |020 |

| |GRAYS HARBOR |

| |160 |

| |YAKIMA VALLEY |

| | |

| |030 |

| |OLYMPIC |

| |170 |

| |SPOKANE A DISTRICT |

| | |

| |040 |

| |SKAGIT VALLEY |

| |171 |

| |SPOKANE COMMUNITY |

| | |

| |050 |

| |EVERETT |

| |172 |

| |SPOKANE FALLS |

| | |

| |060 |

| |SEATTLE A DISTRICT |

| |180 |

| |BIG BEND |

| | |

| |062 |

| |SEATTLE CENTRAL |

| |190 |

| |COLUMBIA BASIN |

| | |

| |063 |

| |SEATTLE NORTH |

| |200 |

| |WALLA WALLA |

| | |

| |064 |

| |SEATTLE SOUTH |

| |210 |

| |WHATCOM |

| | |

| |065 |

| |SEATTLE OC INSTITUTE |

| |220 |

| |TACOMA |

| | |

| |070 |

| |SHORELINE |

| |230 |

| |EDMONDS |

| | |

| |080 |

| |BELLEVUE |

| |240 |

| |SOUTH PUGET SOUND |

| | |

| |090 |

| |HIGHLINE |

| |250 |

| |BELLINGHAM |

| | |

| |100 |

| |GREEN RIVER |

| |260 |

| |LAKE WASHINGTON |

| | |

| |110 |

| |PIERCE DISTRICT |

| |270 |

| |RENTON |

| | |

| |111 |

| |PIERCE / STEILACOOM |

| |280 |

| |BATES |

| | |

| |112 |

| |PIERCE / PUYALLUP |

| |290 |

| |CLOVER PARK |

| | |

| |121 |

| |CENTRALIA |

| |300 |

| |CASCADIA |

| | |

| |130 |

| |LOWER COLUMBIA |

| |890 |

| |SBCTC |

| | |

| |140 |

| |CLARK |

| |895 |

| |CIS |

| | |

| | |

|STD_ID_NO (PK) |Data Type: text |

| |Size: 9 |

| |Allow Null: No |

| |Definition: Student Identification Number. This is the nine-digit social security number for a student. |

| | |

|STATE |Data Type: text |

| |Size: 2 |

| |Allow Null: Yes |

| |Definition: State. This is the two-character code for the student’s state of residence. |

|BIRTHDATE |Data Type: text |

| |Size: 8 |

| |Allow Null: Yes |

| |Definition: Student Birth Date. The student’s birth date in the format YYYYMMDD. |

|ELIG_CODE |Data Type: text |

| |Size: 2 |

| |Allow Null: Yes |

| |Definition: Eligibility Code. This is a code in the SAFERS Academic Progress Module to determine if a |

| |student is eligible for all aid, eligible for only certain programs, or ineligible. The SBCTC does not |

| |use this data element. |

|RACE |Data Type: text |

| |Size: 1 |

| |Allow Null: Yes |

| |Definition: Race/Ethnic Background. This is the race/ethnic background of the student. |

| | |

| |Valid Codes: |

| |1 Asian |

| | |

| |2 African American |

| | |

| |3 American Indian |

| | |

| |4 Hispanic |

| | |

| |5 Pacific Islander |

| | |

| |6 White |

| | |

| |7 Native Hawaiian or |

| |Other Pacific Islander |

| | |

| |8 Alaska Native |

| | |

| |9 Multi-Racial |

| | |

| |0 Other Race |

| | |

| |Blank Not Reported |

| | |

|SEX |Data Type: text |

| |Size: 1 |

| |Allow Null: Yes |

| |Definition: Sex. This is the gender of the student. |

| | |

| |Valid Codes: |

| |M Male |

| |F Female |

| |Blank Not Reported |

|GRAD_YRMO |Data Type: text |

| |Size: 8 |

| |Allow Null: Yes |

| |Definition: Graduation Year/Month. This is the year and month when a student expects to graduate. The |

| |format is YYYYMMDD. |

|DEP_INDEP_CD |Data Type: text |

| |Size: 1 |

| |Allow Null: Yes |

| |Definition: Dependent, Independent Code. This is a code that indicates if a student is independent of his|

| |or her parents or not. |

| | |

| |Valid Codes: |

| |I Independent |

| |D Dependent |

|FAMILY_INCOME |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Family Income. This is the total income for both the student and parents combined. |

|FAMILY_CNTRIB |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Family Contribution. This is the total family income minus the student’s contribution. |

|MARITAL_STAT |Data Type: text |

| |Size: 2 |

| |Allow Null: Yes |

| |Definition: Marital Status. This is the marital status of the student. |

| | |

| |Valid Codes: |

| |DV Divorced |

| |MD Married |

| |SG Single |

| |SP Single Parent |

|NO_DEP |Data Type: number |

| |Size: byte |

| |Allow Null: No |

| |Definition: Number of Dependents. This is the number of people in the student’s household minus the |

| |student if not married, or minus the student and spouse if married. For example, a married student with 3|

| |in the household would have a 1 in the NO_DEP field. |

|SES_YR_START |Data Type: text |

| |Size: 4 |

| |Allow Null: Yes |

| |Definition: Session Start Year/Quarter. This is the first year quarter that an award was given in the |

| |year, usually Summer Quarter. The first three positions are the year, and the last position is the |

| |quarter. For example, Fall Quarter 1998 would be 9892. If disbursements for financial aid awards are made|

| |using monies from the previous academic year but are not received by the student until summer quarter of |

| |the following academic year, a year quarter ending with a “5” (for example, 9785) is used. |

|SES_YR_END |Data Type: text |

| |Size: 4 |

| |Allow Null: Yes |

| |Definition: Session End Year/Quarter. This is the last year quarter of an award year, usually Spring |

| |Quarter. The first three positions are the year, and the last position is the quarter. For example, Fall |

| |Quarter 1998 would be 9892. If disbursements for financial aid awards are made using monies from the |

| |previous academic year but are not received by the student until summer quarter of the following academic |

| |year, a year quarter ending with a “5” (for example, 9785) is used. Disbursements of this kind must be |

| |made before July 1. |

|STD_INCOME |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Student Income. This is the student’s total income, including both taxed and untaxed |

| |amounts. |

|STD_CONTRIB |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Student Contribution. This is the student’s portion of the total family income. |

|STD_NEED |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Student Need. This is the total budgeted amount of financial aid, plus or minus any amount |

| |in the budget supplemental income field. |

|YR_IN_SCH |Data Type: text |

| |Size: 1 |

| |Allow Null: Yes |

| |Definition: Year In School. This is the student’s year in school. |

| | |

| |Valid Codes: |

| |First Year (freshman) |

| |Second Year (sophomore) |

| |Third Year (Junior) |

| |Fourth Year (senior) |

| |Fifth Year (other undergraduate student) |

| |Six Year (first year graduate student) |

| |Seventh Year (second year graduate student) |

| |Eighth Year (third year graduate student) |

| |Ninth Year (beyond third year graduate student) |

|STD_BUD_AMT |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Student Budgeted amount. This is the budgeted amount assigned by a college for a student’s |

| |financial aid. |

|BUD_MOS |Data Type: number |

| |Size: decimal Precision: 3 Scale: 1 |

| |Allow Null: No |

| |Definition: Budgeted Months. This is the number of months a student will attend for the budgeted amount |

| |of financial aid. |

|STATUS |Data Type: text |

| |Size: 2 |

| |Allow Null: Yes |

| |Definition: Student Status. This is the student’s status in the financial aid process. |

| | |

| |Valid Codes: |

| |IN Independent, not in verification |

| |IV Independent, in verification |

| |DE Dependent, not in verification |

| |DV Dependent, in verification |

| |SS Student without FAF data but in SMS |

|VETERAN_STAT |Data Type: text |

| |Size: 1 |

| |Allow Null: Yes |

| |Definition: Veteran Status. This is the student’s veteran status. |

| | |

| |Valid Codes: |

| |Veteran |

| |Not a Veteran |

| |Blank Not a Veteran |

NEED Table: For each applicant for financial aid (by college), selected demographic information, income information, and other benefits. Not all applicants are included in the AWARD DETAIL or MASTER Tables.

|COLLEGE (PK) |Data Type: text |

| |Size: 3 |

| |Allow Null: No |

| |Definition: A three-digit code used to identify each community or technical college in the state of |

| |Washington. College codes begin with the two-digit district code. |

| | |

| |Valid Codes: |

| |010 |

| |PENINSULA |

| |150 |

| |WENATCHEE VALLEY |

| | |

| |020 |

| |GRAYS HARBOR |

| |160 |

| |YAKIMA VALLEY |

| | |

| |030 |

| |OLYMPIC |

| |170 |

| |SPOKANE A DISTRICT |

| | |

| |040 |

| |SKAGIT VALLEY |

| |171 |

| |SPOKANE COMMUNITY |

| | |

| |050 |

| |EVERETT |

| |172 |

| |SPOKANE FALLS |

| | |

| |060 |

| |SEATTLE A DISTRICT |

| |180 |

| |BIG BEND |

| | |

| |062 |

| |SEATTLE CENTRAL |

| |190 |

| |COLUMBIA BASIN |

| | |

| |063 |

| |SEATTLE NORTH |

| |200 |

| |WALLA WALLA |

| | |

| |064 |

| |SEATTLE SOUTH |

| |210 |

| |WHATCOM |

| | |

| |065 |

| |SEATTLE OC INSTITUTE |

| |220 |

| |TACOMA |

| | |

| |070 |

| |SHORELINE |

| |230 |

| |EDMONDS |

| | |

| |080 |

| |BELLEVUE |

| |240 |

| |SOUTH PUGET SOUND |

| | |

| |090 |

| |HIGHLINE |

| |250 |

| |BELLINGHAM |

| | |

| |100 |

| |GREEN RIVER |

| |260 |

| |LAKE WASHINGTON |

| | |

| |110 |

| |PIERCE DISTRICT |

| |270 |

| |RENTON |

| | |

| |111 |

| |PIERCE / STEILACOOM |

| |280 |

| |BATES |

| | |

| |112 |

| |PIERCE / PUYALLUP |

| |290 |

| |CLOVER PARK |

| | |

| |121 |

| |CENTRALIA |

| |300 |

| |CASCADIA |

| | |

| |130 |

| |LOWER COLUMBIA |

| |890 |

| |SBCTC |

| | |

| |140 |

| |CLARK |

| |895 |

| |CIS |

| | |

|STD_ID_NO (PK) |Data Type: text |

| |Size: 9 |

| |Allow Null: No |

| |Definition: Student Identification Number. This is the nine-digit social security number for a student. |

|PAR_HSLD_COL |Data Type: number |

| |Size: byte |

| |Allow Null: No |

| |Definition: Number of People in Parent Household in College. This is the number of people who reside in |

| |the parent’s household who are going to be in college at least half time during the academic year for which |

| |the student is applying for financial aid. |

|PAR_HSLD |Data Type: number |

| |Size: byte |

| |Allow Null: No |

| |Definition: People in Parent Household. This is the number of family members being supported by the |

| |parents more than 50% during the base year. |

|PAR_INC |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Parent Income. This is the parent’s income (earned from work) for the base year. |

|PAR_INC_TAX |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Parent Income Tax. This is the amount of income tax paid (not withheld) from the parents in |

| |the prior year tax return. |

|PAR_INC_UNTAXED |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Parents’ Untaxed Income Total Calculated by CPS. This amount is calculated by the CPS as the |

| |sum of Parents Pension Payments, IRA Payments, Child Support Received, Interest Income, IRA Distributions, |

| |Untaxed Pensions, Military/Clergy Allowances, Veterans Noneducation Benefits, and Other Untaxed Income |

| |rather than provided by the applicant. If greater than 99,999 set to 99,999. Added in A90. |

|PAR_ADDL_FIN_INF |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Parents’ Additional Financial Information Total Calculated by CPS. This amount is calculated by|

| |the CPS as the sum of Parent’s Education Credits, Child Support Paid, Need-Based Employment, and Grant |

| |Scholarship Aid rather than provided by the applicant. If greater than 99,999 set to 99,999. Added in A90. |

|STD_HSLD |Data Type: number |

| |Size: byte |

| |Allow Null: No |

| |Definition: Student Household Size. This is the number of people in the independent student’s household |

| |who are being supported more than 50% of the year. |

|STD_HSLD_COL |Data Type: number |

| |Size: byte |

| |Allow Null: No |

| |Definition: Number of People in Student Household in College. This is the number of people in the |

| |independent student’s household who are going to be in college at least half time during the academic year |

| |for which the student is applying for financial aid. |

|STD_INC |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Student Income. This is the student’s income (earned from work) in the base year for which the|

| |student is applying for financial aid. |

|STD_INC_TAX |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Student Income Tax. This is the amount of income tax paid (not withheld) from the independent |

| |student’s prior year tax return. |

|VET_BENE_TYPE |Data Type: text |

| |Size: 1 |

| |Allow Null: Yes |

| |Definition: Type of Veterans Benefits. Added in A90. |

| |Valid Codes: |

| |1=Montgomery GI Bill – Active Duty (Chapter 30) |

| |2=Post-9/11 GI Bill (Chapter 33) |

| |3=Montgomery GI Bill – Selected Reserve (Chapter 1606) |

| |4=Reserve Educational Assistance Program (Chapter 1607) |

| |5=Vocational Rehabilitation and Employment (Chapter 31) |

| |6=Dependents’ Educational Assistance (Chapter 35) |

| |7=Any other type of veterans education benefits |

| |Blank |

|VET_BENE_RCV |Data Type: text |

| |Size: 1 |

| |Allow Null: Yes |

| |Definition: Receiving Veterans Benefits. Added in A90. |

| |Valid Codes: |

| |1=Yes |

| |2=No |

| |Blank |

|STD_INC_UNTAXED |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Students’ Untaxed Income Total Calculated by CPS. This amount is calculated by the CPS as the |

| |sum of Students Pension Payments, IRA Payments, Child Support Received, Interest Income, IRA Distributions, |

| |Untaxed Pensions, Military/Clergy Allowances, Veterans Noneducation Benefits, Other Untaxed Income, and |

| |Other Non-Reported Money Received rather than provided by the applicant. If greater than 99,999 set to |

| |99,999. Added in A90. |

|STD_ADDL_FIN_INF |Data Type: number |

| |Size: long integer |

| |Allow Null: No |

| |Definition: Students’ Additional Financial Information Total Calculated by CPS. This amount is calculated |

| |by the CPS as the sum of Student’s Education Credits, Child Support Paid, Need-Based Employment, and Grant |

| |Scholarship Aid rather than provided by the applicant. If greater than 99,999 set to 99,999. Added in A90. |

|STD_SEX |Data Type: text |

| |Size: 1 |

| |Allow Null: Yes |

| |Definition: This is the student’s gender. |

| | |

| |Valid Codes: |

| |Male |

| |Female |

| |Blank Not Reported |

|STD_BIRTH |Data Type: text |

| |Size: 8 |

| |Allow Null: Yes |

| |Definition: Student Birth Date. The student’s birth date in the format YYYYMMDD. |

|COLLEGE_ |Data Type: text |

|CHOICES(1) |Size: 6 |

| |Allow Null: Yes |

| |Definition: Student College Choice #1. The Title IV Institution Code of a college that the student wants |

| |the financial aid data sent to. Students may choose up to 6 colleges. See COLLEGE CHOICE Table for codes. |

|COLLEGE_ |Data Type: text |

|CHOICES(2) |Size: 6 |

| |Allow Null: Yes |

| |Definition: Student College Choice #2. The Title IV Institution Code of a college that the student wants |

| |the financial aid data sent to. Students may choose up to 6 colleges. See COLLEGE CHOICE Table for codes. |

|COLLEGE_ |Data Type: text |

|CHOICES(3) |Size: 6 |

| |Allow Null: Yes |

| |Definition: Student College Choice #3. The Title IV Institution Code of a college that the student wants |

| |the financial aid data sent to. Students may choose up to 6 colleges. See COLLEGE CHOICE Table for codes. |

|COLLEGE_ |Data Type: text |

|CHOICES(4) |Size: 6 |

| |Allow Null: Yes |

| |Definition: Student College Choice #4. The Title IV Institution Code of a college that the student wants |

| |the financial aid data sent to. Students may choose up to 6 colleges. See COLLEGE CHOICE Table for codes. |

|COLLEGE_ |Data Type: text |

|CHOICES(5) |Size: 6 |

| |Allow Null: Yes |

| |Definition: Student College Choice #5. The Title IV Institution Code of a college that the student wants |

| |the financial aid data sent to. Students may choose up to 6 colleges. See COLLEGE CHOICE Table for codes. |

|COLLEGE_ |Data Type: text |

|CHOICES(6) |Size: 6 |

| |Allow Null: Yes |

| |Definition: Student College Choice #5. The Title IV Institution Code of a college that the student wants |

| |the financial aid data sent to. Students may choose up to 6 colleges. See COLLEGE CHOICE Table for codes. |

|STD_MARITAL |Data Type: text |

| |Size: 1 |

| |Allow Null: Yes |

| |Definition: Student Marital Status. This is the student’s marital status. |

| | |

| |Valid Codes: |

| |1 Not married |

| |2 Married |

| |3 Separated |

|STD_STATE |Data Type: text |

| |Size: 2 |

| |Allow Null: Yes |

| |Definition: Student State. This is the two-character state where the student resides. |

|GRADE_LEVEL_PA |Data Type: text |

| |Size: 1 |

| |Allow Null: Yes |

| |Definition: Father’s Highest Grade Level. This is the highest grade completed by the student’s father. |

| | |

| |Valid Codes: |

| |Kindergarten through 8th grade |

| |Grades 8-12 |

| |College |

| |Unknown |

|GRADE_LEVEL_MA |Data Type: text |

| |Size: 1 |

| |Allow Null: Yes |

| |Definition: Mother’s Highest Grade Level. This is the highest grade completed by the student’s mother. |

| | |

| |Valid Codes: |

| |1 Kindergarten thru 8th grade |

| |2 Grades 8-12 |

| |College |

| |Unknown |

|STD_RACE |Data Type: text |

| |Size: 1 |

| |Allow Null: Yes |

| |Definition: Student Race. This is the race/ethnic background of the student. The codes are: |

| | |

| |1 Asian/Pacific Islander |

| |2 African American |

| |3 Native American |

| |4 Hispanic |

| |6 White |

| |0 Other Race |

| |Blank Not Reported/Unknown |

COLLEGE-CHOICE Table: This is the TITLE IV institution number, name, and state where a student would like to have his or her financial award sent to.

|INST_NUM (PK) |Data Type: text |

| |Size: 6 |

| |Allow Null: No |

| |Definition: Institution Number. This is the Title IV institution code. |

|INST_NAME |Data Type: text |

| |Size: 75 |

| |Allow Null: Yes |

| |Definition: Institution Name. This is the Title IV institution name. |

|STATE |Data Type: text |

| |Size: 2 |

| |Allow Null: Yes |

| |Definition: Institution State. This is the two-character state where the Title IV institution is located. |

|YRQ_ADDED | |

| | |

|Field added effective B01 | |

STANDARD AWARD CODES Table: This is a lookup table for the SBCTC-assigned standard award codes.

|STD_CODE (PK) |Data Type: text |

| |Size: 2 |

| |Allow Null: No |

| |Definition: Standard Code. This is a two-digit code assigned by SBCTC. It is SBCTC’s translation of the |

| |college-assigned Award Code (AWD_CODE) to a common coding structure for use in IPEDS reporting and analysis by SBCTC. |

| |For a list of valid codes, see STANDARD AWARD CODES Table at the bottom of this document. |

|STANDARD_AWARD_ |Data Type: text |

|CATEGORY |Size: 47 |

| |Allow Null: Yes |

| |Definition: Standard Award Category. This is the name or title given to the SBCTC-assigned Standard Code. |

| |For a list of standard award categories, see STANDARD AWARD CODES Table at the bottom of this document. |

|IPEDS_CAT |Data Type: text |

| |Size: 9 |

| |Allow Null: Yes |

| |Definition: IPEDS Category (short title). |

| | |

| |Example of Use: This is an abbreviated version of the IPEDS category that makes it easy to query for the different types |

| |of aid that are used in IPEDS reporting. |

| |For a list of valid IPEDS categories, see STANDARD AWARD CODES Table at the bottom of this document. |

|IPEDS_ |Data Type: text |

|CATEGORY |Size: 19 |

| |Allow Null: Yes |

| |Definition: IPEDS Category (full title). |

| | |

| |Example of Use: This is the full IPEDS category title that identifies the different types of aid that are used in IPEDS |

| |reporting. |

| |For a list of valid IPEDS categories, see STANDARD AWARD CODES Table at the bottom of this document. |

|SBCTC STANDARD AWARD CODES Table |

|STD_CODE |

|Standard Award Name |

|IPEDS Category |

| |

|01 |

|Federal Pell Grant |

|FEDERAL_GRANT_PELL |

| |

|02 |

|Federal SEOG |

|FEDERAL_GRANT_OTHER |

| |

|03 |

|Bureau of Indian Affairs |

|FEDERAL_GRANT_OTHER |

| |

|04 |

|Gear-Up |

|FEDERAL_GRANT_OTHER |

| |

|05 |

|Academic Competitiveness Grant (ACG) |

|FEDERAL_GRANT_OTHER |

| |

|06 |

|SMART Grant |

|FEDERAL_GRANT_OTHER |

| |

|07 |

|TRiO Student Support Services Scholarship |

|FEDERAL_GRANT_OTHER |

| |

|10 |

|2.5/3.5% Waiver/Grant |

|INSTITUTIONAL |

| |

|11 |

|Institutional Grant or Waivers |

|INSTITUTIONAL |

| |

|12 |

|3% Waiver |

|INSTITUTIONAL |

| |

|13 |

|Opportunity Grants |

|INSTITUTIONAL |

| |

|20 |

|Perkins Loan |

|LOAN_FEDERAL |

| |

|21 |

|2.5/3.5% College Loan |

|LOAN_FEDERAL |

| |

|22 |

|Nursing Loan |

|LOAN_FEDERAL |

| |

|23 |

|Federal Unsubsidized Stafford/Direct |

|LOAN_FEDERAL |

| |

|24 |

|Federal Stafford Subsidized/Direct |

|LOAN_FEDERAL |

| |

|25 |

|Private or alternative loans to students |

|LOAN_OTHER |

| |

|30 |

|State Need Grant |

|STATE |

| |

|31 |

|Washington Promise Scholarship |

|STATE |

| |

|32 |

|Workforce Training TCA |

|STATE |

| |

|33 |

|Workforce Training Tuition and Books |

|STATE |

| |

|34 |

|Workforce Training Childcare and Transportation |

|STATE |

| |

|35 |

|WorkFirst Tuition and Books |

|STATE |

| |

|36 |

|Washington Scholars |

|STATE |

| |

|37 |

|Health Professional Scholarships |

|STATE |

| |

|38 |

|WAVE Awards |

|STATE |

| |

|39 |

|Passport to College Promise |

|STATE |

| |

|40 |

|Basic Food Employment and Training (BFET) |

|STATE |

| |

|41 |

|College Bound Scholarship |

|STATE |

| |

|42 |

|Opportunity Scholarship |

|STATE |

| |

|89 |

|Private or outside grants/scholarships |

|PRIVATE |

| |

|90 |

|2.5/3.5% College Work Study |

|N/A |

| |

|91 |

|Federal Work Study |

|FEDERAL_WORK_STUDY |

| |

|92 |

|State Work Study |

|N/A |

| |

|93 |

|Federal Plus |

|N/A |

| |

|94 |

|WorkFirst Work Study |

|N/A |

| |

|95 |

|Veterans Benefits |

|N/A |

| |

................
................

Online Preview   Download