| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPTION_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Option Name
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
AGE_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Age Calculation Type
D=Decimal Date Subtraction
P=Period Counting
R=Raw Date Subtraction
U=User Code
Default Value: R
|
| 4 |
DAY_PER_MONTH |
Number(3,0) |
SMALLINT NOT NULL |
Days Per Month
|
| 5 |
DECIMAL_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Days Per Month
|
| 6 |
DECIMAL_YEAR |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Days Per Year
|
| 7 |
DECIMAL_CNV_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Decimal Conversion Method
A=Yrs + ((Months * Days/Mth) +
C=Yrs + (Months / 12) + Days /
E=Date Tables
U=User Code
Default Value: A
|
| 8 |
FIRST_COMPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Complete Only
Y/N Table Edit
Default Value: Y
|
| 9 |
FIRST_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Count First Period
D=Days
M=Months
Y=Years
Y/N Table Edit
Default Value: N
|
| 10 |
SECOND_COMPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Complete Only
Y/N Table Edit
Default Value: N
|
| 11 |
SECOND_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Count Second Period
D=Days
M=Months
N=None
Default Value: M
|
| 12 |
SECOND_ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Round the Second Period
E=Round Up if Periods >
N=No Second Round Rule
U=Round Up if Periods >
Default Value: N
|
| 13 |
SECOND_ROUND_UP |
Number(3,0) |
SMALLINT NOT NULL |
Round Up if Periods >
|
| 14 |
SECOND_ROUND_ELSE |
Number(3,0) |
SMALLINT NOT NULL |
Round Up if Periods >Else Down
|
| 15 |
THIRD_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Count Third Period
D=Days
N=None
Default Value: D
|
| 16 |
THIRD_ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Round the Third Period
E=Round Up if Periods >
N=No Third Period Round Rule
U=Round Up if Periods >
Default Value: N
|
| 17 |
THIRD_ROUND_UP |
Number(3,0) |
SMALLINT NOT NULL |
Round Up if Periods >
|
| 18 |
THIRD_ROUND_ELSE |
Number(3,0) |
SMALLINT NOT NULL |
Round Up if Periods >
|
| 19 |
MONTH_EQUIV_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Monthly Equiv Flag
Y/N Table Edit
|
| 20 |
DEC_PLACES |
Number(3,0) |
SMALLINT NOT NULL |
Number of Decimal Places
|
| 21 |
MONTH_CONV |
Character(1) |
VARCHAR2(1) NOT NULL |
Monthly Equiv Conv Rules
D=Down
N=Near
O=No Rounding
U=Up
Default Value: O
|
| 22 |
YEAR_CONV |
Character(1) |
VARCHAR2(1) NOT NULL |
Year Conversion
D=Down
N=Near
O=No Rounding
U=Up
Default Value: O
|
| 23 |
DAY_MONTH_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Acutal or Assumed days per mth
A=Actual Days Per Month
N=Assumed Days Per Month
Default Value: A
|