| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
|
| 2 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
DED_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Deduction Classification
A=After-Tax
B=Before-Tax
L=QC Taxable Benefit
N=Nontaxable Benefit
P=Nontaxable Btax Benefit
T=Taxable Benefit
Default Value: A
|
| 5 |
DED_SLSTX_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Tax Type
B=None
G=Goods and Services Tax
H=Harmonized Sales Tax
I=Provincial Sales Tax Insurance
P=Provincial Sales Tax
Q=QC Prov Sales Tax Insurance
S=QC Provincial Sales Tax
T=Provincial Premium Tax
U=QC Provincial Premium Tax
|
| 6 |
TAX_GRS_COMPNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Taxable gross component ID.
Prompt Table:
TAXGR_CMPNT_VW
|
| 7 |
FICA_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Effect on FICA Gross
A=Adds To
N=No Effect
S=Subtracts From
Default Value: N
|
| 8 |
FUT_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Effect on FUT Gross
A=Adds To
N=No Effect
S=Subtracts From
Default Value: N
|
| 9 |
GTL_DPL_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
GTL/DPL Effect - Impute Income
D=Add to Dependent Life
G=Add to Group Term Life
N=No Imputed Income Calculated
Default Value: N
|
| 10 |
WITHHOLD_FWT |
Character(1) |
VARCHAR2(1) NOT NULL |
Withhold FWT
Y/N Table Edit
Default Value: N
|
| 11 |
PARTIAL_DED_ALLOW |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Deduction Allowed
Y/N Table Edit
Default Value: Y
|
| 12 |
DED_ARREARS |
Character(1) |
VARCHAR2(1) NOT NULL |
Deduction Arrears Allowed
Y/N Table Edit
Default Value: Y
|
| 13 |
STOP_DED_TERM |
Character(1) |
VARCHAR2(1) NOT NULL |
Stop Deduction at Termination
Y/N Table Edit
Default Value: N
|
| 14 |
SEPCHK_DED |
Character(1) |
VARCHAR2(1) NOT NULL |
Deductions Taken From Sep Chk
Y/N Table Edit
Default Value: N
|
| 15 |
DED_YTD_MAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Maximum Yearly Deduction
|
| 16 |
GL_EXPENSE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #-Expense
|
| 17 |
GL_LIABILITY |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #-Liability
Prompt Table:
GL_ACCOUNT_VW
|
| 18 |
CPP_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Effect on CPP Gross
A=Adds To
N=No Effect
S=Subtracts From
Default Value: N
|
| 19 |
CUI_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Effect on EI Gross
A=Adds To
N=No Effect
S=Subtracts From
Default Value: N
|
| 20 |
QIT_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Effect on QIT Gross
A=Adds To
N=No Effect
S=Subtracts From
Default Value: N
|
| 21 |
QPP_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Effect on QPP Gross
A=Adds To
N=No Effect
S=Subtracts From
Default Value: N
|
| 22 |
TRUE_T4GRS_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Eff on True T4 Gross
A=Adds To
N=No Effect
S=Subtracts From
Default Value: N
|
| 23 |
TRUE_RVGRS_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Eff on True RL Gross
A=Adds To
N=No Effect
S=Subtracts From
Default Value: N
|
| 24 |
PAY_TAX_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Eff on Payroll Tax Gross
A=Adds To
N=No Effect
S=Subtracts From
Default Value: N
|
| 25 |
T4A_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Effect on T4A Gross
A=Adds To
N=No Effect
S=Subtracts From
Default Value: N
|
| 26 |
RV2_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Effect on RL-2 Gross
A=Adds To
N=No Effect
S=Subtracts From
Default Value: N
|
| 27 |
ADD_TO_FICA_CREDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator for FICA Credit. If it is checked 'ON', then the deduction amount will be added to FICA Credit.
Y/N Table Edit
Default Value: N
|
| 28 |
QPIP_EFFECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Effect on QPIP Gross
A=Adds To
N=No Effect
S=Subtracts From
Default Value: N
|
| 29 |
EMPLR_MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Employer Match Option when there's insufficient Net Pay.
1=No Employer Match
2=Recalculated Employer Match
3=Full Employer Match
Default Value: 2
|
| 30 |
SUPPRESS_GL |
Character(1) |
VARCHAR2(1) NOT NULL |
Suppress Posting to GL
Y/N Table Edit
Default Value: N
|