IMP_IT_PROP_VW

(SQL View)
 Index Back

Mapper for Oracle config.

This record maps to CZ_IMP_ITEM_PROPERTY_VALUE record in eBIZ database.

SELECT SETID , ATTRIBUTE_ID , ('PKG' %Concat ':' %Concat PRODUCT_ID) , ATTR_ITEM_ID , ATTRIBUTE_VALUE , CASE WHEN ATTR_ITEM_VALUE IS NULL THEN ATTRIBUTE_VALUE ELSE ATTR_ITEM_VALUE END , DEFAULT_FLG , ATTRIBUTE_ID , PRODUCT_ID , (ATTRIBUTE_ID %Concat ':' %Concat PRODUCT_ID) , CZ_SEQUENCE_NUM , 708 FROM PS_IMP_IT_PROP_VAL A , PS_CZ_SEQUENCE_NUM B WHERE CZ_SEQUENCE_NUM = ( SELECT MAX(CZ_SEQUENCE_NUM) FROM PS_CZ_SEQUENCE_NUM) AND PRODUCT_ID IN ( SELECT PRODUCT_ID FROM PS_PROD_PGRP_LNK WHERE PROD_GRP_TYPE='CZ')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
2 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties
3 CZ_PRODUCT_ID Character(35) VARCHAR2(35) NOT NULL Oracle eBIZ configurator Product Identifier field.
4 ATTR_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Attribute Item ID
5 ATTRIBUTE_VALUE Character(254) VARCHAR2(254) NOT NULL Attribute value
6 CZ_ATTR_DEF_VAL Character(254) VARCHAR2(254) NOT NULL Attribute default value for eBIZ CZ table IMP_PROPERTY.
7 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag

Y/N Table Edit

Default Value: N

8 CZ_FSK_PROPERTY_1 Character(30) VARCHAR2(30) NOT NULL Foreign Surrogate key for Oracle Configurator Interface tables in eBIZ database.
9 CZ_FSK_ITEMMASTER Character(30) VARCHAR2(30) NOT NULL Foreign Surrogate key for Oracle Configurator Interface tables in eBIZ database.
10 ORIG_SYS_REF Character(100) VARCHAR2(100) NOT NULL CDH INTERFACE TABLE FIELD - ORIG_SYSTEM_REFERENCE
11 CZ_RUN_ID Number(30,0) DECIMAL(30) NOT NULL Oracle Configurator field RUN_ID in Oracle eBIZ database.
12 CZ_SRC_APPLICATION Number(3,0) SMALLINT NOT NULL Oracle Configurator interface table field in eBIZ database.