QS_COLRT(SQL Table) |
Index Back |
|---|---|
Column Root Definitions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COLRT_ID |
Number(4,0) | SMALLINT NOT NULL | Column Type |
| 2 | COLRT_DESCR | Character(25) | VARCHAR2(25) NOT NULL | Description |
| 3 | COLRT_VAR_GROUP | Character(3) | VARCHAR2(3) NOT NULL |
Variable Group
0=Any 801=Traceability 802=Measurement 803=Attributes 804=Hiearchal 805=Ordinal 806=Configuration |
| 4 | COLRT_VAR_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Variable Type
0=Any 11=Character 12=Date 13=DateTime 14=Float 15=Integer 16=Time 20=Config 30=CSpec 31=HSpec 40=CLimit 41=HLimit 50=Subgroup 51=Sample 52=Size 60=Attribute 61=Defect 62=Ctl Test 63=Cause 64=Action 69=Tally |
| 5 | COLRT_ROW_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Row Type
1=Single 2=Multiple Default Value: 1 |
| 6 | COLRT_SELECT_VAR | Character(1) | VARCHAR2(1) NOT NULL |
Use in Select List
0=No 1=Yes Default Value: 1 |