Document Body Page Navigation Panel

Appendix B Logical Organization of Static Data


Page 1 2 1 Page 2 3
ii
DoDIMS/ COLISEUM Requirements Definition Document Table of Contents
B2.0 LOGICAL ORGANIZATION OF STATIC DATA ........................... B- 1
ACTION .......................................................... B- 1
CODE ...................................................... B- 1
DEFINITION ................................................. B- 3
PRIV ....................................................... B- 3
CLASSIFICATION .................................................. B- 4
CLASS_ LEVEL ............................................... B- 4
CLASSIFICATION ............................................ B- 4
TITLE ...................................................... B- 5
DESCRIPTION ............................................... B- 5
COUNTRY ........................................................ B- 6
CC ......................................................... B- 6
TITLE ...................................................... B- 6
COUNTRY_ TIER ................................................... B- 7
CC ......................................................... B- 7
GAP_ ID ..................................................... B- 7
TIER ....................................................... B- 8
FREQUENCY ...................................................... B- 9
CODE ...................................................... B- 9
FREQUENCY .............................................. B- 10
DISSEMINATION ........................................... B- 10
GAPS ........................................................... B- 11
GAP ....................................................... B- 11
GAP_ ID .................................................... B- 11
ISSUE_ ID .................................................. B- 12
IFC_ CODES ...................................................... B- 13
IFC ........................................................ B- 13
TITLE ..................................................... B- 13
IFC_ PRIORITY ................................................... B- 14
CC ........................................................ B- 14
IFC ........................................................ B- 14
PRIORITY .................................................. B- 15
IFC_ PRD ......................................................... B- 16
IFC ........................................................ B- 16
PRODUCER ................................................ B- 16
TYPE ...................................................... B- 17
ISSUES .......................................................... B- 18
ISSUE ..................................................... B- 18
2
2 Page 3 4
iii
ISSUE_ ID .................................................. B- 18
SUBCATEGORY_ ID ......................................... B- 19
JUSTIFICATION .................................................. B- 20
JUSTIFICATION ............................................. B- 20
PRIORITY ................................................. B- 21
MEDIA .......................................................... B- 22
CODE ..................................................... B- 22
MEDIA .................................................... B- 23
PRODUCER ...................................................... B- 24
CITY ...................................................... B- 24
COM_ PH ................................................... B- 24
DSN_ PH ................................................... B- 25
E_ MAIL ................................................... B- 25
FAX_ DSN .................................................. B- 25
FAX_ PH ................................................... B- 26
STREET ................................................... B- 26
ORG ...................................................... B- 26
PRODUCER ................................................ B- 27
STATE .................................................... B- 28
TITLE ..................................................... B- 29
ZIP ........................................................ B- 29
ZIP_ EXT ................................................... B- 29
PROGRAM ....................................................... B- 30
CODE ..................................................... B- 30
PROGRAM ................................................. B- 31
SII .............................................................. B- 32
SII ........................................................ B- 32
TITLE ..................................................... B- 32
STATES ......................................................... B- 33
CODE ..................................................... B- 33
STATE .................................................... B- 34
SUBCATEGORY .................................................. B- 35
SUBCATEGORY ............................................ B- 35
SUBCATEGORY_ ID ......................................... B- 35
THEME_ CATEGORY_ ID ..................................... B- 36
THEME_ CATEGORY .............................................. B- 37
DESCRIPTION .............................................. B- 37
THEME .................................................... B- 37
THEME_ CATEGORY ........................................ B- 38
THEME_ CATEGORY_ ID ..................................... B- 38
THEMES ......................................................... B- 39
DESCRIPTION .............................................. B- 39
THEME .................................................... B- 39
3
3 Page 4 5
iv
TITLE ..................................................... B- 40
TIERS ........................................................... B- 41
DESCRIPTION .............................................. B- 41
TIER ...................................................... B- 41
UIC ............................................................. B- 42
ORG ...................................................... B- 42
UIC ....................................................... B- 42
4
4 Page 5 6
B- 1
B2.0 LOGICAL ORGANIZATION OF STATIC DATA.
This section describes the Static tables used in DoDIMS/ COLISEUM. The descriptions for each table include the TABLE NAME and DESCRIPTION, followed by the descriptions of the data
elements contained in the table. The information defining the data elements include the DATA ELEMENT, Synonymous Name, Definition, Format, Length, Range of Values, and Comments.

TABLE NAME: ACTION
DESCRIPTION: The ACTION table contains the valid types of actions that can be assigned to a PR. The values are presented to the user through the use of a pick-list.
The CODE selected from the pick- list is stored in the REQ_ ACTION table, along with the REQ_ ID and REQ_ ID_ UP values for the PR under
review.

DATA ELEMENT: CODE
Synonymous Name: None
Definition: CODE is a single word describing an action.
Format: Character
Length: 8
Range of Values:
PRIV CODE DEFINITION
(SIO Level) FORWARDED PR was forwarded to next in chain of command for review
SATISFIED SIO/ Customer were satisfied with the completed answer/ product
REVISED SIO/ Customer revised the PR after PR returned to SIO for revision
CANCELED SIO/ Customer canceled the PR 5
5 Page 6 7
B- 2
PRIV CODE DEFINITION
(Chain of Command) DELEGATED PR was assigned/ delegated to be completed within the
Chain of Command (before VO). The PR will not proceed up the Chain of Command as it will be answered before
reaching the VO. FORWARDED PR was forwarded to next in chain of command for review
SPLIT PR was split into more than one PR REJECTED PR was rejected
ANSWERED PR was answered before assignment to Production Center RETURNED TO SIO PR was returned to the SIO for revisions

(Validator) ANSWERED PR was answered before assignment to Production Center
SPLIT PR was split into more than one PR RETURNED TO SIO PR was returned to the SIO/ Customer for revisions
ASSIGNED VO assigned PR to Production Center, but the Production Center has not accepted the PR yet
REJECTED PR was rejected CLOSED After 90 days of product completion if VO has not received
a response from the SIO/ Customer, VO asks Customer if satisfied. If no response, VO closes the PR.

(Production Center) TASKED TO ANALYST PR was tasked within the Production Center
PCR Production Center Responsed to PR assignment PRODUCED Product has been disseminated to Customer, but Customer
has not indicated satisfaction with the product.
Comments: None 6
6 Page 7 8
B- 3
DATA ELEMENT: DEFINITION
Synonymous Name: None
Definition: DEFINITION is a brief description of the ACTION data.
Format: Character
Length: 40
Range of Values: See ACTION. DEFINITION.
Comments: None

DATA ELEMENT: PRIV
Synonymous Name: Privilege
Definition: PRIV is a single character code identifying the level at which the particular ACTION can be assigned.

Format: Character
Length: 1
Range of Values:
PRIV Definition A All levels
L Levels below the validation office O Validation Office only
P Production Center V Validation Office and above

Comments: None 7
7 Page 8 9
B- 4
TABLE NAME: CLASSIFICATION
DESCRIPTION: The CLASSIFICATION table contains the classification information identifyingthe classification and caveats. These values are displayed
through pick- lists.

DATA ELEMENT: CLASS_ LEVEL
Synonymous Name: None
Definition: CLASS_ LEVEL is the classification level. This value is be used to determine the highest classification assigned to the record being processed.

Format: Tinyint
Length: 1
Range of Values: 1 - 9, 1 being the highest level
Comments: None

DATA ELEMENT: CLASSIFICATION
Synonymous Name: None
Definition: CLASSIFICATION is the abbreviated CLASSIFICATION value.
Format: Character
Length: 5
Range of Values: See DIAM 65- 19, Standard Security Markings for a complete listing of markings.

Comments: None 8
8 Page 9 10
B- 5
DATA ELEMENT: DESCRIPTION
Synonymous Name: None
Definition: DESCRIPTION briefly describes the CLASSIFICATION.
Format: Character
Length: 100
Range of Values: See DIAM 65- 19, Standard Security Markings for a complete listing of markings.

Comments: None

DATA ELEMENT: TITLE
Synonymous Name: None
Definition: TITLE is the long definition of the CLASSIFICATION abbreviation.
Format: Character
Length: 15
Range of Values: See DIAM 65- 19, Standard Security Markings for a complete listing of markings.

Comments: None 9
9 Page 10 11
B- 6
TABLE NAME: COUNTRY
DESCRIPTION: The COUNTRY table contains the Country Code, AOR, and Hierarchy information. The CC and TITLE elements are displayed through pick- lists.
The AOR value is used to identify which area of responsibility the country is in.

DATA ELEMENT: CC
Synonymous Name: COUNTRY CODE
Definition: CC is the value assigned to each country by DIA.
Format: Character
Length: 2
Range of Values: See a valid Country Code Document.
Comments: None

DATA ELEMENT: TITLE
Synonymous Name: None
Definition: TITLE is the name of the country.
Format: Character
Length: 40
Range of Values: See a valid Country Code Document.
Comments: None 10
10 Page 11 12
B- 7
TABLE NAME: COUNTRY_ TIER
DESCRIPTION: The COUNTRY_ TIER table contains the Country Code, Gap, and Priority TIER information. The CC value references the CC value of the
COUNTRY table, the GAP_ ID value references the GAP_ ID value of the GAPS table, and the TIER value references the TIER value in the TIERS
table. The purpose of this table is to identify the TIER Priority, as determined at the National level, of the country selected.

DATA ELEMENT: CC
Synonymous Name: COUNTRY CODE
Definition: CC references the CC value in the COUNTRY table, which is the code used to identify a country.

Format: Character
Length: 2
Range of Values: See a valid Country Code Document.
Comments: None

DATA ELEMENT: GAP_ ID
Synonymous Name: None
Definition: GAP_ ID references the GAP_ ID value in the GAPS table. Reference to the GAPS table identifies the GAP the country has been assigned.

Format: Tinyint
Length: 1
Range of Values: A system generated number between 1 and 255.
Comments: None 11
11 Page 12 13
B- 8 12
12 Page 13 14
B- 9
DATA ELEMENT: TIER
Synonymous Name: None
Definition: TIER is the level in the TIER schema as determined by the National Community.

Format: Tinyint
Length: 1
Range of Values: See the attachment (Guidance on Priorities and Levels of Intelligence Effort, National Intelligence Needs Process) to the Memorandum for
Distribution from Intelligence Community Affairs Office, Subject: Program Responses to Intelligence Gaps.

Comments: None 13
13 Page 14 15
B- 10
TABLE NAME: FREQUENCY
DESCRIPTION: The FREQUENCY table contains the information describing dissemination frequencies. The information is displayed through pick- lists for selection.

DATA ELEMENT: CODE
Synonymous Name: None
Definition: CODE is the frequency of dissemination. When a frequency value is selected from the pick- list, the CODE value is stored on the record under
review.
Format: Character
Length: 1
Range of Values:
CODE FREQUENCY DISSEMINATION A Annually Once a year
R As Required No regular pattern B Biennially Once every two years
C Continuously More often than daily D Daily Once each day
F Semiweekly Twice a week G Biweekly Once every two weeks
K Bimonthly Once every two months L Semiannually Once every six months
M Monthly Once a month O One Time Not scheduled for revision (Default Value)
Q Quarterly Once every three months S Triannually Once every four months
T Triennially Once every three years W Weekly Once a week
X Long Range At intervals greater than three years
Comments: None 14
14 Page 15 16
B- 11
DATA ELEMENT: DISSEMINATION
Synonymous Name: None
Definition: DISSEMINATION is a descriptive explanation of the frequency of dissemination.

Format: Character
Length: 30
Range of Values: See FREQUENCY. CODE. DISSEMINATION.
Comments: None

DATA ELEMENT: FREQUENCY
Synonymous Name: None
Definition: FREQUENCY is a one or two word description of the frequency CODE.
Format: Character
Length: 15
Range of Values: See FREQUENCY. CODE. FREQUENCY.
Comments: None 15
15 Page 16 17
B- 12
TABLE NAME: GAPS
DESCRIPTION: This table contains the information about Gaps.

DATA ELEMENT: GAP
Synonymous Name: None
Definition: GAP is the title or definition of an intelligence gap as defined by the National Intelligence Community.

Format: Character
Length: 50
Range of Values: See the attachment (Guidance on Priorities and Levels of Intelligence Effort, National Intelligence Needs Process) to the Memorandum for
Distribution from Intelligence Community Affairs Office, Subject: Program Responses to Intelligence Gaps.

Comments: None

DATA ELEMENT: GAP_ ID
Synonymous Name: None
Definition: GAP_ ID is a unique value assigned to the Gap used for reference in the COUNTRY_ TIER table.

Format: Tinyint
Length: 1
Range of Values: A system generated number between 1 and 255.
Comments: None 16
16 Page 17 18
B- 13
DATA ELEMENT: ISSUE_ ID
Synonymous Name: None
Definition: ISSUE_ ID is used to link the GAP record to the ISSUES table.
Format: Tinyint
Length: 1
Range of Values: See the attachment (Guidance on Priorities and Levels of Intelligence Effort, National Intelligence Needs Process) to the Memorandum for
Distribution from Intelligence Community Affairs Office, Subject: Program Responses to Intelligence Gaps.

Comments: None 17
17 Page 18 19
B- 14
TABLE NAME: IFC_ CODES
DESCRIPTION: The IFC_ CODES table contains the codes and definitions used to identify intelligence responsibilities. The CODE and DEFINITION values are
displayed through pick- lists. The CODE and information about the PR (REQ_ ID and REQ_ ID_ UP) or PRODUCT (PROD_ ID) as well as a
TYPE (P or S) are stored in a relational table when a selection is made.

DATA ELEMENT: IFC
Synonymous Name: None
Definition: IFC is the code assigned to an area of intelligence for purposes of collection, production, and dissemination.

Format: Character
Length: 7
Range of Values: See the Production Priorities for valid IFC codes.
Comments: None

DATA ELEMENT: TITLE
Synonymous Name: None
Definition: TITLE describes the type of intelligence assigned to the IFC code.
Format: Character
Length: 60
Range of Values: See the Production Priorities for valid IFC titles.
Comments: None 18
18 Page 19 20
B- 15
TABLE NAME: IFC_ PRIORITY
DESCRIPTION: This table is a relational table containing information which represents the priority of an IFC based on a Country Code association. The table is
referenced by DoDIMS/ COLISEUM software, and is maintained through a special process.

DATA ELEMENT: CC
Synonymous Name: Country Code
Definition: CC is the unique code used to identify a country within the COUNTRY table.

Format: Character
Length: 2
Range of Values: See a valid Country Code Document.
Comments: None

DATA ELEMENT: IFC
Synonymous Name: None
Definition: IFC is the code assigned to an area of intelligence for purposes of collection, production, and dissemination.

Format: Character
Length: 7
Range of Values: See the Production Priorities for valid IFC codes.
Comments: None 19
19 Page 20 21
B- 16
DATA ELEMENT: PRIORITY
Synonymous Name: None
Definition: PRIORITY is the code assigned to each CC/ IFC combination.
Format: Tinyint
Length: 1
Range of Values: 1 - 7, see the Production Priorities for valid PRIORITY values and definitions.

Comments: None 20
20 Page 21 22
B- 17
TABLE NAME: IFC_ PRD
DESCRIPTION: The IFC_ PRD table is a relational table identifying the primary and collaborative producers assigned to intelligence responsibilities. This table
is referenced by DoDIMS/ COLISEUM software and maintained in a special process.

DATA ELEMENT: IFC
Synonymous Name: None
Definition: IFC is the code assigned to an area of intelligence for purposes of collection, production, and dissemination.

Format: Character
Length: 7
Range of Values: See the Production Priorities for valid IFC codes.
Comments: None

DATA ELEMENT: PRODUCER
Synonymous Name: Producer Code
Definition: PRODUCER is the code assigned to the Production Center.
Format: Character
Length: 10
Range of Values: See PRODUCER. PRODUCER.
Comments: None 21
21 Page 22 23
B- 18
DATA ELEMENT: TYPE
Synonymous Name: None
Definition: TYPE is the type of producer.
Format: Character
Length: 1
Range of Values:
TYPE DEFINITION P Primary Producer
C Collaborative Producer
Comments: None 22
22 Page 23 24
B- 19
TABLE NAME: ISSUES
DESCRIPTION: This table contains the information about Issues.

DATA ELEMENT: ISSUE
Synonymous Name: None
Definition: ISSUE is the title or definition of an issue as determined by the National Intelligence Community.

Format: Character
Length: 50
Range of Values: See the attachment (Guidance on Priorities and Levels of Intelligence Effort, National Intelligence Needs Process) to the Memorandum for
Distribution from Intelligence Community Affairs Office, Subject: Program Responses to Intelligence Gaps.

Comments: None

DATA ELEMENT: ISSUE_ ID
Synonymous Name: None
Definition: ISSUE_ ID is the unique number assigned to the issue referenced by the GAPS records.

Format: Tinyint
Length: 1
Range of Values: A system generated number between 1 and 255.
Comments: None 23
23 Page 24 25
B- 20
DATA ELEMENT: SUBCATEGORY_ ID
Synonymous Name: None
Definition: The SUBCATEGORY_ ID is used to link the issue records to the subcategory records.

Format: Tinyint
Length: 1
Range of Values: A system generated number between 1 and 255.
Comments: None 24
24 Page 25 26
B- 21
TABLE NAME: JUSTIFICATION
DESCRIPTION: The JUSTIFICATION table contains definitions for justifications and the associated priority (CODE). The values are displayed to the users through
the use of pick- lists. The selected JUSTIFICATION value and the CODE are stored on the PR record when selected.

DATA ELEMENT: JUSTIFICATION
Synonymous Name: None
Definition: JUSTIFICATION is a brief justification description. This is an optional field. The JUSTIFICATION will be included in a pick- list based on
Command/ Services/ Organization pre- defined values. (The values in this field are subject to change per Change Requests submitted to the CCB by
the users.)
Format: Character
Length: 40
Range of Values:
PRIORITY JUSTIFICATION
ACOM 1 Perishable Or Operational Intelligence 2 Planning, Contingency Planning, Briefings, or Exercises
3 Database Maintenance
AF/ 1 Combat Engagement With Hostile Forces In Progress INXA 2 Combat Imminent With Hostile Forces Within Six (6) Hours
3 Combat Operations Planning 4 Briefing
5 Other - User enters free text (i. e. "background info") 25
25 Page 26 27
B- 22
PRIORITY JUSTIFICATION
ARMY 1 Regional Issues And Threats 2 Key Weapon Science & Technology
3 Sustainment 4 Information Warfare
5 Intelligence/ Terrorist/ Criminal Threat 6 Foreign Military Forces
7 Operations Other Than War 8 Weapons Of Mass Destruction
9 Proliferation, Arms Control, Technology Transfer 10 Future Strategic Environment
11 Medical Factors 12 Climate, Weather, Terrain

DIA 1 Support To U. S. Forces Engaged In Hostilities 2 Support To Imminent Engagement In Hostilities
3 Support Is Essential Go Command/ Activity Mission Accomplishment
4 Support Is Very Important To Command/ Activity Mission Accomplishment
5 Support Is Needed To Meet Command/ Activity Tasking
Comments: None

DATA ELEMENT: PRIORITY
Synonymous Name: None
Definition: PRIORITY is a numeric value indicating the priority associated to the JUSTIFICATION data element.

Format: Character
Length: 2
Range of Values: See JUSTIFICATION. PRIORITY.
Comments: None 26
26 Page 27 28
B- 23
TABLE NAME: MEDIA
DESCRIPTION: The MEDIA table contains the CODE and MEDIA values identifying the media types for dissemination of intelligence.

DATA ELEMENT: CODE
Synonymous Name: None
Definition: CODE is a two character code assigned to the media type.
Format: Character
Length: 2
Range of Values:
CODE MEDIA CD CD- ROM
DB Automated Data Base C5 Computer 5 1/ 4" Floppy Disk
C3 Computer 3 1/ 2" Floppy Disk EM Electronic Mail (E_ Mail)
FM Fastest Method, any media most quickly available HA Hardcopy Document
IH Imagery Hardcopy IM Imagery
ME Message M4 4 Milimeter (mm) Digital Audio Tape (DAT)
M8 8mm Magnetic Tape MM 150 Megabyte (mg) 1/ 4" Magnetic Tape
OL Online PH Telephone
VI Videotape/ Cassette
Comments: None 27
27 Page 28 29
B- 24
DATA ELEMENT: MEDIA
Synonymous Name: None
Definition: MEDIA describes the type of media.
Format: Character
Length: 25
Range of Values: See MEDIA. CODE. MEDIA.
Comments: None 28
28 Page 29 30
B- 25
TABLE NAME: PRODUCER
DESCRIPTION: The PRODUCER table contains the information identifying a Production Center.

DATA ELEMENT: CITY
Synonymous Name: None
Definition: CITY is the name of the nearest city to the Production Center.
Format: Character
Length: 25
Range of Values: A- Z
Comments: None

DATA ELEMENT: COM_ PH
Synonymous Name: None
Definition: COM_ PH is the commercial phone number for the Production Center.
Format: Character
Length: 13
Range of Values: 0- 9
Comments: None 29
29 Page 30 31
B- 26
DATA ELEMENT: DSN_ PH
Synonymous Name: None
Definition: DSN_ PH is the secure phone number for the Production Center.
Format: Character
Length: 13
Range of Values: 0- 9
Comments: None

