Development of a National Adult Protective Services Data System: Namrs Pilot Final Report (volume 2). Appendix B. Namrs Pilot Database Tables and Columns

09/25/2015

This section lists the Tables, Columns, and Column Attributes for the NAMRS Pilot Database.

B.1. [Core]

[Core].[Announcement]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AnnouncementId Int 4 N Y N Primary key
Title NVarChar (200) 200 N N N  
Body NVarCharMax -1 Y N N  
AnnouncementDate Date 3 N N N  
IsActive Bit 1 N N N  
CreationTime DateTime 8 N N N  
CreationUserId NVarChar (128) 128 Y N N  

 

[Core].[Resource]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ResourceId Int 4 N Y N Primary key
ResourceTypeId Int 4 N N Y Link to ResourceType table
Title NVarChar (200) 200 N N N  
Body NVarCharMax -1 Y N N  
IsFile Bit 1 N N N  
DisplayFilename NVarChar (100) 100 Y N N  
Filename NVarChar (100) 100 Y N N  
FileLength Int 4 Y N N  
FileType NVarChar (100) 100 Y N N  
Ord Int 4 N N N  
IsActive Bit 1 N N N  
CreationTime DateTime 8 N N N  
CreationUserId NVarChar (128) 128 Y N N  

 

[Core].[ResourceType]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ResourceTypeId Int 4 N Y N Primary key
Title NVarChar (200) 200 N N N  
Body NVarChar (1000) 1000 N N N  
Ord Int 4 N N N  
IsActive Bit 1 N N N  
IsVisibleToState Bit 1 N N N  
IsDataExtract Bit 1 N N N  
CreationTime DateTime 8 N N N  
CreationUserId NVarChar (128) 128 Y N N  

 

[Core].[UserProfile]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
UserId NVarChar (128) 128 N Y Y Link to AspNetUsers table
FirstName NVarChar (50) 50 Y N N  
LastName NVarChar (50) 50 Y N N  
Phone NVarChar (50) 50 Y N N  
RegionId Int 4 Y N Y Link to Region table
LastLoginTime DateTime 8 Y N N  
CreationTime DateTime 8 N N N  
CreationUserId NVarChar (128) 128 Y N N  

 

[Core].[ValidationRule]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ValidationRuleId Int 4 N Y N Primary key
Name NVarChar (100) 100 Y N N  
Description NVarChar (4000) 4000 Y N N  
Definition NVarCharMax -1 Y N N  
ElementPathMessage NVarChar (200) 200 Y N N  
ErrorMessage NVarChar (1000) 1000 Y N N  
ValidationRuleStepLuId Int 4 Y N Y Link to ValidationRuleStepLu table
IsCriticalRule Bit 1 N N N  
IsActive Bit 1 N N N  
CreationTime DateTime 8 N N N  
CreationUserId NVarChar (128) 128 Y N N  

 

