| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: LATE_FEE_CD_TBL.SETID
|
| 2 |
LATE_FEE_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Late Fee Code
Default Value: LATE_FEE_CD_TBL.LATE_FEE_CODE
|
| 3 |
LATE_FEE_SCHEME |
Character(6) |
VARCHAR2(6) NOT NULL |
Late Fee Scheme
Default Value: LATE_FEE_SCHEME.LATE_FEE_SCHEME
|
| 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 |
AMOUNT_PAST_DUE |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount Past Due
|
| 7 |
LATE_FEE_INIT_AMT |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Init Flat Amount
|
| 8 |
LATE_FEE_INIT_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Init Aging Percent
|
| 9 |
LATE_FEE_FLAT_AMT |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Late Fee Flat Amount
|
| 10 |
AGING_PERCENT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Aging Percent
|
| 11 |
MIN_DUE |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Minimum Due
|
| 12 |
FLAT_AMT_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Flat Amount Calculation
O=Use Oldest
S=Sum Categories
Default Value: O
|
| 13 |
PCT_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Percent Calculation
O=Use Oldest
S=Sum Categories
Default Value: S
|
| 14 |
EXCL_DISP_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Disputed Items
Y/N Table Edit
Default Value: N
|
| 15 |
EXCL_CREDIT_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Credit Items
Y/N Table Edit
Default Value: N
|
| 16 |
EXCL_SMALL_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Small Items
Y/N Table Edit
Default Value: N
|
| 17 |
ITEM_MINIMUM |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Item Minimum Amount
|
| 18 |
NEW_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
New Item Nbr
Y/N Table Edit
Default Value: N
|
| 19 |
CAP_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
CAP Fees
Y/N Table Edit
Default Value: N
|
| 20 |
APPLY_ANTI_AID |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Anticipated Aid
Y/N Table Edit
Default Value: N
|
| 21 |
EFFECTIVE_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Effective Term
Prompt Table:
TERM_VAL_TBL
|
| 22 |
NBR_OF_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Number of Days
|
| 23 |
MAX_YRLY_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Maximum Yearly Amount
Default Value: 999999999
|
| 24 |
MAX_NBR_YEAR |
Number(3,0) |
SMALLINT NOT NULL |
Max Number per Year
Default Value: 999
|
| 25 |
YEAR_START_SF |
Character(5) |
VARCHAR2(5) NOT NULL |
Year Start
|
| 26 |
YEAR_STOP_SF |
Character(5) |
VARCHAR2(5) NOT NULL |
Year Stop
|
| 27 |
MAX_TERM_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Max Term Amount
Default Value: 999999999
|
| 28 |
MAX_NBR_TERM |
Number(3,0) |
SMALLINT NOT NULL |
Max Number per Term
Default Value: 999
|
| 29 |
MAX_MON_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Maximum Monthly Amount
Default Value: 999999999
|
| 30 |
MAX_NBR_MONTH |
Number(3,0) |
SMALLINT NOT NULL |
Max Number per Month
Default Value: 999
|
| 31 |
DUE_DATE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Due Date
E=Days from Effective Date
N=Null Value
P=Days from Posted Date
Default Value: E
|
| 32 |
DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Due Days
|
| 33 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|