Oracle Designer

Report : TABLE DEFINITION

Filename :

C:\DOCUME~1\klmcnult\LOCALS~1\Temp\ckr5B.tmp.html

Run by :

CASEOWNER

Report Date :

31 January 2007

Total Pages :

78

Parameter Values

Workarea :

GLOBAL SHARED WORKAREA

Container :

LTrack

Container Version :

Recurse Sub-Containers :

N

Tab/View/Snap Name :

%

Diagram :

Includes

Tables :

Yes

Views :

Yes

Snapshots :

Yes

Column Details :

Yes

Tables Created

On/After :

On/Before :

31 January 2007

and

Tables Changed

On/After :

On/Before :

31 January 2007

---

31 January 2007

Page

2

of

78

Table Definition

Container :

LTrack

Version :

Table Name : APPEAL_OUTCOME_CODE

Alias :

APOC

Display Title : Appeal Outcome Code

Description :

Describes the outcome from any appeal.

User/Help Text :

Describes the outcome from any appeal.

Volumes

Start Rows :

End Rows :

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

APPEAL_OUTCOME_CODE

NOT NULL

VARCHAR2 (10)

2

DESCRIPTION

NOT NULL

VARCHAR2 (120)

3

EFFECTIVE_DATE

NOT NULL

DATE

4

EXPIRY_DATE

NOT NULL

DATE

5

UPDATE_TIMESTAMP

NOT NULL

DATE

Primary Key

Name

Column

APOC_PK

APPEAL_OUTCOME_CODE

Column Detail

1

APPEAL_OUTCOME_CODE

Code for an appeal outcome.

Optional ? :No ; Varchar2 (10) ;() ; ; Domain :STANDARD_CODE ; Uppercase ? :No ;

Code for an appeal outcome.

2

DESCRIPTION

Description of the appeal outcome code.

Optional ? :No ; Varchar2 (120) ;() ; ; Domain :STANDARD_CODE_DESCRIPTION ; Uppercase ? :No ;

Description of the appeal outcome code.

3

EFFECTIVE_DATE

Effective date/time

Optional ? :No ; Date ;() ; ; Domain :DATE_TIME ; Uppercase ? :No ;

Effective date/time

4

EXPIRY_DATE

Oracle Designer Report : cktci

---

31 January 2007

Page

3

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

Expiry date/time

Optional ? :No ; Date ;() ; ; Domain :DATE_TIME ; Uppercase ? :No ;

Expiry date/time

5

UPDATE_TIMESTAMP

Update date/time

Optional ? :No ; Date ;() ; ; Domain :AUDIT_DATE ; Uppercase ? :No ;

Update date/time

Oracle Designer Report : cktci

---

31 January 2007

Page

4

of

78

Table Definition

Container :

LTrack

Version :

Table Name : CASE_APPEAL

Alias :

CASE_APP L

Display Title : Case Appeal

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.

User/Help Text :

ERA System administrative information related to a chronological representation of events of: alleged non-compliance; investigations; enforcement actions; reviews; appeals and final incident disposition.

Volumes

Start Rows :

End Rows :

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

CASE_APPEAL_ID

NOT NULL

NUMBER (10)

2

APPEAL_NO

NOT NULL

NUMBER (10)

Primary Key

Name

Column

CASE_APPL_PK

CASE_APPEAL_ID

Other Unique Keys

Name

Column

CASE_APPL_CASE_UK_UK

APPEAL_NO

Column Detail

1

CASE_APPEAL_ID

Formal number for the ERA case.

Optional ? :No ; Number (10) ;() ; ; Domain :NUMERIC_ID ; Uppercase ? :No ;

Formal unique number for an ERA Case Appeal record

2

APPEAL_NO

Formal unique identifier for the ERA case.

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Formal unique identifier for an ERA Case Appeal record

Oracle Designer Report : cktci

---

31 January 2007

Page

5

of

78

Table Definition

Container :

LTrack

Version :

Table Name : DISCOVERY_NOTE

Alias :

DISC_NOT E

Display Title : Discovery Note

Description :

Discovery notes are notes that are created by participants in the litigation regarding aspects of the discovery process.

User/Help Text :

Discovery notes are notes that are created by participants in the litigation regarding aspects of the discovery process.

Volumes

Start Rows :

End Rows :

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

DISCOVERY_NOTE_ID

NOT NULL

NUMBER (10)

20

LITIGATION_ID

NOT NULL

NUMBER (10)

30

NOTE

NOT NULL

VARCHAR2 (1000)

40

CREATED_BY

NOT NULL

VARCHAR2 (30)

50

CREATED_DATE

NOT NULL

DATE

60

UPDATED_BY

NOT NULL

VARCHAR2 (30)

70

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

DISC_NOTE_PK

DISCOVERY_NOTE_ID

Foreign Keys

DISC_NOTE_LT_LITIGTN_FK

LITIGATION_ID references LT_LITIGATION.LITIGATION_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

DISC_NOTE_LT_LITIGTN_FK_I

20

LITIGATION_ID

NOT UNIQUE

Column Detail

Oracle Designer Report : cktci

---

31 January 2007

Page

6

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

10

DISCOVERY_NOTE_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

20

LITIGATION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique surrogate key used to identify an litigation case.

30

NOTE

Optional ? :No ; Varchar2 (1000) ;() ; ; Uppercase ? :No ;

40

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

50

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

60

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

70

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

Oracle Designer Report : cktci

---

31 January 2007

Page

7

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LIT_COURT_LEVEL_REGISTRY

Alias :

LCLR

Display Title : Lit Court Level Registry

Description :

Associates a court level with a registry.

User/Help Text :

Associates a court level with a registry.

Volumes

Start Rows :

End Rows :

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

COURT_LEVEL_REGISTRY_ID

NOT NULL

NUMBER (10)

3

LT_COURT_LEVEL_CODE

NOT NULL

VARCHAR2 (15)

5

REGISTRY_ID

NOT NULL

NUMBER (10)

Primary Key

Name

Column

LCLR_PK

COURT_LEVEL_REGISTRY_ID

Other Unique Keys

Name

Column

LCLR_LRLRR_UKEY_UK

LT_COURT_LEVEL_CODE

REGISTRY_ID

Foreign Keys

LCLR_LT_CRTLVL_FK

LT_COURT_LEVEL_CODE references LT_COURT_LEVEL_CODE.LT_COURT_LEVEL_CODE

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LCLR_LT_REGSTRY_FK

REGISTRY_ID references LT_REGISTRY.REGISTRY_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Column Detail

Oracle Designer Report : cktci

---

31 January 2007

Page

8

of

78

Table Definition

Container :

LTrack

Version :

Index Summary

Name

Seq.

Column

Index Type

LCLR_LT_CRTLVL_FK_I

20

LT_COURT_LEVEL_CODE

NOT UNIQUE

LCLR_LT_REGSTRY_FK_I

20

REGISTRY_ID

NOT UNIQUE

Column Detail

1

COURT_LEVEL_REGISTRY_ID

Optional ? :No ; Number (10) ;() ; ; Domain :NUMERIC_ID ; Uppercase ? :No ;

Unique number identifying a court level registry.

3

LT_COURT_LEVEL_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Code identifying court level

5

REGISTRY_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique number identifying court location

Oracle Designer Report : cktci

---

31 January 2007

Page

9

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LIT_ERA_CASE_APPEAL

Alias :

LT_CASE_ AP

Display Title : Lit Era Case Appeal

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.

User/Help Text :

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.

Volumes

Start Rows :

End Rows :

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

LITIGATION_ID

NOT NULL

NUMBER (10)

13

CASE_APPEAL_ID

NOT NULL

NUMBER (10)

16

APPEAL_OUTCOME_CODE

NULL

VARCHAR2 (10)

20

APPEAL_COMPLETED_DATE

NULL

DATE

Primary Key

Name

Column

LT_CASE_AP_PK

LITIGATION_ID

CASE_APPEAL_ID

Column Detail

10

LITIGATION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique surrogate key used to identify an litigation case.

13

CASE_APPEAL_ID

Formal number for the ERA case.

Optional ? :No ; Number (10) ;() ; ; Domain :NUMERIC_ID ; Uppercase ? :No ;

Formal unique number for an ERA Case Appeal record

16

APPEAL_OUTCOME_CODE

Code for an appeal outcome.

Optional ? :Yes ; Varchar2 (10) ;() ; ; Domain :STANDARD_CODE ; Uppercase ? :No ;

Code for an appeal outcome.

Oracle Designer Report : cktci

---

31 January 2007

Page

10

of

78

Table Definition

Container :

LTrack

Version :

Foreign Keys

LT_CASE_AP_APOC_FK

APPEAL_OUTCOME_CODE references APPEAL_OUTCOME_CODE.APPEAL_OUTCOME_CODE

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_CASE_AP_CASE_APPL_FK

CASE_APPEAL_ID references CASE_APPEAL.CASE_APPEAL_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_CASE_AP_LT_LITIGTN_FK

LITIGATION_ID references LT_LITIGATION.LITIGATION_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LT_CASE_AP_APOC_FK_I

50

APPEAL_OUTCOME_CODE

NOT UNIQUE

LT_CASE_AP_CASE_APPL_FK_I

50

CASE_APPEAL_ID

NOT UNIQUE

LT_CASE_AP_LT_LITIGTN_FK_I

20

LITIGATION_ID

NOT UNIQUE

Column Detail

20

APPEAL_COMPLETED_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

The date the litigation for the appeal was completed.

Oracle Designer Report : cktci

---

31 January 2007

Page

11

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LIT_FILE_DOCUMENT_TRACKING

