QS_CAT_HIER_VW(SQL View) |
Index Back |
|---|---|
List hierarchal type fields |
| SELECT A.CAT_FIELDNAME , A.CAT_ID , A.CAT_DESCR , A.QS_PROMPT_TBL , A.QS_FIELD_OWNER_CD , A.QS_FLD_LABEL_CD , A.CAT_RESTRICTS_CD , A.QS_ACTIVE FROM PS_QS_CATALOG A , PS_QS_COLRT B WHERE A.CAT_RESTRICTS_CD NOT IN ('TRAC') AND A.COLRT_ID = B.COLRT_ID AND B.COLRT_VAR_GROUP = '801' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CAT_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Name of object field used in catalog |
| 2 | CAT_ID | Number(3,0) | SMALLINT NOT NULL | ID of catalog field |
| 3 | CAT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Catalog Field Description |
| 4 | QS_PROMPT_TBL | Character(24) | VARCHAR2(24) NOT NULL | Validation table/view name |
| 5 | QS_FIELD_OWNER_CD | Character(4) | VARCHAR2(4) NOT NULL |
Application owner - code specifying which PeopleSoft application originates/maintains the catalog field
CP=Product Configurator DP=Demand Planning EG=Engineering EP=Enterprise Planning HR=Human Resources INV=Inventory MG=Manufacturing OM=Order Management PL=Production Planning PO=Purchasing QS=Quality USER=User Defined |
| 6 | QS_FLD_LABEL_CD | Character(4) | VARCHAR2(4) NOT NULL |
Select field label type for display - short or long
LONG=Long SHRT=Short |
| 7 | CAT_RESTRICTS_CD | Character(4) | VARCHAR2(4) NOT NULL |
Restrictions code for limiting use of qs catalog fields- currently (01/2000) the choices are Hierarchy, Trace and Inactive. HIER means that the field can be used as both hierarhcy OR Trace. TRAC means that the field can be used as Trace ONLY. Developer: RRE
HIER=Hierarchy Only IN=Inactive TRAC=Traceability Only |
| 8 | QS_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active Switch
N=Inactive X=Do not use in Search Y=Active |