Safety & Loss Prevention
Facilities Central Data Request
General Technical Considerations
The CDR Facilities File may be submitted by institutions in 1 of 2 text file formats, either as a fixed length, positional file or as a comma separated values (.csv) file, whichever is easier for your institution to produce. Please only submit your institution's data once, and in only 1 of the 2 file format options.
OPTION 1: FIXED LENGTH TEXT FILE
This has been the standard submittal option for CDR Facilities data. All CDR Facilities File data is arranged and formatted
into a fixed row length of characters/text, where each row contains a single record's data, using spaces to pad left justified text fields and 0's to pad right justified
numeric fields to arrive at the desired row length of characters/text.
OPTION 2: COMMA DELIMITED TEXT FILE [*.CSV]
All CDR Facilities File data is arranged and formatted with commas "," used to separate data between the fields. Cell padding is optional and not required. If submitting in .csv format please arrange the fields in the same order as they are listed in the positional file layout.
Field Specifications for Fixed Length, Positional Data Submission
|Field Name||Data Type||Field Length||Position||Notes|
|facility number (3030)||CHAR||(5)||4-8|
|facility name (3040)||CHAR||(40)||9-48|
|date of construction||NUMBER||(4)||49-52||3|
|type of facility (3070)||CHAR||(3)||54-56|
|funding source (3080)||CHAR||(1)||57-57|
|area, total assignable (3090)||NUMBER||(8)||58-65|
|area, total unclassified (3100)||NUMBER||(8)||66-73|
|area, total nonassignable (3110)||NUMBER||(8)||74-81|
|area, gross (3210)||NUMBER||(8)||82-89||2|
|address 1 (3200)||CHAR||(30)||90-119|
|address 2 (3210)||CHAR||(30)||120-149|
|zip code (3240)||NUMBER||(9)||202-210||6|
|utility indicator (4340)||CHAR||(1)||241-241||7|
|central utility, chilled water (4370)||CHAR||(1)||242-242||7|
|central utility, steam (4380)||CHAR||(1)||243-243||7|
|area gross, gpr % (4390)||NUMBER||(5)||244-248|
FTP file ASCII(text) and not binary format.
Not a required field (3020 and 3210).
'Date of Construction' must be 'YYYY' (e.g., 1992).
Element number 3220 must be either City of ___, Town of ____ or Village of ____.
Element number 3230 will default to 'WI'.
Element number 3240 must be zip plus four without the dash.
Utility Indicators must be 'Y' or 'N' (yes or no).
There are several general guidelines which are common to the preparation and processing of all data submission files. These common guidelines are discussed below, while the instructions specific to the individual data submission files are contained within the Data Element Dictionary itself.
Changes in Entity Keys
If the entity within the curricular or student data area changes between data submissions, a list of such changes must accompany the submission which contains the changed key(s).
Right-justify and zero-fill all fields which are to be used in calculations. All such fields are identified with an asterisk (*) on the Data Element lists contained within the sections that follow. All numeric fields must be unsigned.
All other fields are left-justified and blank-filled. (Also note the Coding Considerations in the Data Element Dictionary.)
Data Submission via FTP
The following information is needed for submitting the Facility CDR data via FTP.
Facility CDR destination site: cdr.uwsa.edu (must be lower case)
|Destination file name:||WXXXZZZ.YYYT*|
|XXX =||CDR (CDR file)|
|ZZZ =||PHY (Physical Facility)|
|YYY =||year (e.g., 123 for 2012-13)|
|T =||A (annual)|
|* =||Institution Code|
Sample: WCDRPHY.123AK (2012-13 Annual file for Stevens Point)
Re-Submission of CDR Files
Re-submission of CDR files may be requested by System Administration or may be initiated by an institution. If an institution decides to re-submit a CDR file, an email informing System Administration of this intention should be sent to the appropriate data manager.