SalamanderSoft - ASM sync - what is the personid?

[Bev]

I am using SalamanderSoft to generate CSV files for AppleSchoolManager. It is giving each student a unique number but it's not a number I recognise.

Due to having previously setup my ASM using the UPN, I need to change this number to the UPN and I had assumed it was the Admission Number from SIMS, but it's not. Is it in SIMS or is it just a random number generated by Salamander?

[Jamman960]

It’s their sims code I believe but it’s not accessible from the ui, at the same time it appears to be generated prior to admission which saves some headaches

 

I started off using admission numbers so have to use vlookup to match salamanders output to what’s in ASM

[Bev]

That's what I am doing (Vlookup), i was just hoping to generate a report of the SIMS code and UPN but I don't seem to be able to access it.

[synaesthesia]

It's literally [person_id] in the sims DB but as was mentioned, inaccessible from the UI unless it's buried deep somewhere.

[5tu]

You can get it direct from SQL if you have access to sql management studio....

 

SELECT [person_id],[unique_pupil_no] FROM [sims].[sims].[stud_student] WHERE [current_roll_mode]='On Roll'

Edited September 7, 2020 by gybe78

[3s-gtech]

Is it available from Reports, under the Student category? There’s a Third Party Reporting category, and another further down - these seem to spit out the same ID number as Salamander. Been using that today to trace a student in the SDS logs.

[jemal]

Yep same as 3s-gtech above, you can get it from SIMS reports (although there might be an issue of permissions if you don't see them). Both Staff and Students should have a group of ThirdPartyFields that'll include it, and Students also have a proper field in the root of the report design field list also called person_id. If you have to have a list of both students and staff, it seems to be the preferred ID field in several systems we use.

[synaesthesia]

Yep same as 3s-gtech above, you can get it from SIMS reports (although there might be an issue of permissions if you don't see them). Both Staff and Students should have a group of ThirdPartyFields that'll include it, and Students also have a proper field in the root of the report design field list also called person_id. If you have to have a list of both students and staff, it seems to be the preferred ID field in several systems we use.

 

Can you screenshot those areas for us please? This is useful to know and I can't find either instance of a 3rd party reporting group in reports nor person_id anywhere else in reporting

[Bev]

I can't see Third Party or person_id either. I will get the school business manager to have a look as she has the highest permissions, but I can usually see most things for pupils if not for staff.

[jemal]

Yep screenshot of the student field list in this post with the 2 fields that can be used. Sorry I don't know specifics of my SIMS permissions, just that it's quite high but not as high as the couple of people here with full SIMS rights. I don't have access to sensitive personnel data or able to change some basic employee fields, so there should be no reason to need full sims access to see this. If you use Salamander to sync with local AD, I think you might have an employee ID field in AD attributes (or something similar) that matches this field in SIMS.

[synaesthesia]

Those have been added in by something 3rd party (or indeed a Capita addon looking at CES) so not something that is stock on SIMS.

[Steve21]

They've been in every school I've been at in the past. Also are included in most Capita documentation

 

You sure it's not just that your account doesn't have TPreporting permissions enabled?

 

Steve

[3s-gtech]

They’re standard fields in SIMS (ours has no add-ons at all). You need the Third Party Reporting permission setting via System Manager, then it’ll appear.

[synaesthesia]

They've been in every school I've been at in the past. Also are included in most Capita documentation

 

You sure it's not just that your account doesn't have TPreporting permissions enabled?

 

Steve

 

Ah, would you look at that. There's me thinking that being the all singing, all dancing admin, I'd already have that! Never mind, just add to my own permissions and indeed it's there!

Fankoo!