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 | 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_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 |
4 | LOAN_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Loan Category
B=Sub / Unsub O=Alternative Loan P=PLUS S=Subsidized U=Unsubsidized |
5 | LN_DEST_PROC_LVL | 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 | EQUATION_NAME | 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 |