Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
USERID | User ID |
String | 16 | View | |
AUCTRLCD | Audit Control Code |
String | 14 | View | |
BLDCHDID | Build Check Default ID |
String | 16 | View | |
BLDCHKDT | Build Check Date |
Date | 4 | View | |
BLDCHTIM | Build Check Time |
Time | 4 | View | |
PYRNTYPE | Pay Run Type |
Integer | 2 | View | |
COMPPYRN | Computer Pay Run Type |
Integer | 2 | View | |
EMPCLRNG | Employee Class Range |
Integer | 2 | View | |
STTEMPCL | Start Employee Class |
String | 16 | View | |
ENEMPCLS | End Employee Class |
String | 16 | View | |
EMPIDRNG | Employee ID Range |
Integer | 2 | View | |
STTEMPID | Start Employee ID |
String | 16 | View | |
ENDEMPL | End Employee ID |
String | 16 | View | |
PYRNSTDT | Pay Run Start Date |
Date | 4 | View | |
PYRNENDT | Pay Run End Date |
Date | 4 | View | |
PYRNIWLY | Pay Run Includes Weekly |
Boolean | 2 | View | |
PYRNIBWK | Pay Run Includes Biweekly |
Boolean | 2 | View | |
PRNISMLY | Pay Run Includes Semimonthly |
Boolean | 2 | View | |
PYRNIMLY | Pay Run Includes Monthly |
Boolean | 2 | View | |
PYRNIQLY | Pay Run Includes Quarterly |
Boolean | 2 | View | |
PYRNISAN | Pay Run Includes Semiannually |
Boolean | 2 | View | |
PYRNIANN | Pay Run Includes Annually |
Boolean | 2 | View | |
PYRNIDMS | Pay Run Includes Daily/Misc |
Boolean | 2 | View | |
PYRNISRY | Pay Run Includes Salary |
Boolean | 2 | View | |
PYRNIPSN | Pay Run Includes Pension |
Boolean | 2 | View | |
PYRNIEIC | Pay Run Includes EIC |
Boolean | 2 | View | |
PYRNIPTP | Pay Run Include Pay Types |
Integer | 2 | View | |
PYRNIDED | Pay Run Include Deductions |
Integer | 2 | View | |
PYRNIBFT | Pay Run Include Benefits |
Integer | 2 | View | |
DAYSWRDK | Days Worked |
Long Integer | 4 | View | |
WKSWRKD | Weeks Worked |
Long Integer | 4 | View | |
BLCHWREX | Build Check Warnings Exist |
Boolean | 2 | View | |
BDCHEREX | Build Check Errors Exist |
Boolean | 2 | View | |
PRCHKPTD | Precheck Printed |
Boolean | 2 | View | |
PYRLCHPS | Payroll Check Printing Started |
Boolean | 2 | View | |
CHEKDATE | Check Date |
Date | 4 | View | |
POSTEDDT | Posted Date |
Date | 4 | View | |
NUMOFTRX | Number Of TRX |
Long Integer | 4 | View | |
NUMOFEMP | Number of Employees |
Integer | 2 | View | |
CNTRLTRX | Control TRX Count |
Long Integer | 4 | View | |
CTRLEMPCT | Control Employee Count |
Integer | 2 | View | |
APPROVL | Approval |
Boolean | 2 | View | |
APPRVLDT | Approval Date |
Date | 4 | View | |
APRVLUSERID | Approval User ID |
String | 16 | View |