Alias :

LFLRDOC

Display Title : Lit File Document Tracking

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.

User/Help Text :

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.

Volumes

Start Rows :

End Rows :

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

LIT_FILE_TRACKING_ID

NOT NULL

NUMBER (10)

2

LIT_FILE_TRACKING_PRIMARY

NULL

NUMBER (5)

3

LIT_FILE_TRACKING_SECONDARY

NULL

NUMBER (2)

4

LIT_FILE_TRACKING_TERTIARY

NOT NULL

VARCHAR2 (15)

5

PACKAGE_IDENTITY_TEXT1

NULL

VARCHAR2 (15)

6

PACKAGE_IDENTITY_TEXT2

NULL

VARCHAR2 (15)

7

LIT_FILE_TRACKING_VOLUME

NOT NULL

NUMBER (3)

8

LFLRDOC_INDEX

NULL

VARCHAR2 (15)

9

LIT_FILE_TRACKING_OPEN_DATE

NULL

DATE

10

LIT_FILE_TRACKING_CLOSED_DATE

NULL

DATE

11

SUBJECT

NOT NULL

VARCHAR2 (240)

12

LITIGATION_TECHNICIAN_USER_ID

NULL

VARCHAR2 (30)

13

RECEIVED_DATE

NULL

DATE

14

SCAN_COMPLETED_DATE

NULL

DATE

15

RETURNED_DATE

NULL

DATE

16

LITIGATION_ACCESSION

NULL

NUMBER (9)

17

CREATED_BY

NOT NULL

VARCHAR2 (30)

18

CREATED_DATE

NOT NULL

DATE

19

UPDATED_BY

NOT NULL

VARCHAR2 (30)

20

UPDATED_DATE

NOT NULL

VARCHAR2 (240)

22

LITIGATION_ID

NOT NULL

NUMBER (10)

24

ORG_UNIT_NO

NULL

NUMBER (10)

26

LIT_FILE_FORMAT_TYPE_CODE

NULL

VARCHAR2 (6)

Oracle Designer Report : cktci

---

31 January 2007

Page

12

of

78

Table Definition

Container :

LTrack

Version :

Primary Key

Name

Column

LFLRDOC_PK

LIT_FILE_TRACKING_ID

Foreign Keys

LFLRDOC_LFFTC_FK

LIT_FILE_FORMAT_TYPE_CODE references LIT_FILE_FORMAT_TYPE_CODE.LIT_FILE_FORMAT_TYPE_CODE

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

No

Delete Rule :

Restricted

LFLRDOC_LT_LITIGTN_FK

LITIGATION_ID references LT_LITIGATION.LITIGATION_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LFLRDOC_ORG_UNIT_FK

ORG_UNIT_NO references ORG_UNIT.ORG_UNIT_NO

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

No

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LFLRDOC_LFFTC_FK_I

20

LIT_FILE_FORMAT_TYPE_CODE

NOT UNIQUE

LFLRDOC_LT_LITIGTN_FK_I

20

LITIGATION_ID

NOT UNIQUE

LFLRDOC_ORG_UNIT_FK_I

20

ORG_UNIT_NO

NOT UNIQUE

Column Detail

1

LIT_FILE_TRACKING_ID

Optional ? :No ; Number (10) ;() ; ; Domain :NUMERIC_ID ; Uppercase ? :No ;

Unique number identifying a FILER document track.

2

LIT_FILE_TRACKING_PRIMARY

Optional ? :Yes ; Number (5) ;() ; ; Uppercase ? :No ;

Primary file number which is obtained from ARCS or ORCS.

3

LIT_FILE_TRACKING_SECONDARY

Optional ? :Yes ; Number (2) ;() ; ; Uppercase ? :No ;

Secondary within a primary - also from ARCS or ORCS.

4

LIT_FILE_TRACKING_TERTIARY

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Oracle Designer Report : cktci

---

31 January 2007

Page

13

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

Final file classification breakdown to clarify individual items within the primary secondary classification.

5

PACKAGE_IDENTITY_TEXT1

Optional ? :Yes ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Text used to identify packages that may have a further breakdown of file number or that do not have a file number.

6

PACKAGE_IDENTITY_TEXT2

Optional ? :Yes ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Text used to further identify a package of documents that may or may not have a file number.

7

LIT_FILE_TRACKING_VOLUME

Optional ? :No ; Number (3) ;() ; ; Uppercase ? :No ;

Indicates the number of the folder within one classification or file number.

8

LFLRDOC_INDEX

Optional ? :Yes ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

The accession and box number the information was removed from.

9

LIT_FILE_TRACKING_OPEN_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

The open date of the file or package of documents.

10

LIT_FILE_TRACKING_CLOSED_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

The close date or last date of the file or package of documents.

11

SUBJECT

Optional ? :No ; Varchar2 (240) ;() ; ; Uppercase ? :No ;

Subject matter of the information.

12

LITIGATION_TECHNICIAN_USER_ID

Optional ? :Yes ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

MOF userid of the litigation technician who scanned the file or package.

13

RECEIVED_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

Date the information was received by the Litigation Services Unit.

14

SCAN_COMPLETED_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

Date the scan was completed by the Litigation Services Unit.

15

RETURNED_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

Date the file or package was returned to the originating office.

16

LITIGATION_ACCESSION

Oracle Designer Report : cktci

---

31 January 2007

Page

14

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

Optional ? :Yes ; Number (9) ;() ; ; Uppercase ? :No ;

The unique Accession number assigned for all files provided for one litigation, and the box number the file or package is in.

17

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry.

18

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

Date the parameter form was created.

19

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry.

20

UPDATED_DATE

Optional ? :No ; Varchar2 (240) ;() ; ; Uppercase ? :No ;

Date entry updated.

22

LITIGATION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique surrogate key used to identify an litigation case.

24

ORG_UNIT_NO

Optional ? :Yes ; Number (10) ;() ; ; Uppercase ? :No ;

The code identifying a MOF office.

26

LIT_FILE_FORMAT_TYPE_CODE

Optional ? :Yes ; Varchar2 (6) ;() ; ; Uppercase ? :No ;

Unique code identifying a type of media format.

Oracle Designer Report : cktci

---

31 January 2007

Page

15

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LIT_FILE_FORMAT_TYPE_CODE

Alias :

LFFTC

Display Title : Lit File Format Type Code

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

User/Help Text :

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

Volumes

Start Rows :

End Rows :

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

LIT_FILE_FORMAT_TYPE_CODE

NOT NULL

VARCHAR2 (6)

2

DESCRIPTION

NOT NULL

VARCHAR2 (120)

3

EFFECTIVE_DATE

NOT NULL

DATE

4

EXPIRY_DATE

NOT NULL

DATE

5

UPDATE_TIMESTAMP

NOT NULL

DATE

Primary Key

Oracle Designer Report : cktci

---

31 January 2007

Page

16

of

78

Table Definition

Container :

LTrack

Version :

Name

Column

LFFTC_PK

LIT_FILE_FORMAT_TYPE_CODE

Column Detail

1

LIT_FILE_FORMAT_TYPE_CODE

Optional ? :No ; Varchar2 (6) ;() ; ; Uppercase ? :No ;

Unique code identifying a type of media format.

2

DESCRIPTION

Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;

Display description for the code.

3

EFFECTIVE_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the code becomes effective.

4

EXPIRY_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the code expires.

5

UPDATE_TIMESTAMP

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Indicates the most recent updated date.

Oracle Designer Report : cktci

---

31 January 2007

Page

17

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LIT_PARTICIPANT_TYPE_CODE

Alias :

LPAR_TP_ CD

Display Title : Lit Participant Type Code

Description :

Code that identifies the types of participants that are involved in litigation. IE Litigation Coordinator Search Provider Search Coordinator Local Search Coordinator

User/Help Text :

Code that identifies the types of participants that are involved in litigation. IE Litigation Coordinator Search Provider Search Coordinator Local Search Coordinator

Volumes

Start Rows :

End Rows :

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

LIT_PARTICIPANT_TYPE_CODE

NOT NULL

VARCHAR2 (3)

2

DESCRIPTION

NOT NULL

VARCHAR2 (120)

3

EFFECTIVE_DATE

NOT NULL

DATE

4

EXPIRY_DATE

NOT NULL

DATE

5

UPDATE_TIMESTAMP

NOT NULL

DATE

Primary Key

Name

Column

LPAR_TP_CD_PK

LIT_PARTICIPANT_TYPE_CODE

Column Detail

1

LIT_PARTICIPANT_TYPE_CODE

Optional ? :No ; Varchar2 (3) ;() ; ; Uppercase ? :No ;

Unique code identifying a participant type

2

DESCRIPTION

Oracle Designer Report : cktci

---

31 January 2007

Page

18

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;

Description of the participant type

3

EFFECTIVE_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

Date the code becomes effective.

4

EXPIRY_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

Date the code expires

5

UPDATE_TIMESTAMP

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the code was last updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

19

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LIT_PARTICIPANT_TYPE_LINK

Alias :

LPAR_TY_ LN

Display Title : Lit Participant Type Link

Volumes

Start Rows :

End Rows :

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

2

PARTICIPANT_ID

NOT NULL

NUMBER (10)

4

LIT_PARTICIPANT_TYPE_CODE

NOT NULL

VARCHAR2 (3)

Primary Key

Name

Column

LPAR_TY_LN_PK

LIT_PARTICIPANT_TYPE_CODE

PARTICIPANT_ID

Foreign Keys

LPAR_TY_LN_LPAR_TP_CD_FK

