QS_ATTRIB_SET

(SQL Table)
Index Back

Cse/Act/Def Column Headers

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 QS_ATTRIB_SET_ID Number(5,0) INTEGER NOT NULL Attribute set ident

Default Value: 1

3 QS_ATTRIB_SET_NAME Character(18) VARCHAR2(18) NOT NULL Attribute set name
4 QS_MOD_DATE DateTime(26) TIMESTAMP General modification date for record change tracking
5 QS_MOD_BY Character(30) VARCHAR2(30) NOT NULL Modified by "operator"
6 QS_ROW_COUNT Number(7,0) INTEGER NOT NULL Number of managed (child) rows

Default Value: 0

7 CSE_L1_NAME Character(24) VARCHAR2(24) NOT NULL Cause Component 1
8 CSE_L2_NAME Character(24) VARCHAR2(24) NOT NULL Cause Component 2
9 ACTN_L1_NAME Character(24) VARCHAR2(24) NOT NULL Corrective Action
10 DFCT_L1_NAME Character(24) VARCHAR2(24) NOT NULL Defect Component 1
11 DFCT_L2_NAME Character(24) VARCHAR2(24) NOT NULL Defect Component 2
12 DFCT_L3_NAME Character(24) VARCHAR2(24) NOT NULL Defect Component 3