Financial Aid Award - November
# REF NO Input File Field Name Non Input File Field Name CDW Table Name CDW Field Name Field Description Code Values UCDW Star-Schema Name UCDW Star Table Name UCDW Star Field Name
1 N/A   Year Registered AY Stu_FAI_Summer_Award_Tbl Year_Registered_AY The academic year during which the student is registered for classes NOT APPLICABLE STUD_BI
FILE_CYCLE_D FILE_CYCLE_ACAD_YR
2 A020 Identification Number - Student   Stu_FAI_Summer_Award_Tbl Identification_Number_REG Character string which uniquely identifies a student in the UCOP database. Student Identification Number varies in length from campus to campus NOT APPLICABLE STUD_BI
STUDENT_D STUD_ID
3 S010 Account Number   Stu_FAI_Summer_Award_Tbl Account Number identifying the account from which a student's financial aid award is paid All spaces or all digits STUD_BI
ACCOUNT_D ACCT_ACCT_NUM
4 S020 Fund Number   Stu_FAI_Summer_Award_Tbl Fund Number identifying a specific source of funding All spaces or all digits STUD_BI
FUND_D FD_FD_NUM
5 S030 Subaccount Number   Stu_FAI_Summer_Award_Tbl Subaccount Code indicating a specific category of expenditures All spaces or all digits STUD_BI
AWARD_REFERENCE_D AWRD_REF_SUB_ACCT_CD
6 S040 Award Code   Stu_FAI_Summer_Award_Tbl Award_Code Code indicating the financial aid award which has been made to a student Refer to Financial Aid Award Code Table STUD_BI
AWARD_D AWRD_CD
7 A010 Campus Registered Code   Stu_FAI_Summer_Award_Tbl Campus_Registered_Code Code indicating the campus at which the student or postdoctoral scholar is registered 01 = Berkeley
02 = San Francisco
03 = Davis
04 = Los Angeles
05 = Riverside
06 = San Diego
07 = Santa Cruz
08 = Santa Barbara
09 = Irvine
10 = Merced
STUD_BI
CAMPUS_LOCATION_D
STUDENT_D
CMP_LOC_LOC1_CD
STUD_LOC_CMP_CD
8 N/A   Campus Name Stu_FAI_Summer_Award_Tbl Campus_Name Name indicating the campus at which the student or postdoctoral scholar is registered BERKELEY
DAVIS
IRVINE
LOS ANGELES
MERCED
RIVERSIDE
SAN DIEGO
SAN FRANCISCO
SANTA BARBARA
SANTA CRUZ
STUD_BI
CAMPUS_LOCATION_D CMP_LOC_LOC1_LNG_DESC
9 N/A   Campus Name Abbreviation Stu_FAI_Summer_Award_Tbl Campus_Name_Abbreviation Two-character abbreviation of campus name 01 = Berkeley - BK
02 = San Francisco - SF
03 = Davis - DV
04 = Los Angeles - LA
05 = Riverside - RV
06 = San Diego - SD
07 = Santa Cruz - SC
08 = Santa Barbara - SB
09 = Irvine - IR
10 = Merced - MC
STUD_BI
CAMPUS_LOCATION_D CMP_LOC_LOC1_ABRV_DESC
10 S050 Award Accept Code   Stu_FAI_Summer_Award_Tbl Award_Accept_Code Code indicating whether award has been offered or has been accepted or rejected O = Offered
A = Accepted
R = Rejected
STUD_BI
AWARD_REFERENCE_D AWRD_REF_AWRD_ACPTC_CD
AWRD_REF_AWRD_ACPTC_DESC
11 S100 Award Amount   Stu_FAI_Summer_Award_Tbl Award_Amount The total amount of a student's financial aid award as identified by a particular account, fund, sub-account, and award code NOT APPLICABLE STUD_BI
STUDENT_FINANCIAL_AID_F STUD_FINL_AID_AWRD_AMT
12 S110 Award Amount Paid To Date   Stu_FAI_Summer_Award_Tbl Award_Amount_Paid_To_Date Total payments made to date from a student's financial aid award, including any fee payment and fee deferrals covered by this award NOT APPLICABLE STUD_BI
STUDENT_FINANCIAL_AID_F STUD_FINL_AID_AWRD_PD_TO_DT_AMT
13 N/A   Award Name Stu_FAI_Summer_Award_Tbl Award_Name Name of the financial aid award that has been made to a student Refer to Financial Aid Award Code Table STUD_BI
AWARD_D AWRD_NAM
14 N/A   Authorizing Agency Code Stu_FAI_Summer_Award_Tbl Authorizing_Agency_Code Code indicating the authorizing agency of the financial aid award that has been made to a student 1 = Federal Government
2 = State of CA Government
3 = Other Government
4 = UCOP
5 = UC Campus
6 = Outside Agency = For-profit
7 = Outside Agency = Non-profit
8 = Outside Agency = Individual
STUD_BI
AWARD_D AWRD_AUTHNG_AGCY_CD
AWRD_AUTHNG_AGCY_DESC
15 N/A   Award Type Code Stu_FAI_Summer_Award_Tbl Award_Type_Code Code indicating type of financial aid award that has been made to a student 1 = Scholarship/Fellowship/Traineeship
2 = Grants
3 = Loans
4= Work Study
5 = RA/TA Remission
6 = Earnings
7= Other
STUD_BI
AWARD_D AWRD_TY_CD
AWRD_TY_DESC
16 N/A   Award Basis-Merit Stu_FAI_Summer_Award_Tbl Award_Basis_Merit Code indicating whether financial aid award is merit based Y = Yes
N = No
STUD_BI
AWARD_D AWRD_BASIS_MERIT_FL
17 N/A   Award Basis-Need Stu_FAI_Summer_Award_Tbl Award_Basis_Need Code indicating whether financial aid award is need based Y = Yes
N = No
STUD_BI
AWARD_D AWRD_BASIS_ND_FL
18 N/A   Award Basis-Diversity Stu_FAI_Summer_Award_Tbl Award_Basis_Diversity Code indicating whether financial aid award is diversity based Y = Yes
N = No
STUD_BI
AWARD_D AWRD_BASIS_DVRSTY_FL
19 N/A   Fund Group Code Stu_FAI_Summer_Award_Tbl Fund_Group_Code Code indicating the category to which a fund belongs in the University's accounting structure. NOT APPLICABLE STUD_BI
FUND_D FD_GRP_CD
20 N/A   Catalog of Federal Domestic Assistance (CFDA) Number Stu_FAI_Summer_Award_Tbl CFDA_Code Code indicating the program of federal assistance assigned by the Federal agencies NOT APPLICABLE STUD_BI
FUND_D FD_CFDA_CD
21 N/A   Sponsor Code Stu_FAI_Summer_Award_Tbl Sponsor_Code Code identifying the federal, state, or private contracting or granting agency, i.e., the agency which is the source of funds NOT APPLICABLE STUD_BI
SPONSOR_D SPON_CD
22 N/A   Sponsor Name Stu_FAI_Summer_Award_Tbl Sponsor_Name Name of the federal, state, or private contracting or granting agency, i.e., the agency which is the source of funds NOT APPLICABLE STUD_BI
SPONSOR_D SPON_NAM
23 N/A   Sponsor Category Code Stu_FAI_Summer_Award_Tbl Sponsor_Category_Code Code indicating the type of organization sponsoring an extramurally-funded project 01 = Federal Government
02 = State Government
03 = Other Government Agency
04 = Business/Profit Entity
05 = Non-Profit, Business Related
06 = Foundation/Charitable Trust
07 = Other Charitable Organization
08 = Higher Education Institution/Association
09 = Campus-Related Organization
10 = Individual
11 = UC Foundation
12 = Marketing orders
13 = Major UC DOE laboratories (LBL,LLNL, LANL)
Unknown
STUD_BI
SPONSOR_D SPON_CATG_CD
24 N/A   Super Agency Code Stu_FAI_Summer_Award_Tbl Super_Agency_Code Code for Federal or State Agency NOT APPLICABLE STUD_BI
SPONSOR_D SPON_AGCY_CD
25 N/A   Sub Super Agency Code Stu_FAI_Summer_Award_Tbl Sub_Super_Agency_Code Code for department within federal or state agency NOT APPLICABLE STUD_BI
SPONSOR_D SPON_SUB_AGCY_CD
26 N/A   Sponsor Category Code Campus Stu_FAI_Summer_Award_Tbl Sponsor_Category_Code_Campus NOT APPLICABLE NOT APPLICABLE NOT IN UCDW STAR NOT IN UCDW STAR NOT IN UCDW STAR