Data Validation Examples

Examples of Dependent Field Requirements Rules

Active students must have a homeroom.

Condition: {f:stdEnrStatus} = {Active}

Expression: {f:stdHomeroom} !EMPTY {}

 

Special education students must have a 'level of need' code.

Condition: {f:stdSpedStatus} = {Active}

Expression: {a:DOE Department of Education 38} !EMPTY {}

 

Students with a GPA grade point average less than 2 must have an advisor.

Condition: {a: GPA} {2}

Expression: {a:DOE 38} !EMPTY {}

 

Special education staff members must have a special education role.

Condition: {f:stfSpedInd} = {1}

Expression: {a:DOE 38} !EMPTY {}

 

Examples of Cross-Table Rules

Special education students cannot be suspended.

Condition: {f:actActionCode} = {Suspended}

Expression: {f:relActStdOid.stdSpedStatus} != {Active}