| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| PAYRCORD |
char(7)
''
|
Pay Record...(more) Join Now
|
|
|
|
| INACTIVE |
tinyint
0
|
|
|
|
|
| PAYTYPE |
smallint
0
|
Pay Type: ...(more) Join Now
|
|
|
|
| BSPAYRCD |
char(7)
''
|
Base Pay R...(more) Join Now
|
|
|
|
| PAYRTAMT |
numeric(19,5)
0.00
|
Pay Rate A...(more) Join Now
|
|
|
|
| PAYUNIT |
char(25)
''
|
Pay Unit: ...(more) Join Now
|
|
|
|
| PAYUNPER |
smallint
0
|
Pay Unit P...(more) Join Now
|
|
|
|
| RPTASWGS |
tinyint
0
|
Report as ...(more) Join Now
|
|
|
|
| TAXABLE |
tinyint
0
|
Taxable: ...(more) Join Now
|
|
|
|
| SBJTFDTX |
tinyint
0
|
Subject To...(more) Join Now
|
|
|
|
| SBJTSSEC |
tinyint
0
|
Subject To...(more) Join Now
|
|
|
|
| SBJTMCAR |
tinyint
0
|
Subject To...(more) Join Now
|
|
|
|
| SBJTSTTX |
tinyint
0
|
Subject to...(more) Join Now
|
|
|
|
| SBJTLTAX |
tinyint
0
|
Subject to...(more) Join Now
|
|
|
|
| SBJTFUTA |
tinyint
0
|
|
|
|
|
| SBJTSUTA |
tinyint
0
|
Subject to...(more) Join Now
|
|
|
|
| SUTASTAT |
char(3)
''
|
Suta State...(more) Join Now
|
|
|
|
| FFEDTXRT |
smallint
0
|
Flat Feder...(more) Join Now
|
|
|
|
| FLSTTXRT |
smallint
0
|
Flat State...(more) Join Now
|
|
|
|
| PAYPEROD |
smallint
0
|
1 = Weekly...(more) Join Now
|
|
|
|
| PAYPRPRD |
numeric(19,5)
0.00
|
Pay Per Pe...(more) Join Now
|
|
|
|
| MXPYPPER |
numeric(19,5)
0.00
|
Maximum Pa...(more) Join Now
|
|
|
|
| TipType |
smallint
0
|
Tip Type: ...(more) Join Now
|
|
|
|
| PAYADVNC |
numeric(19,5)
0.00
|
Pay Advanc...(more) Join Now
|
|
|
|
| ACRUVACN |
tinyint
0
|
Accrue Vac...(more) Join Now
|
|
|
|
| ACRUSTIM |
tinyint
0
|
Accrue Sic...(more) Join Now
|
|
|
|
| WRKRCOMP |
char(7)
''
|
Workers Co...(more) Join Now
|
|
|
|
| W2BXNMBR |
smallint
0
|
W2 Box Num...(more) Join Now
|
|
|
|
| W2BXLABL |
char(7)
''
|
W2 Box Lab...(more) Join Now
|
|
|
|
| PYADVTKN |
numeric(19,5)
0.00
|
Pay Advanc...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| DATAENTDFLT |
tinyint
0
|
Data Entry...(more) Join Now
|
|
|
|
| SHFTCODE |
char(7)
''
|
Shift Code...(more) Join Now
|
|
|
|
| PAYFACTR |
numeric(19,5)
0.00
|
Pay Factor...(more) Join Now
|
|
|
|
| BSDONRTE |
numeric(19,5)
0.00
|
|
|
|
|
| PYSTPTBLID |
char(15)
''
|
*Pay Step ...(more) Join Now
|
|
|
|
| Base_Step_Increased_On |
smallint
0
|
*Step FTE ...(more) Join Now
|
|
|
|
| Step |
smallint
0
|
*Step Indi...(more) Join Now
|
|
|
|
| Step_Effective_Date |
datetime
'1/1/1900'
|
*Step Effe...(more) Join Now
|
|
|
|
| Step_FTE |
numeric(19,5)
0.00
|
*Base Step...(more) Join Now
|
|
|
|
| W2BXNMBR2 |
smallint
0
|
|
|
|
|
| W2BXLABL2 |
char(7)
''
|
|
|
|
|
| W2BXNMBR3 |
smallint
0
|
|
|
|
|
| W2BXLABL3 |
char(7)
''
|
|
|
|
|
| W2BXNMBR4 |
smallint
0
|
|
|
|
|
| W2BXLABL4 |
char(7)
''
|
|
|
|
|
| Workflow_Approval_Status |
smallint
0
|
Workflow A...(more) Join Now
|
|
|
|
| Workflow_Priority |
smallint
0
|
div>/div>...(more) Join Now
|
|
|
|
| Workflow_Status |
smallint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|