| # |
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 |
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
|
| 3 |
LN_DEST_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Loan Destination Num
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 7 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: SFA_CRC_DEST.DESCR
|
| 8 |
INC_DEST_OVR |
Character(1) |
VARCHAR2(1) NOT NULL |
Incomplete Dest Override
Y/N Table Edit
Default Value: N
|
| 9 |
SFA_CR_LNDR_OPEID |
Character(8) |
VARCHAR2(8) NOT NULL |
Lender OPEID
Prompt Table:
SFA_CRC_DESL_VW
|
| 10 |
SFA_CR_LNDR_BRANCH |
Character(4) |
VARCHAR2(4) NOT NULL |
Lender Branch ID
Prompt Table:
SFA_CRC_DSL_VW2
|
| 11 |
SFA_CR_GUAR_OPEID |
Character(8) |
VARCHAR2(8) NOT NULL |
Guarantor OPEID
Prompt Table:
SFA_CRC_DESG_VW
|
| 12 |
SFA_CR_GUAR_BRANCH |
Character(4) |
VARCHAR2(4) NOT NULL |
Guarantor Branch ID
|
| 13 |
SFA_CR_SVR_OPEID |
Character(8) |
VARCHAR2(8) NOT NULL |
Servicer OPEID
Prompt Table:
SFA_CRC_DESS_VW
|
| 14 |
SFA_CR_SVR_BRANCH |
Character(4) |
VARCHAR2(4) NOT NULL |
Servicer Branch Code
Prompt Table:
SFA_CRC_DSS_VW2
|
| 15 |
PHYS_DEST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Destination
G=Guarantor
L=Lender
S=Servicer
|
| 16 |
CHG_DEST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Pre-Disb Destination In
G=Guarantor
L=Lender
S=Servicer
|
| 17 |
DSB_DEST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Disb Destination Ind
G=Guarantor
L=Lender
S=Servicer
|
| 18 |
CONTACT_PREDISB |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre-Disb Contact
G=Guarantor
L=Lender
S=Servicer
Default Value: S
|
| 19 |
CONTACT_DISB |
Character(1) |
VARCHAR2(1) NOT NULL |
Disb Contact
G=Guarantor
L=Lender
S=Servicer
Default Value: S
|
| 20 |
CONTACT_POSTDISB |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Disb Contact
G=Guarantor
L=Lender
S=Servicer
Default Value: S
|
| 21 |
SFA_CR_VERSION |
Character(4) |
VARCHAR2(4) NOT NULL |
Version
C=Common Record Commonline
Default Value: C
|
| 22 |
SFA_CR_PLUS_MPN |
Character(1) |
VARCHAR2(1) NOT NULL |
PLUS MPN Processing Default (New or Serial)
N=New MPN
S=Serial MPN
|
| 23 |
CL_ACCEPT_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
Accepts CommonLine Change Recs
Y/N Table Edit
Default Value: Y
|
| 24 |
SFA_CR_STAF_MPN |
Character(1) |
VARCHAR2(1) NOT NULL |
Stafford MPN Processing Default (New or Serial)
N=New MPN
S=Serial MPN
|
| 25 |
PNOTE_DELIVER_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Destination attribute that indicates how the PNOTE will be sent to the borrower.
For CL 4 processing.
E=Email
P=Paper
W=Web
Default Value: P
|
| 26 |
LN_HOLD_REL_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Attribute which indicates whether the loan destination participates in a disbursement hold and release process.
H=Hold Disbursement
N=Not Supported
R=Release Disbursement
|
| 27 |
LN_RET_METH_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Funds Return Method Code
E=Electronic Fund Transfer
I=Borrower Check
M=Master Check
N=Netting
Default Value: E
|
| 28 |
SFA_FILE_PATH |
Character(250) |
VARCHAR2(250) NOT NULL |
File Path
|