Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
LASLM_Client smallint NUMBER(38,0) smallint smallint true number of the client
LASLM_AH_Idnr int NUMBER(38,0) int int false reference to AH of SLO
LASLM_SloName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true SLO object name
LASLM_ServName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Service object name
LASLM_ServOType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Service object type
LASLM_ServRunId int NUMBER(38,0) int int true Service RunId
LASLM_ServFStatus int NUMBER(38,0) int int true Service fulfillment status/ status message number
LASLM_ServMsgNr int NUMBER(38,0) int int true reason of violation
LASLM_ServMsgIns varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true message insert
LASLM_ServOH_Idnr int NUMBER(38,0) int int true reference to OH of service object
LASLM_DetectTime datetime DATE timestamp timestamp true Fulfillment detection time
LASLM_Idnr int NUMBER(38,0) int int false Auto increment field as primary key
LASLM_Date datetime DATE timestamp timestamp true date, used to check if there is already an entry for a certain day. Contains only the date, no time
LASLM_OH_Idnr int NUMBER(38,0) int int true OH_Idnr of the SLO objec
LASLM_LastUpdate datetime DATE timestamp timestamp true Timestamp updated whenever a row is changed in LASLM to help analytics to identify new data

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_LASLM LASLM_Idnr true true true false
NK_LASLM_DetectTime LASLM_DetectTime false false false false
NK_LASLM_ServRunId LASLM_ServRunId false false false false
NK_LASLM_SloName LASLM_SloName false false false false

Foreign Keys:

Name Local References Foreign References

Return to the Index File