CFG_SAMPLE_DATA

(SQL Table)
 Index Back

Generic configurator info

Generic information used to drive configuration models. This record can drive multiple models, all within the same structure. Add more generic columns as necessary.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MODEL Character(30) VARCHAR2(30) NOT NULL Model
2 CATEGORY_NAME Character(15) VARCHAR2(15) NOT NULL Product Category
3 SHORT_NAME Character(50) VARCHAR2(50) NOT NULL
4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
5 LONG_DESCRIPTION Character(254) VARCHAR2(254) NOT NULL
6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
7 INT_PROP1 Number(6,0) INTEGER NOT NULL
8 INT_PROP2 Number(6,0) INTEGER NOT NULL
9 STRING_PROP1 Character(254) VARCHAR2(254) NOT NULL
10 STRING_PROP2 Character(254) VARCHAR2(254) NOT NULL
11 FLOAT1 Number(11,2) DECIMAL(10,2) NOT NULL
12 FLOAT2 Number(11,2) DECIMAL(10,2) NOT NULL
13 FLOAT3 Number(11,2) DECIMAL(10,2) NOT NULL
14 FLOAT4 Number(11,2) DECIMAL(10,2) NOT NULL
15 FLOAT5 Number(11,2) DECIMAL(10,2) NOT NULL
16 SORT_ORDER_NUM Number(3,0) SMALLINT NOT NULL Field to capture the sort order number.
17 DESCR254_CFR Character(254) VARCHAR2(254) NOT NULL Description of length 254
18 DESCR254_DUT Character(254) VARCHAR2(254) NOT NULL Description of length 254
19 DESCR254_ESP Character(254) VARCHAR2(254) NOT NULL Description of length 254
20 DESCR254_FRA Character(254) VARCHAR2(254) NOT NULL Description of length 254
21 DESCR254_GER Character(254) VARCHAR2(254) NOT NULL Description of length 254
22 DESCR254_ITA Character(254) VARCHAR2(254) NOT NULL Description of length 254
23 DESCR254_JPN Character(254) VARCHAR2(254) NOT NULL Description of length 254
24 DESCR254_KOR Character(254) VARCHAR2(254) NOT NULL Description of length 254
25 DESCR254_SVE Character(254) VARCHAR2(254) NOT NULL Description of length 254
26 DESCR254_ZHS Character(254) VARCHAR2(254) NOT NULL Description of length 254