Skip to content
Printer-friendly version

SBAC Users File Import Layout

Specifications for the import data file for the users information into the SMARTER Balanced Consortium (SBAC) Information Technology Readiness Tool.
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:
C or c (create)
U or u (update)

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.

Delimited field. Multiple organization codes must be separated with a colon (e.g., 555:556).

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.
Delimited field. Multiple role codes must be separated with a colon.

Most users will have only one role.

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
district = District User
school = School User

8 Active Begin Date Identifies when a user account becomes active.

Optional
Format as: MM/DD/CCYY
MM is the 2-digit month
DD is the 2-digit day
CC is the century
YY is the 2-digit year

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
Format as: MM/DD/CCYY
MM is the 2-digit month
DD is the 2-digit day
CC is the century
YY is the 2-digit year

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
Yes = Account should be disabled.
No = Account is not disabled.

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:
Related Content
Questions:   SBAC Technology Readiness Coordinator | sbac-itreadiness@cde.ca.gov
Download Free Readers