QS_ATTRIB_DEFN

(SQL Table)
Index Back

Attribute text values

04/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