D0700370 - Add records to DBA Detail Cache
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| mnPayDeductBenAccType | PDBA | MATH_NUMERIC | REQ | INPUT | 
| A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are 
 | ||||
| mnPayrollTransactionNo | PRTR | MATH_NUMERIC | REQ | INPUT | 
| A unique number that the system assigns to each timecard. You can use this field in the Time Entry By Job program to retrieve a specific 
 | ||||
| mnMonthWorked | DTEM | MATH_NUMERIC | REQ | INPUT | 
| A two-digit number that specifies the applicable month. If you leave this field blank, the program uses the system date. | ||||
| mnAmount | GPA | MATH_NUMERIC | OPT | NONE | 
| The actual gross pay amount for an employee. This amount is to be distinguished from the distributed gross pay amount used for labor 
 | ||||
| mnArrearageAmount | ARRA | MATH_NUMERIC | OPT | NONE | 
| The amount of the deduction that is being or has been reduced because the employee did not receive wages that could cover the payroll 
 | ||||
| mnHoursWorked | PHRW | MATH_NUMERIC | OPT | NONE | 
| The number of hours associated with each transaction. | ||||
| mnPiecesUnits | PCUN | MATH_NUMERIC | OPT | NONE | 
| The number of pieces for piecework or any other unit of measure you want to track for this employee. Examples are:  recording miles driven 
 | ||||
| szDBADetailCache | PID1 | char | OPT | NONE | 
| Program ID - 01 | ||||
| mnCheckControlNumber | CKCN | MATH_NUMERIC | REQ | INPUT | 
| A number used to group all payroll transactions for each payment or individual interim payment. This number is carried into the accounting 
 | ||||
| jdDateWorked | DWK | JDEDATE | OPT | NONE | 
| The date used as the actual work date or pay-period ending date. | ||||
| szBusinessUnitDBAAllocation | MCUG | char | OPT | NONE | 
| This field will come from one of two sources:
   1.   Direct entry of a business unit on the One-Time-Override screen; or
   2.   When the system 
 | ||||
| mnWorkState | WST | MATH_NUMERIC | OPT | NONE | 
| Vertex state code identifying the state where the employee works. REQUIRED. | ||||
| mnWorkCounty | WCNT | MATH_NUMERIC | OPT | NONE | 
| Vertex county code identifying where the employee works. Zero fill if you do not need to calculate county taxes. | ||||
| mnWorkCity | WCTY | MATH_NUMERIC | OPT | NONE | 
| Vertex city code identifying the city where the employee works. Zero fill if you do not need to calculate city taxes. | ||||
| szUnionCode_UN | UN | char | OPT | NONE | 
| A user defined code (06/UN) that represents the union or plan in which the employee or group of employees work or participate. | ||||
| szJobCode_JBCD | JBCD | char | OPT | NONE | 
| A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and 
 | ||||
| szJobStep_JBST | JBST | char | OPT | NONE | 
| A user defined code (07/GS) that designates a specific level within a particular job type. The system uses this code in conjunction with job 
 | ||||
| szWorkersCompInsurCode_WCMP | WCMP | char | OPT | NONE | 
| A user defined code (00/W) that represents a workers' compensation insurance (WCI) code. This code should correspond to the 
 | ||||
| cFloatCode_WET | WET | char | OPT | NONE | 
| A code that specifies any special circumstances associated with the workers compensation insurance (WCI) code, resulting in multiple 
 | ||||
| cF0709WrittenFlag | EV01 | char | OPT | NONE | 
| An option that specifies the type of processing for an event. | ||||
| B0700003 Create PrePayroll Caches | 
| None |