QS_COLRT_VW

(SQL View)
 Index Back

View of all Column root

Used in Cache Update

SELECT COLRT_ID , colrt_version , COLRT_DESCR , COLRT_VAR_GROUP , COLRT_VAR_TYPE , COLRT_ROW_TYPE , COLRT_SELECT_VAR FROM PS_QS_COLRT , ps_qs_version

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COLRT_ID Number(4,0) SMALLINT NOT NULL Column Type
2 COLRT_VERSION Number(6,0) INTEGER NOT NULL Column Root
3 COLRT_DESCR Character(25) VARCHAR2(25) NOT NULL Description
4 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
5 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
6 COLRT_ROW_TYPE Character(1) VARCHAR2(1) NOT NULL Row Type
1=Single
2=Multiple

Default Value: 1

7 COLRT_SELECT_VAR Character(1) VARCHAR2(1) NOT NULL Use in Select List
0=No
1=Yes

Default Value: 1