The Snapshot Flat File provides the ability to integrate using the latest LEARN data objects. Below is a comprehensive list of the supported objects, their UI to Feed Header naming conventions, usage description, and data requirements.

As the data feed is a text file all data is represented as a string. In some cases specific formatting and length are noted. Where required by the field supported values are provided. Required fields are highlighted and noted.

LEARN Objects:

User

Course/Organization

Course/Organization Membership

Term

Secondary Institution Role Association

Observer Association

Category

Category Membership

Hierarchy Node

Hierarchy User Association

Hierarchy Course Association

Goal Association

    LEARN Object: User

    SIS Object: Person

    Default Insert/Update behavior: Smart Inserts or Updates

    Default Delete Behavior: Disable

    Learn Fields

    Batch Uid (Required)

    Required:    Yes

    Unique:    Yes

    Header:    external_person_key

    Description: A unique identifier for a user at the institution. This ID is provided by the institution and is not displayed to users.

    It is strongly recommended that the key data be a permanent, non-changing identifier for each user. An example of a good key is a permanent Student ID assigned when the person applies to the institution. Please note that the database cannot merge data between distinct accounts.

    Max length 64.

     

    Data Source Key (Required) Supplied by the integration or the data file.

    Required:    Yes

    Unique:    No

    Header:    data_source_key

    Description: Key used to establish grouping of user elements. Note this may be provided by the integration configuration and thus would not be required in the file.

    Max. length: 256. Multi byte characters accepted.

     

    First Name (Required)

    Required:    Yes

    Unique:    No

    Header:    firstname

    Description: The user's given first name.


    Max length 100. Multi byte characters accepted.

     

    Last Name (Required)

    Required:    Yes

    Unique:    No

    Header:    lastname

    Description: The user's family/last name.

    Max length 100. Multi byte characters accepted.

     

    Username (Required)

    Required:     Yes

    Unique:    Yes

    Header:   user_id

    Description: The username used to log into Blackboard Learn. The username must be unique.

    Max length 50. Multi byte characters accepted.

     

    Name Pronunciation

    Required:     No

    Unique:    No

    Header:  TBC

    Description: Phonetic spelling or pronunciation guide for user’s name.

    Max length: 1000. Multi-byte characters accepted.

     

    Password

    Required:    No

    Unique:    No

    Header:    passwd

    Description: The password used to log into Blackboard Learn. If a password is not provided in the data feed Learn auto-populates this field with a SHA-512 password for security purposes.

    Max length 32. Multi byte characters accepted.

     

    Available

    Required:    No

    Unique:    No

    Header:    available_ind

    Description: User account availability within the user interface. If set to no, the user account will appear in gray to the Administrator and Instructors. The user will not be able to log into the system. Values may be "Y" for yes, or "N" for no.

    Supported values: 'Y', 'N'.

     

    Birthdate

    Required:    No

    Unique:    No

    Header:    birthdate

    Description: The user's birth date.

    Format: yyyymmdd.

     

    City

    Required:    No

    Unique:    No

    Header:    city

    Description: The city name corresponding to the user's address.

    Max length 50. Multi byte characters accepted.

     

    Company

    Required:    No

    Unique:    No

    Header:    company

    Description: The name of the company for which the user works.

    Max length 100. Multi byte characters accepted.

     

    Country

    Required:    No

    Unique:    No

    Header:    country

    Description: The country name corresponding to the user's address.

    Max length 50. Multi byte characters accepted.

     

    Department

    Required:    No

    Unique:    No

    Header:    department

    Description: The name of the department or sub-section where the user works.

    Max length 100. Multi byte characters accepted.

     

    Education Level

    Required:    No

    Unique:    No

    Header:    educ_level

    Description: The highest level of education achieved by the user.

    Supported values: "K-8", "high school", "freshman", "sophomore", "junior", "senior", "graduate school", "post- graduate school"

     

    Email

    Required:    No

    Unique:    No

    Header:    email

    Description: The email address of the user. Blackboard recommends that user_email is not null. Users without an email address cannot send email.

    Max length 100

     

    Institution Email

    Required:    No

    Unique:    Yes

    Header:    inst_email

    Description: The institution email address of the user. inst_email can be set to Null. No email communications are sent to the inst_email.

    Max length 254

     

    Pronouns
    Required:    No
    Unique:    No
    Header:   pronouns
    Description: This is the user’s pronouns. Multiple pronoun values are accepted using comma as delimiter.

    Max length 1000

     

    Gender

    Required:    No

    Unique:    No

    Header:    gender

    Description: The gender of the user.

    Supported values: "Not Disclosed", "Male", "Female"

     

    Home Phone

    Required:    No

    Unique:    No

    Header:    h_phone_1

    Description: The user's home phone number.

    Max length 50. Multi byte characters accepted.

     

    Home Phone (Secondary)

    Required:    No

    Unique:    No h_phone_2

    Description: An additional home phone number associated with the user.

    Max length 50. Multi byte characters accepted.

     

    Job Title

    Required:    No

    Unique:    No

    Header:    job_title

    Description: The associated job title for the user.

    Max length 100. Multi byte characters accepted.

     

    Middle Name

    Required:    No

    Unique:    No middlename

    Description: The user's given middle name.

    Max length 100. Multi byte characters accepted.

     

    Mobile Phone

    Required:    No

    Unique:    No

    Header:    m_phone

    Description: The user's mobile phone or pager number.

     

    Max length 50. Multi byte characters accepted.

     

    Other Name

    Required:    No

    Unique:    No

    Header:    othername

    Description: This is the user's alternate preferred name.

    Max length: 100.

     

    Password Encryption Type

    Required:    No

    Unique:    No

    Header:    pwencryptiontype

    Description: This field sets the password encryption type used to encrypt the password in the database.

    Supported values are: MD5, SSHA

     

    Primary Institution Role

    Required:    No

    Unique:    No

    Header:    institution_role

    Description: The user's Primary Institution Role, which determines the user's view of the Portal Modules and other items.

    See "Manage Institution Roles" in the System Admin panel for the list of valid Institution Roles on the system.

     

    Pronouns
    Required:    No
    Unique:    No
    Header:    pronouns
    Description: This is the user's pronouns.

    Max length 1000.

     

    Replacement Batch Uid

    Required:    No

    Unique:    Yes

    Header:    new_external_person_key

    Description: This field is used only on the rare occasions when a user's EXTERNAL_PERSON_KEY changes.

    Max length 64. Multi byte characters accepted.

     

    Replacement Data Source Batch Uid

    Required:    No

    Unique:    No

    Header:    new_data_source_key

    Description: New key used to establish grouping of user elements. Replaces existing data source associating data with the group designated by the specified replacement data source key. Note: The UI mapping field for Replacement Data Source Batch Uid is 'script.flatfile.UserReplacementDataSourceBatchUid'

     

    Row Status

    Required:    No

    Unique:    No

    Header:    row_status

    Description: Sets the value of the record to one of the following: Enabled: Normal access to the record. Disabled: Record is visible in some areas of the UI, but may not be changed or accessed. Deleted: Record is scheduled to be removed.

    Supported values: "enabled", "disabled", "deleted"

    Max length 64. Multi byte characters accepted.

     

    State/Province

    Required:    No

    Unique:    No

    Header:    state

    Description: The state or province name corresponding to the user's address.

    Max length 50. Multi byte characters accepted.

     

    Street 1

    Required:    No

    Unique:    No

    Header:    street_1

    Description: The first line of the address of the user.

    Max length 100. Multi byte characters accepted.

     

    Street 2

    Required:    No

    Unique:    No

    Header:    street_2

    Description: The second line of the address of the user.

    Max length 100. Multi byte characters accepted.

     

    Student ID

    Required:    No

    Unique:    No

    Header:    student_id

    Description: Generic identifier field. This is a display only field.

    Max length 100. Multi byte characters accepted.

     

    Suffix

    Required:    No

    Unique:    No

    Header:    suffix The user's name suffix.

    Max length 100. Multi byte characters accepted.

     

    System Role

    Required:    No

    Unique:    No

    Header:    system_role

    Description: The user's administrative role, describing the user's level of system administration privilege. The role of "none" has no system administration or Course creation privileges associated with it, and is the most commonly assigned role. The following strings are acceptable: User Administrator: "account_admin", "accountadmin" or "user_admin" System Support: "system_support" or "syssupport" Course Creator: "course_creator" or "creator" Support: "course_support" or "support" Guest: "guest"