DATA ELEMENT: E_ MAIL
Synonymous Name: None
Definition: E_ MAIL is the production manager's E- Mail address.
Format: Character
Length: 30
Range of Values: A valid E- Mail address.
Comments: None

DATA ELEMENT: FAX_ DSN
Synonymous Name: None
Definition: FAX_ PH is the secure FAX phone number for the Production Center.
Format: Character
Length: 13
Range of Values: 0- 9 30
30 Page 31 32
B- 27
Comments: None 31
31 Page 32 33
B- 28
DATA ELEMENT: FAX_ PH
Synonymous Name: None
Definition: FAX_ PH is the commercial FAX phone number for the Production Center.
Format: Character
Length: 13
Range of Values: 0- 9
Comments: None

DATA ELEMENT: ORG
Synonymous Name: Organization
Definition: ORG is the full organization name for the Production Center.
Format: Character
Length: 55
Range of Values: See PRODUCER. ORGANIZATION below.
Comments: None 32
32 Page 33 34
B- 29
DATA ELEMENT: PRODUCER
Synonymous Name: Producer Code
Definition: PRODUCER is the code value identifying the Production Center.
Format: Character
Length: 10
Range of Values:
PRODUCER ORGANIZATION
DoD Producers 4th PSYOP 4th Psychological Operations Group, USSOCOM
AIC USACOM, Atlantic Intelligence Command AFMIC DIA, Armed Forces Medical Intelligence Center
CENTJIC USCENTCOM, Joint Intelligence Center JAC USEUCOM Joint Analysis Center
JICPAC Joint Intelligence Center, USPACOM JICSOUTH Joint Intelligence Center, USSOUTHCOM
JICTRANS Joint Intelligence Center, USTRANSCOM MCIA Marine Corps Intelligence Activity
MSIC DIA, Missile and Space Intelligence Center NAIC National Air Intelligence Center
NGIC National Ground Intelligence Center NMIPC DIA, National Military Intelligence Production Center
NMJIC DIA, National Military Joint Intelligence Center NORAD North American Aerospace Defense
ONI Office of Naval Intelligence STRATJIC USSTRATCOM, Joint Intelligence Center 33
33 Page 34 35
B- 30
PRODUCER ORGANIZATION
National Producers
CIA Central Intelligence Agency COSPO Community Open Source Program Office
DMAAC Defense Mapping Agency Aeronautics Center DOE Department of Energy
JAEIC Joint Atomic Energy Intelligence Committee NIC National Intelligence Council
NPIC/ NEL National Photographic Interpretation Center NPC Nonproliferation Center
NSA National Security Agency DOS Department of State (Intelligence and Research)
STIC Scientific Technical Intelligence Committee WSSIC Weapons Space System Intelligence Committee

Comments: None

DATA ELEMENT: STATE
Synonymous Name: State Code
Definition: STATE is the abbreviation for the STATE.
Format: Character
Length: 2
Range of Values: See STATE. CODE.
Comments: None 34
34 Page 35 36
B- 31
DATA ELEMENT: STREET
Synonymous Name: None
Definition: STREET is the Production Center street address.
Format: Character
Length: 50
Range of Values: 0- 9, A- Z
Comments: None

DATA ELEMENT: TITLE
Synonymous Name: None
Definition: TITLE is the unabbreviated Production Center title.
Format: Character
Length: 50
Range of Values: See PRODUCER. TITLE.
Comments: None

DATA ELEMENT: ZIP
Synonymous Name: None
Definition: ZIP is the zip code of the mailing address for the Production Center.
Format: Integer
Length: 5
Range of Values: 0- 9 35
35 Page 36 37
B- 32
Comments: None 36
36 Page 37 38
B- 33
DATA ELEMENT: ZIP_ EXT
Synonymous Name: Zip Code Extension
Definition: ZIP_ EXT is the zip code four number extension.
Format: Integer
Length: 4
Range of Values: 0- 9
Comments: None 37
37 Page 38 39
B- 34
TABLE NAME: PROGRAM
DESCRIPTION: The PROGRAM table contains the CODE and PROGRAM values identifying special production programs.

DATA ELEMENT: CODE
Synonymous Name: None
Definition: CODE is the value assigned to the Special Production Program.
Format: Character
Length: 1
Range of Values:
CODE PROGRAM A Arms Control
D Defense Acquisition F Futures Intelligence
I Indications and Warning M Foreign Material
C Military Capabilities Study (MCS) N Non- Evacuation Operations (NEO)
P Proliferation S SIOP Support
T Target Materials Y Psychological Operations