LIT_PARTICIPANT_TYPE_CODE references LIT_PARTICIPANT_TYPE_CODE.LIT_PARTICIPANT_TYPE_CODE

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LPAR_TY_LN_LT_PART_FK

PARTICIPANT_ID references LT_PARTICIPANT.PARTICIPANT_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LPAR_TY_LN_LPAR_TP_CD_FK_I

20

LIT_PARTICIPANT_TYPE_CODE

NOT UNIQUE

LPAR_TY_LN_LT_PART_FK_I

20

PARTICIPANT_ID

NOT UNIQUE

Column Detail

2

PARTICIPANT_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Oracle Designer Report : cktci

---

31 January 2007

Page

20

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

Unique ID, identifying participant

4

LIT_PARTICIPANT_TYPE_CODE

Optional ? :No ; Varchar2 (3) ;() ; ; Uppercase ? :No ;

Unique code identifying a participant type

Oracle Designer Report : cktci

---

31 January 2007

Page

21

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_AG_LAWYER

Alias :

LT_LAWYE R

Display Title : Lt Ag Lawyer

Description :

The Attorney General Lawyer for the case

User/Help Text :

The Attorney General Lawyer for the case

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

AG_LAWYER_ID

NOT NULL

NUMBER (10)

2

FIRST_NAME

NOT NULL

VARCHAR2 (25)

3

LAST_NAME

NOT NULL

VARCHAR2 (25)

4

CREATED_BY

NOT NULL

VARCHAR2 (30)

5

CREATED_DATE

NOT NULL

DATE

6

UPDATED_BY

NOT NULL

VARCHAR2 (30)

7

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_LAWYER_PK

AG_LAWYER_ID

Column Detail

1

AG_LAWYER_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique number identifying AG Lawyer

2

FIRST_NAME

Optional ? :No ; Varchar2 (25) ;() ; ; Uppercase ? :No ;

First Name of Lawyer

3

LAST_NAME

Optional ? :No ; Varchar2 (25) ;() ; ; Uppercase ? :No ;

Last Name of Lawyer

4

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person who created the record.

Oracle Designer Report : cktci

---

31 January 2007

Page

22

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

5

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date record created

6

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person who last updated the record.

7

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

The last date the record was updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

23

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_CHRONOLOGIC_EVENT

Alias :

LT_CHRON

Display Title : Lt Chronologic Event

Description :

Chronological events for the litigation

User/Help Text :

Chronological events for the litigation

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

CHRONOLOGY_ID

NOT NULL

NUMBER (10)

15

LITIGATION_ID

NOT NULL

NUMBER (10)

20

LT_COURT_LEVEL_CODE

NOT NULL

VARCHAR2 (15)

30

DESCRIPTION

NULL

VARCHAR2 (255)

40

CHRONOLOGIC_DATE

NOT NULL

DATE

50

CREATED_BY

NOT NULL

VARCHAR2 (30)

60

CREATED_DATE

NOT NULL

DATE

70

UPDATED_BY

NOT NULL

VARCHAR2 (30)

80

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_CHRON_PK

CHRONOLOGY_ID

Foreign Keys

LT_CHRON_LT_CRTLVL_FK

LT_COURT_LEVEL_CODE references LT_COURT_LEVEL_CODE.LT_COURT_LEVEL_CODE

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_CHRON_LT_LITIGTN_FK

LITIGATION_ID references LT_LITIGATION.LITIGATION_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Column Detail

Oracle Designer Report : cktci

---

31 January 2007

Page

24

of

78

Table Definition

Container :

LTrack

Version :

Index Summary

Name

Seq.

Column

Index Type

LT_CHRON_LT_CRTLVL_FK_I

13360

LT_COURT_LEVEL_CODE

NOT UNIQUE

LT_CHRON_LT_LITIGTN_FK_I

13350

LITIGATION_ID

NOT UNIQUE

Column Detail

10

CHRONOLOGY_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique number identifying chronologic event

15

LITIGATION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique surrogate key used to identify an litigation case.

20

LT_COURT_LEVEL_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Code identifying court level

30

DESCRIPTION

Optional ? :Yes ; Varchar2 (255) ;() ; ; Uppercase ? :No ;

Description of chronologic event

40

CHRONOLOGIC_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date that the chronologic event occured

50

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

60

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

70

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

80

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

25

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_CONTENT_CRITERIA

Alias :

LT_CON_C RI

Display Title : Lt Content Criteria

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.

User/Help Text :

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.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

CONTENT_CRITERIA_ID

NOT NULL

NUMBER (10)

20

PARAMETER_FORM_ID

NOT NULL

NUMBER (10)

30

DESCRIPTION

NOT NULL

VARCHAR2 (1000)

40

CREATED_BY

NOT NULL

VARCHAR2 (30)

50

CREATED_DATE

NOT NULL

DATE

60

UPDATED_BY

NOT NULL

VARCHAR2 (30)

70

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_CON_CRI_PK

CONTENT_CRITERIA_ID

Foreign Keys

LT_CON_CRI_LT_SRCHPAR_FK

PARAMETER_FORM_ID references LT_SEARCH_PARAMETER_FORM.PARAMETER_FORM_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Column Detail

10

CONTENT_CRITERIA_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Oracle Designer Report : cktci

---

31 January 2007

Page

26

of

78

Table Definition

Container :

LTrack

Version :

Index Summary

Name

Seq.

Column

Index Type

LT_CON_CRI_LT_SRCHPAR_FK_I

13370

PARAMETER_FORM_ID

NOT UNIQUE

Column Detail

Unique number identifying content criteria.

20

PARAMETER_FORM_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique id to identify search parameter form

30

DESCRIPTION

Optional ? :No ; Varchar2 (1000) ;() ; ; Uppercase ? :No ;

40

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

50

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

60

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

70

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

27

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_COURT_LEVEL_CODE

Alias :

LT_CRTLV L

Display Title : Lt Court Level Code

Description :

Contains codes that indicate the court level. IE BC Provincial court, BC Court of Appeal, BC Supreme Court, Supreme Court of Canada

User/Help Text :

Contains codes that indicate the court level. IE BC Provincial court, BC Court of Appeal, BC Supreme Court, Supreme Court of Canada

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

LT_COURT_LEVEL_CODE

NOT NULL

VARCHAR2 (15)

2

DESCRIPTION

NOT NULL

VARCHAR2 (120)

3

EFFECTIVE_DATE

NOT NULL

DATE

4

EXPIRY_DATE

NOT NULL

DATE

5

UPDATE_TIMESTAMP

NOT NULL

DATE

Primary Key

Name

Column

LT_CRTLVL_PK

LT_COURT_LEVEL_CODE

Column Detail

1

LT_COURT_LEVEL_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Code identifying court level

2

DESCRIPTION

Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;

Display description of court level

3

EFFECTIVE_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the code becomes effective

4

EXPIRY_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the code expires.

5

UPDATE_TIMESTAMP

Oracle Designer Report : cktci

---

31 January 2007

Page

28

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Oracle Designer Report : cktci

---

31 January 2007

Page

29

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_CRITICAL_EVENT

Alias :

LT_CRTEV NT

Display Title : Lt Critical Event

Description :

Records the Critical Events for the case. A critical event can be broken into chunks for more efficient storage in the system.

User/Help Text :

Records the Critical Events for the case. A critical event can be broken into chunks for more efficient storage in the system.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

CRITICAL_EVENT_ID

NOT NULL

NUMBER (10)

20

LITIGATION_ID

NOT NULL

NUMBER (10)

25

LT_COURT_LEVEL_CODE

NOT NULL

VARCHAR2 (15)

30

DESCRIPTION

NULL

VARCHAR2 (1000)

40

CREATED_BY

NOT NULL

VARCHAR2 (30)

50

CREATED_DATE

NOT NULL

DATE

60

UPDATED_BY

NOT NULL

VARCHAR2 (30)

70

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_CRTEVNT_PK

CRITICAL_EVENT_ID

Foreign Keys

LT_CRTEVNT_LT_CRTLVL_FK

LT_COURT_LEVEL_CODE references LT_COURT_LEVEL_CODE.LT_COURT_LEVEL_CODE

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_CRTEVNT_LT_LITIGTN_FK

LITIGATION_ID references LT_LITIGATION.LITIGATION_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Column Detail

Oracle Designer Report : cktci

---

31 January 2007

Page

30

of

78

Table Definition

Container :

LTrack

Version :

Index Summary

Name

Seq.

Column

Index Type

LT_CRTEVNT_LT_CRTLVL_FK_I

13390

LT_COURT_LEVEL_CODE

NOT UNIQUE

LT_CRTEVNT_LT_LITIGTN_FK_I

13380

LITIGATION_ID

NOT UNIQUE

Column Detail

10

CRITICAL_EVENT_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique ID identifying critical event.

20

LITIGATION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique surrogate key used to identify an litigation case.

25

LT_COURT_LEVEL_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Code identifying court level

30

DESCRIPTION

Optional ? :Yes ; Varchar2 (1000) ;() ; ; Uppercase ? :No ;

The description of the Critical event

40

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

50

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

60

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

70

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

31

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_CURRENT_STATUS

Alias :

LT_CURST AT

Display Title : Lt Current Status

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.

User/Help Text :

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.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

CURRENT_STATUS_ID

NOT NULL

NUMBER (10)

20

LITIGATION_ID

NOT NULL

NUMBER (10)

30

DESCRIPTION

NOT NULL

VARCHAR2 (1000)

40

CREATED_BY

NOT NULL

VARCHAR2 (30)

50

CREATED_DATE

NOT NULL

DATE

60

UPDATED_BY

NOT NULL

