ITEMTYPFAFEELNG(SQL Table) | 
Index Back | 
|---|---|
RelLng-Item Type Fee TableITEMTYPFAFEELNG is the related language recordfor the record ITEM_TYP_FA_FEE | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | 
SetID
 Default Value: ITEM_FA_CD_TBL.SETID Prompt Table: SP_SETID_NONVW  | 
|
| 2 | Character(12) | VARCHAR2(12) NOT NULL | 
Item Type
 Default Value: ITEM_FA_CD_TBL.ITEM_TYPE Prompt Table: ITEM_TYP_LN_VW  | 
|
| 3 | Character(4) | VARCHAR2(4) NOT NULL | 
Aid Year
 Default Value: ITEM_FA_CD_TBL.AID_YEAR Prompt Table: ITEM_TYPE_FA  | 
|
| 4 | Date(10) | DATE NOT NULL | 
Effective Date
 Default Value: %date  | 
|
| 5 | Character(3) | VARCHAR2(3) NOT NULL | 
Loan Fee
 Prompt Table: LN_FEE_VW  | 
|
| 6 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | 
Description
 Default Value: LN_FEE_TBL.DESCR  |