Job History table
Store job history records
| Column Name | Column Datatype | Column Null Option | Column Comment |
| jhr_jschd | char(65) | not null | Jobset name |
| jhr_name | char(65) | not null | Jobset name |
| jhr_jno | char(5) | not null | Job number |
| jhr_key | char(12) | not null | Record timestamp |
| jhr_ws | varchar(21) | with null | Station id |
| jhr_avcpu | integer | with null | Average cpu time |
| jhr_hcnt | smallint | with null | History instance count |
| jhr_erdt | integer | with null | Early date |
| jhr_msdt | integer | with null | Must start date |
| jhr_deddt | integer | with null | Must complete date |
| jhr_adate | integer | with null | Scheduled date |
| jhr_vdate | integer | with null | Available date |
| jhr_sdate | integer | with null | Actual start date |
| jhr_edate | integer | with null | Actual end date |
| jhr_ertm | integer | with null | Early time |
| jhr_mstm | integer | with null | Must start date |
| jhr_dedtm | integer | with null | Must complete date |
| jhr_atime | integer | with null | Scheduled time |
| jhr_vtime | integer | with null | Available time |
| jhr_stime | integer | with null | Actual start time |
| jhr_etime | integer | with null | Actual end time |
| jhr_relpt | integer | with null | Elapsed time in seconds |
| jhr_rcput | integer | with null | CPU time |
| jhr_code | integer | with null | Completion code |
| jhr_qual | char(4) | with null | Qualifier |
| jhr_stat | byte(1) | with null | Completion status |
| jhr_late | char(1) | with null | Late status |
| jhr_cmrun | varchar(33) | with null | Submitting userid |
| jhr_cmhld | varchar(33) | with null | Hold status |
| jhr_cmrls | varchar(33) | with null | Release userid |
| jhr_cmcnc | varchar(33) | with null | Cancel userid |
| jhr_cmfrc | varchar(33) | with null | Force userid |
| jhr_cmstr | varchar(33) | with null | Begin userid |
| jhr_cmcmp | varchar(33) | with null | End userid |
| jhr_pid | integer | with null | Process id |
| jhr_uxjno | integer | with null | Extended job number |
| jhr_sysid | varchar(65) | with null | System id |
| jhr_avelp | integer | with null | Average elapsed time in seconds |
| jhr_qname | char(2) | with null | Queue name |
Product Name: Unicenter Network and System Management/EnterpriseManagement
Table Type: Table