| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
STDNT_AID_SRCH
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 3 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
STUDENT_AID
|
| 4 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
|
| 5 |
LOAN_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Loan Type Cd
Prompt Table:
LN_TYPE_TBL
|
| 6 |
LN_APPL_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Loan Application Seq Num
|
| 7 |
BORR_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Borrower ID
Prompt Table:
LN_BOR_RELAT_VW
|
| 8 |
FED_OR_INST_COST |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal or Institutional Cost
F=Federal Cost
I=Institutional Cost
Default Value: LN_TYPE_TBL.FED_OR_INST_COST
|
| 9 |
FED_EFC |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Federal EFC
|
| 10 |
INST_EFC |
Number(6,0) |
INTEGER NOT NULL |
Institutional EFC
|
| 11 |
FED_YEAR_COA |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Fed Year COA
|
| 12 |
INST_YEAR_COA |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Inst Year COA
|
| 13 |
LN_FIN_AID |
Number(6,0) |
INTEGER NOT NULL |
Loan Financial Aid
|
| 14 |
LN_NET_COST |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Loan Net Cost
|
| 15 |
NSLDS_LOAN_YEAR |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan Year
0=1st Year - Never Attended
1=1st Year - Previously Attended
2=2nd Year
3=3rd Year
4=4th Year
5=5th Year+
A=1st Year Graduate
B=2nd Year Graduate
C=3rd Year Graduate
D=4th or more Graduate
G=Graduate/Professional
|
| 16 |
DIR_LND_YR |
Character(2) |
VARCHAR2(2) NOT NULL |
Direct Lending Year
01=First Year,never attended
02=First Year,previously attnd
03=Second Year
04=Third Year
05=Fourth Year
06=Fifth Year+ Undergrad
07=First Yr, Grad/Prof
08=Second Yr, Grad/Prof
09=Third Yr, Grad/Prof
10=Fourth Yr+,Grad/Prof
|
| 17 |
ACADEMIC_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level
00=Not Set
01=First Year
02=Second Year
03=Third Year
04=Fourth Year
05=Fifth Year
06=Sixth Year
10=Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GR=Graduate
GRA=Graduate AUS
HON=Honours
IE=Industrial Experience
MAS=Masters
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PHD=PhD
|
| 18 |
LN_DEST_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Loan Destination Num
Prompt Table:
LN_DESTPROF_TBL
|
| 19 |
LEND_UNQ_ID |
Number(3,0) |
SMALLINT NOT NULL |
Lender ID
Prompt Table:
LENDER_TBL
|
| 20 |
GUAR_UNQ_ID |
Number(3,0) |
SMALLINT NOT NULL |
Guarantor ID
Prompt Table:
GUARANTOR_TBL
|
| 21 |
GUAR_LN_ID |
Character(23) |
VARCHAR2(23) NOT NULL |
Guarantor Loan ID
|
| 22 |
LN_EFT_AUTHRZTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan EFT Authorization
N=No
Y=Yes
|
| 23 |
LN_REQ_DEFRMNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Loan Deferment
N=No
Y=Yes
|
| 24 |
CAPTLZ_INTRST |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalize Interest Cd
N=Capitalize while in school
Y=Pay interest while in school
|
| 25 |
LN_AMT_BORRQSTD |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Borrower Requested Amount
|
| 26 |
LN_PNT_BORRQSTD |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
PNote Borr Requested Amount
|
| 27 |
LN_TOTAL_CERT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Total Certified Loan Amt
|
| 28 |
LN_CERT_DT |
Date(10) |
DATE |
Loan Certification Date
Default Value: %date
|
| 29 |
LNDR_LAST_RSRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Lender of Last Resort
Y/N Table Edit
Default Value: N
|
| 30 |
LOAN_CREDIT_CHK |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Credit Eligibility
A=Credit Approved
D=Credit Denied
X=Credit Pending
|
| 31 |
LOAN_CRDT_OVRID |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Decision Override
C=C O New Info
D=Credit Denied
E=C O Endorser OK
L=Lower Endorser Amount
N=Denied after Pending
X=Credit Pending
|
| 32 |
LOAN_CRDT_DT |
Date(10) |
DATE |
Loan Credit Decision Dt
|
| 33 |
SCH_LNAPPL_ID |
Character(23) |
VARCHAR2(23) NOT NULL |
School Loan Appl ID
|
| 34 |
ACADEMIC_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Academic Load
F=Enrolled Full-Time
H=Enrolled Half-Time
L=Less than Half-Time
N=No Unit Load
P=Enrolled Part-Time
T=Three Quarter Time
|
| 35 |
LN_PRGCMPLT_DT |
Date(10) |
DATE |
Program Completion Dt
|
| 36 |
EXP_GRAD_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Expected Graduation Term
|
| 37 |
LN_PERIOD_START |
Date(10) |
DATE |
Loan Period Start
|
| 38 |
LN_PERIOD_END |
Date(10) |
DATE |
Loan Period End
|
| 39 |
LN_PERIOD_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Loan Period
Y/N Table Edit
|
| 40 |
LN_UPDT_DMGRPHC |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Loan Demographic
Y/N Table Edit
Default Value: N
|
| 41 |
LOAN_AMT_COSIGN |
Number(5,0) |
INTEGER NOT NULL |
Cosigner Required Amt
|
| 42 |
LN_ORIG_MANUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Manual Origination Ind
Y/N Table Edit
Default Value: N
|
| 43 |
LN_REFUND_INDC |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Refund Indicator
B=Borrower
S=Student
Default Value: S
|
| 44 |
LN_BORR_DFLT_RFND |
Character(1) |
VARCHAR2(1) NOT NULL |
Borr Default / Owes Refund
N=No
Y=Yes
Z=Overridden by School
|
| 45 |
LN_STDNT_DFLT_RFND |
Character(1) |
VARCHAR2(1) NOT NULL |
Stdnt Default / Owes Refund
N=No
Y=Yes
Z=Overridden by School
|
| 46 |
LN_TOT_LOAN_DEBT |
Number(7,0) |
INTEGER NOT NULL |
Total Student Loan Debt
|
| 47 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 48 |
BORR_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Borrower SSN
|
| 49 |
LN_BORR_SSN_CHGDT |
Date(10) |
DATE |
Borrower SSN Change Date
|
| 50 |
DRIVERS_LIC_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Driver's License #
Prompt Table:
LN_DRVR_LIC_VW
|
| 51 |
BORR_DRIVER_LIC_ST |
Character(6) |
VARCHAR2(6) NOT NULL |
Borrower Drivers license State
Default Value: LN_DRVR_LIC_VW.STATE
Prompt Table:
SFA_DRVR_LIC_VW
|
| 52 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 53 |
BORR_BIRTHDATE |
Date(10) |
DATE |
Borrower Date of Birth
|
| 54 |
LN_BORR_DOB_CHGDT |
Date(10) |
DATE |
Borrower DOB Change Date
|
| 55 |
VISA_WRKPMT_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Visa/Permit Number
|
| 56 |
BORR_VISA_WKPT_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Borrower Visa/Permit Nbr
|
| 57 |
CITIZENSHIP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Citizenship Status
Prompt Table:
SFA_LN_STU_CIT
|
| 58 |
BORR_CTZNSHP_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Borrower Citizenship Stat
1=Native
2=Naturalized
3=Alien Permanent
4=Alien Temporary
5=Permanent Resident
N=Not Indicated
Prompt Table:
%EDITTABLE2
|
| 59 |
LN_PRINT_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Loan Print Option
F=School Prints
R=Dest Prints(return to School)
S=Dest Prints(send to Borr)
V=Dest Reprints,sends to School
Z=Dest Reprint
|
| 60 |
DL_DISC_PRT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
DL Disclosure Print
N=School Prints Disclosure
Y=LOC Prints Disclosure
Z=COD Reprint Requested
|
| 61 |
INST_DEPEND_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Depend Stat (Inst)
D=Dependent
I=Independent
M=Married
S=Sole Support
|
| 62 |
FED_DEPEND_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Depend Stat (Fed)
D=Dependent
I=Independent
M=Married
S=Sole Support
Prompt Table:
%EDITTABLE
|
| 63 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 64 |
LN_DEST_PROC_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Loan Dest Processing Level
CR=School Cert Request
D=Direct
GO=Guarantee Only
GP=Guarantee and Print Appl
M=Manual
PG=Print and Guarantee
PO=Print Loan Application Only
|
| 65 |
LN_BOOK_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Lending Booked Status
A=Booked
R=Unbooked
|
| 66 |
LN_BOOK_DT |
Date(10) |
DATE |
DL Book Date
|
| 67 |
DL_ADD_USUB_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Unsub Eligibility
Y/N Table Edit
|
| 68 |
DL_HEAL_LN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
HEAL Eligible
Y/N Table Edit
|
| 69 |
LN_VERSION |
Character(10) |
VARCHAR2(10) NOT NULL |
CommonLine Loan Version
|
| 70 |
LN_RPT_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Loan Report Form ID
|
| 71 |
PNOTE_PRINT_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Promissory Note Print Seq
|
| 72 |
LN_MPN_SEQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Loan MPN Sequence
|
| 73 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 74 |
LN_PHONE_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Phone #
Y/N Table Edit
|
| 75 |
LN_TRNS_PER_ST |
Date(10) |
DATE |
Transmitted Loan Period Start
|
| 76 |
LN_TRNS_PER_END |
Date(10) |
DATE |
Transmitted Loan Period End
|
| 77 |
LN_TRNS_DEP_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Depend Stat (Fed)
D=Dependent
I=Independent
M=Married
S=Sole Support
|
| 78 |
LN_TRNS_HEAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
HEAL Eligible
Y/N Table Edit
|
| 79 |
LN_TRNS_USUB_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Unsub Eligibility
Y/N Table Edit
|
| 80 |
LN_TRNS_DIR_YR |
Character(2) |
VARCHAR2(2) NOT NULL |
Direct Lending Year
01=First Year, never attended
02=First Year,previously attnd
03=Second Year
04=Third Year
05=Fourth Year
06=Fifth Year+ Undergrad
07=First Yr, Grad/Prof
08=Second Yr, Grad/Prof
09=Third Yr, Grad/Prof
10=Fourth Yr+,Grad/Prof
|
| 81 |
LN_TRNS_NSLDS_YEAR |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan Year
0=1st Year - Never Attended
1=1st Year - Previously Attended
2=2nd Year
3=3rd Year
4=4th Year
5=5th Year+
A=1st Year Graduate
B=2nd Year Graduate
C=3rd Year Graduate
D=4th or more Graduate
G=Graduate/Professional
|
| 82 |
LN_TRNS_PRGCMPLT |
Date(10) |
DATE |
Transmitted Prg Complete Dt
|
| 83 |
LN_TRNS_BORR_CIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Ack Borr Citizenship Status
1=Native
2=Naturalized
3=Alien Permanent
4=Alien Temporary
N=Not Indicated
|
| 84 |
LN_TRNS_BORR_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Ack Borr Default / Owes Refund
N=No
Y=Yes
Z=Overridden by School
|
| 85 |
LN_TRNS_BORR_DOB |
Date(10) |
DATE |
Acknowledged Borrower DOB
|
| 86 |
LN_TRNS_BORR_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Acknowledged Borrower SSN
|
| 87 |
LN_TRNS_BORR_VISA |
Character(15) |
VARCHAR2(15) NOT NULL |
Ack Borr Visa/Permit Number
|
| 88 |
LN_TRNS_DRIVER_LIC |
Character(20) |
VARCHAR2(20) NOT NULL |
Ack Driver's License #
|
| 89 |
LN_TRNS_DRIVER_ST |
Character(6) |
VARCHAR2(6) NOT NULL |
Ack Borr Drivers license State
|
| 90 |
LN_TRNS_STU_CIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Ack Student Citizenship Status
1=Native
2=Naturalized
3=Alien Permanent
4=Alien Temporary
N=Not Indicated
|
| 91 |
LN_TRNS_STU_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Ack Stdnt Default / Owes Ref
N=No
Y=Yes
Z=Overridden by School
|
| 92 |
LN_TRNS_STU_DOB |
Date(10) |
DATE |
Acknowledged Student DOB
|
| 93 |
LN_TRNS_STU_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Acknowledged Student SSN
|
| 94 |
LN_TRNS_STU_VISA |
Character(15) |
VARCHAR2(15) NOT NULL |
Ack Student Visa/Permit Number
|
| 95 |
LN_TRNS_PRNT_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Loan Print Option
F=School Prints
R=Dest Prints(return to School)
S=Dest Prints(send to Borr)
Z=Dest Reprint
|
| 96 |
LN_TRNS_DISC_PRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Ack DL Disclosure Print Ind
N=School Prints Disclosure
Y=LOC Prints Disclosure
|
| 97 |
LN_TRNS_DL_FEE |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
Ack DL Orig Fee Percentage
|
| 98 |
LN_TRNS_ACAD_ST |
Date(10) |
DATE |
Ack Academic Year Start Date
|
| 99 |
LN_TRNS_ACAD_END |
Date(10) |
DATE |
Ack Academic Year End Date
|
| 100 |
LN_TRNS_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 101 |
LN_TRNS_DOB_CHGDT |
Date(10) |
DATE |
Ack Borrower DOB Change Date
|
| 102 |
LN_TRNS_SSN_CHGDT |
Date(10) |
DATE |
Ack Borrower SSN Change Date
|
| 103 |
INTEREST_RATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest Rate Option - Alt Lns
|
| 104 |
REPAYMENT_OPT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Repayment Option Code - Alt
|
| 105 |
CL_ACT_INT_RATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Actual Interest Rate
|
| 106 |
CL_LNDR_USE |
Character(20) |
VARCHAR2(20) NOT NULL |
Lender Use Only
|
| 107 |
CL_SERIAL_LN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Code that indicates how the school will use the MPN. This is transmitted i the App Send file.
N=Use new MPN
S=Serial, Renew existing MPN
|
| 108 |
CL_MPN_CONFIRM_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Response file value that indicates whether a valid serial MPN was confirmed by the service provider.
N=No valid MPN exists
U=Unknown MPN status
Y=Yes, a valid MPN exists
|
| 109 |
CL_BORR_CONFIRM_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
A code indicating if the service provider has received borrower confirmation of the MPN loan request.
N=No borr confirm received
Y=Yes, SP received borr confirm
|
| 110 |
CL_DIFF_NAME_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Under Different Name Cd
|
| 111 |
CL_FED_APP_FRM_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal App Form Cd
B=Stafford Version 1/3/94
G=Graduate PLUS MPN
M=Stafford MPN
P=PLUS Version 4/25/94
Q=PLUS MPN
|
| 112 |
DL_ORIG_FEE |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
DL Origination Fee %
|
| 113 |
ACAD_YEAR_START |
Date(10) |
DATE |
Academic Year Start Date
|
| 114 |
ACAD_YEAR_END |
Date(10) |
DATE |
Academic Year End Date
|
| 115 |
LN_ORIG_PNOTE_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to accept MPN status from origination acknowledgements and determine whether an MPN exists for the origination record or whether an MPN should be created
A=Accepted
C=Closed
E=Endorser
I=Inactive
P=Print
Q=Rejected
R=Rejected (from MPN Ack)
X=Printed, Ack Pend
|
| 116 |
DL_PNOTE_ID |
Character(21) |
VARCHAR2(21) NOT NULL |
DL Pnote Unique ID
|
| 117 |
LN_FED_DEP_ST_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Dependency Status
Y/N Table Edit
|
| 118 |
LN_ACAD_END_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Academic Year End
Y/N Table Edit
|
| 119 |
LN_ACAD_ST_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Academic Year Start
Y/N Table Edit
|
| 120 |
LN_BORR_CIT_ST_OVR |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Borrower Citizenship
Y/N Table Edit
|
| 121 |
LN_BORR_VISA_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Borrower Alien Reg
Y/N Table Edit
|
| 122 |
LN_BORR_DOB_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Borrower BirthDate
Y/N Table Edit
|
| 123 |
LN_BORR_SSN_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Borrower SSN
Y/N Table Edit
|
| 124 |
LN_ENDORS_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Loan Endorser Amount
|
| 125 |
SFA_COD_MPN_EXPIRE |
Date(10) |
DATE |
DL Pnote Expire Date
|
| 126 |
SFA_PP_CRSEWRK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
PreProfessional Coursewrk
Y/N Table Edit
|
| 127 |
SFA_TRNS_PP_CRS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
PreProfessional Coursewrk
Y/N Table Edit
|
| 128 |
SFA_LN_STU_CIT_OVR |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Student Citizenship
Y/N Table Edit
|
| 129 |
SFA_ATB_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Ability To Benefit Code
01=01: Complete before 7/1/2012
02=02: College before 7/1/2012
03=03: State Process
04=04: Home Schooled
05=05: Other
06=06: High School Diploma
07=07: General Ed Development
08=08: State-Authorized exam/cert
09=09: Acad Transc min 2 YR Prog
10=10: Excelled in High School
11=11: Complete 7/1/12 - 6/30/15
12=12: Complete after 7/1/2012
13=13: College 7/1/12 - 6/30/15
14=14: College after 7/1/2012
15=15: CPT Program
|
| 130 |
SFA_TRNS_ATB_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Ability To Benefit Code
01=01: Testing Completed
02=02: College Credits
03=03: State Process
04=04: Home Schooled
05=05: Other
|
| 131 |
SFA_ATB_TST_ADM_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Ability to Benefit Test Adminitrator Code
01=01: Testing Center
02=02: Test Administrator
|
| 132 |
SFA_TRNS_ATB_TADMC |
Character(2) |
VARCHAR2(2) NOT NULL |
Ability to Benefit Test Adminitrator Code
01=01: Testing Center
02=02: Test Administrator
|
| 133 |
SFA_ATB_TST_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Ability To Benefit Test Code
01=01: ASSET Program
02=02: Career Program Assessment
03=03: COMBO English Lang Skills
04=04: Compass Subtests
05=05: COMP Placement Tests
06=06: Descriptive LANG Skills
07=07: ESL Placement Test
08=08: Wonderic Basic Skills Test
09=09: WorkKeys Program
10=10: Test of Adult Basic ED
11=11: Spanish Assessment
12=12: WBST - Spanish
13=13: TSI Assessment
|
| 134 |
SFA_TRNS_ATB_TSTCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Ability To Benefit Test Code
01=01: ASSET Program
02=02: Career Program Assessment
03=03: COMBO English Lang Skills
04=04: Compass Subtests
05=05: COMP Placement Tests
06=06: Descriptive LANG Skills
07=07: ESL Placement Test
08=08: Wonderic Basic Skills Test
09=09: WorkKeys Program
10=10: Test of Adult Basic ED
11=11: Spanish Assessment
|
| 135 |
SFA_ATB_STATE_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Ability to Benefit State Code
Prompt Table:
SFA_ISIRSTATEVW
|
| 136 |
SFA_TRNS_ATB_STCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Transmitted ATB State Code
|
| 137 |
SFA_ATB_COMP_DT |
Date(10) |
DATE |
Ability to Benefit Completion Date
|
| 138 |
SFA_TRNS_ATB_CMPDT |
Date(10) |
DATE |
Transmitted ATB Completion Dt
|
| 139 |
SFA_STU_SSN_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Stu SSN Overirde
Y/N Table Edit
Default Value: N
|
| 140 |
SFA_BORR_SSN_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Borr SSN Override
Y/N Table Edit
Default Value: N
|
| 141 |
SFA_PROG_LENGTH_MN |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Program Length Value
|
| 142 |
SFA_PROG_LENGTH_WK |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Program Length Value
|
| 143 |
SFA_PROG_LENGTH_YR |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Program Length Value
|
| 144 |
SFA_WK_PROG_ACADYR |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Program Length Value
|
| 145 |
SFA_SPEC_PROG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
SULA Special Programs Flag
A=Selective Admission Assoc Deg
B=2-year Bachelor's Degree
N=Not Applicable
P=Prep Crsewk Grad Prof Pgm
T=Non-Cred Teacher Cert Pgm
U=Prep Crsewk Ugrad Program
|
| 146 |
SFA_COD_CRED_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is Credential Level field for COD reporting.
01=Undergraduate diploma/cert
02=Associate's degree
03=Bachelor's degree
04=Post Baccalaureate certificate
05=Master's degree
06=Doctoral degree
07=First Professional degree
08=Graduate/Professional cert
99=Non-credential programs
|
| 147 |
SFA_TRNS_PROGLN_MN |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Program Length Value
|
| 148 |
SFA_TRNS_PROGLN_WK |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Program Length Value
|
| 149 |
SFA_TRNS_PROGLN_YR |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Program Length Value
|
| 150 |
SFA_TRNS_WKPRGACYR |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Program Length Value
|
| 151 |
SFA_TRNS_SPPRG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
SULA Special Programs Flag
A=Special Admission Assoc Degree
B=2-year Bachelor's Degree
N=Not Applicable
P=Prep Crsewk Grad Prof Pgm
T=Non-Cred Teacher Cert Pgm
U=Prep Crsewk Ugrad Program
|
| 152 |
SFA_TRNS_COD_CRDLV |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is Credential Level field for COD reporting.
01=Undergrad diploma/cert
02=Associate degree
03=Bachelor's degree
04=Post Baccalaureate certificate
05=Master's degree
06=Doctoral degree
07=First Professional degree
08=Graduate/professional certif
99=Non-credential programs
|
| 153 |
SFA_PROGLN_MN_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Prog Length in Month
|
| 154 |
SFA_PROGLN_WK_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Prog Length in Weeks
|
| 155 |
SFA_PROGLN_YR_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Prog Length in Years
|
| 156 |
SFA_WKPRGACYR_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Week Prog Acad Year
|
| 157 |
SFA_SPEC_PROG_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Special Program Flag
|
| 158 |
SFA_COD_CRDLV_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Credential Level
|
| 159 |
SFA_DL_CRD_DEC_ORG |
Character(1) |
VARCHAR2(1) NOT NULL |
Original Credit Decision
A=Credit Approved
D=Credit Denied
|
| 160 |
SFA_DL_CRD_ACTN_CH |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Action Choice
A=Appeal Decision
E=Pursue Endorser
N=Not Pursue PLUS Loan
U=Undecided
|
| 161 |
SFA_DL_APPEAL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Appeal Status
A=Appeal Accepted
D=Appeal Denied
P=Appeal Pending
R=Appeal Closed
|
| 162 |
SFA_DL_CRD_BAL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Balance Option
B=Borrower
S=Student
|
| 163 |
SFA_DL_CRD_EXP_DT |
Date(10) |
DATE |
Credit Decision Expiration Dt
|
| 164 |
SFA_DL_CRDT_ACTNST |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Action Status
D=Endorser Denied
L=Lower Endorser Amount
N=Denied after Pending
|
| 165 |
SFA_DL_RECONS_ELG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reconsideration Eligible
N=No
Y=Yes
|
| 166 |
SFA_DL_PLUS_CNSLCP |
Character(1) |
VARCHAR2(1) NOT NULL |
Counseling Completed
N=No
Y=Yes
|
| 167 |
SFA_DL_PLUS_CNSLDT |
Date(10) |
DATE |
Counseling Complete Dt
|
| 168 |
SFA_DL_PLUS_CNSLEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Counseling Exception
N=No
Y=Yes
|
| 169 |
SFA_DL_CREDIT_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Requirements Met
N=No
Y=Yes
|
| 170 |
SFA_DL_ENDORS_APPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Endorser Approved
N=No
Y=Yes
|
| 171 |
SFA_DL_PLUS_EXPDT |
Date(10) |
DATE |
Counseling Expiration Dt
|
| 172 |
SFA_DL_CRD_DEC_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Decision Status
A=Accepted
D=Denied
P=Pending
|
| 173 |
SFA_DL_IBT_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Informed Borrowing ID
|
| 174 |
SFA_DL_IBT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Informed Borrowing Complete
N=No
Y=Yes
Default Value: N
|
| 175 |
SFA_DL_IBT_DATE |
Date(10) |
DATE |
Informed Borrowing Cmplt Dt
|
| 176 |
SFA_IBT_ID_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override IB ID
Y/N Table Edit
Default Value: N
|
| 177 |
SFA_IBT_FLAG_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override IB Complete
Y/N Table Edit
Default Value: N
|
| 178 |
SFA_IBT_DATE_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override IB Date
Y/N Table Edit
Default Value: N
|
| 179 |
SFA_DL_PLUS_RELSTU |
Character(1) |
VARCHAR2(1) NOT NULL |
RelationshipToStudent
A=Legal Adoptive Parent
O=Other
P=Biological Parent
S=Spouse Legal/Adoptive Parent
|
| 180 |
SFA_DLAC_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override DL Attendance Cost
N=No
Y=Yes
|