Room Numbers and Effective Dates

Room Numbers and Effective Dates

Room Numbers and Effective Dates

A note about room numbers and effective dates

Each room record has a unique SISKey (ID). The room number is part of the room record’s SISKey, along with the campus and building. For example, the SISKey for room 100 in the Jones building on the Main campus would be Main_Jones_100. Using this SISKey we can accurately match up imported room assignments where only the campus, building, and room are provided.

When effective dated changes are made, the new, effective dated version of the room is still part of the original room. There is only one SISKey value for the record, and it does not automatically change when an effective dated change is applied. If the room number is changed as part of an effective dated update, the SISKey still retains the original record’s room number. If you expect to be able to import room assignments using the new room number, you must also edit the room’s SISKey value to reflect the new number. You cannot import room assignments using both versions of the room number.

What this means

Scenario: Jones 100 on the Main campus (Main_Jones_100) becomes Jones 100A as of a certain date.

If this room is only manually scheduled for activities in Astra Schedule, the SISKey is not relevant for imports, and effective dated scheduling capability works as usual.

If activities must be imported into Astra Schedule with the new version of the room pre-assigned, then the SISKey value for the room in question MUST be edited to reflect the new room number. The old room number will no longer be supported for imported assignments.

If activities must be imported into Astra Schedule with both the old and new room number assigned (depending on when the activity is occurring), then a new room MUST be created to represent the new room number. Effective dating does not accommodate this scenario.