DEDUCTON | char(6) | Yes | Deduction - | IN |
DSCRIPTN | char(30) | Yes | Deduction Description - | IN |
INACTIVE | tinyint | No | Inactive - - 0 = False & 1 = True | IN |
DEDBEGDT | datetime | Yes | Begin Date - | IN |
DEDENDDT | datetime | No | End Date - | IN |
DEDTYPE | smallint | No | Deduction Type - - 1 = Standard & 2 = Garnishment | IN |
GARNCAT | smallint | Yes | Garnishment Category - if Deduction Type is set to a 2 | IN |
VARDEDTN | tinyint | No | Variable Deduction - - 0 = False & 1 = True | IN |
DEDNFREQ | smallint | No | Deduction Frequency - - 1 = Weekly, 2 = Biweekly, | IN |
SFRFEDTX | tinyint | No | Sheltered from Fed. Tax - - 0 = False & 1 = True | IN |
SHFRFICA | tinyint | No | Sheltered from FICA Tax - - 0 = False & 1 = True | IN |
SHFRSTTX | tinyint | No | Sheltered from State Tax - - 0 = False & 1 = True | IN |
SFRLCLTX | tinyint | No | Sheltered from Local Tax - - 0 = False & 1 = True | IN |
BSDORCDS | smallint | No | Based on Records - - 0 = All & 1 = Selected | IN |
DEDNMTHD | smallint | No | Deduction Method - - 1 = % of Gross Wages, | IN |
DEDFRMLA | smallint | No | Deduction Formula - 0 = Single & 1 = Multiple | IN |
EARNINGSCODE | char(15) | No | Earnings Code - | IN |
DEDCAMNT_1 | numeric(19,5) | No | Deduction Amount 1 - | IN |
DEDCAMNT_2 | numeric(19,5) | No | Deduction Amount 2 - | IN |
DEDCAMNT_3 | numeric(19,5) | No | Deduction Amount 3 - | IN |
DEDCAMNT_4 | numeric(19,5) | No | Deduction Amount 4 - | IN |
DEDCAMNT_5 | numeric(19,5) | No | Deduction Amount 5 - | IN |
DEDNPRCT_1 | numeric(19,5) | No | Deduction Percentage 1 - | IN |
DEDNPRCT_2 | numeric(19,5) | No | Deduction Percentage 2 - | IN |
DEDNPRCT_3 | numeric(19,5) | No | Deduction Percentage 3 - | IN |
DEDNPRCT_4 | numeric(19,5) | No | Deduction Percentage 4 - | IN |
DEDNPRCT_5 | numeric(19,5) | No | Deduction Percentage 5 - | IN |
DEDTRMAX_1 | numeric(19,5) | No | Deduction Tier Max 1 - | IN |
DEDTRMAX_2 | numeric(19,5) | No | Deduction Tier Max 2 - | IN |
DEDTRMAX_3 | numeric(19,5) | No | Deduction Tier Max 3 - | IN |
DEDTRMAX_4 | numeric(19,5) | No | Deduction Tier Max 4 - | IN |
DEDTRMAX_5 | numeric(19,5) | No | Deduction Tier Max 5 - | IN |
DETRMXUN_1 | numeric(19,5) | No | Deduction Tier Max Units 1 - | IN |
DETRMXUN_2 | numeric(19,5) | No | Deduction Tier Max Units 2 - | IN |
DETRMXUN_3 | numeric(19,5) | No | Deduction Tier Max Units 3 - | IN |
DETRMXUN_4 | numeric(19,5) | No | Deduction Tier Max Units 4 - | IN |
DETRMXUN_5 | numeric(19,5) | No | Deduction Tier Max Units 5 - | IN |
DEPYPRMX | numeric(19,5) | No | Deduction Pay Period Max - | IN |
DEDYRMAX | numeric(19,5) | No | Deduction Year Max - | IN |
Deduction_Fiscal_Yr_Max | numeric(19,5) | No | Deduction Fiscal Year Maximum - | IN |
DEDLTMAX | numeric(19,5) | No | Deduction Life Max - | IN |
W2BXNMBR | smallint | No | W-2 Box Number - | IN |
W2BXLABL | char(6) | No | W-2 Box Label - | IN |
W2BXNMBR2 | smallint | No | W-2 Box Number 2 - | IN |
W2BXLABL2 | char(6) | No | W-2 Box Label 2 - | IN |
W2BXNMBR3 | smallint | No | W-2 Box Number 3 - | IN |
W2BXLABL3 | char(6) | No | W-2 Box Label 3 - | IN |
W2BXNMBR4 | smallint | No | W-2 Box Number 4 - | IN |
W2BXLABL4 | char(6) | No | W-2 Box Label 4 - | IN |
DATAENTDFLT | tinyint | No | Data Entry Default - - 0 = False & 1 = True | IN |
UpdateIfExists | tinyint | No | Flag to allow customer data to be updated if it exists. 0=no, 1=yes | IN |
RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | IN |
USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
SHFRFICAMED | tinyint | No | New parameter Added For Bug ID #72342 | IN |
ErrorState | int | No | Return value: 0=No Errors, 1=Error Occurred | INOUT |
oErrString | varchar(255) | No | Return Error Code List | INOUT |