LN_EDITDFLT_DTL(SQL Table) |
Index Back |
---|---|
Loan Destination Deflt listTo set default valid edits for Loan Destination Profiles. |
# | 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 | Character(1) | VARCHAR2(1) NOT NULL |
Loan Category
B=Sub / Unsub O=Alternative Loan P=PLUS S=Subsidized U=Unsubsidized |
|
5 | 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 |
|
6 | Character(12) | VARCHAR2(12) NOT NULL |
Equation Name
Prompt Table: SFA_LNEDCL4_VW |
|
7 | LN_REQ_STAT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Loan Requirement Status
O=Optional R=Required S=Strongly Recommended Default Value: R |
8 | LN_EDIT_ACTV_INDC | Character(1) | VARCHAR2(1) NOT NULL |
Loan Edit Activated
Y/N Table Edit Default Value: Y |