User Tools

Site Tools


student:cafeteria_import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
student:cafeteria_import [2017/09/02 01:50] jstanfordstudent:cafeteria_import [2025/07/21 15:28] (current) lrosdahl
Line 1: Line 1:
 ======Cafeteria Import====== ======Cafeteria Import======
  
-Use this record layout to import cafeteria data into TxEIS. The import file is a comma-delimited text file.+Use this record layout to import cafeteria data into ASCENDER. The import file is a comma-delimited text file.
  
 <WRAP box>**NOTE:** Each field has a fixed length, except the name fields. The name fields are truncated, so no additional spaces are needed.</WRAP> <WRAP box>**NOTE:** Each field has a fixed length, except the name fields. The name fields are truncated, so no additional spaces are needed.</WRAP>
  
-^Description^Length^Notes^ +^Field^Characters^Required^Notes^ 
-|Record ID|6|CAFIMP| +|Record ID|6|Y|Literal "CAFIMP"
-|County/District/Campus|9| | +|County/District/Campus|9| Y| | 
-|Student ID|6| | +|Student ID|6|Y| | 
-|Date of Birth|8|YYYYMMDD| +|Date of Birth|8|Y|YYYYMMDD| 
-|Student Last Name|25| | +|Student Last Name|25| Y| | 
-|Student First Name|17| | +|Student First Name|17|Y| | 
-|Student Middle Initial|1|Add a space if no middle initial.| +|Student Middle Initial|1|Y|Space if no middle name.| 
-|Economic Disadvantage Status|2| |+|Economic Disadvantage Status|2|Y | | 
 +|Effective Date|8| Y|Date used for Begin/End Date on inserted/updated records.|
  
 Example: CAFIMP,030902041,003018,20041010,LOPEZ,MICHAEL,L,00 Example: CAFIMP,030902041,003018,20041010,LOPEZ,MICHAEL,L,00
  
student/cafeteria_import.1504317009.txt.gz · Last modified: 2017/09/01 20:50 (external edit)