Return to Navigation

ITT Return: Student Entity

The Create Extract process creates ITT Student entities only if all the following conditions are satisfied:

Note: Students are not included in the return if TTCID is 0 (zero) or is one of the codes only relevant to the Student return (5, 9, D, F, J, K) or is blank or is NULL ERROR.

If all the conditions are satisfied, then the process create a record in the ITT Student Extract table with status set to ACTIVE using the following values:

If you provided an EMPLID for the Student ID run parameter, the process creates ITT Student entity records for only the selected EMPLID.

The Create Extract process selects External Degree records to derive the degree fields (such as DEGENDDT and DEGEST). If the student has multiple records, the process selects the most recent record.

If you have selected the Null Errors Only check box for the Include Student Entities on the Create Extract Data page, the process selects distinct EMPLIDs from the existing active ITT extract data, where at least one field in the Student or Course Subject extract data has a derived value of NULL ERROR. The process then selects Student entity records for these EMPLIDs.

If you have selected the Validation Errors Only check box for the Include Student Entities, the process first deletes any Validation Error staging records where EMPLID is blank. Then, it selects distinct EMPLIDs from the Validation Error staging table. The process selects Student entity records for these EMPLIDs. Finally, it deletes records from the Validation Error staging table where EMPLID is populated.