Financial Aid Dependency - Legal Guardian - Excel by qcz62603

VIEWS: 145 PAGES: 63

Financial Aid Dependency - Legal Guardian document sample

More Info
									DISCOVERER STUDENT FINANCIAL AID VIEWS AND TABLES




    09/19/2008
    D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.xls
09/19/2008
D:\Docstoc\Working\pdf\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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\a331f6a0-d3ba-4058-98f7-ed1cd09fad9b.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

								
To top