iEdison Header
Edison Integrator Users Guide

    Description of the Data Elements in a Batch Record


The table contains, for each data element in the record, the name of the data element, the data format and size, the data element status, groups, value selection list, and repeats. The definitions of the matrix column titles are listed below.

Data Element Name
The name of the data element.
Format/Size
The data element type and size. The data element types are presented below.
Varchar
Can be character and numeric values, with a length up to specified size.
Numeric
Can only be numeric values
Text
Can be character and numeric values with a fixed length of 4,000 characters
Date
Format is YY/MM/DD
Value
A set if choices from a predefined list.


There are three specific formats that need to be followed for EIR_Grants.GrantNum, Patent.PCTNum, and Utilize_New.FiscalYear.
EIR_Grants.GrantNum
NIH grants:
The grant number must be in the form AA###### where A is a character and # is a digit.
USDA/CSREES grants:
The grant number must be in either the form YY-#####-####, YY-LLLL-D-####, XX-LLLL-D-####, or XX-AAAA-D-####, where YY represents the fiscal year, L is an uppercase letter, D is the numbers 1, 2, or 3, A is either a number or an uppercase letter, and X is the letter "X".
Other grants
Please use this link to view the formats for other grants.
Patent.PCTNum
The PCT Number has the following format: PCT/country code, fiscal-year/###### (for example, when the PCT country is the United States of America and the fiscal year is 2007 the PCT Number is: PCT/US2007/123456).
Utilize_New.FiscalYear
The format is ####. For example, 2001.
Status
Defines whether a data element is required or not. The three choices are required, or optional, optional/required.
Required means that the user must fill in the field.
Optional means that the field can be filled in if needed.
OptReq means that although the field is considered optional, if the previous field is filled in then data submission is required.
Groups
Certain data elements must be submitted in groups. There are five groups defined in the Interagency Edison/Edison system. A number indicates that all of the data elements with the same number must be grouped together.
For example, EIR_Grants.GrantAgency and EIR_Grants.GrantNum are grouped together. Thus for each instance of an optioned EIR_Grants.GrantAgency, an EIR_Grants.GrantNum must follow.
Value
Indicates that the value for this data element must be one of the values from the value selection list.
maxOccurs
Indicates the maximum number of times an element can occur. For example, the EIR_Grants.GrantAgency and EIR_Grants.GrantNum can occur up to 20 times.

Data Element Name

Format/Size

Status

Groups

Value Selection List

maxOccurs

EIR.DocketNum

varchar(30)

Required

   

1

EIR.PrimaryAgency

varchar(60)

Optional

 

AFMCLO/JAZ
AFRL/RI
AHRQ
ARMY/ARL
ARMY/ARO
ARMY/MRMC
ARMY/SMDC
ARMY/SSC
ATSDR
CDC
DHS/ST
DOC/EDA
DOC/ITA
DOD/DARPA
DOD/DMEA
DOD/DTRA
DOE
DOT
EPA
FDA
IHS
NAVY/ONR
NIH
NIST
NOAA
NRC
NSF
OTHER
USAF/AFOSR
USAID
USDA/ARS
USDA/FS
USDA/NIFA

1

EIR.Title

varchar(255)

Required

 

 

1

EIR.DisclosurDate

date

Required (if new invention), otherwise Optional

 

 

1

EIR.TitleExtenReq

^^One Year^^ or ^^Two Year^^ or ^^^^ (default - Zero year)

Optional

 

"" (Empty String)
One Year
Two Year

1

EIR.PatentExtenReq

^^Yes^^ or ^^No^^ or ^^^^ (Default NO)

Optional

 

"" (Empty String)
Yes
No

1

EIR.BarDate

date

Optional

 

 

1

EIR.EIRStatus

varchar(80)

Optional

 

Under Evaluation

Elect Title

Licensed as an Unpatented Biological Material

Not Elect Title; Assign to Other Party

1

EIR.TitleElectDate

date

Optional

 

 

1

EIR.DispRightsReq

varchar(80)

Optional
(except when <NOT ELECT> was selected in the EIR.EIRStatus field)

 

Waive to Government

Assign to Inventor(s)

Or text to specifiy other party to which assigned

1

EIR.WaiveReason

varchar(255)

Optional

 

 

1

EIR.Notes

text


Optional

 

 

1

EIR.ParentEIR

#######-##-####

Optional

 

 

1

EIR.ParentDocketNum

varchar(30)

Optional

 

 

1

EIR_Grants.Agency

varchar(60)

Required

1

