| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DEFINITION_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
VARCHAR2(10) NOT NULL
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
ADJUST_DEFINITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Reduction Using
A=Arithmetic Rule
T=Table Lookup
U=User Code
Default Value: A
|
| 4 |
ADJUST_TABLE |
Character(10) |
VARCHAR2(10) NOT NULL |
Table Use Name
Prompt Table:
PA_TBL_LOOKUP
|
| 5 |
ADJUST_TBL_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Table-Defined Schedule
A=Use Reduction as Stored
M=Multiple Cumulative Reduction
S=Subtract From Cumulative
U=User Code
Default Value: A
|
| 6 |
PRESERVE_CREDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Between Definitions
Y/N Table Edit
|
| 7 |
APPLY_ADJUSTMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply the Reduction to
F=Some Fixed Period
H=Empl Coverage Election History
Default Value: H
|
| 8 |
ROUND_OPTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Round Option for EFFDT
Prompt Table:
PA_DATE_RND_OPT
|
| 9 |
PERIODS_OPTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Duration Option
M=Monthly Periods
Y=Yearly Periods
|
| 10 |
PRESERVE_ROW |
Character(1) |
VARCHAR2(1) NOT NULL |
Between Coverage History Rows
Y/N Table Edit
|
| 11 |
SEGMENT_DATES |
Character(1) |
VARCHAR2(1) NOT NULL |
Stays Within Segment Dates
Y/N Table Edit
|
| 12 |
FIXED_LENGTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Determine Fixed Period Length
A=Count Periods Between Ages
D=Count Periods Between Dates
U=User Code
|
| 13 |
FIXED_DATE1_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Date 1 Field Type
A=Alias Name
D=Date Constant
|
| 14 |
FIXED_DATE1 |
Date(10) |
DATE |
Date 1
|
| 15 |
FIXED_DATE1_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Date 1 Alias Name
Prompt Table:
PA_DTDB_ALS_VW
|
| 16 |
FIXED_DATE2_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Date 2 Field Type
A=Alias Name
D=Date Constant
|
| 17 |
FIXED_DATE2 |
Date(10) |
DATE |
Date 2
|
| 18 |
FIXED_DATE2_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Date 2 Alias Name
Prompt Table:
PA_DTDB_ALS_VW
|
| 19 |
FIXED_AGE1_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Age 1 Field Type
A=Alias Name
N=Numeric Constant
|
| 20 |
FIXED_AGE1 |
Number(3,0) |
SMALLINT NOT NULL |
Age 1
|
| 21 |
FIXED_AGE1_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Age 1 Alias Name
Prompt Table:
PA_DURATION
|
| 22 |
FIXED_AGE2_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Age 2 Field Type
A=Alias Name
N=Numeric Constant
|
| 23 |
FIXED_AGE2 |
Number(3,0) |
SMALLINT NOT NULL |
Age 2
|
| 24 |
FIXED_AGE2_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Age 2 Alias Name
Prompt Table:
PA_DURATION
|
| 25 |
ADJUST_LENGTH1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust to Mininimum or Maximum
M=Minimum of
N=Not Applicable
X=Maximum of
Default Value: N
|
| 26 |
PERIOD_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Number of Periods
|
| 27 |
PERCENT_FRACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Percentages or Fractions
F=Fractions
P=Percentages
Default Value: P
|
| 28 |
PERCENT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Reduction Basis
A=Age Based
L=Length of Coverage Based
Default Value: L
|
| 29 |
NUM_OF_DEC_PLACES |
Number(3,0) |
SMALLINT NOT NULL |
Number of Decimal Places
|
| 30 |
FIXED_DATE1_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type for Date 1
|
| 31 |
FIXED_DATE2_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type for Date 2
|
| 32 |
FIXED_AGE1_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type for Age 1
|
| 33 |
FIXED_AGE2_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type For Age 2
|