| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INTEREST_USE_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Interest Parameter Set Name
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
B_INT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Balance Interest Type
L=Level Rate
U=User Code
Default Value: L
|
| 4 |
B_INT_LVL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Source Type
C=Constant Rate
L=Table Lookup
S=Custom Statement
T=Program Generated Table Lookup
Default Value: C
|
| 5 |
INT_LR_PD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Level Rate Period Type
A=Annual
M=Monthly
Default Value: A
|
| 6 |
INT_LR_FP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Full Period Interest Method
F=Full Period Interest
N=No Interest
P=Fractional Interest For Period
U=User Code
Default Value: F
|
| 7 |
INT_LR_FP_P_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest Type
C=Compound Interest
S=Simple Interest
Default Value: S
|
| 8 |
INT_FP_NUMER |
Number(3,0) |
SMALLINT NOT NULL |
Numerator
|
| 9 |
INT_FP_DENOM |
Number(3,0) |
SMALLINT NOT NULL |
Denominator
|
| 10 |
INT_PP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Period Interest Method
N=No Interest
P=Partial Interest, Using
S=Same as Full Period Technique
U=User Code
Default Value: N
|
| 11 |
INT_PP_P_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest Type
C=Compound Interest
S=Simple Interest
Default Value: S
|
| 12 |
B_INT_L_CONST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Bal Int Level Constant Type
|
| 13 |
INT_LR_CONST |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Interest Rate
Default Value: 0
|
| 14 |
INT_LR_TBL_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Rate Table Name
Prompt Table:
PA_TBL_ALS_SRCH
|
| 15 |
INT_LR_TATBL_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Aware Table
Prompt Table:
PA_TBL_INT_SRCH
|
| 16 |
INT_LR_TATBL_OPT |
Character(3) |
VARCHAR2(3) NOT NULL |
Time Aware Table Option
FPD=First Day of Period
FYC=First Day of Calendar Year
FYP=First Day of Plan Year
LPD=Last Day of Period
Default Value: FPD
|
| 17 |
INT_LR_STMT_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Statement Name
Prompt Table:
PA_CUSTOM
|