Comments: None 38
38 Page 39 40
B- 35
DATA ELEMENT: PROGRAM
Synonymous Name: None
Definition: PROGRAM is the name of the Special Production Program.
Format: Character
Length: 25
Range of Values: See PROGRAM. CODE.
Comments: None 39
39 Page 40 41
B- 36
TABLE NAME: SII
DESCRIPTION: The SII table contains a subset of the CRMS Statement of Intelligence Interest (SII) table. This table is used for look- up and generation of the
REQ_ ID value.

DATA ELEMENT: SII
Synonymous Name: None
Definition: SII is the code assigned to SII accounts.
Format: Character
Length: 4
Range of Values: See DIDS documentation.
Comments: None

DATA ELEMENT: TITLE
Synonymous Name: None
Definition: TITLE is the organization that has been assigned the SII account.
Format: Character
Length: 50
Range of Values: See DIDS documentation.
Comments: None 40
40 Page 41 42
B- 37
TABLE NAME: STATES
DESCRIPTION: The STATES table contains the US State names and the two character abbreviations.

DATA ELEMENT: CODE
Synonymous Name: None
Definition: CODE is the two character state abbreviation.
Format: Character
Length: 2
Range of Values:
CODE STATE AL Alabama
AK Alaska AZ Arizona
AR Arkansas CA California
CO Colorado CT Connecticut
DC District of Columbia DE Delaware
FL Florida GA Georgia
GU Guam HI Hawaii
ID Idaho IL Illinois
IN Indiana IA Iowa
KS Kansas KY Kentucky
LA Louisiana ME Maine
MD Maryland 41
41 Page 42 43
B- 38
MH Marshall Islands MA Massachusetts
MI Michigan MN Minnesota
CODE STATE MS Mississippi
MO Missouri MT Montana
NE Nebraska NV Nevada
NH New Hampshire NJ New Jersey
NM New Mexico NY New York
NC North Carolina ND North Dakota
OH Ohio OK Oklahoma
OR Oregon PA Pennsylvania
PR Puerto Rico RI Rhode Island
SC South Carolina SD South Dakota
TN Tennessee TX Texas
UT Utah VT Vermont
VA Virginia VI Virgin Islands
WA Washington WV West Virginia
WI Wisconsin WY Wyoming

Comments: None

DATA ELEMENT: STATE
Synonymous Name: None
Definition: STATE is the state name.
Format: Character 42
42 Page 43 44
B- 39
Length: 25
Range of Values: See STATE. CODE. STATE.
Comments: None 43
43 Page 44 45
B- 40
TABLE NAME: SUBCATEGORY
DESCRIPTION: The SUBCATEGORY table contains the Subcategories of the Themes.

DATA ELEMENT: SUBCATEGORY
Synonymous Name: None
Definition: SUBCATEGORY is the breakout of the THEME_ CATEGORY in the National Level Tiers Schema.

Format: Character
Length: 50
Range of Values: See the attachment (Guidance on Priorities and Levels of Intelligence Effort, National Intelligence Needs Process) to the Memorandum for
Distribution from Intelligence Community Affairs Office, Subject: Program Responses to Intelligence Gaps.

Comments: None

DATA ELEMENT: SUBCATEGORY_ ID
Synonymous Name: None
Definition: SUBCATEGORY_ ID is the unique code assigned to the Subcateory. It is used in reference by the Gaps records.

Format: Tinyint
Length: 1
Range of Values: A system generated number between 1 and 255.
Comments: None 44
44 Page 45 46
B- 41
DATA ELEMENT: THEME_ CATEGORY_ ID
Synonymous Name: None
Definition: THEME_ SUBCATEGORY_ ID links the Subcategory records to the Category records.

Format: Tinyint
Length: 1
Range of Values: A system generated number between 1 and 255.
Comments: None 45
45 Page 46 47
B- 42
TABLE NAME: THEME_ CATEGORY
DESCRIPTION: The THEME_ CATEGORY table identifies categories within the themes.

DATA ELEMENT: DESCRIPTION
Synonymous Name: None
Definition: DESCRIPTON is the description of the Theme Category.
Format: Text
Length: 16 (Up to 2,147,483,647 bytes)
Range of Values: See the attachment (Guidance on Priorities and Levels of Intelligence Effort, National Intelligence Needs Process) to the Memorandum for
Distribution from Intelligence Community Affairs Office, Subject: Program Responses to Intelligence Gaps.

