| Table Name: | MPSysClassInfoQuery |
| View Name: | MARISysClassInfoQuery |
| Group: | |
| Description: | Query user tables for employee / individual information |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| InfoQueryID | InfoQueryID INT Primary |
||
| BaseClassID | BaseClassID INT Index |
ClassID | |
| UseTypeFlag | UseTypeFlag SMALLINT Index |
||
| GroupName | GroupName NVARCHAR (100) |
||
| GroupNameID | GroupNameID INT |
||
| InfoQueryOrder | InfoQueryOrder INT Index |
||
| DimensionName | DimensionName NVARCHAR (100) |
||
| DimensionNameID | DimensionNameID INT Index |
||
| DimensionNameID2 | DimensionNameID2 INT |
||
| DimensionClassID | DimensionClassID INT Index |
ClassID | |
| DimensionPictureID | DimensionPictureID INT Index |
||
| ShowOption | ShowOption INT |
||
| ConnectionType | ConnectionType INT |
||
| QueryCount | QueryCount NTEXT |
||
| QueryInfo | QueryInfo NTEXT |
||
| QueryFrom | QueryFrom NTEXT |
||
| Description | Description NVARCHAR (255) |
||
| DescriptionID | DescriptionID INT |
||
| Module | Module INT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |