Entity Definition Report
Run by: CASEOWNER
Run on: February 1, 2007 01:37 PM
Total Pages: 41
Total Entities: 34
Parameters
Application: LTrack
Entities: %
ER Diagram: %
Include Entity Notes? Y
Include Attribute Descriptions? Y
Include Attribute Notes? Y
Include Attribute Values? Y
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 1 of 41
Application: LTrack
APPEAL OUTCOME CODE Short Name: APOC
Plural: APPEAL OUTCOME CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Describes the outcome from any appeal.
Attributes:
Name Domain Opt Format Length
* APPEAL OUTCOME CODE STANDARD_CODE N VARCHAR2 10
Code for an appeal outcome.
DESCRIPTION STANDARD_CODE_DESCR IPTION
 N VARCHAR2 120
Description of the appeal outcome code.
EFFECTIVE DATE DATE_TIME N DATE  
Effective date/time
EXPIRY DATE DATE_TIME N DATE  
Expiry date/time
UPDATE TIMESTAMP AUDIT_DATE N DATE  
Update date/time
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE is outcome for one or more LIT_ERA_CASE_APPEAL
* = Relationships in primary unique identifier.
Unique Identifiers:
OUTCOME_CODE_PK Primary? Y
APPEAL OUTCOME CODE
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 2 of 41
Application: LTrack
CASE APPEAL Short Name: CASE_APPL
Plural: CASE APPEAL
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
ERA System administrative information related to a chronological representation of events of: alleged non-compliance; investigations; enforcement actions; reviews; appeals and final incident disposition.
Attributes:
Name Domain Opt Format Length
* CASE APPEAL ID NUMERIC_ID N NUMBER 10
Formal unique number for an ERA Case Appeal record
APPEAL NO   N NUMBER 10
Formal unique identifier for an ERA Case Appeal record
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE has case one or more LIT_ERA_CASE_APPEAL
* = Relationships in primary unique identifier.
Unique Identifiers:
CASE_UK Primary? N
APPEAL NO
CASE_PK Primary? Y
CASE APPEAL ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 3 of 41
Application: LTrack
DISCOVERY NOTE Short Name: DISC NOTE
Plural: DISCOVERY NOTE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Discovery notes are notes that are created by participants in the litigation regarding aspects of the discovery process.
Attributes:
Name Domain Opt Format Length
* DISCOVERY NOTE ID   N NUMBER 10
NOTE   N VARCHAR2 1000
CREATED BY   N VARCHAR2 30
CREATED DATE   N DATE  
UPDATED BY   N VARCHAR2 30
UPDATED DATE   N DATE  
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MUST BE has discovery note one and only one LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
DISC NOTE Primary? Y
DISCOVERY NOTE ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 4 of 41
Application: LTrack
LIT COURT LEVEL REGISTRY Short Name: LCLR
Plural: LIT COURT LEVEL REGISTRY
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Associates a court level with a registry.
Attributes:
Name Domain Opt Format Length
* COURT LEVEL REGISTRY ID NUMERIC_ID N NUMBER 10
Unique number identifying a court level registry.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE is court location of one or more LT LITIGATION
MUST BE has court one and only one LT COURT LEVEL CODE
MUST BE has registry one and only one LT REGISTRY
* = Relationships in primary unique identifier.
Unique Identifiers:
LRLRR_UKEY Primary? N
MUST BE has court one and only one LT COURT LEVEL CODE
MUST BE has registry one and only one LT REGISTRY
LCLR_PKEY Primary? Y
COURT LEVEL REGISTRY ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 5 of 41
Application: LTrack
LIT FILE DOCUMENT TRACKING Short Name: LFLRDOC
Plural: LIT FILE DOCUMENT TRACKING
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Maintains information to locate and retrieve documents associated with a litigation unit. This includes any type of physical record, such as a piece of paper, video tape, or electronic files.
Attributes:
Name Domain Opt Format Length
* LIT FILE TRACKING ID NUMERIC_ID N NUMBER 10
Unique number identifying a FILER document track.
LIT FILE TRACKING PRIMARY   Y NUMBER 5
Primary file number which is obtained from ARCS or ORCS.
 
LIT FILE TRACKING SECONDARY   Y NUMBER 2
Secondary within a primary - also from ARCS or ORCS.
 
