| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPT_FEE_TERM.SETID
Prompt Table:
OPT_FEE_TRM_EFF
|
| 2 |
FEE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Fee Code
Default Value: OPT_FEE_TERM.FEE_CD
Prompt Table:
OPT_FEE_TRM_EFF
|
| 3 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Default Value: OPT_FEE_TERM.STRM
Prompt Table:
OPT_FEE_TRM_EFF
|
| 4 |
ACADEMIC_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Academic Load
F=Enrolled Full-Time
H=Enrolled Half-Time
L=Less than Half-Time
N=No Unit Load
P=Enrolled Part-Time
T=Three Quarter Time
Default Value: OPT_FEE_TRM_LD.ACADEMIC_LOAD
Prompt Table:
OPT_FEE_TRM_EFF
|
| 5 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: OPT_FEE_TRM_EFF.EFFDT
|
| 6 |
VALID_VALUE |
Character(6) |
VARCHAR2(6) NOT NULL |
Valid Value
Prompt Table:
OPT_FEE_VAL
|
| 7 |
AMT_PER_UNIT |
Number(17,2) |
DECIMAL(16,2) NOT NULL |
Amount Per Unit
|
| 8 |
FLAT_AMT |
Number(17,2) |
DECIMAL(16,2) NOT NULL |
Flat Amount
|
| 9 |
MAX_AMOUNT |
Number(17,2) |
DECIMAL(16,2) NOT NULL |
Maximum Amount
Default Value: 99999
|
| 10 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 11 |
INITIAL_VALUE |
Character(1) |
VARCHAR2(1) NOT NULL |
Initial Value
Y/N Table Edit
Default Value: N
|