IMP_PROP_PRI_VW

(SQL View)
 Index Back

Attribute mapper record

eCRM Attribute mapper record maps to CZ_IMP_PROPERTY record in eBIZ db, Stores hardcoded values for List Price and Recurring Price.

SELECT MARKET , ATTRIBUTE_ID , ATTR_NAME , ATTR_STATUS , ATTR_FIELD_TYPE , ATTR_DATA_TYPE , ATTR_LENGTH , ATTR_DECIMALS , ATTR_DEFAULT_VAL , CZ_ATTR_DEF_VAL , ATTR_DEFAULT_NBR , ATTR_DEFAULT_DATE , DESCR60 , ORIG_SYS_REF , CZ_SRC_APPLICATION , CZ_SEQUENCE_NUM , %subrec(RB_AUDIT_SBR, A) FROM PS_IMP_PROP_PRI_TB A , PS_CZ_SEQUENCE_NUM B WHERE CZ_SEQUENCE_NUM = ( SELECT MAX(CZ_SEQUENCE_NUM) FROM PS_CZ_SEQUENCE_NUM)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Default Value: OPR_DEF_TBL_RB.MARKET

2 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties
3 ATTR_NAME Character(30) VARCHAR2(30) NOT NULL Attribute name
4 ATTR_STATUS Character(4) VARCHAR2(4) NOT NULL Attribute status
ACTV=Active
INCT=Inactive

Default Value: ACTV

5 ATTR_FIELD_TYPE Character(4) VARCHAR2(4) NOT NULL Attribute field type
DRDN=Drop-Down
EDIT=Edit Box
LOOK=Prompt Lookup

Default Value: EDIT

6 ATTR_DATA_TYPE Character(4) VARCHAR2(4) NOT NULL Attribute data type
DATE=Date
NMBR=Number
PSWD=Password
STR=String
7 ATTR_LENGTH Character(4) VARCHAR2(4) NOT NULL carry the length in characters of the attribute
10=10
20=20
30=30
40=40
50=50
60=60
LONG=Long
8 ATTR_DECIMALS Character(1) VARCHAR2(1) NOT NULL holds the number of decimals for attributes
0=0
1=1
2=2
3=3
4=4
5=5
6=6
9 ATTR_DEFAULT_VAL Character(254) VARCHAR2(254) NOT NULL Attribute default value
10 CZ_ATTR_DEF_VAL Character(254) VARCHAR2(254) NOT NULL Attribute default value for eBIZ CZ table IMP_PROPERTY.
11 ATTR_DEFAULT_NBR Number(29,6) DECIMAL(28,6) NOT NULL default number for attributes application
12 ATTR_DEFAULT_DATE Date(10) DATE default date for attributes application
13 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
14 ORIG_SYS_REF Character(100) VARCHAR2(100) NOT NULL CDH INTERFACE TABLE FIELD - ORIG_SYSTEM_REFERENCE
15 CZ_SRC_APPLICATION Number(3,0) SMALLINT NOT NULL Oracle Configurator interface table field in eBIZ database.
16 CZ_RUN_ID Number(30,0) DECIMAL(30) NOT NULL Oracle Configurator field RUN_ID in Oracle eBIZ database.
17 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
18 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
19 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
20 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
21 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
22 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time