|
SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , 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 , A.SFA_HIGH_SCHL_FLAG , A.SFA_STU_IRS_AGI , A.SFA_STU_IRS_FIT , A.SFA_PAR_IRS_AGI , A.SFA_PAR_IRS_FIT , A.SFA_STU_IRS_TAXRET , A.SFA_STU_IRS_EXEMPT , A.SFA_STU_IRS_EDCRDT , A.SFA_STU_IRS_IRAPAY , A.SFA_STU_IRS_INTRST , A.SFA_STU_IRS_IRADIS , A.SFA_STU_IRS_UNTAX , A.SFA_STU_IRS_STATUS , A.SFA_PAR_IRS_TAXRET , A.SFA_PAR_IRS_EXEMPT , A.SFA_PAR_IRS_EDCRDT , A.SFA_PAR_IRS_IRAPAY , A.SFA_PAR_IRS_INTRST , A.SFA_PAR_IRS_IRADIS , A.SFA_PAR_IRS_UNTAX , A.SFA_PAR_IRS_STATUS , A.SFA_CFH_INDICATOR ,A.SFA_STU_IRS_SCHED ,A.SFA_PAR_IRS_SCHED ,A.SFA_INCAR_APP_FLAG FROM PS_ISIR_CONTROL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ISIR_CONTROL B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_ISIR_CONTROL C WHERE C.EMPLID = A.EMPLID AND C.INSTITUTION = A.INSTITUTION AND C.AID_YEAR = A.AID_YEAR AND C.EFFDT = A.EFFDT)
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 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 |
ISIR_TXN_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Transaction Num
|
| 5 |
ORIG_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Original SSN
|
| 6 |
NAME_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Name Code
|
| 7 |
LAST_NAME_SSN_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Name-SSN Change Flag
|
| 8 |
SS_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Selective Service Match
I=Institutional Override
L=Record Returned Late
N=Regist Status Not Confirmed
T=Temporarily Exempt
Y=Registration Status Confirmed
Z=Record Mismatch
|
| 9 |
SS_REGISTRATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Selective Service Registration
I=Institutional Override
L=Record Returned Late
N=Registration not completed
T=Temporarily Exempt
Y=Registration Confirmed
Z=Record Mismatch
|
| 10 |
INS_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
INS Match
D=Duplicate case
I=Invalid ARN
L=Record Returned Late
N=Citizenship Not Confirmed
Y=Citizenship Confirmed
Z=Record Mismatch
|
| 11 |
SSN_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
SSN Match
0=Record Returned Late
1=No Match
2=SSN and Name, no DOB
3=SSN Only, No Name
4=SSN, Name, and DOB Match
5=All match Date of Death
6=SSN not verified
8=Record Not Sent to SSA
9=Record Mismatch
I=Institutional Override
|
| 12 |
SFA_VER_DT_APP |
Date(10) |
DATE |
Date Application Received
|
| 13 |
PELL_ELIGIBILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal PELL Eligibility
Y=Yes
|
| 14 |
ASSIGNED_PIN |
Number(4,0) |
SMALLINT NOT NULL |
Unique Nbr Assigned to Student
|
| 15 |
DUPLICATE_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Request Indicator
|
| 16 |
SAR_C_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates When 'C' Printed SAR
Y=SAR C Flag Set
|
| 17 |
MDE_EDE_SITE_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
MDE/EDE Site Code
1=Site 1
2=Site 2
|
| 18 |
MDE_SITE_NBR |
Character(1) |
VARCHAR2(1) NOT NULL |
MDE Site Nbr
|
| 19 |
VERF_SELECTION_IND |
Character(2) |
VARCHAR2(2) NOT NULL |
Verification Selection Ind
*=Subsequent Trans Select
N=Not Selected
Y=Selected
|
| 20 |
HOLD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Indicator. Enables user to indicate whether a transaction should be kept from processing (until the indicator is turned "OFF" again)
A=On Hold Drug Abuse
C=On Hold
D=On Hold
F=On Hold
G=On Hold Drug Abuse
H=On Hold
J=On Hold Drug Abuse
M=On Hold
N=On Hold SSS
S=Selected for Verf, Hold Rlsd
U=Selected for Verf, Hold Rlsd
Y=Removed SSS Hold
|
| 21 |
SYSTEM_GENERATED |
Character(1) |
VARCHAR2(1) NOT NULL |
System Generated Indicator
A=Release from Drug Enf Hold
D=Duplicate Request
H=Applcation Released from Hold
I=INS Secondary Confirmation
L=Dup Req, Match data changed
N=NSLDS post-screening transact
P=Dup Req/Prison Match Change
R=Rematched Transaction
S=Dup SSN and no activity
Z=Reprocessed Transaction
|
| 22 |
TRANS_RECEIPT_DT |
Date(10) |
DATE |
Transaction Receipt Date
|
| 23 |
TRANS_PROCESS_DT |
Date(10) |
DATE |
Transaction Process Date
|
| 24 |
CPS_REPROCESS_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Reprocess Code
A=Rls From Drug Enforcement Hold
D=Duplicate Request
H=Application Released from Hold
L=NSLDS History Correction
R=Rematched Transaction
S=Duplicate SSN
Z=Reprocessed Transaction
|
| 25 |
APP_SOURCE_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Source Code
0=Need Access
0=Need Access
1=Electronic Initial Application
2=Electronic Renewal Aplication
3=Electronic Correction
4=FAFSA Express
5=ACT
6=I-NET
7=NCS
8=Profile
9=Institutional Application
O=FT Canada Student Loan
P=PT Canada Student Loan
|
| 26 |
APP_SOURCE_SITE |
Character(1) |
VARCHAR2(1) NOT NULL |
Appl Source Site Code
1=Site 1
2=Site 2
|
| 27 |
BATCH_NUMBER |
Character(23) |
VARCHAR2(23) NOT NULL |
CPS Batch Number
|
| 28 |
SFA_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type.
0=EDE Initial Application
1=Paper Application
2=EDE Correction
3=EDE Duplicate Request
5=EDE Renewal App
|
| 29 |
ELEC_INSTITUT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Institution Ind
0=Federal School Code #10
1=Federal School Code #1
2=Federal School Code #2
3=Federal School Code #3
4=Federal School Code #4
5=Federal School Code #5
6=Federal School Code #6
7=Federal School Code #7
8=Federal School Code #8
9=Federal School Code #9
|
| 30 |
VERIFCATION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Verfication Type
|
| 31 |
CORRECTION_APPLIED |
Character(2) |
VARCHAR2(2) NOT NULL |
Correction Applied
|
| 32 |
FAA_INSTITUT_NUM |
Character(6) |
VARCHAR2(6) NOT NULL |
FAA Institution Nbr
|
| 33 |
INS_VERF_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
INS Verification Nbr
|
| 34 |
FULL_PARTIAL_ESAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Full or Partial ESAR Recvd
|
| 35 |
MULTI_INSTITUTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Multiple Institution Flags
|
| 36 |
SEND_ISAR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Send ISAR to Student
Default Value: Y
|
| 37 |
FINAL_REVIEW_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Review
N=No - Student Data Not Reviewed
Y=Yes - Student Data Reviewed
Default Value: N
|
| 38 |
DEPNDNCY_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependency Override Indicator
1=Dependent To Independent
2=Cancel Dep Override-Corr Only
3=Override Failed
4=Homeless Youth Determination
|
| 39 |
FAA_SIGNATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
FAA Signature
1=Signed
|
| 40 |
APPLICATION_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Status
1=Send Electronic Application
2=Pending
3=Application Sent
Default Value: 2
|
| 41 |
APP_STAT_DT |
Date(10) |
DATE |
Application Status Date
Default Value: %date
|
| 42 |
EFC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
EFC Status Indicator
O=Official
R=Rejected
U=Unofficial
Z=Provisional
Default Value: U
|
| 43 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 44 |
ADJ_EFC_CALC_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjusted EFC Calc Requested
1=Calc Adjustment Processed
2=Calc Adjustment Failed
|
| 45 |
ASSUMPTION_OVRRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Send Assumptions/Overrides
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 46 |
CORRECTION_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Correction Status
1=Correction(s) Pending
2=Send Correction(s)
3=Correction(s) Sent
4=Correction(s) Accepted
5=Corrections Rejected
6=Do Not Send Corrections
|
| 47 |
CORR_STAT_DT |
Date(10) |
DATE |
Correction Status Date
|
| 48 |
CORR_NAME |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Name Flag
Y/N Table Edit
|
| 49 |
CORR_ADDRESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Address Flag
Y/N Table Edit
|
| 50 |
CORR_SSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct SSN Flag
Y/N Table Edit
|
| 51 |
CORR_DOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Date of Birth Flag
Y/N Table Edit
|
| 52 |
CORR_PHONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Phone Flag
Y/N Table Edit
|
| 53 |
CORR_STATE_RES |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct State Residency Flag
Y/N Table Edit
|
| 54 |
CORR_STATE_RES_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct State Res Date Flag
Y/N Table Edit
|
| 55 |
CORR_LICENSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Drivers License Flag
Y/N Table Edit
|
| 56 |
CORR_LICENSE_STATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Driver Lic State Flag
Y/N Table Edit
|
| 57 |
CORR_CIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Citzenship Status Flag
Y/N Table Edit
|
| 58 |
CORR_ALIEN_REG_NUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Alien Reg Nbr
Y/N Table Edit
|
| 59 |
CORR_MARITAL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Marital Status Flag
Y/N Table Edit
|
| 60 |
CORR_MARITAL_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Marital Stat Date Flag
Y/N Table Edit
|
| 61 |
TITLEIV_ELIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Title IV Fund Eligibility
I=Institutional Override
Y/N Table Edit
Default Value: Y
|
| 62 |
ISIR_PRINT_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Print ISIR
Y/N Table Edit
|
| 63 |
ISIR_PRINT_DT |
Date(10) |
DATE |
ISIR Print Date
|
| 64 |
INST_PROCESS_DT |
Date(10) |
DATE |
Institution Process Date
|
| 65 |
ADJ_EFC |
Number(4,0) |
SMALLINT NOT NULL |
Unofficial Estimated EFC
|
| 66 |
SSA_CITIZENSHP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
SSA Citizenship Indicator
*=Foreign born
A=U.S. Citizen
B=Legal Alien, work eligible
C=Legal Alien, work ineligible
D=Other
E=Alien/student restrc/wk elig
F=Alien, conditionally legal
I=Institutional Override
N=No Match on Name or DOB
|
| 67 |
ISIR_SERIAL_NUM |
Number(5,0) |
INTEGER NOT NULL |
Serial Nbr
|
| 68 |
OWNING_SCHOOL_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Owning School Cd
Prompt Table:
INST_SCHOOL_CDS
|
| 69 |
SEND_VERIFY_FIELDS |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Verify Fields
Y/N Table Edit
Default Value: N
|
| 70 |
NSLDS_TXN_NBR |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Transaction Nbr
|
| 71 |
INAS_RFC_CALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc EFC via Remote Call
N=No
Y=Yes
|
| 72 |
EARLY_ANALYSIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Early Analysis Flag
|
| 73 |
ELECTRONIC_APP_VER |
Character(6) |
VARCHAR2(6) NOT NULL |
Electronic App Version No
|
| 74 |
ETI_DEST_CD |
Character(7) |
VARCHAR2(7) NOT NULL |
ETI Destination Code
|
| 75 |
ISIR_REC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ISIR Record Code
C=Correction Application
D=Duplicate Request
H=Correction
Q=EDE Quick Correction
R=Renewal FAFSA Web or Paper
S=Web Signatures
V=EDE Verification Corrections
|
| 76 |
SIMP_NEED_TEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Simplified Need Test
|
| 77 |
SSN_DATE_OF_DEATH |
Date(10) |
DATE |
SSN Date of Death
|
| 78 |
SUB_APP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Subsequent Application Flag
|
| 79 |
COMPUTE_BTCH_NO |
Character(3) |
VARCHAR2(3) NOT NULL |
Compute Batch Number
|
| 80 |
DUP_PROC_DT |
Date(10) |
DATE |
Process Date of Dup Rqst
|
| 81 |
VA_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Veteran Status Match Flag
1=Veteran status confirmed
2=Record found on VA db not Qual
3=Record not found on VA db
4=Active Duty
8=Record not sent to VA
|
| 82 |
PRISONER_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Prisoner Match
0=Not sent to SSA/Not a Prisoner
1=Prisoner in Local Facility
2=In State or Federal Facility
8=Not sent for match
I=Institutional Override
|
| 83 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 84 |
PROCESS_DT |
Date(10) |
DATE |
Process Date
|
| 85 |
APP_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
CPS Appl Source Site Cd
|
| 86 |
TRANS_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Data Source
|
| 87 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Prompt Table:
ADDRESSES_EFFVW
|
| 88 |
OVRD_ADDR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Address Type
Y/N Table Edit
Default Value: N
|
| 89 |
PREP_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Preparers SSN
|
| 90 |
PREP_SIGNATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Preparers Signature
1=Yes
X=Blank
|
| 91 |
PREP_EIN |
Character(9) |
VARCHAR2(9) NOT NULL |
Preparers EIN
|
| 92 |
ISIR_CORR_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Correction Source
A=Applicant
D=CPS
S=School
|
| 93 |
ISIR_EFC_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
EFC Change Flag
1=EFC Increase
2=EFC Decrease
|
| 94 |
ISIR_SEC_INS_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Sec INS Match Flag
C=Not yet confirmed by INS
N=Citizenship Not Confirmed
P=Pending Confirmation
X=Not enough info to confirm
Y=Citizenship Confirmed
|
| 95 |
ISIR_SEC_INS_VERF |
Character(15) |
VARCHAR2(15) NOT NULL |
Sec INS Verification Number
|
| 96 |
ISIR_DUP_SSN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate SSN Code
Y/N Table Edit
|
| 97 |
CORR_EMAIL_ADDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Email Address
Y/N Table Edit
|
| 98 |
ISIR_ORIG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Original ISIR
Y/N Table Edit
Default Value: Y
|
| 99 |
VERIF_TRK_FLG |
Character(4) |
VARCHAR2(4) NOT NULL |
Verification Tracking Flag
V1=Standard Group
V2=FSA Use Only
V3=Child Support Group
V4=Custom Group
V5=Aggregate Group
V6=Household Resources Grp
|
| 100 |
EFC_OVRD_DSPLAY_FM |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag that triggers the display of EFC Override labels.
Y/N Table Edit
Default Value: N
|
| 101 |
ISIR_CPS_PUSHED |
Character(1) |
VARCHAR2(1) NOT NULL |
CPS Pushed ISIR Flag
|
| 102 |
ISIR_SAR_C_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
ISIR SAR C Flag Changed
Y=FPS C Flag Has Changed
|
| 103 |
FATHER_SSN_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Father's SSN Match
1=No Match
2=SSN and Name, no DOB
3=SSN Only, No Name
4=SSN, Name, and DOB Match
5=All match Date of Death
6=SSN not verified
8=Record Not Sent to SSA
I=Institutional Override
|
| 104 |
MOTHER_SSN_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Mother's SSN Match
1=No Match
2=SSN and Name, no DOB
3=SSN Only, No Name
4=SSN, Name, and DOB Match
5=All match Date of Death
6=SSN not verified
8=Record Not Sent to SSA
I=Institutional Override
|
| 105 |
SFA_VF_SEL_CHG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Verification Select Chng Flag
C=Change in Verif Tracking Grp
Y=VF SEL C Flag Has Changed
|
| 106 |
SFA_REJ_ST_CHG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rejected Status Change Flag
1=REJ ST C Flag Has Changed
|
| 107 |
ISIR_OVRD_E_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Email Type
Y/N Table Edit
Default Value: N
|
| 108 |
ISIR_OVRD_P_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Phone Type
Y/N Table Edit
Default Value: N
|
| 109 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
Prompt Table:
ISIR_PTYPE_VW
|
| 110 |
E_ADDR_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Email Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
Prompt Table:
ISIR_ETYPE_VW
|
| 111 |
SFA_SPL_CIRCUM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Circumstances Flag
1=Dep w/o Parent Data
2=Parent Data Corrected
3=Unaccompanied Homeless
4=Dep Unsub Loan Only
|
| 112 |
SFA_DOD_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Dept of Defense Match
Y=SSN included in DOD file
|
| 113 |
SFA_DOD_PARENT |
Date(10) |
DATE |
DOD Parent Date of Death
|
| 114 |
SFA_STU_IRS_REQUST |
Character(2) |
VARCHAR2(2) NOT NULL |
Student IRS Request
00=Ineligible
01=Used and Not Transferred
02=Transferred and Not Changed
03=Transferred and Changed
04=Transferred and Corrected
05=Eligible and Not Used
06=Eligible to Not Eligible
07=Transferred but Amended
B=Not Available
|
| 115 |
SFA_PAR_IRS_REQUST |
Character(2) |
VARCHAR2(2) NOT NULL |
Parent IRS Request
00=Ineligible
01=Used and Not Transferred
02=Transferred and Not Changed
03=Transferred and Changed
04=Transferred and Corrected
05=Eligible and Not Used
06=Eligible to Not Eligible
07=Transferred but Amended
B=Not Available
|
| 116 |
SFA_HIGH_SCHL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
High School Flag
Y=High School not found
|
| 117 |
SFA_STU_IRS_AGI |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS AGI Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
|
| 118 |
SFA_STU_IRS_FIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS FIT Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
|
| 119 |
SFA_PAR_IRS_AGI |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS AGI Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
|
| 120 |
SFA_PAR_IRS_FIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS FIT Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
|
| 121 |
SFA_STU_IRS_TAXRET |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Return Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 122 |
SFA_STU_IRS_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Exemption Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 123 |
SFA_STU_IRS_EDCRDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS ED Credits Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 124 |
SFA_STU_IRS_IRAPAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS IRA Payment Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 125 |
SFA_STU_IRS_INTRST |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Interest Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 126 |
SFA_STU_IRS_IRADIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS IRA Dist Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 127 |
SFA_STU_IRS_UNTAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Pension Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 128 |
SFA_STU_IRS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Filing Status Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 129 |
SFA_PAR_IRS_TAXRET |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Return Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 130 |
SFA_PAR_IRS_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Exemption Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 131 |
SFA_PAR_IRS_EDCRDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS ED Credits Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 132 |
SFA_PAR_IRS_IRAPAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS IRA Payment Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 133 |
SFA_PAR_IRS_INTRST |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Interest Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 134 |
SFA_PAR_IRS_IRADIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS IRA Dist Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 135 |
SFA_PAR_IRS_UNTAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Pension Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 136 |
SFA_PAR_IRS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Filing Status Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 137 |
SFA_CFH_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Children of Fallen Heroes
1=Yes
2=No
|
| 138 |
SFA_STU_IRS_SCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Schedule 1 Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 139 |
SFA_PAR_IRS_SCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Schedule 1 Data
0=Not Transferred
1=Transferred and Not Changed
2=Transferred and Changed
3=Transferred and Corrected
4=Transferred and Previous Corr
B=IRS DRT not used
|
| 140 |
SFA_INCAR_APP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Added new field for 2324
1=Corr Facility Address File
2=Received via PO Box at IDC
3=Incarcerated App Flag Set
4=Incarcerated App Flag Removed
|