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 |