Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA_DOCUMENTS Table   Tables and Data Elements   FinAid Home   Data Warehouse Home

DOCUMENTS Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

 

 

Data element

Definition

Object name in Business Objects universe (if different from data element name)

Document_Number

Indexed - yes
Format - Varchar2(6)
May be Null? N

The identifying number for a document. This, along with the year, uniquely identifies a document.

 
Document_Year

Indexed - yes
Format - Varchar2(4)
May be Null? N

The academic year that applies to the document name. Documents of the same number can change their names from one year to another.

 
Load_Date

Indexed - no
Format - Date
May be Null? Y

The latest date this table was refreshed in the warehouse from the Student Aid Management system (SAM).

 
Long_Name

Indexed - no
Format - Varchar2(60)
May be Null? Y

The full name of the document type. See Short_Name for list of values.

 
Short_Name

Indexed - no
Format - Varchar2(9)
May be Null? Y

A code that identifies the document type. Note: these same codes appear in the FA_STANDARD_DOCS table, but the column there is named Document_Type.

Vallues:

ADDTLTAX - Additional IRS Tax Information
ADDTLTAX - ADDITIONAL IRS TAX INFORMATION
B/F SUPP - BUSINESS/FARM SUPPLEMENT
B/F SUPP - Business/Farm Supplement
BUDINC - Budget Reevaluation Increase Approved
BUDINC - BUDGET REEVALUATION INCREASE APPROVED
BUDNOCHG - BUDGET REEVALUATION NO CHANGE
BUDNOCHG - Budget Reevaluation No Change
BUDREVAL - REQUEST FOR BUDGET REEVALUATION
BUDREVAL - Request for Budget Reevaluation
CANFAF - Canadian Financial Aid Form
CGSDEGR - CONFIRMATION OF CGS DEGREE CANDIDACY
CGSWEAPP - CGS/Wharton evening application
CGSWERF - CGS/Wharton Evening Registration Form
CGSWERF - CGS/WHARTON EVENING REGISTRATION FORM
CGSWESDF - CGS/WHARTON EVENING SUPPLEMENTAL DATA FORM
CONSORT - CONSORTIUM AGREEMENT
CONSORT - Consortium Agreement
CORSREG - COURSE REGISTRATION/SPRING TERM
CORSREG - Course Registration/Spring Term
CSEA - Certification for Sibling Enrollment/A
CSEA - CERTIFICATION FOR SIBLING ENROLLMENT/A
CSEF - Certification for Sibling Enrollment
CSEF - Certification for Sibling Enrollment/F
CSEF - CERTIFICATION FOR SIBLING ENROLLMENT/F
CSSTAPE - Electronic PROFILE Record from CSS
CVF - VERIFICATION OF SIBLING/SPOUSE COLLEGE ENROLLMENT FORM
CVF - Verification of Sibling/Spouse College Enrollment Form
DAD INFO - FATHER'S FINANCIAL AID INFORMATION & 1985 IRS 1040 FORMS
DEFAULT - Resolution of Loan Default
DEFAULT - Resolution of Title IV Default Status
DEFLTARR - PROOF OF SATISFACTORY ARRANGEMENTS FOR PRIOR LOAN DEFAULT
DEFLTINF - DETAILED INFORMATION REGARDING PRIOR LOAN DEFAULT
DEGCAND - Degree Candidacy Letter or Certificate
DEGCAND - DEGREE CANDIDACY LETTER OR CERTIFICATE
DRUGCERT - Anti-Drug Abuse Act Certification
DRUGCERT - ANTI-DRUG ABUSE ACT CERTIFICATION
DSPS - DIVORCED/SEPARATED PARENTS' STATEMENT
DSPS - Divorced/Separated Parents' Statement
EIF - Employment Information Form
EIF - EMPLOYMENT INFORMATION FORM
EIFSPR - Employment Information Form Spring Term
EIFSPR - EMPLOYMENT INFORMATION FORM SPRING TERM
ENTRINT - ENTRANCE INTERVIEW
ENTRINT - Entrance Interview
EVFAF - EARLY VERSION FAF
EVFAF - Early Version FAF
FAF - Financial Aid Form (FAF)
FAFSATAP - Confirmation of FAFSA Application From Processor
FAFSATAP - CONFIRMATION OF FAFSA APPLICATION FROM PROCESSOR
FAFSATAP - Confirmation of FAFSA Application from Processor
FAFTAPE - Confirmation of FAF Application from CSS
FAT - FINANCIAL AID TRANSCRIPT
FAT - Financial Aid Transcript
FWSIR - Federal Work-Study Award Increase Request Form
FWSLNAPP - Work-Study/Loan Change Application
FWSONLY - Federal Work-Study App
GAPSFAS - GAPSFAS - Graduate Aid Application
GAPSFAS - GAPSFAS - GRADUATE AID APPLICATION
GAPSFAS - GAPSFAS - graduate aid application
GAPSTAPE - CONFIRMATION OF GAPSFAS APPLICATION FROM GAPSFAS
GAPSTAPE - Confirmation of GAPSFAS Application from GAPSFAS
GSL APP - GUARANTEED STUDENT LOAN APPLICATION
I151DOC - Copy of your I 151 Immigration Card for Perm Resident
I151DOC - COPY OF YOUR I 151 IMMIGRATION CARD FOR PERM RESIDENT
INST APP - INSTITUTIONAL FINANCIAL AID APPLICATION
INST APP - Institutional Financial Aid Application
ITEMZEXP - Itemized Ed and Living Expenses (provide on application)
MOM INFO - MOTHER'S FINANCIAL AID INFORMATION & 1985 IRS 1040 FORMS
NCP/PROF - Non-Custodial Parent Profile
NCPS - Non-Custodial Parents' Statement
NCPTX - NON-CUSTODIAL PARENT TAX RETURN
NCPTX - Non-Custodial Parent Tax Return
NONTXF - NON-TAX FILER FORM
NONTXF - NON-TAX FILER VERIFICATION FORM
NONTXF - Non Tax Filer Verification Form
NONTXF - Non-Tax Filer Form
NONTXF - Non-Tax Filer Verification Form
NTF - NEEDS TEST FORM FOR GSL PROCESSING
OLOANAPP - Other Loan Application - PLUS/HEAL/PEFP/Other
P&LST - PROFIT AND LOSS STATEMENT
PAR INFO - PARENTS' FINANCIAL AID INFORMATION & 1985 IRS 1040 FORMS
PARFEDTX - PARENTS' 1986 FEDERAL INCOME TAX RETURN
PARFEDTX - Parents' 2006 Federal Income Tax Return
PARFEDTX - Parents' 2007 Federal Income Tax Return
PARFEDTX - PARENTS' 1987 FEDERAL INCOME TAX RETURN
PARFEDTX - Parents' 1994 Federal Income Tax Return
PARFEDTX - Parents' 2004 Federal Income Tax Return
PARFEDTX - Parents' 2009 Federal Income Tax Return
PARFEDTX - Parents' 1999 Federal Income Tax Return
PARFEDTX - Parents' 2001 Federal Income Tax Return
PARFEDTX - Parents' 1993 Federal Income Tax Return
PARFEDTX - Parents' 2008 Federal Income Tax Return
PARFEDTX - Parents' 1997 Federal Income Tax Return
PARFEDTX - Parents' 1995 Federal Income Tax Return
PARFEDTX - PARENTS' 1990 FEDERAL INCOME TAX RETURN
PARFEDTX - Parents' 2005 Federal Income Tax Return
PARFEDTX - Parents' 2003 Federal Income Tax Return
PARFEDTX - PARENTS' 1989 FEDERAL INCOME TAX RETURN
PARFEDTX - PARENTS' 1992 FEDERAL INCOME TAX RETURN
PARFEDTX - PARENTS' 1991 FEDERAL INCOME TAX RETURN
PARFEDTX - PARENTS' 1988 FEDERAL INCOME TAX RETURN
PARFEDTX - Parents' 2000 Federal Income Tax Return
PARFEDTX - Parents' 1998 Federal Income Tax Return
PARFEDTX - Parents' 1996 Federal Income Tax Return
PARFEDTX - Parents' 2010 Federal Income Tax Return
PARFEDTX - PARENTS' 1985 FEDERAL INCOME TAX RETURN
PARFEDTX - Parents' 2002 Federal Income Tax Return
PELLFUP - Pell Follow-up Information
PELLFUP - PELL FOLLOW-UP INFORMATION
PENNFAA - Penn Financial Aid Application
PENNSUP - PENN Supplemental Form for FAFSA Applicants
PENNSUP - Penn Supplemental Form for FAFSA Applicants
PENNSUP - PENN SUPPLEMENTAL FORM FOR FAFSA APPLICANTS
PFAS - Penn Financial Aid Supplement
PLUSCRT - Plus CRT
PLUSCRT - PLUS CRT
PRIORTAX - Parent's Most Recent Tax Return and W2's
PROFILE - PROFILE Application
PTNONTXF - Parent Non-Tax Filer Form
PTXP - Parents' Tax Return Required for Pell Verification
PTXP - PARENTS' TAX RETURN REQUIRED FOR PELL VERIFICATION
REEVAL - Request for Reevaluation
REEVAL - REQUEST FOR REEVALUATION
REGFLPS - LPS Registration Form
REPROSAR - Reprocessed Student Aid Report (SAR)
REPROSAR - REPROCESSED STUDENT AID REPORT (SAR)
RESFU - Response to Special Follow-up Letter
RESFU - RESPONSE TO SPECIAL FOLLOW-UP LETTER
RESFUGSL - RESPONSE TO FOLLOW-UP REGARDING YOUR LOAN APPLICATION
REVINCOT - REEVALUATION INCREASE OTHER THAN PENN GRANT
REVINCOT - Reevaluation Increase Other Than Penn Grant
REVINCPG - REevaluation Increase in Penn Grant
REVINCPG - REEVALUATION INCREASE IN PENN GRANT
REVINCPG - Reevaluation Increase In Penn Grant
REVNOCHG - Reevaluation No Change
REVNOCHG - REEVALUATION NO CHANGE
SAR - Student Aid Report
SAR - PELL STUDENT AID REPORT
SAR - Pell Student Aid Report
SEP/SRC - Educational Purpose/Registration Compliance Form
SEP/SRC - EDUCATIONAL PURPOSE/REGISTRATION COMPLIANCE FORM
SEPDIVAG - COPY OF SEPARATION/DIVORCE AGREEMENT
SIF - SUPPLEMENTAL INFORMATION FOR LOAN PROCESSING
SIFIN - Supplemental Information Form (SIF) - IN
SIFIN - SUPPLEMENTAL INFORMATION FORM (SIF) - IN
SIFIN - SIF IN
SIFOUT - SIF OUT
SIFOUT - Supplemental Information Form (SIF) - OUT
SIFOUT - SUPPLEMENTAL INFORMATION FORM (SIF) - OUT
SPQUES - SPOUSE'S QUESTIONNAIRE
SSDOC - Documentation of SS Benefits
SSDOC - DOCUMENTATION OF SS BENEFITS
STIPAMT - VALUE OF YOUR TA/RA STIPEND FOR THE ACADEMIC YEAR
STNONTXF - Student Non-Tax Filer Form
STUFEDTX - Student's 1997 Federal Income Tax Return
STUFEDTX - Student's 2008 Federal Income Tax Return
STUFEDTX - Student's 2009 Federal Income Tax Return
STUFEDTX - Student's 1999 Federal Income Tax Return
STUFEDTX - STUDENT'S 1988 FEDERAL INCOME TAX RETURN
STUFEDTX - STUDENT'S 1992 FEDERAL INCOME TAX RETURN
STUFEDTX - Student's 1998 Federal Income Tax Return
STUFEDTX - Student's 2006 Federal Income Tax Return
STUFEDTX - Student's 1993 Federal Income Tax Return
STUFEDTX - STUDENT'S 1985 FEDERAL INCOME TAX RETURN
STUFEDTX - Student's 2004 Federal Income Tax Return
STUFEDTX - Student's 2010 Federal Income Tax Return
STUFEDTX - Student's 1996 Federal Income Tax Return
STUFEDTX - Student's 1994 Federal Income Tax Return
STUFEDTX - Student's 2001 Federal Income Tax Return
STUFEDTX - Student's 2000 Federal Income Tax Return
STUFEDTX - Student's 2002 Federal Income Tax Return
STUFEDTX - Student's 1995 Federal Income Tax Return
STUFEDTX - STUDENT'S 1990 FEDERAL INCOME TAX RETURN
STUFEDTX - STUDENT'S 1989 FEDERAL INCOME TAX RETURN
STUFEDTX - STUDENT'S 1987 FEDERAL INCOME TAX RETURN
STUFEDTX - STUDENT'S 1986 FEDERAL INCOME TAX RETURN
STUFEDTX - Student's 2005 Federal Income Tax Return
STUFEDTX - STUDENT'S 1991 FEDERAL INCOME TAX RETURN
STUFEDTX - Student's 2003 Federal Income Tax Return
STUFEDTX - Student's 2007 Federal Income Tax Return
SUMEARAP - Summer Earnings Application
SUPMAR - FORM FOR MARRIED STUDENTS OR STUDENTS WITH DEPENDENTS
SUPMAR - Form for Married Students or Students with Dependents
SUPMAR - Form For Married Students or Students with Dependents
TUADJ - Graduate Tuition Adjustment Form
UNASSG1 - UNASSIGNED #1
UNASSG1 - Unassigned
UNASSG2 - UNASSIGNED #2
UNASSGN1 - Unassigned
VAFDC - VERIFICATION OF AMOUNT OF AID TO FAMILY WITH DEP CHILDREN
VAFDC - Verification of Amount of Aid to Family with Dep Children
VERDEGRE - VERIFICATION OF DEGREE CANDIDACY
VERWORK - VERIFICATION WORKSHEET 1991-92
VERWORK - VERIFICATION WORKSHEET 1986-87
VERWORK - VERIFICATION WORKSHEET 1989-90
VERWORK - VERIFICATION WORKSHEET 1990-91
VERWORK - VERIFICATION WORKSHEET 1987-88
VERWORK - Verification Worksheet
VERWORK - VERIFICATION WORKSHEET
VERWORK - VERIFICATION WORKSHEET 1988-89
VGIBILL - VERIFICATION OF AMOUNT OF GI BILL MONTHLY BENEFITS
VMEDDEN - PROOF OF MEDICAL/DENTAL EXPENSES NOT PAID BY INSURANCE
VSOCSECP - VERIFICATION OF PARENTS' SOCIAL SECURITY BENEFITS
VSPEARN - COPY OF YOUR SPOUSE'S PAYCHECK STUB TO VERIFY EARNINGS
VUMEMPBS - VERIFICATION OF SPOUSE'S UNEMPLOYMENT BENEFITS
VUNEMPBP - VERIFICATION OF PARENTS' UNEMPLOYMENT BENEFITS
VVEAP - VERIFICATION OF AMT OF VETERANS ED ASSISTANCE BENEFITS
W2PARENT - PARENTS' W2 FORM
W2PARENT - Parents' W2 Form
W2PARENT - Parents' W-2 Form
W2SPOUSE - SPOUSE'S W2 FORM
W2SPOUSE - Spouse's W2 Form
W2STUDNT - Student's W2 Form
W2STUDNT - STUDENT'S W2 FORM
WGLNRR - Wharton Loan Statement of Rights & Responsibilities

 
FA_DOCUMENTS Table   Tables and Data Elements   FinAid Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania