Users Guide

Reporting and Task Management 77
UserInformationUserName nvarchar 64 Yes The user name.
ExtendedWarrantyStartDate nvarchar 64 Yes The extended warranty start
date.
ExtendedWarrantyEndDate nvarchar 64 Yes The extended warranty end
date.
ExtendedWarrantyCost nvarchar 64 Yes The extended warranty cost.
ExtendedWarrantyProviderName nvarchar 64 Yes The extended warranty provider
name.
OwnershipCode nvarchar 64 Yes The ownership code.
CorporateOwnerName nvarchar 64 Yes The owner name.
HazardousWasteCodeName nvarchar 64 Yes The hazardous waste code
name.
DeploymentDateLength nvarchar 64 Yes The deployment date length.
DeploymentDurationUnitType nvarchar 64 Yes The deployment duration unit
type.
TrainingName nvarchar 64 Yes The training name.
OutsourcingProblemDescription nvarchar 64 Yes The outsourcing problem
description.
OutsourcingServiceFee nvarchar 64 Yes The outsourcing service fee.
OutsourcingSigningAuthority nvarchar 64 Yes The outsourcing signing
authority.
OutsourcingProviderFee nvarchar 64 Yes The outsourcing provider fee.
OutsourcingProviderServiceLevel nvarchar 64 Yes The outsourcing provider
service level.
InsuranceCompanyName nvarchar 64 Yes The insurance company name.
BoxAssetTagName nvarchar 64 Yes The device’s asset tag.
BoxSystemName nvarchar 64 Yes The device’s operating system
name.
BoxCPUSerialNumberName nvarchar 64 Yes The device’s CPU serial
number.
DepreciationDuration nvarchar 64 Yes The depreciation duration.
DepreciationDurationUnitType nvarchar 64 Yes The depreciation duration
units.
Table 5-2. IT Assistant Database Schema (continued)
Column Name Data
Typ e
Data
Size
Nulls
Allowed
Description