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

TABLE: DDR.DDR_E_ORG_HCHY

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


Error table that stores error records from DDR_I_ORG_HCHY


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
REC_ID NUMBER
Yes Record ID, uniquely identify each records.
ORG_CD VARCHAR2 (30)
Organization code
CHAIN_CD VARCHAR2 (30)
Organization chain code
CHAIN_GLBL_LOC_ID VARCHAR2 (30)
Universally Unique Global Location ID for a Chain level of organization
CHAIN_GLBL_LOC_ID_TYP VARCHAR2 (30)
An indicator of the identification scheme used to assign the global Location ID.
CHAIN_NAME VARCHAR2 (40)
Organization chain name
CHAIN_MGR_NAME VARCHAR2 (40)
Organization chain manager name
AREA_CD VARCHAR2 (30)
Organization area code
AREA_GLBL_LOC_ID VARCHAR2 (30)
Universally Unique Global Location ID for a Area level of organization
AREA_GLBL_LOC_ID_TYP VARCHAR2 (30)
An indicator of the identification scheme used to assign the global Location ID.
AREA_NAME VARCHAR2 (40)
Organization area name
AREA_MGR_NAME VARCHAR2 (40)
Organization area manager name
RGN_CD VARCHAR2 (30)
Organization region code
RGN_GLBL_LOC_ID VARCHAR2 (30)
Universally Unique Global Location ID for a Region level of organization
RGN_GLBL_LOC_ID_TYP VARCHAR2 (30)
An indicator of the identification scheme used to assign the global Location ID.
RGN_NAME VARCHAR2 (40)
Organization region name
RGN_MGR_NAME VARCHAR2 (40)
Organization region manager name
DSTRCT_CD VARCHAR2 (30)
Organization district code
DSTRCT_GLBL_LOC_ID VARCHAR2 (30)
Universally Unique Global Location ID for a District level of organization
DSTRCT_GLBL_LOC_ID_TYP VARCHAR2 (30)
An indicator of the identification scheme used to assign the global Location ID. An indicator of the identification scheme used to assign the global Location ID.
DSTRCT_NAME VARCHAR2 (40)
Organization district name
DSTRCT_MGR_NAME VARCHAR2 (40)
Organization district manager name
BSNS_UNIT_CD VARCHAR2 (30)
Organization Business Unit code
BSNS_UNIT_GLBL_LOC_ID VARCHAR2 (30)
Universally Unique Global Location ID for a Business unit level of organization
BSNS_UNIT_GLBL_LOC_ID_TYP VARCHAR2 (30)
An indicator of the identification scheme used to assign the global Location ID.
BSNS_UNIT_NAME VARCHAR2 (40)
Organization Business Unit name
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
ERR_REASON VARCHAR2 (500) Yes Descriptive reason why the record failed validation and came in error table
ACTION_FLAG VARCHAR2 (1) Yes Flag indicating the status of error record and what needs to be done on it, possible values can be 'N/Y/D', N - Not corrected; Y- Corrected, ready for processing; D- to be deleted
LOAD_ID NUMBER
Yes Load ID is required for identifying each load records
Query Text

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


SELECT REC_ID
,      ORG_CD
,      CHAIN_CD
,      CHAIN_GLBL_LOC_ID
,      CHAIN_GLBL_LOC_ID_TYP
,      CHAIN_NAME
,      CHAIN_MGR_NAME
,      AREA_CD
,      AREA_GLBL_LOC_ID
,      AREA_GLBL_LOC_ID_TYP
,      AREA_NAME
,      AREA_MGR_NAME
,      RGN_CD
,      RGN_GLBL_LOC_ID
,      RGN_GLBL_LOC_ID_TYP
,      RGN_NAME
,      RGN_MGR_NAME
,      DSTRCT_CD
,      DSTRCT_GLBL_LOC_ID
,      DSTRCT_GLBL_LOC_ID_TYP
,      DSTRCT_NAME
,      DSTRCT_MGR_NAME
,      BSNS_UNIT_CD
,      BSNS_UNIT_GLBL_LOC_ID
,      BSNS_UNIT_GLBL_LOC_ID_TYP
,      BSNS_UNIT_NAME
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      ERR_REASON
,      ACTION_FLAG
,      LOAD_ID
FROM DDR.DDR_E_ORG_HCHY;

Dependencies

[top of page]

DDR.DDR_E_ORG_HCHY does not reference any database object

DDR.DDR_E_ORG_HCHY is referenced by following:

SchemaAPPS
SynonymDDR_E_ORG_HCHY