VARCHAR2 (30)

70

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_CURSTAT_PK

CURRENT_STATUS_ID

Foreign Keys

LT_CURSTAT_LT_LITIGTN_FK

LITIGATION_ID references LT_LITIGATION.LITIGATION_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LT_CURSTAT_LT_LITIGTN_FK_I

13400

LITIGATION_ID

NOT UNIQUE

Column Detail

Oracle Designer Report : cktci

---

31 January 2007

Page

32

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

10

CURRENT_STATUS_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique number to identify current status record. A current status can be broken into chunks for more efficient storage in the system.

20

LITIGATION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique surrogate key used to identify an litigation case.

30

DESCRIPTION

Optional ? :No ; Varchar2 (1000) ;() ; ; Uppercase ? :No ;

The content of the current status, may be a chunk of a document spread over several records.

40

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

50

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

60

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

70

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

33

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_DELIVERY_ADDRESS

Alias :

LT_DELAD DR

Display Title : Lt Delivery Address

Description :

The address that documents resulting from the search are to be delivered to.

User/Help Text :

The address that documents resulting from the search are to be delivered to.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

PARAMETER_FORM_ID

NOT NULL

NUMBER (10)

20

ADDRESSEE

NOT NULL

VARCHAR2 (30)

30

OFFICE_NAME

NULL

VARCHAR2 (75)

40

STREET

NULL

VARCHAR2 (50)

50

CITY

NULL

VARCHAR2 (30)

60

PROVINCE

NULL

VARCHAR2 (4)

70

POSTAL_CODE

NULL

VARCHAR2 (6)

80

CREATED_BY

NOT NULL

VARCHAR2 (30)

90

CREATED_DATE

NOT NULL

DATE

100

UPDATED_BY

NOT NULL

VARCHAR2 (30)

110

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_DELADDR_PK

PARAMETER_FORM_ID

Foreign Keys

LT_DELADDR_LT_SRCHPAR_FK

PARAMETER_FORM_ID references LT_SEARCH_PARAMETER_FORM.PARAMETER_FORM_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Column Detail

10

PARAMETER_FORM_ID

Oracle Designer Report : cktci

---

31 January 2007

Page

34

of

78

Table Definition

Container :

LTrack

Version :

Index Summary

Name

Seq.

Column

Index Type

LT_DELADDR_LT_SRCHPAR_FK_I

13410

PARAMETER_FORM_ID

NOT UNIQUE

Column Detail

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique id to identify search parameter form

20

ADDRESSEE

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

The person to send the documents to.

30

OFFICE_NAME

Optional ? :Yes ; Varchar2 (75) ;() ; ; Uppercase ? :No ;

The name of the office documents are sent to.

40

STREET

Optional ? :Yes ; Varchar2 (50) ;() ; ; Uppercase ? :No ;

Street address

50

CITY

Optional ? :Yes ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

City

60

PROVINCE

Optional ? :Yes ; Varchar2 (4) ;() ; ; Uppercase ? :No ;

Province

70

POSTAL_CODE

Optional ? :Yes ; Varchar2 (6) ;() ; ; Uppercase ? :No ;

Postal Code

80

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

90

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

100

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

110

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

35

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_DESCRIPTION_OF_CLAIM

Alias :

LT_CLAIM

Display Title : Lt Description Of Claim

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

User/Help Text :

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

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

DESCRIPTION_ID

NOT NULL

NUMBER (10)

20

LITIGATION_ID

NOT NULL

NUMBER (10)

30

DESCRIPTION

NULL

VARCHAR2 (1000)

40

CREATED_BY

NOT NULL

VARCHAR2 (30)

50

CREATED_DATE

NOT NULL

DATE

60

UPDATED_BY

NOT NULL

VARCHAR2 (30)

70

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_CLAIM_PK

DESCRIPTION_ID

Foreign Keys

LT_CLAIM_LT_LITIGTN_FK

LITIGATION_ID references LT_LITIGATION.LITIGATION_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Column Detail

10

DESCRIPTION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Oracle Designer Report : cktci

---

31 January 2007

Page

36

of

78

Table Definition

Container :

LTrack

Version :

Index Summary

Name

Seq.

Column

Index Type

LT_CLAIM_LT_LITIGTN_FK_I

13420

LITIGATION_ID

NOT UNIQUE

Column Detail

Unique key identifying a part of the Statement of Claim Descripiton.

20

LITIGATION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique surrogate key used to identify an litigation case.

30

DESCRIPTION

Optional ? :Yes ; Varchar2 (1000) ;() ; ; Uppercase ? :No ;

The Statement of Claim Description.

40

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

50

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

60

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

70

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

37

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_DOCUMENT

Alias :

LT_DOC

Display Title : Lt Document

Description :

Stores Documents associated with the Litigation. Typically there will only be one file associated with the litigation, the "Statement of Claim" document.

User/Help Text :

Stores Documents associated with the Litigation. Typically there will only be one file associated with the litigation, the "Statement of Claim" document.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

DOCUMENT_ID

NOT NULL

NUMBER (10)

20

LITIGATION_ID

NOT NULL

NUMBER (10)

30

FILE_NAME

NOT NULL

VARCHAR2 (255)

40

DESCRIPTION

NULL

VARCHAR2 (255)

50

DOCUMENT

NOT NULL

BLOB ()

60

CREATED_BY

NOT NULL

VARCHAR2 (30)

70

CREATED_DATE

NOT NULL

DATE

80

UPDATED_BY

NOT NULL

VARCHAR2 (30)

90

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_DOC_PK

DOCUMENT_ID

Foreign Keys

LT_DOC_LT_LITIGTN_FK

LITIGATION_ID references LT_LITIGATION.LITIGATION_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LT_DOC_LT_LITIGTN_FK_I

13430

LITIGATION_ID

NOT UNIQUE

Oracle Designer Report : cktci

---

31 January 2007

Page

38

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

10

DOCUMENT_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique number identifying the document

20

LITIGATION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique surrogate key used to identify an litigation case.

30

FILE_NAME

Optional ? :No ; Varchar2 (255) ;() ; ; Uppercase ? :No ;

The filename of the document

40

DESCRIPTION

Optional ? :Yes ; Varchar2 (255) ;() ; ; Uppercase ? :No ;

Display description of the document

50

DOCUMENT

Optional ? :No ; Blob () ;() ; ; Uppercase ? :No ;

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.

60

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

70

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

80

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

90

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Oracle Designer Report : cktci

---

31 January 2007

Page

39

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_DOMAIN_CODE

Alias :

LT_DOMN_ CD

Display Title : Lt Domain Code

Description :

Identifies all the available NT domains a Government Userid may have

User/Help Text :

Identifies all the available NT domains a Government Userid may have

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

LT_DOMAIN_CODE

NOT NULL

VARCHAR2 (15)

2

DESCRIPTION

NOT NULL

VARCHAR2 (120)

3

EFFECTIVE_DATE

NOT NULL

DATE

4

EXPIRY_DATE

NOT NULL

DATE

5

UPDATE_TIMESTAMP

NOT NULL

DATE

Primary Key

Name

Column

LT_DOMN_CD_PK

LT_DOMAIN_CODE

Column Detail

1

LT_DOMAIN_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

The domain code. Corresponds directly to the domain

2

DESCRIPTION

Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;

Description of domain

3

EFFECTIVE_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the domain becomes effective

4

EXPIRY_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the domain expires

5

UPDATE_TIMESTAMP

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Oracle Designer Report : cktci

---

31 January 2007

Page

40

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_LITIGATION

Alias :

LT_LITIG TN

Display Title : Lt Litigation

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.

User/Help Text :

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.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

LITIGATION_ID

NOT NULL

NUMBER (10)

20

ACTION_NUMBER

NULL

VARCHAR2 (20)

30

STYLE_OF_CAUSE

NOT NULL

VARCHAR2 (255)

40

FILE_ID

NULL

VARCHAR2 (30)

50

LT_LITIGATION_STATUS_CODE

NOT NULL

VARCHAR2 (15)

60

LT_COURT_LEVEL_CODE

NOT NULL

VARCHAR2 (15)

80

ABORIGINAL_IND

NOT NULL

VARCHAR2 (1)

90

SENSITIVE_IND

NOT NULL

VARCHAR2 (1)

100

DATE_PROCEEDING_FILED

NULL

DATE

110

LT_PROCEEDING_TYPE_CODE

NOT NULL

VARCHAR2 (15)

120

AG_LAWYER_ID

NOT NULL

NUMBER (10)

130

PRIMARY_ASSISTANT_ID

NULL

NUMBER (10)

140

SECONDARY_ASSISTANT_ID

NULL

NUMBER (10)

150

REGION_HQ_ID

NOT NULL

NUMBER (10)

160

DISTRICT_ID

NULL

NUMBER (10)

170

INSTRUCTION_PROVIDER_ID

NULL

NUMBER (10)

180

LITIGATION_COORDINATOR_ID

NULL

NUMBER (10)

190

SEARCH_COORDINATOR_ID

NULL

NUMBER (10)

200

SCAN_TECHNICIAN_ID

NULL

NUMBER (10)

210

TRIAL_DATE

NULL

DATE

220

KEY_CONTACTS

NULL

VARCHAR2 (1000)

Oracle Designer Report : cktci

---

31 January 2007

Page

41

of

78

Table Definition

Container :

LTrack

Version :

Col.Seq.

Column

Nulls ?

Type

230

AD_HOC_COUNSEL

NULL

VARCHAR2 (255)

240

AD_HOC_IND

NULL

VARCHAR2 (1)

250

OPPOSING_COUNSEL

