Document Body Page Navigation Panel

Pages 1--98 from unmodified]


Page 1 2
Appendix C Logical Organization of Dynamic Data 1
1 Page 2 3
ii
DoDIMS/ COLISEUM Requirements Definition Document Table of Contents
C1.0 LOGICAL ORGANIZATION OF DYNAMIC DATA ......................... C- 1 PROD_ CLASSIFICATION ............................................ C- 1
CLASS_ LEVEL .............................................. C- 1 CLASSIFICATION ............................................ C- 2
PROD_ ID ................................................... C- 2 PROD_ PRD ....................................................... C- 3
DATE_ CREATED ............................................. C- 3
DATA ELEMENT: ...................................................... C- 4 PROD_ ID ................................................... C- 4
TYPE ....................................................... C- 5 PROD_ REQ ....................................................... C- 6
DATE_ CREATED ............................................. C- 6 REQ_ ID ..................................................... C- 6
REQ_ ID_ UP ................................................. C- 7 PRODUCER ................................................. C- 7
TYPE ....................................................... C- 8 PRODUCT_ REQ_ LINK .............................................. C- 9
DATE_ CREATED ............................................. C- 9 PROD_ ID ................................................... C- 9
REQ_ ID .................................................... C- 10 REQ_ ID_ UP ................................................ C- 10
PRODUCT ....................................................... C- 11 ABSTRACT ................................................. C- 11
COVER_ DATE .............................................. C- 11 DATE_ CREATED ............................................ C- 12
DATE_ DISSEM ............................................. C- 12 DATE_ MODIFIED ........................................... C- 13
FQ_ DISSEM ................................................ C- 13 FY_ DISSEM ................................................ C- 14
FREQUENCY ............................................... C- 14 ICOD ...................................................... C- 15
LENGTH ................................................... C- 15 PROD_ TYPE ................................................ C- 16
PROGRAM ................................................. C- 16 PROD_ ID .................................................. C- 17
PRODUCT_ NUMBER ........................................ C- 18 TITLE ..................................................... C- 18
PROD_ CC ........................................................ C- 19 2
2 Page 3 4
iii
CC ....................................................... C- 19 PROD_ ID .................................................. C- 19
TYPE ...................................................... C- 20 PROD_ CLASSIFICATION ........................................... C- 21
CLASS_ LEVEL ............................................. C- 21 CLASSIFICATION .......................................... C- 21
PROD_ ID .................................................. C- 22 TYPE ...................................................... C- 22
PROD_ IFC ....................................................... C- 23 IFC ....................................................... C- 23
PROD_ ID .................................................. C- 23 TYPE ...................................................... C- 24
PROD_ MEDIA .................................................... C- 25 MEDIA .................................................... C- 25
PROD_ ID .................................................. C- 25 PR_ MSGS ........................................................ C- 26
MESSAGE .................................................. C- 26 REQ_ ID .................................................... C- 26
REQ_ ID_ UP ................................................ C- 27 RE_ MAIL .................................................. C- 27
RNAME .................................................... C- 28 SE_ MAIL .................................................. C- 28
SNAME .................................................... C- 29 SUBJECT .................................................. C- 29
REQ_ ACTION .................................................... C- 30 ACTION ................................................... C- 30
ACTION_ TO ................................................ C- 30 ACTION_ THRU ............................................. C- 31
DATE_ CREATED ............................................ C- 31 REQ_ ID .................................................... C- 32
REQ_ ID_ UP ................................................ C- 32 VO ........................................................ C- 33
REQ_ CC ......................................................... C- 34 DATE_ CREATED ............................................ C- 34
CC ....................................................... C- 34 REQ_ ID .................................................... C- 35
REQ_ ID_ UP ................................................ C- 35 TYPE ...................................................... C- 36
REQ_ CLASSIFICATION ............................................ C- 37 CLASS_ LEVEL .............................................. C- 37
CLASSIFICATION .......................................... C- 37 REQ_ ID .................................................... C- 38
REQ_ ID_ UP ................................................ C- 38 3
3 Page 4 5
iv
REQ_ IFC ........................................................ C- 39 DATE_ CREATED ............................................ C- 39
IFC ........................................................ C- 39 REQ_ ID .................................................... C- 40
REQ_ ID_ UP ................................................ C- 40 TYPE ...................................................... C- 41
REQ_ MEDIA ..................................................... C- 42 MEDIA .................................................... C- 42
REQ_ ID .................................................... C- 42 REQ_ ID_ UP ................................................ C- 43
REQUEST ........................................................ C- 44 CREATED_ BY .............................................. C- 44
CLASS_ PRODUCT ........................................... C- 44 CLASS_ OVERALL ........................................... C- 45
CLASS_ REQUEST ........................................... C- 45 CLASS_ SUBJECT ........................................... C- 46
DATE_ CREATED ............................................ C- 46 DATE_ MODIFIED ........................................... C- 47
EXERCISE_ NAME ........................................... C- 47 FQ_ DISSEM ................................................ C- 48
FROM ..................................................... C- 48 FY_ DISSEM ................................................ C- 49
FREQUENCY ............................................... C- 49 IFC_ PRIORITY .............................................. C- 50
JUSTIFICATION ............................................. C- 50 LTIOV ..................................................... C- 51
MEDIA .................................................... C- 51 ORG ...................................................... C- 52
PROD_ TYPE ................................................ C- 52 REQ_ ID .................................................... C- 53
REQ_ ID_ UP ................................................ C- 53 REQUEST .................................................. C- 54
REQ_ DTG .................................................. C- 54 REVIEWER ................................................. C- 55
SIO ....................................................... C- 55 SUBJECT .................................................. C- 56
SUSPENSE ................................................. C- 56 USER_ PRIORITY ........................................... C- 57
VO ........................................................ C- 57 REQUESTOR ..................................................... C- 58
CITY ...................................................... C- 58 COM_ PH ................................................... C- 58
DATE_ CREATED ............................................ C- 59 4
4 Page 5 6
v
DATE_ MODIFIED ........................................... C- 59 DSN_ PH ................................................... C- 60
E_ MAIL ................................................... C- 60 FAX_ SECURE .............................................. C- 61
FAX_ UNCLASS ............................................. C- 61 FIRST ..................................................... C- 62
LAST ...................................................... C- 62 MI ........................................................ C- 63
NEXT_ ORG ................................................ C- 63 ORG ...................................................... C- 64
REVIEWER ................................................. C- 64 SEC_ PHONE ................................................ C- 65
SII ........................................................ C- 65 STATE .................................................... C- 65
STREET ................................................... C- 66 UIC ....................................................... C- 66
UIC_ SII .................................................... C- 67 VO ........................................................ C- 67
ZIP ........................................................ C- 68 ZIP_ EXT ................................................... C- 68
TITLE_ HIST ...................................................... C- 69 DATE_ CREATED ............................................ C- 69
PROD_ ID .................................................. C- 69 PRODUCT_ NUMBER ........................................ C- 70
VO ............................................................. C- 71 CITY ...................................................... C- 71
COM_ PH ................................................... C- 71 DATE_ CREATED ............................................ C- 72
DATE_ MODIFIED ........................................... C- 72 DSN_ PH ................................................... C- 73
E_ MAIL ................................................... C- 73 FAX_ SECURE .............................................. C- 74
FAX_ UNCLASS ............................................. C- 74 FIRST ..................................................... C- 75
LAST ...................................................... C- 75 MI ........................................................ C- 76
NEXT_ ORG ................................................ C- 76 ORG ...................................................... C- 77
REVIEWER ................................................. C- 77 SEC_ PHONE ................................................ C- 78
STATE .................................................... C- 78 STREET ................................................... C- 79
VO ........................................................ C- 79 5
5 Page 6 7
vi
ZIP ........................................................ C- 80 ZIP_ EXT ................................................... C- 80 6
6 Page 7 8
C- 1
C1.0 LOGICAL ORGANIZATION OF DYNAMIC DATA.
Appendix C describes the Dynamic 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: PROD_ CLASSIFICATION
DESCRIPTION: The PROD_ CLASSIFICATION table contains the information identifying the classification associated with a product. The data elements
CLASS_ LEVEL and CLASSIFICATION identify the classification level and the abbreviated classification, and PROD_ ID identifies the product.

DATA ELEMENT: CLASS_ LEVEL
Synonymous Name: None
Definition: CLASS_ LEVEL is an integer indentifying the classification level. This value is to 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 7
7 Page 8 9
C- 2
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

DATA ELEMENT: PROD_ ID
Synonymous Name: Product ID
Definition: PROD_ ID is a system generated value that uniquely identifies the product.
Format: Character
Length: 8
Range of Values: See PRODUCT. PROD_ ID
Comments: None 8
8 Page 9 10
C- 3
TABLE NAME: PROD_ PRD
DESCRIPTION: The PROD_ PRD table contains the information identifying the producers associated with a product. The data elements PRODUCER and TYPE
identify the producer and type (primary or secondary), and PROD_ ID identifies the product.

DATA ELEMENT: DATE_ CREATED
Synonymous Name: None
Definition: DATE_ CREATED contains the date the record is created. This value is generated by the system and added to the record when it is stored.

Format: Smalldatetime
Length: 8
Range of Values: This value will be a system generated date.
Comments: None 9
9 Page 10 11
C- 4
DATA ELEMENT: PRODUCER
Synonymous Name: Producer Code
Definition: PRODUCER is the code identifying the Production Center.
Format: Character
Length: 10
Range of Values: See Appendix B, PRODUCER. PRODUCER.
Comments: None

DATA ELEMENT: PROD_ ID
Synonymous Name: Product ID
Definition: PROD_ ID is a system generated value that uniquely identifies the product.
Format: Character
Length: 8
Range of Values: See PRODUCT. PROD_ ID
Comments: None 10
10 Page 11 12
C- 5
DATA ELEMENT: TYPE
Synonymous Name: None
Definition: TYPE identifies the producer as Primary or Secondary.
Format: Character
Length: 1
Range of Values:
CODE DEFINITION P Primary Producer
C Collaborative Producer
Comments: None 11
11 Page 12 13
C- 6
TABLE NAME: PROD_ REQ
DESCRIPTION: The PROD_ REQ table identifies the producers associated with a PR. This table contains the PRODUCER element, which identifies the producer, the
TYPE element, which indicates whether the producer is primary or secondary, and the REQ_ ID and REQ_ ID_ UP elements, which identify the
PR.

DATA ELEMENT: DATE_ CREATED
Synonymous Name: None
Definition: DATE_ CREATED is the date the record is created. This value is generated by the system and added to the record when it is stored.

Format: Smalldatetime
Length: 8
Range of Values: This value will be a system generated date.
Comments: None

DATA ELEMENT: PRODUCER
Synonymous Name: Producer Code
Definition: PRODUCER is the code identifying the Production Center.
Format: Character
Length: 10
Range of Values: See Appendix B, PRODUCER. PRODUCER. 12
12 Page 13 14
C- 7
Comments: None 13
13 Page 14 15
C- 8
DATA ELEMENT: REQ_ ID
Synonymous Name: Req ID, Request ID, PR Number, Customer Number
Definition: The REQ_ ID value is a system generated. This value and the REQ_ ID_ UP value are used to identify the PR and all PRs that are parsed
from the original PR.
Format: Character
Length: 11
Range of Values: See REQUEST. REQ_ ID
Comments: None

DATA ELEMENT: REQ_ ID_ UP
Synonymous Name: None
Definition: REQ_ ID_ UP is used in combination with the REQ_ ID value to identify a PR.

Format: Integer
Length: 8
Range of Values: This is a system generated one- up- number.
Comments: None 14
14 Page 15 16
C- 9
DATA ELEMENT: TYPE
Synonymous Name: None
Definition: TYPE identifies the producer as Primary or Secondary.
Format: Character
Length: 1
Range of Values:
CODE DEFINITION P Primary Producer
C Collaborative Producer
Comments: None 15
15 Page 16 17
C- 10
TABLE NAME: PRODUCT_ REQ_ LINK
DESCRIPTION: The PRODUCT_ REQ_ LINK table identifies products that satisfy PRs. The PROD_ ID value identifies the product, and the REQ_ ID and
REQ_ ID_ UP values identify the PR.

DATA ELEMENT: DATE_ CREATED
Synonymous Name: None
Definition: DATE_ CREATED contains the date the record is created. This value is generated by the system and added to the record when it is stored.

Format: Smalldatetime
Length: 8
Range of Values: This value will be a system generated date.
Comments: None

DATA ELEMENT: PROD_ ID
Synonymous Name: Product ID
Definition: PROD_ ID is a system generated value that uniquely identifies the product.
Format: Character
Length: 8
Range of Values: See PRODUCT. PROD_ ID
Comments: None 16
16 Page 17 18
C- 11
DATA ELEMENT: REQ_ ID
Synonymous Name: Req ID, Request ID, PR Number, Customer Number
Definition: The REQ_ ID value is a system generated. This value and the REQ_ ID_ UP value are used to identify the PR and all PRs that are parsed
from the original PR.
Format: Character
Length: 11
Range of Values: See REQUEST. REQ_ ID
Comments: None

DATA ELEMENT: REQ_ ID_ UP
Synonymous Name: None
Definition: REQ_ ID_ UP is used in combination with the REQ_ ID value to identify a PR.

Format: Integer
Length: 8
Range of Values: This is a system generated one- up- number.
Comments: None 17
17 Page 18 19
C- 12
TABLE NAME: PRODUCT
DESCRIPTION: The PRODUCT table contains the information describing the PRODUCT.

DATA ELEMENT: ABSTRACT
Synonymous Name: None
Definition: ABSTRACT describes the content and purpose of the product, to include automated data bases.

Format: Character
Length: 500
Range of Values: This value is free form text.
Comments: None

DATA ELEMENT: COVER_ DATE
Synonymous Name: None
Definition: COVER_ DATE is the date on the cover of the product, or the date the product is ready for dissemination.

Format: Smalldatetime
Length: 8
Range of Values: This value contains two parts. The first two characters are the Publication Year, which is the calendar year as opposed to the Fiscal Year. The last
two characters are the Publication Month (01 - 12).
Comments: None 18
18 Page 19 20
C- 13 19
19 Page 20 21
C- 14
DATA ELEMENT: DATE_ CREATED
Synonymous Name: None
Definition: DATE_ CREATED contains the date the record is created. This value is generated by the system and added to the record when it is stored.

Format: Smalldatetime
Length: 8
Range of Values: This value will be a system generated date.
Comments: None

DATA ELEMENT: DATE_ DISSEM
Synonymous Name: None
Definition: DATE_ DISSEM is the date the product is actually disseminated.
Format: Smalldatetime
Length: 8
Range of Values: YY/ MM/ DD.
Comments: None 20
20 Page 21 22
C- 15
DATA ELEMENT: DATE_ MODIFIED
Synonymous Name: None
Definition: DATE_ MODIFIED contains the date the record was modified. This value is system generated and stored on the record when the record is modified.

Format: Timestamp
Length: 8
Range of Values: This value will be a system generated date.
Comments: None

DATA ELEMENT: FQ_ DISSEM
Synonymous Name: Dissem Qtr
Definition: FQ_ DISSEM identifies the Fiscal Quarter in which a product is targeted for production or dissemination. This value is used for scheduling
purposes, and is only changed to reflect scheduling changes. This value is not changed to match the actual quarter of dissemination.

Format: Tinyint
Length: 1
Range of Values: 1 - 4, see Appendix B, FQ. FQ.
Comments: None 21
21 Page 22 23
C- 16
DATA ELEMENT: FY_ DISSEM
Synonymous Name: Dissem Yr
Definition: FY_ DISSEM identifies the Fiscal Year in which a product is targeted for production or dissemination. This value is used for scheduling purposes,
and is only changed to reflect scheduling changes. This value is not changed to match the actual quarter of dissemination.

Format: Tinyint
Length: 1
Range of Values: YY.
Comments: None

DATA ELEMENT: FREQUENCY
Synonymous Name: None
Definition: FREQUENCY is a one or two word description of the frequency CODE.
Format: Character
Length: 1
Range of Values: See Appendix B, FREQUENCY. CODE. The default value is "O" - One Time.

Comments: None 22
22 Page 23 24
C- 17
DATA ELEMENT: ICOD
Synonymous Name: None
Definition: ICOD identifies the Information Cut- Off Date which indicates the currency of information within the product.

Format: Datetime
Length: 8
Range of Values: YY/ MM/ DD.
Comments: None

DATA ELEMENT: LENGTH
Synonymous Name: None
Definition: LENGTH is the length of the product. The value indicates pages for hardcopy documents, minutes for video products, a record count for data
base products, etc.
Format: Integer
Length: 4
Range of Values: 0001 - 9999
Comments: None 23
23 Page 24 25
C- 18
DATA ELEMENT: PROD_ ID
Synonymous Name: Product ID
Definition: PROD_ ID is a system generated value that uniquely identifies the product.
Format: Character
Length: 8
Range of Values: PROD_ ID is system generated. The first two characters would be production center code. The next two characters are the Fiscal Year. The
final four characters are a one- up- number. A sample number would be: PG950001.

Comments: None
DATA ELEMENT: PROD_ TYPE
Synonymous Name: None
Definition: PROD_ TYPE is a one or two character code identifying the type of product.

Format: Character
Length: 2
Range of Values: See Appendix B, PROD_ TYPE. CODE.
Comments: None 24
24 Page 25 26
C- 19
DATA ELEMENT: PRODUCT_ NUMBER
Synonymous Name: Product Short Title
Definition: PRODUCT_ NUMBER is the product number (old Short Title) of the product. It is initially system generated but can be modified by the
Production Manager.
Format: Character
Length: 16
Range of Values: The first four characters identify the Producer. The next four characters are the primary IFC code from the PR. The next four characters are a
system generated one- up- number. The Production Manager can change these characters to valid Country Code to indicate the product is an MCS.
The last two characters are the calendar year. The values are hyphen separated. A sample would be: NAIC- 1500- 001- 94 or NAIC- 2600- IZ- 94
(MCS).
Comments: None

DATA ELEMENT: PROGRAM
Synonymous Name: None
Definition: PROGRAM is the code assigned to the Special Production Program.
Format: Character
Length: 1
Range of Values: See Appendix B, PROGRAM. CODE.
Comments: None 25
25 Page 26 27
C- 20
DATA ELEMENT: TITLE
Synonymous Name: None
Definition: TITLE is the title of the product, automated data base, or activity.
Format: Character
Length: 160
Range of Values: The TITLE is free form text.
Comments: None 26
26 Page 27 28
C- 21
TABLE NAME: PROD_ CC
DESCRIPTION: This table is a relational table used to store the Country Codes (single/ multiple) assigned to a product.

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: PROD_ ID
Synonymous Name: Product ID
Definition: PROD_ ID is the unique number assigned to each product. This value is generated from the PRODUCER CODE, the Fiscal Year, and a three digit,
zero padded, numeric, one- up- number.
Format: Character
Length: 8
Range of Values: See PRODUCT. PROD_ ID
Comments: None 27
27 Page 28 29
C- 22
DATA ELEMENT: TYPE
Synonymous Name: None
Definition: TYPE identifies the Producer as Primary or Secondary.
Format: Character
Length: 1
Range of Values:
TYPE DEFINITION P Primary
S Secondary
Comments: None 28
28 Page 29 30
C- 23
TABLE NAME: PROD_ CLASSIFICATION
DESCRIPTION: This table is a relational table used to store the Product Classifications assigned to a product.

DATA ELEMENT: CLASS_ LEVEL
Synonymous Name: None
Definition: CLASS_ LEVEL indentifies the classification level of the product. This value is 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 29
29 Page 30 31
C- 24 30
30 Page 31 32
C- 25
DATA ELEMENT: PROD_ ID
Synonymous Name: Product ID
Definition: PROD_ ID is the unique number assigned to each product. This value is generated from the PRODUCER CODE, the Fiscal Year, and a three digit,
zero padded, numeric, one- up- number.
Format: Character
Length: 8
Range of Values: See PRODUCT. PROD_ ID
Comments: None

DATA ELEMENT: TYPE
Synonymous Name: None
Definition: TYPE identifies the Country as Primary or Secondary.
Format: Character
Length: 1
Range of Values:
TYPE DEFINITION P Primary
S Secondary
Comments: None 31
31 Page 32 33
C- 26
TABLE NAME: PROD_ IFC
DESCRIPTION: This table is a relational table used to store the Intelligence Functional Code (IFC) assigned to a product.

DATA ELEMENT: IFC
Synonymous Name: INTELLIGENCE FUNCTIONAL CODE
Definition: IFC is the unique code assigned to a specific area of intelligence for collection, production, and dissemination.

Format: Character
Length: 4
Range of Values: See IFC_ CODES. IFC.
Comments: None

DATA ELEMENT: PROD_ ID
Synonymous Name: Product ID
Definition: PROD_ ID is the unique number assigned to each product. This value is generated from the PRODUCER CODE, the Fiscal Year, and a three digit,
zero padded, numeric, one- up- number.
Format: Character
Length: 8
Range of Values: See PRODUCT. PROD_ ID
Comments: None 32
32 Page 33 34
C- 27 33
33 Page 34 35
C- 28
DATA ELEMENT: TYPE
Synonymous Name: None
Definition: TYPE identifies the IFC as Primary or Secondary.
Format: Character
Length: 1
Range of Values:
TYPE DEFINITION P Primary
S Secondary
Comments: None 34
34 Page 35 36
C- 29
TABLE NAME: PROD_ MEDIA
DESCRIPTION: This table is a relational table used to store the media for each product.

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

DATA ELEMENT: PROD_ ID
Synonymous Name: Product ID
Definition: PROD_ ID is the unique number assigned to each product. This value is generated from the PRODUCER CODE, the Fiscal Year, and a three digit,
zero padded, numeric, one- up- number.
Format: Character
Length: 8
Range of Values: See PRODUCT. PROD_ ID
Comments: None 35
35 Page 36 37
C- 30
TABLE NAME: PR_ MSGS
DESCRIPTION: The PR_ MSGS table will contain the messages generated from DoDIMS/ COLISEUM. The REQ_ ID and REQ_ ID_ UP data elements
identify the PR. The SE_ MAIL and RE_ MAIL data elements identify the sender and recipient of the message.

DATA ELEMENT: MESSAGE
Synonymous Name: None
Definition: MESSAGE is the message sent between users.
Format: Text
Length: Unlimited
Range of Values: The MESSAGE value is free form text. The message is typed, or pasted by the user.

Comments: None

DATA ELEMENT: REQ_ ID
Synonymous Name: Req ID, Request ID, PR Number, Customer Number
Definition: The REQ_ ID value is system generated. This value and the REQ_ ID_ UP value are used to identify the PR and all PRs that are parsed from the
original PR.
Format: Character
Length: 11
Range of Values: See REQUEST. REQ_ ID 36
36 Page 37 38
C- 31
Comments: None 37
37 Page 38 39
C- 32
DATA ELEMENT: REQ_ ID_ UP
Synonymous Name: None
Definition: REQ_ ID_ UP is used in combination with the REQ_ ID value to identify a PR.

Format: Integer
Length: 3
Range of Values: This is a system generated one- up- number.
Comments: None

DATA ELEMENT: RE_ MAIL
Synonymous Name: None
Definition: RE_ MAIL is the recipient's electronic mail address.
Format: Character
Length: 30
Range of Values: A valid E- Mail address. The format of the E- Mail address may differ by Host.

Comments: None 38
38 Page 39 40
C- 33
DATA ELEMENT: RNAME
Synonymous Name: None
Definition: RNAME contains the name of the recipient of the E- Mail message.
Format: Character
Length: 30
Range of Values: The RNAME value differs by Host.
Comments: None

DATA ELEMENT: SE_ MAIL
Synonymous Name: None
Definition: SE_ MAIL is the originator's electronic mail address.
Format: Character
Length: 30
Range of Values: A valid E- Mail address. The format of the E- Mail address may differ by Host.

Comments: None 39
39 Page 40 41
C- 34
DATA ELEMENT: SNAME
Synonymous Name: None
Definition: SNAME contains the name of the originator of the E- Mail message.
Format: Character
Length: 30
Range of Values: The SNAME value differs by Host.
Comments: None

DATA ELEMENT: SUBJECT
Synonymous Name: None
Definition: SUBJECT is the Subject of the PR. This value is copied to the message from the PR under review.

Format: Character
Length: 65
Range of Values: SUBJECT is free form text.
Comments: None 40
40 Page 41 42
C- 35
TABLE NAME: REQ_ ACTION
DESCRIPTION: The REQ_ ACTION table stores a history of a PR. The data elements REQ_ ID and REQ_ ID_ UP identify the PR. The data element VO
identifies the Validation Office that has reviewed the PR. The ACTION_ TO and ACTION_ THRU data elements identify actions taken
and actions waiting against the PR.

DATA ELEMENT: ACTION
Synonymous Name: None
Definition: ACTION is a single word describing the Action applied to a PR.
Format: Character
Length: 8
Range of Values: See Appendix B, ACTION. CODE
Comments: None

DATA ELEMENT: ACTION_ TO
Synonymous Name: None
Definition: ACTION_ TO identifies the organization that recieves the PR after an action has been taken.

Format: Character
Length: 30
Range of Values: An organization or title from the Requestor table. 41
41 Page 42 43
C- 36
Comments: None 42
42 Page 43 44
C- 37
DATA ELEMENT: ACTION_ THRU
Synonymous Name: None
Definition: ACTION_ THRU identifies the organization the PR passed through.
Format: Character
Length: 30
Range of Values: An organization or title from the Requestor table.
Comments: None

DATA ELEMENT: DATE_ CREATED
Synonymous Name: None
Definition: DATE_ CREATED contains the date the record is created. This value is generated by the system and added to the record when it is stored.

Format: Smalldatetime
Length: 8
Range of Values: This value will be a system generated date.
Comments: None 43
43 Page 44 45
C- 38
DATA ELEMENT: REQ_ ID
Synonymous Name: Req ID, Request ID, PR Number, Customer Number
Definition: REQ_ ID is system generated. This value and the REQ_ ID_ UP value are used to identify the PR and all PRs that are parsed from the original PR.

Format: Character
Length: 11
Range of Values: See REQUEST. REQ_ ID
Comments: None

DATA ELEMENT: REQ_ ID_ UP
Synonymous Name: None
Definition: REQ_ ID_ UP is used in combination with the REQ_ ID value to identify a PR.

Format: Integer
Length: 3
Range of Values: This is a system generated one- up- number.
Comments: None 44
44 Page 45 46
C- 39
DATA ELEMENT: VO
Synonymous Name: Validation Office
Definition: VO is the code assigned to the Validation office.
Format: Character
Length: 2
Range of Values: See the MIIDS/ IDB Data Dictionary RESPROD values.
Comments: None 45
45 Page 46 47
C- 40
TABLE NAME: REQ_ CC
DESCRIPTION: The REQ_ CC table identifies the Country Codes associated with a PR. The REQ_ ID and REQ_ ID_ UP values identify the PR. The CC value
identifies the country, and the TYPE value identifies the country as primary or secondary.

DATA ELEMENT: DATE_ CREATED
Synonymous Name: None
Definition: DATE_ CREATED contains the date the record is created. This value is generated by the system and added to the record when it is stored.

Format: Smalldatetime
Length: 8
Range of Values: This value will be a system generated date.
Comments: None

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 46
46 Page 47 48
C- 41 47
47 Page 48 49
C- 42
DATA ELEMENT: REQ_ ID
Synonymous Name: Req ID, Request ID, PR Number, Customer Number
Definition: REQ_ ID is a system generated. This value and the REQ_ ID_ UP value are used to identify the PR and all PRs that are parsed from the original PR.

Format: Character
Length: 11
Range of Values: See REQUEST. REQ_ ID
Comments: None

DATA ELEMENT: REQ_ ID_ UP
Synonymous Name: None
Definition: REQ_ ID_ UP is used in combination with the REQ_ ID value to identify a PR.

Format: Integer
Length: 3
Range of Values: This is a system generated one- up- number.
Comments: None 48
48 Page 49 50
C- 43
DATA ELEMENT: TYPE
Synonymous Name: None
Definition: TYPE identifies the country as primary or secondary.
Format: Character
Length: 1
Range of Values:
CODE DEFINITION P Primary
S Secondary
Comments: None 49
49 Page 50 51
C- 44
TABLE NAME: REQ_ CLASSIFICATION
DESCRIPTION: The REQ_ CLASSIFICATION table contains the information identifying the classification associated with a PR. The data elements
CLASS_ LEVEL and CLASSIFICATION identify the classification level and the abbreviated classification. REQ_ ID and REQ_ ID_ UP values
identify the PR.

DATA ELEMENT: CLASS_ LEVEL
Synonymous Name: None
Definition: CLASS_ LEVEL indentifies 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 50
50 Page 51 52
C- 45
markings.
Comments: None 51
51 Page 52 53
C- 46
DATA ELEMENT: REQ_ ID
Synonymous Name: Req ID, Request ID, PR Number, Customer Number
Definition: REQ_ ID is system generated. This value and the REQ_ ID_ UP value are used to identify the PR and all PRs that are parsed from the original PR.

Format: Character
Length: 11
Range of Values: The REQ_ ID value is generated based on the SII or UIC, the Fiscal Year, and a one- up- number. The specific format is: SII- FY- nnn or UIC- FY- nnn.

Comments: None

DATA ELEMENT: REQ_ ID_ UP
Synonymous Name: None
Definition: REQ_ ID_ UP is used in combination with the REQ_ ID value to identify a PR.

Format: Integer
Length: 3
Range of Values: This is a system generated one- up- number.
Comments: None 52
52 Page 53 54
C- 47
TABLE NAME: REQ_ IFC
DESCRIPTION: The REQ_ IFC table identifies the IFCs associated with a PR. The REQ_ ID and REQ_ ID_ UP values identify the PR. The IFC value
identifies the IFC, and the TYPE value identifies the IFC as primary or secondary.

DATA ELEMENT: DATE_ CREATED
Synonymous Name: None
Definition: DATE_ CREATED contains the date the record is created. This value is generated by the system and added to the record when it is stored.

Format: Smalldatetime
Length: 8
Range of Values: This value will be a system generated date.
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. 53
53 Page 54 55
C- 48
Comments: None 54
54 Page 55 56
C- 49
DATA ELEMENT: REQ_ ID
Synonymous Name: Req ID, Request ID, PR Number, Customer Number
Definition: REQ_ ID is system generated. This value and the REQ_ ID_ UP value are used to identify the PR and all PRs that are parsed from the original PR.

Format: Character
Length: 11
Range of Values: See REQUEST. REQ_ ID
Comments: None

DATA ELEMENT: REQ_ ID_ UP
Synonymous Name: None
Definition: REQ_ ID_ UP is used in combination with the REQ_ ID value to identify a PR.

Format: Integer
Length: 3
Range of Values: This is a system generated one- up- number.
Comments: None 55
55 Page 56 57
C- 50
DATA ELEMENT: TYPE
Synonymous Name: None
Definition: TYPE identifies the IFC as primary or secondary.
Format: Character
Length: 1
Range of Values:
CODE DEFINITION P Primary
S Secondary
Comments: None 56
56 Page 57 58
C- 51
TABLE NAME: REQ_ MEDIA
DESCRIPTION: This table is a relational table used to store the media for each requirement.

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

DATA ELEMENT: REQ_ ID
Synonymous Name: Req ID, Request ID, PR Number, Customer Number
Definition: REQ_ ID is system generated. This value and the REQ_ ID_ UP value are used to identify the PR and all PRs that are parsed from the original PR.

Format: Character
Length: 11
Range of Values: The REQ_ ID value is generated based on the SII or UIC, the Fiscal Year, and a one- up- number. The specific format is: SII- FY- nnn or UIC- FY- nnn.

Comments: None 57
57 Page 58 59
C- 52
DATA ELEMENT: REQ_ ID_ UP
Synonymous Name: None
Definition: REQ_ ID_ UP is used in combination with the REQ_ ID value to identify a PR.

Format: Integer
Length: 3
Range of Values: This is a system generated one- up- number.
Comments: None 58
58 Page 59 60
C- 53
TABLE NAME: REQUEST
DESCRIPTION: The REQUEST table contains the Production Request information.

DATA ELEMENT: CLASS_ OVERALL
Synonymous Name: None
Definition: CLASS_ REQ contains the computed overall classification of the PR. The system computes this value based on the highest classification values in
CLASS_ SUBJECT and CLASS_ REQUEST. This is a hidden field.
Format: Character
Length: 30
Range of Values: See Appendix B, CLASSIFICATION. CODE.
Comments: None

