Name Type MSSql Type Oracle Type DB2 Nullable Description
LAH_System varchar (8) VARCHAR2 (8 CHAR) varchar(8) false UC4 system name
LAH_Date varchar (6) VARCHAR2 (6 CHAR) varchar(6) false YYYYMM
LAH_Type varchar (8) VARCHAR2 (8 CHAR) varchar(8) false Type (DC,HOST,JOBS,OBJ,GLOB,SERV)
LAH_Name varchar (32) VARCHAR2 (32 CHAR) varchar(32) false Name (DC,rem.System,Host,Objecttype)
LAH_Platform varchar (32) VARCHAR2 (32 CHAR) varchar(32) false Platform
LAH_Hardware varchar (32) VARCHAR2 (32 CHAR) varchar(32) false hardware
LAH_LicClassUsed char (1) CHAR (1 CHAR) char(1) false used license class
LAH_LicCategory varchar (32) VARCHAR2 (32 CHAR) varchar(32) false license category
LAH_Restriction varchar (250) VARCHAR2 (250 CHAR) varchar(250) true license restriction (e.g. 5 jobs/day)
LAH_LicClassNec char (1) CHAR (1 CHAR) char(1) true necessary license class
LAH_Checksum varchar (32) VARCHAR2 (32 CHAR) varchar(32) true checksum
LAH_Count1 int NUMBER(38,0) int true used count 1 (jobs/DC's,def Objects,used Server)
LAH_Count2 int NUMBER(38,0) int true used count 2 (filetransfer)
LAH_Count3 int NUMBER(38,0) int true used count 3 (event)
LAH_Count4 int NUMBER(38,0) int true used count 4 (max. used processors/max. used users)
LAH_Count5 int NUMBER(38,0) int true used count 5 (reserved)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_LAH LAH_System, LAH_Date, LAH_Type, LAH_Name, LAH_Platform, LAH_Hardware, LAH_LicClassUsed, LAH_LicCategory true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File