NULL

VARCHAR2 (255)

260

FINANCIAL_RESPONSIBILITY

NULL

VARCHAR2 (255)

270

ALERT_DATE

NULL

DATE

280

LITIGATION_COMPLETED_DATE

NULL

DATE

290

RELATED_FOI_REQUEST

NULL

VARCHAR2 (20)

320

CREATED_BY

NOT NULL

VARCHAR2 (30)

330

CREATED_DATE

NOT NULL

DATE

340

UPDATED_BY

NOT NULL

VARCHAR2 (30)

350

UPDATED_DATE

NOT NULL

DATE

352

COURT_LEVEL_REGISTRY_ID

NOT NULL

NUMBER (10)

Primary Key

Name

Column

LT_LITIGTN_PK

LITIGATION_ID

Other Unique Keys

Name

Column

LT_LITIGTN_LT_FILE_ID_UNQ_UK

FILE_ID

Column Detail

10

LITIGATION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique surrogate key used to identify an litigation case.

20

ACTION_NUMBER

Optional ? :Yes ; Varchar2 (20) ;() ; ; Uppercase ? :No ;

Unique alpha-numberic number assigned by the court registry to identify the case.

30

STYLE_OF_CAUSE

Optional ? :No ; Varchar2 (255) ;() ; ; Uppercase ? :No ;

The name of the case. Identifies the plaintiff and defendent. IE "John Doe v. Her Majesty the Queen"

40

FILE_ID

Optional ? :Yes ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Interal id used by staff to refer to the litigation

50

LT_LITIGATION_STATUS_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Oracle Designer Report : cktci

---

31 January 2007

Page

42

of

78

Table Definition

Container :

LTrack

Version :

Foreign Keys

LT_LITHAS_INSTRUCTION_PROVI_FK

INSTRUCTION_PROVIDER_ID references LT_PARTICIPANT.PARTICIPANT_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

No

Delete Rule :

Restricted

LT_LITIGHAS_SEARCH_COORDINA_FK

SEARCH_COORDINATOR_ID references LT_PARTICIPANT.PARTICIPANT_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

No

Delete Rule :

Restricted

LT_LITIGTHAS_PRIMARY_ASSIST_FK

PRIMARY_ASSISTANT_ID references LT_AG_LAWYER.AG_LAWYER_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

No

Delete Rule :

Restricted

LT_LITIGTN_LCLR_FK

COURT_LEVEL_REGISTRY_ID references LIT_COURT_LEVEL_REGISTRY.COURT_LEVEL_REGISTRY_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

No

Delete Rule :

Restricted

LT_LITIGTN_LT_CRTLVL_FK

LT_COURT_LEVEL_CODE references LT_COURT_LEVEL_CODE.LT_COURT_LEVEL_CODE

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_LITIGTN_LT_LAWYER_FK

AG_LAWYER_ID references LT_AG_LAWYER.AG_LAWYER_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_LITIGTN_LT_LITSTCD_FK

LT_LITIGATION_STATUS_CODE references LT_LITIGATION_STATUS_CODE.LT_LITIGATION_STATUS_CODE

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_LITIGTN_LT_PARHAS_SCAN_T_FK

SCAN_TECHNICIAN_ID references LT_PARTICIPANT.PARTICIPANT_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Column Detail

Oracle Designer Report : cktci

---

31 January 2007

Page

43

of

78

Table Definition

Container :

LTrack

Version :

Foreign Keys

LT_LITIGTN_LT_PART_FK

LITIGATION_COORDINATOR_ID references LT_PARTICIPANT.PARTICIPANT_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

No

Delete Rule :

Restricted

LT_LITIGTN_LT_PRCTYP_FK

LT_PROCEEDING_TYPE_CODE references LT_PROCEEDING_TYPE_CODE.LT_PROCEEDING_TYPE_CODE

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_LITIGTN_ORG_UNIHAS_DISTR_FK

DISTRICT_ID references ORG_UNIT.ORG_UNIT_NO

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

No

Delete Rule :

Restricted

LT_LITIGTN_ORG_UNIT_FK

REGION_HQ_ID references ORG_UNIT.ORG_UNIT_NO

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_LITIHAS_SECONDARY_ASSIST_FK

SECONDARY_ASSISTANT_ID references LT_AG_LAWYER.AG_LAWYER_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

No

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LT_LITHAS_INSTRUCTION_PROVI__I

13450

INSTRUCTION_PROVIDER_ID

NOT UNIQUE

LT_LITIGHAS_SEARCH_COORDINA__I

13460

SEARCH_COORDINATOR_ID

NOT UNIQUE

LT_LITIGTHAS_PRIMARY_ASSIST__I

20

PRIMARY_ASSISTANT_ID

NOT UNIQUE

LT_LITIGTN_LCLR_FK_I

20

COURT_LEVEL_REGISTRY_ID

NOT UNIQUE

LT_LITIGTN_LT_CRTLVL_FK_I

13470

LT_COURT_LEVEL_CODE

NOT UNIQUE

LT_LITIGTN_LT_LAWYER_FK_I

13530

AG_LAWYER_ID

NOT UNIQUE

LT_LITIGTN_LT_LITSTCD_FK_I

13480

LT_LITIGATION_STATUS_CODE

NOT UNIQUE

LT_LITIGTN_LT_PARHAS_SCAN_T__I

20

SCAN_TECHNICIAN_ID

NOT UNIQUE

LT_LITIGTN_LT_PART_FK_I

13440

LITIGATION_COORDINATOR_ID

NOT UNIQUE

LT_LITIGTN_LT_PRCTYP_FK_I

13490

LT_PROCEEDING_TYPE_CODE

NOT UNIQUE

LT_LITIGTN_ORG_UNIHAS_DISTR__I

13510

DISTRICT_ID

NOT UNIQUE

Oracle Designer Report : cktci

---

31 January 2007

Page

44

of

78

Table Definition

Container :

LTrack

Version :

Name

Seq.

Column

Index Type

LT_LITIGTN_ORG_UNIT_FK_I

13500

REGION_HQ_ID

NOT UNIQUE

LT_LITIHAS_SECONDARY_ASSIST__I

20

SECONDARY_ASSISTANT_ID

NOT UNIQUE

Column Detail

Code identifying litigation status

60

LT_COURT_LEVEL_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Code identifying court level

80

ABORIGINAL_IND

Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ; Default Value :N ;

Indicates if the case is an aboriginal case or not

90

SENSITIVE_IND

Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ; Default Value :N ;

Assesment of sensitivity. Either it's sensitive or not.

100

DATE_PROCEEDING_FILED

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

The date the proceeding was filed.

110

LT_PROCEEDING_TYPE_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Unique code defining a litigation type

120

AG_LAWYER_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique number identifying AG Lawyer

130

PRIMARY_ASSISTANT_ID

Optional ? :Yes ; Number (10) ;() ; ; Uppercase ? :No ;

Unique number identifying AG Lawyer

140

SECONDARY_ASSISTANT_ID

Optional ? :Yes ; Number (10) ;() ; ; Uppercase ? :No ;

Unique number identifying AG Lawyer

150

REGION_HQ_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

The code identifying a MOF office.

160

DISTRICT_ID

Optional ? :Yes ; Number (10) ;() ; ; Uppercase ? :No ;

The code identifying a MOF office.

170

Oracle Designer Report : cktci

---

31 January 2007

Page

45

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

INSTRUCTION_PROVIDER_ID

Optional ? :Yes ; Number (10) ;() ; ; Uppercase ? :No ;

Unique ID, identifying participant

180

LITIGATION_COORDINATOR_ID

Optional ? :Yes ; Number (10) ;() ; ; Uppercase ? :No ;

Unique ID, identifying participant

190

SEARCH_COORDINATOR_ID

Optional ? :Yes ; Number (10) ;() ; ; Uppercase ? :No ;

Unique ID, identifying participant

200

SCAN_TECHNICIAN_ID

Optional ? :Yes ; Number (10) ;() ; ; Uppercase ? :No ;

Unique ID, identifying participant

210

TRIAL_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

Trial Date of case.

220

KEY_CONTACTS

Optional ? :Yes ; Varchar2 (1000) ;() ; ; Uppercase ? :No ;

Identifies the key contacts for the litigation.

230

AD_HOC_COUNSEL

Optional ? :Yes ; Varchar2 (255) ;() ; ; Uppercase ? :No ;

Some cases may require Lawyers outside of the ministry for special counsel. They are called Ad Hoc Counsel.

240

AD_HOC_IND

Optional ? :Yes ; Varchar2 (1) ;() ; ; Uppercase ? :No ; Default Value :N ;

Indicates if Ad Hoc Counsel involved in case.

250

OPPOSING_COUNSEL

Optional ? :Yes ; Varchar2 (255) ;() ; ; Uppercase ? :No ;

260

FINANCIAL_RESPONSIBILITY

Optional ? :Yes ; Varchar2 (255) ;() ; ; Uppercase ? :No ;

Describes who will bear the financial responsibility for the Document search process.

270

ALERT_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

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).

280

LITIGATION_COMPLETED_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

The date on which the Litigation was completed.

290

RELATED_FOI_REQUEST

Oracle Designer Report : cktci

---

31 January 2007

Page

46

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

Optional ? :Yes ; Varchar2 (20) ;() ; ; Uppercase ? :No ;

Stores the related FOI request document number. IE FOR-04-12345

320

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

330

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

Date the file was input

340

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

350

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

Date entry updated.

352

COURT_LEVEL_REGISTRY_ID

Optional ? :No ; Number (10) ;() ; ; Domain :NUMERIC_ID ; Uppercase ? :No ;

