CASE Studio 2 - HTML Report

CONTRACT.CONTRACT_X1

General info

Table name	CONTRACT
Column names	Contract_No
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

CONTRACT.CONTRACT_X2

General info

Table name	CONTRACT
Column names	Customer, Contract_No
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

CONTRACT_NOTES.CONTRACT_NOTES_X1

General info

Table name	CONTRACT_NOTES
Column names	Contract_No, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

CONTRACT_TAX.CONTRACT_TAX_X1

General info

Table name	CONTRACT_TAX
Column names	Contract_No, Customer, Address_ID, Model_ID, Serial_No, Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

CUST_EQUIPMENT.CUST_EQUIPMENT_X1

General info

Table name	CUST_EQUIPMENT
Column names	Customer, Address_ID, Model_ID, Serial_No
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

CUST_EQUIPMENT.CUST_EQUIPMENT_X2

General info

Table name	CUST_EQUIPMENT
Column names	Tag_ID, Customer, Address_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

CUST_EQUIPMENT.CUST_EQUIPMENT_X3

General info

Table name	CUST_EQUIPMENT
Column names	CONTRACT_NO, Customer, Address_ID, Model_ID, Serial_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

CUST_EQUIPMENT_METERS.EQUIPMENT_METERS_X1

General info

Table name	CUST_EQUIPMENT_METERS
Column names	Customer, Address_ID, Model_ID, Serial_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

CUST_EQUIPMENT_NOTES.CUST_EQUIPMENT_NOTES_X1

General info

Table name	CUST_EQUIPMENT_NOTES
Column names	Customer, Address_ID, Model_ID, Serial_No, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_CONTRACT.HISTORY_CONTRACT_X1

General info

Table name	HISTORY_CONTRACT
Column names	Contract_No, Contract_Seq_No
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_CONTRACT.HISTORY_CONTRACT_X2

General info

Table name	HISTORY_CONTRACT
Column names	Customer, Contract_Seq_No, Contract_No
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_CONTRACT_NOTES.HISTORY_CONTRACT_NOTES_X1

General info

Table name	HISTORY_CONTRACT_NOTES
Column names	Contract_No, Contract_Seq_No, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_CONTRACT_TAX.HISTORY_CONTRACT_TAX_X1

General info

Table name	HISTORY_CONTRACT_TAX
Column names	Contract_No, Contract_Seq_No, Customer, Address_ID, Model_ID, Serial_No, Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_CUST_EQUIPMENT.HISTORY_CUST_EQUIPMENT_X1

General info

Table name	HISTORY_CUST_EQUIPMENT
Column names	Customer, Contract_No, Contract_Seq_No, Address_ID, Model_ID, Serial_No
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_CUST_EQUIPMENT.HISTORY_CUST_EQUIPMENT_X2

General info

Table name	HISTORY_CUST_EQUIPMENT
Column names	Tag_ID, Customer, Address_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_CUST_EQUIPMENT.HISTORY_CUST_EQUIPMENT_X3

General info

Table name	HISTORY_CUST_EQUIPMENT
Column names	Contract_No, Contract_Seq_No, Customer, Address_ID, Model_ID, Serial_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_METER_READINGS.HISTORY_METER_READINGS_X1

General info

Table name	HISTORY_METER_READINGS
Column names	Customer, Address_ID, Model_ID, Serial_No, READING_DATE, SEQ_NO
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WO_ADDL_CHG.HISTORY_WO_ADDL_CHG_X1

General info

Table name	HISTORY_WO_ADDL_CHG
Column names	Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Addl_Chg_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WO_LABOR.HISTORY_WO_LABOR_X1

General info

Table name	HISTORY_WO_LABOR
Column names	Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Lbr_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WO_LABOR_NOTES.HISTORY_WO_LABOR_NOTES_X1

General info

Table name	HISTORY_WO_LABOR_NOTES
Column names	Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Lbr_Seq_No, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WO_NOTES.HISTORY_WO_NOTES_X1

General info

Table name	HISTORY_WO_NOTES
Column names	Work_Order_No, Work_Order_Seq_No, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WO_PARTS.HISTORY_WO_PARTS_X1

General info

Table name	HISTORY_WO_PARTS
Column names	Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Pts_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WO_PARTS_GRID_CELL.HISTORY_WO_PARTS_GRID_CELL_X1

General info

Table name	HISTORY_WO_PARTS_GRID_CELL
Column names	Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Pts_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WO_PARTS_SERIALS.HISTORY_WO_PARTS_SERIALS_X1

General info

Table name	HISTORY_WO_PARTS_SERIALS
Column names	Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Pts_Seq_No, Serial_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WO_PMNT.HISTORY_WO_PMNT_X1

General info

Table name	HISTORY_WO_PMNT
Column names	Work_Order_No, Work_Order_Seq_No, Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WO_TASK.HISTORY_WO_TASK_X1

General info

Table name	HISTORY_WO_TASK
Column names	Work_Order_No, Work_Order_Seq_No, Task_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WO_TASK_NOTES.HISTORY_WO_TASK_NOTES_X1

General info

Table name	HISTORY_WO_TASK_NOTES
Column names	Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WO_TAX.HISTORY_WO_TAX_X1

General info

Table name	HISTORY_WO_TAX
Column names	Work_Order_No, Work_Order_Seq_No, Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WORK_ORDER.HISTORY_WORK_ORDER_X1

