DW_NS_payrollBatch_D
This table contains information about payroll batches created to generate paychecks.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | Internal ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| batchnumber | VARCHAR2 | 32 | Batch | ||||
| checkdate | TIMESTAMP | Check Date | |||||
| count | NUMBER | Count | |||||
| datecreated | TIMESTAMP | Date Created | |||||
| displaystatus | VARCHAR2 | 999 | Display Status | ||||
| donotaccruetime | VARCHAR2 | 16 | Do Not Accrue Time | ||||
| message | VARCHAR2 | 999 | Message | ||||
| nodirectdeposit | VARCHAR2 | 16 | No Direct Deposits | ||||
| offcycle | VARCHAR2 | 16 | Off Cycle | ||||
| payautocontribution | VARCHAR2 | 16 | Pay Auto Contribution | ||||
| payautodeduction | VARCHAR2 | 16 | Pay Auto Deduction | ||||
| payautoearning | VARCHAR2 | 16 | Pay Auto Earning | ||||
| paybonuses | VARCHAR2 | 16 | Pay Bonuses | ||||
| paycommissions | VARCHAR2 | 16 | Pay Commissions | ||||
| payexpenses | VARCHAR2 | 16 | Pay Expenses | ||||
| paypto | VARCHAR2 | 16 | Pay PTO | ||||
| paytime | VARCHAR2 | 16 | Pay Time | ||||
| periodending | TIMESTAMP | Period Ending | |||||
| subsidiary | NUMBER | 38 | 0 | Subsidiary | |||
| tobeprinted | VARCHAR2 | 16 | To Be Printed |