Unique number identifying a court level registry.

Oracle Designer Report : cktci

---

31 January 2007

Page

47

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_LITIGATION_NOTE

Alias :

LT_LITNO TE

Display Title : Lt Litigation Note

Description :

Records notes about the Litigation that are relevant to the Document Discovery process

User/Help Text :

Records notes about the Litigation that are relevant to the Document Discovery process

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

NOTE_ID

NOT NULL

NUMBER (10)

20

LITIGATION_ID

NOT NULL

NUMBER (10)

30

NOTE

NULL

VARCHAR2 (1000)

40

CREATED_BY

NOT NULL

VARCHAR2 (30)

50

CREATED_DATE

NOT NULL

DATE

60

UPDATED_BY

NOT NULL

VARCHAR2 (30)

70

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_LITNOTE_PK

NOTE_ID

Foreign Keys

LT_LITNOTE_LT_LITIGTN_FK

LITIGATION_ID references LT_LITIGATION.LITIGATION_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LT_LITNOTE_LT_LITIGTN_FK_I

13540

LITIGATION_ID

NOT UNIQUE

Column Detail

Oracle Designer Report : cktci

---

31 January 2007

Page

48

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

10

NOTE_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique ID identifying a note

20

LITIGATION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique surrogate key used to identify an litigation case.

30

NOTE

Optional ? :Yes ; Varchar2 (1000) ;() ; ; Uppercase ? :No ;

The content of the notes

40

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Note author

50

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Creation date of note

60

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Person who updated the note.

70

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

The update date of the note

Oracle Designer Report : cktci

---

31 January 2007

Page

49

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_LITIGATION_STATUS_CODE

Alias :

LT_LITST CD

Display Title : Lt Litigation Status Code

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

User/Help Text :

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

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

LT_LITIGATION_STATUS_CODE

NOT NULL

VARCHAR2 (15)

2

DESCRIPTION

NOT NULL

VARCHAR2 (120)

3

EFFECTIVE_DATE

NOT NULL

DATE

4

EXPIRY_DATE

NOT NULL

DATE

5

UPDATE_TIMESTAMP

NOT NULL

DATE

Primary Key

Name

Column

LT_LITSTCD_PK

LT_LITIGATION_STATUS_CODE

Column Detail

1

LT_LITIGATION_STATUS_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Code identifying litigation status

2

DESCRIPTION

Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;

Display description of litigation status

3

EFFECTIVE_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the code becomes effective

4

EXPIRY_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

Oracle Designer Report : cktci

---

31 January 2007

Page

50

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

The date the code expires.

5

UPDATE_TIMESTAMP

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Oracle Designer Report : cktci

---

31 January 2007

Page

51

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_LOCAL_SEARCH_COORDINATOR

Alias :

LT_LOCCO OR

Display Title : Lt Local Search Coordinator

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.

User/Help Text :

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.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

LOCAL_COORDINATOR_ID

NOT NULL

NUMBER (10)

20

PARAMETER_FORM_ID

NOT NULL

NUMBER (10)

25

PARTICIPANT_ID

NOT NULL

NUMBER (10)

27

OFFICE_NUMBER

NOT NULL

NUMBER (10)

30

CREATED_BY

NOT NULL

VARCHAR2 (30)

40

CREATED_DATE

NOT NULL

DATE

50

UPDATED_BY

NOT NULL

VARCHAR2 (30)

60

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_LOCCOOR_PK

LOCAL_COORDINATOR_ID

Other Unique Keys

Name

Column

LT__LT_PARTICIPANT_FORM_UNQ_UK

PARAMETER_FORM_ID

OFFICE_NUMBER

PARTICIPANT_ID

Column Detail

10

LOCAL_COORDINATOR_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Oracle Designer Report : cktci

---

31 January 2007

Page

52

of

78

Table Definition

Container :

LTrack

Version :

Foreign Keys

LT_LOCCOOR_LT_PART_FK

PARTICIPANT_ID references LT_PARTICIPANT.PARTICIPANT_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_LOCCOOR_LT_SRCH_OF_FK

OFFICE_NUMBER references LT_SEARCH_OFFICE_LINK.OFFICE_NUMBER

PARAMETER_FORM_ID references LT_SEARCH_OFFICE_LINK.PARAMETER_FORM_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LT_LOCCOOR_LT_PART_FK_I

13550

PARTICIPANT_ID

NOT UNIQUE

LT_LOCCOOR_LT_SRCH_OF_FK_I

1

OFFICE_NUMBER

NOT UNIQUE

LT_LOCCOOR_LT_SRCH_OF_FK_I

13560

PARAMETER_FORM_ID

NOT UNIQUE

Column Detail

Unique ID identifying the search coordinator.

20

PARAMETER_FORM_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique id to identify search parameter form

25

PARTICIPANT_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique ID, identifying participant

27

OFFICE_NUMBER

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

The code identifying a MOF office.

30

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

40

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

50

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

Oracle Designer Report : cktci

---

31 January 2007

Page

53

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

60

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

54

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_LOCAL_SEARCH_DELEGATE

Alias :

LT_SRCHD EL

Display Title : Lt Local Search Delegate

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.

User/Help Text :

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.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

LOCAL_COORDINATOR_ID

NOT NULL

NUMBER (10)

15

LT_DOMAIN_CODE

NOT NULL

VARCHAR2 (15)

20

USERNAME

NOT NULL

VARCHAR2 (32)

30

CREATED_BY

NOT NULL

VARCHAR2 (30)

40

CREATED_DATE

NOT NULL

DATE

50

UPDATED_BY

NOT NULL

VARCHAR2 (30)

60

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_SRCHDEL_PK

LOCAL_COORDINATOR_ID

LT_DOMAIN_CODE

USERNAME

Column Detail

10

LOCAL_COORDINATOR_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique ID identifying the search coordinator.

15

LT_DOMAIN_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

The domain code. Corresponds directly to the domain

Oracle Designer Report : cktci

---

31 January 2007

Page

55

of

78

Table Definition

Container :

LTrack

Version :

Foreign Keys

LT_SRCHDEL_LT_DOMN_CD_FK

LT_DOMAIN_CODE references LT_DOMAIN_CODE.LT_DOMAIN_CODE

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_SRCHDEL_LT_LOCCOOR_FK

LOCAL_COORDINATOR_ID references LT_LOCAL_SEARCH_COORDINATOR.LOCAL_COORDINATOR_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LT_SRCHDEL_LT_DOMN_CD_FK_I

13580

LT_DOMAIN_CODE

NOT UNIQUE

LT_SRCHDEL_LT_LOCCOOR_FK_I

13570

LOCAL_COORDINATOR_ID

NOT UNIQUE

Column Detail

20

USERNAME

Optional ? :No ; Varchar2 (32) ;() ; ; Uppercase ? :No ;

30

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

40

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

50

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

60

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

56

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_PARTICIPANT

Alias :

LT_PART

Display Title : Lt Participant

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.

User/Help Text :

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.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

PARTICIPANT_ID

NOT NULL

NUMBER (10)

2

LAST_NAME

NOT NULL

VARCHAR2 (25)

3

FIRST_NAME

NOT NULL

VARCHAR2 (25)

4

PARTICIPANT_TITLE

NULL

VARCHAR2 (100)

5

OFFICE

NULL

VARCHAR2 (50)

6

PHONE_NO

NULL

VARCHAR2 (15)

7

FAX_NO

NULL

VARCHAR2 (15)

8

EMAIL

NULL

VARCHAR2 (50)

9

USERID

NOT NULL

VARCHAR2 (50)

10

EFFECTIVE_DATE

NOT NULL

DATE

11

EXPIRY_DATE

NOT NULL

DATE

12

CREATED_BY

NOT NULL

VARCHAR2 (30)

13

CREATED_DATE

NOT NULL

DATE

14

UPDATED_BY

NOT NULL

VARCHAR2 (30)

15

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_PART_PK

PARTICIPANT_ID

Column Detail

1

PARTICIPANT_ID

Oracle Designer Report : cktci

---

31 January 2007

Page

57

of

78

Table Definition

Container :

LTrack

Version :

Other Unique Keys

Name

Column

LT_PART_LT_PART_USERID_UNQ_UK

USERID

Column Detail

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique ID, identifying participant

2

LAST_NAME

Optional ? :No ; Varchar2 (25) ;() ; ; Uppercase ? :No ;

Last Name of participant

3

FIRST_NAME

Optional ? :No ; Varchar2 (25) ;() ; ; Uppercase ? :No ;

First Name of Participant

4

PARTICIPANT_TITLE

Optional ? :Yes ; Varchar2 (100) ;() ; ; Uppercase ? :No ;

The title of the participant. IE They may be a Local Search Coordinator, whose title is Director of a Forest District Branch

5

OFFICE

Optional ? :Yes ; Varchar2 (50) ;() ; ; Uppercase ? :No ;

The office where the participant works.

6

PHONE_NO

Optional ? :Yes ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Participant's phone number

7

FAX_NO

Optional ? :Yes ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Participant's Fax Number

8

EMAIL

Optional ? :Yes ; Varchar2 (50) ;() ; ; Uppercase ? :No ;

Participant's Email address

9

USERID

Optional ? :No ; Varchar2 (50) ;() ; ; Uppercase ? :No ;

The userid of the participant. Must be qualified with a domain name. IE: BCGOV\JDOE or FSMASTER\EMURPHY

10

EFFECTIVE_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the code becomes effective

11

EXPIRY_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the code expires.

Oracle Designer Report : cktci

---

31 January 2007

Page

58

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

12

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

13

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

