| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RESULT_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Alias Name
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
DATE_FROM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Date From Field Type
A=Alias Name
D=Date Constant
Default Value: A
|
| 4 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 5 |
DATE_FROM_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Date-From
Prompt Table:
PA_ALIAS_USE
|
| 6 |
DATE_FROM_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type
|
| 7 |
DATE_ACTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Action Type to act on Date
AS=Service Date
AT=Add Time to Date
CR=Convert/Round
Default Value: AT
|
| 8 |
PERIOD_DUR1_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Period/Duration 1 Field Type
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 9 |
PERIOD_DURATION1 |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Add Time to Date
|
| 10 |
PERIOD_DUR1_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Period/Duration 1 Alias
Prompt Table:
PA_ALIAS_USE
|
| 11 |
PERIOD_DUR1_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type
|
| 12 |
PERIOD_DUR1_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Period/Duration
D=Decimal
Y=Years
Default Value: Y
|
| 13 |
PERIOD_MONTH_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Period/Duration Months
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 14 |
PERIOD_MONTH |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Period/Duration Months
|
| 15 |
PERIOD_MONTH_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Period/Duration Months
Prompt Table:
PA_ALIAS_USE
|
| 16 |
PERIOD_MNTH_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type
|
| 17 |
PERIOD_DAYS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Period/Duration Days
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 18 |
PERIOD_DAYS |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Period/Duration Days
|
| 19 |
PERIOD_DAYS_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Period/Duration Days
Prompt Table:
PA_ALIAS_USE
|
| 20 |
PERIOD_DAYS_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type
|
| 21 |
SVC_AMOUNT |
Number(12,6) |
DECIMAL(11,6) NOT NULL |
Service Amount Extension
|
| 22 |
SERVICE_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Name
Prompt Table:
PA_DFN_SVC_VW
|
| 23 |
DATE_OPTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Duration Option
Prompt Table:
%DT_OPT_EDIT
|
| 24 |
DT_OPTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Date Option Type
CV=Conversion
RN=Rounding
Default Value: CV
|