Supplemental Data Table Request Checklist

Provide the following details for each field requested.

Basic Field Information

Table to be Modified

• SUP (Student Supplemental)
• DSD (District Supplemental)

Field Description

• Label displayed to users on the page

Field Code / Column Name

• Recommended length: 2–4 characters
• Must begin with a letter
• Cannot be ID or PID
• Should not use reserved words (for example: AND, OR, BY)

Data Type

Select the data type that best fits the information being stored:

• Text (varchar or nvarchar)
• Long Text (varchar(MAX) or nvarchar(MAX))
• Whole Number (smallint or int)
• Currency/Decimal (money)
• Date (datetime)
• True/False (bit)

Note: If a visual checkbox is required, a Custom Table may be more appropriate than a Supplemental field.

Field Length (Text Fields Only)

• Maximum number of characters required

Default Value

• Indicate whether a default value is needed
• If applicable, provide the default value

Drop-Down List Requirements

Does the field require a drop-down list?

• Yes
• No

If Yes, provide:

• List of valid values/options
• Corresponding codes (if applicable)

Field Placement

Indicate where the field should appear on the Supplemental page.

• Specify the field(s) that should appear before or after the requested field

Additional Requirements

Field Visibility

• Yes (Visible)
• No (Hidden)

Special Requirements

• Validation rules
• Business rules
• Usage notes

Example

Please complete the checklist for each requested field. This information will allow review of the request and determination of the appropriate Supplemental table configuration.