LIT FILE TRACKING TERTIARY   N VARCHAR2 15
Final file classification breakdown to clarify individual items within the primary secondary classification.
PACKAGE IDENTITY TEXT1   Y VARCHAR2 15
Text used to identify packages that may have a further breakdown of file number or that do not have a file number.
PACKAGE IDENTITY TEXT2   Y VARCHAR2 15
Text used to further identify a package of documents that may or may not have a file number.
LIT FILE TRACKING VOLUME   N NUMBER 3
Indicates the number of the folder within one classification or file number.
INDEX   Y VARCHAR2 15
The accession and box number the information was removed from.
LIT FILE TRACKING OPEN DATE   Y DATE  
The open date of the file or package of documents.
LIT FILE TRACKING CLOSED DATE   Y DATE  
The close date or last date of the file or package of documents.
SUBJECT   N VARCHAR2 240
Subject matter of the information.
LITIGATION TECHNICIAN USER ID   Y VARCHAR2 30
MOF userid of the litigation technician who scanned the file or package.
RECEIVED DATE   Y DATE  
Date the information was received by the Litigation Services Unit.
SCAN COMPLETED DATE   Y DATE  
Date the scan was completed by the Litigation Services Unit.
RETURNED DATE   Y DATE  
Date the file or package was returned to the originating office.
LITIGATION ACCESSION   Y NUMBER 9
The unique Accession number assigned for all files provided for one litigation, and the box number the file or package is in.
CREATED BY   N VARCHAR2 30
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 6 of 41
Application: LTrack
LIT FILE DOCUMENT TRACKING (cont'd) Short Name: LFLRDOC
Userid of person inputing this entry.
CREATED DATE   N DATE  
Date the parameter form was created.
UPDATED BY   N VARCHAR2 30
Userid of person updating entry.
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE classified by one and only one LIT FILE FORMAT TYPE CODE
MAY BE has ministry office for one and only one ORG UNIT
MUST BE is a related file one and only one LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
LT FLRDOC Primary? Y
LIT FILE TRACKING ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 7 of 41
Application: LTrack
LIT FILE FORMAT TYPE CODE Short Name: LFFTC
Plural: LIT FILE FORMAT TYPE CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Identifies the format document format types.

Code Description
_______________________
CNV Conversion
DES Destroyed
DGT Digital
MCR Microfiche
HDC Hard Copy
HCM Hard Copy & Microfilm
MCF Microfilm
VID Video
PHT Photos
MSS Missing
 
Attributes:
Name Domain Opt Format Length
* LIT FILE FORMAT TYPE CODE   N VARCHAR2 6
Unique code identifying a type of media format.
DESCRIPTION   N VARCHAR2 120
Display description for the code.
EFFECTIVE DATE   N DATE  
The date the code becomes effective.
EXPIRY DATE   N DATE  
The date the code expires.
UPDATE TIMESTAMP   N DATE  
Indicates the most recent updated date.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE classifying one or more LIT FILE DOCUMENT TRACKING
* = Relationships in primary unique identifier.
Unique Identifiers:
LFFTC Primary? Y
LIT FILE FORMAT TYPE CODE
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 8 of 41
Application: LTrack
LIT PARTICIPANT TYPE CODE Short Name: LPAR TP CD
Plural: LIT PARTICIPANT TYPE CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Code that identifies the types of participants that are involved in litigation.
IE
Litigation Coordinator
Search Provider
Search Coordinator
Local Search Coordinator
 
Attributes:
Name Domain Opt Format Length
* LIT PARTICIPANT TYPE CODE   N VARCHAR2 3
Unique code identifying a participant type
DESCRIPTION   N VARCHAR2 120
Description of the participant type
EFFECTIVE DATE   N DATE  
Date the code becomes effective.
EXPIRY DATE   N DATE  
Date the code expires
UPDATE TIMESTAMP   N DATE  
The date the code was last updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE is type for one or more LIT PARTICIPANT TYPE LINK
* = Relationships in primary unique identifier.
Unique Identifiers:
PAR TYP CD Primary? Y
LIT PARTICIPANT TYPE CODE
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 9 of 41
Application: LTrack
LIT PARTICIPANT TYPE LINK Short Name: LPAR TY LN
Plural: LIT PARTICIPANT TYPE LINK
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Attributes:
Name Domain Opt Format Length
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
* MUST BE has participant one and only one LT PARTICIPANT
* MUST BE has type one and only one LIT PARTICIPANT TYPE CODE
* = Relationships in primary unique identifier.
Unique Identifiers:
PART_TYP_LNK_PK Primary? Y
MUST BE has type one and only one LIT PARTICIPANT TYPE CODE
MUST BE has participant one and only one LT PARTICIPANT
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 10 of 41
Application: LTrack
LIT_ERA_CASE_APPEAL Short Name: LT_CASE_AP
Plural: LIT_ERA_CASE_APPEAL
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Tracks the ERA Case appeals linked to a litigation. It records the appeal outcome, and corresponding completion date for each appeal tied to the litigation.
Attributes:
Name Domain Opt Format Length
APPEAL COMPLETED DATE   Y DATE  
The date the litigation for the appeal was completed.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE has outcome one and only one APPEAL OUTCOME CODE
* MUST BE has litigation one and only one LT LITIGATION
* MUST BE is case for one and only one CASE APPEAL
* = Relationships in primary unique identifier.
Unique Identifiers:
LIT_ERA_CASE_APPL_PK Primary? Y
MUST BE has litigation one and only one LT LITIGATION
MUST BE is case for one and only one CASE APPEAL
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 11 of 41
Application: LTrack
LT AG LAWYER Short Name: LT LAWYER
Plural: LT AG LAWYER
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
The Attorney General Lawyer for the case
Attributes:
Name Domain Opt Format Length
* AG LAWYER ID   N NUMBER 10
Unique number identifying AG Lawyer
FIRST NAME   N VARCHAR2 25
First Name of Lawyer
LAST NAME   N VARCHAR2 25
Last Name of Lawyer
CREATED BY   N VARCHAR2 30
Userid of person who created the record.
CREATED DATE   N DATE  
Date record created
UPDATED BY   N VARCHAR2 30
Userid of person who last updated the record.
UPDATED DATE   N DATE  
The last date the record was updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE is AG lawyer for one or more LT LITIGATION
MAY BE is assistant for one or more LT LITIGATION
MAY BE is assistant for one or more LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_LAWYER_PKEY Primary? Y
AG LAWYER ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 12 of 41
Application: LTrack
LT CHRONOLOGIC EVENT Short Name: LT CHRON
Plural: LT CHRONOLOGIC EVENT
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Chronological events for the litigation
Attributes:
Name Domain Opt Format Length
* CHRONOLOGY ID   N NUMBER 10
Unique number identifying chronologic event
DESCRIPTION   Y VARCHAR2 255
Description of chronologic event
CHRONOLOGIC DATE   N DATE  
The date that the chronologic event occured
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MUST BE has court level one and only one LT COURT LEVEL CODE
MUST BE is chronological event for one and only one LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_CHRONOLOGIC_EVENT_PKEY Primary? Y
CHRONOLOGY ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 13 of 41
Application: LTrack
LT CONTENT CRITERIA Short Name: LT CON CRI
Plural: LT CONTENT CRITERIA
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
The Content Criteria section of a Search Parameter form is a list of parameters to be searched. This section is presented to the user as a single memo field, but internally it is broken down into several records for efficient storage.
Attributes:
Name Domain Opt Format Length
* CONTENT CRITERIA ID   N NUMBER 10
Unique number identifying content criteria.
DESCRIPTION   N VARCHAR2 1000
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MUST BE is content criteria for one and only one LT SEARCH PARAMETER FORM
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_CONTENT_CRITERIA_PKEY Primary? Y
CONTENT CRITERIA ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 14 of 41
Application: LTrack
LT COURT LEVEL CODE Short Name: LT CRTLVL
Plural: LT COURT LEVEL CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Contains codes that indicate the court level. IE BC Provincial court, BC Court of Appeal, BC Supreme Court, Supreme Court of Canada
Attributes:
Name Domain Opt Format Length
* LT COURT LEVEL CODE   N VARCHAR2 15
Code identifying court level
DESCRIPTION   N VARCHAR2 120
Display description of court level
EFFECTIVE DATE   N DATE  
The date the code becomes effective
EXPIRY DATE   N DATE  
The date the code expires.
UPDATE TIMESTAMP   N DATE  
The date the code was last updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE is court level for one or more LT CHRONOLOGIC EVENT
MAY BE is court level for one or more LT CRITICAL EVENT
MAY BE is court level for one or more LT LITIGATION
MAY BE is court level one or more LIT COURT LEVEL REGISTRY
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_COURT_LEVEL_CD_PKEY Primary? Y
LT COURT LEVEL CODE
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 15 of 41
Application: LTrack
LT CRITICAL EVENT Short Name: LT CRTEVNT
Plural: LT CRITICAL EVENT
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Records the Critical Events for the case. A critical event can be broken into chunks for more efficient storage in the system.
Attributes:
Name Domain Opt Format Length
* CRITICAL EVENT ID   N NUMBER 10
Unique ID identifying critical event.
DESCRIPTION   Y VARCHAR2 1000
The description of the Critical event
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MUST BE has court level one and only one LT COURT LEVEL CODE
MUST BE is critical event for one and only one LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_CRITICAL_EVENT_PKEY Primary? Y
CRITICAL EVENT ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 16 of 41
Application: LTrack
LT CURRENT STATUS Short Name: LT CURSTAT
Plural: LT CURRENT STATUS
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Description of the current status of the litigation which is a legal description. Not to be confused with the litigation status which is the status of the litgation record.
Attributes:
Name Domain Opt Format Length
* CURRENT STATUS ID   N NUMBER 10
Unique number to identify current status record. A current status can be broken into chunks for more efficient storage in the system.
 
DESCRIPTION   N VARCHAR2 1000
The content of the current status, may be a chunk of a document spread over several records.
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MUST BE is current status for one and only one LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_CURRENT_STATUS_PKEY Primary? Y
CURRENT STATUS ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 17 of 41
Application: LTrack
LT DELIVERY ADDRESS Short Name: LT DELADDR
Plural: LT DELIVERY ADDRESS
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
The address that documents resulting from the search are to be delivered to.
Attributes:
Name Domain Opt Format Length
ADDRESSEE   N VARCHAR2 30
The person to send the documents to.
OFFICE NAME   Y VARCHAR2 75
The name of the office documents are sent to.
STREET   Y VARCHAR2 50
Street address
CITY   Y VARCHAR2 30
City
PROVINCE   Y VARCHAR2 4
Province
POSTAL CODE   Y VARCHAR2 6
Postal Code
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
* MUST BE document destination for one and only one LT SEARCH PARAMETER FORM
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_DELIVERY_ADDRESS_PKEY Primary? Y
MUST BE document destination for one and only one LT SEARCH PARAMETER FORM
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 18 of 41
Application: LTrack
LT DESCRIPTION OF CLAIM Short Name: LT CLAIM
Plural: LT DESCRIPTION OF CLAIM
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
The Description of Claim is the description of what a case is about. It's extracted from the Statement of Claim document and stored in the database for convenience. The description may vary in length, so this table is intended to break the description into chunks that can be stored efficiently
Attributes:
Name Domain Opt Format Length
* DESCRIPTION ID   N NUMBER 10
Unique key identifying a part of the Statement of Claim Descripiton.
DESCRIPTION   Y VARCHAR2 1000
The Statement of Claim Description.
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MUST BE is claim description for one and only one LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_DESC_CLAIM_PKEY Primary? Y
DESCRIPTION ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 19 of 41
Application: LTrack
LT DOCUMENT Short Name: LT DOC
Plural: LT DOCUMENT
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Stores Documents associated with the Litigation. Typically there will only be one file associated with the litigation, the "Statement of Claim" document.
Attributes:
Name Domain Opt Format Length
* DOCUMENT ID   N NUMBER 10
Unique number identifying the document
FILE NAME   N VARCHAR2 255
The filename of the document
DESCRIPTION   Y VARCHAR2 255
Display description of the document
DOCUMENT   N IMAGE  
The Blob field that will hold the document. Unfortunately, designer does not allow me to set the field type to a blob. It is therefore specified as an Image type, and changed to a blob after the ER diagram transformation.
CREATED BY   N VARCHAR2 30
CREATED DATE   N DATE  
UPDATED BY   N VARCHAR2 30
UPDATED DATE   N DATE  
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MUST BE has document one and only one LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_DOC Primary? Y
DOCUMENT ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 20 of 41
Application: LTrack
LT DOMAIN CODE Short Name: LT DOMN CD
Plural: LT DOMAIN CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Identifies all the available NT domains a Government Userid may have
Attributes:
Name Domain Opt Format Length
* LT DOMAIN CODE   N VARCHAR2 15
The domain code. Corresponds directly to the domain
DESCRIPTION   N VARCHAR2 120
Description of domain
EFFECTIVE DATE   N DATE  
The date the domain becomes effective
EXPIRY DATE   N DATE  
The date the domain expires
UPDATE TIMESTAMP   N DATE  
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE is domain for one or more LT LOCAL SEARCH DELEGATE
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_DOMAIN_CODE_PKEY Primary? Y
LT DOMAIN CODE
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 21 of 41
Application: LTrack
LT LITIGATION Short Name: LT LITIGTN
Plural: LT LITIGATION
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
The Litigation table contains the core set of information regarding the background of the case. This includes the contact information and chronology for the case. It will be primarily used by the litigation coordinators to monitor and report the current status of all current litigation involving the government.
Attributes:
Name Domain Opt Format Length
* LITIGATION ID   N NUMBER 10
Unique surrogate key used to identify an litigation case.
ACTION NUMBER   Y VARCHAR2 20
Unique alpha-numberic number assigned by the court registry to identify the case.
STYLE OF CAUSE   N VARCHAR2 255
The name of the case. Identifies the plaintiff and defendent. IE "John Doe v. Her Majesty the Queen"
FILE ID   Y VARCHAR2 30
Interal id used by staff to refer to the litigation
ABORIGINAL IND   N VARCHAR2 1
Indicates if the case is an aboriginal case or not
Allowable Values of Attribute
 
Y   Case is and aboriginal case.
N   Case is not an aboriginal case.  
SENSITIVE IND   N VARCHAR2 1
Assesment of sensitivity. Either it's sensitive or not.
Allowable Values of Attribute
N   Case is not sensitive  
Y   Case is sensitive  
DATE PROCEEDING FILED   Y DATE  
The date the proceeding was filed.
TRIAL DATE   Y DATE  
Trial Date of case.
KEY CONTACTS   Y VARCHAR2 1000
Identifies the key contacts for the litigation.
AD HOC COUNSEL   Y VARCHAR2 255
Some cases may require Lawyers outside of the ministry for special counsel. They are called Ad Hoc Counsel.
AD HOC IND   Y VARCHAR2 1
Indicates if Ad Hoc Counsel involved in case.
Allowable Values of Attribute
Y   Ad Hoc Counsel involved in case.  
N   Ad Hoc Counsel not involved in case.  
OPPOSING COUNSEL   Y VARCHAR2 255
FINANCIAL RESPONSIBILITY   Y VARCHAR2 255
Describes who will bear the financial responsibility for the Document search process.
ALERT DATE   Y DATE  
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 22 of 41
Application: LTrack
LT LITIGATION (cont'd) Short Name: LT LITIGTN
The date that the Search Coordinator should be notified by to review the progress of the search (could be applied to other interested parties as well, like the litigation coordinator).
LITIGATION COMPLETED DATE   Y DATE  
The date on which the Litigation was completed.
RELATED FOI REQUEST   Y VARCHAR2 20
Stores the related FOI request document number.
IE FOR-04-12345
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE has chronological event one or more LT CHRONOLOGIC EVENT
MAY BE has claim description one or more LT DESCRIPTION OF CLAIM
MAY BE has critical event one or more LT CRITICAL EVENT
MAY BE has current status one or more LT CURRENT STATUS
MAY BE has district one and only one ORG UNIT
MAY BE has instruction provider one and only one LT PARTICIPANT
MAY BE has litigation coordinator one and only one LT PARTICIPANT
MAY BE has note one or more LT LITIGATION_NOTE
MAY BE has parameter form one or more LT SEARCH PARAMETER FORM
MAY BE has primary assistant one and only one LT AG LAWYER
MAY BE has related case one or more LT RELATED CASE
MAY BE has related files one or more LIT FILE DOCUMENT TRACKING
MAY BE has scan tech one and only one LT PARTICIPANT
MAY BE has search coordinator one and only one LT PARTICIPANT
MAY BE has secondary assistant one and only one LT AG LAWYER
MAY BE is discovery note for one or more DISCOVERY NOTE
MAY BE is document for one or more LT DOCUMENT
MAY BE is litigation for one or more LIT_ERA_CASE_APPEAL
MUST BE has AG Lawyer one and only one LT AG LAWYER
MUST BE has court level one and only one LT COURT LEVEL CODE
MUST BE has court location one and only one LIT COURT LEVEL REGISTRY
MUST BE has litigation status one and only one LT LITIGATION STATUS CODE
MUST BE has proceeding type one and only one LT PROCEEDING TYPE CODE
MUST BE has region/hq one and only one ORG UNIT
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_FILE_ID_UNQ Primary? N
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 23 of 41
Application: LTrack
LT LITIGATION (cont'd) Short Name: LT LITIGTN
FILE ID
LT_LITIGATION_PKEY Primary? Y
LITIGATION ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 24 of 41
Application: LTrack
LT LITIGATION NOTE Short Name: LT LITNOTE
Plural: LT LITIGATION_NOTE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Records Litigation Coordinator/Administrator notes about the Litigation that are relevant to the coordination of the Litigation discovery process.
Attributes:
Name Domain Opt Format Length
* NOTE ID   N NUMBER 10
Unique ID identifying a note
NOTE   Y VARCHAR2 1000
The content of the notes
CREATED BY   N VARCHAR2 30
Note author
CREATED DATE   N DATE  
Creation date of note
UPDATED BY   N VARCHAR2 30
Person who updated the note.
UPDATED DATE   N DATE  
The update date of the note
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MUST BE is note for one and only one LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_LITIGATION_NOTE_PKEY Primary? Y
NOTE ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 25 of 41
Application: LTrack
LT LITIGATION STATUS CODE Short Name: LT LITSTCD
Plural: LT LITIGATION STATUS CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Contains the codes to indicate the status of a piece of litigation. Not to be confused with the Current Status which is a legal description of Current Status events
Attributes:
Name Domain Opt Format Length
* LT LITIGATION STATUS CODE   N VARCHAR2 15
Code identifying litigation status
DESCRIPTION   N VARCHAR2 120
Display description of litigation status
EFFECTIVE DATE   N DATE  
The date the code becomes effective
EXPIRY DATE   N DATE  
The date the code expires.
UPDATE TIMESTAMP   N DATE  
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE is litigation status for one or more LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_LITIGATION_STATUS_CD_PKEY Primary? Y
LT LITIGATION STATUS CODE
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 26 of 41
Application: LTrack
LT LOCAL SEARCH COORDINATOR Short Name: LT LOCCOOR
Plural: LT LOCAL SEARCH COORDINATOR
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
The local Search Coordinator performing a search action. A Search Coordinator wishing to complete a Search Action form, will also be designated a local search coordinator, so that the same Search Action Form can be completed.
Attributes:
Name Domain Opt Format Length
* LOCAL COORDINATOR ID   N NUMBER 10
Unique ID identifying the search coordinator.
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE compiles search results for one or more LT SEARCH ACTION FORM
MAY BE is delagated by one or more LT LOCAL SEARCH DELEGATE
MUST BE performs search of office one and only one LT SEARCH OFFICE LINK
MUST BE searched locally by one and only one LT PARTICIPANT
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_PARTICIPANT_FORM_UNQ Primary? N
MUST BE performs search of office one and only one LT SEARCH OFFICE LINK
MUST BE searched locally by one and only one LT PARTICIPANT
LT_LOCAL_COORDINATOR_PKEY Primary? Y
LOCAL COORDINATOR ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 27 of 41
Application: LTrack
LT LOCAL SEARCH DELEGATE Short Name: LT SRCHDEL
Plural: LT LOCAL SEARCH DELEGATE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
The list of users, managed by the local search coordinator, who are authorized by the local search coordinator to perform data input into the search action form. IE a director of a forest district may be the local search coordinator, and that person delegates their local staff to perform the search and input the results on the director's behalf.
Attributes:
Name Domain Opt Format Length
* USERNAME   N VARCHAR2 32
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
* MUST BE delegates one and only one LT LOCAL SEARCH COORDINATOR
* MUST BE has domain one and only one LT DOMAIN CODE
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_SEARCH_DELEGATE_PKEY Primary? Y
MUST BE delegates one and only one LT LOCAL SEARCH COORDINATOR
MUST BE has domain one and only one LT DOMAIN CODE
USERNAME
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 28 of 41
Application: LTrack
LT PARTICIPANT Short Name: LT PART
Plural: LT PARTICIPANT
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Identifies the various Ministry Staff members involved in the litigation. Some of the different participant types are Litigation Coordinator, Search Coordinator, Local Search Coordinator, Instruction Provider, and Key Official.
Attributes:
Name Domain Opt Format Length
* PARTICIPANT ID   N NUMBER 10
Unique ID, identifying participant
LAST NAME   N VARCHAR2 25
Last Name of participant
FIRST NAME   N VARCHAR2 25
First Name of Participant
PARTICIPANT TITLE   Y VARCHAR2 100
The title of the participant. IE They may be a Local Search Coordinator, whose title is Director of a Forest District Branch
OFFICE   Y VARCHAR2 50
The office where the participant works.
PHONE NO   Y VARCHAR2 15
Participant's phone number
FAX NO   Y VARCHAR2 15
Participant's Fax Number
EMAIL   Y VARCHAR2 50
Participant's Email address
USERID   N VARCHAR2 50
The userid of the participant. Must be qualified with a domain name. IE: BCGOV\JDOE or FSMASTER\EMURPHY
EFFECTIVE DATE   N DATE  
The date the code becomes effective
EXPIRY DATE   N DATE  
The date the code expires.
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE is instruction provider for one or more LT LITIGATION
MAY BE is ligitigation coordinator for one or more LT LITIGATION
MAY BE is participant for one or more LIT PARTICIPANT TYPE LINK
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 29 of 41
Application: LTrack
LT PARTICIPANT (cont'd) Short Name: LT PART
MAY BE is scan tech for one or more LT LITIGATION
MAY BE is search coordinator for one or more LT LITIGATION
MAY BE performs local search one or more LT LOCAL SEARCH COORDINATOR
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_PART_USERID_UNQ Primary? N
USERID
LT_PARTICIPANT_PKEY Primary? Y
PARTICIPANT ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 30 of 41
Application: LTrack
LT PROCEEDING TYPE CODE Short Name: LT PRCTYP
Plural: LT PROCEEDING TYPE CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Identifies the proceeding types for the litigation
Attributes:
Name Domain Opt Format Length
* LT PROCEEDING TYPE CODE   N VARCHAR2 15
Unique code defining a litigation type
DESCRIPTION   N VARCHAR2 120
Display description of the litigation type
EFFECTIVE DATE   N DATE  
The date the code becomes effective
EXPIRY DATE   N DATE  
The date the code expires
UPDATE TIMESTAMP   N DATE  
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE is proceeding type for one or more LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_PROCEEDING_TYPE_PKEY Primary? Y
LT PROCEEDING TYPE CODE
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 31 of 41
Application: LTrack
LT REGISTRY Short Name: LT REGSTRY
Plural: LT REGISTRY
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Specifies the court registry (court locations) where the litigation is being heard
Attributes:
Name Domain Opt Format Length
* REGISTRY ID   N NUMBER 10
Unique number identifying court location
REGISTRY   N VARCHAR2 50
The name of the court registry.
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE is registry one or more LIT COURT LEVEL REGISTRY
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_REGISTRY_PKEY Primary? Y
REGISTRY ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 32 of 41
Application: LTrack
LT RELATED CASE Short Name: LRC
Plural: LT RELATED CASE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Tracks related litigations. This allows a user to view information from cases that may be related in some form.
Attributes:
Name Domain Opt Format Length
* RELATED LITIGATION ID   N NUMBER 10
The Litigation ID of a related case.
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
* MUST BE is a related case one and only one LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_RELATED_CASE_PKEY Primary? Y
MUST BE is a related case one and only one LT LITIGATION
RELATED LITIGATION ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 33 of 41
Application: LTrack
LT SEARCH ACTION Short Name: LT ACTION
Plural: LT SEARCH ACTION
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Records Search Actions for a Local Search Coordinator's Search Action Form. A search action is a description of a search process carried out by the local search coordinator. It records the action performed by the coordinato or the result of the search.
Attributes:
Name Domain Opt Format Length
* ACTION ID   N NUMBER 10
Unique number identifying action
SEARCH ACTION   Y VARCHAR2 1000
Description of Search Action. IE talked to district manager. Searched main file room.
SEARCH ACTION DATE   N DATE  
The date the search action was performed
DOCUMENT FOUND IND   N CHAR 1
Indicates that documents were found.
Allowable Values of Attribute
N   No  
Y   Yes  
LOCATION FOUND   Y VARCHAR2 500
The Location documents were found. IE File Cabinet B, 2nd drawer room 202
PRIMARY NO   Y NUMBER 5
ARCS/ORCS Number used to classify all files related to a subject or function regardless of physical format.
SECONDARY NO   Y NUMBER 2
ARCS/ORCS Number used for further classification
TERTIARY TXT   Y VARCHAR2 40
Short descriptive name and/or number reference of file. May or may not be associated with an ARC/ORCS Primary and Secondary Classification
TITLE TXT   Y VARCHAR2 120
Long Description of file, as required, to further describe purpose or contents beyond short description
FILE NUMBER   Y VARCHAR2 30
File Number of file/document found. Could be ARCS/ORCS number
FILE NAME   Y VARCHAR2 50
Name of file found.
RELATED DOCUMENTS IND   N CHAR 1
Indicates if searcher believes the file contains related documents.
Allowable Values of Attribute
N   No  
Y   Yes  
NUMBER OF VOLUMES   Y NUMBER 10
Number of volumes that make up the file
NOTES   Y VARCHAR2 1000
Notes regarding the search action or files found
CREATED BY   N VARCHAR2 30
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 34 of 41
Application: LTrack
LT SEARCH ACTION (cont'd) Short Name: LT ACTION
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MUST BE Is search action for one and only one LT SEARCH ACTION FORM
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_SEARCH_ACTION_PKEY Primary? Y
ACTION ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 35 of 41
Application: LTrack
LT SEARCH ACTION FORM Short Name: LT SRCHACT
Plural: LT SEARCH ACTION FORM
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
The Search Action Form, documents the search process carried out by the local search coordinator. It records the actions performed by the coordinator, and the results of the search.
Attributes:
Name Domain Opt Format Length
* ACTION FORM ID   N NUMBER 10
Unique number identifying Search Action Form
 
SIGN OFF IND   N VARCHAR2 1
Indicates if the Local Search Coordinator has signed off on local search being complete or not.
Allowable Values of Attribute
N   Local Search Coordinator has not signed off on local search being complete
  
Y   Local Search Coordinator has signed off on local search being complete
  
SIGN OFF DATE   Y DATE  
Date that the Local Search Coordinator signed off on search results.
DELIVERED IND   N CHAR 1
Indicates if documents were delivered or not.
Allowable Values of Attribute
N   No  
Y   Yes  
DELIVER METHOD   Y VARCHAR2 25
The method used to deliver files. IE Courier, Canda Post, Greyhound
DELIVER DATE   Y DATE  
Date files were delivered
DELIVERER NAME   Y VARCHAR2 30
Person who orchestrated the delivery
RECEIVED DATE   Y DATE  
Date the Files were recieved
RECEIVER NAME   Y VARCHAR2 30
Person who recieved the files.
NOTES   Y VARCHAR2 4000
Common Notes field for general discussion of search action form
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the file was input
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 36 of 41
Application: LTrack
LT SEARCH ACTION FORM (cont'd) Short Name: LT SRCHACT
Relationships:
Each Occurrence Of This Entity:
MAY BE has search action one or more LT SEARCH ACTION
MUST BE form compiled by one and only one LT LOCAL SEARCH COORDINATOR
MUST BE has status one and only one LT SEARCH STATUS CODE
MUST BE is search action form for one and only one LT SEARCH PARAMETER FORM
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_SEARCH_ACTION_PKEY Primary? Y
ACTION FORM ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 37 of 41
Application: LTrack
LT SEARCH OFFICE LINK Short Name: LT SRCH OF
Plural: LT SEARCH OFFICE LINK
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Creates list of offices that are to be searched for documents
 
Attributes:
Name Domain Opt Format Length
CREATED BY   N VARCHAR2 30
CREATED DATE   N DATE  
UPDATED BY   N VARCHAR2 30
UPDATED DATE   N DATE  
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE office searched by one and only one LT LOCAL SEARCH COORDINATOR
* MUST BE has search parameters one and only one LT SEARCH PARAMETER FORM
* MUST BE searching office one and only one ORG UNIT
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_PARAM_FORM_OFFICE_PKEY Primary? Y
MUST BE has search parameters one and only one LT SEARCH PARAMETER FORM
MUST BE searching office one and only one ORG UNIT
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 38 of 41
Application: LTrack
LT SEARCH PARAMETER FORM Short Name: LT SRCHPAR
Plural: LT SEARCH PARAMETER FORM
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
The Search Parameters for the Document Discovery are determined at the Search Planning Meeting, scheduled by the Search Coordinator. The Search Parameters provide the scope for the document search. The Search Coordinator and local search coordinators will base their search on these parameters.
Attributes:
Name Domain Opt Format Length
* PARAMETER FORM ID   N NUMBER 10
Unique id to identify search parameter form
DISPLAY ID   N NUMBER 10
The Display ID for this Search Parameter Form. A litigation may have more than one parameter form, so we need to distinquish them with the display id, and the creation date. Can't use primary key because it's a surrogate key and the numbering would confuse a user. IE form 1 would have a surrogate key 103, and form 2 would have a surrogate key 154. The display ID would always be in sequence IE: 1, 2.
RECEIVE DUE DATE   Y DATE  
The Date the results of the Search are due by
GEOGRAPHIC SCOPE   Y VARCHAR2 1000
Description of the geographic scope of the search.
TIME PERIOD BEGIN   Y DATE  
The search action should find documents that were created on or after the time period begin date.
TIME PERIOD END   Y DATE  
The search action should find documents that were created on or before the time period end date.
DOCUMENT FORMATS   Y VARCHAR2 1000
Describes the document types that are to be retrieved. Can include notes of document types to be excluded. Some example document formats are paper, tape, video, databases, electronic formats.
NOTES   Y VARCHAR2 4000
Common Notes field for general discussion of search parameter form.
SIGN OFF IND   N VARCHAR2 1
Indicates if the Search Coordinator has Signed Off on search being complete or not
Allowable Values of Attribute
N   Search Coordinator has not Signed Off on search being complete
  
Y   Search Coordinator has Signed Off on search being complete
  
SIGN OFF DATE   Y DATE  
The date the search was signed off as complete.
CREATED BY   N VARCHAR2 30
Userid of person inputing this entry
CREATED DATE   N DATE  
Date the parameter form was created.
UPDATED BY   N VARCHAR2 30
Userid of person updating entry
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 39 of 41
Application: LTrack
LT SEARCH PARAMETER FORM (cont'd) Short Name: LT SRCHPAR
UPDATED DATE   N DATE  
Date entry updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE documents delivered to one and only one LT DELIVERY ADDRESS
MAY BE has content criteria one or more LT CONTENT CRITERIA
MAY BE has search action forms one or more LT SEARCH ACTION FORM
MAY BE search parameters for one or more LT SEARCH OFFICE LINK
MUST BE provides search parameters for one and only one LT LITIGATION
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_DISPLAY_ID_UNQ Primary? N
DISPLAY ID
MUST BE provides search parameters for one and only one LT LITIGATION
LT_SEARCH_PARAM_PKEY Primary? Y
PARAMETER FORM ID
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 40 of 41
Application: LTrack
LT SEARCH STATUS CODE Short Name: LT SRCH ST
Plural: LT SEARCH STATUS CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Contains the codes that identify the current status of a search action form.
Attributes:
Name Domain Opt Format Length
* LT SEARCH STATUS CODE   N VARCHAR2 15
Unique code identifying the status
DESCRIPTION   N VARCHAR2 120
The display description for the code
EFFECTIVE DATE   N DATE  
The date the code becomes effective
EXPIRY DATE   N DATE  
The date the code expires
UPDATE TIMESTAMP   N DATE  
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE is status for one or more LT SEARCH ACTION FORM
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_SEARCH_STATUS_CD_PKEY Primary? Y
LT SEARCH STATUS CODE
Data Administration
daqr0010
February 01, 2007 Entity Definition Report Page 41 of 41
Application: LTrack
ORG UNIT Short Name: ORG UNIT
Plural: ORG UNIT
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Represents the Mof Org Unit Table. Not all fields included in the model, though they will exist in the MOF database environments.
Attributes:
Name Domain Opt Format Length
* ORG UNIT NO   N NUMBER 10
The code identifying a MOF office.
ORG UNIT NAME   N VARCHAR2 100
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE is district for one or more LT LITIGATION
MAY BE is ministry office for one or more LIT FILE DOCUMENT TRACKING
MAY BE is region/hq for one or more LT LITIGATION
MAY BE office searched by one or more LT SEARCH OFFICE LINK
* = Relationships in primary unique identifier.
Unique Identifiers:
LT_OFFICE_PKEY Primary? Y
ORG UNIT NO