SETIDQS_ATTRIB_SET_IDQS_ATTRIB_VW(SQL View) |
Index Back |
|---|---|
Cse/Act/Def Column Headers |
| SELECT SETID , QS_ATTRIB_SET_ID , QS_ATTRIB_SET_NAME , QS_MOD_DATE , QS_MOD_BY , QS_ROW_COUNT , CSE_L1_NAME , CSE_L2_NAME , ACTN_L1_NAME , DFCT_L1_NAME , DFCT_L2_NAME , DFCT_L3_NAME FROM PS_QS_ATTRIB_SET |
| # | 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_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 |
| 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 |