[Core].[ValidationRuleStepLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ValidationRuleStepLuId Int 4 N Y N Primary key
Name NVarChar (50) 50 Y N N  

B.2. [dbo]

[dbo].[__MigrationHistory]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
MigrationId NVarChar (150) 150 N Y N Primary key
ContextKey NVarChar (300) 300 N Y N Primary key
Model VarBinaryMax -1 N N N  
ProductVersion NVarChar (32) 32 N N N  

 

[dbo].[AspNetRoles]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
Id NVarChar (128) 128 N Y N Primary key
Name NVarChar (256) 256 N N N  

 

[dbo].[AspNetUserClaims]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
Id Int 4 N Y N Primary key
UserId NVarChar (128) 128 N N Y Link to AspNetUsers table
ClaimType NVarCharMax -1 Y N N  
ClaimValue NVarCharMax -1 Y N N  

 

[dbo].[AspNetUserLogins]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
LoginProvider NVarChar (128) 128 N Y N Primary key
ProviderKey NVarChar (128) 128 N Y N Primary key
UserId NVarChar (128) 128 N Y Y Link to AspNetUsers table

 

[dbo].[AspNetUserRoles]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
UserId NVarChar (128) 128 N Y Y Link to AspNetUsers table
RoleId NVarChar (128) 128 N Y Y Link to AspNetRoles table

 

[dbo].[AspNetUsers]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
Id NVarChar (128) 128 N Y N Primary key
Email NVarChar (256) 256 Y N N  
EmailConfirmed Bit 1 N N N  
PasswordHash NVarCharMax -1 Y N N  
SecurityStamp NVarCharMax -1 Y N N  
PhoneNumber NVarCharMax -1 Y N N  
PhoneNumberConfirmed Bit 1 N N N  
TwoFactorEnabled Bit 1 N N N  
LockoutEndDateUtc DateTime 8 Y N N  
LockoutEnabled Bit 1 N N N  
AccessFailedCount Int 4 N N N  
UserName NVarChar (256) 256 N N N  

 

[dbo].[ELMAH_Error]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ErrorId UniqueIdentifier 16 N Y N Primary key
Application NVarChar (60) 60 N N N  
Host NVarChar (50) 50 N N N  
Type NVarChar (100) 100 N N N  
Source NVarChar (60) 60 N N N  
Message NVarChar (500) 500 N N N  
User NVarChar (50) 50 N N N  
StatusCode Int 4 N N N  
TimeUtc DateTime 8 N N N  
Sequence Int 4 N N N  
AllXml NText 16 N N N  

B.3. [Lookup]

[Lookup].[AcceptingReportLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AcceptingReportLuId Int 4 N Y N Primary key
Name VarChar (1000) 1000 N N N  

 

[Lookup].[AgeLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AgeLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[AgencyAddressTypeLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AgencyAddressTypeLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  

 

[Lookup].[AgencyContactRoleLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AgencyContactRoleLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  

 

[Lookup].[AssessmentToolLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AssessmentToolLuId Int 4 N Y N Primary key
Name VarChar (1000) 1000 N N N  

 

[Lookup].[AssociationLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AssociationLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[AttributeStatusLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AttributeStatusLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  

 

[Lookup].[BehaviorHealthLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
BehaviorHealthLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[BenefitLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
BenefitLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[CaseServiceLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
CaseServiceLuId Int 4 N Y N Primary key
Name VarChar (1000) 1000 N N N  

 

[Lookup].[CloseReasonLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
CloseReasonLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[CohabLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
CohabLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[DataSourceLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
DataSourceLuId Int 4 N Y N Primary key
Name VarChar (1000) 1000 N N N  

 

[Lookup].[DecisionLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
DecisionLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[DisabilityLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
DisabilityLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[EmployLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
EmployLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[EngCompLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
EngCompLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[EthnicityLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
EthnicityLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[EvidenceStandardLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
EvidenceStandardLuId Int 4 N Y N Primary key
Name VarChar (1000) 1000 N N N  

 

[Lookup].[GenderIdentityLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
GenderIdentityLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[IncomeLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
IncomeLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[InteragencyLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
InteragencyLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[KinshipLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
KinshipLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[LegalRemedyLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
LegalRemedyLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[LivingSetLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
LivingSetLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[MaltreatmentTypeLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
MaltreatmentTypeLuId Int 4 N Y N Primary key
Name VarChar (1000) 1000 N N N  

 

[Lookup].[MaltxSettingLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
MaltxSettingLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[MaritalLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
MaritalLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[MtxDispositionLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
MtxDispositionLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[PreviousReportLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
PreviousReportLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[PrimLangLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
PrimLangLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[RaceLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
RaceLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[ReportSourceLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ReportSourceLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[SchoolingLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
SchoolingLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[ServiceLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ServiceLuId Int 4 N Y N Primary key
Name VarChar (1000) 1000 N N N  

 

[Lookup].[SexOrientLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
SexOrientLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[UsStateLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
UsStateLuId Char (2) 2 N Y N Primary key
Name NVarChar (100) 100 N N N  

 

[Lookup].[VeteranLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
VeteranLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  
Description NVarChar (1000) 1000 Y N N  

 

[Lookup].[WorkflowStatusLu]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
WorkflowStatusLuId Int 4 N Y N Primary key
Name NVarChar (100) 100 N N N  

B.4. [Namrs]

[Namrs].[Agency]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AgencyId Int 4 N Y N Primary key
FiscalYear Int 4 N N Y Link to ReportingPeriod table
RegionId Int 4 N N Y Link to Region table
WorkflowStatusLuId Int 4 N N Y Link to WorkflowStatusLu table
AgencyName1 NVarChar (100) 100 N N N  
AgencyName2 NVarChar (100) 100 Y N N  
DataSourceLuId Int 4 Y N Y Link to DataSourceLu table
DataSourceComment NVarCharMax -1 Y N N  
FteBudgetedInvestigator Int 4 Y N N  
FteBudgetedSupervisor Int 4 Y N N  
FteFilledInvestigator Int 4 Y N N  
FteFilledSupervisor Int 4 Y N N  
FteComment NVarCharMax -1 Y N N  
AcceptingReportLuId Int 4 Y N Y Link to AcceptingReportLu table
AcceptingReportComment NVarCharMax -1 Y N N  
ReportCountNotAccepted Int 4 Y N N  
ReportCountResolved Int 4 Y N N  
ReportCountAccepted Int 4 Y N N  
ReportCountComment NVarCharMax -1 Y N N  
EvidenceStandardLuId Int 4 Y N Y Link to EvidenceStandardLu table
EvidenceStandardComment NVarCharMax -1 Y N N  
CompletionTime Int 4 Y N N  
CompletionComment NVarCharMax -1 Y N N  
AssessmentToolLuId Int 4 Y N Y Link to AssessmentToolLu table
AssessmentComment NVarCharMax -1 Y N N  
ServiceGapsComment NVarCharMax -1 Y N N  
MaltreatmentTypesComment NVarCharMax -1 Y N N  
CreationTime DateTime 8 N N N  
CreationUserId NVarChar (128) 128 Y N N  

 

[Namrs].[AgencyAddress]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AgencyAddressId Int 4 N Y N Primary key
AgencyId Int 4 N N Y Link to Agency table
AgencyAddressTypeLuId Int 4 N N Y Link to AgencyAddressTypeLu table
Street1 NVarChar (100) 100 Y N N  
Street2 NVarChar (100) 100 Y N N  
City NVarChar (100) 100 Y N N  
USStateLuId Char (2) 2 Y N Y Link to UsStateLu table
Zip NVarChar (10) 10 Y N N  

 

[Namrs].[AgencyContact]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AgencyContactId Int 4 N Y N Primary key
AgencyId Int 4 N N Y Link to Agency table
Name NVarChar (100) 100 Y N N  
Title NVarChar (100) 100 Y N N  
Email NVarChar (100) 100 Y N N  
Phone NVarChar (50) 50 Y N N  
AgencyContactRoleLuId Int 4 N N Y Link to AgencyContactRoleLu table

 

[Namrs].[AgencyMaltreatmentType]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AgencyId Int 4 N Y Y Link to Agency table
MaltreatmentTypeLuId Int 4 N Y Y Link to MaltreatmentTypeLu table

 

[Namrs].[AgencyServiceGap]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
AgencyId Int 4 N Y Y Link to Agency table
ServiceLuId Int 4 N Y Y Link to ServiceLu table

 

[Namrs].[CaseBasicCount]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
CaseBasicCountId Int 4 N Y N Primary key
CaseDataSetId Int 4 Y N Y Link to CaseDataSet table
UniqueInvestigationCnt Int 4 Y N N  
UniqueClientCnt Int 4 Y N N  
UniqueFacilityCnt Int 4 Y N N  
UniquePerpCnt Int 4 Y N N  
AllClientCnt Int 4 Y N N  
AllPerpCnt Int 4 Y N N  
AllMtxCnt Int 4 Y N N  
AllRelCnt Int 4 Y N N  

 

[Namrs].[CaseBasicCountBool]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
CaseBasicCountBoolId Int 4 N Y N Primary key
CaseBasicCountId Int 4 N N Y Link to CaseBasicCount table
BoolTypeNum Int 4 N N N  
FieldNum Int 4 N N N  
LookupId Int 4 N N N  
IsUsed Bit 1 N N N  

 

[Namrs].[CaseBasicCountDist]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
CaseBasicCountDistId Int 4 N Y N Primary key
CaseBasicCountId Int 4 N N Y Link to CaseBasicCount table
DistributionTypeNum Int 4 N N N  
FieldNum Int 4 Y N N  
Cnt0 Int 4 Y N N  
Cnt1 Int 4 Y N N  
Cnt2 Int 4 Y N N  
Cnt3 Int 4 Y N N  
Cnt4 Int 4 Y N N  

 

[Namrs].[CaseBasicCountFld]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
CaseBasicCountFldId Int 4 N Y N Primary key
CaseBasicCountId Int 4 N N Y Link to CaseBasicCount table
FieldTypeNum Int 4 N N N  
FieldNum Int 4 N N N  
Cnt Int 4 N N N  

 

[Namrs].[CaseDataSet]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
CaseDataSetId Int 4 N Y N Primary key
FiscalYear Int 4 N N Y Link to ReportingPeriod table
RegionId Int 4 N N Y Link to Region table
WorkflowStatusLuId Int 4 N N Y Link to WorkflowStatusLu table
XmlFilename NVarChar (100) 100 N N N  
CreationTime DateTime 8 N N N  
CreationUserId NVarChar (128) 128 Y N N  

 

[Namrs].[CaseStatistic]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
CaseStatisticId Int 4 N Y N Primary key
CaseDataSetId Int 4 Y N Y Link to CaseDataSet table
InvestigationCountStart Int 4 Y N N  
InvestigationCountFinal Int 4 Y N N  
ClientCountStart Int 4 Y N N  
ClientCountFinal Int 4 Y N N  
PerpetratorCountStart Int 4 Y N N  
PerpetratorCountFinal Int 4 Y N N  
MaltreatmentCountStart Int 4 Y N N  
MaltreatmentCountFinal Int 4 Y N N  
RelationshipCountStart Int 4 Y N N  
RelationshipCountFinal Int 4 Y N N  

 

[Namrs].[Client]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y N Primary key
InvestigationId Int 4 N N Y Link to Investigation table
ClientCode NVarChar (32) 32 N N N  
FacilityCode NVarChar (15) 15 Y N N  
FacilityCodeStLuId Int 4 N N Y Link to AttributeStatusLu table
ClientFipsId Char (5) 5 Y N Y Link to FIPS table
ClientFipsStLuId Int 4 N N Y Link to AttributeStatusLu table
CloseReasonLuId Int 4 Y N Y Link to CloseReasonLu table
CloseReasonStLuId Int 4 N N Y Link to AttributeStatusLu table
AgeLuId Int 4 Y N Y Link to AgeLu table
AgeStLuId Int 4 N N Y Link to AttributeStatusLu table
GenderIdentityLuId Int 4 Y N Y Link to GenderIdentityLu table
GenderIdentityStLuId Int 4 N N Y Link to AttributeStatusLu table
SexOrientLuId Int 4 Y N Y Link to SexOrientLu table
SexOrientStLuId Int 4 N N Y Link to AttributeStatusLu table
EngCompLuId Int 4 Y N Y Link to EngCompLu table
EngCompStLuId Int 4 N N Y Link to AttributeStatusLu table
PrimLangLuId Int 4 Y N Y Link to PrimLangLu table
PrimLangStLuId Int 4 N N Y Link to AttributeStatusLu table
MaritalLuId Int 4 Y N Y Link to MaritalLu table
MaritalStLuId Int 4 N N Y Link to AttributeStatusLu table
SchoolingLuId Int 4 Y N Y Link to SchoolingLu table
SchoolingStLuId Int 4 N N Y Link to AttributeStatusLu table
EmployLuId Int 4 Y N Y Link to EmployLu table
EmployStLuId Int 4 N N Y Link to AttributeStatusLu table
IncomeLuId Int 4 Y N Y Link to IncomeLu table
IncomeStLuId Int 4 N N Y Link to AttributeStatusLu table
VeteranLuId Int 4 Y N Y Link to VeteranLu table
VeteranStLuId Int 4 N N Y Link to AttributeStatusLu table
AdlScore Int 4 Y N N  
AdlScoreStLuId Int 4 N N Y Link to AttributeStatusLu table
IadlScore Int 4 Y N N  
IadlScoreStLuId Int 4 N N Y Link to AttributeStatusLu table
LivingSetStartLuId Int 4 Y N Y Link to LivingSetLu table
LivingSetStartStLuId Int 4 N N Y Link to AttributeStatusLu table
LivingSetCloseLuId Int 4 Y N Y Link to LivingSetLu table
LivingSetCloseStLuId Int 4 N N Y Link to AttributeStatusLu table
PreviousReportLuId Int 4 Y N Y Link to PreviousReportLu table
PreviousReportStLuId Int 4 N N Y Link to AttributeStatusLu table
MaltxSettingLuId Int 4 Y N Y Link to MaltxSettingLu table
MaltxSettingStLuId Int 4 N N Y Link to AttributeStatusLu table
RaceStLuId Int 4 N N Y Link to AttributeStatusLu table
EthnicityStLuId Int 4 N N N  
BenefitStLuId Int 4 N N Y Link to AttributeStatusLu table
DisabilityStLuId Int 4 N N Y Link to AttributeStatusLu table
BhScreeningStLuId Int 4 N N Y Link to AttributeStatusLu table
BhDiagnosisStLuId Int 4 N N Y Link to AttributeStatusLu table
DecisionStartStLuId Int 4 N N Y Link to AttributeStatusLu table
DecisionCloseStLuId Int 4 N N Y Link to AttributeStatusLu table
InterAgencyStLuId Int 4 N N Y Link to AttributeStatusLu table
ServiceStartStLuId Int 4 N N Y Link to AttributeStatusLu table
ServiceCloseStLuId Int 4 N N Y Link to AttributeStatusLu table
ServiceApsStLuId Int 4 N N Y Link to AttributeStatusLu table
ServiceReferredStLuId Int 4 N N Y Link to AttributeStatusLu table

 

[Namrs].[ClientBenefit]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
BenefitLuId Int 4 N Y Y Link to BenefitLu table

 

[Namrs].[ClientBhDiagnosis]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
BhDiagnosisLuId Int 4 N Y Y Link to BehaviorHealthLu table

 

[Namrs].[ClientBhScreening]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
BehaviorHealthLuId Int 4 N Y Y Link to BehaviorHealthLu table

 

[Namrs].[ClientDecisionClose]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
DecisionLuId Int 4 N Y Y Link to DecisionLu table

 

[Namrs].[ClientDecisionStart]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
DecisionLuId Int 4 N Y Y Link to DecisionLu table

 

[Namrs].[ClientDisability]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
DisabilityLuId Int 4 N Y Y Link to DisabilityLu table

 

[Namrs].[ClientEthnicity]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
EthnicityId Int 4 N Y Y Link to EthnicityLu table

 

Namrs].[ClientInteragency]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
InteragencyLuId Int 4 N Y Y Link to InteragencyLu table

 

[Namrs].[ClientRace]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
RaceLuId Int 4 N Y Y Link to RaceLu table

 

[Namrs].[ClientServiceAps]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
ServiceLuId Int 4 N Y Y Link to CaseServiceLu table

 

[Namrs].[ClientServiceClose]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
ServiceLuId Int 4 N Y Y Link to CaseServiceLu table

 

[Namrs].[ClientServiceReferred]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
ServiceLuId Int 4 N Y Y Link to CaseServiceLu table

 

[Namrs].[ClientServiceStart]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
ClientId Int 4 N Y Y Link to Client table
ServiceLuId Int 4 N Y Y Link to CaseServiceLu table

 

[Namrs].[Fips]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
FipsId Char (5) 5 N Y N Primary key
StateFips Char (2) 2 N N N  
CountyFips Char (3) 3 N N N  
UsStateLuId Char (2) 2 N N Y Link to UsStateLu table
CountyName NVarChar (100) 100 N N N  

 

[Namrs].[Investigation]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
InvestigationId Int 4 N Y N Primary key
CaseDataSetId Int 4 N N Y Link to CaseDataSet table
InvestigationCode NVarChar (32) 32 N N N  
ReportDate Date 3 Y N N  
ReportDateStLuId Int 4 N N N  
ReportSourceLuId Int 4 Y N Y Link to ReportSourceLu table
ReportSourceStLuId Int 4 N N Y Link to AttributeStatusLu table
AgencyFipsId Char (5) 5 Y N Y Link to FIPS table
AgencyFipsStLuId Int 4 N N Y Link to AttributeStatusLu table
StartDate Date 3 Y N N  
StartDateStLuId Int 4 N N Y Link to AttributeStatusLu table
DispositionDate Date 3 Y N N  
DispositionDateStLuId Int 4 N N Y Link to AttributeStatusLu table
CaseClosureDate Date 3 N N N  

 

[Namrs].[KeyIndicatorSet]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
KeyIndicatorSetId Int 4 N Y N Primary key
FiscalYear Int 4 N N Y Link to ReportingPeriod table
RegionId Int 4 N N Y Link to Region table
WorkflowStatusLuId Int 4 N N Y Link to WorkflowStatusLu table
IsCalculated Bit 1 N N N  
ClientInv Int 4 Y N N  
ClientInvComment NVarCharMax -1 Y N N  
ClientInteragency Int 4 Y N N  
ClientInteragencyComment NVarCharMax -1 Y N N  
ClientClosureInvComplete Int 4 Y N N  
ClientClosureProtComplete Int 4 Y N N  
ClientClosureRefused Int 4 Y N N  
ClientClosureIncomplete Int 4 Y N N  
ClientClosureDied Int 4 Y N N  
ClientClosureOther Int 4 Y N N  
ClientClosureUnknown Int 4 Y N N  
ClientClosureComment NVarCharMax -1 Y N N  
VictimMultMalt Int 4 Y N N  
VictimMultMaltComment NVarCharMax -1 Y N N  
VictimAge18 Int 4 Y N N  
VictimAge30 Int 4 Y N N  
VictimAge40 Int 4 Y N N  
VictimAge50 Int 4 Y N N  
VictimAge60 Int 4 Y N N  
VictimAge70 Int 4 Y N N  
VictimAge75 Int 4 Y N N  
VictimAge85 Int 4 Y N N  
VictimAgeUnknown Int 4 Y N N  
VictimAgeComment NVarCharMax -1 Y N N  
VictimRaceAian Int 4 Y N N  
VictimRaceAsian Int 4 Y N N  
VictimRaceBlackAa Int 4 Y N N  
VictimRaceHawaiianPi Int 4 Y N N  
VictimRaceWhite Int 4 Y N N  
VictimRaceMultiRacial Int 4 Y N N  
VictimRaceUnknown Int 4 Y N N  
VictimRaceComment NVarCharMax -1 Y N N  
VictimEthnicityHispanic Int 4 Y N N  
VictimEthnicityNotHispanic Int 4 Y N N  
VictimEthnicityUnknown Int 4 Y N N  
VictimEthnicityComment NVarCharMax -1 Y N N  
VictimGenderMale Int 4 Y N N  
VictimGenderFemale Int 4 Y N N  
VictimGenderTransgender Int 4 Y N N  
VictimGenderUnknown Int 4 Y N N  
VictimGenderComment NVarCharMax -1 Y N N  
VictimWithBenefit Int 4 Y N N  
VictimWithBenefitComment NVarCharMax -1 Y N N  
VictimWithDisability Int 4 Y N N  
VictimWithDisabilityComment NVarCharMax -1 Y N N  
VictimWithScrnBehavior Int 4 Y N N  
VictimWithScrnBehaviorComment NVarCharMax -1 Y N N  
VictimMaltAbandon Int 4 Y N N  
VictimMaltEmotAbuse Int 4 Y N N  
VictimMaltFinExpl Int 4 Y N N  
VictimMaltNeglect Int 4 Y N N  
VictimMaltPhysAbuse Int 4 Y N N  
VictimMaltSexAbuse Int 4 Y N N  
VictimMaltSuspDeath Int 4 Y N N  
VictimMaltSelfNeglect Int 4 Y N N  
VictimMaltOther Int 4 Y N N  
VictimMaltUnknown Int 4 Y N N  
VictimMaltComment NVarCharMax -1 Y N N  
VictimWithGuardOrConv Int 4 Y N N  
VictimWithGuardOrConvComment NVarCharMax -1 Y N N  
VictimWithSvcAps Int 4 Y N N  
VictimWithSvcApsComment NVarCharMax -1 Y N N  
PerpAge18 Int 4 Y N N  
PerpAge30 Int 4 Y N N  
PerpAge40 Int 4 Y N N  
PerpAge50 Int 4 Y N N  
PerpAge60 Int 4 Y N N  
PerpAge70 Int 4 Y N N  
PerpAge75 Int 4 Y N N  
PerpAge85 Int 4 Y N N  
PerpAgeUnknown Int 4 Y N N  
PerpAgeComment NVarCharMax -1 Y N N  
PerpGenderMale Int 4 Y N N  
PerpGenderFemale Int 4 Y N N  
PerpGenderTransgender Int 4 Y N N  
PerpGenderUnknown Int 4 Y N N  
PerpGenderComment NVarCharMax -1 Y N N  
PerpWithKinship Int 4 Y N N  
PerpWithKinshipComment NVarCharMax -1 Y N N  
PerpWithAssoc Int 4 Y N N  
PerpWithAssocComment NVarCharMax -1 Y N N  
PerpWithLegal Int 4 Y N N  
PerpWithLegalComment NVarCharMax -1 Y N N  
CreationTime DateTime 8 N N N  
CreationUserId NVarChar (128) 128 Y N N  

 

[Namrs].[Malperp]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
MaltreatmentId Int 4 N Y Y Link to Maltreatment table
PerpetratorId Int 4 N Y Y Link to Perpetrator table

 

[Namrs].[Maltreatment]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
MaltreatmentId Int 4 N Y N Primary key
ClientId Int 4 N N Y Link to Client table
MaltreatmentTypeLuId Int 4 Y N Y Link to MaltreatmentTypeLu table
MtxDispositionLuId Int 4 Y N Y Link to MtxDispositionLu table

 

[Namrs].[PerpBhDiagnosis]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
PerpetratorId Int 4 N Y Y Link to Perpetrator table
BehaviorHealthLuId Int 4 N Y Y Link to BehaviorHealthLu table

 

[Namrs].[PerpBhScreening]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
PerpetratorId Int 4 N Y Y Link to Perpetrator table
BehaviorHealthLuId Int 4 N Y Y Link to BehaviorHealthLu table

 

[Namrs].[PerpDisability]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
PerpetratorId Int 4 N Y Y Link to Perpetrator table
DisabilityLuId Int 4 N Y Y Link to DisabilityLu table

 

[Namrs].[PerpEthnicity]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
PerpetratorId Int 4 N Y Y Link to Perpetrator table
EthnicityId Int 4 N Y Y Link to EthnicityLu table

 

[Namrs].[Perpetrator]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
PerpetratorId Int 4 N Y N Primary key
InvestigationId Int 4 N N Y Link to Investigation table
PerpetratorCode NVarChar (32) 32 Y N N  
AgeLuId Int 4 Y N Y Link to AgeLu table
AgeStLuId Int 4 N N Y Link to AttributeStatusLu table
GenderIdentityLuId Int 4 Y N Y Link to GenderIdentityLu table
GenderIdentityStLuId Int 4 N N Y Link to AttributeStatusLu table
EthnicityStLuId Int 4 N N Y Link to AttributeStatusLu table
DisabilityStLuId Int 4 N N Y Link to AttributeStatusLu table
BhScreeningStLuId Int 4 N N Y Link to AttributeStatusLu table
BhDiagnosisStLuId Int 4 N N Y Link to AttributeStatusLu table
RaceStLuId Int 4 N N N  

 

[Namrs].[PerpRace]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
PerpetratorId Int 4 N Y Y Link to Perpetrator table
RaceLuId Int 4 N Y Y Link to RaceLu table

 

[Namrs].[Region]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
RegionId Int 4 N Y N Primary key
IsState Bit 1 N N N  
IsAian Bit 1 N N N  
IsActive Bit 1 N N N  
ShortName NVarChar (100) 100 N N N  
LongName NVarChar (500) 500 N N N  

 

[Namrs].[Relationship]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
RelationshipId Int 4 N Y N Primary key
PerpetratorId Int 4 N N Y Link to Perpetrator table
ClientId Int 4 N N Y Link to Client table
CohabStartLuId Int 4 Y N Y Link to CohabLu table
CohabStartStLuId Int 4 N N Y Link to AttributeStatusLu table
CohabCloseLuId Int 4 Y N Y Link to CohabLu table
CohabCloseStLuId Int 4 N N Y Link to AttributeStatusLu table
KinshipLuId Int 4 Y N Y Link to KinshipLu table
KinshipStLuId Int 4 N N Y Link to AttributeStatusLu table
PerpAssocStartLuId Int 4 Y N Y Link to AssociationLu table
PerpAssocStartStLuId Int 4 N N Y Link to AttributeStatusLu table
PerpAssocCloseLuId Int 4 Y N Y Link to AssociationLu table
PerpAssocCloseStLuId Int 4 N N Y Link to AttributeStatusLu table
PerpDecisionStartStLuId Int 4 N N Y Link to AttributeStatusLu table
PerpDecisionCloseStLuId Int 4 N N Y Link to AttributeStatusLu table
PerpLegalRemedyStLuId Int 4 N N Y Link to AttributeStatusLu table

 

[Namrs].[RelPerpDecisionClose]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
RelationshipId Int 4 N Y Y Link to Relationship table
DecisionLuId Int 4 N Y Y Link to DecisionLu table

 

[Namrs].[RelPerpDecisionStart]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
RelationshipId Int 4 N Y Y Link to Relationship table
DecisionLuId Int 4 N Y Y Link to DecisionLu table

 

[Namrs].[RelPerpLegalRemedy]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
RelationshipId Int 4 N Y Y Link to Relationship table
LegalRemedyLuId Int 4 N Y Y Link to LegalRemedyLu table

 

[Namrs].[ReportingPeriod]:
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description
FiscalYear Int 4 N Y N Primary key
Comments NVarCharMax -1 Y N N  
IsActive Bit 1 N N N  
CreationTime DateTime 8 N N N  
CreationUserId NVarChar (128) 128 Y N N  

View full report

Preview
Download

"NAMRSpilot-V2.pdf" (pdf, 1.83Mb)

Note: Documents in PDF format require the Adobe Acrobat Reader®. If you experience problems with PDF documents, please download the latest version of the Reader®