| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | BATCH_GUID | Unique Identifier (GUID22) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | CACS_GUID_22 | Allow NULL? |
| 2 | GUID | Unique Identifier (GUID22) | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | CACS_GUID_22 | Allow NULL? |
| 3 | TASK_STATUS | Patch Manager: Status of Task | char | 1 | 0 | CHAR | (N' ') | Yes | | CACS_PATCH_TASK_STATUS | Allow NULL? |
| 4 | TASK_TYPE | Patch Manager: Type of Task | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CACS_PATCH_TASK_TYPE | Allow NULL? |
| 5 | EVENT | Patch Manager: Execution Time | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CACS_PATCH_STEP_EVENT | Allow NULL? |
| 6 | JOBNAME | Background job name | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BTCJOB | Allow NULL? |
| 7 | JOBCOUNT | Job ID | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | BTCJOBCNT | Allow NULL? |
| 8 | LOG_HANDLE | Application Log: Log Handle | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | BALLOGHNDL | Allow NULL? |
| 9 | CHG_TCODE | Transaction in Which the Change Was Made | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | CACSCDTC | Allow NULL? |
| 10 | CHG_USR | Last user to change object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CACSCHUSR | Allow NULL? |
| 11 | CHG_TIMESTAMP | Creation Time Stamp of Object | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACSCHGTSTMP | Allow NULL? |
| 12 | CREATE_TIMESTAMP | Patch Manager: Creation Time | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACS_PATCH_TASK_CREATETIME | Allow NULL? |
| 13 | CREATE_USER | Patch Manager: Creator | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CACS_PATCH_TASK_CREATEUSER | Allow NULL? |
| 14 | START_TIMESTAMP | Patch Manager: Start Time | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACS_PATCH_TASK_STARTTIME | Allow NULL? |
| 15 | START_USER | Patch Manager: Executor of Task | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CACS_PATCH_TASK_STARTUSER | Allow NULL? |