DATA ELEMENT: CLASS_ PRODUCT
Synonymous Name: PROD_ CLASS
Definition: CLASS_ PRODUCT identifies the requested classification of the intelligence product. This includes caveats and disclosure instructions,
allowing the requestor to receive a response tailored to the target audience.
Format: Character
Length: 60
Range of Values: See Appendix B, CLASSIFICATION. CODE.
Comments: None 59
59 Page 60 61
C- 54 60
60 Page 61 62
C- 55
DATA ELEMENT: CLASS_ REQUEST
Synonymous Name: None
Definition: CLASS_ REQUEST is the classification of the Statement of Requirement. The CLASS_ REQUEST field will be displayed as part of the Statement of
Requirement.
Format: Character
Length: 30
Range of Values: See Appendix B, CLASSIFICATION. CODE.
Comments: None

DATA ELEMENT: CLASS_ SUBJECT
Synonymous Name: None
Definition: CLASS_ SUBJECT is the classification of the subject. The CLASS_ SUBJECT field will be displayed as part of the SUBJECT field.

Format: Character
Length: 30
Range of Values: See Appendix B, CLASSIFICATION. CODE.
Comments: None 61
61 Page 62 63
C- 56
DATA ELEMENT: CREATED_ BY
Synonymous Name: None
Definition: CREATED_ BY is the Login ID of the user who entered the PR. This is a hidden field.

Format: Character
Length: 10
Range of Values: The CREATED_ BY format differs by site. The value is a valid Logon ID.
Comments: None

DATA ELEMENT: DATE_ CREATED
Synonymous Name: None
Definition: DATE_ CREATED is the date the record is created. This value is generated by the system and added to the record when it is stored. This is
a hidden field.
Format: Smalldatetime
Length: 8
Range of Values: This value will be a system generated date.
Comments: None 62
62 Page 63 64
C- 57
DATA ELEMENT: DATE_ MODIFIED
Synonymous Name: None
Definition: DATE_ MODIFIED is the date the record was modified. This value is system generated and stored on the record when the record is modified.
This is a hidden field.
Format: Timestamp
Length: 8
Range of Values: This value will be a system generated date.
Comments: None

DATA ELEMENT: EXERCISE_ NAME
Synonymous Name: None
Definition: EXERCISE_ NAME is the name of the exercise for which the PR is submitted.

Format: Character
Length: 65
Range of Values: A current, valid exercise name.
Comments: None 63
63 Page 64 65
C- 58
DATA ELEMENT: FQ_ DISSEM
Synonymous Name: Dissem Qtr
Definition: FQ_ DISSEM identifies the Fiscal Quarter in which a product is targeted for production or dissemination. This value is used for scheduling
purposes, and is only changed to reflect scheduling changes. This value is not changed to match the actual quarter of dissemination.

Format: Tinyint
Length: 1
Range of Values: 1 - 4, see Appendix B, FQ. FQ.
Comments: None

DATA ELEMENT: FROM
Synonymous Name: None
Definition: FROM identifies the organization forwarding the PR.
Format: Character
Length: 30
Range of Values: A valid UIC or SII code.
Comments: None 64
64 Page 65 66
C- 59
DATA ELEMENT: FY_ DISSEM
Synonymous Name: Dissem Yr
Definition: FY_ DISSEM identifies the Fiscal Year in which a product is targeted for production or dissemination. This value is used for scheduling purposes,
and is only changed to reflect scheduling changes. This value is not changed to match the actual quarter of dissemination.

Format: Tinyint
Length: 1
Range of Values: This value will be the Fiscal Year.
Comments: None

DATA ELEMENT: FREQUENCY
Synonymous Name: None
Definition: FREQUENCY is a one or two word description of the frequency CODE indicating the frequency which the customer would like to receive the
intelligence.
Format: Character
Length: 1
Range of Values: See Appendix B, FREQUENCY. CODE.
Comments: None 65
65 Page 66 67
C- 60
DATA ELEMENT: IFC_ PRIORITY
Synonymous Name: None
Definition: IFC_ PRIORITY is the value assigned from the Production Priorities table based on the IFC and Country Code values assigned to the PR. This is a
hidden field.
Format: Character
Length: 5
Range of Values: See the Production Priorities matrix.
Comments: None

DATA ELEMENT: JUSTIFICATION
Synonymous Name: None
Definition: JUSTIFICATION is an aid to the intelligence operations officer and the producer to guide them in determining the relative priorities of the requests
they receive over time. It also is a proxy for the user's priority.
Format: Character
Length: 40
Range of Values: See Appendix B, JUSTIFICATION. JUSTIFICATION
Comments: None 66
66 Page 67 68
C- 61
DATA ELEMENT: LTIOV
Synonymous Name: LTIOV
Definition: LTIOV contains a date time group indicating the Lastest Time the Information Is Of Value.

Format: Smalldatetime
Length: 8
Range of Values: Zulu time format.
Comments: None

DATA ELEMENT: MEDIA
Synonymous Name: None
Definition: MEDIA is the code assigned to the media type.
Format: Character
Length: 2
Range of Values: See Appendix B, MEDIA. CODE.
Comments: None 67
67 Page 68 69
C- 62
DATA ELEMENT: ORG
Synonymous Name: Organization
Definition: ORG is the full organization name of the organization requesting the intelligence.

Format: Character
Length: 55
Range of Values: A- Z, 0- 9
Comments: None

DATA ELEMENT: PROD_ TYPE
Synonymous Name: None
Definition: PROD_ TYPE is the code identifying the type of intelligence product being requested.

Format: Character
Length: 2
Range of Values: See Appendix B, PROD_ TYPE. CODE.
Comments: None 68
68 Page 69 70
C- 63
DATA ELEMENT: REQ_ ID
Synonymous Name: Req ID, Request ID, PR Number, Customer Number
Definition: REQ_ ID is system generated. This value and the REQ_ ID_ UP value are used to identify the PR and all PRs that are parsed from the original PR.

Format: Character
Length: 11
Range of Values: The REQ_ ID value is generated based on the SII or UIC, the Fiscal Year, and a one- up- number. The specific format is: SII- FY- nnn or UIC- FY- nnn.

Comments: None

DATA ELEMENT: REQ_ ID_ UP
Synonymous Name: None
Definition: REQ_ ID_ UP is used in combination with the REQ_ ID value to identify a PR.

Format: Integer
Length: 3
Range of Values: This is a system generated one- up- number.
Comments: None 69
69 Page 70 71
C- 64
DATA ELEMENT: REQUEST
Synonymous Name: Statement of Requirement
Definition: REQUEST is the full text statement of intelligence requirement. This value is formerly block 10 on DD FORM 1497.

Format: Text
Length: Unlimited
Range of Values: REQUEST is free form text.
Comments: None

