| Table Name: | MPQualityProcessQuestions |
| View Name: | MARIQualityProcessQuestions |
| Group: | Group: QualityProcess |
| Description: | QualityProcess Definition Questionnaire |
| ClassID: | 384. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| QualityProcessQuestion | QualityProcessQuestion INT Primary |
||
| QualityProcess | QualityProcess INT Index |
MPQualityProcess.QualityProcess | |
| QuestionMode | QuestionMode INT |
||
| QuestionText | QuestionText NVARCHAR (200) Index |
||
| QuestionOrder | QuestionOrder INT |
||
| QuestionIndent | QuestionIndent INT |
||
| QuestionVisible | QuestionVisible SMALLINT |
||
| AnswerType | AnswerType INT |
||
| AnswerLength | AnswerLength INT |
||
| RetestOption | RetestOption INT |
||
| NumberFormat | NumberFormat INT Index |
||
| Unit | Unit NVARCHAR (10) |
||
| ValueRangeFrom | ValueRangeFrom NUMERIC(19,6) |
||
| ValueRangeTo | ValueRangeTo NUMERIC(19,6) |
||
| ValueListMemo | ValueListMemo NTEXT |
||
| ValueRangeMode | ValueRangeMode INT |
||
| DependencyID | DependencyID INT |
MPQualityProcessQuestions.QualityProcessQuestion | |
| DependencyType | DependencyType INT |
||
| ApprovalLevel1Mode | ApprovalLevel1Mode INT |
||
| ApprovalLevel1From | ApprovalLevel1From NUMERIC(19,6) |
||
| ApprovalLevel1To | ApprovalLevel1To NUMERIC(19,6) |
||
| ApprovalLevel2Mode | ApprovalLevel2Mode INT |
||
| ApprovalLevel2From | ApprovalLevel2From NUMERIC(19,6) |
||
| ApprovalLevel2To | ApprovalLevel2To NUMERIC(19,6) |
||
| AfterApprovalMethod | AfterApprovalMethod INT |
||
| DestinationField | DestinationField NVARCHAR (50) |
||
| QuestionInstructions1 | QuestionInstructions1 NTEXT |
||
| QuestionInstructions2 | QuestionInstructions2 NTEXT |
||
| QuestionPictureID | QuestionPictureID INT Index |
||
| ViewFieldName | ViewFieldName NVARCHAR (20) |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) |
| Table | Description |
|---|---|
| MPQualityProcessQuestions | QualityProcess Definition Questionnaire |
| MPQualityProcessResults | QualityProcess Result for each question of the questionaire |
| MPWorkItemResults | Results of quality process questionnaire |