LN_DESTPROF_TBL(SQL Table) |
Index Back |
---|---|
Loan Destination Profiles TablTo construct profile information |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
|
2 | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
|
3 | Character(1) | VARCHAR2(1) NOT NULL |
Loan Program
A=Alternative D=Direct Lending F=FFELP H=Health Professions P=Perkins S=State U=University |
|
4 | Number(3,0) | SMALLINT NOT NULL |
Loan Destination Num
Prompt Table: LN_DESTPROF_VW |
|
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: LN_DESTPROF_TBL.DESCR |
7 | DFLT_DESTINATION | Character(1) | VARCHAR2(1) NOT NULL |
Default Destination
Y/N Table Edit Default Value: N |
8 | LEND_UNQ_ID | Number(3,0) | SMALLINT NOT NULL |
Lender ID
Prompt Table: LENDER_TBL |
9 | GUAR_UNQ_ID | Number(3,0) | SMALLINT NOT NULL |
Guarantor ID
Prompt Table: GUARANTOR_TBL |
10 | SERV_UNQ_ID | Number(3,0) | SMALLINT NOT NULL |
Servicer ID
Prompt Table: SERVICER_TBL |
11 | INC_DEST_OVR | Character(1) | VARCHAR2(1) NOT NULL |
Incomplete Dest Override
Y/N Table Edit Default Value: N |
12 | PHYS_DEST_IND | Character(1) | VARCHAR2(1) NOT NULL |
Physical Destination
G=Guarantor L=Lender S=Servicer |
13 | CONTACT_PREDISB | Character(1) | VARCHAR2(1) NOT NULL |
Pre-Disb Contact
G=Guarantor L=Lender S=Servicer Default Value: S |
14 | CONTACT_DISB | Character(1) | VARCHAR2(1) NOT NULL |
Disb Contact
G=Guarantor L=Lender S=Servicer Default Value: S |
15 | CONTACT_POSTDISB | Character(1) | VARCHAR2(1) NOT NULL |
Post Disb Contact
G=Guarantor L=Lender S=Servicer Default Value: S |
16 | LN_PHY_DEST_OE_CD | Character(6) | VARCHAR2(6) NOT NULL | Physical Destination OE Code |
17 | LN_PHY_DEST_OE_BR | Character(2) | VARCHAR2(2) NOT NULL | Physical Destination OE Branch |
18 | LN_PHY_DEST_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Physical Destination Descr |
19 | 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 |
20 | LN_DISB_NET_TOL | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Loan Disb Net Tolerance |
21 | CHG_DEST_IND | Character(1) | VARCHAR2(1) NOT NULL |
Change Pre-Disb Destination In
G=Guarantor L=Lender S=Servicer |
22 | CHG_DEST_UNQ_ID | Number(3,0) | SMALLINT NOT NULL |
Pre-Disb Trans Unique ID
Prompt Table: %EDITTABLE |
23 | DSB_DEST_IND | Character(1) | VARCHAR2(1) NOT NULL |
Post Disb Destination Ind
G=Guarantor L=Lender S=Servicer |
24 | DSB_DEST_UNQ_ID | Number(3,0) | SMALLINT NOT NULL |
Post Disb Trans Unique ID
Prompt Table: %EDITTABLE2 |
25 | CL_VER_TYPE_USE | Character(1) | VARCHAR2(1) NOT NULL |
CommonLine Version to use.
2=CommonLine 96 4=CommonLine Ver 4 Default Value: 4 |
26 | CL_ACCEPT_CHNG | Character(1) | VARCHAR2(1) NOT NULL |
Accepts CommonLine Change Recs
Y/N Table Edit Default Value: Y |
27 | LN_REQ_UNQ | Character(1) | VARCHAR2(1) NOT NULL |
CommonLine @2 Required
Y/N Table Edit Default Value: N |
28 | LN_REQ_ALT | Character(1) | VARCHAR2(1) NOT NULL |
CL Alt Req @4 Required
Y/N Table Edit Default Value: N |
29 | LN_REQ_REF | Character(1) | VARCHAR2(1) NOT NULL |
CL Ref @5 Required
Y/N Table Edit Default Value: N |
30 | LN_REQ_REF_SUP | Character(1) | VARCHAR2(1) NOT NULL |
CL Ref Sup @7 Required
Y/N Table Edit Default Value: N |
31 | 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 |
32 | MPN_PROC_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to indicate whether the loan destination participates in processing serial loans from a single MPN.
N=New MPN Required S=Renew Serial MPN |
33 | 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 |
34 | CL_FED_APP_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
Default setting of the type of federal application we are processing for CommonLine
B=Stafford Version 1/3/94 M=Master Prom Note |
35 | 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 |