This is an old revision of the document!
txConnect Admin > Administrator Options > Settings > Forms Management > Form Fields
This page allows you to set options for the fields that will be used for student enrollment, registration, and data update forms. Examples of fields are first name, last name, middle name, and birth date.
The list of Available Fields is added automatically. For each field, you indicate if the field is visible and add any instructions. By default, all fields are visible and no action is required; however you can hide a field globally and/or add default instructions as needed.
Some districts allow you to select document storage (DOCSTOR_) fields which allow parents to upload supporting registration forms (immunization record, birth certificate, etc.).
NOTES:
Field Name | Default Friendly Name - English | Default Friendly Name - Spanish |
---|---|---|
ADDR_APT_NBR | Apartment Number (Mailing) | Número de departamento (postal) |
ADDR_CITY | City (Mailing) | Ciudad (postal) |
ADDR_STATE | State (Mailing) | Estado (postal) |
ADDR_STR_DIR | Street Direction (Mailing) | Calle y número (postal) |
ADDR_STR_NAME | Street Name (Mailing) | Nombre de la calle (postal) |
ADDR_STR_NBR | Street Number (Mailing) | Número(postal) |
ADDR_ZIP | Zip (Mailing) | Código postal (postal) |
ADDR_ZIP4 | Zip4 (Mailing) | Código postal4 (postal) |
APT_NBR | Contact: Apartment Number | Contacto: Número de departamento |
APT_NBR_PHYS_ADDR | Apartment Number (Physical) | Número de departamento (físico) |
CAMPUS_CD_PRV | Previous Campus | Campus anterior |
CELL_PHONE | Contact: Cell Phone | Contacto: Teléfono celular |
CITY | Contact: City | Contacto: Ciudad |
CITY_NAME_PHYS_ADDR | City (Physical) | Ciudad (física) |
DL_NBR | Contact: Driver License Number | Contacto: Número de licencia de conducir |
DL_ST | Contact: Driver License State | Contacto: Estado de licencia de conducir |
DOB (SR_PARENT) | Contact: Date of Birth | Contacto: Fecha de nacimiento |
DOB (SR_STU_DEMO) | Date of Birth | Fecha de nacimiento |
DOCSTOR_ACCEPTABLEUSEPOLICY | Student Acceptable Use Policy | Política de uso aceptable para estudiantes |
DOCSTOR_BC | Birth Certificate Document | Documento de certificado de nacimiento |
DOCSTOR_CAPP | Chemical Abuse Participation Form | Formulario de participación en abuso de sustancias |
DOCSTOR_DIRECTORY | Directory Form | Formulario del directorio |
DOCSTOR_DISTRICTHANDBOOK | District Handbook | Manual del distrito |
DOCSTOR_DL | Driver License Document | Documento de licencia de conducir |
DOCSTOR_EMP_SURVEY | Employee Survey Form | Formulario de encuesta para empleados |
DOCSTOR_ETHRACEQUESTIONNAIRE | Ethnicity and Race Data Questionnaire | Cuestionario de datos de origen étnico y raza |
DOCSTOR_FAMILYSURVEY | Family Survey | Encuesta familiar |
DOCSTOR_FOODALERGY* | Food and Allergy Form | Formulario de alimentos y alergias |
DOCSTOR_FREELUNCH | Free Lunch (NSLP) | Almuerzo gratis (NSLP) |
DOCSTOR_HISTSCHOOLATTENDANCE | History of School Attendance | Historial de asistencia escolar |
DOCSTOR_HOMELANGSURVEY | Home Language Survey | Encuesta sobre idioma del hogar |
DOCSTOR_IDENTITYVERIF | Identity Verification | Verificación de identidad |
DOCSTOR_IMM* | Immunizations Document | Documento de inmunizaciones |
DOCSTOR_MCVINTO | McKinney-Vento Form | Formulario McKinney-Vento |
DOCSTOR_MILCONNECTEDSTUDATA | Military Connected Student Data | Datos de alumnos con conexiones militares |
DOCSTOR_POR | Proof of Residency Document | Documento de comprobante de residencia |
DOCSTOR_REGISTRATIONPACKET | Registration Packet | Paquete de registro |
DOCSTOR_RELEASEOFINFO | Release of Information | Divulgación de información |
DOCSTOR_SSC | Social Security Card | Tarjeta de seguro Social |
DOCSTOR_STATEMENTSPECED | Statement of Special Education Services | Declaración de servicios de educación especial |
DOCSTOR_STUDENTMEDIARELEASE | Student Media Release | Divulgación de información del alumno a medios de comunicación |
EMAIL (SR_PARENT) | Contact: Email | Contacto: Correo electrónico |
EMAIL (SR_STU_DEMO) | Student Email Address | Dirección de correo electrónico del estudiante |
EMERGENCY_FLAG | Contact: Emergency Contact | Contacto: Contacto de emergencia |
ETHN_HISPANIC | Hispanic/Latino | |
FOOD_ALLERGY | Food Allergy | Food Allergy |
GEN | Contact: Generation | Contacto: Generación |
HOME_LANG_CD | Pri Language Spoken at Home | |
LANG_CD | Contact: Language | Contacto: Idioma |
LANG_PRI | Pri Language Spoken by Student | |
MIGRANT_FLAG | Contact: Migrant | Contacto: Migrante |
MIL_BRANCH | Contact: Branch of Service | Contacto: Rama del servicio |
MIL_IND | Military Connection | |
MIL_RANK | Contact: Rank | Contacto: Rango |
MOCK_FOSTER_CARE | Foster care | Cuidado tutelar |
MOCK_HOMELESS | Is student homeless? | ¿Es un estudiante sin hogar? |
MOCK_LAST_YEAR_GRADE | Last year's grade | Grado del año pasado |
MOCK_PREV_IN_504 | 504 Program | Programa 504 |
MOCK_PREV_IN_ALT_PROG | Alternative Program | Programa alternativo |
MOCK_PREV_IN_ARMED_FORCES | Family members serving our country | Miembros de la familia que sirven a nuestro país |
MOCK_PREV_IN_BIL_ESL | Bilingual/ESL | Bilingüe/ESL |
MOCK_PREV_IN_DAEP_JJAEP | DAEP/JJAEP | DAEP/JJAEP |
MOCK_PREV_IN_DYSLEXIA | Dyslexia | Dislexia |
MOCK_PREV_IN_GT | Was student previously in GT? | ¿El estudiante estuvo antes en GT? |
MOCK_PREV_IN_IMMIGRANT | Immigrant Program | Programa para inmigrantes |
MOCK_PREV_IN_MIGRANT | Migrant Program | Programa para migrantes |
MOCK_PREV_IN_OTHER_PROG | Other Programs | Otros programas |
MOCK_PREV_IN_SOCIAL_SERVICES | Social Services | Servicios sociales |
MOCK_PREV_IN_SPECIAL_ED | Special Education | Educación especial |
MOCK_PREV_IN_SPECIAL_ED_TYPE | If yes, which one? | En caso afirmativo |
MOCK_PRIOR_RETENTION | Prior student retention? | |
NAME_F (SR_STU_ENROLL) | First Name | Nombre |
NAME_F (SR_PARENT) | Contact: First Name | Contacto: Nombre |
NAME_GEN_CD | Generation | Generacion |
NAME_L (SR_STU_ENROLL) | Last Name | Apellido |
NAME_L (SR_PARENT) | Contact: Last Name | Contacto: Apellido |
NAME_M (SR_STU_ENROLL) | Middle Name | Segundo nombre |
NAME_M ( SR_PARENT) | Contact: Middle Name | Contacto: Segundo nombre |
NAME_STU_GOES_BY | Nickname | Apodo |
OCCUPATION | Contact: Occupation | Contacto: Ocupación |
OTHER_PHONE_AC | Contact: Other Phone Area Code | Contacto: Código de área de otro teléfono |
OTHER_PHONE_EXT | Contact: Other Phone Extension | Contacto: Extensión de otro teléfono |
OTHER_PHONE_NBR | Contact: Other Phone | Contacto: Otro teléfono |
PAR_NAME | Parent Name | Nombre del padre/madre |
PHONE_AREA_CD | Contact: Area Code | Contacto: Código de área |
PHONE_AREA_CD_BUS | Contact: Business Area Code | Contacto: Código de área del negocio |
PHONE_EXT_BUS | Contact: Business Phone Extension | Contacto: Extensión del teléfono del negocio |
PHONE_NBR (SR_STU_DEMO) | Student Phone | Teléfono del estudiante |
PHONE_NBR (SR_PARENT) | Contact: Phone | Contacto: Teléfono |
PHONE_NBR_BUS | Contact: Business Phone | Contacto: Teléfono del negocio |
PHONE_PREF | Contact: Phone Preference | Contacto: Preferencia telefónica |
PHYS_ADDR_STATE | State (Physical) | Estado (físico) |
PREV_DIST | Previous District | Distrito anterior |
PRI_PHONE | Primary Phone | Teléfono principal |
PRIMARY_FLAG | Contact: Guardian | Contacto: Tutor |
PRIORITY | Contact: Priority | Contacto: Prioridad |
RACE_AMER_INDIAN | American Indian/Alaskan Native | Indio americano/Nativo de Alaska |
RACE_ASIAN | Asian | Asiático |
RACE_BLACK | Black/African American | Negro/Afroamericano |
RACE_PACIFIC_ISL | Hawaiian/Pacific Islander | Hawaiiano/Islas del Pacífico |
RACE_WHITE | White | Blanco |
RCV_MAILOUTS | Contact: Receive Mailouts | Contacto: Recibir comunicaciones por correo |
RELAT | Contact: Relation | Contacto: Relación |
SCH_YR | Contact: School Year | Contacto: Año escolar |
SCND_PHONE | Secondary Phone | |
SEQ_NO | Contact: Sequence Number | Contacto: Número consecutivo |
SEX | Sex | Sexo |
SSN | Contact: SSN | Contacto: NSS |
STATE_CD | Contact: State | Contacto: Estado |
STATE_STU_ID | ||
STR_DRCTN_PHYS | Street Direction (Physical) | Calle y número (física) |
STR_NAME | Contact: Street Name | Contacto: Calle |
STR_NAME_PHYS | Street Name (Physical) | Nombre de la calle (física) |
STR_NBR | Contact: Street Number | Contacto: Número |
STR_NBR_PHYS | Street Number (Physical) | Número (físico) |
STU_CELL_PH | Student Cell Phone | Teléfono celular del estudiante |
STU_ID | Student ID | Identificación del estudiante |
STU_PHONE_AC | Student Area Code | Código de área del estudiante |
TRANSPORT_IND | Contact: Right to Transport | Contacto: Derecho a transportar |
VEH_COLOR | Contact: Vehicle Color | Contacto: Color del vehículo |
VEH_LIC | Contact: Vehicle License Plate Number | Contacto: Número de placas del vehículo |
VEH_LIC_ST | Contact: Vehicle License State | Contacto: Estado de registro del vehículo |
VEH_MDL | Contact: Vehicle Model | Contacto: Modelo de vehículo |
VEH_MK | Contact: Vehicle Make | Contacto: Marca del vehículo |
ZIP | Contact: Zip | Contacto: Código postal |
ZIP_CODE_PHYS_ADDR | Zip (Physical) | Código postal (físico) |
ZIP4 | Contact: Zip4 | Contacto: Código postal4 |
ZIP4_PHYS_ADDR | Zip4 (Physical) | Código Postal4 (físico) |
On this page you will set options for the fields. You will add the fields to a form in a subsequent step.
Seq |
This field indicates if the field is from a vertical table. |
---|---|
Updateable |
This field indicates if the data in the field can be updated by a parent. This is set automatically and cannot be changed. |
Click under Edit to edit settings for a particular field.
The Edit Field Information section is displayed on the left side of the page.
Edit Field Information (left) | |
---|---|
Modify information for the selected field as needed.
|
|
Selected Field | The database name for the selected field is displayed. For a field in a vertical table, an asterisk or a sequence number is displayed in parentheses next to the field name. |
From Table | The database name for the table in which the selected field exists is displayed. |
Default friendly display name |
A friendly name for the selected field is displayed as it will appear on the form in both English and Spanish.
Language |
Is field visible to the user |
• Yes - Allow the field to be displayed for the parent on a form in txConnect. |
Will this field require an admin’s review | This field is not in use at this time. Whether you select Yes or No, all changes submitted by a parent must be reviewed by an administrator before they can be reviewed. |
Is physical documentation required for changes | This field is not in use at this time. |
Default instructions or information for this data |
Type any special instructions for the parent that are specific to the field, up to 255 characters.
Language
If Spanish instructions are not provided, English instructions will be displayed even if the parent is viewing txConnect in Spanish.
|
Click Save.
Repeat for each field that will be used in a form.
txConnect Admin > Administrator Options > Settings > Forms Management > Forms
This page allows you to create new forms, as well as delete and edit existing forms. Two types of forms can be created:
Standard forms are predefined district-level forms that are common throughout Texas. The forms are included automatically and cannot be edited.
A form must be added to a group (or to the Online Registration template) in order to be accessible to parents. You will add the form to a group or to the Online Registration template in a subsequent step.
Available Forms (right) |
Any existing forms are listed, including those that are added automatically. |
---|
Several standard forms are included automatically. The Type is set to standard. Standard forms cannot be modified or deleted; the spyglass and delete icons are not available.
If you uploaded any static documents, you must create a form with each document in order to make it accessible to parents.
NOTE: To create a Spanish version of a static form, you will need to set the Current Language Context for the form to Spanish. This will be done in a subsequent step using the Form Editor page once the static form is created.
To create a static form, do the following under New Form:
Name | |
---|---|
Campus | Select a campus in order to assign the form to a specific campus. Or, select None if the form is used for all campuses in the district. |
Visible |
Select the form from the list in the drop-down field.
Special Instructions or information for this form |
---|
Click Add. A message is displayed indicating that the static form was successfully added.
Repeat for all remaining static forms.
To create a dynamic form, do the following under New Form:
Name | |
---|---|
Campus | Select a campus in order to assign the form to a specific campus. Or, select None if the form is used for all campuses in the district. |
Visible |
If you are creating a dynamic form, leave the drop-down field set to No Document.
Special Instructions or information for this form |
---|
Click Add.
The form opens on the Form Editor page where you can add fields and make other modifications.
On the Form Editor page:
Current Language Context | Select the language of the form you are editing. |
---|---|
Name |
The form name is displayed as entered in the previous step. Modify the field if necessary. The name should be typed in the language selected in Current Language Context. If a Spanish name is not provided, the English name will be displayed even if the parent is viewing txConnect in Spanish. |
Campus |
The campus is displayed as entered in the previous step. Modify the field if necessary. |
Editable |
• Yes - The fields on the form will be editable. |
Visible | The setting entered on the previous page is displayed, indicating if the form is visible to parents in txConnect. Modify the setting if necessary. |
Archived |
• Yes - Archive the form, which allows you to retain forms that may still be needed for reporting purposes but are no longer used for data collection. An archived form is still accessible to administrators, but is grouped with other archived forms for organizational purposes. |
Special Instructions or information for this form | The text box displays any text entered on the previous page. Modify the text if necessary, up to 2000 characters. |
Form Fields | |
---|---|
Field Name | |
---|---|
Select the table-field you want to add to the form. The drop down lists all possible fields, including the field name, sequence number (if applicable), and table name. |
For vertical table, some fields are mandatory, and they will automatically be added to the form even if you do not select them.
Table | Mandatory Fields |
---|---|
SR_PARENT | NAME_L NAME_F NAME_M |
SR_HLTH_MED_COND | MED_COND_CD |
SR_STU_RESTRICT | STU_RESTRICT_CD STU_RESTRICT_CATEG_CD (iTCCS only) |
SR_DEMO | PAR1_NAME_L PAR1_NAME_F PAR1_NAME_M PAR2_NAME_L PAR2_NAME_F PAR2_NAME_M |
SR_DEMO_CONTACT | NAME_L NAME_F NAME_M SEQ_NBR (iTCCS only) |
The following fields will have edits when used on a dynamic form:
• If a column has a DATA_TYP of STATE in DR_ORD_OPT_TYP, the entry will appear as a drop-down list with all of the US states, territories, and insular areas spelled out. When one is selected, the standard two-character postal abbreviation is stored in the table.
• If a column has a DATA_TYP of NUMERIC in DR_ORD_OPT_TYP, the data entered by the user is checked to ensure that there are no invalid characters. It allows either all numbers or spaces. No alpha or special characters are allowed.
• If a column has a DATA_TYP of DATE in DR_ORD_OPT_TYP, the data is masked to force the format MM/DD/YYYY and checked to verify that it is a valid date. For example, 02/31/1995 is not a valid date, even though it is numeric and in the correct format.
• For a DATA_TYP of AREACODE, the data is masked to force the format ###.
• For a DATA_TYP of PHONENUM, the data is masked to force the format ###-####.
• For a DATA_TYP of ZIP5, the data is masked to force the format #####.
• For a DATA_TYP of ZIP4, the data is masked to force the format ####.
• For a DATA_TYP of SSN, the data is masked to force the format ###-##-####.
• In any cases where there are special characters in the display mask on the page, the characters are removed before saving to the SR_ORD table. Also, the date is reformatted to the format YYYYMMDD before saving.
• For a DATA_TYP of EMAIL, the data is checked to ensure that it fits a standard email format. It must have at least one character before an “@” symbol, at least one character between the “@” and the final period, and at least two characters after the final period. For example, the smallest email address that would be considered valid is a@b.cd. There can be multiple periods in the address (e.g., first.last@email.net).
• If a column has an HTML_TYP of DROPDOWN and includes the name of a lookup table, lookup ID, and value fields, the drop down is populated from that table.
• If a column has an HTML_TYP of RADIO_YN, it displays as Y N.
• If a column has an HTML_TYP of TEXT, and a FLD_LEN is given, the text entered into the field is limited to the number of characters specified in FLD_LEN.
Friendly Name | The default friendly name is displayed. If you selected Spanish for Current Language Context, the default friendly names are Spanish. Modify the name as needed, up to 50 characters. |
---|---|
Order | Indicate the order in which you want the fields to be displayed on the form. For example, type 1 if you want to field to be displayed at the top of the form. |
Field Set |
Use this column to group related fields together in the form. For example, you could type “Mailing Address” for all fields that are related to the student’s mailing address. The field set should be typed in the language selected in Current Language Context. If a Spanish field set name is not provided, the English field set name will be displayed even if the parent is viewing txConnect in Spanish. |
Vis | Select if you want the field to be visible to parents on the form. Clear the check box if you do not want the field visible to parents. For example, you can hide the four-digit zip code extension. The setting of this field overrides all other visibility settings. |
Edit |
Select to allow parents to update data in this field from the form. |
Req | Select if the field is required of the parents. If this field is selected, be sure Edit is also selected. |
Bold | Select if you want the field to be displayed in a bold font. |
Italics | Select if you want the field to be displayed in an italic font. |
Color | |
Bg Color |
Click the box to select a background color for the field. A pop-up window opens that provides seven background color choices, as well as the option for no color. The form is automatically shaded with an alternating (light/dark) gray background when displayed for parents in txConnect. If you do not select a color, or if you select No Color, the background will be gray. |
Instructions | |
---|---|
Default Instructions | Any instructions entered on the Form Field Management page are displayed. They cannot be changed here. |
---|---|
Field Instructions | Add or update any additional instructions for the field. These instructions will be appended to the Default Instructions when the parent accesses the form in txConnect. |
Bold | Select if you want the instructions to be displayed in a bold font. This selection will apply to all text typed in the Field Instructions area. |
Italics | Select if you want the instructions to be displayed in an italic font. This selection will apply to all text typed in the Field Instructions area. |
Color |
Click Close.
To remove a column from the form, click the delete icon for the column.
It is removed from the list, but it is not actually deleted until you click Save.
Click Save.
NOTE: If you created a form with fields from a vertical table, some required additional fields may be added automatically. If so, a message is displayed prompting you to review the fields before saving.
Note the added fields. These fields cannot be removed; the delete icon is not displayed.
Click Save again.
Based on the settings in the example above, the form will look like this to the parent in txConnect:
Click < Forms to return to the Form Management page.
Copy Form |
Click to create a new form that is an exact duplicate of the form you are copying. |
---|
The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.