14

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

15

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

59

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_PROCEEDING_TYPE_CODE

Alias :

LT_PRCTY P

Display Title : Lt Proceeding Type Code

Description :

Identifies the proceeding types for the litigation

User/Help Text :

Identifies the proceeding types for the litigation

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

LT_PROCEEDING_TYPE_CODE

NOT NULL

VARCHAR2 (15)

2

DESCRIPTION

NOT NULL

VARCHAR2 (120)

3

EFFECTIVE_DATE

NOT NULL

DATE

4

EXPIRY_DATE

NOT NULL

DATE

5

UPDATE_TIMESTAMP

NOT NULL

DATE

Primary Key

Name

Column

LT_PRCTYP_PK

LT_PROCEEDING_TYPE_CODE

Column Detail

1

LT_PROCEEDING_TYPE_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Unique code defining a litigation type

2

DESCRIPTION

Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;

Display description of the litigation type

3

EFFECTIVE_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the code becomes effective

4

EXPIRY_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the code expires

5

UPDATE_TIMESTAMP

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Oracle Designer Report : cktci

---

31 January 2007

Page

60

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_REGISTRY

Alias :

LT_REGST RY

Display Title : Lt Registry

Description :

Specifies the court registry (court locations) where the litigation is being heard

User/Help Text :

Specifies the court registry (court locations) where the litigation is being heard

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

REGISTRY_ID

NOT NULL

NUMBER (10)

30

REGISTRY

NOT NULL

VARCHAR2 (50)

40

CREATED_BY

NOT NULL

VARCHAR2 (30)

50

CREATED_DATE

NOT NULL

DATE

60

UPDATED_BY

NOT NULL

VARCHAR2 (30)

70

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_REGSTRY_PK

REGISTRY_ID

Column Detail

10

REGISTRY_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique number identifying court location

30

REGISTRY

Optional ? :No ; Varchar2 (50) ;() ; ; Uppercase ? :No ;

The name of the court registry.

40

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

50

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

Oracle Designer Report : cktci

---

31 January 2007

Page

61

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

60

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

70

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

62

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_RELATED_CASE

Alias :

LRC

Display Title : Lt Related Case

Description :

Tracks related litigations. This allows a user to view information from cases that may be related in some form.

User/Help Text :

Tracks related litigations. This allows a user to view information from cases that may be related in some form.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

RELATED_LITIGATION_ID

NOT NULL

NUMBER (10)

20

LITIGATION_ID

NOT NULL

NUMBER (10)

30

CREATED_BY

NOT NULL

VARCHAR2 (30)

40

CREATED_DATE

NOT NULL

DATE

50

UPDATED_BY

NOT NULL

VARCHAR2 (30)

60

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LRC_PK

LITIGATION_ID

RELATED_LITIGATION_ID

Foreign Keys

LRC_LT_LITIGTN_FK

LITIGATION_ID references LT_LITIGATION.LITIGATION_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LRC_LT_LITIGTN_FK_I

13600

LITIGATION_ID

NOT UNIQUE

Column Detail

10

RELATED_LITIGATION_ID

Oracle Designer Report : cktci

---

31 January 2007

Page

63

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

The Litigation ID of a related case.

20

LITIGATION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique surrogate key used to identify an litigation case.

30

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

40

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

50

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

60

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

64

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_SEARCH_ACTION

Alias :

LT_ACTIO N

Display Title : Lt Search Action

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.

User/Help Text :

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.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

ACTION_ID

NOT NULL

NUMBER (10)

20

ACTION_FORM_ID

NOT NULL

NUMBER (10)

30

SEARCH_ACTION

NULL

VARCHAR2 (1000)

40

SEARCH_ACTION_DATE

NOT NULL

DATE

50

DOCUMENT_FOUND_IND

NOT NULL

VARCHAR2 (1)

60

LOCATION_FOUND

NULL

VARCHAR2 (500)

70

PRIMARY_NO

NULL

NUMBER (5)

80

SECONDARY_NO

NULL

NUMBER (2)

90

TERTIARY_TXT

NULL

VARCHAR2 (40)

100

TITLE_TXT

NULL

VARCHAR2 (120)

110

FILE_NUMBER

NULL

VARCHAR2 (30)

120

FILE_NAME

NULL

VARCHAR2 (50)

130

RELATED_DOCUMENTS_IND

NOT NULL

VARCHAR2 (1)

140

NUMBER_OF_VOLUMES

NULL

NUMBER (10)

150

NOTES

NULL

VARCHAR2 (1000)

160

CREATED_BY

NOT NULL

VARCHAR2 (30)

170

CREATED_DATE

NOT NULL

DATE

180

UPDATED_BY

NOT NULL

VARCHAR2 (30)

190

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

Oracle Designer Report : cktci

---

31 January 2007

Page

65

of

78

Table Definition

Container :

LTrack

Version :

Name

Column

LT_ACTION_PK

ACTION_ID

Foreign Keys

LT_ACTION_LT_SRCHACT_FK

ACTION_FORM_ID references LT_SEARCH_ACTION_FORM.ACTION_FORM_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LT_ACTION_LT_SRCHACT_FK_I

13610

ACTION_FORM_ID

NOT UNIQUE

Column Detail

10

ACTION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique number identifying action

20

ACTION_FORM_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique number identifying Search Action Form

30

SEARCH_ACTION

Optional ? :Yes ; Varchar2 (1000) ;() ; ; Uppercase ? :No ;

Description of Search Action. IE talked to district manager. Searched main file room.

40

SEARCH_ACTION_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

The date the search action was performed

50

DOCUMENT_FOUND_IND

Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ; Default Value :N ;

Indicates that documents were found.

60

LOCATION_FOUND

Optional ? :Yes ; Varchar2 (500) ;() ; ; Uppercase ? :No ;

The Location documents were found. IE File Cabinet B, 2nd drawer room 202

70

PRIMARY_NO

Optional ? :Yes ; Number (5) ;() ; ; Uppercase ? :No ;

ARCS/ORCS Number used to classify all files related to a subject or function regardless of physical format.

80

SECONDARY_NO

Oracle Designer Report : cktci

---

31 January 2007

Page

66

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

Optional ? :Yes ; Number (2) ;() ; ; Uppercase ? :No ;

ARCS/ORCS Number used for further classification

90

TERTIARY_TXT

Optional ? :Yes ; Varchar2 (40) ;() ; ; Uppercase ? :No ;

Short descriptive name and/or number reference of file. May or may not be associated with an ARC/ORCS Primary and Secondary Classification

100

TITLE_TXT

Optional ? :Yes ; Varchar2 (120) ;() ; ; Uppercase ? :No ;

Long Description of file, as required, to further describe purpose or contents beyond short description

110

FILE_NUMBER

Optional ? :Yes ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

File Number of file/document found. Could be ARCS/ORCS number

120

FILE_NAME

Optional ? :Yes ; Varchar2 (50) ;() ; ; Uppercase ? :No ;

Name of file found.

130

RELATED_DOCUMENTS_IND

Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ; Default Value :N ;

Indicates if searcher believes the file contains related documents.

140

NUMBER_OF_VOLUMES

Optional ? :Yes ; Number (10) ;() ; ; Uppercase ? :No ;

Number of volumes that make up the file

150

NOTES

Optional ? :Yes ; Varchar2 (1000) ;() ; ; Uppercase ? :No ;

Notes regarding the search action or files found

160

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

170

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

180

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

190

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

67

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_SEARCH_ACTION_FORM

Alias :

LT_SRCHA CT

Display Title : Lt Search Action Form

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.

User/Help Text :

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.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

ACTION_FORM_ID

NOT NULL

NUMBER (10)

15

PARAMETER_FORM_ID

NOT NULL

NUMBER (10)

20

LOCAL_COORDINATOR_ID

NOT NULL

NUMBER (10)

25

LT_SEARCH_STATUS_CODE

NOT NULL

VARCHAR2 (15)

30

SIGN_OFF_IND

NOT NULL

VARCHAR2 (1)

40

SIGN_OFF_DATE

NULL

DATE

50

DELIVERED_IND

NOT NULL

VARCHAR2 (1)

60

DELIVER_METHOD

NULL

VARCHAR2 (25)

70

DELIVER_DATE

NULL

DATE

80

DELIVERER_NAME

NULL

VARCHAR2 (30)

90

RECEIVED_DATE

NULL

DATE

100

RECEIVER_NAME

NULL

VARCHAR2 (30)

105

NOTES

NULL

VARCHAR2 (4000)

110

CREATED_BY

NOT NULL

VARCHAR2 (30)

120

CREATED_DATE

NOT NULL

DATE

130

UPDATED_BY

NOT NULL

VARCHAR2 (30)

140

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_SRCHACT_PK

ACTION_FORM_ID

Column Detail

Oracle Designer Report : cktci

---

31 January 2007

Page

68

of

78

Table Definition

Container :

LTrack

Version :

Foreign Keys

LT_SRCHACT_LT_LOCCOOR_FK

LOCAL_COORDINATOR_ID references LT_LOCAL_SEARCH_COORDINATOR.LOCAL_COORDINATOR_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_SRCHACT_LT_SRCHPAR_FK

PARAMETER_FORM_ID references LT_SEARCH_PARAMETER_FORM.PARAMETER_FORM_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_SRCHACT_LT_SRCH_ST_FK

LT_SEARCH_STATUS_CODE references LT_SEARCH_STATUS_CODE.LT_SEARCH_STATUS_CODE

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LT_SRCHACT_LT_LOCCOOR_FK_I

13620

LOCAL_COORDINATOR_ID

NOT UNIQUE

