DBA Data[Home] [Help] [Dependency Information]

TABLE: DDR.DDR_I_CAUSAL_CNDTN

Object Details
Object Name: DDR_I_CAUSAL_CNDTN
Object Type: TABLE
Owner: DDR
Subobject Name:
Status: VALID


Interface table to populate data in DDR_R_CAUSAL_CNDTN


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDR_I_CAUSAL_CNDTN_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREC_ID
Columns
Name Datatype Length Mandatory Comments
REC_ID NUMBER
Yes Record ID, uniquely identify each records.
ORG_CD VARCHAR2 (30)
Organization code
BSNS_UNIT_CD VARCHAR2 (30)
Business unit code
GEO_CD VARCHAR2 (30)
Geography code
CLNDR_DT DATE

Calendar Date
WEATHR_CNDTN VARCHAR2 (240)
Weather Condition details, It stores the weather conditions for a particular portion of the day such as snow, rain, high temperature
INTRNL_CNDTN VARCHAR2 (240)
It stores the internal conditions for a particular portion of the day such as partial flooding of the store; employee strike etc
EXTRNL_CNDTN VARCHAR2 (240)
It stores the external conditions for a particular portion of the day such as parking lot reconstruction, Flood, earthquake etc.
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REC_ID
,      ORG_CD
,      BSNS_UNIT_CD
,      GEO_CD
,      CLNDR_DT
,      WEATHR_CNDTN
,      INTRNL_CNDTN
,      EXTRNL_CNDTN
,      SRC_SYS_IDNT
,      SRC_SYS_DT
FROM DDR.DDR_I_CAUSAL_CNDTN;

Dependencies

[top of page]

DDR.DDR_I_CAUSAL_CNDTN does not reference any database object

DDR.DDR_I_CAUSAL_CNDTN is referenced by following:

SchemaAPPS
SynonymDDR_I_CAUSAL_CNDTN