Field

Definition

Type

Length

Source

SI_ID

Unique identifier for this table

int

Uniqid

Corresponds to a particular report from SOPR

Varchar

36

SOPR

IssueID

A three-letter code corresponding to the general issue area.

Char

3

CRP

Issue

The long version of the three letter general issue.

Varchar

50

SOPR

SpecificIssue

The specific issue.

Varchar

Max

SOPR

Year

The Year.

Char

4

SOPR