Information for the BenevolenceRequest
Columns
Id
(datatype: int) Required Primary Key
FirstName
(datatype: nvarchar(50)) Required Primary Key
LastName
(datatype: nvarchar(50)) Required Primary Key
Email
(datatype: nvarchar(254)) Required Primary Key
RequestedByPersonAliasId
(datatype: int) Required Primary Key
RequestText
(datatype: nvarchar(max)) Required Primary Key
RequestDateTime
(datatype: datetime) Required Primary Key
HomePhoneNumber
(datatype: nvarchar(20)) Required Primary Key
CellPhoneNumber
(datatype: nvarchar(20)) Required Primary Key
WorkPhoneNumber
(datatype: nvarchar(20)) Required Primary Key
CaseWorkerPersonAliasId
(datatype: int) Required Primary Key
GovernmentId
(datatype: nvarchar(100)) Required Primary Key
RequestStatusValueId
(datatype: int) Required Primary Key
ResultSummary
(datatype: nvarchar(max)) Required Primary Key
ConnectionStatusValueId
(datatype: int) Required Primary Key
LocationId
(datatype: int) Required Primary Key
CreatedDateTime
(datatype: datetime) Required Primary Key
ModifiedDateTime
(datatype: datetime) Required Primary Key
CreatedByPersonAliasId
(datatype: int) Required Primary Key
ModifiedByPersonAliasId
(datatype: int) Required Primary Key
Guid
(datatype: uniqueidentifier) Required Primary Key
ForeignKey
(datatype: nvarchar(100)) Required Primary Key
ForeignGuid
(datatype: uniqueidentifier) Required Primary Key
ForeignId
(datatype: int) Required Primary Key
ProvidedNextSteps
(datatype: nvarchar(max)) Required Primary Key
CampusId
(datatype: int) Required Primary Key
RequestDateKey
(datatype: int) Required Primary Key
BenevolenceTypeId
(datatype: int) Required Primary Key