QS_ATTRIB_DEFN(SQL Table) |
Index Back |
---|---|
Attribute text values04/28/00 ST Added Related Lang Record 01/03/00 RRE Removed Related Lang Record-not translating attribute groups because they are used in the Quality Server which is not translated. When quality server gets translated, attributes can be. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | QS_ATTRIB_SET_ID | Number(5,0) | INTEGER NOT NULL | Attribute set ident |
3 | QS_ATTRIB_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Attribute component type code
151=Defect Comp 1 152=Defect Comp 2 153=Defect Comp 3 161=Cause Comp 1 162=Cause Comp 2 171=Action Comp |
4 | QS_ATTRIB_CD | Character(4) | VARCHAR2(4) NOT NULL | Attribute code (mnemonic) |
5 | QS_ATTRIB_TEXT | Character(36) | VARCHAR2(36) NOT NULL | Attribute text (value) |
6 | QS_ATTRIB_INACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Attribute inactive switch
Y/N Table Edit Default Value: N |