DATA ELEMENT: REQ_ DTG
Synonymous Name: Request DTG
Definition: REQ_ DTG is a system- generated field indicating the Request Date/ Time. The VO may change the Request Date/ Time if required.

Format: Smalldatetime
Length: 8
Range of Values: REQ_ DTG must be entered in Zulu date/ time format.
Comments: None 70
70 Page 71 72
C- 65
DATA ELEMENT: REVIEWER
Synonymous Name: None
Definition: REVIEWER is the Logon ID of the user who modified the record. This value is added to the record by the system when modifications are made to
the record. This is an internally generated field and does not appear on the screen.

Format: Character
Length: 10
Range of Values: The REVIEWER format differs by site. The value is a valid Logon ID.
Comments: None

DATA ELEMENT: SIO
Synonymous Name: Supporting Intelligence Office, SPT INTEL OFF
Definition: SIO is the organization name of the Supporting Intelligence Office entering the PR into the system.

Format: Character
Length: 30
Range of Values: A valid organization name.
Comments: None 71
71 Page 72 73
C- 66
DATA ELEMENT: SUBJECT
Synonymous Name: None
Definition: SUBJECT is the subject, or brief description, of the PR.
Format: Character
Length: 255
Range of Values: This value is free form text.
Comments: None

DATA ELEMENT: SUSPENSE
Synonymous Name: Suspense DTG, OTIOV
Definition: SUSPENSE is the Date/ Time group indicating the optimum time the requested intelligence will be of value.

Format: Smalldatetime
Length: 8
Range of Values: The SUSPENSE will be a date in Zulu time format.
Comments: None 72
72 Page 73 74
C- 67
DATA ELEMENT: USER_ PRIORITY
Synonymous Name: PRIORITY
Definition: USER_ PRIORITY is the priority associated to the JUSTIFICATION data element.

Format: Integer
Length: 2
Range of Values: See Appendix B, JUSTIFICATION. PRIORITY
Comments: None

DATA ELEMENT: VO
Synonymous Name: Validation Office
Definition: VO is the code assigned to the Validation office.
Format: Character
Length: 2
Range of Values: See the MIIDS/ IDB Data Dictionary RESPROD values.
Comments: None 73
73 Page 74 75
C- 68
TABLE NAME: REQUESTOR
DESCRIPTION: The REQUESTOR table contains the information identifying organizations requesting intelligence.

DATA ELEMENT: CITY
Synonymous Name: None
Definition: CITY is the name of the nearest city to the requesting organization.
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 requesting organization.
Format: Character
Length: 13
Range of Values: 0- 9
Comments: None 74
74 Page 75 76
C- 69
DATA ELEMENT: DATE_ CREATED
Synonymous Name: None
Definition: DATE_ CREATED is the date the record is created. This value is generated by the system and added to the record when it is stored.

Format: Smalldatetime
Length: 8
Range of Values: This value will be a system generated date.
Comments: None

DATA ELEMENT: DATE_ MODIFIED
Synonymous Name: None
Definition: DATE_ MODIFIED is the date the record was modified. This value is system generated and stored on the record when the record is modified.

Format: Timestamp
Length: 8
Range of Values: This value will be a system generated date.
Comments: None 75
75 Page 76 77
C- 70
DATA ELEMENT: DSN_ PH
Synonymous Name: None
Definition: DSN_ PH is the autovon phone number for the requesting organization.
Format: Character
Length: 13
Range of Values: 0- 9
Comments: None

DATA ELEMENT: E_ MAIL
Synonymous Name: None
Definition: E_ MAIL is the E- Mail address for the SIO of the requesting organization.
Format: Character
Length: 30
Range of Values: A valid E- Mail address.
Comments: None 76
76 Page 77 78
C- 71
DATA ELEMENT: FAX_ SECURE
Synonymous Name: None
Definition: FAX_ SECURE is the secure FAX phone number for the requesting organization.

Format: Character
Length: 13
Range of Values: 0- 9
Comments: None

DATA ELEMENT: FAX_ UNCLASS
Synonymous Name: None
Definition: FAX_ UNCLASS is the commercial FAX phone number for the requesting organization.

Format: Character
Length: 13
Range of Values: 0- 9
Comments: None 77
77 Page 78 79
C- 72
DATA ELEMENT: FIRST
Synonymous Name: None
Definition: FIRST is the Requestor's First Name.
Format: Character
Length: 30
Range of Values: A- Z
Comments: None

DATA ELEMENT: LAST
Synonymous Name: None
Definition: LAST_ NAME is the Requestor's Last Name.
Format: Character
Length: 30
Range of Values: A- Z
Comments: None 78
78 Page 79 80
C- 73
DATA ELEMENT: MI
Synonymous Name: None
Definition: MI is the Requestor's Middle Initial.
Format: Character
Length: 1
Range of Values: A- Z
Comments: None

DATA ELEMENT: NEXT_ ORG
Synonymous Name: None
Definition: NEXT_ ORG is the next organization in the chain of command.
Format: Character
Length: 55
Range of Values: A valid organization name.
Comments: None 79
79 Page 80 81
C- 74
DATA ELEMENT: ORG
Synonymous Name: Organization
Definition: ORG is the full organization name for the requesting organization.
Format: Character
Length: 55
Range of Values: A valid organization name.
Comments: None

DATA ELEMENT: REVIEWER
Synonymous Name: None
Definition: REVIEWER is the Logon ID of the user who modified the record. This value is added to the record by the system when modifications are made to
the record.
Format: Character
Length: 10
Range of Values: The REVIEWER format differs by site. The value is a valid Logon ID.
Comments: None 80
80 Page 81 82
C- 75
DATA ELEMENT: SEC_ PHONE
Synonymous Name: None
Definition: SEC_ PHONE is the Requestor's Secure phone number.
Format: Character
Length: 13
Range of Values: 0- 9
Comments: None

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

DATA ELEMENT: STATE
Synonymous Name: State Code
Definition: STATE is the abbreviation for the STATE.
Format: Character
Length: 2 81
81 Page 82 83
C- 76
Range of Values: See Appendix B, STATE. CODE.
Comments: None 82
82 Page 83 84
C- 77
DATA ELEMENT: STREET
Synonymous Name: None
Definition: STREET is the requesting organization street address.
Format: Character
Length: 40
Range of Values: A- Z, 0- 9
Comments: None

DATA ELEMENT: UIC
Synonymous Name: None
Definition: UIC is the requesting organization's Unit Identification Code (UIC).
Format: Character
Length: 6
Range of Values: See UIC. UIC.
Comments: None 83
83 Page 84 85
C- 78
DATA ELEMENT: UIC_ SII
Synonymous Name: None
Definition: UIC_ SII is a flag indicating which code value (UIC or SII) is used for generating the REC_ ID value.

