EMPLOYID | char(15) | Yes | Employee ID - | IN |
PAYRCORD | char(6) | Yes | Pay Code - | IN |
INACTIVE | tinyint | No | Inactive - - 0=False & 1=True | IN |
BSPAYRCD | char(6) | No | Based on Pay Code - | IN |
PAYRTAMT | numeric(19,5) | No | Pay Rate Amount - | IN |
PAYUNIT | char(25) | Yes | Pay Unit - if passing a Piecework Pay Code | IN |
PAYUNPER | smallint | No | Pay Unit Period - - 1 = Weekly, 2 = Biweekly, | IN |
RPTASWGS | tinyint | No | Report As Wages - - 0=False & 1=True | IN |
SBJTFDTX | tinyint | No | Subject To Fed Tax - - 0=False & 1=True | IN |
SBJTSSEC | tinyint | No | Subject To Social Security - - 0=False & 1=True | IN |
SBJTMCAR | tinyint | No | Subject To Medicare - - 0=False & 1=True | IN |
SBJTSTTX | tinyint | No | Subject To State Tax - - 0=False & 1=True | IN |
SBJTLTAX | tinyint | No | Subject To Local Tax - - 0=False & 1=True | IN |
SBJTFUTA | tinyint | No | Subject To FUTA Tax - - 0=False & 1=True | IN |
SBJTSUTA | tinyint | No | Subject To SUTA Tax - - 0=False & 1=True | IN |
SUTASTAT | char(2) | No | SUTA State - | IN |
FFEDTXRT | numeric(19,5) | No | Federal Tax Rate - | IN |
FLSTTXRT | numeric(19,5) | No | State Tax Rate - | IN |
PAYPEROD | smallint | No | Pay Period - | IN |
MXPYPPER | numeric(19,5) | No | Max Per Pay Period - | IN |
TipType | smallint | No | Tip Type - - 1=Directly & 2=Indirectly | IN |
PAYADVNC | numeric(19,5) | No | Pay Advance - | IN |
ACRUVACN | tinyint | No | Auto Accrue Vacation Time - - 0=False & 1=True | IN |
ACRUSTIM | tinyint | No | Auto Accrue Sick Time - - 0=False & 1=True | IN |
WRKRCOMP | char(6) | No | Workers Comp Code - | 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 |
PYADVTKN | numeric(19,5) | No | Pay Advance Taken - | IN |
DATAENTDFLT | tinyint | No | Data Entry Default - - 0=False & 1=True | IN |
Primary_Pay_Record | tinyint | No | Primary Pay Record - - - 0=False & 1=True | IN |
SHFTCODE | char(6) | No | Shift Code - | IN |
PAYFACTR | numeric(19,5) | No | Pay Factor - | IN |
UseDefaultCoPayCode | smallint | No | Use Default Company Pay Code - 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 |
ErrorState | int | No | Return value: 0=No Errors, 1=Error Occurred | INOUT |
oErrString | varchar(255) | No | Return Error Code List | INOUT |