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 255. 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 three 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. Repeats Indicates the maximum number of repeat occurances that can be inputted. For example, the EIR_Grants.GrantAgency and EIR_Grants.GrantNum can be repeated up to seven times. Data Element Name Format/Size Status Groups Value Selection List Repeats EIR.DocketNum varchar(30) Required     0 EIR.PrimaryAgency varchar(60) Optional   AFRL/IF AHRQ ARMY/MRMC ARMY/SMDC ARMY/SSC ATSDR CDC DOD/DMEA DOE EPA FDA IHS Navy/ONR NIH NIST NOAA NSF USAF/AFOSR USAF/ESC USAID USDA/ARS USDA/CSREES USDA/FS 0 EIR.Title varchar(255) Required     0 EIR.DisclosurDate date Required (if new invention), otherwise Optional     0 EIR.TitleExtenReq ^^One Year^^ or ^^Two Year^^ or ^^^^ (default - Zero year) Optional   "" (Empty String) One Year Two Year 0 EIR.PatentExtenReq ^^Yes^^ or ^^No^^ or ^^^^ (Default NO) Optional   "" (Empty String) Yes No 0 EIR.BarDate date Optional     0 EIR.EIRStatus varchar(80) Optional   Under Evaluation Elect Title Licensed as an Unpatented Biological Material Not Elect Title; Assign to Other Party 0 EIR.TitleElectDate date Optional     0 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 0 EIR.WaiveReason varchar(255) Optional     0 EIR.Notes text Optional     0 EIR.ParentEIR #######-##-#### Optional     0 EIR.ParentDocketNum varchar(30) Optional     0 EIR_Grants.Agency varchar(60) Required 1 AFRL/IF AHRQ ARMY/MRMC ARMY/SMDC ARMY/SSC ATSDR CDC DOD/DMEA DOE EPA FDA IHS Navy/ONR NIH NIST NOAA NSF USAF/AFOSR USAF/ESC USAID USDA/ARS USDA/CSREES USDA/FS 12 EIR_Grants.GrantNum varchar(60) Required 1   12 EIR_Keyword.Keyword varchar(80) Optional     12 EIR_Inventor.LastName varchar(30) Required 2   12 EIR_Inventor.FirstName varchar(30) Required 2   12 EIR_Inventor.MI varchar(30) Optional 2   12 Patent.PatDocketNum* varchar(30) Optional     0 Patent.ProvAppNum* ##/###,###** Optional     0 Patent.ProvAppDate* date Optional     0 Patent.PCTNum* PCT/AA####/###### Optional     0 Patent.PCTFileDate* date Optional     0 Patent.NonProvAppNum* ##/###,### or ##/###,### (CPA##) or PV####### or PV######### Optional     0 Patent.NonProvAppDate* date Optional     0 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     0 Patent.PatentDate date OptReq, if PatentNum if provided     0 Patent.ExpireDate date Optional     0 Patent.TypeOfApplic varchar(5) Required   CIP CON DIV FWC ORD PVP 0 Patent.PatentTitle varchar(300) Optional     0 Patent.Notes text Optional     0 Patent.OtherRelatedInventions varchar(500) Optional     0 Patent.DispRightsReq varchar(80) Optional   Waive to Government Assign to Inventor(s) Or text to specifiy other party to which assigned 0 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     0 Utilize_New.NonExclusiveLicensesOptions ### OptReq     0 Utilize_New.ExclusiveLicensesOptions ### OptReq     0 Utilize_New.FirstCommSaleYear #### OptReq     0 Utilize_New.SmallBusLicensesOptions ### OptReq     0 Utilize_New.LatestStageDev varchar(15) OptReq   Licensed Not Licensed Commercialized 0 Utilize_New.TotalIncome ########## or #,###,###,### or $#,###,###,### OptReq     0 Utilize_New.ManufacturingWaiver # OptReq     0 Utilize_New.ManufacturingWaiverTotal #### OptReq     0 Utilize_New.CommercialName varchar(80) OptReq 5   0 Utilize_New.Public ^^Yes^^ or ^^No^^ OptReq 5 Yes No 0 Utilize_New.FDAApprovalType varchar(4) Optional 5 CBER (Biologic) CDER (Drug) CDRH (Medical Device) 0 Utilize_New.FDAApprovalNumber varchar(20) OptReq 5   0 * 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