| FILTERPROGRAM |
bit |
|
Default = 0 |
Flag for if status part filters by program for display |
| SELECTEDPROGRAMS |
xml |
yes |
|
Programs which allow children to be displayed in the CMS |
| NOTESAVAILABLILITYCODE |
tinyint |
|
Default = 0 |
Flag for filtering of the notes |
| NOTESAVAILABLILITY |
nvarchar(8) (Computed) |
yes |
CASE [NOTESAVAILABLILITYCODE] WHEN 0 THEN N'All' WHEN 1 THEN N'Filtered' WHEN 2 THEN N'None' END |
Provides a translation for the 'NOTESAVAILABLILITYCODE' field. |
| NOTESCODESLIST |
xml |
yes |
|
IDs of note types to be displayed on the status part |
| ATTACHMENTSAVAILABILITYCODE |
tinyint |
|
Default = 0 |
Flag for filtering of attachments |
| ATTACHMENTSAVAILABILITY |
nvarchar(8) (Computed) |
yes |
CASE [ATTACHMENTSAVAILABILITYCODE] WHEN 0 THEN N'All' WHEN 1 THEN N'Filtered' WHEN 2 THEN N'None' END |
Provides a translation for the 'ATTACHMENTSAVAILABILITYCODE' field. |
| ATTACHMENTCODESLIST |
xml |
yes |
|
Ids of attachment types to be displayed on the status part |
| MEDIALINKSAVAILABILITYCODE |
tinyint |
|
Default = 0 |
Flag for filtering of media links |
| MEDIALINKSAVAILABILITY |
nvarchar(8) (Computed) |
yes |
CASE [MEDIALINKSAVAILABILITYCODE] WHEN 0 THEN N'All' WHEN 1 THEN N'Filtered' WHEN 2 THEN N'None' END |
Provides a translation for the 'MEDIALINKSAVAILABILITYCODE' field. |
| MEDIALINKCODESLIST |
xml |
yes |
|
Ids of media link types to be displayed on the status part |
| EMAILENABLED |
bit |
|
Default = 0 |
Flag for if emailing opportunities is allowed form this part |
| EMAILCATEGORYID |
uniqueidentifier |
yes |
|
Email category Id |
| EMAILSUBCATEGORYID |
uniqueidentifier |
yes |
|
Email subcategory Id |
| DEFAULTEMAILCATEGORYID |
uniqueidentifier |
yes |
|
Default email category Id |
| DEFAULTEMAILSUBCATEGORYID |
uniqueidentifier |
yes |
|
Default email subcategory Id |
| DEFAULTEMAILADDRESS |
UDT_EMAILADDRESS |
|
Default = '' |
Default email address for emails sent from a sponsor |
| EMAILTYPECODE |
uniqueidentifier |
yes |
|
Typecode for sponsor emails |
| EMAILFIELDLIMIT |
int |
|
Default = 0 |
Character limit for sponsor emails |
| EMAILTEMPLATESLIST |
xml |
yes |
|
Email template Ids specifying which templates will appear on the status part |
| EMAILPROGRAMLIST |
xml |
yes |
|
List of Ids of programs which allow email |
| OUTPUTFIELDLIST |
xml |
yes |
|
List of the integer mergefield Ids in the html content |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| CHILDHTMLCONTENT |
nvarchar(max) |
|
Default = '' |
HTML Content for displaying child sponsorship information on the status page |
| PROJECTHTMLCONTENT |
nvarchar(max) |
|
Default = '' |
HTML content for displaying project sponsorship information on the status page |
| PAYMENTPARTPAGE |
int |
|
Default = 0 |
|
| SPONSORSHIPLISTFORMATCODE |
tinyint |
|
Default = 0 |
|
| SPONSORSHIPLISTFORMAT |
nvarchar(21) (Computed) |
yes |
CASE [SPONSORSHIPLISTFORMATCODE] WHEN 0 THEN N'Child full name' WHEN 1 THEN N'Child first name only' END |
|
| SUPPORTSCHECKOUTONLY |
bit |
|
Default = 0 |
|