Comments: None

DATA ELEMENT: THEME
Synonymous Name: None
Definition: THEME is used to link the Theme Category record to the Theme.
Format: Character
Length: 3
Range of Values: See the attachment (Guidance on Priorities and Levels of Intelligence Effort, National Intelligence Needs Process) to the Memorandum for
Distribution from Intelligence Community Affairs Office, Subject: Program Responses to Intelligence Gaps.

Comments: None 46
46 Page 47 48
B- 43
DATA ELEMENT: THEME_ CATEGORY
Synonymous Name: None
Definition: THEME_ CATEGORY is assigned to each Category broken out under each Theme.

Format: Character
Length: 50
Range of Values: See the attachment (Guidance on Priorities and Levels of Intelligence Effort, National Intelligence Needs Process) to the Memorandum for
Distribution from Intelligence Community Affairs Office, Subject: Program Responses to Intelligence Gaps.

Comments: None

DATA ELEMENT: THEME_ CATEGORY_ ID
Synonymous Name: None
Definition: THEME_ SUBCATEGORY_ ID is the unique identifier used in reference by the Subcategory records.

Format: Tinyint
Length: 1
Range of Values: A system generated number between 1 and 255.
Comments: None 47
47 Page 48 49
B- 44
TABLE NAME: THEMES
DESCRIPTION: The THEMES table contains the Themes set forth by the National Committee.

DATA ELEMENT: DESCRIPTION
Synonymous Name: None
Definition: DESCRIPTON is the brief description of the Theme.
Format: Text
Length: 16 (Up to 2,147,483,647 bytes)
Range of Values: See the attachment (Guidance on Priorities and Levels of Intelligence Effort, National Intelligence Needs Process) to the Memorandum for
Distribution from Intelligence Community Affairs Office, Subject: Program Responses to Intelligence Gaps.

Comments: None

DATA ELEMENT: THEME
Synonymous Name: None
Definition: THEME is the unique identifier for a Theme.
Format: Character
Length: 3
Range of Values: I, II, III.
Comments: None 48
48 Page 49 50
B- 45
DATA ELEMENT: TITLE
Synonymous Name: None
Definition: TITLE is the title of the Theme Category.
Format: Character
Length: 50
Range of Values: See the attachment (Guidance on Priorities and Levels of Intelligence Effort, National Intelligence Needs Process) to the Memorandum for
Distribution from Intelligence Community Affairs Office, Subject: Program Responses to Intelligence Gaps.

Comments: None 49
49 Page 50 51
B- 46
TABLE NAME: TIERS
DESCRIPTION: The TIERS table contains the National Level Tier Priority system.

DATA ELEMENT: DESCRIPTION
Synonymous Name: None
Definition: DESCRIPTON is the description of the Tier.
Format: Text
Length: 16 (Up to 2,147,483,647 bytes)
Range of Values: See the attachment (Guidance on Priorities and Levels of Intelligence Effort, National Intelligence Needs Process) to the Memorandum for
Distribution from Intelligence Community Affairs Office, Subject: Program Responses to Intelligence Gaps.

Comments: None

DATA ELEMENT: TIER
Synonymous Name: None
Definition: TIER is the code assigned to identify the Tier.
Format: Tinyint
Length: 1
Range of Values: 0- 4
Comments: None 50
50 Page 51
B- 47
TABLE NAME: UIC
DESCRIPTION: The UIC table contains the Unit Idenitification Codes (UICs) used in the automatic generation of the REQ_ ID. The UICs are updated quarterly.

DATA ELEMENT: ORG
Synonymous Name: None
Definition: ORG is the description of the UIC's organization.
Format: Character
Length: 55
Range of Values: See the SORTS database.
Comments: None

DATA ELEMENT: UIC
Synonymous Name: None
Definition: UIC is the Unit Identification Code.
Format: Character
Length: 6
Range of Values: See the SORTS database.
Comments: None 51

Page Navigation Panel

1 2 3 4 5 6 7 8 9
10 11 12 13 14 15 16 17 18 19
20 21 22 23 24 25 26 27 28 29
30 31 32 33 34 35 36 37 38 39
40 41 42 43 44 45 46 47 48 49
50 51