LT_SRCHACT_LT_SRCHPAR_FK_I

13630

PARAMETER_FORM_ID

NOT UNIQUE

LT_SRCHACT_LT_SRCH_ST_FK_I

13640

LT_SEARCH_STATUS_CODE

NOT UNIQUE

Column Detail

10

ACTION_FORM_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique number identifying Search Action Form

15

PARAMETER_FORM_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique id to identify search parameter form

20

LOCAL_COORDINATOR_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique ID identifying the search coordinator.

25

LT_SEARCH_STATUS_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Unique code identifying the status

30

SIGN_OFF_IND

Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ; Default Value :N ;

Oracle Designer Report : cktci

---

31 January 2007

Page

69

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

Indicates if the Local Search Coordinator has signed off on local search being complete or not.

40

SIGN_OFF_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

Date that the Local Search Coordinator signed off on search results.

50

DELIVERED_IND

Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ; Default Value :N ;

Indicates if documents were delivered or not.

60

DELIVER_METHOD

Optional ? :Yes ; Varchar2 (25) ;() ; ; Uppercase ? :No ;

The method used to deliver files. IE Courier, Canda Post, Greyhound

70

DELIVER_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

Date files were delivered

80

DELIVERER_NAME

Optional ? :Yes ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Person who orchestrated the delivery

90

RECEIVED_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

Date the Files were recieved

100

RECEIVER_NAME

Optional ? :Yes ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Person who recieved the files.

105

NOTES

Optional ? :Yes ; Varchar2 (4000) ;() ; ; Uppercase ? :No ;

Common Notes field for general discussion of search action form

110

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

120

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the file was input

130

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

140

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

70

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_SEARCH_OFFICE_LINK

Alias :

LT_SRCH_ OF

Display Title : Lt Search Office Link

Description :

Creates list of offices that are to be searched for documents

User/Help Text :

Creates list of offices that are to be searched for documents

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

PARAMETER_FORM_ID

NOT NULL

NUMBER (10)

15

OFFICE_NUMBER

NOT NULL

NUMBER (10)

20

CREATED_BY

NOT NULL

VARCHAR2 (30)

30

CREATED_DATE

NOT NULL

DATE

40

UPDATED_BY

NOT NULL

VARCHAR2 (30)

50

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_SRCH_OF_PK

PARAMETER_FORM_ID

OFFICE_NUMBER

Foreign Keys

LT_SRCH_OF_LT_SRCHPAR_FK

PARAMETER_FORM_ID references LT_SEARCH_PARAMETER_FORM.PARAMETER_FORM_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

LT_SRCH_OF_ORG_UNIT_FK

OFFICE_NUMBER references ORG_UNIT.ORG_UNIT_NO

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Column Detail

Oracle Designer Report : cktci

---

31 January 2007

Page

71

of

78

Table Definition

Container :

LTrack

Version :

Index Summary

Name

Seq.

Column

Index Type

LT_SRCH_OF_LT_SRCHPAR_FK_I

13660

PARAMETER_FORM_ID

NOT UNIQUE

LT_SRCH_OF_ORG_UNIT_FK_I

13650

OFFICE_NUMBER

NOT UNIQUE

Column Detail

10

PARAMETER_FORM_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique id to identify search parameter form

15

OFFICE_NUMBER

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

The code identifying a MOF office.

20

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

30

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

40

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

50

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Oracle Designer Report : cktci

---

31 January 2007

Page

72

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_SEARCH_PARAMETER_FORM

Alias :

LT_SRCHP AR

Display Title : Lt Search Parameter Form

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.

User/Help Text :

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.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

10

PARAMETER_FORM_ID

NOT NULL

NUMBER (10)

20

LITIGATION_ID

NOT NULL

NUMBER (10)

30

DISPLAY_ID

NOT NULL

NUMBER (10)

40

RECEIVE_DUE_DATE

NULL

DATE

50

GEOGRAPHIC_SCOPE

NULL

VARCHAR2 (1000)

60

TIME_PERIOD_BEGIN

NULL

DATE

70

TIME_PERIOD_END

NULL

DATE

80

DOCUMENT_FORMATS

NULL

VARCHAR2 (1000)

90

NOTES

NULL

VARCHAR2 (4000)

100

SIGN_OFF_IND

NOT NULL

VARCHAR2 (1)

110

SIGN_OFF_DATE

NULL

DATE

120

CREATED_BY

NOT NULL

VARCHAR2 (30)

130

CREATED_DATE

NOT NULL

DATE

140

UPDATED_BY

NOT NULL

VARCHAR2 (30)

150

UPDATED_DATE

NOT NULL

DATE

Primary Key

Name

Column

LT_SRCHPAR_PK

PARAMETER_FORM_ID

Column Detail

Oracle Designer Report : cktci

---

31 January 2007

Page

73

of

78

Table Definition

Container :

LTrack

Version :

Other Unique Keys

Name

Column

LT_SRCHPA_LT_DISPLAY_ID_UNQ_UK

DISPLAY_ID

LITIGATION_ID

Foreign Keys

LT_SRCHPAR_LT_LITIGTN_FK

LITIGATION_ID references LT_LITIGATION.LITIGATION_ID

Transferable ?

Yes

Update Rule :

Restricted

Mandatory ?

Yes

Delete Rule :

Restricted

Index Summary

Name

Seq.

Column

Index Type

LT_SRCHPAR_LT_LITIGTN_FK_I

13670

LITIGATION_ID

NOT UNIQUE

Column Detail

10

PARAMETER_FORM_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique id to identify search parameter form

20

LITIGATION_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

Unique surrogate key used to identify an litigation case.

30

DISPLAY_ID

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ; Default Value :1 ;

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.

40

RECEIVE_DUE_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

The Date the results of the Search are due by

50

GEOGRAPHIC_SCOPE

Optional ? :Yes ; Varchar2 (1000) ;() ; ; Uppercase ? :No ;

Description of the geographic scope of the search.

60

TIME_PERIOD_BEGIN

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

The search action should find documents that were created on or after the time period begin date.

70

TIME_PERIOD_END

Oracle Designer Report : cktci

---

31 January 2007

Page

74

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

The search action should find documents that were created on or before the time period end date.

80

DOCUMENT_FORMATS

Optional ? :Yes ; Varchar2 (1000) ;() ; ; Uppercase ? :No ;

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.

90

NOTES

Optional ? :Yes ; Varchar2 (4000) ;() ; ; Uppercase ? :No ;

100

SIGN_OFF_IND

Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ; Default Value :N ;

Indicates if the Search Coordinator has Signed Off on search being complete or not

110

SIGN_OFF_DATE

Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;

The date the search was signed off as complete.

120

CREATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person inputing this entry

130

CREATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date the parameter form was created.

140

UPDATED_BY

Optional ? :No ; Varchar2 (30) ;() ; ; Uppercase ? :No ;

Userid of person updating entry

150

UPDATED_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Date entry updated.

Oracle Designer Report : cktci

---

31 January 2007

Page

75

of

78

Table Definition

Container :

LTrack

Version :

Table Name : LT_SEARCH_STATUS_CODE

Alias :

LT_SRCH_ ST

Display Title : Lt Search Status Code

Description :

Contains the codes that identify the current status of a search action form.

User/Help Text :

Contains the codes that identify the current status of a search action form.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

LT_SEARCH_STATUS_CODE

NOT NULL

VARCHAR2 (15)

2

DESCRIPTION

NOT NULL

VARCHAR2 (120)

3

EFFECTIVE_DATE

NOT NULL

DATE

4

EXPIRY_DATE

NOT NULL

DATE

5

UPDATE_TIMESTAMP

NOT NULL

DATE

Primary Key

Name

Column

LT_SRCH_ST_PK

LT_SEARCH_STATUS_CODE

Column Detail

1

LT_SEARCH_STATUS_CODE

Optional ? :No ; Varchar2 (15) ;() ; ; Uppercase ? :No ;

Unique code identifying the status

2

DESCRIPTION

Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;

The display description for the code

3

EFFECTIVE_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the code becomes effective

4

EXPIRY_DATE

Optional ? :No ; Date ;() ; ; Uppercase ? :No ;

The date the code expires

5

UPDATE_TIMESTAMP

Oracle Designer Report : cktci

---

31 January 2007

Page

76

of

78

Table Definition

Container :

LTrack

Version :

Column Detail

Optional ? :No ; Date ;() ; ; Uppercase ? :No ; Default Value :SYSDATE ;

Oracle Designer Report : cktci

---

31 January 2007

Page

77

of

78

Table Definition

Container :

LTrack

Version :

Table Name : ORG_UNIT

Alias :

ORG_UNIT

Display Title : Org Unit

Description :

Represents the Mof Org Unit Table. Not all fields included in the model, though they will exist in the MOF database environments.

User/Help Text :

Represents the Mof Org Unit Table. Not all fields included in the model, though they will exist in the MOF database environments.

Volumes

Start Rows :

0

End Rows :

0

Storage

Index-organized ?

No

Column Summary

Col.Seq.

Column

Nulls ?

Type

1

ORG_UNIT_NO

NOT NULL

NUMBER (10)

2

ORG_UNIT_NAME

NOT NULL

VARCHAR2 (100)

Primary Key

Name

Column

ORG_UNIT_PK

ORG_UNIT_NO

Column Detail

1

ORG_UNIT_NO

Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;

The code identifying a MOF office.

2

ORG_UNIT_NAME

Optional ? :No ; Varchar2 (100) ;() ; ; Uppercase ? :No ;

Oracle Designer Report : cktci

---

	Oracle Designer
	TABLE DEFINITION
		End of Report

---