| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PY_PFF_CALCRULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Calc Rule Id
|
| 2 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 3 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 4 |
PY_PFF_STEP |
Number(3,0) |
SMALLINT NOT NULL |
Step
|
| 5 |
PY_PFF_ELEM1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Element 1
A=Tax Table - Tax Rate
B=Tax Table - Ratio
C=Result of Step
D=Company Tax - EE Ratio
E=Company Tax - ER Ratio
F=Company Tax - EE Rate Percent
G=Company Tax - ER Rate Percent
I=Rate Percent
|
| 6 |
PY_PFF_ELEM2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Element 2
A=Tax Table - Tax Rate
B=Tax Table - Ratio
C=Result of Step
D=Company Tax - EE Ratio
E=Company Tax - ER Ratio
F=Company Tax - EE Rate Percent
G=Company Tax - ER Rate Percent
H=Not Applicable
I=Rate Percent
|
| 7 |
PY_PFF_OPER |
Character(1) |
VARCHAR2(1) NOT NULL |
Operator
*=Multiply by
+=Plus
-=Minus
/=Divided by
N=N/A
Default Value: N
|
| 8 |
PY_PFF_ELEM1_TXT1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Element 1 Value
Prompt Table:
PY_TAX_CLS_VW
|
| 9 |
PY_PFF_ELEM2_TXT2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Element 2 Value
Prompt Table:
PY_TAX_CLS_VW2
|
| 10 |
PY_PFF_ELEM1_NUM1 |
Number(3,0) |
SMALLINT NOT NULL |
Element 1 Value
|
| 11 |
PY_PFF_ELEM2_NUM2 |
Number(3,0) |
SMALLINT NOT NULL |
Element 2 Value
|
| 12 |
PY_PFF_ELEM1_RTPCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Element 1 Value
|
| 13 |
PY_PFF_ELEM2_RTPCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Element 1 Value
|