eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGW.IGW_ORG_DETAILS

Object Details

Object Name:	IGW_ORG_DETAILS
Object Type:	TABLE
Owner:	IGW
FND Design Data:	IGW.IGW_ORG_DETAILS
Subobject Name:
Status:	VALID

IGW_ORG_DETAILS stores details for the applicant organization and the applicant unit.
Detail examples include Signing Official, Administrative Official, Entity Identification Number, Taxpayer's Identification Number, and DUNS number.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGW_ORG_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER	(15)	Yes	Organization identifier
AGREEMENT_DATE	DATE			Division of Health and Human Services agreement date
NEGOTIATING_AGREEMENT_WITH	VARCHAR2	(50)		Regional office with which Division of Health and Human Services agreement is being negotiated.
RATE_ESTABLISHED_WITH	VARCHAR2	(50)		Regional office with which rate has been established, in case no Division of Health and Human Services agreement has been established
RATE_ESTABLISHED_DATE	DATE			Date when rate was established
ADMIN_OFFICIAL_ID	NUMBER	(15)		Administrative official identifier
SIGNING_OFFICIAL_ID	NUMBER	(15)		Signing official identifier
ORG_IPF_CODE	VARCHAR2	(20)		Organization's Institutional Profile Code
CONGRESS_DISTRICT	VARCHAR2	(50)		Congressional district
EIN	VARCHAR2	(20)		Employer Identification Number
TIN	VARCHAR2	(20)		Taxpayer Identification Number
DUNS_NUMBER	VARCHAR2	(20)		Data Universal Numbering System number
DUNS4_NUMBER	VARCHAR2	(20)		Data Universal Numbering System + 4 number
DODAAC_NUMBER	VARCHAR2	(20)		Department of Defense Activity Address Code number
CAGE_NUMBER	VARCHAR2	(20)		Commercial And Government Entity number
HUMAN_EXEMPTION_NUMBER	VARCHAR2	(20)		Human exemption number
HUMAN_ASSURANCE_NUMBER	VARCHAR2	(20)		Human assurance number
ANIMAL_ASSURANCE_NUMBER	VARCHAR2	(20)		Animal assurance number
NSF_INSTITUTIONAL_CODE	VARCHAR2	(20)		National Science Foundation institutional code
NIH_SUBDIVISION_CODE	VARCHAR2	(30)		Major subdivision code
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield 1 structure defining column
ATTRIBUTE_CATEGORY2	VARCHAR2	(30)		Descriptive Flexfield 2 structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment

Query Text

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


SELECT ORGANIZATION_ID
,      AGREEMENT_DATE
,      NEGOTIATING_AGREEMENT_WITH
,      RATE_ESTABLISHED_WITH
,      RATE_ESTABLISHED_DATE
,      ADMIN_OFFICIAL_ID
,      SIGNING_OFFICIAL_ID
,      ORG_IPF_CODE
,      CONGRESS_DISTRICT
,      EIN
,      TIN
,      DUNS_NUMBER
,      DUNS4_NUMBER
,      DODAAC_NUMBER
,      CAGE_NUMBER
,      HUMAN_EXEMPTION_NUMBER
,      HUMAN_ASSURANCE_NUMBER
,      ANIMAL_ASSURANCE_NUMBER
,      NSF_INSTITUTIONAL_CODE
,      NIH_SUBDIVISION_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE_CATEGORY2
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM IGW.IGW_ORG_DETAILS;

Dependencies

[top of page]

IGW.IGW_ORG_DETAILS does not reference any database object

IGW.IGW_ORG_DETAILS is referenced by following:

APPS: IGW_ORG_DETAILS