| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ESTIMATIONID | Runtime Estimation ID | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | PCLPACKID | Package Number of Transformation / Analysis Package | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | STEP | Step Number for Execution of Parallel Background Jobs | int | 10 | 0 | | | | Allow NULL? |
| 5 | JOB_SERIAL | Job Serial Number Within Step | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | JOBCOUNT | Background Job ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | OPERATION | Operation Performed | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | JOBS | Number of Background Jobs Scheduled for a Step | int | 10 | 0 | | | | Allow NULL? |
| 9 | AVMS | Time Taken to Process One Record (in milliseconds/record) | decimal | 15 | 3 | | | | |
| 10 | THROUGHPUT | Throughput for a Job (recs/sec) | int | 10 | 0 | | | | Allow NULL? |
| 11 | STEP_THROUGHPUT | Step Throughput (in records/second) | int | 10 | 0 | | | | Allow NULL? |
| 12 | IDLE | CPU : Idle(%) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 13 | PAGING | Paging (Kb/s) | int | 10 | 0 | | | | Allow NULL? |
| 14 | CHKP | Checkpoint | int | 10 | 0 | | | | Allow NULL? |
| 15 | BATCH | Number of Active Background Work Processes | int | 10 | 0 | | | | Allow NULL? |
| 16 | WPTOT | Total Number of Active Work Processes | int | 10 | 0 | | | | Allow NULL? |
| 17 | RUNTIME | Run Time (in seconds) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | TEST_RECORDS | Number of Records Processed for Runtime Estimation | decimal | 15 | 0 | | | | |
| 19 | EST_RUNTIME | Estimated Run Time (in hours) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | EST_RECORDS | Total Number of Records Located for Analysis | decimal | 15 | 0 | | | | |
| 21 | LOGGED_DATE | | nvarchar | 8 | 0 | | | | Allow NULL? |