None: "none" Observer: "observer"
Portal Administrator: "portal_admin" or "portal" System Administrator: "sys_admin", "sysadmin" or "system_admin" eCommerce Administrator: "ecommerce_admin" Card Office Administrator: "card_office_admin" Store Administrator: "store_admin" User defined system roles can be used. Just match the "Role ID" found in Administrator Panel > System Role If one is not given the system defaults to none. Title No No title The title that the user prefers to use.

    Max length 100. Multi byte characters accepted.

     

    Website

    Required:    No

    Unique:    No

    Header:    webpage

    Description: The URL of the user's personal Web page, if they have one.

    Max length 100

     

    Work Phone

    Required:    No

    Unique:    No

    Header:    b_Phone _1

    Description: The work phone number associated with the user.

    Max length 50. Multi byte characters accepted.

     

    Work Phone (Secondary)

    Required:    No

    Unique:    No

    Header:    b_phone_2

    Description: An additional work phone number associated with the user.

    Max length 50. Multi byte characters accepted.

     

    Zip/Postal Code

    Required:    No

    Unique:    No

    Header:    zip_code

    Description: The user's ZIP or Postal Code.

    Max length 50. Multi byte characters accepted.

    TOP

    LEARN Object: Course and Organization

    SIS Object: Course or Organization

    Default Insert/Update behavior: Smart Inserts or Updates

    Default Delete Behavior: Disable

    Learn Fields

    Batch Uid (Required)

    Required:    Yes

    Unique:    Yes

    Header:    external_course_key.external_organization_key

    Description: Short name used by the Institution to uniquely identify the Course or Organization section. This is not displayed to users. Can contain only letters, digits, dashes and periods. No spaces or other punctuation allowed. Must be unique for each Course and Organization, and is often the same as the COURSE_ID or ORGANIZATION_ID.

    Max length 64. Must be unique. Multi byte characters accepted.

     

    Course ID or Organization ID (Required)

    Required:    Yes

    Unique:    Yes

    Header:    course_id or organization_id

    Description: Short name used by the institution to uniquely identify the Course or Organization (for example, math101_F99 or ChessClub) The following characters may not be used: space ( ) & / ' +

    Max length 100. Must be unique and cannot be changed.

     

    Course Name or Organization Name (Required)

    Required:    Yes

    Unique:    No

    Header:    course_name/organization_name

    Description: Complete title of the Course or Organization. This is used for display.

    Max length 255. Multi byte characters accepted.

     

    Data Source Key (Required) Supplied by the integration or the data file.

    Required:    Yes

    Unique:    No

    Header:    data_source_key

    Description: Key used to establish a grouping of Course or organization elements. Note this may be provided by the integration configuration and thus would not be required in the file.

    Max. length: 256. Multi byte characters accepted.

     

    Course View

    Required:    No

    Unique:    No

    Header:   course_experience

    Description: Determines which course view will appear for new courses. This field is insert only, and can't be updated through the SIS framework. 

    Supported values: Original, Ultra, or Instructor choice.

     

    classificationId

    Required:    No

    Unique:    No

    Header:    classification_key

    Description: This determines the classification (subject area and the discipline) of the course. This is an Id representing the primary key for the classification.

    Max length 450

     

    hasDescriptionPage

    Required:    No

    Unique:    No

    Header:    desc_page_ind

    Description: This field is currently not supported. Integrations should not use this field.

     

    numDaysOfUse

    Required:    No

    Unique:    No

    Header:    days_of_use

    Description: Number of days that Students may access the Course after enrollment. Useful for self-paced learning. This value is only used if the duration is set to 'FIXED' and it describes the number of days the course can be used after creation.

    Numeric. For example: 120

     

    serviceLevelType

    Required:    No

    Unique:    No

    Header:    service_level

    Description: Not typically used in data feeds. Ignore.

    Specifies the type of course.

    C = Community = Organization

    F = Full = Course

    R = Registered = (is not used)

    T = Test_Drive = (is not used)

    S = System = A course with limited functions to protect data comprising the course.

    Supported values: 'F', 'C', 'R', 'T', 'S'

     

    Allow Guests

    Required:    No

    Unique:    No

    Header:    allow_guest_ind

    Description: Allows guest access to the Course.

    Supported values: 'Y', 'N'

     

    Allow Observers

    Required:    No

    Unique:    No

    Header:    allow_observer_ind

    Description: Allows observer access to the Course.

    Supported values: 'Y", 'N'

     

    Available

    Required:    No

    Unique:    No

    Header:    available_ind

    Description: Establishes Course or organization availability to Blackboard. If use_term_avail_ind is 'Y', this flag is ignored and this course's availability is determined by its associated term available_ind.

    Supported values: 'Y", 'N'

     

    Cross Listed Course Batch Uid

    Required:    No

    Unique:    No

    Header:    master_course_key

    Description: Parent course EXTERNAL_COURSE_KEY of which this course is a child.

    Max length: 64

     

    Description

    Required:    No

    Unique:    No

    Header:    description

    Description: Complete description of the Course.

    Max length 4000. Multi byte characters accepted.

     

    Duration

    Required:    No

    Unique:    No

    Header:    duration

    Description: This is to indicate if the duration of the course availability is continuous, date range, x days from enrollment, or term-dictated.

    Options are:

    • Continuous: 'C' = The Course is always accessible.
    • Range: 'R' = The Course is accessible in the days between one START_DATE and END_DATE. Either the beginning date or the end date can be left open-ended to make a Course accessible from a certain date or until a certain date.
    • Duration: 'D' = N days from enrollment
    • Term: 'T' = term-dictated (the associated term's duration controls this course's duration)

    Supported values: "C", "R", "D", "T"

     

    Educational Pace

    Required:    No

    Unique:    No

    Header:    pace

    Description: Indicates if the Course is Instructor-led or self- paced according to the Student.

    Supported values: "Self", "Instructor"

     

    End Date

    Required:    No

    Unique:    No

    Header:    end_date

    Description: Date on which access to the Course ends.

    Format: yyyymmdd

     

    Enforce Language Pack

    Required:    No

    Unique:    No

    Header:    locale_enforced

    Description: A flag that determines if the language pack is enforced when a user accesses the Course. If the language pack is not enforced, the user may view the Course using their preferred language pack.

    Supported values: 'Y','N'

     

    Enrollment Access Code

    Required:    No

    Unique:    No

    Header:    enroll_access_code

    Description: This is the access code for students to use when enrolling to the course.

    Max length 50.

     

    Enrollment End Date

    Required:    No

    Unique:    No

    Header:    enroll_end

    Description: Date that enrollment is no longer available to Students.

    Format: yyyymmdd

     

    Enrollment Start Date

    Required:    No

    Unique:    No

    Header:    enroll_start

    Description: Date that enrollment may begin.

    Format: yyyymmdd

     

    Enrollment Type

    Required:    No

    Unique:    No

    Header:    enroll_option

    Description: Determines the enrollment method.

    Supported values: "instructor", "self", or "email".

     

    Fee

    Required:    No

    Unique:    No

    Header:    fee

    Description: Fee associated with this Course or Organization.

    Numeric. 11 characters, 2 decimal places. Eg 1500.00

     

    Institution Name

    Required:    No

    Unique:    No

    Header:    institution_name

    Description: The name of the institution.

    Max length 255. Multi byte characters accepted.

     

    Language Pack

    Required:    No

    Unique:    No

    Header:    locale

    Description: Identifier for the preferred language pack. The value is expressed as xx_XX, for example, the French language pack is represented by fr_FR

    Max length 20.

     

    Locked Out

    Required:    No

    Unique:    No

    Header:    lockout_ind

    Description: Indicates if access to the Course or Organization has been restricted. If set to "Y" access to the Course or organization will be restricted based on the END_DATE and START_DATE.

    Supported values: 'Y', 'N'

     

    Maximum disk usage (soft limit)

    Required:    No

    Unique:    No

    Header:    soft_limit

    Description: Soft limit on course quota. This setting triggers warning emails when course folder storage reaches the soft_limit specified and course quotas are in effect.

    Numeric. eg: 10MB would be 10485760 bytes.

     

    Primary Association Batch Uid

    Required:    No

    Unique:    Yes

    Header:    external_association_key

    Description: The external key of the node with which the course should be primarily associated. The course uses that node's tool setting defaults to create its own settings. This is the same field as "external_association_key" from the Course Association feed; except this association is the "primary" one... meaning it will copy its Tool setting defaults on course creation.

    The proper minimum required headers for creating courses that are meant to be associated with an Institutional Hierarchy node are:

    external_course_key

    course_id

    course_name

    external_association_key

    primary_external_node_key

     

    Primary Node Batch Uid

    Required:    No

    Unique:    No

    Header:    primary_external_node_key

    Description: This is the same field as "external_node_key" from the Course Association feed; except this is the primary association.

    The proper minimum required headers for creating courses that are meant to be associated with an Institutional Hierarchy node are:

    external_course_key

    course_id

    course_name

    external_association_key

    primary_external_node_key

    Max length: 256

     

    Replacement Batch Uid

    Required:    No

    Unique:    Yes

    Header:    new_external_course_key

    Description: This field is used only on the rare occasions when a Course's or Organization's EXTERNAL KEY changes.

    Max length 64. Must be unique. Multi byte characters accepted.

     

    Replacement Data Source Batch Uid

    Required:    No

    Unique:    No

    Header:    new_data_source_key

    Description: New key used to establish grouping of user elements. Replaces existing data source associating data with the group designated by the specified replacement data source key. Note: The UI mapping field for Replacement Data Source Batch Uid is 'script.flatfile.CourseReplacementDataSourceBatchUid'

     

    Row Status

    Required:    No

    Unique:    No

    Header:    row_status

    Description: Sets the value of the record to one of the following: Enabled: Normal access to the record. Disabled: Record is visible in some areas of the UI, but may not be changed or accessed. Deleted: Record is scheduled to be removed.

    Supported values: "enabled", "disabled", "deleted"

     

    Show In Catalog

    Required:    No

    Unique:    No

    Header:    catalog_ind

    Description: Establishes whether the Course or Organization appears in catalog.

    Supported values: 'Y', 'N'

     

    Source Course Copy key.Source Organization Copy Key

    Required:    No

    Unique:    No

    Header:    template_course_key.template_organization_key

    Description: External key of content source for copy operations.

    Max length 64. Multi byte characters accepted.

     

    Start Date

    Required:    No

    Unique:    No

    Header:    start_date

    Description: Date on which access to the Course section begins.

    Format: yyyymmdd

     

    Term

    Required:    No

    Unique:    No

    Header:    term_key

    Description: Associated EXTERNAL_TERM_KEY

    Max length 256.

     

    Use Term Availability

    Required:    No

    Unique:    No

    Header:    use_term_availability_ind

    Description: Flag to follow associated TERM for availability of course. If Y then the term for available_ind, startdate, and enddate are used; if N then the course settings are used.

    Supported values: 'Y', 'N'

      TOP

      LEARN Object: Course and Organization Membership

      Courses and Organizations require the same fields. Header will be specific to whether a course or organization is being created — note the differences when constructing data feeds.

      SIS Object: Course or Organization Memberships (Enrollments and Staff Assignments)

      Default Insert/Update behavior: Smart Inserts or Updates

      Default Delete Behavior: Disable

      Learn Fields

      Course Batch Uid or Organization Batch Uid (Required)

      Required:    Yes

      Unique:    No

      Header:    external_course_key or external_organization_key

      Description: This is the same key used to identify the Course or Organization. 

      Max length 64. Multi byte characters accepted.

       

      Data Source Key (Required) Supplied by the integration or the data file.

      Required:    Yes

      Unique:    No

      Header:    data_source_key

      Description: Key used to establish grouping of user elements. Note this may be provided by the integration configuration and thus would not be required in the file.

      Max length 256. Multi byte characters accepted.

       

      User Batch Uid (Required)

      Required:    Yes

      Unique:    No

      Header:    external_person_key

      Description: This is the external_person_key used to identify the user.

      Max length: 64. Multi byte characters accepted.

       

      hasCartridgeAccess

      Required:    No

      Unique:    No

      Header:    hascartridgeaccess

      Description: This field is not supported and targeted for removal. Ignore. New integrations should not use this field if existing integrations utilize this field they should cease to do so.

       

      Available

      Required:    No

      Unique:    No

      Header:    available_ind

      Description: Establishes enrollment availability in Blackboard Learn.

      Supported values: 'Y', 'N'

       

      Image URL

      Required:    No

      Unique:    No

      Header:    Image_URL

      Description: This field is not supported and targeted for removal. Ignore. New integrations should not use this field if existing integrations utilize this field they should cease to do so.

       

      Include In Roster

      Required:    No

      Unique:    No

      Header:    roster_ind

      Description: Flag indicating whether user is displayed in roster.

      Supported values: 'Y', 'N'

       

      Introduction

      Required:    No

      Unique:    No

      Header:    intro

      Description: Introduction information for User Home Page within the Course.

      Max length 4000. Multi byte characters accepted.

       

      Notes

      Required:    No

      Unique:    No

      Header:    notes

      Description: Information pertinent to this user that may impact the course or organization participation.

      Not limited. Multi byte characters accepted.

       

      Personal Information

      Required:    No

      Unique:    No

      Header:    pinfo

      Description: Personal Information for User Home Page.

      Not limited. Multi byte characters accepted.

       

      Receive Email

      Required:    No

      Unique:    No

      Header:    receive_email_ind

      Description: Flag whether email is enabled for this user.

      Supported values: 'Y', 'N'

       

      Replacement Data Source Batch Uid

      Required:    No

      Unique:    No

      Header:    new_data_source_key

      Description: New key used to establish grouping of data elements. Replaces existing data source associating data with the group designated by the specified replacement data source key. Note: The UI mapping field for Replacement Data Source Batch Uid is 'script.flatfile.MemberReplacementDataSourceBatchUid'

       

      Role

      Required:    No

      Unique:    No

      Header:    role

      Description: The user's role in the Course.

      Supported values: "Instructor", "teaching_assistant", "course_builder", "Grader", "Student", "guest", "none"

       

      Row Status

      Required:    No

      Unique:    No

      Header:    row_status

      Description: Sets the value of the record to one of the following: Enabled: Normal access to the record. Disabled: Record is visible in some areas of the UI, but may not be changed or accessed. Deleted: Record is scheduled to be removed.

      Supported values: "enabled", "disabled", "deleted"

       

      Website 1 Description

      Required:    No

      Unique:    No

      Header:    link_description_1

      Description: Description for user website

      Max length 255

       

      Website 1 Name

      Required:    No

      Unique:    No

      Header:    link_name_1

      Description: Name used in link to user website

      Max length 100

       

      Website 1 URL

      Required:    No

      Unique:    No

      Header:    link_url_1

      Description: URL used in link to user website

      Max length 100

       

      Website 2 Description

      Required:    No

      Unique:    No

      Header:    link_description_2

      Description: Description for user website

      Max length 255

       

      Website 2 Name

      Required:    No

      Unique:    No

      Header:    link_name_2

      Description: Name used in link to user website

      Max length 100

       

      Website 2 URL

      Required:    No

      Unique:    No

      Header:    link_url_2

      Description: URL used in link to user website

      Max length 100

       

      Website 3 Description

      Required:    No

      Unique:    No

      Header:    link_description_3

      Description: Description for user website

      Max length 255

       

      Website 3 Name

      Required:    No

      Unique:    No

      Header:    link_name_3

      Description: Name used in link to user website

      Max length 100

       

      Website 3 URL

      Required:    No

      Unique:    No

      Header:    link_url_3

      Description: URL used in link to user website

      Max length 100

        TOP

        LEARN Object: Term

        SIS Object:Term

        Default Insert/Update behavior: Smart Inserts or Updates

        Default Delete Behavior: Disable

        Learn Fields

        Batch Uid (Required)

        Required:    Yes

        Unique:    Yes

        Header:    external_term_key

        Description: Short name used by the Institution to uniquely identify the Term. This is not displayed to users. Can contain only letters, digits, dashes and periods. No spaces or other punctuation allowed..

        Max length 256. Multi byte characters accepted.

         

        Data Source Key (Required) Supplied by the integration or the data file.

        Required:    Yes

        Unique:    No

        Header:    data_source_key

        Description: Key used to establish grouping of Term elements. Note this may be provided by the integration configuration and thus would not be required in the file.

        Max length 256. Multi byte characters accepted.

         

        Name (Required)

        Required:    Yes

        Unique:    No

        Header:    name

        Description: Name of the term.

        Max length 333

         

        daysOfUse

        Required:    No

        Unique:    No

        Header:    days_of_use

        Description: Number of days that Students may access the Course after enrollment. Useful for self-paced learning.

        Numeric.

         

        Available

        Required:    No

        Unique:    No

        Header:    available_ind

        Description: Determines Term availability. If set to 'N', the associated objects will not be available.

        Supported values: 'Y', 'N'

         

        Description

        Required:    No

        Unique:    No

        Header:    description

        Description: Description of the Term

        Not limited.

         

        Duration

        Required:    No

        Unique:    No

        Header:    duration

        Description: Schedules term availability window.

        Options are:

        • Continuous: The Term is always accessible.
        • Range: The Term is valid in the days between one START_DATE and END_DATE. Either the beginning date or the end date can be left open-ended to make a Term valid from a certain date or until a certain date.
        • Fixed: The Term is valid for a set number of days (DAYS_OF_USE). 

        Supported values: Continuous, Range, Fixed

         

        End Date

        Required:    No

        Unique:    No

        Header:    end_date

        Description: This is the date that the term stops to be available to access.

        Format: yyyymmdd

         

        Replacement Batch Uid

        Required:    No

        Unique:    Yes

        Header:    new_external_term_key

        Description: This field is used only on the rare occasions when a terms EXTERNAL KEY changes.

        Max length 256. Multi byte characters accepted.

         

        Replacement Data Source Batch Uid

        Required:    No

        Unique:    No

        Header:    new_data_source_key

        Description: New key used to establish grouping of data elements. Replaces existing data source associating data with the group designated by the specified replacement data source key. Note: The UI mapping field for Replacement Data Source Batch Uid is 'script.flatfile.TermReplacementDataSourceBatchUid'

         

        Row Status

        Required:    No

        Unique:    No

        Header:    row_status

        Description: Sets the value of the record to one of the following:

        • Enabled: Normal access to the record.
        • Disabled: Record is visible in some areas of the UI, but may not be changed or accessed.
        • Deleted: Record is scheduled to be removed.

        Supported values: "enabled", "disabled", "deleted"

         

        Start Date

        Required:    No

        Unique:    No

        Header:    start_date

        Description: This is the date that the term begins to be available to access.

        Format: yyyymmdd

          TOP

          LEARN Object: Secondary Institution Role Association

          SIS Object:User Secondary Institution Role

          Default Insert/Update behavior: Smart Inserts or Updates

          Default Delete Behavior: Disable

          Learn Fields

          Data Source Key (Required) Supplied by the integration or the data file.

          Required:    Yes

          Unique:    No

          Header:    data_source_key

          Description: Key used to establish grouping of user elements. Note this may be provided by the integration configuration and thus would not be required in the file.

          Max length 256. Multi byte characters accepted.

           

          Secondary Institution Role Id (Required)

          Required:    Yes

          Unique:    No

          Header:    role_id

          Description: The identifier for the secondary institution role for this association.

           

          User Batch Uid (Required)

          Required:    Yes

          Unique:    No

          Header:    external_person_key

          Description: The user external_person_key (batch_uid) to be used for this association.

          Max Length 64.

           

          Replacement Data Source Batch Uid

          Required:    No

          Unique:    No

          Header:    new_data_source_key

          Description: New key used to establish grouping of data elements. Replaces existing data source associating data with the group designated by the specified replacement data source key. Note: The UI mapping field for Replacement Data Source Batch Uid is 'script.flatfile.SecondaryInstRoleReplacementDataSourceBatchUid'

           

          Row Status

          Required:    No

          Unique:    No

          Header:    row_status

          Description: Sets the value of the record to one of the following: Enabled: Normal access to the record. Disabled: Record is visible in some areas of the UI, but may not be changed or accessed. Deleted: Record is scheduled to be removed manually by the administrator in the future. The row is not deleted automatically via a task.

          Supported values: "enabled", "disabled", "deleted"

            TOP

            LEARN Object: Observer Association

            SIS Object:Observer Association

            Default Insert/Update behavior: Smart Inserts or Updates

            Default Delete Behavior: Disable

            Learn Fields

            Data Source Key (Required) Supplied by the integration or the data file.

            Required:    Yes

            Unique:    No

            Header:    data_source_key

            Description: Key used to establish grouping of user elements. Note this may be provided by the integration configuration and thus would not be required in the file.

            Max length: 256. Multi byte characters accepted.

             

            Observed Student (Required)

            Required:    Yes

            Unique:    No

            Header:    external_user_key

            Description: The user external_person_key (batch_uid) to be used for this association. A unique identifier for a user with the Institution Role of Student at the institution. This ID is provided by the institution and is not displayed to users.

            Max length 64. Multi byte characters accepted.

             

            Observer (Required)

            Required:    Yes

            Unique:    No

            Header:    external_observer_key

            Description: The observer external_person_key (batch_uid) to be used for this association. A unique identifier for a user with the system role of Observer at the institution.

            Max length 64. Multi byte characters accepted.

             

            Replacement Data Source Batch Uid

            Required:    No

            Unique:    No

            Header:    new_data_source_key

            Description: New key used to establish grouping of data elements. Replaces existing data source associating data with the group designated by the specified replacement data source key. Note: The UI mapping field for Replacement Data Source Batch Uid is 'script.flatfile.AssociateObserverReplacementDataSourceBatchUid'

             

            Row Status

            Required:    No

            Unique:    No

            Header:    row_status

            Description: Sets the value of the record to one of the following: Enabled: Normal access to the record. Disabled: Record is visible in some areas of the UI, but may not be changed or accessed. Deleted: Record is scheduled to be removed.

            Supported values: "enabled", "disabled", "deleted"

              TOP

              LEARN Object: Category

              SIS Object:Course Category

              Default Insert/Update behavior: Smart Inserts or Updates

              Default Delete Behavior: Disable

              Learn Fields

              dataSourceBatchUid (Required)

              Required:    Yes

              Unique:    No

              Header:    data_source_key

              Description: Key used to establish grouping of category elements.

              Multi byte characters accepted.

               

              title (Required)

              Required:    Yes

              Unique:    No

              Header:    title

              Description: The name of the category as it will appear to users within the UI.

              Max length 255. Multi byte characters accepted.

               

              Batch Uid (Required)

              Required:    Yes

              Unique:    Yes

              Header:    external_category_key

              Description: Must be unique. Please note that this field corresponds to the Category Mnemonic field in the UI.

              Max length 64. Multi byte characters accepted.

               

              description

              Required:    No

              Unique:    No

              Header:    description

              Description: Category description.

               

              frontPageInd

              Required:    No

              Unique:    No

              Header:    frontpage_ind

              Description: Determines whether or not the category is displayed on the front page of the catalog.

              Supported values: 'Y', 'N'

               

              isAvailable

              Required:    No

              Unique:    No

              Header:    available_ind

              Description: Establishes category availability within Blackboard Learn.

              Supported values: 'Y', 'N'

               

              isRestricted

              Required:    No

              Unique:    No

              Header:    restrict_ind

              Description: Flag whether Course or Organization is restricted to members.

              Supported values: 'Y', 'N'

               

              parentBatchUid

              Required:    No

              Unique:    No

              Header:    parent_category_key

              Description: The EXTERNAL_CATEGORY_KEY representing the Parent category of which this category is a child.

              Max length 64.

               

              rowStatus

              Required:    No

              Unique:    No

              Header:    row_status

              Description: Sets the value of the record to one of the following: Enabled: Normal access to the record. Disabled: Record is visible in some areas of the UI, but may not be changed or accessed. Deleted: Record is scheduled to be removed. String.

              Supported values: "enabled", "disabled", "deleted"

               

              Replacement Batch Uid

              Required:    No

              Unique:    Yes

              Header:    new_external_category_key

              Description: Designates replacement for the current key.

              Max length 64. Multi byte characters accepted.

               

              Replacement Data Source Batch Uid

              Required:    No

              Unique:    No

              Header:    new_data_source_key

              Description: New key used to establish grouping of data elements. Replaces existing data source associating data with the group designated by the specified replacement data source key. Note: The UI mapping field for Replacement Data Source Batch Uid is 'script.flatfile.CourseCatReplacementDataSourceBatchUid'

                TOP

                LEARN Object: Category Membership

                SIS Object: Category Membership

                Default Insert/Update behavior: Smart Inserts or Updates

                Default Delete Behavior: Disable

                Learn Fields

                Batch Uid (Required)

                Required:    Yes

                Unique:    Yes

                Description: Auto populated. Do not use in data feeds.

                 

                Category Batch Uid (Required)

                Required:    Yes

                Unique:    No

                Header:    external_category_key

                Description: The EXTERNAL KEY (batch_uid) for the category to which to add the course/organization.

                Max Length 64.

                 

                Course Batch Uid or Organization Batch Uid (Required)

                Required:    Yes

                Unique:    No

                Header:    external_course_key

                Description: external_organization_key The EXTERNAL KEY (batch_uid) for the course or organization being categorized.

                Max Length 64.

                 

                Data Source Key (Required) Supplied by the integration or the data file.

                Required:    Yes

                Unique:    No

                Header:    data_source_key

                Description: Key used to establish grouping of user elements. Note this may be provided by the integration configuration and thus would not be required in the file.

                Multi byte characters accepted.

                 

                Is Available

                Required:    No

                Unique:    Yes

                Header:    available_ind

                Description: Establishes category availability within Blackboard Learn.

                Supported values: 'Y', 'N'

                 

                Replacement Data Source Batch Uid

                Required:    No

                Unique:    No

                Header:    new_data_source_key

                Description: New key used to establish grouping of data elements. Replaces existing data source associating data with the group designated by the specified replacement data source key. Note: The UI mapping field for Replacement Data Source Batch Uid is 'script.flatfile.CourseCatMemReplacementDataSourceBatchUid'

                 

                Row Status

                Required:    No

                Unique:    No

                Header:    row_status

                Description: Sets the value of the record to one of the following: Enabled: Normal access to the record. Disabled: Record is visible in some areas of the UI, but may not be changed or accessed. Deleted: Record is scheduled to be removed.

                Supported values: "enabled", "disabled", "deleted"

                  TOP

                  LEARN Object: Hierarchy Node

                  SIS Object: Hierarchy Node

                  Default Insert/Update behavior: Smart Inserts or Updates

                  Default Delete Behavior: Purge

                  Learn Fields

                  These are the minimum required headers for creating an Institutional Hierarchy node:

                  • external_node_key
                  • data_source_key
                  • parent_node_key
                  • name

                  Batch Uid (Required)

                  Required:    Yes

                  Unique:    Yes

                  Header:    external_node_key

                  Description: Identifier used by the Institution to uniquely identify the hierarchy node. This is not displayed to users. Can contain only letters, digits, dashes and periods. No spaces or other punctuation allowed.

                  Max length 255. Multi byte characters accepted.

                   

                  Data Source Key (Required) Supplied by the integration or the data file.

                  Required:    Yes

                  Unique:    No

                  Header:    data_source_key

                  Description: Key used to establish grouping of user elements. Note this may be provided by the integration configuration and thus would not be required in the file.

                  Max length 255. Multi byte characters accepted.

                   

                  Parent Batch Uid (Required)

                  Required:    Yes

                  Unique:    No

                  Header:    parent_node_key

                  Description: Parent external_node_key (batch uid) for this node.

                  Max length 64.

                   

                  Name (Required)

                  Required:    Yes

                  Unique:    No

                  Header:    name

                  Description: Node name

                  Max length: 255

                   

                  Description

                  Required:    No

                  Unique:    No

                  Header:    description

                  Description: Description of the node

                  Max length: 1000.

                   

                  Replacement Batch Uid

                  Required:    No

                  Unique:    Yes

                  Header:    new_external_node_key

                  Description: This field is used only on the rare occasions when a Node's EXTERNAL KEY changes.

                  Max length 255. Must be unique. Multi byte characters accepted.

                   

                  Replacement Data Source Batch Uid

                  Required:    No

                  Unique:    No

                  Header:    new_data_source_key

                  Description: New key used to establish grouping of data elements. Replaces existing data source associating data with the group designated by the specified replacement data source key. Note: The UI mapping field for Replacement Data Source Batch Uid is 'script.flatfile.NodeReplacementDataSourceBatchUid'

                    TOP

                    LEARN Object: Hierarchy User Association

                    SIS Object: User Association

                    Default Insert/Update behavior: Smart Inserts or Updates

                    Default Delete Behavior: Purge

                    Learn Fields

                    The minimum required headers for associating users to an Institutional Hierarchy node are:

                    • external_user_key
                    • external_node_key
                    • external_association_key
                    • data_source_key

                    Data Source Key (Required) Supplied by the integration or the data file.

                    Required:    Yes

                    Unique:    No

                    Header:    data_source_key

                    Description: Key used to establish grouping of user elements. Note this may be provided by the integration configuration and thus would not be required in the file.

                    Max length 255. Multi byte characters accepted.

                     

                    Batch Uid (Required)

                    Required:    Yes

                    Unique:    Yes

                    Header:    external_association_key

                    Description: The association id, which is the unique identifier of the user to node association.  Often a concatenation of the User Batch Uid and Node Batch Uid values to ensure uniqueness when a user can be assigned to more than one node.

                    Max length 64.

                     

                    Node Batch Uid (Required)

                    Required:    Yes

                    Unique:    No

                    Header:    external_node_key

                    Description: The node for this association, which is also the Node Identifier which can be found in the 'Edit Node' area in the GUI

                    Max length: 64.

                     

                    User Batch Uid (Required)

                    Required:    Yes

                    Unique:    No

                    Header:    external_user_key

                    Description: The user external_person_key (batch_uid) to be associated with this node.

                    Max length: 64.

                     

                    Replacement Batch Uid

                    Required:    No

                    Unique:    Yes

                    Header:    new_external_association_key

                    Description: This field is used only on the rare occasions when an association's EXTERNAL KEY changes.

                    Max length 64. Multi byte characters accepted.

                     

                    Replacement Data Source Batch Uid

                    Required:    No

                    Unique:    No

                    Header:    new_data_source_key

                    Description: New key used to establish grouping of data elements. Replaces existing data source associating data with the group designated by the specified replacement data source key. Note: The UI mapping field for Replacement Data Source Batch Uid is 'script.flatfile.UserAssociationReplacementDataSourceBatchUid'

                     

                     

                    TOP

                    LEARN Object: Hierarchy Course Association

                    SIS Object: Course Association

                    Default Insert/Update behavior: Smart Inserts or Updates

                    Default Delete Behavior: Purge

                    Learn Fields

                    The minimum required headers for associating courses to an Institutional Hierarchy node are:

                    • external_course_key
                    • external_node_key
                    • external_association_key
                    • data_source_key

                    Batch Uid (Required)

                    Required:    Yes

                    Unique:    Yes

                    Header:    external_association_key

                    Description: The association id.

                    Max length 64.

                     

                    Course Batch Uid (Required)

                    Required:    Yes

                    Unique:    No

                    Header:    external_course_key

                    Description: The course external_course_key (batch_uid) to be associated with this node.

                    Max length 64.

                     

                    Data Source Key (Required) Supplied by the integration or the data file.

                    Required:    Yes

                    Unique:    No

                    Header:    data_source_key

                    Description: Key used to establish grouping of elements. Note this may be provided by the integration configuration and thus would not be required in the file.

                    Max length 255. Multi byte characters accepted.

                     

                    Node Batch Uid (Required)

                    Required:    Yes

                    Unique:    No

                    Header:    external_node_key

                    Description: The node for this association.

                    Max length 64. Multi byte characters accepted.

                     

                    Primary Association Indicator

                    Required:    No

                    Unique:    No

                    Header:    is_primary_association

                    Description: Flag designating this association as the primary association when others may be specified.

                    Supported values: 'Y', 'N'.

                     

                    Replacement Batch Uid

                    Required:    No

                    Unique:    Yes

                    Header:    new_external_association_key

                    Description: This field is used only on the rare occasions when an association's EXTERNAL KEY changes.

                    Max length 64. Multi byte characters accepted.

                     

                    Replacement Data Source Batch Uid

                    Required:    No

                    Unique:    No

                    Header:    new_data_source_key

                    Description: New key used to establish grouping of data elements. Replaces existing data source associating data with the group designated by the specified replacement data source key. Note: The UI mapping field for Replacement Data Source Batch Uid is 'script.flatfile.CourseAssociationReplacementDataSourceBatchUid'

                     

                    TOP

                    LEARN Object: Goal Association

                    SIS Object: Goal Association

                    Default Insert/Update behavior: Smart Inserts or Updates

                    Default Delete Behavior: Purge

                    Learn Fields

                    Batch Uid (Required)

                    Required:    Yes

                    Unique:    Yes

                    Header:    This has no header, it is auto populated. Ignore in integration feeds.

                    Description: A unique identifier for the relationship between the course and the goal (standard).

                    Max length 64.

                     

                    Course Batch Uid (Required)

                    Required:    Yes

                    Unique:    No

                    Header:    course_key

                    Description: The unique identifier (external_course_key) for the course to which the goal (standard) will be associated

                    Max length 64.

                     

                    Data Source Key (Required) Supplied by the integration or the data file.

                    Required:    Yes

                    Unique:    No

                    Header:    data_source_key

                    Description: Key used to establish grouping of user elements. Note this may be provided by the integration configuration and thus would not be required in the file.

                    Max length 255. Multi byte characters accepted.

                     

                    Sub Goal Set (Required)

                    Required:    Yes

                    Unique:    No

                    Header:    std_sub_doc_key

                    Description: The unique identifier for the goal (standard) to associate to a course.

                    Max length 64.

                     

                    Replacement Data Source Batch Uid

                    Required:    No

                    Unique:    No

                    Header:    new_data_source_key

                    Description: New key used to establish grouping of data elements. Replaces existing data source associating data with the group designated by the specified replacement data source key. Note: The UI mapping field for Replacement Data Source Batch Uid is 'script.flatfile.GoalAssociationReplacementDataSourceBatchUid'