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

TABLE: DDR.DDR_I_ORG

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


Interface table to populate data in DDR_R_ORG


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDR_I_ORG_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.
MFG_ORG_CD VARCHAR2 (30)
Manufacture Organization code
ORG_CD VARCHAR2 (30)
Organization code
ORG_TYP VARCHAR2 (30)
Organization type (retailer/manufacturer/competitor)
GLBL_LOC_ID VARCHAR2 (30)
Global location ID
GLBL_LOC_ID_TYP VARCHAR2 (30)
Global location ID type
ORG_NAME VARCHAR2 (40)
Organization name
SIC_CD VARCHAR2 (30)
Standard Industrial Classification code
SHORT_DESC VARCHAR2 (240)
Organization description
LONG_DESC VARCHAR2 (240)
Organization description
SCNDRY_DESC VARCHAR2 (240)
Organization description
WEB_SITE_URL VARCHAR2 (240)
Web site URL of Organization
PRMRY_CRNCY_CD VARCHAR2 (30)
currency code of organization
PRMRY_LANG VARCHAR2 (40)
Language of organization
ESTBD_DT DATE

Date of establishment of organization
CNTCT_NBR VARCHAR2 (30)
organization contact number
CNTCT_TYP VARCHAR2 (30)
organization contact type
CNTCT_NAME VARCHAR2 (40)
Name of the contact person of Organization
CNTCT_EMAIL VARCHAR2 (240)
E-mail address of Organization
CNTCT_PHONE VARCHAR2 (30)
organization phone number
FRNCHSE_CD VARCHAR2 (30)
Franchise Code
INDSTRY_SPFC_CD VARCHAR2 (30)
Industry specific code
DUNS_NBR VARCHAR2 (30)
Data Universal Numbering System is a unique nine-digit numbering system that is used to identify a business.
CR_RTNG_CD VARCHAR2 (30)
Credit Rating Code
INDVL_FIRM_CD VARCHAR2 (30)
Individual firm code
FIRST_APPEAR_YR NUMBER

The year when the product first launch in the market
DB_ADD_DT DATE

Date the organization was added to the database
SLS_VOL_CD VARCHAR2 (30)
Unique code of sales volume
PUB_IND VARCHAR2 (1)
Indicates whether company is public or not
STCK_EXCHNG_CD VARCHAR2 (30)
Stock Exchange Code
STCK_TCKR_SYMBL VARCHAR2 (30)
Stock Ticker Symbol
FICO_SCR VARCHAR2 (40)
FICO Score
TOT_EMP_SZ NUMBER

Total number of employee
FULL_TIME_EMP_EQVLNTS NUMBER

Total number of full time employees all employees equal (full and part time)
NBR_OF_STORES NUMBER

Total number of store of the organization
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
,      MFG_ORG_CD
,      ORG_CD
,      ORG_TYP
,      GLBL_LOC_ID
,      GLBL_LOC_ID_TYP
,      ORG_NAME
,      SIC_CD
,      SHORT_DESC
,      LONG_DESC
,      SCNDRY_DESC
,      WEB_SITE_URL
,      PRMRY_CRNCY_CD
,      PRMRY_LANG
,      ESTBD_DT
,      CNTCT_NBR
,      CNTCT_TYP
,      CNTCT_NAME
,      CNTCT_EMAIL
,      CNTCT_PHONE
,      FRNCHSE_CD
,      INDSTRY_SPFC_CD
,      DUNS_NBR
,      CR_RTNG_CD
,      INDVL_FIRM_CD
,      FIRST_APPEAR_YR
,      DB_ADD_DT
,      SLS_VOL_CD
,      PUB_IND
,      STCK_EXCHNG_CD
,      STCK_TCKR_SYMBL
,      FICO_SCR
,      TOT_EMP_SZ
,      FULL_TIME_EMP_EQVLNTS
,      NBR_OF_STORES
,      SRC_SYS_IDNT
,      SRC_SYS_DT
FROM DDR.DDR_I_ORG;

Dependencies

[top of page]

DDR.DDR_I_ORG does not reference any database object

DDR.DDR_I_ORG is referenced by following:

SchemaAPPS
SynonymDDR_I_ORG