| # |
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 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 6 |
ISIR_TXN_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Transaction Num
|
| 7 |
ORIG_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Original SSN
|
| 8 |
NAME_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Name Code
|
| 9 |
LAST_NAME_SSN_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Name-SSN Change Flag
|
| 10 |
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
|
| 11 |
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
|
| 12 |
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
|
| 13 |
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
|
| 14 |
DT_APP_RECEIVED |
Date(10) |
DATE |
Date Application Received
Default Value: %date
|
| 15 |
PELL_ELIGIBILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal PELL Eligibility
Y=Yes
|
| 16 |
ASSIGNED_PIN |
Number(4,0) |
SMALLINT NOT NULL |
Unique Nbr Assigned to Student
|
| 17 |
DUPLICATE_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Request Indicator
|
| 18 |
SAR_C_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates When 'C' Printed SAR
Y=SAR C Flag Set
|
| 19 |
MDE_EDE_SITE_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
MDE/EDE Site Code
1=Site 1
2=Site 2
|
| 20 |
MDE_SITE_NBR |
Character(1) |
VARCHAR2(1) NOT NULL |
MDE Site Nbr
|
| 21 |
VERF_SELECTION_IND |
Character(2) |
VARCHAR2(2) NOT NULL |
Verification Selection Ind
*=Subsequent Trans Select
N=Not Selected
Y=Selected
|
| 22 |
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
|
| 23 |
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
|
| 24 |
TRANS_RECEIPT_DT |
Date(10) |
DATE |
Transaction Receipt Date
|
| 25 |
TRANS_PROCESS_DT |
Date(10) |
DATE |
Transaction Process Date
|
| 26 |
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
|
| 27 |
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
|
| 28 |
APP_SOURCE_SITE |
Character(1) |
VARCHAR2(1) NOT NULL |
Appl Source Site Code
1=Site 1
2=Site 2
|
| 29 |
BATCH_NUMBER |
Character(23) |
VARCHAR2(23) NOT NULL |
CPS Batch Number
|
| 30 |
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
|
| 31 |
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
|
| 32 |
VERIFCATION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Verfication Type
|
| 33 |
CORRECTION_APPLIED |
Character(2) |
VARCHAR2(2) NOT NULL |
Correction Applied
|
| 34 |
FAA_INSTITUT_NUM |
Character(6) |
VARCHAR2(6) NOT NULL |
FAA Institution Nbr
|
| 35 |
INS_VERF_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
INS Verification Nbr
|
| 36 |
FULL_PARTIAL_ESAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Full or Partial ESAR Recvd
|
| 37 |
MULTI_INSTITUTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Multiple Institution Flags
|
| 38 |
SEND_ISAR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Send ISAR to Student
Default Value: Y
|
| 39 |
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
|
| 40 |
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
|
| 41 |
FAA_SIGNATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
FAA Signature
1=Signed
|
| 42 |
APPLICATION_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Status
1=Send Electronic Application
2=Pending
3=Application Sent
Default Value: 2
|
| 43 |
APP_STAT_DT |
Date(10) |
DATE |
Application Status Date
Default Value: %date
|
| 44 |
EFC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
EFC Status Indicator
O=Official
R=Rejected
U=Unofficial
Z=Provisional
Default Value: U
|
| 45 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 46 |
ADJ_EFC_CALC_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjusted EFC Calc Requested
1=Calc Adjustment Processed
2=Calc Adjustment Failed
|
| 47 |
ASSUMPTION_OVRRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Send Assumptions/Overrides
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 48 |
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
|
| 49 |
CORR_STAT_DT |
Date(10) |
DATE |
Correction Status Date
|
| 50 |
CORR_NAME |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Name Flag
Y/N Table Edit
|
| 51 |
CORR_ADDRESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Address Flag
Y/N Table Edit
|
| 52 |
CORR_SSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct SSN Flag
Y/N Table Edit
|
| 53 |
CORR_DOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Date of Birth Flag
Y/N Table Edit
|
| 54 |
CORR_PHONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Phone Flag
Y/N Table Edit
|
| 55 |
CORR_STATE_RES |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct State Residency Flag
Y/N Table Edit
|
| 56 |
CORR_STATE_RES_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct State Res Date Flag
Y/N Table Edit
|
| 57 |
CORR_LICENSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Drivers License Flag
Y/N Table Edit
|
| 58 |
CORR_LICENSE_STATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Driver Lic State Flag
Y/N Table Edit
|
| 59 |
CORR_CIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Citzenship Status Flag
Y/N Table Edit
|
| 60 |
CORR_ALIEN_REG_NUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Alien Reg Nbr
Y/N Table Edit
|
| 61 |
CORR_MARITAL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Marital Status Flag
Y/N Table Edit
|
| 62 |
CORR_MARITAL_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Marital Stat Date Flag
Y/N Table Edit
|
| 63 |
TITLEIV_ELIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Title IV Fund Eligibility
I=Institutional Override
Y/N Table Edit
Default Value: Y
|
| 64 |
ISIR_PRINT_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Print ISIR
Y/N Table Edit
|
| 65 |
ISIR_PRINT_DT |
Date(10) |
DATE |
ISIR Print Date
|
| 66 |
INST_PROCESS_DT |
Date(10) |
DATE |
Institution Process Date
|
| 67 |
ADJ_EFC |
Number(4,0) |
SMALLINT NOT NULL |
Unofficial Estimated EFC
|
| 68 |
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
|
| 69 |
ISIR_SERIAL_NUM |
Number(5,0) |
INTEGER NOT NULL |
Serial Nbr
|
| 70 |
OWNING_SCHOOL_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Owning School Cd
Prompt Table:
INST_SCHOOL_CDS
|
| 71 |
SEND_VERIFY_FIELDS |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Verify Fields
Y/N Table Edit
Default Value: N
|
| 72 |
NSLDS_TXN_NBR |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Transaction Nbr
|
| 73 |
INAS_RFC_CALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc EFC via Remote Call
N=No
Y=Yes
|
| 74 |
EARLY_ANALYSIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Early Analysis Flag
|
| 75 |
ELECTRONIC_APP_VER |
Character(6) |
VARCHAR2(6) NOT NULL |
Electronic App Version No
|
| 76 |
ETI_DEST_CD |
Character(7) |
VARCHAR2(7) NOT NULL |
ETI Destination Code
|
| 77 |
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
|
| 78 |
SIMP_NEED_TEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Simplified Need Test
|
| 79 |
SSN_DATE_OF_DEATH |
Date(10) |
DATE |
SSN Date of Death
|
| 80 |
SUB_APP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Subsequent Application Flag
|
| 81 |
COMPUTE_BTCH_NO |
Character(3) |
VARCHAR2(3) NOT NULL |
Compute Batch Number
|
| 82 |
DUP_PROC_DT |
Date(10) |
DATE |
Process Date of Dup Rqst
|
| 83 |
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
|
| 84 |
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
|
| 85 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 86 |
PROCESS_DT |
Date(10) |
DATE |
Process Date
|
| 87 |
APP_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
CPS Appl Source Site Cd
|
| 88 |
TRANS_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Data Source
|
| 89 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Prompt Table:
ADDRESSES_EFFVW
|
| 90 |
OVRD_ADDR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Address Type
Y/N Table Edit
Default Value: N
|
| 91 |
PREP_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Preparers SSN
|
| 92 |
PREP_SIGNATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Preparers Signature
1=Yes
X=Blank
|
| 93 |
PREP_EIN |
Character(9) |
VARCHAR2(9) NOT NULL |
Preparers EIN
|
| 94 |
ISIR_CORR_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Correction Source
A=Applicant
D=CPS
S=School
|
| 95 |
ISIR_EFC_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
EFC Change Flag
1=EFC Increase
2=EFC Decrease
|
| 96 |
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
|
| 97 |
ISIR_SEC_INS_VERF |
Character(15) |
VARCHAR2(15) NOT NULL |
Sec INS Verification Number
|
| 98 |
ISIR_DUP_SSN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate SSN Code
Y/N Table Edit
|
| 99 |
CORR_EMAIL_ADDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Correct Email Address
Y/N Table Edit
|
| 100 |
ISIR_ORIG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Original ISIR
Y/N Table Edit
Default Value: Y
|
| 101 |
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
|
| 102 |
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
|
| 103 |
ISIR_CPS_PUSHED |
Character(1) |
VARCHAR2(1) NOT NULL |
CPS Pushed ISIR Flag
|
| 104 |
ISIR_SAR_C_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
ISIR SAR C Flag Changed
Y=FPS C Flag Has Changed
|
| 105 |
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
|
| 106 |
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
|
| 107 |
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
|
| 108 |
SFA_REJ_ST_CHG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rejected Status Change Flag
1=REJ ST C Flag Has Changed
|
| 109 |
ISIR_OVRD_E_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Email Type
Y/N Table Edit
Default Value: N
|
| 110 |
ISIR_OVRD_P_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Phone Type
Y/N Table Edit
Default Value: N
|
| 111 |
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
|
| 112 |
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
|
| 113 |
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
|
| 114 |
SFA_DOD_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Dept of Defense Match
Y=SSN included in DOD file
|
| 115 |
SFA_DOD_PARENT |
Date(10) |
DATE |
DOD Parent Date of Death
|
| 116 |
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
|
| 117 |
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
|
| 118 |
SFA_HIGH_SCHL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
High School Flag
Y=High School not found
|
| 119 |
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
|
| 120 |
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
|
| 121 |
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
|
| 122 |
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
|
| 123 |
SFA_STU_IRS_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IRS Display
A=No DRT - Skipped Income/Asset
B=DRT was displayed to student
C=No DRT - Tax Return Status
D=No DRT - Marital Status Date
E=No DRT - SSN Starts with '666'
H=No DRT - Amended Tax Return
J=No DRT - Foreign Tax Return
K=No DRT - Married Filed Separat
L=No DRT - Married Filed Head
M=No DRT - Marital/Filing Cnflct
Z=Not Available
|
| 124 |
SFA_PAR_IRS_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IRS Display
A=No DRT - Special Circumstances
B=DRT was displayed to parent
C=No DRT - Tax Return Status
D=No DRT - Marital Status Date
E=No DRT - SSN Starts with '666'
F=No DRT - SSN All Zeroes
G=No DRT - SSN Invalid
H=No DRT - Amended Tax Return
J=No DRT - Foreign Tax Return
K=No DRT - Married Filed Separat
L=No DRT - Married Filed Head
M=No DRT - Marital/Filing Cnflct
N=No DRT - Unmarried
Z=Not Available
|
| 125 |
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
|
| 126 |
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
|
| 127 |
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
|
| 128 |
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
|
| 129 |
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
|
| 130 |
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
|
| 131 |
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
|
| 132 |
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
|
| 133 |
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
|
| 134 |
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
|
| 135 |
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
|
| 136 |
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
|
| 137 |
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
|
| 138 |
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
|
| 139 |
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
|
| 140 |
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
|
| 141 |
SFA_CFH_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Children of Fallen Heroes
1=Yes
2=No
|