| # |
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 |
LN_RPT_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Loan Report Form ID
Prompt Table:
LN_TYPE_DOC_VW
|
| 5 |
LN_DCMNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates the type of document to be produced for the given Loan Type.
C=Cover Letter
H=Health Professional PNote
I=Total Indebtedness
K=Perkins PNote
M=Master PNote
P=Promissory Note
T=Truth-in-Lending
U=University Loan PNote
Default Value: LN_TYPE_DOC_VW.LN_DCMNT_TYPE
|
| 6 |
LN_DCMNT_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Loan Document ID
|
| 7 |
PNOTE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Promissory Note Type
A=Annual Note
L=Loan Application
M=Master Note
O=Open Note
Default Value: A
|
| 8 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
Default Value: LN_RPT_ITEM.DESCR
|
| 9 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: LN_PNOTE_TBL.DESCR
|
| 10 |
PNOTE_USE_START |
Date(10) |
DATE |
P Note Use Start Dt
|
| 11 |
PNOTE_USE_END |
Date(10) |
DATE |
P Note Use End Dt
|
| 12 |
LN_PNOTE_INTEREST |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Loan P-Note Interest Rate
|
| 13 |
LOAN_INT_VARIABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Variable Interest Rate
Y/N Table Edit
Default Value: N
|
| 14 |
PRINT_PNOTE_BRCODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Not used at this time
Y/N Table Edit
Default Value: N
|
| 15 |
PRINT_DOC_BARCODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Not used at this time
|