AFMCLO/JAZ
AFRL/RI
AHRQ
ARMY/ARL
ARMY/ARO
ARMY/MRMC
ARMY/SMDC
ARMY/SSC
ATSDR
CDC
DHS/ST
DOC/EDA
DOC/ITA
DOD/DARPA
DOD/DMEA
DOD/DTRA
DOE
DOT
EPA
FDA
IHS
NAVY/ONR
NIH
NIST
NOAA
NRC
NSF
OTHER
USAF/AFOSR
USAID
USDA/ARS
USDA/FS
USDA/NIFA

20

EIR_Grants.GrantNum

varchar(60)

Required

1

 

20

EIR_Keyword.Keyword

varchar(80)

Optional

 

 

12

EIR_Inventor.LastName

varchar(30)

Required

2

 

20

EIR_Inventor.FirstName

varchar(30)

Required

2

 

20

EIR_Inventor.MI

varchar(30)

Optional

2

 

20

Patent.PatDocketNum*

varchar(30)

Optional

 

 

1

Patent.ProvAppNum*

##/###,###**

Optional

 

 

1

Patent.ProvAppDate*

date

Optional

 

 

1

Patent.PCTNum*

PCT/AA####/######

Optional

 

 

1

Patent.PCTFileDate*

date

Optional

 

 

1

Patent.NonProvAppNum*

##/###,### or ##/###,### (CPA##) or PV####### or PV#########

Optional

 

 

1

Patent.NonProvAppDate*

date

Optional

 

 

1

Patent.PatentNum

#,###,### or ##,###,### or ######## or T##### or D##### or H##### or RE##### or ####### or PLT###### or PLT##,#### or PP##### or PP#### or PP#,### or PP##,### or PV####### or PV#########

Optional

 

 

1

Patent.PatentDate

date

OptReq, if PatentNum if provided

 

 

1

Patent.ExpireDate

date

Optional

 

 

1

Patent.TypeOfApplic

varchar(5)

Required

 

CIP
CON
CPA
DIV
FWC
ORD
PCT
PROV
PVP
RCE

1

Patent.PatentTitle

varchar(300)

Optional

 

 

1

Patent.Notes

text

Optional

 

 

1

Patent.OtherRelatedInventions

varchar(500)

Optional

 

 

1

Patent.DispRightsReq

varchar(80)

Optional

 

Waive to Government

Assign to Inventor(s)

Or text to specifiy other party to which assigned

1

Pat_Keyword.Keyword

varchar(80)

Optional

 

 

12

Pat_Inventor.LastName

varchar(30)

Required

3

 

12 

Pat_Inventor.FirstName

varchar(30)

Required

3

 

12

Pat_Inventor.MI

varchar(30)

Optional

3

 

12

Pat_ForeignFiling.Country

varchar(100)

Optional

4

Please use this link to view the countries.

12

Pat_ForeignFiling.Status

Active or Abandoned

OptReq, if Pat_ForeignFiling.Country is provided

4

Active
Abandoned

12

Pat_ForeignFiling.Date

date

OptReq, if Pat_ForeignFiling.Country is provided

4

 

12

Utilize_New.FiscalYear

####

Optional

 

 

1

Utilize_New.NonExclusiveLicensesOptions

###

OptReq

 

 

1

Utilize_New.ExclusiveLicensesOptions

###

OptReq

 

 

1

Utilize_New.FirstCommSaleYear

####

OptReq

 

 

1

Utilize_New.SmallBusLicensesOptions

###

OptReq

 

 

1

Utilize_New.LatestStageDev

varchar(15)

OptReq

 

Licensed
Not Licensed
Commercialized

1

Utilize_New.TotalIncome

########## or
#,###,###,### or
$#,###,###,###

OptReq

 

 

1

Utilize_New.ManufacturingWaiver

#

OptReq

 

 

1

Utilize_New.ManufacturingWaiverTotal

####

OptReq

 

 

1

Utilize_New.CommercialName

varchar(80)

OptReq

5

 

1

Utilize_New.Public

^^Yes^^ or ^^No^^

OptReq

5

Yes
No

1

Utilize_New.FDAApprovalType

varchar(4)

Optional

5

CBER (Biologic)
CDER (Drug)
CDRH (Medical Device)

1

Utilize_New.FDAApprovalNumber

varchar(20)

OptReq

5

 

1


* When submitting a Patent, one or more of the following (numbers)
Patent.PatDocketNum
Patent.ProvAppNum
Patent.PCTNum
Patent.NonProvAppNum
and one or more of the following (dates)
Patent.ProvAppDate
Patent.PCTFileDate
Patent.NonProvAppDate
must be submitted.
Return to Data Elements
**Patent.ProvAppNum's first two digits must be greater than or equal to 60.
Return to Data Elements


On to the next section

Return to Special Instructions for Organizations that have Large Databases

 

IEDISON- 1006