| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
PY_OPT_PED |
Character(1) |
VARCHAR2(1) NOT NULL |
Date option for pay end date.
|
| 2 |
PY_OPT_CHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Date option for check date.
|
| 3 |
PY_TH_GROSS |
Character(1) |
VARCHAR2(1) NOT NULL |
Threshold for total gross on check.
|
| 4 |
PY_TH_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Threshold for taxes on check.
|
| 5 |
PY_TH_DED |
Character(1) |
VARCHAR2(1) NOT NULL |
Threshold for total deductuion on check.
|
| 6 |
PY_TH_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
Threshold for net pay on check.
|
| 7 |
PY_TH_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Threshold by Amount.
|
| 8 |
PY_TH_HR |
Character(1) |
VARCHAR2(1) NOT NULL |
Threshold by hour.
|
| 9 |
PY_GREATER |
Character(1) |
VARCHAR2(1) NOT NULL |
Greater than operator.
|
| 10 |
PY_LESS_THAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Less than operator.
|
| 11 |
PY_EQUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Equal to operator.
|