Get documents about "Financial Aid Student Loan Refund Money
Description
Financial Aid Student Loan Refund Money document sample
Document Sample
DISCOVERER STUDENT FINANCIAL AID VIEWS AND TABLES
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
Fields Included in Each View and Table
Budget Catg Tbl
Y AID_YEAR - Aid Year
Y BGT_ITEM_CATEGORY - Budget Item Category
Y INSTITUTION - Academic Institution
BUDGET_ITEM_TYPE - Item Classification
DESCR - Description
DESCRSHORT - Short Description
PELL_CATEGORY - Pell Category
Budget Item Tbl
Y AID_YEAR - Aid Year
Y BGT_ITEM_CATEGORY - Budget Item Category
Y BUDGET_ITEM_CD - Budget Item Code
Y INSTITUTION - Academic Institution
BUDG_MULT_FIELD - Multiplier Field
BUDG_MULTIPLIER - Budget Multiplier
BUDGET_ITEM_AMOUNT - Budget Item Amount
CURRENCY_CD - Currency Code
DESCR - Description
DESCRLONG - Description
DESCRSHORT - Short Description
HALF_TIME_ADJ - Half-time Adjustment
LESS_HALF_TIME_ADJ - Less Half-Time Adjustment
PELL_ITEM_AMOUNT - Pell Amount
SFA_PELITMAMT_LHT - Pell Less Half Annual Amount
THREE_QTR_TIME_ADJ - Three quarters Load Adjustment
ZERO_TIME_ADJ - Zero-Time Adjustment
Fan FA Term Vw
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
Y STRM - Term
ACAD_CAREER - Academic Career
ACAD_CAREER_CL - Acad Career Calculated
ACAD_GROUP_ADVIS - Academic Group of Advisor
ACAD_LEVEL_BOT - Academic Level - Term Start
ACAD_LEVEL_BOT_CL - Acad Level BOT Calculated
ACAD_LEVEL_EOT - Academic Level - Term End
ACAD_LEVEL_EOT_CL - Acad Level EOT Calculated
ACAD_LEVEL_PROJ - Academic Level - Projected
ACAD_LEVEL_PROJ_CL - Acad Level Proj Calculated
ACAD_LOAD_APPR - Approved Academic Load
ACAD_LOAD_APPR_CL - Acad Load Approved Calculated
ACAD_PLAN - Academic Plan
ACAD_PLAN_CL - Acad Plan Calculated
ACAD_PLAN_TYPE - Academic Plan Type
ACAD_PROG_PRIM_CL - Acad Prog Prim Calculated
ACAD_PROG_PRIMARY - Primary Academic Program
ACAD_STANDING - Academic Standing
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
ACAD_STANDING_CL - Calc Academic Standing
ACAD_SUB_PLAN - Academic Sub-Plan
ACAD_SUB_PLAN_CL - Acad Sub-Plan Calculated
ACAD_YEAR - Academic Year
ACAD_YEAR_CL - Acad Year Calculated
ACADEMIC_LOAD - Academic Load
ACADEMIC_LOAD_CL - Academic Load Calculated
ADMIT_TERM - Admit Term
ADVISOR_ID - Academic Advisor
ADVISOR_ROLE - Advisor Role
AID_YEAR - Aid Year
AID_YEAR_CL - Calculated Aid Year
BILLING_CAREER - Billing Career
BUDGET_REQUIRED - Budget Required
BUSINESS_UNIT - Business Unit
CAMPUS - Campus
CAMPUS_ADVISEMENT - Advisement Campus
CAMPUS_FA - FA Campus
CAMPUS_REGISTRAR - Registrar Campus
CENSUS_DT - Census Date
COMMITTEE_ID - Committee
COST_CODE - Canadian Cost Code
COUNTRY - Country
COURSE_LD_PCT - Course Load Pct
CREATION_DT - Creation Date
CUM_GPA - Cumulative GPA
CUM_GPA_CL - Cumulative GPA Calculated
CUM_RESIDENT_TERMS - Cumulative In Residence Terms
CUR_RESIDENT_TERMS - Current In Residence Terms
DEGR_CONFER_DT - Confer Date
DIR_LND_YR - Direct Lending Year
DIR_LND_YR_CL - Calculated Direct Lending Year
DRIVER_OPTION - Driver Creation Option
EFF_STATUS - Status as of Effective Date
ELIG_TO_ENROLL - Eligible to Enroll
END_DATE - End Date
EXP_GRAD_DATE - Expected Grad Date
EXP_GRAD_DATE_CL - Expected Grad Date Calculated
EXP_GRAD_TERM - Expected Graduation Term
EXP_GRAD_TERM_CL - Expected Grad Term Calculated
EXT_ORG_ID - External Org ID
FA_CAR_TYPE - Financial Aid Career Type
FA_EXP_DT_REBUILD - Rebuilt After Ovrd Exp Date
FA_LOAD - Financial Aid Load
FA_LOAD_CHANGE_IND - FATerm Load Changed
FA_LOAD_CL - FA Load Calculated
FA_LOAD_CURRENT - Current Load
FA_NUMBER_OF_WEEKS - FA Number of Weeks
FA_OEE_STUDENT - Enrolled in OEE Courses
FA_REBUILD_DT - Next Date to Rebuild FATerm
FA_STANDING - FA Standing
FA_STANDING_CL - FA Standing Calculated
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
FA_STATS_CALC_REQ - FA Stats Calculation Required
FA_UNIT_ANTIC - Anticipated Units
FA_UNIT_COMPLETED - Completed Units
FA_UNIT_CURRENT - Current Units
FA_UNIT_IN_PROG - In Progress Units
FA_UNIT_WARNING - Excluded FA Eligible Term Warn
FORM_OF_STUDY - Form of Study
FORM_OF_STUDY_CL - Form of Study Calculated
GPA_CALC_IND - GPA Computed by Another Proc
GPA_CL - GPA Calculated
GRADE_POINTS - Grade Points
GRADE_POINTS_INEL - Other Grade Points
LAST_DATE_ATTENDED - Last Date of Attendance
LOCK_OVRD_DATE - Lock Override Date
LOCK_OVRD_OPRID - Lock Override User
LS_GPA - GPA
NSLDS_LOAN_YEAR - NSLDS Loan Year
NSLDS_LOAN_YEAR_CL - NSLDS Loan Year Calculated
ONLINE_BATCH_IND - Online or Batch Run Indicator
OPRID - User ID
OVRD_ACAD_LOAD_AP - Override Approved Acad Load
OVRD_ACAD_LVL_ALL - Override All Academic Levels
OVRD_ACAD_LVL_PROJ - Override Projected Level
OVRD_ACAD_PLAN - Override Academic Plan
OVRD_ACAD_PROG_PRM - Override Primary Acad Program
OVRD_ACAD_STANDING - Override Academic Standing
OVRD_ACAD_YEAR - Override Acad Year
OVRD_ACADEMIC_LOAD - Override Academic Load
OVRD_AID_YEAR - Override Aid Year
OVRD_ASG_BOT - Override HERA Beginning of Trm
OVRD_ASG_EOT - Override HERA End of Term
OVRD_BILL_UNITS - Override Billing Units
OVRD_CAREER - Override Career
OVRD_CENSUSDT_LOCK - Override Census Date Locking
OVRD_CUM_GPA - Override Cum GPA
OVRD_DIR_LND_YR - Ovrd Direct Lending Year
OVRD_EXP_DT - Override Expiration Date
OVRD_FA_LOAD - Override Financial Aid Load
OVRD_FA_STANDING - Ovrd FA Standing
OVRD_FA_UNITS - Override Financial Aid Units
OVRD_FORM_OF_STUDY - Override Form of Study
OVRD_GPA - Override GPA
OVRD_GRAD_DATE - Override Grad Date
OVRD_GRAD_TERM - Override Grad Term
OVRD_NSLDS_LOAN_YR - Override NSLDS Loan Year
OVRD_SUB_PLAN - Override Sub-Plan
OVRD_TOT_PASSD_FA - Override Total Passed FA
OVRD_TOT_TAKEN_FA - Override Total Units Taken FA
OVRD_UNT_PASSD_FA - Override Units Passed FA
OVRD_UNT_TAKEN_FA - Override Unit Taken
PROCESS_INSTANCE - Process Instance
PROJ_BILL_UNT - Projected Bill Units
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
REFUND_CLASS - Refund Classification
REFUND_PCT - Refund Percentage
REFUND_SCHEME - Refund Scheme
REFUND_SETID - Refund SetID
REMOTE_UNT_FA - Remote Units
RESET_CUM_STATS - Reset Cum Stats at Term Start
SEL_GROUP - Tuition Group
SFA_ASG_AC_LVL_BCL - Calculated ASG Start Acad Lvl
SFA_ASG_AC_LVL_BOT - Academic Level - Term Start
SFA_ASG_AC_LVL_ECL - Calculated ASG End Acad Lvl
SFA_ASG_AC_LVL_EOT - Academic Level - Term End
SRVC_IND_CD - Service Indicator Cd
SRVC_IND_DTTM - Service Indicator Date Time
START_DATE - Start Date for Gen Standing PO
STDNT_CAR_NBR - Student Career Nbr
STUDY_AGREEMENT - Study Agreement
TC_UNITS_ADJUST - TC Units Adjustment
TERM_SRC - Term Source
TERM_TYPE - Term Unit Type
TOT_GRADE_POINTS - Total Grade Points
TOT_OTHER - Total from Other Credit
TOT_PASSD_FA - Total Fin Aid Units Passed
TOT_PASSD_FA_CL - Total Passed FA Calculated
TOT_TAKEN_FA - Total Fin Aid Units Taken
TOT_TAKEN_FA_CL - Total Units Taken FA Calc
TOT_TAKEN_GPA - Total Taken Toward GPA
TOT_TC_UNIT_ADJUST - Total TC Units Adjustment
TOT_TERM_UNT_FA - Total Term Units
TOT_TERM_UNT_FA_CL - Total Term Units FA Calculated
TOT_TEST_CREDIT - Total From Test Credit
TOT_TRNSFR - Total Transferred
TRF_PASSED_GPA - Transfer Passed for GPA
TRF_PASSED_NOGPA - Transfer Passed Not for GPA
TRF_RESIDENT_TERMS - Transfer In Residence Terms
TUIT_CALC_DTTM - Tuit Calc Date Time
TUIT_CALC_REQ - Tuition Calc Required
UNT_OTHER - Units from Other Credit
UNT_PASSD_FA - Fin Aid Progress Units Passed
UNT_PASSD_FA_CL - Units Passed FA Calculated
UNT_PASSD_FA_INEL - Other FA Passed Units
UNT_TAKEN_FA - Fin Aid Progress Units Taken
UNT_TAKEN_FA_CL - Units Taken FA Calculated
UNT_TAKEN_FA_INEL - Other FA Taken Units
UNT_TAKEN_FA_NOPIT - Unlocked FA Progress Units
UNT_TAKEN_GPA - Units Taken Toward GPA
UNT_TAKEN_GPA_INEL - Other Units Toward GPA
UNT_TAKEN_PRG_INEL - Ineligible Units Taken Progess
UNT_TEST_CREDIT - Units from Test Credit
UNT_TRNSFR - Units Transferred
WEEKS_OF_INSTRUCT - Weeks of Instruction
WITHDRAW_CODE - Withdrawal \ Cancel
WITHDRAW_DATE - Withdrawal \ Cancel Date
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
WITHDRAW_REASON - Withdrawal \ Cancel Reason
Isir Computed
Y AID_YEAR - Aid Year
Y EFFDT - Effective Date
Y EFFSEQ - Effective Sequence
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
Y TABLE_ID - Child Table Key
ADJ_AVAILABLE_INC - Adj Available Income
ADJ_EFC_AMT - Adjust EFC
ADJ_PAR_CONTRIB - Parent Contribution
ALWNC_AGAINST_TI - Total Allowances
AST_PROTECTN_ALWNC - Asset Protection Allowance
AUTO_ZERO_EFC - Auto Zero EFC
AVAILABLE_INCOME - Available Income
BUDGET_DURATION - Budget Duration
CONTRIB_AVAIL_INC - Contribution Available Income
CONTRIB_FROM_ASSET - Contribution from Assets
CURRENCY_CD - Currency Code
DEP_STU_A_CONTRIB - Student Asset Contribution
DEP_STU_I_CONTRIB - Student Income Contribution
DESCRTN_NET_WORTH - Discretionary Net Worth
EFC_CALC_DT - EFC Calc'd On
EFC_NET_WORTH - EFC Net Worth
EMPLOYMENT_ALWNC - Employment Allowance
FICA_TAX_PD - FICA Taxes
FORMULA_TYPE - Formula Type
INC_PROTECTN_ALWNC - Inc Protection Allowance
ISIR_CALC_EFC - Calculated Family Contribution
ISIR_CALC_PC - Calculated Parent Contribution
ISIR_CALC_SC - Calculated Studnt Contribution
PAID_EFC - Paid EFC
PELL_PAID_EFC_TYPE - Pell Paid EFC Type
PELL_SPCL_PRM_EFC - PELL Special Primary EFC
PELL_SPCL_SEC_EFC - PELL Special Secondary EFC
PRIMARY_EFC - Primary EFC
PRM_ALT_MONTH_1 - Primary Alternate Month 1
PRM_ALT_MONTH_10 - Primary Alternate Month 10
PRM_ALT_MONTH_11 - Primary Alternate Month 11
PRM_ALT_MONTH_12 - Primary Alternate Month 12
PRM_ALT_MONTH_2 - Primary Alternate Month 2
PRM_ALT_MONTH_3 - Primary Alternate Month 3
PRM_ALT_MONTH_4 - Primary Alternate Month 4
PRM_ALT_MONTH_5 - Primary Alternate Month 5
PRM_ALT_MONTH_6 - Primary Alternate Month 6
PRM_ALT_MONTH_7 - Primary Alternate Month 7
PRM_ALT_MONTH_8 - Primary Alternate Month 8
PRORATED_EFC - Prorated EFC
SEC_ALLOW_VS_TI - Sec Stu Allow VS Total Income
SEC_ALT_MONTH_1 - Secondary Alternate Month 1
SEC_ALT_MONTH_10 - Secondary Alternate Month 10
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
SEC_ALT_MONTH_11 - Secondary Alternate Month 11
SEC_ALT_MONTH_12 - Secondary Alternate Month 12
SEC_ALT_MONTH_2 - Secondary Alternate Month 2
SEC_ALT_MONTH_3 - Secondary Alternate Month 3
SEC_ALT_MONTH_4 - Secondary Alternate Month 4
SEC_ALT_MONTH_5 - Secondary Alternate Month 5
SEC_ALT_MONTH_6 - Secondary Alternate Month 6
SEC_ALT_MONTH_7 - Secondary Alternate Month 7
SEC_ALT_MONTH_8 - Secondary Alternate Month 8
SEC_NET_WORTH - Secondary Net Worth
SEC_SDNW - Sec Stu Disc Net Worth
SECONDARY_EFC - Secondary EFC
SECONDARY_EFC_TP - Secondary EFC Type
SFA_SIG_REJ_EFC - Signature Reject EFC
STATE_TAX_ALWNC - State Tax Allowance
STU_ALLOW_VS_TI - Student's Allowance VS TI
STU_DISC_NET_WORTH - Student's Disc Net Worth
STU_TOTAL_INC - Students Total Income
TOTAL_INCOME - Total Income
TOTAL_PAR_CONTRIB - Total Parent Contribution
TOTAL_STU_CONTRIB - Total Student Contribution
VALID_EFC_CALC - Valid EFC Calc
WEEKLY_PC - Weekly EFC Parent Contribution
WEEKLY_SC - Weekly EFC Stdnt Contribution
Isir Computed Vw Custom
(Same layout as Isir Computed)
Isir Control
Y AID_YEAR - Aid Year
Y EFFDT - Effective Date
Y EFFSEQ - Effective Sequence
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
ADDRESS_TYPE - Address Type
ADJ_EFC - Unofficial Estimated EFC
ADJ_EFC_CALC_REQ - Adjusted EFC Calc Requested
APP_SOURCE - CPS Appl Source Site Cd
APP_SOURCE_CODE - Application Source Code
APP_SOURCE_SITE - Appl Source Site Code
APP_STAT_DT - Application Status Date
APPLICATION_STAT - Application Status
ASSIGNED_PIN - Unique Nbr Assigned to Student
ASSUMPTION_OVRRIDE - Send Assumptions/Overrides
BATCH_NUMBER - CPS Batch Number
COMPUTE_BTCH_NO - Compute Batch Number
CORR_ADDRESS - Correct Address Flag
CORR_ALIEN_REG_NUM - Correct Alien Reg Nbr
CORR_CIT_STATUS - Correct Citzenship Status Flag
CORR_DOB - Correct Date of Birth Flag
CORR_EMAIL_ADDR - Correct Email Address
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
CORR_LICENSE - Correct Drivers License Flag
CORR_LICENSE_STATE - Correct Driver Lic State Flag
CORR_MARITAL_DATE - Correct Marital Stat Date Flag
CORR_MARITAL_STAT - Correct Marital Status Flag
CORR_NAME - Correct Name Flag
CORR_PHONE - Correct Phone Flag
CORR_SSN - Correct SSN Flag
CORR_STAT_DT - Correction Status Date
CORR_STATE_RES - Correct State Residency Flag
CORR_STATE_RES_DT - Correct State Res Date Flag
CORRECTION_APPLIED - Correction Applied
CORRECTION_STATUS - Correction Status
CPS_REPROCESS_CD - Reprocess Code
DEPNDNCY_OVERRIDE - Dependency Override Indicator
DT_APP_RECEIVED - Date Application Received
DUP_PROC_DT - Process Date of Dup Rqst
DUPLICATE_REQUEST - Duplicate Request Indicator
E_ADDR_TYPE - Email Type
EARLY_ANALYSIS_FLG - Early Analysis Flag
EFC_OVRD_DSPLAY_FM - Display FM EFC Override Values
EFC_STATUS - Official/Unofficial Indicator
ELEC_INSTITUT_IND - Electronic Institution Ind
ELECTRONIC_APP_VER - Electronic App Version No
ETI_DEST_CD - ETI Destination Code
FAA_INSTITUT_NUM - FAA Institution Nbr
FAA_SIGNATURE - FAA Signature
FATHER_SSN_MATCH - Father's SSN Match
FINAL_REVIEW_SW - Final Review
FULL_PARTIAL_ESAR - Full or Partial ESAR Recvd
HOLD_IND - Hold From Processing
INAS_RFC_CALL - Call INAS via RFC
INS_MATCH - INS Match
INS_VERF_NUM - INS Verification Nbr
INST_PROCESS_DT - Institution Process Date
ISIR_CORR_SRC - Correction Source
ISIR_CPS_PUSHED - CPS Pushed ISIR Flag
ISIR_DUP_SSN_CD - Duplicate SSN Code
ISIR_EFC_CHANGE - EFC Change Flag
ISIR_ORIG_IND - Original ISIR
ISIR_OVRD_E_TYPE - Override Email Type
ISIR_OVRD_P_TYPE - Override Phone Type
ISIR_PRINT_DT - ISIR Print Date
ISIR_PRINT_REQUEST - Print ISIR
ISIR_REC_TYPE - ISIR Record Code
ISIR_SAR_C_CHNG - ISIR SAR C Flag Changed
ISIR_SEC_INS_MATCH - Sec INS Match Flag
ISIR_SEC_INS_VERF - Sec INS Verification Number
ISIR_SERIAL_NUM - Serial Nbr
ISIR_TXN_NBR - Transaction Nbr
LAST_NAME_SSN_CHNG - Last Name-SSN Change Flag
MDE_EDE_SITE_CODE - MDE/EDE Site Code
MDE_SITE_NBR - MDE Site Nbr
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
MOTHER_SSN_MATCH - Mother's SSN Match
MULTI_INSTITUTION - Multiple Institution Flags
NAME_CD - Name Code
NSLDS_TXN_NBR - NSLDS Transaction Nbr
OPRID - User ID
ORIG_SSN - Original SSN
OVRD_ADDR_TYPE - Override Address Type
OWNING_SCHOOL_CD - Owning School Cd
PELL_ELIGIBILITY - Federal PELL Eligibility
PHONE_TYPE - Phone Type
PREP_EIN - Preparers EIN
PREP_SIGNATURE - Preparers Signature
PREP_SSN - Preparers SSN
PRISONER_MATCH - Prisoner Match
PROCESS_DT - Process Date
PROCESS_INSTANCE - Process Instance
SAR_C_FLAG - Indicates When 'C' Printed SAR
SEND_ISAR_SW - Send ISAR to Student
SEND_VERIFY_FIELDS - Include Verify Fields
SFA_REJ_ST_CHG_FLG - Rejected Status Change Flag
SFA_TRANS_TYPE - Transaction Type
SFA_VF_SEL_CHG_FLG - Verification Select Chng Flag
SIMP_NEED_TEST - Simplified Need Test
SS_MATCH - Selective Service Match
SS_REGISTRATION - Selective Service Registration
SSA_CITIZENSHP_IND - SSA Citizenship Indicator
SSN_DATE_OF_DEATH - SSN Date of Death
SSN_MATCH - SSN Match
SUB_APP_FLAG - Subsequent Application Flag
SYSTEM_GENERATED - System Generated Indicator
TITLEIV_ELIG - Title IV Fund Eligibility
TRANS_PROCESS_DT - Transaction Process Date
TRANS_RECEIPT_DT - Transaction Receipt Date
TRANS_SOURCE - Transaction Data Source
VA_MATCH - Veteran Status Match Flag
VERF_SELECTION_IND - Verification Selection Ind
VERIF_TRK_FLG - Verification Tracking Flag
VERIFCATION_TYPE - Verfication Type
Isir Control Vw Custom
(Same layout as Isir Control)
Isir Parent
Y AID_YEAR - Aid Year
Y EFFDT - Effective Date
Y EFFSEQ - Effective Sequence
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
Y TABLE_ID - Child Table Key
AFDC_BENEFITS - AFDC Benefits
AGE_OLDER_PARENT - Age of Older Parent
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
AGI - Adjusted Gross Income
BLANK_AGI - AGI value is blank
BLANK_CASH_SAV - Cash savings value is blank
BLANK_FATHER_INC - Father's Income value is blank
BLANK_INV_NET_WRTH - Investment Net Worth is blank
BLANK_MOTHER_INC - Mother's Income value is blank
BLANK_TAXES_PAID - Taxes Paid value is blank
BLANK_TOT_FROM_WKA - Total From Wksheet A is blank
BLANK_TOT_FROM_WS3 - Total From Wksheet B is blank
BUS_NET_WORTH - Business Net Worth
BUSINESS_DEBT - Business Debt
BUSINESS_VALUE - Business Value
CASH_SAVINGS - Cash Savings
CHILD_SUPPORT - Child Support
CURRENCY_CD - Currency Code
DFLT_AFDC_BEN_IND - AFDC Benefit Default Set
DFLT_AGI_IND - AGI Default Set
DFLT_CHLD_SPPT_IND - Child Support Default Set
DFLT_DAD_INC_IND - Father's Income Default Set
DFLT_EIC_IND - Earned Inc Source Ind
DFLT_FATHERSSN_IND - Assumed Father SSN
DFLT_MAR_STAT_IND - Marital Ststus Defaulted
DFLT_MOM_INC_IND - Mother's Income Default Set
DFLT_MOTHERSSN_IND - Assumed Mother SSN
DFLT_NUM_COLL_IND - Nbr in College Default Set
DFLT_NUM_FAM_IND - Nbr Family Default Set
DFLT_SS_BEN_IND - Soc Sec Benefits Default Set
DFLT_TAXES_PD_IND - Taxes Paid Default Set
DFLT_UNTXD_INC_IND - Untaxed Income Default Set
DFLT_WKC_TOT_IND - Total from WrkSht C Defaulted
DFLT_WS3_TOT_IND - Total from WrkSht 3 Defaulted
DFLT_WSA_TOT_IND - Total from Worksheet A
DT_LEGAL_RES - Date of Legal Residence
ELIG_FOR_1040A_EZ - Eligible For 1040A or 1040EZ
ERND_INC_CREDIT - Earned Income Credit
FARM_DEBT - Investment Farm Debt
FARM_NET_WORTH - Farm Net Worth
FARM_VALUE - Investment Farm Value
FATHER_1ST_NM_INIT - Father's First Name Initial
FATHER_DOB - Father's Date of Birth
FATHER_GRADE_LVL - Father's Highest Grade Level
FATHER_INCOME - Father's Earnings
FATHER_LAST_NAME - Father's Last Name
FATHER_SSN - Father's SSN
INV_NET_WORTH - Investment Net Worth
IWD_PAR_EMAIL - Parent's E-mail Address
LEGAL_RES_PRI_94 - Legal Resident Before 01-01-94
LEGAL_RES_PRIOR - Legal Resident Before 01-01-95
LEGAL_RESIDENCE - Legal Residence
MAR_STATUS_DT - Marital Status Date
MARITAL_STAT - Marital Status
MOTHER_1ST_NM_INIT - Mother's First Name Initial
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
MOTHER_DOB - Mother's Date of Birth
MOTHER_GRADE_LVL - Mother's Highest Grade Level
MOTHER_INCOME - Mother's Earnings
MOTHER_LAST_NAME - Mother's Last Name
MOTHER_SSN - Mother's SSN
NUM_IN_COLLEGE - Nbr in College
NUMBER_EXEMPTIONS - Nbr of Exemptions
NUMBER_IN_FAMILY - Nbr Family Members
PROJECTED_YR_INC - Projected Year Income
RE_INVEST_DEBT - Real Estate Invest Debt
RE_INVEST_VALUE - Real Estate Invest Value
SFA_FOOD_STAMPS - Receives Food Stamps
SFA_SCHL_LUNCH_PRG - Participates in Sch Lunch Prog
SFA_SSI_INCOME - Receives SSI Income
SFA_TANF_BENEFITS - TANF Recipient
SFA_WIC_BENEFITS - WIC Benefits Recipient
SOC_SEC_BENEFITS - SS Benefits
TAX_FORM_FILED - Tax Form Filed
TAX_RETURN_FILED - Tax Return Filed?
TAXES_PAID - U. S. Tax Paid
TOTAL_FROM_WKA - Total Amount from WK A
TOTAL_FROM_WKC - Total Amount from WK C
TOTAL_FROM_WS3 - Total from Worksheet 3
UNTAXED_INCOME - Untaxed Income
Isir Parent Vw Custom
(Same layout as Isir Parent)
Isir Student
Y AID_YEAR - Aid Year
Y EFFDT - Effective Date
Y EFFSEQ - Effective Sequence
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
Y TABLE_ID - Child Table Key
AFDC_BENEFITS - AFDC Benefits
AGI - Adjusted Gross Income
APP_SIGNED_BY - Application Signed By
ATTEND_SAME_COLL - Attend Same College
BIRTHDATE - Date of Birth
BLANK_AGI - AGI value is blank
BLANK_CASH_SAV - Cash savings value is blank
BLANK_INV_NET_WRTH - Investment Net Worth is blank
BLANK_SPS_EARN_INC - Spouse's Earned Income blank
BLANK_STD_EARN_INC - Student's Earned Income blank
BLANK_TAXES_PAID - Taxes Paid value is blank
BLANK_TOT_FROM_WKA - Total From Wksheet A is blank
BLANK_TOT_FROM_WS3 - Total From Wksheet B is blank
BUS_NET_WORTH - Business Net Worth
BUSINESS_DEBT - Business Debt
BUSINESS_VALUE - Business Value
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
CASH_SAVINGS - Cash Savings
CHILD_SUPPORT - Child Support
CHILDREN - Have Children you support
CITIZENSHIP_STATUS - Citizenship Status
COURSE_OF_STUDY - Course of Study
CURRENCY_CD - Currency Code
CURRENT_GRADE_LVL - Current Grade Level
DEGREE_CERTIF - Degree/Certificate
DEPENDENTS - Dependents Other Than Spouse
DEPNDNCY_STAT - Dependency Status
DFLT_AFDC_BEN_IND - AFDC Benefit Default Set
DFLT_AGI_IND - AGI Default Set
DFLT_CHILDREN_IND - Default Veteran Indicator
DFLT_CHLD_SPPT_IND - Child Support Default Set
DFLT_CITIZEN_IND - Default Citizenship Indicator
DFLT_DEPEND_IND - Dependents Defaulted
DFLT_DOB_PRIOR_IND - DOB Prior Defaulted
DFLT_EIC_IND - Earned Inc Source Ind
DFLT_EXP_WS3_IND - WS3 Total Defaulted
DFLT_MAR_STAT_IND - Marital Ststus Defaulted
DFLT_MARRIED_IND - Married Defaulted
DFLT_NUM_COLL_IND - Nbr in College Default Set
DFLT_NUM_FAM_IND - Nbr Family Default Set
DFLT_SPS_INC_IND - Spouse Income Default Set
DFLT_SS_BEN_IND - Soc Sec Benefits Default Set
DFLT_STD_INC_IND - Student Income Default Set
DFLT_TAXES_PD_IND - Taxes Paid Default Set
DFLT_UNTXD_INC_IND - Untaxed Income Default Set
DFLT_VETERAN_IND - Default Veteran Indicator
DFLT_WKC_TOT_IND - Total from WrkSht C Defaulted
DFLT_WS3_TOT_IND - Total from WrkSht 3 Defaulted
DFLT_WSA_TOT_IND - Total from Worksheet A
DOB_PRIOR - DOB Before 1/1/74
DRIV_LIC_STATE - Issuing State
DRIVERS_LICENSE_NO - Driver's License #
DRUG_OFFENSE_CONV - Drug Offense Conviction
DT_APP_COMPLETED - Date Application Completed
DT_EXPCT_TO_COMP - Date Expected to Complete Prog
DT_GED_EARNED - Date GED Earned
EARLY_ADMISSION - Early Admission
ELIG_FOR_1040A_EZ - Eligible For 1040A or 1040EZ
ENROLL_CURNT_SUM - Enroll Plan for Current Sumr
ENROLL_FALL - Enroll Plan for Fall
ENROLL_NEXT_SUM - Enroll Plan for Next Sumr
ENROLL_SPRING - Enroll Plan for Spring
ENROLL_WINTER - Enroll Plan for Winter
ERND_INC_CREDIT - Earned Income Credit
EXP_TOT_WS3 - Expected Tot From Worksheet 3
FARM_DEBT - Investment Farm Debt
FARM_NET_WORTH - Farm Net Worth
FARM_VALUE - Investment Farm Value
FIRST_BACH_DEGREE - Received First Bachelor Degree
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
FISAP_TOT_INC - FISAP Total Income
GRADUATE - Graduate
GRADUATE_STUDENT - Grad Student
HOUSING_CODE_1 - Student's Housing Code Col 1
HOUSING_CODE_2 - Student's Housing Code Col 2
HOUSING_CODE_3 - Student's Housing Code Col 3
HOUSING_CODE_4 - Student's Housing Code Col 4
HOUSING_CODE_5 - Student's Housing Code Col 5
HOUSING_CODE_6 - Student's Housing Code Col 6
HS_GED_RCVD - HS Diploma or GED Received
HS_GRAD_DT - HS Graduation Date
INTERESTED_IN_PLUS - Interested In PLUS
INTERESTED_IN_SL - Interested In Student Loans
INTERESTED_IN_WS - Interested In Work-Study
INV_NET_WORTH - Investment Net Worth
ISIR_STU_ENRL_STAT - Enrollment Status
IWD_CITY - City
IWD_PERM_ADDR02 - Permanent Mailing Address
IWD_PERM_PHONE - Perm Phone Number
IWD_STATE - State
IWD_STD_EMAIL - Student's Email Address
IWD_STD_FIRST_NM02 - Student's First Name
IWD_STD_LAST_NAME - Last Name
IWD_STU_ALIEN_REG - Alien Registration Number
IWD_STU_MI - Student Middle Initial
IWD_ZIP - Zip
LEGAL_RES_PRI_94 - Legal Resident Before 01-01-94
LEGAL_RES_PRIOR - Legal Resident Before 01-01-95
MAR_STATUS_DT - Marital Status Date
MARITAL_STAT - Marital Status
MARRIED - Student Married
MONTHLY_VET_BEN - Monthly Vet Edu Benefits
NUM_FAMILY_MEMBERS - Nbr in Family
NUM_MONTH_VET_BEN - VA Ben Nbr of Months
NUMBER_EXEMPTIONS - Nbr of Exemptions
NUMBER_IN_COLLEGE - Nbr in College
ORPHAN - Orphan or Ward of the Court
PAY_NUM_DEPENDENTS - Care for how many Dependents
PROJECTED_YR_INC - Projected Year Income
RE_INVEST_DEBT - Real Estate Invest Debt
RE_INVEST_VALUE - Real Estate Invest Value
RESIDENCY_DT - Residency Date
SCHOOL_CHOICE_1 - Student's 1st Choice School
SCHOOL_CHOICE_2 - Student's 2nd Choice School
SCHOOL_CHOICE_3 - Student's 3rd Choice School
SCHOOL_CHOICE_4 - Student's 4th Choice School
SCHOOL_CHOICE_5 - Student's 5th Choice School
SCHOOL_CHOICE_6 - Student's 6th Choice School
SEL_SERV_REGISTER - Permit Sel Serv to Enroll
SFA_ACTIVE_DUTY - Active Duty in U.S Military
SFA_FOOD_STAMPS - Receives Food Stamps
SFA_HOUSING_CODE10 - Student's Housing Code Col 10
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
SFA_HOUSING_CODE7 - Student's Housing Code Col 7
SFA_HOUSING_CODE8 - Student's Housing Code Col 8
SFA_HOUSING_CODE9 - Student's Housing Code Col 9
SFA_HS_DIP_EQUIV - HS Diploma or Equivalent
SFA_INTRSTD_IN_WSL - Work Study or Student Loans
SFA_SCHL_CHOICE_10 - Student's 10th Choice School
SFA_SCHL_CHOICE_7 - Student's 7th Choice School
SFA_SCHL_CHOICE_8 - Student's 8th Choice School
SFA_SCHL_CHOICE_9 - Student's 9th Choice School
SFA_SCHL_LUNCH_PRG - Participates in Sch Lunch Prog
SFA_SSI_INCOME - Receives SSI Income
SFA_STDNT_GENDER - Are You Male or Female
SFA_TANF_BENEFITS - TANF Recipient
SFA_WIC_BENEFITS - WIC Benefits Recipient
SIGNED_BY_APPLICNT - Student Signed
SIGNED_BY_FATHER - Father Signed
SIGNED_BY_MOTHER - Mother Signed
SIGNED_BY_SPOUSE - Spouse Signed
SOC_SEC_BENEFITS - SS Benefits
SPS_EARNED_INCOME - Spouse's Earned Income
SSN - Social Security #
STATE_AGNCY_RLSE - Send Info to the State Agency
STATE_RESIDENCE - State of Residence
STD_EARNED_INCOME - Student's Earned Income
STUDENT_HAVE_DL - Do you have a driver's license
STUDENT_MALE - Are You Male?
TAX_FORM_FILED - Tax Form Filed
TAX_RETURN_FILED - Tax Return Filed?
TAXES_PAID - U. S. Tax Paid
TOTAL_FROM_WKA - Total Amount from WK A
TOTAL_FROM_WKC - Total Amount from WK C
TOTAL_FROM_WS3 - Total from Worksheet 3
UNTAXED_INCOME - Untaxed Income
VETERAN - Veteran
Isir Student Vw Custom
(Same layout as Isir Student)
Item Type FA
Y AID_YEAR - Aid Year
Y EFFDT - Effective Date
Y ITEM_TYPE - Item Type
Y SETID - SetID
AGGREGATE_AREA - Aggregate Area
ANTCP_AID_EXP_DAYS - Anticip Aid Expiration Days
AUTO_CANCEL_TYPE - Auto Cancel Item Type
AWARD_LETTER_PRINT - Award Letter Print
AWARD_MSG_CD - Award Message
AWARD_PERIOD - Award Period
DESCR - Description
DESCRLONG - Description
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
DESCRSHORT - Short Description
DISB_PROTECTION - Disbursement Protection
DISBURSE_METHOD - Disbursement Method
EFF_STATUS - Status as of Effective Date
EQUITY_AWARD - Equity Award
FA_ROUND_OPTION - Rounding Option
FA_SOURCE - Source
FA_SS_ACCEPT - Accept
FA_SS_DECLINE - Decline
FA_SS_REDUX - Reduce
FAN_PRINT_SPECS - FAN Print Specification
FED_OR_INST - Fed/Inst Affected
FED_OVRAWRD_RULE - Overaward Rule(Fed)
FEDERAL_ID - Federal ID
FEE_REMAINDER_RULE - Fee Remainder Rule
FIN_AID_TYPE - Fin Aid Type
INCLUDE_IN_TSCRPT - Include in Transcript
INST_OVRAWRD_RULE - Overaward Rule(Inst)
LINE_REASON_CD - Line Reason Code
LOAN_INTEREST_ATTR - Loan Interest Attribute
LOAN_PROGRAM - Loan Program
LOCK_AWARD_FLAG - Lock Award
MANUAL_AUTH_IND - Manual Authorization
MEET_NEED_COST - Meet Need/Cost
METHODOLOGY - Packaging Methodology
MISSING_TERM_SPLIT - Even split across valid terms
NEED_BASED - Need Based
ONE_INSTANCE_ITEM - Package Only Once
OVRAWD_TOLERANCE - Overaward Tolerance
PACKAGE_LIMIT_RULE - Package Limit
PACKAGING_FEED - Auto Package
PARENT_ITEM_TYPE - Parent Item Type
PASS_ANTICIP_AID - Pass Anticipated Aid
PAY_ACROSS_TERMS - Pay Fin Aid Across Terms
PRINT_LTR_OPTION - Print Letter Option
REMAINDER_RULE - Award Remainder Rule
REPORT_CODE - Institution Reporting Cd
ROUND_DIRECTION - Round Direction
SELECTION_CRITERIA - Selection Criteria
SELF_HELP_AWARD - Self Help Award
SEQUENCE_OVERRIDE - Auto assign lowest sequence
SFA_ASG_ACAD_LEVEL - Academic Level
SFA_LNTRANSIT_FLAG - Adjust while in transit
SFA_MPN_REQUIRED - MPN Required
SIGNATURE_RELEASE - Signature Required
TITLE_IV - Title IV Aid
TRUNCATE_FEE - Truncate Fees
Item Type FA Custom
(Same layout as Item Type FA)
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
Stdent Awards
Y ACAD_CAREER - Academic Career
Y AID_YEAR - Aid Year
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
Y ITEM_TYPE - Item Type
ACCEPT_AMOUNT - Accept Amount
ACCEPT_LOAN_FEE - Accept Loan Fee
ACCEPT_REBATE_AMT - Accept Rebate Amount
AUTHORIZED_AMOUNT - Authorized Amount
AWARD_MSG_CD - Award Message
AWARD_PERIOD - Award Period
AWARD_POSTED - Award Posted
AWARD_STATUS - Award Status
CANCEL_DECLINE_AMT - Cancel/Decline Amount
CHARGE_PRIORITY - Charge Priority List
CURRENCY_CD - Currency Code
CUSTOM_LOAN_FEE - Custom Loan Fee
DISBURSED_AMOUNT - Disbursed Amount
DISBURSEMENT_PLAN - Disbursement Plan
FA_PROF_JUDGEMENT - Professional Judgement
FIN_AID_TYPE - Fin Aid Type
HIGHEST_ACCEPT_AMT - Highest Accepted
HIGHEST_OFFER_AMT - Highest Offer
LN_DEST_FEE_PRCNT - Destination Loan Fee
LOAN_ADJUST_CD - Loan Adjust Reason
LOAN_TOT_DISB - Total Loan Disbursements
LOAN_TOT_ORIG - Total Loan Orig Amt
LOCK_AWARD_FLAG - Lock Award
NET_AWARD_AMT - Net Award Amount
NET_OFFER_AMT - Net Offer Amount
OFFER_ACTIVITY_IND - Offer Activity
OFFER_AMOUNT - Offer Amount
OFFER_LOAN_FEE - Offer Loan Fee
OFFER_REBATE_AMT - Offer Rebate Amount
OVERRIDE_FL - Override Flag
OVERRIDE_NEED - Need Override Lock Flag
PKG_APP_DATA_USED - Application Data Used
PKG_PLAN_ID - Packaging Plan ID
PKG_SEQ_NBR - Sequence Nbr
PKG_STATUS_CD - Package Status
SCHEDULED_AWARD - Scheduled Award
SETID - SetID
SFA_AGGR_SRC_USED - Aggregate Source Used
SFA_PKG_DEP_STAT - Dependency Status
SPLIT_CODE - Split Code
WS_ERND_TO_DT - Work Study Earned
Stdnt Awd Per
Y AID_YEAR - Aid Year
Y AWARD_PERIOD - Award Period
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
BASE_WEEKS - Base Number of Weeks
BDGT_DURATION_FED - Budget Duration
BDGT_DURATION_INST - Budget Duration
COMMENTS - Comment
EFC_STATUS - Official/Unofficial Indicator
FANLTR_STATUS - Fan Ltr Status
FANLTR_STATUS_PREH - FanLtr Status Pre-Hold
FED_EFC - Federal EFC
FED_NEED - Fed Need
FED_NEED_BASE_AID - N/B Aid (Fed)
FED_OVRAWD_AMT - Overaward (Fed)
FED_OVRAWD_COA - COA Overaward(Fed)
FED_PARENT_CONTRB - Parents Contribution - Federal
FED_SPECIAL_AID - Special Need/Cost Aid (Fed)
FED_STDNT_CONTRB - Student Contribution - Federal
FED_TOTAL_AID - Total Aid (Fed)
FED_UNMET_COA - Unmet COA(Fed)
FED_UNMET_NEED - Unmet Need (Fed)
FED_YEAR_COA - Fed Year COA
INST_CALC_EFC - Calculated Family Contribution
INST_CALC_PC - Calculated Parent Contribution
INST_CALC_SC - Calculated Studnt Contribution
INST_EFC - Institutional EFC
INST_EFC_OVERIDE - Override Institutional EFC
INST_NEED - Inst Need
INST_NEED_BASE_AID - N/B Aid (Inst)
INST_OVRAWD_AMT - Overaward (Inst)
INST_OVRAWD_COA - COA Overaward(Inst)
INST_PARENT_CONTRB - Parents Contribution - Inst
INST_SPECIAL_AID - Special Need/Cost Aid (Inst)
INST_STDNT_CONTRB - Student Contribution - Inst
INST_TOTAL_AID - Total Aid (Inst)
INST_UNMET_COA - Unmet COA(Inst)
INST_UNMET_NEED - Unmet Need (Inst)
INST_YEAR_COA - Inst Year COA
ISIR_CALC_EFC - Calculated Family Contribution
ISIR_CALC_PC - Calculated Parent Contribution
ISIR_CALC_SC - Calculated Studnt Contribution
PELL_YEAR_COA - Pell Year COA
PRORATED_EFC - Prorated EFC
PRORATED_PAR_CNTRB - Prorated Parent Contribution
PRORATED_STU_CNTRB - Prorated Student Contribution
SFA_PELLYR_COA_LHT - Less than Half Time Pell COA
VET_ED_BENEFIT - Montgomery GI Bill/AmeriCorps
VET_ED_FAN_PRINT - Print as Other Resource
WEEKLY_PC - Weekly EFC Parent Contribution
WEEKLY_SC - Weekly EFC Stdnt Contribution
WEEKS_ENROLLED - Number of Weeks Enrolled
Stdnt Awrd Actv
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
Y ACAD_CAREER - Academic Career
Y ACTION_DTTM - Override Date Time
Y AID_YEAR - Aid Year
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
Y ITEM_TYPE - Item Type
ACCEPT_AMOUNT - Accept Amount
ADJUST_AMOUNT - Adjust Amount
ADJUST_REASON_CD - Adjustment Reason
AUTH_TO_DATE - Authorized Total
AUTHORIZED_AMOUNT - Authorized Amount
AWARD_DISB_ACTION - Disb ID Action
BUSINESS_UNIT - Business Unit
CURRENCY_CD - Currency Code
DISB_AMOUNT - Disbursed Amount
DISB_TO_DATE - Disbursed Total
DISBURSEMENT_ID - Disbursement ID
DISBURSEMENT_PLAN - Disbursement Plan
LOAN_ADJUST_CD - Loan Adjust Reason
OFFER_AMOUNT - Offer Amount
OPRID - User ID
PKG_APP_DATA_USED - Application Data Used
SPLIT_CODE - Split Code
Stdnt Awrd Disb
Y ACAD_CAREER - Academic Career
Y AID_YEAR - Aid Year
Y DISBURSEMENT_ID - Disbursement ID
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
Y ITEM_TYPE - Item Type
ACCEPT_BAL_LN_FEE - Accept Balance Loan Fee
ACCEPT_BAL_REBATE - Accept Balance Rebate
ACCEPT_BALANCE - Accept Balance
AGGREGATE_AREA - Aggregate Area
AGGREGATE_LEVEL - Aggregate Level
AUTHORIZED_BALANCE - Authorized Balance
BUSINESS_UNIT - Business Unit
CPS_SCHOOL_CODE - School Code
CURRENCY_CD - Currency Code
DISBURSED_BALANCE - Disbursed Balance
NET_DISB_BALANCE - Net Disb Balance
OFFER_BAL_LN_FEE - Offer Balance Loan Fee
OFFER_BAL_REBATE - Offer Balance Rebate
OFFER_BALANCE - Offer Balance
SFA_AGGR_BALANCE - Aggregate Balance
STRM - Term
Stdnt Disb Awd
Y ACAD_CAREER - Academic Career
Y AID_YEAR - Aid Year
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
Y DISBURSEMENT_ID - Disbursement ID
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
Y ITEM_TYPE - Item Type
Y STRM - Term
ACCEPT_AMOUNT - Accept Amount
AUTHORIZED_AMOUNT - Authorized Amount
DISBURSED_AMOUNT - Disbursed Amount
DISBURSEMENT_PLAN - Disbursement Plan
OFFER_AMOUNT - Offer Amount
Stdnt Pkg Disb
Y AID_YEAR - Aid Year
Y DISBURSEMENT_ID - Disbursement ID
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
Y PKG_SEQ_NBR - Sequence Nbr
ACAD_CAREER - Academic Career
ACCEPT_BAL_LN_FEE - Accept Balance Loan Fee
ACCEPT_BAL_REBATE - Accept Balance Rebate
ACCEPT_BALANCE - Accept Balance
ACCEPT_BALNCE_ORIG - Original Accept Balance
AGGREGATE_AREA - Aggregate Area
AGGREGATE_LEVEL - Aggregate Level
AUTHORIZED_BALANCE - Authorized Balance
BUSINESS_UNIT - Business Unit
CPS_SCHOOL_CODE - School Code
CURRENCY_CD - Currency Code
DISBURSED_BALANCE - Disbursed Balance
ITEM_TYPE - Item Type
LN_FEE_AMT - Loan Fee Amount
NET_DISB_BALANCE - Net Disb Balance
OFFER_BAL_LN_FEE - Offer Balance Loan Fee
OFFER_BAL_REBATE - Offer Balance Rebate
OFFER_BALANCE - Offer Balance
OFFER_BALANCE_ORIG - Original Offer Balance
SFA_AGGR_BALANCE - Aggregate Balance
STRM - Term
Stdnt Term Bdgt
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
Y AID_YEAR - Aid Year
Y ACAD_CAREER - Academic Career
Y STRM - Term
Y EFFDT - Effective Date
Y EFFSEQ - Effective Sequence
ACAD_LEVEL_BOT - Academic Level - Term Start
ACAD_LEVEL_PROJ - Academic Level - Projected
ACAD_LOAD_APPR - Approved Academic Load
ACAD_PLAN - Academic Plan
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
ACAD_PLAN_TYPE - Academic Plan Type
ACAD_PROG_PRIMARY - Primary Academic Program
ACAD_SUB_PLAN - Academic Sub-Plan
ACADEMIC_LOAD - Academic Load
APP_STATE_RESIDENC - Application State Residence
BUDGET_GROUP_CODE - Budget Group Code
DEPNDNCY_STAT - Dependency Status
DESCRSHORT - Short Description
FA_LOAD - Financial Aid Load
FA_LOAD_CURRENT - Current Load
FA_TERM_EFFDT - Effective Date
FA_TERM_EFFSEQ - Effective Sequence
FA_UNIT_ANTIC - Anticipated Units
FA_UNIT_COMPLETED - Completed Units
FA_UNIT_CURRENT - Current Units
FA_UNIT_IN_PROG - In Progress Units
FED_TERM_COA - Fed Term COA
FIN_AID_FED_EXCPT - Fin Aid Fed Residency Excpt
FIN_AID_FED_RES - Fin Aid Federal Residency
FIN_AID_ST_EXCPT - Fin Aid St Residency Excpt
FIN_AID_ST_RES - Fin Aid State Residency
FORM_OF_STUDY - Form of Study
HOUSING_TYPE - Projected Housing Type
INST_TERM_COA - Inst Term COA
MARITAL_STAT - Marital Status
NSLDS_LOAN_YEAR - NSLDS Loan Year
NUMBER_IN_FAMILY - Nbr Family Members
OPRID - User ID
PELL_TERM_COA - Pell Term COA
POSTAL - Postal Code
PRORATE_BUDGET - Prorate Budget
RESIDENCY - Residency
SFA_PELTRM_COA_LHT - Less than Half Time Pell COA
STATE_RESIDENCE - State of Residence
TERM_TYPE - Term Unit Type
Stdnt Budget IT
Y ACAD_CAREER - Academic Career
Y AID_YEAR - Aid Year
Y BGT_ITEM_CATEGORY - Budget Item Category
Y EFFDT - Effective Date
Y EFFSEQ - Effective Sequence
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
Y STRM - Term
BUDGET_ITEM_AMOUNT - Budget Item Amount
BUDGET_ITEM_CD - Budget Item Code
OPRID - User ID
PELL_ITEM_AMOUNT - Pell Amount
SFA_PELITMAMT_LHT - Pell Less Half Annual Amount
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
Um Isir Max Vw
Y CPS_SCHOOL_CODE - School Code
Y ECQUEUEINSTANCE - EC Queue Instance
Y ECTRANSID - EC Transaction ID
Y ECTRANSINOUTSW - Inbound / Outbound Switch
Y ISIR_SEQ_NO - Sequence Number
Y SSN - Social Security #
ADJ_EFC_CALC_REQ - Adjusted EFC Calc Requested
ADMIT_LVL - Student's Admit Lvl
AGE_OLDER_PARENT - Age of Older Parent
ALT_EFFDT - Alternate Effective Date
BATCH_NUMBER - CPS Batch Number
BIRTHDATE - Date of Birth
CHILDREN - Have Children you support
CITIZENSHIP_STATUS - Citizenship Status
DEGREE_CERTIF - Degree/Certificate
DEPENDENCY_OVERIDE - Dependency Override
DEPENDENTS - Dependents Other Than Spouse
DISCARD_REASON - Skip Reason
DRIVERS_LICENSE_NO - Driver's License #
DRUG_OFFENSE_CONV - Drug Offense Conviction
DT_APP_COMPLETED - Date Application Completed
EFC_STATUS_MSG - EFC Status Message
EMPLID - EmplID
ENROLL_CURNT_SUM - Enroll Plan for Current Sumr
ENROLL_FALL - Enroll Plan for Fall
ENROLL_NEXT_SUM - Enroll Plan for Next Sumr
ENROLL_SPRING - Enroll Plan for Spring
ENROLL_WINTER - Enroll Plan for Winter
ERROR_CODE - Error Code
FAA_INSTITUT_NUM - FAA Institution Nbr
FAA_SIGNATURE - FAA Signature
FATHER_1ST_NM_INIT - Father's First Name Initial
FATHER_DOB - Father's Date of Birth
FATHER_GRADE_LVL - Father's Highest Grade Level
FATHER_LAST_NAME - Father's Last Name
FATHER_SSN - Father's SSN
FIRST_BACH_DEGREE - Received First Bachelor Degree
GRADUATE_STUDENT - Grad Student
HOUSING_CODE_1 - Student's Housing Code Col 1
HOUSING_CODE_2 - Student's Housing Code Col 2
HOUSING_CODE_3 - Student's Housing Code Col 3
HOUSING_CODE_4 - Student's Housing Code Col 4
HOUSING_CODE_5 - Student's Housing Code Col 5
HOUSING_CODE_6 - Student's Housing Code Col 6
HS_GED_RCVD - HS Diploma or GED Received
ID_OVERRIDE - ID Override
INTERESTED_IN_SL - Interested In Student Loans
INTERESTED_IN_WS - Interested In Work-Study
ISIR_LOAD_ACTION - Load Action
ISIR_LOAD_STATUS - Load Status
ISIR_STU_ENRL_STAT - Enrollment Status
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
IWD_APP_SIGNED_BY - FAFSA Signed by
IWD_BATCH_YR - Batch Year
IWD_BORN_PRIOR - Born Before 01-01-XXXX
IWD_BORN_PRIOR_76 - Born Before 01-01-1976
IWD_CITY - City
IWD_DL_STATE - Driver's License State Code
IWD_DRN - Data Release Number
IWD_ELIG_1040A_EZ - Eligible For 1040A or EZ
IWD_ELIG_1040A_PAR - Eligible For 1040A or EZ
IWD_FATH_WORK_INC - Father Income From Work
IWD_GRADE_LVL - Grade Level
IWD_HAVE_DL - Do You Have a Drivers License
IWD_INPUT_REC_TYPE - Input Record Type
IWD_LEGAL_RES_DT - Legal Res Date
IWD_MALE - Are You Male
IWD_MAR_STAT_DT - Marital Status Date
IWD_MOM_WORK_INC - Mother Income From Work
IWD_MTHLY_VET_BEN - Monthly Veterans Benefits
IWD_PAR_AGI - Par AGI
IWD_PAR_BUS_WORTH - Business Net Worth
IWD_PAR_CASH - Cash and Savings
IWD_PAR_EIC - Earned Income Credit
IWD_PAR_EMAIL - Parent's Email Address
IWD_PAR_FAM_MEM - Par Family Members
IWD_PAR_FARM_WORTH - Farm Net Worth
IWD_PAR_INVEST - Investment Net Worth
IWD_PAR_MAR_ST_DT - Parents' Marital Status Date
IWD_PAR_MEM_COLL - Nbr in College
IWD_PAR_NBR_EXEMP - Number of Exemptions
IWD_PAR_RES_DT - Legal Res Date
IWD_PAR_RES_PRI - Legal Res Before 01-01-XXXX
IWD_PAR_RES_PRI_94 - Legal Res Before 01-01-1994
IWD_PAR_STATE_RES - State of Legal Res
IWD_PAR_TAX_PAID - Income Tax Paid
IWD_PAR_WK_A - Total from WK A
IWD_PAR_WK_B - Total from WK B
IWD_PERM_ADDR02 - Permanent Mailing Address
IWD_PERM_PHONE - Perm Phone Number
IWD_PREP_EIN - Preparers EIN
IWD_PREP_SIGNATURE - Preparers Signature
IWD_PREP_SSN - Preparers SSN
IWD_RES_PRIOR - Legal Res Before 01-01-XXXX
IWD_RES_PRIOR_94 - Legal Res Before 01-01-1994
IWD_SERIAL_NO - Current Serial Number
IWD_SPS_WORK_INC - Spouse Income From Work
IWD_STATE - State
IWD_STATE_RES - State of Legal Res
IWD_STD_FIRST_NM02 - Student's First Name
IWD_STD_LAST_NAME - Last Name
IWD_STU_AGI - Stu Agi
IWD_STU_ALIEN_REG - Alien Registration Number
IWD_STU_BUS_WORTH - Student's Business Net Worth
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
IWD_STU_CASH - Cash and Savings
IWD_STU_EIC - Student EIC
IWD_STU_FAM_MEM - Stu Family Members
IWD_STU_FARM_WORTH - Farm Net Worth
IWD_STU_INVEST - Student's Investment Net Worth
IWD_STU_MEM_COLL - Nbr in College
IWD_STU_MI - Student Middle Initial
IWD_STU_NBR_EXEMP - Number of Exemptions
IWD_STU_TAX_PAID - Student Income Tax Paid
IWD_STU_WK_A - Student's Total from WK A
IWD_STU_WK_B - Student's Total from WK B
IWD_STU_WK_C - Student's Total from WK C
IWD_STU_WORK_INC - Student Income From Work
IWD_TRANS_NBR - Transaction Number
IWD_ZIP - Zip
LAST_NAME_SSN_CHNG - Last Name-SSN Change Flag
MARITAL_STAT - Marital Status
MARITAL_STAT_PAR - Marital Status-Parents
MARRIED - Student Married
MAX_MATCH_LEVEL - Max Search Match Level
MOTHER_1ST_NM_INIT - Mother's First Name Initial
MOTHER_DOB - Mother's Date of Birth
MOTHER_GRADE_LVL - Mother's Highest Grade Level
MOTHER_LAST_NAME - Mother's Last Name
MOTHER_SSN - Mother's SSN
NAME_CD - Name Code
NUM_MONTH_VET_BEN - VA Ben Nbr of Months
ORIG_SSN - Original SSN
ORPHAN - Orphan or Ward of the Court
PROCESS_DT - Process Date
PROCESS_INSTANCE - Process Instance
SCHOOL_CHOICE_1 - Student's 1st Choice School
SCHOOL_CHOICE_2 - Student's 2nd Choice School
SCHOOL_CHOICE_3 - Student's 3rd Choice School
SCHOOL_CHOICE_4 - Student's 4th Choice School
SCHOOL_CHOICE_5 - Student's 5th Choice School
SCHOOL_CHOICE_6 - Student's 6th Choice School
SEL_SERV_REGISTER - Permit Sel Serv to Enroll
SFA_ACTIVE_DUTY - Active Duty in U.S Military
SFA_EMANCIPT_MINOR - Emancipated Minor
SFA_FOOD_STAMPS - Receives Food Stamps
SFA_HOUSING_CODE10 - Student's Housing Code Col 10
SFA_HOUSING_CODE7 - Student's Housing Code Col 7
SFA_HOUSING_CODE8 - Student's Housing Code Col 8
SFA_HOUSING_CODE9 - Student's Housing Code Col 9
SFA_HS_DIP_EQUIV - HS Diploma or Equivalent
SFA_INTRSTD_IN_WSL - Work Study or Student Loans
SFA_LEGAL_GUARDIAN - Legal Guardianship
SFA_PAR_COMBAT_PAY - Parents Combat Pay
SFA_PAR_DISLOC_WRK - Parent Dislocated Worker
SFA_PAR_EDU_CREDIT - Parents Educational Credits
SFA_PAR_FOOD_STAMP - Parent Receives Food Stamps
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
SFA_PAR_GRANT_AID - Parents Grant/Scholarship Aid
SFA_PAR_INT_INCOME - Parents Interest Income
SFA_PAR_IRA_DIST - Parents IRA Distributions
SFA_PAR_IRA_PAY - Parents IRA Payments
SFA_PAR_LUNCH_BEN - Parent School Lunch Program
SFA_PAR_MIL_ALLOW - Parents Mil/Clergy Allowance
SFA_PAR_NEED_EMPL - Parents Need-Based Employment
SFA_PAR_PEN_PAY - Parents Pension Payments
SFA_PAR_SSI_INCOME - Parent Receives SSI Income
SFA_PAR_SUP_PAID - Parents Child Support Paid
SFA_PAR_SUP_RECV - Parents Child Support Received
SFA_PAR_TANF_BEN - Parent TANF Recipient
SFA_PAR_UNTAX_INC - Parents Other Untaxed Income
SFA_PAR_UNTAX_PEN - Parents Untaxed Pensions
SFA_PAR_VET_ED_BEN - Parents Vet Non-Edu Benefits
SFA_PAR_WIC_BEN - Parent WIC Benefits
SFA_RECV_VET_BEN - Receiving Veterans Benefits
SFA_RISK_HOMELESS - At Risk of Homelessness
SFA_SCHL_CHOICE_10 - Student's 10th Choice School
SFA_SCHL_CHOICE_7 - Student's 7th Choice School
SFA_SCHL_CHOICE_8 - Student's 8th Choice School
SFA_SCHL_CHOICE_9 - Student's 9th Choice School
SFA_SCHL_LUNCH_PRG - Participates in Sch Lunch Prog
SFA_SSI_INCOME - Receives SSI Income
SFA_STDNT_GENDER - Are You Male or Female
SFA_STU_COMBAT_PAY - Student Combat Pay
SFA_STU_DISLOC_WRK - Student Dislocated Worker
SFA_STU_EDU_CREDIT - Student's Educational Credits
SFA_STU_GRANT_AID - Student Grant/Scholarship Aid
SFA_STU_INT_INCOME - Student Interest Income
SFA_STU_IRA_DIST - Student IRA Distributions
SFA_STU_IRA_PAY - Student IRA Payments
SFA_STU_MIL_ALLOW - Students Mil/Clergy Allowance
SFA_STU_NEED_EMPL - Student Need-Based Employment
SFA_STU_NREP_MONEY - Other Non-Reported Money
SFA_STU_PEN_PAY - Student Pension Payments
SFA_STU_SUP_PAID - Student Child Support Paid
SFA_STU_SUP_RECV - Student Child Support Received
SFA_STU_UNTAX_INC - Student Other Untaxed Income
SFA_STU_UNTAX_PEN - Student Untaxed Pensions
SFA_STU_VET_ED_BEN - Student Vet Non-Edu Benefits
SFA_TANF_BENEFITS - TANF Recipient
SFA_TCH_COURSE_WRK - Teacher Coursework
SFA_VET_BEN_TYPE - Type of Veterans Benefits
SFA_WIC_BENEFITS - WIC Benefits Recipient
SFA_YOUTH_HUD - Youth determined by HUD
SFA_YOUTH_LIASON - Youth determined by SDL
SUSPEND_REASON - Suspend Reason
TAX_FORM_FILED - Tax Form Filed
TAX_FORM_FILED_PAR - Tax Form Filed - Parent
TAX_FORM_PAR - Tax Form-Parents
TAX_FORM_STU - Tax Form-Student
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
TRANS_RECEIPT_DT - Transaction Receipt Date
VETERAN - Veteran
Um Ityp Fa Vw
Y AID_YEAR - Aid Year
Y EFFDT - Effective Date
Y ITEM_TYPE - Item Type
Y SETID - SetID
AGGREGATE_AREA - Aggregate Area
CHARGE_PRIORITY - Charge Priority List
DESCR - Description
DESCRSHORT - Short Description
EFF_STATUS - Status as of Effective Date
FA_SOURCE - Source
FED_OR_INST - Fed/Inst Affected
FEDERAL_ID - Federal ID
FIN_AID_TYPE - Fin Aid Type
ITEM_TYPE_CD - Item Type Code
KEYWORD1 - Key Word
KEYWORD2 - Key Word 2
KEYWORD3 - Key Word 3
LOAN_PROGRAM - Loan Program
NEED_BASED - Need Based
REPORT_CODE - Institution Reporting Cd
TITLE_IV - Title IV Aid
UM_GASB_1 - Item Type GASB Node 1
UM_GASB_2 - Item Type GASB Node 2
UM_GASB_3 - Item Type GASB Node 3
UM_GASB_4 - Item Type GASB Node 4
UM_GASB_5 - Item Type GASB node 5
UM_SCRTY_1 - Item Type Security Node 1
UM_SCRTY_2 - Item Type Security Node 2
UM_SCRTY_3 - Item Type Security Node 3
UM_SCRTY_4 - Item Type Security Node 4
UM_SCRTY_5 - Item Type Security Node 5
UM_SCRTY_6 - Item Type Security Node 6
UM_SCRTY_7 - Item Type Security Node 7
UM_SCRTY_8 - Item Type Security Node 8
Um Sfa Va Benes Vw
(Max effective date <= current date)
Y ACAD_CAREER - Academic Career
Y EFFDT - Effective Date
Y EMPLID - EmplID
Y INSTITUTION - Academic Institution
Y STRM - Term
COMMENTS - Comment
EFF_STATUS - Status as of Effective Date
LASTUPDDTTM - Last Update Date/Time
LASTUPDOPRID - by
UM_ADV_PAY - Advance Pay
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
UM_CERT_CREDITS - Certified Credits
UM_DELIMINATED_DT - Delimination Date
UM_FA_CERT - FA Certification
UM_INELIGIBLE - Ineligible
UM_KICKER_AMT - Kicker Amount
UM_MONTHLY_AMT - Monthly Amount
UM_VA_CHAPTER - VA Chapter
CHAP 1606
CHAP 1607
CHAP 30
CHAP 31
CHAP 32
CHAP 33
CHAP 34
CHAP 35
UM_VA_FILE_NBR - VA File Number
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
Account SF - Account Balance by Emplid by Account Type
Y ACCOUNT_NBR - Account Nbr
Y ACCOUNT_TERM - Account Term
Y BUSINESS_UNIT - Business Unit
Y EMPLID - EmplID
ACAD_YEAR - Academic Year
ACCOUNT_BALANCE - Account Balance
ACCOUNT_TYPE_SF - Account Type
ACCT_STATUS - Account Status
BILL_REQ_ID - Bill Request ID
CLOSE_DT - Date Closed
CONTRACT_NUM - Contract Number
INCLUDE_BILLING - Include Billing
INCLUDE_IN_BALANCE - Include in Balance
INCLUDE_PREPAY - Include Pre-Pay
INCLUDE_TRANSFER - Include Transfers
LAST_ACCT_DT_AGED - Last Accounting Date Aged
LAST_AGING_DT - Last Aging Date
OPEN_DT - Created
OVERR_BILL_REQ_ID - Override Bill Request ID
Acct Typ Tbl SF - Account Type Table
Y SETID - SetID
Y ACCOUNT_TYPE_SF - Account Type
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
ACCT_NUM_PREFIX - Account Nbr Prefix
ACCT_PER_TERM - Account Per Term
BALANCE_FWD_SW - Balance Forward
CANCEL_CLASS - Include in Class Cancellation
DESCR - Description
DESCRSHORT - Short Description
EXCLUDE_AGE_FLG - Exclude From Aging Total
INCLUDE_BILLING - Include Billing
INCLUDE_IN_BALANCE - Include in Balance
INCLUDE_PREPAY - Include Pre-Pay
INCLUDE_TRANSFER - Include Transfers
LATE_FEE_ACCT_IND - Late Fee Account
LATE_FEE_ACCT_ORG - Ext Org Late Fee Account
LATE_FEE_CODE - Late Fee Code
LATE_FEE_CODE_ORG - Ext Org Late Fee Code
MOVE_EXCESS_FA - Move Excess Financial Aid
MOVE_EXCESS_PMT - Move Excess Payment
MOVE_EXCESS_WAIVER - Move Excess Waiver
PMT_PLAN_ACCT_FLG - Payment Plan Account
PRIMARY_ACCOUNT - Primary Account
SF_ACCOUNT_CLASS - Account Class
UNAPP_PMT_CREDHIST - View Unappld Pymt Credit Hist
Item SF - Account Transactions by Emplid by Item Number
Y BUSINESS_UNIT - Business Unit
Y COMMON_ID - ID
Y ITEM_NBR - Item Nbr
Y SA_ID_TYPE - ID Type
ACAD_CAREER - Academic Career
ACAD_YEAR - Academic Year
ACCOUNT_NBR - Account Nbr
ACCOUNT_TERM - Account Term
ACCOUNT_TYPE_SF - Account Type
ADM Admission Fees
CNV Converson Balance from ISIS
END Enrollment Deposits Paid UMS01
ENR Enrollment Fees
MCF Misc Charges and Fines
OTH Other
PP Payment Plans UMS01
PPL Payment Plans
PRL Payroll Deduction Payment Plan UMS03,UMS04,UMS07
RMB Room and Board
SCH Scholarships UMS01
SPN Sponsored Charges
TUT Tuition
UND Undefined Postings
XCP Cross Campus Account
XFA Excess Financial Aid
XPY Excess Payments
XWA Excess Waivers UMS06
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
XWV Excess Waiver Account UMS01,UMS02,UMS03,UMS04,UMS05,UMS07
ACTUAL_BILLING_DT - Actual Billing Date
ADM_APPL_NBR - Application Nbr
AID_YEAR - Aid Year
APPLIED_AMT - Applied Amount
BILLING_CAREER - Billing Career
BILLING_DT - Billing Date
CALENDAR_YEAR - Calendar Year
CHARGE_PRIORITY - Charge Priority List
CLASS_CRSE_FEE_IND - Class/Course Fee Indicator
CLASS_NBR - Class Nbr
COLLECTION_ID - Collection ID
CONTRACT_AMT - Contract Amt
CONTRACT_EMPLID - Contract ID
CONTRACT_NUM - Contract Number
COURSE_LIST - Course List
CRSE_ID - Course ID
CUR_RT_TYPE - Exchange Rate Type
CURRENCY_CD - Currency Code
DEPOSIT_NBR - Deposit Nbr
DISBURSEMENT_DATE - Disbursement Date
DUE_DT - Due Date
EMPLID - EmplID
ENCUMBERED_AMT - Amount Encumbered
EXT_ORG_ID - External Org ID
FEDERAL_TAX_RT - Federal Tax Rate
FEE_CD - Fee Code
GL_ASSESSED_AMT - GL Assessed
GL_BALANCED_AMT - GL Assessed
GL_FROM_SUBFEE - GL from Sub Fees
GL_SATISFIED_AMT - GL Satisfied Amount
INTEREST_DT - Interest Date
ITEM_AMT - Item Amount
ITEM_BALANCE - Item Balance
ITEM_EFFECTIVE_DT - Item Effective Date
ITEM_NBR_SOURCE - Item Nbr - Src Charge Nbr
ITEM_STATUS - Item Status
ITEM_TERM - Item Term
ITEM_TYPE - Item Type
ITEM_TYPE_CD - Item Type Code
A Application Fee App Fee
B Billing Only Billing
C Charge Charge
D Deposit Deposit
F Financial Aid Fin. Aid
G GL Interface Only GL Only
H Withholding Withhold
I Interest Interest
L Pre-Paid Tuition Pre-paid
P Payment Payment
R Refund Refund
T Transfers Transfers
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
V Contributor Relations CR
W Waiver Waiver
X Write-off Write-off
Z Pay Plan Credit Credit
LAST_ACTIVITY_DATE - Last Activity Date
LATE_FEE_CODE - Late Fee Code
LOCAL_TAX_RT - Local Tax Rate
NRA_TAXATION_SWTCH - NRA Taxation Option
ORIG_EFF_DT - Original Effective Date
ORIGINAL_ACCT_TERM - Original Account Term
ORIGNL_CURRENCY_CD - Currency Code
ORIGNL_ITEM_AMT - Item Amount
PAYMENT_ID_NBR - Payment ID Nbr
PRIORITY - Priority
PRIORITY_PMT_FLG - Payment Priority Flag
RATE_DIV - Rate Divisor
RATE_MULT - Rate Multiplier
RECEIPT_NBR - Receipt Number
REF1_DESCR - Reference Nbr
REFUND_EMPLID - Refund ID
REFUND_EXT_ORG_ID - Refund External Org ID
REFUND_NBR - Refund Nbr
REFUND_ORG_CONTACT - Refund Org Contact
SEL_GROUP - Tuition Group
SESSION_CODE - Session
SF_ADM_APPL_DEL - Application Deleted
SF_DEPOSIT_ID - Deposit ID
SF_PMT_REF_NBR - Reference Nbr
SRVC_IND_DTTM - Service Indicator Date Time
STATE_TAX_RT - State Tax Rate
STDNT_CAR_NBR - Student Career Nbr
T4_SENT_AMT - T4 Sent Amt
TAX_ADJ_WHOLDINGS - Gross Taxable Payments YTD
TAX_AUTHORITY_CD - Tax Authority
TAX_CD - Tax Code
TRACER_NBR - Bank Tracer Nbr
TRANS_FEE_CD - Transaction Fee Code
TRANSFER_AMT - Transfer Amt
TRANSFER_DT - Transfer Date
TRANSFER_PAYMNT_ID - Transfer Payment ID
TRANSFER_STATUS - Transfer Status
WAIVER_CODE - Waiver Code
Item Type Tbl - Item Type Table
Y EFFDT - Effective Date
Y ITEM_TYPE - Item Type
Y SETID - SetID
ACCTG_DT_CNTL - Accounting Date Control
ADJUSTMENT_CAL_SF - Adjustment Calendar
ALL_OR_NONE - Pay All or None
CHARGE_PRIORITY - Charge Priority List
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
CURRENCY_CD - Currency Code
DAYS_SINCE_EFFDT - Days Past Since Effdt
DAYS_TO_EFFDT - Days to Effdt
DEFAULT_AMT - Default Amount
DESCR - Description
DESCRSHORT - Short Description
DUEDAYS_PAST_EFFDT - Nbr of Days Past Effdt
DUEDAYS_PRIOR_EFFD - Nbr of Days Before Effdt
EFF_STATUS - Status as of Effective Date
ENCUMBRANCE_DAYS - Days to Encumber
ENCUMBRANCE_PCT - Encumbrance Pct
ENROL_FLAG - Enrolled Flag
ERNCD - Earnings Code
ERNCD_NOTAX - Earnings Code Non Taxable
GL_CRSE_CLASS_SPC - Course Class Specific
GL_INTERFACE_REQ - GL Interface Required
ITEM_TYPE_CD - Item Type Code
KEYWORD1 - Key Word
KEYWORD2 - Key Word 2
KEYWORD3 - Key Word 3
LOCAL_TAX_OFFSET - Local Tax Offset
LOCAL_TAX_PMT - Local Tax Payment
MATCH_WRITEOFF - Match Charge Write-Offs
MAXIMUM_AMT - Maximum Transaction Amount
MINIMUM_AMT - Mininum Transaction Amount
NRA_CREDIT_TAX_FLG - NRA Tax Payment Flag
NRA_DEBIT_TAX_FLG - NRA Tax Type
PAY_PRIORITY_ID - Payment Overall Priority
PAYMENT_PRIORITY - Payment Priority
PAYMENT_TERMS - Payment Terms
PRIORITY - Priority
PRIORITY_PMT_FLG - Payment Priority Flag
RECVABLE_FROM_CHRG - Pick up Receivable from Charge
REFUNDABLE_IND - Refundable Indicator
SECURITY_GROUP - Security Group
SF_1098_FLG - 1098-T Eligible
SSF_DEST_TUT_TYPE - DEST Tuition Type
SSF_STATE_FLAG - State
STATE_TAX_OFFSET - State Tax Offset
STATE_TAX_PMT - State Tax Payment
T2202A_FLG - T2202A Eligible
T2202A_OFFSET_FLG - T2202A Offset
T2202A_PCT - T2202A Percent
T4_INCOME - T4A Eligible
TAX_CD - Tax Code
TAXABLE_Y_N - Taxable
TENDER_CATEGORY - Tender Category
TENDER_SPEC - Tender Specific
TERM_ENROLL_REQ - Term Enroll Req for Posting
TUITION_DEPOSIT - Tuition Deposit
WAGE_LOSS_PLAN - Wage Loss Replacement Plan
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
Item Type Vw - Item Type View
Y SETID - SetID
Y ITEM_TYPE - Item Type
DESCR - Description
SF Acctg Ln - SF Accounting Line Table
Y RUN_DT - Run Date
Y SEQNUM - Sequence number
Y SF_LINE_NBR - Line Number
ACCOUNT - Account
ACCOUNTING_DT - Accounting Date
ACCOUNTING_PERIOD - Accounting Period
AFFILIATE - Affiliate
AFFILIATE_INTRA1 - Fund Affiliate
AFFILIATE_INTRA2 - Operating Unit Affiliate
ALTACCT - Alternate Account
APPL_JRNL_ID - Journal Template
AUDIT_ACTN - Action
BUDGET_PERIOD - Budget Period
BUDGET_REF - Budget Reference
BUSINESS_UNIT - Business Unit
BUSINESS_UNIT_GL - General Ledger Unit
CHARTFIELD1 - Chartfield 1
CHARTFIELD2 - Chartfield 2
CHARTFIELD3 - Chartfield 3
CLASS_FLD - Class Field
COMMON_ID - ID
CURRENCY_CD - Currency Code
DEPTID - Department
EMPLID - EmplID
EXT_GL_CHARTFLD - External GL Chart Field
FISCAL_YEAR - Fiscal Year
FOREIGN_AMOUNT - Foreign Amount
FOREIGN_CURRENCY - Foreign Currency Code
FUND_CODE - Fund Code
GL_DISTRIB_STATUS - Distribution Status
IN_PROCESS_FLG - In Process
ITEM_NBR - Item Nbr
JOURNAL_DATE - Journal Date
JOURNAL_ID - GL Journal ID
JOURNAL_LINE - GL Journal Line Number
JOURNAL_LINE_DATE - Journal Line Date
JRNL_LINE_STATUS - Journal Line Status
JRNL_LN_REF - Journal Line Reference
LEDGER - Ledger
LEDGER_GROUP - Ledger Group
LINE_DESCR - Journal Line Description
MONETARY_AMOUNT - Monetary Amount
OPEN_ITEM_STATUS - Open Item Status
OPERATING_UNIT - Operating Unit
PROCESS_INSTANCE - Process Instance
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
PRODUCT - Product
PROGRAM_CODE - Program Code
PROJECT_ID - Project/Grant
RATE_DIV - Rate Divisor
RATE_MULT - Rate Multiplier
RT_TYPE - Rate Type
SA_ID_TYPE - ID Type
SF_DEPOSIT_ID - Deposit ID
SF_EXT_ORG_ID - External Org ID
SF_GL_RUN_INSTANCE - Process Instance
STATISTIC_AMOUNT - Statistic Amount
STATISTICS_CODE - Statistics Code
Person Name - Current Primary Name View
Y EMPLID - EmplID
ASOFDATE - As Of Date
COUNTRY_NM_FORMAT - Format Using
FIRST_NAME - First Name
FIRST_NAME_SRCH - First Name
LAST_NAME - Last Name
LAST_NAME_PREF_NLD - Last Name Preference
LAST_NAME_SRCH - Last Name
MIDDLE_NAME - Middle Name
NAME - Name
NAME_AC - Alternate Character Name
NAME_DISPLAY - Display Name
NAME_FORMAL - Formal Name
NAME_INITIALS - Name Initials
NAME_PREFIX - Name Prefix
NAME_PSFORMAT - Name (LN,FN)
NAME_ROYAL_PREFIX - Name Royal Prefix
NAME_ROYAL_SUFFIX - Name Royal Suffix
NAME_SUFFIX - Name Suffix
NAME_TITLE - Title
NAME_TYPE - Type of Name
PARTNER_LAST_NAME - Last Name Partner
PARTNER_ROY_PREFIX - Prefix Partner
PREF_FIRST_NAME - Preferred First Name
SECOND_LAST_NAME - Second Last Name
SECOND_LAST_SRCH - Second Name
09/19/2008
D:\Docstoc\Working\pdf\95003bc1-dc2f-4544-bdc6-525164a4e98e.xls
FINANCIAL AID CALCULATIONS
FINANCIAL AID TYPE
CASE
WHEN Fin Aid Type = 'V' THEN 'Waiver'
WHEN Fin Aid Type = 'S' THEN 'Scholarship'
WHEN Fin Aid Type = 'W' THEN 'Work Study'
WHEN Fin Aid Type = 'F' THEN 'Fellowship'
WHEN Fin Aid Type = 'A' THEN 'Athletic'
WHEN Fin Aid Type = 'D' THEN 'Department'
WHEN Fin Aid Type = 'G' THEN 'Grant'
WHEN Fin Aid Type = 'O' THEN 'Other'
WHEN Fin Aid Type = 'L' THEN 'Loan'
WHEN Fin Aid Type = 'B' THEN 'Bursary'
ELSE 'Other'
END
CAMP
CASE
WHEN Institution = 'UMS01' THEN 'UMA'
WHEN Institution = 'UMS02' THEN 'UMF'
WHEN Institution = 'UMS03' THEN 'UMFK'
WHEN Institution = 'UMS04' THEN 'UMM'
WHEN Institution = 'UMS07' THEN 'UMPI'
WHEN Institution = 'UMS05' THEN 'UM'
WHEN Institution = 'UMS06' THEN 'USM'
ELSE 'Other'
END
FED ID
CASE
WHEN Federal Id = 'LDS' THEN 'Loans for Disadvantaged Stdnts'
WHEN Federal Id = 'NSF' THEN 'National Science Foundation'
WHEN Federal Id = 'ACG' THEN 'Academic Competitiveness Grant'
WHEN Federal Id = 'PCL' THEN 'Primary Care Loan'
WHEN Federal Id = 'JVTS' THEN 'Jacob K Javits Fellowship'
WHEN Federal Id = 'NIH' THEN 'National Institute of Health'
WHEN Federal Id = 'NURS' THEN 'Nursing Loan'
WHEN Federal Id = 'OTHR' THEN 'Other Federal Fund'
WHEN Federal Id = 'STFS' THEN 'Fed Stafford Loan - Subsidized'
WHEN Federal Id = 'FWSP' THEN 'Federal Work Study Program'
WHEN Federal Id = 'HEAL' THEN 'Health Education Assistance Ln'
WHEN Federal Id = 'HPSL' THEN 'Health Profession Student Loan'
WHEN Federal Id = 'IASA' THEN 'Iraq/Afghanistan Service Award'
WHEN Federal Id = 'PERK' THEN 'Federal Perkins Loan Program'
WHEN Federal Id = 'STFU' THEN 'Fed Stafford Loan-Unsubsidized'
WHEN Federal Id = 'TCH' THEN 'TEACH Grant'
WHEN Federal Id = 'PLUS' THEN 'Federal Stafford Loan, PLUS'
WHEN Federal Id = 'GAAN' THEN 'Grad Assistance in Natl Need'
WHEN Federal Id = 'GPLS' THEN 'Graduate Plus Loan'
WHEN Federal Id = 'PELL' THEN 'Federal PELL Grant'
WHEN Federal Id = 'SEOG' THEN 'Federal SEOG'
WHEN Federal Id = 'SMRT' THEN 'National Smart Grant'
ELSE 'Other'
END
ITEM TYPE CODE
CASE
WHEN Item Type Cd = 'D' THEN 'Deposit'
WHEN Item Type Cd = 'H' THEN 'Withholding'
WHEN Item Type Cd = 'L' THEN 'Pre-Paid Tuition'
WHEN Item Type Cd = 'F' THEN 'Financial Aid'
WHEN Item Type Cd = 'P' THEN 'Payment'
WHEN Item Type Cd = 'V' THEN 'Contributor Relations'
WHEN Item Type Cd = 'X' THEN 'Write-off'
WHEN Item Type Cd = 'G' THEN 'GL Interface Only'
WHEN Item Type Cd = 'Z' THEN 'Pay Plan Credit'
WHEN Item Type Cd = 'T' THEN 'Transfers'
WHEN Item Type Cd = 'C' THEN 'Charge'
WHEN Item Type Cd = 'W' THEN 'Waiver'
WHEN Item Type Cd = 'I' THEN 'Interest'
WHEN Item Type Cd = 'A' THEN 'Application Fee'
WHEN Item Type Cd = 'B' THEN 'Billing Only'
WHEN Item Type Cd = 'R' THEN 'Refund'
ELSE 'Other'
END
FUND SOURCE
CASE
WHEN Fa Source = 'O' THEN 'Other'
WHEN Fa Source = 'G' THEN 'Government'
WHEN Fa Source = 'I' THEN 'Institutional'
WHEN Fa Source = 'N' THEN 'Fed Non Title IV'
WHEN Fa Source = 'S' THEN 'State'
WHEN Fa Source = 'F' THEN 'Federal'
WHEN Fa Source = 'P' THEN 'Private'
WHEN Fa Source = 'U' THEN 'System'
ELSE 'Other'
END
AID AWARD STATUS
CASE
WHEN AWARD_STATUS = 'D' THEN 'Declined'
WHEN AWARD_STATUS = 'O' THEN 'Offered'
WHEN AWARD_STATUS = 'A' THEN 'Accepted'
WHEN AWARD_STATUS = 'C' THEN 'Cancelled'
ELSE 'Unknown'
END
LOAN PROG
CASE
WHEN Loan Program = 'F' THEN 'FFELP'
WHEN Loan Program = 'U' THEN 'University'
WHEN Loan Program = 'S' THEN 'State'
WHEN Loan Program = 'P' THEN 'Perkins'
WHEN Loan Program = 'D' THEN 'Direct Lending'
WHEN Loan Program = 'H' THEN 'Health Professions'
WHEN Loan Program = 'A' THEN 'Alternative'
ELSE 'Not Loan'
END
GIFT AID
CASE
WHEN Fin Aid Type = 'V' THEN 'Y'
WHEN Fin Aid Type = 'S' THEN 'Y'
WHEN Fin Aid Type = 'W' THEN 'N'
WHEN Fin Aid Type = 'F' THEN 'Y'
WHEN Fin Aid Type = 'A' THEN 'Y'
WHEN Fin Aid Type = 'D' THEN 'Y'
WHEN Fin Aid Type = 'G' THEN 'Y'
WHEN Fin Aid Type = 'O' THEN 'Y'
WHEN Fin Aid Type = 'L' THEN 'N'
WHEN Fin Aid Type = 'B' THEN 'Y'
ELSE 'N'
END
PS_ISIR_STUDENT_VW_CUSTOM
SELECT
A.EMPLID,
A.INSTITUTION,
A.AID_YEAR,
A.EFFDT,
A.EFFSEQ,
A.TABLE_ID,
A.NUM_FAMILY_MEMBERS,
A.DFLT_NUM_FAM_IND,
A.NUMBER_IN_COLLEGE,
A.DFLT_NUM_COLL_IND,
A.DOB_PRIOR,
A.DFLT_DOB_PRIOR_IND,
A.VETERAN,
A.GRADUATE_STUDENT,
A.MARRIED,
A.DFLT_MARRIED_IND,
A.MARITAL_STAT,
A.MAR_STATUS_DT,
A.DFLT_MAR_STAT_IND,
A.ORPHAN,
A.DEPENDENTS,
A.DFLT_DEPEND_IND,
A.TAX_FORM_FILED,
A.NUMBER_EXEMPTIONS,
A.AGI,
A.DFLT_AGI_IND,
A.TAXES_PAID,
A.DFLT_TAXES_PD_IND,
A.STD_EARNED_INCOME,
A.DFLT_STD_INC_IND,
A.SPS_EARNED_INCOME,
A.DFLT_SPS_INC_IND,
A.SOC_SEC_BENEFITS,
A.DFLT_SS_BEN_IND,
A.AFDC_BENEFITS,
A.DFLT_AFDC_BEN_IND,
A.CHILD_SUPPORT,
A.DFLT_CHLD_SPPT_IND,
A.UNTAXED_INCOME,
A.DFLT_UNTXD_INC_IND,
A.CASH_SAVINGS,
A.RE_INVEST_VALUE,
A.RE_INVEST_DEBT,
A.BUSINESS_VALUE,
A.BUSINESS_DEBT,
A.FARM_VALUE,
A.FARM_DEBT,
A.CURRENCY_CD,
A.SCHOOL_CHOICE_1,
A.HOUSING_CODE_1,
A.SCHOOL_CHOICE_2,
A.HOUSING_CODE_2,
A.SCHOOL_CHOICE_3,
A.HOUSING_CODE_3,
A.SCHOOL_CHOICE_4,
A.HOUSING_CODE_4,
A.SCHOOL_CHOICE_5,
A.HOUSING_CODE_5,
A.SCHOOL_CHOICE_6,
A.HOUSING_CODE_6,
A.STATE_AGNCY_RLSE,
A.SEL_SERV_REGISTER,
A.SIGNED_BY_APPLICNT,
A.SIGNED_BY_SPOUSE,
A.SIGNED_BY_FATHER,
A.SIGNED_BY_MOTHER,
A.FIRST_BACH_DEGREE,
A.MONTHLY_VET_BEN,
A.NUM_MONTH_VET_BEN,
A.INTERESTED_IN_WS,
A.INTERESTED_IN_SL,
A.INTERESTED_IN_PLUS,
A.APP_SIGNED_BY,
A.DT_APP_COMPLETED,
A.DT_GED_EARNED,
A.HS_GRAD_DT,
A.ATTEND_SAME_COLL,
A.ENROLL_CURNT_SUM,
A.ENROLL_FALL,
A.ENROLL_WINTER,
A.ENROLL_SPRING,
A.ENROLL_NEXT_SUM,
A.DEGREE_CERTIF,
A.COURSE_OF_STUDY,
A.DT_EXPCT_TO_COMP,
A.CURRENT_GRADE_LVL,
A.PAY_NUM_DEPENDENTS,
A.TOTAL_FROM_WS3,
A.DFLT_WS3_TOT_IND,
A.DEPNDNCY_STAT,
A.PROJECTED_YR_INC,
A.EARLY_ADMISSION,
A.ERND_INC_CREDIT,
A.DFLT_EIC_IND,
A.GRADUATE,
A.EXP_TOT_WS3,
A.DFLT_EXP_WS3_IND,
A.STATE_RESIDENCE,
A.RESIDENCY_DT,
A.DRIV_LIC_STATE,
A.HS_GED_RCVD,
A.FISAP_TOT_INC,
A.CITIZENSHIP_STATUS,
A.LEGAL_RES_PRI_94,
A.STUDENT_MALE,
A.TAX_RETURN_FILED,
A.ELIG_FOR_1040A_EZ,
A.TOTAL_FROM_WKA,
A.INV_NET_WORTH,
A.BUS_NET_WORTH,
A.FARM_NET_WORTH,
A.STUDENT_HAVE_DL,
A.DRUG_OFFENSE_CONV,
A.LEGAL_RES_PRIOR,
A.DFLT_WSA_TOT_IND,
A.DFLT_VETERAN_IND,
A.DFLT_CITIZEN_IND,
A.IWD_PERM_ADDR02,
A.IWD_CITY,
A.IWD_STATE,
A.IWD_ZIP,
A.IWD_PERM_PHONE,
A.IWD_STD_LAST_NAME,
A.IWD_STD_FIRST_NM02,
A.IWD_STU_MI,
A.SSN,
A.BIRTHDATE,
A.DRIVERS_LICENSE_NO,
A.IWD_STU_ALIEN_REG,
A.CHILDREN,
A.DFLT_CHILDREN_IND,
A.TOTAL_FROM_WKC,
A.DFLT_WKC_TOT_IND,
A.IWD_STD_EMAIL,
A.BLANK_AGI,
A.BLANK_TAXES_PAID,
A.BLANK_STD_EARN_INC,
A.BLANK_SPS_EARN_INC,
A.BLANK_TOT_FROM_WS3,
A.BLANK_TOT_FROM_WKA,
A.BLANK_INV_NET_WRTH,
A.ISIR_STU_ENRL_STAT,
A.BLANK_CASH_SAV,
A.SFA_ACTIVE_DUTY,
A.SFA_SSI_INCOME,
A.SFA_FOOD_STAMPS,
A.SFA_SCHL_LUNCH_PRG,
A.SFA_TANF_BENEFITS,
A.SFA_WIC_BENEFITS,
A.SFA_INTRSTD_IN_WSL,
A.SFA_STDNT_GENDER,
A.SFA_HS_DIP_EQUIV,
A.SFA_SCHL_CHOICE_7,
A.SFA_HOUSING_CODE7,
A.SFA_SCHL_CHOICE_8,
A.SFA_HOUSING_CODE8,
A.SFA_SCHL_CHOICE_9,
A.SFA_HOUSING_CODE9,
A.SFA_SCHL_CHOICE_10,
A.SFA_HOUSING_CODE10,
A.SFA_TCH_COURSE_WRK,
A.SFA_EMANCIPT_MINOR,
A.SFA_LEGAL_GUARDIAN,
A.SFA_YOUTH_LIASON,
A.SFA_YOUTH_HUD,
A.SFA_RISK_HOMELESS,
A.SFA_DISLOCATE_WRK,
A.SFA_EDU_CREDITS,
A.SFA_CHILD_SUP_PAID,
A.SFA_NEED_EMPLOYMNT,
A.SFA_GRANT_AID,
A.SFA_COMBATPAY,
A.SFA_PENSION_PAY,
A.SFA_IRA_PAY,
A.SFA_CHILD_SUP_RECV,
A.SFA_INTERST_INCOME,
A.SFA_IRA_DIST,
A.SFA_UNTAX_PENSION,
A.SFA_MILITARY_ALLOW,
A.SFA_VET_NONEDU_BEN,
A.SFA_UNTAX_INCOME,
A.SFA_NON_REP_MONEY,
A.SFA_RECV_VET_BEN,
A.SFA_VET_BEN_TYPE,
A.SFA_COOP_EARN,
A.SFA_DFLT_YOUTH_SCH,
A.SFA_DFLT_YOUTH_HUD,
A.SFA_DFLT_RISK_HOME,
A.SFA_BLANK_BUSNET,
A.SFA_BLANK_EDUCREDT,
A.SFA_BLANK_CHILDSUP,
A.SFA_BLANK_NEEDEMPL,
A.SFA_BLANK_GRANTAID,
A.SFA_BLANK_COMBAT,
A.SFA_BLANK_COOPEARN,
A.SFA_BLANK_PENSION,
A.SFA_BLANK_IRA_PAY,
A.SFA_BLANK_CHILDREC,
A.SFA_BLANK_INT_INC,
A.SFA_BLANK_IRA_DIST,
A.SFA_BLANK_UNTAXPEN,
A.SFA_BLANK_MILITARY,
A.SFA_BLANK_VET_NON,
A.SFA_BLANK_UNTAXINC,
A.SFA_BLANK_NON_REP
FROM PS_ISIR_STUDENT
WHERE A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_ISIR_STUDENT A_ED
WHERE A.EMPLID = A_ED.EMPLID
AND A.INSTITUTION = A_ED.INSTITUTION
AND A.AID_YEAR = A_ED.AID_YEAR
AND A_ED.EFFDT <= SYSDATE)
AND A.EFFSEQ =
(SELECT MAX(A_ES.EFFSEQ) FROM PS_ISIR_STUDENT A_ES
WHERE A.EMPLID = A_ES.EMPLID
AND A.INSTITUTION = A_ES.INSTITUTION
AND A.AID_YEAR = A_ES.AID_YEAR
AND A.EFFDT = A_ES.EFFDT)
PS_ISIR_PARENT_VW_CUSTOM
SELECT
A.EMPLID,
A.INSTITUTION,
A.AID_YEAR,
A.EFFDT,
A.EFFSEQ,
A.TABLE_ID,
A.MARITAL_STAT,
A.DFLT_MAR_STAT_IND,
A.LEGAL_RESIDENCE,
A.DT_LEGAL_RES,
A.NUMBER_IN_FAMILY,
A.DFLT_NUM_FAM_IND,
A.NUM_IN_COLLEGE,
A.DFLT_NUM_COLL_IND,
A.TAX_FORM_FILED,
A.NUMBER_EXEMPTIONS,
A.AGI,
A.DFLT_AGI_IND,
A.TAXES_PAID,
A.DFLT_TAXES_PD_IND,
A.FATHER_INCOME,
A.DFLT_DAD_INC_IND,
A.MOTHER_INCOME,
A.DFLT_MOM_INC_IND,
A.SOC_SEC_BENEFITS,
A.DFLT_SS_BEN_IND,
A.AFDC_BENEFITS,
A.DFLT_AFDC_BEN_IND,
A.CHILD_SUPPORT,
A.DFLT_CHLD_SPPT_IND,
A.UNTAXED_INCOME,
A.DFLT_UNTXD_INC_IND,
A.AGE_OLDER_PARENT,
A.CASH_SAVINGS,
A.RE_INVEST_VALUE,
A.RE_INVEST_DEBT,
A.BUSINESS_VALUE,
A.BUSINESS_DEBT,
A.FARM_VALUE,
A.FARM_DEBT,
A.CURRENCY_CD,
A.FATHER_GRADE_LVL,
A.MOTHER_GRADE_LVL,
A.TOTAL_FROM_WS3,
A.DFLT_WS3_TOT_IND,
A.PROJECTED_YR_INC,
A.ERND_INC_CREDIT,
A.DFLT_EIC_IND,
A.TAX_RETURN_FILED,
A.ELIG_FOR_1040A_EZ,
A.TOTAL_FROM_WKA,
A.INV_NET_WORTH,
A.BUS_NET_WORTH,
A.FARM_NET_WORTH,
A.LEGAL_RES_PRI_94,
A.DFLT_WSA_TOT_IND,
A.FATHER_SSN,
A.FATHER_LAST_NAME,
A.MOTHER_SSN,
A.MOTHER_LAST_NAME,
A.LEGAL_RES_PRIOR,
A.TOTAL_FROM_WKC,
A.DFLT_WKC_TOT_IND,
A.BLANK_AGI,
A.BLANK_TAXES_PAID,
A.BLANK_FATHER_INC,
A.BLANK_MOTHER_INC,
A.BLANK_TOT_FROM_WS3,
A.BLANK_TOT_FROM_WKA,
A.BLANK_INV_NET_WRTH,
A.MAR_STATUS_DT,
A.FATHER_1ST_NM_INIT,
A.FATHER_DOB,
A.MOTHER_1ST_NM_INIT,
A.MOTHER_DOB,
A.IWD_PAR_EMAIL,
A.DFLT_FATHERSSN_IND,
A.DFLT_MOTHERSSN_IND,
A.BLANK_CASH_SAV,
A.SFA_SSI_INCOME,
A.SFA_FOOD_STAMPS,
A.SFA_SCHL_LUNCH_PRG,
A.SFA_TANF_BENEFITS,
A.SFA_WIC_BENEFITS,
A.SFA_DISLOCATE_WRK,
A.SFA_EDU_CREDITS,
A.SFA_CHILD_SUP_PAID,
A.SFA_NEED_EMPLOYMNT,
A.SFA_GRANT_AID,
A.SFA_COMBATPAY,
A.SFA_PENSION_PAY,
A.SFA_IRA_PAY,
A.SFA_CHILD_SUP_RECV,
A.SFA_INTERST_INCOME,
A.SFA_IRA_DIST,
A.SFA_UNTAX_PENSION,
A.SFA_MILITARY_ALLOW,
A.SFA_VET_NONEDU_BEN,
A.SFA_UNTAX_INCOME,
A.SFA_COOP_EARN,
A.SFA_BLANK_BUSNET,
A.SFA_BLANK_EDUCREDT,
A.SFA_BLANK_CHILDSUP,
A.SFA_BLANK_NEEDEMPL,
A.SFA_BLANK_GRANTAID,
A.SFA_BLANK_COMBAT,
A.SFA_BLANK_COOPEARN,
A.SFA_BLANK_PENSION,
A.SFA_BLANK_IRA_PAY,
A.SFA_BLANK_CHILDREC,
A.SFA_BLANK_INT_INC,
A.SFA_BLANK_IRA_DIST,
A.SFA_BLANK_UNTAXPEN,
A.SFA_BLANK_MILITARY,
A.SFA_BLANK_VET_NON,
A.SFA_BLANK_UNTAXINC
FROM PS_ISIR_PARENT A
WHERE A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_ISIR_PARENT A_ED
WHERE A.EMPLID = A_ED.EMPLID
AND A.INSTITUTION = A_ED.INSTITUTION
AND A.AID_YEAR = A_ED.AID_YEAR
AND A_ED.EFFDT <= SYSDATE)
AND A.EFFSEQ =
(SELECT MAX(A_ES.EFFSEQ) FROM PS_ISIR_PARENT A_ES
WHERE A.EMPLID = A_ES.EMPLID
AND A.INSTITUTION = A_ES.INSTITUTION
AND A.AID_YEAR = A_ES.AID_YEAR
AND A.EFFDT = A_ES.EFFDT)
PS_ISIR_CONTROL_VW_CUSTOM
SELECT
A.EMPLID,
A.INSTITUTION,
A.AID_YEAR,
A.EFFDT,
A.EFFSEQ,
A.ISIR_TXN_NBR,
A.ORIG_SSN,
A.NAME_CD,
A.LAST_NAME_SSN_CHNG,
A.SS_MATCH,
A.SS_REGISTRATION,
A.INS_MATCH,
A.SSN_MATCH,
A.DT_APP_RECEIVED,
A.PELL_ELIGIBILITY,
A.ASSIGNED_PIN,
A.DUPLICATE_REQUEST,
A.SAR_C_FLAG,
A.MDE_EDE_SITE_CODE,
A.MDE_SITE_NBR,
A.VERF_SELECTION_IND,
A.HOLD_IND,
A.SYSTEM_GENERATED,
A.TRANS_RECEIPT_DT,
A.TRANS_PROCESS_DT,
A.CPS_REPROCESS_CD,
A.APP_SOURCE_CODE,
A.APP_SOURCE_SITE,
A.BATCH_NUMBER,
A.SFA_TRANS_TYPE,
A.ELEC_INSTITUT_IND,
A.VERIFCATION_TYPE,
A.CORRECTION_APPLIED,
A.FAA_INSTITUT_NUM,
A.INS_VERF_NUM,
A.FULL_PARTIAL_ESAR,
A.MULTI_INSTITUTION,
A.SEND_ISAR_SW,
A.FINAL_REVIEW_SW,
A.DEPNDNCY_OVERRIDE,
A.FAA_SIGNATURE,
A.APPLICATION_STAT,
A.APP_STAT_DT,
A.EFC_STATUS,
A.OPRID,
A.ADJ_EFC_CALC_REQ,
A.ASSUMPTION_OVRRIDE,
A.CORRECTION_STATUS,
A.CORR_STAT_DT,
A.CORR_NAME,
A.CORR_ADDRESS,
A.CORR_SSN,
A.CORR_DOB,
A.CORR_PHONE,
A.CORR_STATE_RES,
A.CORR_STATE_RES_DT,
A.CORR_LICENSE,
A.CORR_LICENSE_STATE,
A.CORR_CIT_STATUS,
A.CORR_ALIEN_REG_NUM,
A.CORR_MARITAL_STAT,
A.CORR_MARITAL_DATE,
A.TITLEIV_ELIG,
A.ISIR_PRINT_REQUEST,
A.ISIR_PRINT_DT,
A.INST_PROCESS_DT,
A.ADJ_EFC,
A.SSA_CITIZENSHP_IND,
A.ISIR_SERIAL_NUM,
A.OWNING_SCHOOL_CD,
A.SEND_VERIFY_FIELDS,
A.NSLDS_TXN_NBR,
A.INAS_RFC_CALL,
A.EARLY_ANALYSIS_FLG,
A.ELECTRONIC_APP_VER,
A.ETI_DEST_CD,
A.ISIR_REC_TYPE,
A.SIMP_NEED_TEST,
A.SSN_DATE_OF_DEATH,
A.SUB_APP_FLAG,
A.COMPUTE_BTCH_NO,
A.DUP_PROC_DT,
A.VA_MATCH,
A.PRISONER_MATCH,
A.PROCESS_INSTANCE,
A.PROCESS_DT,
A.APP_SOURCE,
A.TRANS_SOURCE,
A.ADDRESS_TYPE,
A.OVRD_ADDR_TYPE,
A.PREP_SSN,
A.PREP_SIGNATURE,
A.PREP_EIN,
A.ISIR_CORR_SRC,
A.ISIR_EFC_CHANGE,
A.ISIR_SEC_INS_MATCH,
A.ISIR_SEC_INS_VERF,
A.ISIR_DUP_SSN_CD,
A.CORR_EMAIL_ADDR,
A.ISIR_ORIG_IND,
A.VERIF_TRK_FLG,
A.EFC_OVRD_DSPLAY_FM,
A.ISIR_CPS_PUSHED,
A.ISIR_SAR_C_CHNG,
A.FATHER_SSN_MATCH,
A.MOTHER_SSN_MATCH,
A.SFA_VF_SEL_CHG_FLG,
A.SFA_REJ_ST_CHG_FLG,
A.ISIR_OVRD_E_TYPE,
A.ISIR_OVRD_P_TYPE,
A.PHONE_TYPE,
A.E_ADDR_TYPE,
A.SFA_SPL_CIRCUM_FLG,
A.SFA_DOD_MATCH,
A.SFA_DOD_PARENT,
A.SFA_STU_IRS_REQUST,
A.SFA_PAR_IRS_REQUST
FROM PS_ISIR_CONTROL A
WHERE A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_ISIR_CONTROL A_ED
WHERE A.EMPLID = A_ED.EMPLID
AND A.INSTITUTION = A_ED.INSTITUTION
AND A.AID_YEAR = A_ED.AID_YEAR
AND A_ED.EFFDT <= SYSDATE)
AND A.EFFSEQ =
(SELECT MAX(A_ES.EFFSEQ) FROM PS_ISIR_CONTROL A_ES
WHERE A.EMPLID = A_ES.EMPLID
AND A.INSTITUTION = A_ES.INSTITUTION
AND A.AID_YEAR = A_ES.AID_YEAR
AND A.EFFDT = A_ES.EFFDT)
PS_ISIR_COMPUTED_VW_CUSTOM
SELECT
A.EMPLID,
A.INSTITUTION,
A.AID_YEAR,
A.EFFDT,
A.EFFSEQ,
A.TABLE_ID,
A.PRIMARY_EFC,
A.SECONDARY_EFC,
A.PELL_SPCL_PRM_EFC,
A.PELL_SPCL_SEC_EFC,
A.PELL_PAID_EFC_TYPE,
A.VALID_EFC_CALC,
A.AUTO_ZERO_EFC,
A.FORMULA_TYPE,
A.PRM_ALT_MONTH_1,
A.PRM_ALT_MONTH_2,
A.PRM_ALT_MONTH_3,
A.PRM_ALT_MONTH_4,
A.PRM_ALT_MONTH_5,
A.PRM_ALT_MONTH_6,
A.PRM_ALT_MONTH_7,
A.PRM_ALT_MONTH_8,
A.PRM_ALT_MONTH_10,
A.PRM_ALT_MONTH_11,
A.PRM_ALT_MONTH_12,
A.SEC_ALT_MONTH_1,
A.SEC_ALT_MONTH_2,
A.SEC_ALT_MONTH_3,
A.SEC_ALT_MONTH_4,
A.SEC_ALT_MONTH_5,
A.SEC_ALT_MONTH_6,
A.SEC_ALT_MONTH_7,
A.SEC_ALT_MONTH_8,
A.SEC_ALT_MONTH_10,
A.SEC_ALT_MONTH_11,
A.SEC_ALT_MONTH_12,
A.TOTAL_INCOME,
A.ALWNC_AGAINST_TI,
A.STATE_TAX_ALWNC,
A.EMPLOYMENT_ALWNC,
A.INC_PROTECTN_ALWNC,
A.AVAILABLE_INCOME,
A.DESCRTN_NET_WORTH,
A.AST_PROTECTN_ALWNC,
A.CONTRIB_FROM_ASSET,
A.ADJ_AVAILABLE_INC,
A.TOTAL_PAR_CONTRIB,
A.TOTAL_STU_CONTRIB,
A.ADJ_PAR_CONTRIB,
A.DEP_STU_I_CONTRIB,
A.DEP_STU_A_CONTRIB,
A.STU_TOTAL_INC,
A.CONTRIB_AVAIL_INC,
A.FICA_TAX_PD,
A.CURRENCY_CD,
A.EFC_CALC_DT,
A.BUDGET_DURATION,
A.ADJ_EFC_AMT,
A.WEEKLY_PC,
A.WEEKLY_SC,
A.PRORATED_EFC,
A.SECONDARY_EFC_TP,
A.EFC_NET_WORTH,
A.STU_ALLOW_VS_TI,
A.STU_DISC_NET_WORTH,
A.SEC_NET_WORTH,
A.SEC_ALLOW_VS_TI,
A.SEC_SDNW,
A.PAID_EFC,
A.ISIR_CALC_SC,
A.ISIR_CALC_PC,
A.ISIR_CALC_EFC,
A.SFA_SIG_REJ_EFC
FROM PS_ISIR_COMPUTED A
WHERE A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_ISIR_COMPUTED A_ED
WHERE A.EMPLID = A_ED.EMPLID
AND A.INSTITUTION = A_ED.INSTITUTION
AND A.AID_YEAR = A_ED.AID_YEAR
AND A_ED.EFFDT <= SYSDATE)
AND A.EFFSEQ =
(SELECT MAX(A_ES.EFFSEQ) FROM PS_ISIR_COMPUTED A_ES
WHERE A.EMPLID = A_ES.EMPLID
AND A.INSTITUTION = A_ES.INSTITUTION
AND A.AID_YEAR = A_ES.AID_YEAR
AND A.EFFDT = A_ES.EFFDT)
PS_ITEM_TYPE_FA_CUSTOM
SELECT
A.SETID AS INSTITUTION,
A.ITEM_TYPE,
A.AID_YEAR,
A.EFFDT,
A.EFF_STATUS,
A.DESCR,
A.DESCRSHORT,
A.PAY_ACROSS_TERMS,
A.FA_SOURCE,
A.FEDERAL_ID,
A.LOAN_PROGRAM,
A.TITLE_IV,
A.AWARD_LETTER_PRINT,
A.PRINT_LTR_OPTION,
A.FAN_PRINT_SPECS,
A.FIN_AID_TYPE,
A.FED_OR_INST,
A.PACKAGE_LIMIT_RULE,
A.NEED_BASED,
A.MEET_NEED_COST,
A.DISBURSE_METHOD,
A.AGGREGATE_AREA,
A.FA_ROUND_OPTION,
A.ROUND_DIRECTION,
A.REMAINDER_RULE,
A.FEE_REMAINDER_RULE,
A.TRUNCATE_FEE,
A.LOAN_INTEREST_ATTR,
A.PASS_ANTICIP_AID,
A.ANTCP_AID_EXP_DAYS,
A.PACKAGING_FEED,
A.EQUITY_AWARD,
A.INST_OVRAWRD_RULE,
A.FED_OVRAWRD_RULE,
A.OVRAWD_TOLERANCE,
A.REPORT_CODE,
A.AWARD_MSG_CD,
A.SIGNATURE_RELEASE,
A.AUTO_CANCEL_TYPE,
A.MANUAL_AUTH_IND,
A.LINE_REASON_CD,
A.PARENT_ITEM_TYPE,
A.SELECTION_CRITERIA,
A.METHODOLOGY,
A.SELF_HELP_AWARD,
A.LOCK_AWARD_FLAG,
A.AWARD_PERIOD,
A.ONE_INSTANCE_ITEM,
A.MISSING_TERM_SPLIT,
A.DISB_PROTECTION,
A.SEQUENCE_OVERRIDE,
A.INCLUDE_IN_TSCRPT,
A.FA_SS_ACCEPT,
A.FA_SS_DECLINE,
A.FA_SS_REDUX,
A.SFA_MPN_REQUIRED,
A.SFA_LNTRANSIT_FLAG,
A.SFA_ASG_ACAD_LEVEL,
A.SFA_ADDL_PELL_ELIG,
A.DESCRLONG
FROM PS_ITEM_TYPE_FA A
WHERE A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_ITEM_TYPE_FA A_ED
WHERE A.ITEM_TYPE = A_ED.ITEM_TYPE
AND A.SETID = A_ED.SETID
AND A.AID_YEAR = A_ED.AID_YEAR
AND A_ED.EFFDT <= SYSDATE)
PS_RESIDENCY_OFF_VW_CUSTOM
SELECT
A.EMPLID,
A.ACAD_CAREER,
A.INSTITUTION,
A.EFFECTIVE_TERM,
A.RESIDENCY_DT,
A.RESIDENCY,
A.ADMISSION_RES,
A.FIN_AID_FED_RES,
A.FIN_AID_ST_RES,
A.TUITION_RES,
A.ADMISSION_EXCPT,
A.FIN_AID_FED_EXCPT,
A.FIN_AID_ST_EXCPT,
A.TUITION_EXCPT,
A.SCC_DISTRICT,
A.CITY,
A.COUNTY,
A.STATE,
A.COUNTRY,
A.POSTAL,
A.COMMENTS
FROM PS_RESIDENCY_OFF A
WHERE A.EFFECTIVE_TERM =
(SELECT /*+ unnest */ MAX(B.EFFECTIVE_TERM) FROM PS_RESIDENCY_OFF B
WHERE A.EMPLID = B.EMPLID
AND A.INSTITUTION = B.INSTITUTION
AND A.ACAD_CAREER = B.ACAD_CAREER
Related docs
