The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
These are here for reference. Note that MUL beside multiple columns refers to a composite key.
JobRecords Table
ColumnName
|
Type
|
Null
|
Key
|
Default
|
Normalised
|
Indexed
|
UpdateTime |
TimeStamp |
Auto |
|
|
|
|
Site |
varchar(255) |
No |
|
|
Yes |
Yes
|
SubmitHost |
varchar(255) |
No |
MUL |
|
Yes |
|
MachineName |
varchar(255) |
No |
|
|
Yes |
|
Queue |
varchar(255) |
No |
|
|
Yes |
|
LocalJobId |
varchar(255) |
No |
MUL |
|
|
|
LocalUserId |
varchar(255) |
|
|
|
|
|
GlobalUserName |
varchar(255) |
No |
|
'None' |
Yes |
Yes
|
FQAN |
varchar(255) |
|
|
|
|
|
VO |
varchar(255) |
No |
|
'None' |
Yes |
Yes
|
VOGroup |
varchar(255) |
No |
|
'None' |
Yes |
Yes
|
VORole |
varchar(255) |
No |
|
'None' |
Yes |
Yes
|
WallDuration |
bigint |
|
|
|
|
|
CpuDuration |
bigint |
|
|
|
|
|
Processors |
int |
No |
|
0 |
|
|
NodeCount |
int |
No |
|
0 |
|
|
StartTime |
datetime |
No |
|
|
|
|
EndTime |
datetime |
No |
MUL |
|
|
|
InfrastructureDescription |
varchar(255) |
|
|
|
|
|
InfrastructureType |
varchar(20) |
|
|
|
|
|
MemoryReal |
bigint |
|
|
|
|
|
MemoryVirtual |
bigint |
|
|
|
|
|
ServiceLevelType |
varchar(50) |
No |
|
|
|
|
ServiceLevel |
decimal |
No |
|
|
|
|
Summaries Table
ColumnName
|
Type
|
Null
|
Key
|
Default
|
Normalised
|
UpdateTime |
TimeStamp |
Auto |
|
|
|
Site |
varchar(255) |
No |
MUL |
|
Yes
|
Month |
int |
No |
MUL |
|
|
Year |
int |
No |
MUL |
|
|
GlobalUserName |
varchar(255) |
No |
MUL |
'None' |
Yes
|
VO |
varchar(255) |
No |
MUL |
'None' |
Yes
|
VOGroup |
varchar(255) |
No |
MUL |
'None' |
Yes
|
VORole |
varchar(255) |
No |
MUL |
'None' |
Yes
|
SubmitHost |
varchar(255) |
Yes |
|
|
|
InfrastructureType |
varchar(255) |
Yes |
|
|
|
NodeCount |
int |
No |
|
0 |
|
Processors |
int |
No |
|
0 |
|
EarliestEndTime |
datetime |
|
|
|
|
LatestEndTime |
datetime |
|
|
|
|
WallDuration |
int |
No |
|
|
|
CpuDuration |
int |
No |
|
|
|
NormalisedWallDuration |
int |
No |
|
|
|
NormalisedCpuDuration |
int |
No |
|
|
|
NumberOfJobs |
int |
No |
|
|
|
Sync Table
ColumnName
|
Type
|
Null
|
Key
|
Default
|
Normalised
|
UpdateTime |
TimeStamp |
Auto |
|
|
|
Site |
varchar(255) |
No |
MUL |
|
Yes
|
SubmitHost |
varchar(255) |
No |
MUL |
|
Yes
|
NumberOfJobs |
int |
No |
|
|
|
Month |
int |
No |
MUL |
|
|
Year |
int |
No |
MUL |
|
|
HepSpecHistory View
ColumnName
|
Type
|
Key
|
UpdateTime |
TimeStamp |
|
Site |
varchar(255) |
MUL
|
HepSpec06 |
int |
MUL
|
NumberOfJobs |
int |
|
Month |
int |
MUL
|
Year |
int |
MUL
|
EarliestEndDate |
date |
|
LatestEndDate |
date |
|