[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | DDR_B_SYND_CNSMPTN_DATA |
|---|---|
| Object Type: | TABLE |
| Owner: | DDR |
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| DDR_B_SYND_CNSMPTN_DATA_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 MEASURE_SET
SRC_CD
CHNL_TYP_CD
GEO_SUB_RGN_ID
GEO_RGN_ID
MKT_AREA_ID
MFG_ITM_HCHY_ID
RTL_ORG_CD
RTL_ORG_HCHY_ID
PERIOD_ID
AO_HCHY_CD
BSNS_ENT_CD
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SRC_CD | VARCHAR2 | (30) | A code representing the souce of the syndicated consumption data. For example, "IRI" or "ACNielsen". | |
| RTL_ORG_CD | VARCHAR2 | (30) | The retailer organization code to which the syndicated data measures are associated (if applicable). Syndicated data measures do not have to be associcated to a retailer. For example, they may be market area measures that span several retailers, in which case the retailer organization code would be null. | |
| RTL_ORG_HCHY_ID | NUMBER | The ID of the value within the organization hierarchy to which the syndicated data measures are associated (if applicable). For example, if the measures are associated with a retailer region called "Northwest". This field would contain the ID associated with the "Northwest" retailer region. | ||
| RTL_ORG_HCHY_LVL | VARCHAR2 | (30) | The level within the retail organization hiearchy to which the syndicated geography key is associated (if applicable). For example, Area, Chain, Region, District, etc. In some cases the syndicated geography key is not associated to a retailer, in which case this field would be null. | |
| MFG_ITM_HCHY_ID | NUMBER | The ID of the value within the manufacturer item hierarchy to which the syndicated data measures are associated (if applicable). For example, if the measures are associated with a product class called "tissues", this field would contain the ID associated with the "tissues" product class. | ||
| MFG_ITM_HCHY_LVL | VARCHAR2 | (30) | The level within the manufacturer item hierarchy to which the syndicated data measures are associated (if applicable). In some cases the syndicated data measures may not be product specific, in which case this field would be null. | |
| MKT_AREA_ID | NUMBER | The market area ID to which the syndicated data measures are associated (if applicable). | ||
| GEO_RGN_ID | NUMBER | The geographic region ID to which the syndicated data measures are associated (if applicable). | ||
| GEO_SUB_RGN_ID | NUMBER | The geographic sub-region ID to which the syndicated data measures are associated (if applicable). | ||
| CHNL_TYP_CD | VARCHAR2 | (30) | The channel type (e.g., "Grocery", "Drug", etc.) to which the syndicated data measures are associated (if applicable). | |
| PERIOD_ID | NUMBER | ID of the period end date provided in the interface table | ||
| TIME_HCHY_LVL | VARCHAR2 | (30) | The level within the manufacturer business calendar hierarchy to which the syndicated data measures are associated (if applicable). In some cases the syndicated data measures may not be date specific, in which case this field would be null. | |
| SRC_SYS_IDNT | VARCHAR2 | (40) | Yes | Source file name or system that provided the data. It can be used to cross-reference the data with the source system, mainly for auditing purpose |
| SRC_SYS_DT | DATE | Yes | The date that the data was created. It can be used to cross-reference the data with the source system, mainly for auditing purpose | |
| CRTD_BY_DSR | VARCHAR2 | (30) | Yes | User Information of who loaded the data, for auditing purpose |
| LAST_UPDT_BY_DSR | VARCHAR2 | (30) | Yes | User Information of last updated by, for auditing purpose |
| CREATED_BY | NUMBER | (15) | Yes | Number code of who last loaded the data, for auditing purpose |
| CREATION_DATE | DATE | Yes | Date on which the data was loaded in target table, for auditing purpose | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Number code of who last updated the data in target table, for auditing purpose |
| LAST_UPDATE_DATE | DATE | Yes | Date on which the data was last updated in target table, for auditing purpose | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Login ID of the User who last updated the data in target table, for auditing purpose |
| MEASURE_SET | VARCHAR2 | (30) | A name assigned to the following set of 100 measures (e.g., "IRI Measures"). If more than 100 measures are needed, or if different measures are received from different sources, additional measure set names can be created to load additional sets of 100 measures. For example, "IRI Measures", "ACN Measures", etc.) | |
| MEASURE1 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE2 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE3 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE4 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE5 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE6 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE7 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE8 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE9 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE10 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE11 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE12 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE13 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE14 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE15 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE16 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE17 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE18 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE19 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE20 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE21 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE22 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE23 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE24 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE25 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE26 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE27 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE28 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE29 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE30 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE31 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE32 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE33 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE34 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE35 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE36 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE37 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE38 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE39 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE40 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE41 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE42 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE43 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE44 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE45 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE46 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE47 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE48 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE49 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE50 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE51 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE52 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE53 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE54 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE55 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE56 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE57 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE58 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE59 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE60 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE61 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE62 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE63 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE64 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE65 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE66 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE67 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE68 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE69 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE70 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE71 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE72 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE73 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE74 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE75 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE76 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE77 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE78 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE79 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE80 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE81 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE82 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE83 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE84 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE85 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE86 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE87 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE88 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE89 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE90 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE91 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE92 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE93 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE94 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE95 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE96 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE97 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE98 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE99 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| MEASURE100 | NUMBER | A generic measure in which syndicated consumption data can be loaded into. | ||
| AO_HCHY_CD | VARCHAR2 | (30) | The Alternate Organization Hierarchy (AOH) to which the syndicated geography key is associated (if applicable). | |
| BSNS_ENT_CD | VARCHAR2 | (30) | The Alternate Organization Hierarchy (AOH) Account to which the syndicated geography key is associated (if applicable). | |
| PERIOD_END_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT SRC_CD
, RTL_ORG_CD
, RTL_ORG_HCHY_ID
, RTL_ORG_HCHY_LVL
, MFG_ITM_HCHY_ID
, MFG_ITM_HCHY_LVL
, MKT_AREA_ID
, GEO_RGN_ID
, GEO_SUB_RGN_ID
, CHNL_TYP_CD
, PERIOD_ID
, TIME_HCHY_LVL
, SRC_SYS_IDNT
, SRC_SYS_DT
, CRTD_BY_DSR
, LAST_UPDT_BY_DSR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MEASURE_SET
, MEASURE1
, MEASURE2
, MEASURE3
, MEASURE4
, MEASURE5
, MEASURE6
, MEASURE7
, MEASURE8
, MEASURE9
, MEASURE10
, MEASURE11
, MEASURE12
, MEASURE13
, MEASURE14
, MEASURE15
, MEASURE16
, MEASURE17
, MEASURE18
, MEASURE19
, MEASURE20
, MEASURE21
, MEASURE22
, MEASURE23
, MEASURE24
, MEASURE25
, MEASURE26
, MEASURE27
, MEASURE28
, MEASURE29
, MEASURE30
, MEASURE31
, MEASURE32
, MEASURE33
, MEASURE34
, MEASURE35
, MEASURE36
, MEASURE37
, MEASURE38
, MEASURE39
, MEASURE40
, MEASURE41
, MEASURE42
, MEASURE43
, MEASURE44
, MEASURE45
, MEASURE46
, MEASURE47
, MEASURE48
, MEASURE49
, MEASURE50
, MEASURE51
, MEASURE52
, MEASURE53
, MEASURE54
, MEASURE55
, MEASURE56
, MEASURE57
, MEASURE58
, MEASURE59
, MEASURE60
, MEASURE61
, MEASURE62
, MEASURE63
, MEASURE64
, MEASURE65
, MEASURE66
, MEASURE67
, MEASURE68
, MEASURE69
, MEASURE70
, MEASURE71
, MEASURE72
, MEASURE73
, MEASURE74
, MEASURE75
, MEASURE76
, MEASURE77
, MEASURE78
, MEASURE79
, MEASURE80
, MEASURE81
, MEASURE82
, MEASURE83
, MEASURE84
, MEASURE85
, MEASURE86
, MEASURE87
, MEASURE88
, MEASURE89
, MEASURE90
, MEASURE91
, MEASURE92
, MEASURE93
, MEASURE94
, MEASURE95
, MEASURE96
, MEASURE97
, MEASURE98
, MEASURE99
, MEASURE100
, AO_HCHY_CD
, BSNS_ENT_CD
, PERIOD_END_DATE
FROM DDR.DDR_B_SYND_CNSMPTN_DATA;
DDR.DDR_B_SYND_CNSMPTN_DATA does not reference any database object
DDR.DDR_B_SYND_CNSMPTN_DATA is referenced by following:
DDR
DDR_B_SYND_CNSMPTN_DATA#
|
|
|
|