SFA_NAC_ASRJ_VW(SQL View) |
Index Back |
|---|---|
Assumption/Reject FM ReqAssumptions/Reject view for FMNAC Request |
| SELECT DISTINCT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.EFFDT , A.EFFSEQ , B.ASMPTN_OVR_AGI_P , B.ASMPTN_OVR_COL_P ,B.ASMPTN_OVR_COL_S ,B.ASMPTN_OVR_AGI_S ,B.ASMPTN_OVR_WS3_P ,B.ASMPTN_OVR_WS3_S ,B.SFA_REJ_OVR_TX_PAR ,B.SFA_REJ_OVR_NO_TAX ,B.SFA_REJ_OVR_MAR_ST ,B.SFA_REJ_OVR_TX_STU ,B.REJ_OVR_BIRTH_YEAR ,B.REJ_OVR_IND_STDNT ,B.REJ_OVR_TAX_RANGE ,B.REJ_OVR_TAXRNG_DEP ,B.SFA_REJ_OVR_DADSSN ,B.SFA_REJ_OVR_MOMSSN ,B.REJ_OVR_STDNT_NAME ,B.REJ_OVR_BIG_FAMILY ,B.ASMD_CITIZENSHIP ,B.ASMD_STU_MAR_STAT ,B.ASMD_STU_AGI ,B.ASMD_STU_TAX_PAID ,B.ASMD_STU_ERN_INC ,B.ASMD_SPS_ERN_INC ,B.ASMD_STU_WKC ,B.ASMD_STU_DOB_PRIOR ,B.ASMD_STU_MARRIED ,B.ASMD_CHILDREN ,B.ASMD_STU_LGL_DEP ,B.ASMD_STU_NBR_INFAM ,B.ASMD_STU_NBR_COLL ,B.SFA_STU_ASM_AST_VL ,B.ASMD_PAR_MAR_STAT ,B.ASMD_PAR_NBR_INFAM ,B.ASMD_PAR_NBR_COLL ,B.ASMD_PAR_AGI ,B.ASMD_PAR_TAX_PAID ,B.ASMD_DAD_ERN_INC ,B.ASMD_MOM_ERN_INC ,B.ASMD_PAR_WKC ,B.SFA_PAR_ASM_AST_VL FROM %Table(ISIR_CONTROL) A , %Table(ISIR_INTERPRET) B WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.EMPLID = B.EMPLID AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM %Table(ISIR_CONTROL) C WHERE C.EMPLID = A.EMPLID AND C.INSTITUTION = A.INSTITUTION AND C.AID_YEAR = A.AID_YEAR) AND A.EFFSEQ = ( SELECT MAX(D.EFFSEQ) FROM %Table(ISIR_CONTROL) D WHERE D.EMPLID = A.EMPLID AND D.INSTITUTION = A.INSTITUTION AND D.AID_YEAR = A.AID_YEAR AND D.EFFDT = A.EFFDT) AND B.EFFDT = A.EFFDT AND B.EFFSEQ = A.EFFSEQ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | ASMPTN_OVR_AGI_P | Character(1) | VARCHAR2(1) NOT NULL |
Parent AGI
1=Yes 2=No |
| 7 | ASMPTN_OVR_COL_P | Character(1) | VARCHAR2(1) NOT NULL |
Parent Num In College
1=Yes 2=No |
| 8 | ASMPTN_OVR_COL_S | Character(1) | VARCHAR2(1) NOT NULL |
Student Num In College
1=Yes 2=No |
| 9 | ASMPTN_OVR_AGI_S | Character(1) | VARCHAR2(1) NOT NULL |
Student AGI
1=Yes 2=No |
| 10 | ASMPTN_OVR_WS3_P | Character(1) | VARCHAR2(1) NOT NULL |
Par Inc. From WKB/C Asmd 0
1=Yes 2=No |
| 11 | ASMPTN_OVR_WS3_S | Character(1) | VARCHAR2(1) NOT NULL |
Stu Inc. From WKB/C Asmd 0
1=Yes 2=No |
| 12 | SFA_REJ_OVR_TX_PAR | Character(1) | VARCHAR2(1) NOT NULL |
Reject Override 12
1=Yes 2=No |
| 13 | SFA_REJ_OVR_NO_TAX | Character(1) | VARCHAR2(1) NOT NULL |
Reject Override 20
1=Yes |
| 14 | SFA_REJ_OVR_MAR_ST | Character(1) | VARCHAR2(1) NOT NULL |
Reject Override 21
1=Yes |
| 15 | SFA_REJ_OVR_TX_STU | Character(1) | VARCHAR2(1) NOT NULL |
Reject Override 3
1=Yes 2=No |
| 16 | REJ_OVR_BIRTH_YEAR | Character(1) | VARCHAR2(1) NOT NULL |
Date of Birth Yr is 1900-1928
1=Yes |
| 17 | REJ_OVR_IND_STDNT | Character(1) | VARCHAR2(1) NOT NULL |
Student Independnt Status
1=Yes 2=No |
| 18 | REJ_OVR_TAX_RANGE | Character(1) | VARCHAR2(1) NOT NULL |
Taxes paid is high, but < AGI
1=Yes |
| 19 | REJ_OVR_TAXRNG_DEP | Character(1) | VARCHAR2(1) NOT NULL |
Taxes paid is high, but < AGI
1=Yes |
| 20 | SFA_REJ_OVR_DADSSN | Character(1) | VARCHAR2(1) NOT NULL |
Reject Override J
1=Yes 2=No |
| 21 | SFA_REJ_OVR_MOMSSN | Character(1) | VARCHAR2(1) NOT NULL |
Reject Override K
1=Yes 2=No |
| 22 | REJ_OVR_STDNT_NAME | Character(1) | VARCHAR2(1) NOT NULL |
Student First/Last Name
1=Yes 2=No |
| 23 | REJ_OVR_BIG_FAMILY | Character(1) | VARCHAR2(1) NOT NULL |
Large Family Size
1=Yes 2=No |
| 24 | ASMD_CITIZENSHIP | Character(1) | VARCHAR2(1) NOT NULL |
Assumed Citizenship
1=Assumed Student is a Citizen 2=Assumd Student Is Elg Non-Cit |
| 25 | ASMD_STU_MAR_STAT | Character(1) | VARCHAR2(1) NOT NULL | Assumed Marital Status-Student |
| 26 | ASMD_STU_AGI | Signed Number(8,0) | DECIMAL(7) NOT NULL | Assumed AGI-Student |
| 27 | ASMD_STU_TAX_PAID | Signed Number(8,0) | DECIMAL(7) NOT NULL | Assumed U. S. Tax Paid |
| 28 | ASMD_STU_ERN_INC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Assumed Stu's Earned Income |
| 29 | ASMD_SPS_ERN_INC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Assumed Sps's Earned Income |
| 30 | ASMD_STU_WKC | Signed Number(9,0) | DECIMAL(8) NOT NULL | Worksheet C Total |
| 31 | ASMD_STU_DOB_PRIOR | Character(1) | VARCHAR2(1) NOT NULL | DOB Before |
| 32 | ASMD_STU_MARRIED | Character(1) | VARCHAR2(1) NOT NULL | Assumed Value Student Married |
| 33 | ASMD_CHILDREN | Character(1) | VARCHAR2(1) NOT NULL | Children |
| 34 | ASMD_STU_LGL_DEP | Character(1) | VARCHAR2(1) NOT NULL | Assumed Dependents |
| 35 | ASMD_STU_NBR_INFAM | Character(2) | VARCHAR2(2) NOT NULL | Number Of Family Members-Stu |
| 36 | ASMD_STU_NBR_COLL | Number(2,0) | SMALLINT NOT NULL | Number in College |
| 37 | SFA_STU_ASM_AST_VL | Character(1) | VARCHAR2(1) NOT NULL |
Asset Threshold Exceeded
Y=Yes |
| 38 | ASMD_PAR_MAR_STAT | Character(1) | VARCHAR2(1) NOT NULL | Assumed Marital Status-Parent |
| 39 | ASMD_PAR_NBR_INFAM | Character(2) | VARCHAR2(2) NOT NULL | Number Of Family Members-Par |
| 40 | ASMD_PAR_NBR_COLL | Number(2,0) | SMALLINT NOT NULL | Assumed Number in College |
| 41 | ASMD_PAR_AGI | Signed Number(8,0) | DECIMAL(7) NOT NULL | Assumed AGI-Parent |
| 42 | ASMD_PAR_TAX_PAID | Number(7,0) | INTEGER NOT NULL | Par Tax Paid |
| 43 | ASMD_DAD_ERN_INC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Assumed Father's Earned Income |
| 44 | ASMD_MOM_ERN_INC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Assumed Mother's Earned Income |
| 45 | ASMD_PAR_WKC | Signed Number(9,0) | DECIMAL(8) NOT NULL | Assumed WKC - Par |
| 46 | SFA_PAR_ASM_AST_VL | Character(1) | VARCHAR2(1) NOT NULL |
Asset Threshold Exceeded
Y=Yes |