FAN_ISIR_CMP_VW(SQL View) |
Index Back |
|---|---|
Computed ViewThis is a view of the ISIR_COMPUTED table used for Financial Aid Award Notification Letter equation selection processing. |
| SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,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 ,A.SFA_PRIMARY_PC ,A.SFA_PRIMARY_SCA ,A.SFA_PRIMARY_SIC ,A.SFA_COMPUT_TYPE ,A.SFA_MAX_PELLIND ,A.SFA_MIN_PELLIND ,A.SFA_FPS_STD_FWS ,A.SFA_FPS_SPS_FWS ,A.SFA_FPS_PAR_FWS ,A.SFA_FPS_OTH_FWS ,A.SFA_FPS_PAR_ALLOW ,A.SFA_FPS_PAR_PAYROL ,A.SFA_FPS_PAR_IPA ,A.SFA_FPS_PEEA ,A.SFA_FPS_PAI ,A.SFA_FPS_PAAI ,A.SFA_FPS_PC ,A.SFA_FPS_STD_PAYROL ,A.SFA_FPS_STD_IPA ,A.SFA_FPS_ALLOW ,A.SFA_FPS_SEEA ,A.SFA_FPS_STD_ALLOW ,A.SFA_FPS_STAI ,A.SFA_FPS_SCI ,A.SFA_FPS_SAAI ,A.SFA_FPS_TOT_SAAI ,A.SFA_FPS_PIA ,A.SFA_FPS_PIO ,A.SFA_FPS_PNW ,A.SFA_FPS_SNW ,A.SFA_FPS_SIA ,A.SFA_FPS_SIO ,A.SFA_FPS_PDNW ,A.SFA_FPS_PAPA ,A.SFA_FPS_PCA ,A.SFA_FPS_SAPA ,A.SFA_FPS_SCA 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 <= %CurrentDateIn) 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) AND A.TABLE_ID = '1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: STUDENT_AID |
| 4 | PRIMARY_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Primary EFC |
| 5 | SECONDARY_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Secondary EFC |
| 6 | PELL_SPCL_PRM_EFC | Signed Number(6,0) | DECIMAL(5) NOT NULL | PELL Special Primary EFC |
| 7 | PELL_SPCL_SEC_EFC | Signed Number(6,0) | DECIMAL(5) NOT NULL | PELL Special Secondary EFC |
| 8 | PELL_PAID_EFC_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Pell Paid EFC Type |
| 9 | VALID_EFC_CALC | Character(1) | VARCHAR2(1) NOT NULL |
Valid EFC Calc
Y/N Table Edit |
| 10 | AUTO_ZERO_EFC | Character(1) | VARCHAR2(1) NOT NULL |
Auto Zero EFC
Y=EFC Set To Zero |
| 11 | FORMULA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Formula Type
1=Full Needs Test: Dependent 2=Full Needs Test: Ind w/out Dep 3=Full Needs Test: Ind w/Deps 4=Simplified: Dependent 5=Simplified: Ind w/out Deps 6=Simplified: Indep w/Deps A=Dependent B=Independent w/o dependents C=Independent with dependents G=Boolean I=Iterative R=Regular |
| 12 | PRM_ALT_MONTH_1 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 1 |
| 13 | PRM_ALT_MONTH_2 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 2 |
| 14 | PRM_ALT_MONTH_3 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 3 |
| 15 | PRM_ALT_MONTH_4 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 4 |
| 16 | PRM_ALT_MONTH_5 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 5 |
| 17 | PRM_ALT_MONTH_6 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 6 |
| 18 | PRM_ALT_MONTH_7 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 7 |
| 19 | PRM_ALT_MONTH_8 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 8 |
| 20 | PRM_ALT_MONTH_10 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 10 |
| 21 | PRM_ALT_MONTH_11 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 11 |
| 22 | PRM_ALT_MONTH_12 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 12 |
| 23 | SEC_ALT_MONTH_1 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 1 |
| 24 | SEC_ALT_MONTH_2 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 2 |
| 25 | SEC_ALT_MONTH_3 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 3 |
| 26 | SEC_ALT_MONTH_4 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 4 |
| 27 | SEC_ALT_MONTH_5 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 5 |
| 28 | SEC_ALT_MONTH_6 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 6 |
| 29 | SEC_ALT_MONTH_7 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 7 |
| 30 | SEC_ALT_MONTH_8 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 8 |
| 31 | SEC_ALT_MONTH_10 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 10 |
| 32 | SEC_ALT_MONTH_11 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 11 |
| 33 | SEC_ALT_MONTH_12 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 12 |
| 34 | TOTAL_INCOME | Signed Number(16,0) | DECIMAL(15) NOT NULL | Total Income |
| 35 | ALWNC_AGAINST_TI | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Allowances |
| 36 | STATE_TAX_ALWNC | Signed Number(8,0) | DECIMAL(7) NOT NULL | State Tax Allowance |
| 37 | EMPLOYMENT_ALWNC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Employment Allowance |
| 38 | INC_PROTECTN_ALWNC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Inc Protection Allowance |
| 39 | AVAILABLE_INCOME | Signed Number(9,0) | DECIMAL(8) NOT NULL | Available Income |
| 40 | DESCRTN_NET_WORTH | Signed Number(8,0) | DECIMAL(7) NOT NULL | Discretionary Net Worth |
| 41 | AST_PROTECTN_ALWNC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Asset Protection Allowance |
| 42 | CONTRIB_FROM_ASSET | Signed Number(8,0) | DECIMAL(7) NOT NULL | Contribution from Assets |
| 43 | ADJ_AVAILABLE_INC | Signed Number(9,0) | DECIMAL(8) NOT NULL | Adj Available Income |
| 44 | TOTAL_PAR_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Parent Contribution |
| 45 | TOTAL_STU_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Student Contribution |
| 46 | ADJ_PAR_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Parent Contribution |
| 47 | DEP_STU_I_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Student Income Contribution |
| 48 | DEP_STU_A_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Student Asset Contribution |
| 49 | STU_TOTAL_INC | Signed Number(16,0) | DECIMAL(15) NOT NULL | Students Total Income |
| 50 | CONTRIB_AVAIL_INC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Contribution Available Income |
| 51 | FICA_TAX_PD | Signed Number(12,0) | DECIMAL(11) NOT NULL | FICA Taxes |
| 52 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 53 | EFC_CALC_DT | Date(10) | DATE | EFC Calc'd On |
| 54 | BUDGET_DURATION | Number(2,0) | SMALLINT NOT NULL | Budget Duration |
| 55 | ADJ_EFC_AMT | Signed Number(6,0) | DECIMAL(5) NOT NULL | Adjust EFC |
| 56 | WEEKLY_PC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Weekly EFC Parent Contribution |
| 57 | WEEKLY_SC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Weekly EFC Stdnt Contribution |
| 58 | PRORATED_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Prorated EFC |
| 59 | SECONDARY_EFC_TP | Character(1) | VARCHAR2(1) NOT NULL | Secondary EFC Type |
| 60 | EFC_NET_WORTH | Number(9,0) | DECIMAL(9) NOT NULL | EFC Net Worth |
| 61 | STU_ALLOW_VS_TI | Signed Number(8,0) | DECIMAL(7) NOT NULL | Student's Allowance VS TI |
| 62 | STU_DISC_NET_WORTH | Signed Number(10,0) | DECIMAL(9) NOT NULL | Student's Disc Net Worth |
| 63 | SEC_NET_WORTH | Number(9,0) | DECIMAL(9) NOT NULL | Secondary Net Worth |
| 64 | SEC_ALLOW_VS_TI | Signed Number(8,0) | DECIMAL(7) NOT NULL | Sec Stu Allow VS Total Income |
| 65 | SEC_SDNW | Signed Number(8,0) | DECIMAL(7) NOT NULL | Sec Stu Disc Net Worth |
| 66 | PAID_EFC | Signed Number(6,0) | DECIMAL(5) NOT NULL | Paid EFC |
| 67 | ISIR_CALC_SC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Non-Overridden Federal SC calculated by INAS. |
| 68 | ISIR_CALC_PC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Non-Overridden Federal PC calculated by INAS. |
| 69 | ISIR_CALC_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Non-Overridden Federal EFC calculated by INAS. |
| 70 | SFA_SIG_REJ_EFC | Number(6,0) | INTEGER NOT NULL | Signature Reject EFC |
| 71 | SFA_PRIMARY_PC | Signed Number(12,0) | DECIMAL(11) NOT NULL | Primary Parent Contrb |
| 72 | SFA_PRIMARY_SCA | Signed Number(12,0) | DECIMAL(11) NOT NULL | Primary Stu Contrb from Assets |
| 73 | SFA_PRIMARY_SIC | Signed Number(12,0) | DECIMAL(11) NOT NULL | Primary Stu Contrb from Income |
| 74 | SFA_COMPUT_TYPE | Character(2) | VARCHAR2(2) NOT NULL | 2425 : Computation Type |
| 75 | SFA_MAX_PELLIND | Character(1) | VARCHAR2(1) NOT NULL | 2425: Maximum Pell Indicator |
| 76 | SFA_MIN_PELLIND | Character(1) | VARCHAR2(1) NOT NULL | 2425: Minimum Pell Indicator |
| 77 | SFA_FPS_STD_FWS | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Student Total Federal Work Study Earnings |
| 78 | SFA_FPS_SPS_FWS | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Student Spouse Total Federal Work Study Earnings |
| 79 | SFA_FPS_PAR_FWS | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Parent Total Federal Work Study Earnings |
| 80 | SFA_FPS_OTH_FWS | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Other Parent Total Federal Work Study Earnings |
| 81 | SFA_FPS_PAR_ALLOW | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Total Parent Allowances Against Income |
| 82 | SFA_FPS_PAR_PAYROL | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Payroll Tax Allowance |
| 83 | SFA_FPS_PAR_IPA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Protection Allowance (IPA)� |
| 84 | SFA_FPS_PEEA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Employment Expense Allowance (PEEA) |
| 85 | SFA_FPS_PAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Parent Available Income (PAI) |
| 86 | SFA_FPS_PAAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Parent Adjusted Available Income (PAAI) |
| 87 | SFA_FPS_PC | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Parent Contribution (PC) |
| 88 | SFA_FPS_STD_PAYROL | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Student Payroll Tax Allowance |
| 89 | SFA_FPS_STD_IPA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Student Income Protection Allowance (IPA)� |
| 90 | SFA_FPS_ALLOW | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Student Allowance for Parents negative Adjusted Available Income |
| 91 | SFA_FPS_SEEA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Student Employment Expense Allowance (SEEA) |
| 92 | SFA_FPS_STD_ALLOW | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Total Student Allowances Against Income |
| 93 | SFA_FPS_STAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Student Available Income (StAI) |
| 94 | SFA_FPS_SCI | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Student Contribution from Income (SCI) |
| 95 | SFA_FPS_SAAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Student Adjusted Available Income (SAAI) |
| 96 | SFA_FPS_TOT_SAAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Total Student Contribution from SAAI |
| 97 | SFA_FPS_PIA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 98 | SFA_FPS_PIO | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 99 | SFA_FPS_PNW | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 100 | SFA_FPS_SNW | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 101 | SFA_FPS_SIA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 102 | SFA_FPS_SIO | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 103 | SFA_FPS_PDNW | Number(7,0) | INTEGER NOT NULL | Parent Discretionary Net Worth |
| 104 | SFA_FPS_PAPA | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Parent Asset Protection Allowance |
| 105 | SFA_FPS_PCA | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Parent Contribution from Assets |
| 106 | SFA_FPS_SAPA | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Student Asset Protection Allowance |
| 107 | SFA_FPS_SCA | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Student Contribution from Assets (SCA) |