REVENUESPLIT_EXT
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| TYPECODE | tinyint | Default = 0 | ||
| APPLICATIONCODE | tinyint | Default = 0 | ||
| OVERRIDEBUSINESSUNITS | bit | Default = 0 | ||
| DATEADDED | datetime | Default = getdate() | ||
| DATECHANGED | datetime | Default = getdate() | ||
| TS | timestamp | |||
| TSLONG | bigint (Computed) | yes | CONVERT(bigint, TS) | |
| APPLICATION | nvarchar(27) (Computed) | yes | CASE [APPLICATIONCODE] WHEN 0 THEN N'Donation' WHEN 1 THEN N'Event registration' WHEN 2 THEN N'Pledge' WHEN 3 THEN N'Recurring gift' WHEN 4 THEN N'Other' WHEN 5 THEN N'Membership' WHEN 6 THEN N'Planned gift' WHEN 7 THEN N'Matching gift' WHEN 8 THEN N'Grant award' WHEN 9 THEN N'Admission' WHEN 10 THEN N'Order' WHEN 11 THEN N'Miscellaneous' WHEN 12 THEN N'Auction purchase' WHEN 13 THEN N'Donor challenge' WHEN 15 THEN N'Event sponsorship' WHEN 16 THEN N'Merchandise' WHEN 17 THEN N'Pending gift' WHEN 18 THEN N'Membership add-on' WHEN 19 THEN N'Membership installment plan' END | |
| TYPE | nvarchar(27) (Computed) | yes | CASE [TYPECODE] WHEN 0 THEN N'Gift' WHEN 1 THEN N'Event registration' WHEN 2 THEN N'Membership' WHEN 3 THEN N'Grant award' WHEN 4 THEN N'Other' WHEN 5 THEN N'Ticket' WHEN 6 THEN N'Fee' WHEN 7 THEN N'Tax' WHEN 8 THEN N'Miscellaneous' WHEN 9 THEN N'Sponsorship' WHEN 10 THEN N'Supply/Equipment Resource' WHEN 11 THEN N'Staffing Resource' WHEN 12 THEN N'Auction purchase' WHEN 13 THEN N'Security deposit' WHEN 14 THEN N'Facility' WHEN 15 THEN N'Event sponsorship' WHEN 16 THEN N'Merchandise' WHEN 17 THEN N'Sponsorship additional gift' WHEN 18 THEN N'Membership add-on' WHEN 19 THEN N'Unearned revenue' WHEN 20 THEN N'Overage' END |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ID | uniqueidentifier | FINANCIALTRANSACTIONLINEITEM.ID | ||
| DESIGNATIONID | uniqueidentifier | yes | DESIGNATION.ID | |
| REVENUESPLITBUSINESSUNITOVERRIDECODEID | uniqueidentifier | yes | REVENUESPLITBUSINESSUNITOVERRIDECODE.ID | |
| ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | ||
| CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_REVENUESPLIT_EXT_DATEADDED | DATEADDED | yes | ||
| IX_REVENUESPLIT_EXT_DATECHANGED | DATECHANGED | |||
| IX_REVENUESPLIT_EXT_DESIGNATIONID | DESIGNATIONID | |||
| IX_REVENUESPLIT_EXT_ID | ID | |||
| IX_REVENUESPLIT_EXT_TYPECODE_APPLICATIONCODE | TYPECODE, APPLICATIONCODE | |||
| PK_REVENUESPLIT_EXT | ID | yes | yes |
Triggers
| Trigger Name | Description |
|---|---|
| TR_REVENUESPLIT_EXT_AUDIT_UPDATE | |
| TR_REVENUESPLIT_EXT_AUDIT_DELETE | |
| TR_REVENUESPLIT_EXT_DELETE |