| Description | Column | Datatype |
|---|---|---|
| Batch date | d_batch_s | datetime |
| Batch number | batch_num_s | char (6) |
| Sybase timestamp | timestamp | timestamp |
| Batch projected total | total_d | double precision |
| Status (UNPR/SUBM/FAIL/IPRG/COMP)
UNPR - unprocessed SUBM - submitted FAIL - failed (nothing processed) IPRG - in progress COMP - completed |
status_s | char (4) |
| Batch count total | count_l | integer |
| Processed entries count | processed_cnt_l | integer |
| Processed entries total | processed_tot_d | double precision |
| Run date | d_run_s | datetime |
| Run time | t_run_s | char (6) |
| Operator initials | opr_s | char (3) |
| Batch validated (Y/N) | validated_c | char (1) |
| Index name | Piece 1 | Piece 2 |
|---|---|---|
| rbc_idx0 | d_batch_s | batch_num_s |