| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | JOBNAME | Background job name | nvarchar | 32 | 0 | CHAR | (N' ') | No | | BTCJOB | Allow NULL? |
| 2 | JOBCOUNT | Job ID | nvarchar | 8 | 0 | CHAR | (N' ') | No | | BTCJOBCNT | Allow NULL? |
| 3 | JOBGROUP | Summary of jobs for a group | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BTCJOBGRP | Allow NULL? |
| 4 | INTREPORT | Name of internal report for batch job | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BTCREP | Allow NULL? |
| 5 | SDLUNAME | Initiator of job/step scheduling | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BTCSDLNM | Allow NULL? |
| 6 | AUTHCKNAM | Background User Name for Authorization Check | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BTCAUTHNAM | Allow NULL? |
| 7 | AUTHCKMAN | Background client for authorization check | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | * | BTCAUTHMAN | Allow NULL? |
| 8 | SUCCNUM | Number of successor job(s) | int | 10 | 0 | INT4 | ((0)) | Yes | | BTCSNUM | Allow NULL? |
| 9 | DELANFREP | Job deletion indicator after processing | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCDELFLAG | Allow NULL? |
| 10 | SDLFLAG | Batch scheduler ID | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCSDLFLAG | Allow NULL? |
| 11 | STEPCOUNT | Job step ID number. | int | 10 | 0 | INT4 | ((0)) | Yes | | BTCSTEPCNT | Allow NULL? |
| 12 | XPGACTIVE | Flag for step executed by external program | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCXPGFLAG | Allow NULL? |
| 13 | JOBLOG | TemSe object name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | RSTSONAME | Allow NULL? |
| 14 | EVENTID | Background Processing Event | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BTCEVENTID | Allow NULL? |
| 15 | EVENTPARM | Background Event Parameters (Such as, Jobname/Jobcount) | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | BTCEVTPARM | Allow NULL? |
| 16 | JOBCLASS | Job classification | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCJOBCLAS | Allow NULL? |
| 17 | PRIORITY | Job priority | int | 10 | 0 | INT4 | ((0)) | Yes | | BTCJOBPRIO | Allow NULL? |
| 18 | STATUS | State of Background Job | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCSTATUS | Allow NULL? |
| 19 | XPGTERMCTL | Control flag for external program (e.g. trace level) | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCXPGCNTL | Allow NULL? |
| 20 | STEPFLAG | Flag indicates start of new job step | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCSTPFLAG | Allow NULL? |
| 21 | CREADATE | Planned Start Date for Background Job | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BTCSDATE | Allow NULL? |
| 22 | CREATIME | Planned start time for background Job | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BTCSTIME | Allow NULL? |
| 23 | EXECSERVER | Server name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BTCSRVNAME | Allow NULL? |
| 24 | TGTSRVGRP | Server Group Name Background Processing | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BPSRVGRPN | Allow NULL? |
| 25 | REAXSERVER_1 | Server name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BTCSRVNAME | Allow NULL? |
| 26 | REAXSERVER_2 | Server name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BTCSRVNAME | Allow NULL? |
| 27 | REAXSERVER_LAST | Server name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BTCSRVNAME | Allow NULL? |
| 28 | LASTCHDATE | Planned Start Date for Background Job | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BTCSDATE | Allow NULL? |
| 29 | LASTCHTIME | Planned start time for background Job | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BTCSTIME | Allow NULL? |
| 30 | NROFTRIES | Natural Number | int | 10 | 0 | INT4 | ((0)) | Yes | | INT4 | Allow NULL? |
