For your reference, the following sections represent a complete list of feed files used in SIS integration along with their headers and object types.
All dates should be in the format of either yyyyMMdd or MM/dd/yyyy.
Valid boolean values include 1/Y/Yes/true or 0/N/No/false.
Course
| Header | Object Type |
|---|---|
| external_course_key | Unique external identifier. Required. |
| course_id | Short course ID. Required for insert. |
| course_name | Course name. Required for insert. |
| description | Course description. |
| start_date | Course start date. |
| end_date | Course end date. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
| row_status | The enabled status of this record. Values include enabled/disabled. |
| enroll_option | Type of enrollment. Values include self/instructor/email. |
| available_ind | Boolean for whether the course is available. |
| catalog_ind | Boolean for whether the course should show in the catalog. |
| desc_page | Boolean for whether this course has a description page. |
| duration | The duration type of the course. Values include continuous/range/fixed/term. Overridden when use_term_availability_ind set to Y. |
| lockout_ind | Boolean for whether the course is locked out. |
| pace | The pace of the course. Values include self/instructor. |
| service_level | Course or organization. Values include community/full. |
| abs_limit | The absolute limit on total file size in the course. Field not currently used in Learn 9.1 |
| soft_limit | The soft limit on the total file size in the course. |
| enroll_start | The enrollment start date. |
| enroll_end | The enrollment end date. |
| days_of_use | For a fixed duration course, the number of days the course can be used. |
| institution_name | The name of the institution. |
| fee | The fee if the course has a fee. |
| allow_guest_ind | Boolean for whether the guest user is allowed access to the course. |
| enroll_access_code | Enrollment access code for self-enrolled courses |
| new_external_course_key | A replacement for the existing external_course_key. |
| template_course_key | The external_course_key of a course whose contents should be copied into this one. |
| allow_observer_ind | Boolean for whether observer users are allowed access to this course. |
| locale | The locale. |
| term_key | The external key of the term with which this course is associated. |
| master_course_key | The master course under which this course is cross-listed. |
| primary_external_node_key | The institutional hierarchy node from which the initial settings for this course will be populated. |
| external_association_key | The institution hierarchy node with which this course is associated. |
| use_term_availability_ind | Boolean for whether the course availability/duration should be taken from the associated term. |
Course association
| Header | Object Type |
|---|---|
| external_association_key | Unique external identifier. Required. |
| external_course_key | External identifier of the course. Required. |
| external_node_key | External identifier of the hierarchy node. Required. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
| is_primary_association | Boolean for whether this association is the primary association. |
Course category
| Header | Object Type |
|---|---|
| external_category_key | Unique external identifier. Required. |
| row_status | The enabled status of this record. Values include enabled/disabled. |
| available_ind | Boolean for whether the record is available. |
| title | Title of the category. Required for insert. |
| frontpage_ind | Boolean for whether the category shows on the top category page. |
| data_source_key new_data_source_key |
The data source with which this record is associated. |
| parent_category_key | The external_category_key of the parent category of this category. |
| new_external_category_key | A replacement for the existing external_category_key. |
| description | Description of the category. |
| restrict_ind | Boolean for whether this category should be restricted. |
Course category membership
| Header | Object Type |
|---|---|
| external_category_key | The external key of the course category. Required. |
| external_course_key | The external key of the course. Required. |
| row_status | The enabled status of this record. Values include enabled/disabled. |
| available_ind | Boolean for whether the record is available. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
Course membership
| Header | Object Type |
|---|---|
| external_course_key | The external key of the course. Required. |
| external_person_key | The external key of the person. Required. |
| role | The role to use. Required for insert. |
| row_status | The enabled status of this record. Values include enabled/disabled. |
| available_ind | Boolean for whether the record is available. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. Required. |
| receive_email_ind | Boolean for whether the member wants to receive email from the course. |
| roster_ind | Boolean for whether the member should show up in the course roster. |
Course standard association
| Header | Object Type |
|---|---|
| std_sub_doc_key | External key of the standard document. Required. |
| course_key | External key of the course. Required. |
Hierarchy node
| Header | Object Type |
|---|---|
| external_node_key | Unique external identifier. Required. |
| new_external_node_key | Replacement for the existing external_node_key. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
| parent_node_key | The external_node_key of the parent node of this one. |
| name | The name of the node. Required for insert. |
| description | The description of the node. |
Observer association
| Header | Object Type |
|---|---|
| external_observer_key | The external_person_key of the observer. Required. |
| external_user_key | The external_person_key of the person being observed. Required. |
| row_status | The enabled status of this record. Values include enabled/disabled. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
Organization
| Header | Object Type |
|---|---|
| external_organization_key | Unique external identifier. Required. |
| organization_id | Short organization ID. Required for insert. |
| organization_name | Organization name. Required for insert. |
| description. | Organization description. |
| start_date | Organization start date. |
| end_date | Organization end date. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
| row_status | The enabled status of this record. Values include enabled/disabled. |
| enroll_option | The type of enrollment. Values include self/instructor/email. |
| available_ind | Boolean for whether the organization is available. |
| catalog_ind | Boolean for whether the organization should show in the catalog. |
| desc_page | Boolean for whether this organization has a description page. |
| duration | The duration type for this organization. Values include continuous/range/fixed/term. |
| lockout_ind | Boolean for whether the organization is locked out. |
| pace | The pace of the organization. Values include self/instructor. |
| service_level | Whether this is a course or organization. Values include community/full. |
| abs_limit | The absolute limit on total file size in the organization. |
| soft_limit | The soft limit on total file size in the organization. |
| upload_limit | The limit on uploaded file size in the organization. |
| enroll_start | The enrollment start date. |
| enroll_end | The enrollment end date. |
| days_of_use | For a fixed duration organization, the number of days the organization can be used. |
| institution_name | The name of the institution. |
| fee | The fee if the organization has a fee. |
| allow_guest_ind | Boolean for whether the guest user is allowed access to the organization. |
| enroll_access_code | Enrollment access code for self-enrolled organizations. |
| new_external_ organization_key |
A replacement for the existing external_organization_key. |
| template_organization_key | The external_organization_key of an organization whose contents should be copied into this one. |
| allow_observer_ind | Boolean for whether observer users are allowed access to this organization. |
| locale | The locale. |
| locale_enforced | Boolean for whether the locale is enforced. |
| use_term_availability_ind | Boolean for whether the organization availability/duration should be taken from the associated term. |
| primary_external_node_key | The institutional hierarchy node from which the initial settings for this organization will be populated. |
| external_association_key | The institution hierarchy node with which this organization is associated. |
Organization association
| Header | Object Type |
|---|---|
| external_association_key | Unique external identifier. Required. |
| external_organization_key | External identifier of the organization. Required. |
| external_node_key | External identifier of the hierarchy node. Required. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
| is_primary_association | Boolean for whether this association is the primary association. |
Organization category
| Header | Object Type |
|---|---|
| external_category_key | Unique external identifier. Required. |
| row_status | The enabled status of this record. Values include enabled/disabled. |
| available_ind | Boolean for whether the record is available. |
| title | Title of the category. Required for insert. |
| frontpage_ind | Boolean for whether the category shows on the top category page. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
| parent_category_key | The external_category_key of the parent category of this category. |
| description | Description of the category. |
| resrict_ind | Boolean for whether this category should be restricted. |
| is_primary_association | Boolean for whether this association is the primary association. |
Organization category membership
| Header | Object Type |
|---|---|
| external_category_key | External key of the organization category. Required. |
| external_organization_key | The external key of the organization. Required. |
| row_status | The enabled status of this record. Values include enabled/disabled. |
| available_ind | Boolean for whether the record is available. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
Organization membership
| Header | Object Type |
|---|---|
| external_organization_key | The external key of the organization. Required. |
| external_person_key | The external key of the person. Required. |
| role | The role to use. Required for insert. |
| row_status | The enabled status of this record. Values include enabled/disabled. |
| available_ind | Boolean for whether the record is available. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
| receive_email_ind | Boolean for whether the member wants to receive email from the organization. |
| roster_ind | Boolean for whether the member should show up in the organization roster. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
Person
| Header | Object Type |
|---|---|
| external_person_key | The external key of the person. Required. |
| system_role | The person's system role. |
| user_id | The login ID. Required for insert. |
| passwd | The user's password. Can be plain text (where it will be hashed) or already hashed. Required. |
| pwencryptiontype | The type of hashing done on the password. Required if the password is pre-hashed. Supported values are MD5 or SSHA |
| title | The user's title; for example, "Mr". |
| firstname | The user's first name. Required for insert. |
| middlename | The user's middle name. |
| lastname | The user's last name. Required for insert. |
| h_phone_1 | The user's home phone number. |
| h_fax | The user's home fax number. |
| m_phone | The user's cell phone number. |
| The user's email address. | |
| birthdate | The user's date of birth. |
| street_1 | The user's street address. |
| street_2 | The user's street address (line 2). |
| city | The user's city. |
| state | The user's state. |
| zip_code | The user's zip/postal code. |
| country | The user's country. |
| company | The company at which the user works. |
| department | The department in which the user works. |
| job_title | The user's job title. |
| b_phone_1 | The user's work phone number. |
| b_fax | The user's work fax number. |
| student_id | The user's student ID. |
| institution_role | The user's institution role. |
| row_status | The enabled status of this record. Values include enabled/disabled. |
| gender | The user's gender. |
| b_phone_2 | The user's secondary work phone number. |
| h_phone_2 | The user's secondary home phone number. |
| webpage | The URL for the user's Web page. |
| educ_level | The user's level of education. Values include k-8/high school/freshman/sophomore/junior/senior/graduate school/post-graduate school/unknown. |
| available_ind | Boolean for whether the record is available. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
| new_external_person_key | Replacement for the current external_person_key. |
| othername | The user's other name. |
| suffix | The user's suffix name. |
Term
| Header | Object Type |
|---|---|
| external_term_key | The external key of the term. Required. |
| name | The name of the term. Required for insert. |
| description | The description of the term. |
| duration | The term duration. Values include continuous/range/fixed. |
| start_date | The term start date. |
| end_date | The term end date. |
| days_of_use | For a fixed duration term, the number of days in the term. |
| row_status | The enabled status of this record. Values include enabled/disabled. |
| available_ind | Boolean for whether the record is available. |
| new_external_term_key | Replacement for the current external_term_key. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
User association
| Header | Object Type |
|---|---|
| external_association_key | External key of the association category. Required. |
| external_user_key | The external_person_key of the user to associate. Required. |
| external_node_key | The external_node_key of the node to associate to. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
User secondary institution role
| Header | Object Type |
|---|---|
| external_person_key | The external_person_key of the person to associate. |
| role_id | The institution role. Required. |
| row_status | The enabled status of this record. Values include enabled/disabled. |
| data_source_key new_data_source_key |
The data source with which this record should be associated. |