General info

Table name	HISTORY_WORK_ORDER
Column names	Work_Order_No, Work_Order_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

HISTORY_WORK_ORDER.HISTORY_WORK_ORDER_X2

General info

Table name	HISTORY_WORK_ORDER
Column names	Customer, Work_Order_No, Work_Order_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

METER_READINGS.METER_READINGS_X1

General info

Table name	METER_READINGS
Column names	Customer, Address_ID, Model_ID, Serial_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

PREDEF_JOB.PREDEF_JOB_X1

General info

Table name	PREDEF_JOB
Column names	Job_ID
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

PREDEF_JOB.PREDEF_JOB_X2

General info

Table name	PREDEF_JOB
Column names	Description, Job_ID
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

PREDEF_JOB_ADDL_CHG.JOB_ADDL_CHG_X1

General info

Table name	PREDEF_JOB_ADDL_CHG
Column names	Job_ID, Task_Seq_No, Addl_Chg_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

PREDEF_JOB_LABOR.JOB_LABOR_X1

General info

Table name	PREDEF_JOB_LABOR
Column names	Job_ID, Task_Seq_No, Lbr_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

PREDEF_JOB_LABOR_NOTES.JOB_LABOR_NOTES_X1

General info

Table name	PREDEF_JOB_LABOR_NOTES
Column names	Job_ID, Task_Seq_No, Lbr_Seq_No, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

PREDEF_JOB_NOTES.JOB_NOTES_X1

General info

Table name	PREDEF_JOB_NOTES
Column names	Job_ID, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

PREDEF_JOB_PARTS.JOB_PARTS_X1

General info

Table name	PREDEF_JOB_PARTS
Column names	Job_ID, Task_Seq_No, Pts_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

PREDEF_JOB_TASK.JOB_TASK_X1

General info

Table name	PREDEF_JOB_TASK
Column names	Job_ID, Task_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

PREDEF_JOB_TASK_NOTES.JOB_TASK_NOTES_X1

General info

Table name	PREDEF_JOB_TASK_NOTES
Column names	Job_ID, Task_Seq_No, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

PREDEF_NOTES.PREDEF_NOTE_X1

General info

Table name	PREDEF_NOTES
Column names	Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

SP_USER.SP_USER_X1

General info

Table name	SP_USER
Column names	User_ID
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

SVC_ADDRESS.SVC_ADDRESS_X1

General info

Table name	SVC_ADDRESS
Column names	Customer, Address_ID
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

SVC_ADDRESS.SVC_ADDRESS_X2

General info

Table name	SVC_ADDRESS
Column names	Name
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

SVC_ADDRESS_NOTES.SVC_ADDRESS_NOTES_X1

General info

Table name	SVC_ADDRESS_NOTES
Column names	Customer, Address_ID, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

SVC_TECH.SVC_TECH_X1

General info

Table name	SVC_TECH
Column names	Tech_ID
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

SVC_TECH.SVC_TECH_X2

General info

Table name	SVC_TECH
Column names	Name
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WO_ADDL_CHG.WO_ADDL_CHG_X1

General info

Table name	WO_ADDL_CHG
Column names	Work_Order_No, Task_Seq_No, Addl_Chg_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WO_LABOR.WO_LABOR_X1

General info

Table name	WO_LABOR
Column names	Work_Order_No, Task_Seq_No, Lbr_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WO_LABOR_NOTES.WO_LABOR_NOTES_X1

General info

Table name	WO_LABOR_NOTES
Column names	Work_Order_No, Task_Seq_No, Lbr_Seq_No, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WO_NOTES.WO_NOTES_X1

General info

Table name	WO_NOTES
Column names	Work_Order_No, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WO_PARTS.WO_PARTS_X1

General info

Table name	WO_PARTS
Column names	Work_Order_No, Task_Seq_No, Pts_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WO_PARTS_GRID_CELL.WO_PARTS_GRID_CELL_X1

General info

Table name	WO_PARTS_GRID_CELL
Column names	Work_Order_No, Task_Seq_No, Pts_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WO_PARTS_SERIALS.WO_PARTS_SERIALS_X1

General info

Table name	WO_PARTS_SERIALS
Column names	Work_Order_No, Task_Seq_No, Pts_Seq_No, Serial_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WO_PMNT.WO_PMNT_X1

General info

Table name	WO_PMNT
Column names	Work_Order_No, Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WO_TASK.WO_TASK_X1

General info

Table name	WO_TASK
Column names	Work_Order_No, Task_Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WO_TASK_NOTES.WO_TASK_NOTES_X1

General info

Table name	WO_TASK_NOTES
Column names	Work_Order_No, Task_Seq_No, Note_ID
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WO_TAX.WO_TAX_X1

General info

Table name	WO_TAX
Column names	Work_Order_No, Seq_No
Unique	NO
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WORK_ORDER.WORK_ORDER_X1

General info

Table name	WORK_ORDER
Column names	Work_Order_No
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor

WORK_ORDER.WORK_ORDER_X2

General info

Table name	WORK_ORDER
Column names	Customer, Work_Order_No
Unique	YES
Clustered	NO
Descending	NO

User-defined variables

Name	Value
Pad Index	No
Filegroup for Index
Index Fill factor