| Column # | Field Name | Description | Rules Values = Display Description Enter Values in the data file |
|---|---|---|---|
| 1 | Action | Contains the code representing the action to be taken for the record. | Required field. Case insensitive. Valid values are: If attempting to create a record and the Username provided already exists in the system, the record will error. If attempting to update a record and the Username provided does NOT already exist in the system, the record will error. |
| 2 | Username NOTE: Please use your e-mail address as your username. This is the location your password token will be sent when creating a user. |
Contains the unique username. Must be unique. | Required field. Case insensitive. Use e-mail address. Max length = 100 characters |
| 3 | State Code | State Abbreviation | CA |
| 4 | First Name | Contains the user's first name. | Required. Max length = 50 characters |
| 5 | Last Name | Contains the user's last name. | Required. Max length = 50 characters |
| 6 | Authorized Organizations | Contains the organization codes associated to the user. The values in this field should represent ALL organizations associated to the user. | Required. Use the 14 character CDS Code for the associated district or school. Reference the Roles field. Most users will have only organization listed and will have access to that organization and all of its children organizations. Can only create/modify organizations for users that are within the list of organizations that the user submitting the file has access to. |
| 7 | Roles | Contains the role codes associated to the user. The values in this field should represent ALL roles associated to the user. | Required. Case insensitive. Can only create/modify roles for users that are within the list of roles that the user submitting the file has access to. district_admin = District Admin User |
| 8 | Active Begin Date | Identifies when a user account becomes active. | Optional For example, if a start date is March 30, 2011, it should be entered as 03/30/2011. Leading zeros in the month and day fields are not required. Active Begin Date must be equal to or before Active End Date Note: Even though time is not collected, system time is currently in CT which may affect perceived access crossing over midnight boundaries. |
| 9 | Active End Date | Identifies when a user account becomes inactive. If an account has expired, the user will receive an error message upon log in. | Optional For example, if an end date is August 30, 2011, it should be entered into this field as 08/30/2011. Leading zeros in the month and day fields are not required. Active End Date must be equal or after Active Begin Date Note: Even though time is not collected, system time is currently in CT which may affect perceived access crossing over midnight boundaries. |
| 10 | Disabled | Identifies whether the user's account is disabled. Also use this field when a user will never need to access the system again (e.g., the user retires or changes jobs). If an account is disabled, the user will receive an error message when attempting to login to the system. |
Required Case insensitive. Disabled Date within the system will be populated with current date if Disabled field on this file is set to Yes |
| 11 | Disabled Reason | Identifies the reason given as to why the user account has been disabled. | Required if Disabled field on this file is set to Yes. Max length = 1000 characters |
Notes:
- This file contains data about Users of the system. The system will match user accounts in additional file uploads to the data in the tool. If a user account exists with the same user name and state code as a user account in the new file upload, the data will replace the data for that user account. If no match is found, a new user account will be created.
- When a user account is created, the system will generate an e-mail to the user with instructions on to set the intial password for the user.
- File must be comma delimited and must include the header row.
- CDE will create initial "district admin" users for each district. The "district admin" user can create other users at the district and school levels.