Format: Character
Length: 3
Range of Values: See UIC. UIC or SII. SII.
Comments: None

DATA ELEMENT: VO
Synonymous Name: Validation Office
Definition: VO is the code assigned to the Validation office.
Format: Character
Length: 2
Range of Values: See the MIIDS/ IDB Data Dictionary RESPROD values.
Comments: None 84
84 Page 85 86
C- 79
DATA ELEMENT: ZIP
Synonymous Name: None
Definition: ZIP is the zip code of the mailing address for the requesting organization.
Format: Integer
Length: 5
Range of Values: 0- 9
Comments: None

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 85
85 Page 86 87
C- 80
TABLE NAME: TITLE_ HIST
DESCRIPTION: The TITLE_ HIST table contains the PRODUCT_ NUMBER changes made to a product. The PROD_ ID value identifies the product. The
PRODUCT_ NUMBER is the old PRODUCT_ NUMBER. The DATE_ CREATED indicates when the PRODUCT_ NUMBER was
changed. This is a hidden table.

DATA ELEMENT: DATE_ CREATED
Synonymous Name: None
Definition: DATE_ CREATED is the date the record is created. This value is generated by the system and added to the record when it is stored.

Format: Smalldatetime
Length: 8
Range of Values: This value will be a system generated date.
Comments: None

DATA ELEMENT: PROD_ ID
Synonymous Name: Product ID
Definition: PROD_ ID is a system generated value that uniquely identifies the product.
Format: Character
Length: 8
Range of Values: See PRODUCT. PROD_ ID 86
86 Page 87 88
C- 81
Comments: None 87
87 Page 88 89
C- 82
DATA ELEMENT: PRODUCT_ NUMBER
Synonymous Name: Product Short Title
Definition: PRODUCT_ NUMBER is the old product number (prior product short title) that was replaced when the Product Number of the product record
was modified. A new record is generated for each change to the Product Number field/ value on the product record.

Format: Character
Length: 16
Range of Values: See PRODUCT. PRODUCT_ NUMBER
Comments: None 88
88 Page 89 90
C- 83
TABLE NAME: VO
DESCRIPTION: The VO table contains the information identifying validation offices.

DATA ELEMENT: CITY
Synonymous Name: None
Definition: CITY is the name of the nearest city to the validation office.
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 validation office.
Format: Character
Length: 13
Range of Values: 0- 9
Comments: None 89
89 Page 90 91
C- 84
DATA ELEMENT: DATE_ CREATED
Synonymous Name: None
Definition: DATE_ CREATED is the date the record is created. This value is generated by the system and added to the record when it is stored.

Format: Smalldatetime
Length: 8
Range of Values: This value will be a system generated date.
Comments: None

DATA ELEMENT: DATE_ MODIFIED
Synonymous Name: None
Definition: DATE_ MODIFIED is the date the record was modified. This value is system generated and stored on the record when the record is modified.

Format: Timestamp
Length: 8
Range of Values: This value will be a system generated date.
Comments: None 90
90 Page 91 92
C- 85
DATA ELEMENT: DSN_ PH
Synonymous Name: None
Definition: DSN_ PH is the autovon phone number for the validation office.
Format: Character
Length: 13
Range of Values: 0- 9
Comments: None

DATA ELEMENT: E_ MAIL
Synonymous Name: None
Definition: E_ MAIL is the E- Mail address for the SIO of the validation office.
Format: Character
Length: 30
Range of Values: A valid E- Mail address.
Comments: None 91
91 Page 92 93
C- 86
DATA ELEMENT: FAX_ SECURE
Synonymous Name: None
Definition: FAX_ SECURE is the secure FAX phone number for the validation office.
Format: Character
Length: 13
Range of Values: 0- 9
Comments: None

DATA ELEMENT: FAX_ UNCLASS
Synonymous Name: None
Definition: FAX_ UNCLASS is the commercial FAX phone number for the validation office.

Format: Character
Length: 13
Range of Values: 0- 9
Comments: None 92
92 Page 93 94
C- 87
DATA ELEMENT: FIRST
Synonymous Name: None
Definition: FIRST is the Validation Officer's First Name.
Format: Character
Length: 30
Range of Values: A- Z
Comments: None

DATA ELEMENT: LAST
Synonymous Name: None
Definition: LAST_ NAME is the Validation Officer's Last Name.
Format: Character
Length: 30
Range of Values: A- Z
Comments: None 93
93 Page 94 95
C- 88
DATA ELEMENT: MI
Synonymous Name: None
Definition: MI is the Validation Officer's Middle Initial.
Format: Character
Length: 1
Range of Values: A- Z
Comments: None

DATA ELEMENT: NEXT_ ORG
Synonymous Name: None
Definition: NEXT_ ORG is the next organization in the chain of command.
Format: Character
Length: 55
Range of Values: A valid organization name.
Comments: None 94
94 Page 95 96
C- 89
DATA ELEMENT: ORG
Synonymous Name: Organization
Definition: ORG is the full organization name for the validation office.
Format: Character
Length: 55
Range of Values: A valid organization name.
Comments: None

DATA ELEMENT: REVIEWER
Synonymous Name: None
Definition: REVIEWER is the Logon ID of the user who modified the record. This value is added to the record by the system when modifications are made to
the record.
Format: Character
Length: 10
Range of Values: The REVIEWER format differs by site. The value is a valid Logon ID.
Comments: None 95
95 Page 96 97
C- 90
DATA ELEMENT: SEC_ PHONE
Synonymous Name: None
Definition: SEC_ PHONE is the Validation Officer's Secure phone number.
Format: Character
Length: 13
Range of Values: 0- 9
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 Appendix B, STATE. CODE.
Comments: None 96
96 Page 97 98
C- 91
DATA ELEMENT: STREET
Synonymous Name: None
Definition: STREET is the validation office street address.
Format: Character
Length: 40
Range of Values: A- Z, 0- 9
Comments: None

DATA ELEMENT: VO
Synonymous Name: Validation Office
Definition: VO is the code assigned to the validation office.
Format: Character
Length: 2
Range of Values: See the MIIDS/ IDB Data Dictionary RESPROD values.
Comments: None 97
97 Page 98
C- 92
DATA ELEMENT: ZIP
Synonymous Name: None
Definition: ZIP is the zip code of the mailing address for the validation office.
Format: Integer
Length: 5
Range of Values: 0- 9
Comments: None

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 98

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 52 53 54 55 56 57 58 59
60 61 62 63 64 65 66 67 68 69
70 71 72 73 74 75 76 77 78 79
80 81 82 83 84 85 86 87 88 89
90 91 92 93 94 95 96 97 98