CFG_RQST_FVW1 (SQL View)	Index Back
Configurator Configurator

CFG_RQST_FVW1

(SQL View)

Configurator

SELECT CFG_SCHEMA_ID , CFG_SECTION_ID ,CFG_OBJECT_TYPE , CFG_OBJECT_NAME FROM PS_CFG_RQST_FILTER WHERE CFG_OBJECT_TYPE = '01'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CFG_SCHEMA_ID Character(18) VARCHAR2(18) NOT NULL Schema ID displayed on several pages of Configurator

2 CFG_SECTION_ID Number(5,0) INTEGER NOT NULL This field holds the unique section number for each section of a schema.

3 CFG_OBJECT_TYPE Character(2) VARCHAR2(2) NOT NULL Configurator
01=Selection
02=Expression
03=Configuration Attribute
04=External Variable
05=Connections
06=Component
07=Connections
08=Selections Filtered List
09=Selections Filter Where
10=Selections Attributes
11=Package Components
12=Manufactured Components
13=Routing Operations
14=Purchased Components
15=Product Selector
Default Value: 01

4 CFG_OBJECT_NAME Character(64) VARCHAR2(64) NOT NULL Attribute name column on Configurator Output tab and Price tabs

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CFG_SCHEMA_ID	Character(18)	VARCHAR2(18) NOT NULL	Schema ID displayed on several pages of Configurator
2	CFG_SECTION_ID	Number(5,0)	INTEGER NOT NULL	This field holds the unique section number for each section of a schema.
3	CFG_OBJECT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Configurator 01=Selection 02=Expression 03=Configuration Attribute 04=External Variable 05=Connections 06=Component 07=Connections 08=Selections Filtered List 09=Selections Filter Where 10=Selections Attributes 11=Package Components 12=Manufactured Components 13=Routing Operations 14=Purchased Components 15=Product Selector Default Value: 01
4	CFG_OBJECT_NAME	Character(64)	VARCHAR2(64) NOT NULL	Attribute name column on Configurator Output tab and Price tabs