| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 3 |
LOAN_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Loan Type Cd
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: LN_TYPE_TBL.DESCR
|
| 6 |
LOAN_PROGRAM |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Program
A=Alternative
D=Direct Lending
F=FFELP
H=Health Professions
P=Perkins
S=State
U=University
|
| 7 |
LOAN_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Category
B=Sub / Unsub
O=Alternative Loan
P=PLUS
S=Subsidized
U=Unsubsidized
|
| 8 |
LOAN_FEE_RT |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
Loan Fee Rate
|
| 9 |
LOAN_INS_RT |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Loan Insurance Rate
|
| 10 |
LOAN_REF_RQRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan References Required
Y/N Table Edit
Default Value: N
|
| 11 |
LOAN_NBR_REF_RQRD |
Number(1,0) |
SMALLINT NOT NULL |
Nbr Loan References Rqrd
|
| 12 |
LOAN_COSIGN_RQRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Cosigner Required
Y/N Table Edit
Default Value: N
|
| 13 |
LOAN_AMT_COSIGN |
Number(5,0) |
INTEGER NOT NULL |
Cosigner Required Amt
|
| 14 |
LOAN_NBR_CSGN_RQRD |
Number(1,0) |
SMALLINT NOT NULL |
Nbr Loan Cosigner Rqurd
|
| 15 |
LOAN_CREDIT_RQRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Check Required
Y/N Table Edit
Default Value: N
|
| 16 |
LOAN_PCKG_ORDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Package Order
1=Package 1st
2=Package 2nd
3=Package 3rd
4=Package 4th
5=Package 5th
6=Package 6th
|
| 17 |
FED_OR_INST_COST |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal or Institutional Cost
F=Federal Cost
I=Institutional Cost
Default Value: F
|
| 18 |
SVCR_PRINT_PNOTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Servicer Prints Prom Note
Y/N Table Edit
Default Value: N
|
| 19 |
LN_REFUND_INDC |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Refund Indicator
B=Borrower
S=Student
Default Value: B
|
| 20 |
CL_TYPE_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
CL Loan Type Code
|
| 21 |
CL_ALT_LN_TYPE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Alternative Loan Type Cd
|
| 22 |
LN_RPT_PKG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report Package
Prompt Table:
LN_RPT_PKG_VW
|
| 23 |
CHECKLIST_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Checklist Code
Prompt Table:
LN_CHKLST_VW
|
| 24 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 25 |
LN_DL_DISB_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
DL Disbursement Option
B=Disburse on Orig & PNote Ack
N=Disburse on Origination
O=Disburse on Orig Ack
P=Disburse on PNote Ack
|
| 26 |
LN_DL_TRNS_DISB_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
DL Transmit Disb Option
B=Transmit Disb on Orig & PNote
O=Transmit Disb on Orig Ack
|
| 27 |
DL_VER_TYPE_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Direct Loan Version
0=Direct Loan 2000
1=Direct Loan 2001
2=Direct Loan 2002
3=Direct Loan 2003
4=Direct Loan 2004
5=Direct Loan 2005
|
| 28 |
LN_MAX_NBR_DISBS |
Number(5,0) |
INTEGER NOT NULL |
Max Nmb of Disbursements
Default Value: 4
|
| 29 |
LN_MIN_LOAN_AMT |
Number(5,0) |
INTEGER NOT NULL |
Minimum Amount to Originate
Default Value: 1
|
| 30 |
LN_DL_ADD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days to Add to Inserted Disb
|
| 31 |
SFA_LN_GRAD_PLUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Graduate PLUS Indicator
Y/N Table Edit
Default Value: N
|
| 32 |
SFA_ADDL_USUB_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Unsub Eligibility
Y/N Table Edit
Default Value: N
|
| 33 |
SFA_DO_NOT_COPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Do Not Copy
Y/N Table Edit
|