Show:
SIF Specification
Common Cases
Databases
Customers
Miscellaneous
100
What is the latest version of the SIF specification?
3.0
100
A customer just downloaded and ran the PS agent exe from PowerSource. Upon finishing the manual update they launch the agent and there are now no zones in the agent. They restarted the agent console and service, but the zones still do not appear. What is the problem and solution?
They installed in a new location and created a second instance.
100
What does SQL stand for?
Structured Query Language
100
What is the phone number and email address to contact our support team?
1-877-790-1261 X2 dssupport@pearson.com or datasolutionsupport@pearson.com
100
What run command opens Window's services?
Services.msc
200
Is it Race or is it Ethnicity that is used in SIF 1.5r1?
Ethnicity
200
An Oklahoma user calls in because their white students don’t show their ethnicity code in the Wave, but they can see in DDE that they do in fact have data populated. All non-white students have no problems. What is the cause of the problem?
The valueset is not translating properly, and is set to suppress unrecognized values. (Typically "C" is in use rather than "W").
200
In the PowerSchool database, what is the table name of the inbound and outbound queue?
Outbound - AppEventsQeueu Inbound - SIFEventsQueue
200
Who is the main contact for TRECA?
Jennifer Schmidt
200
What does dsa.msc open in a run command?
It opens Active Directory "Users and Computers"
300
What race code is used for Asian?
0999
300
At what point does student data get put into the reports table for VRF? A) After the collection B) After the Prepare C) After the Submission D) As SIF events are received and processed
B - After the prepare is ran
300
What SQL command is used to return only different values (remove duplicates).
DISTINCT: SELECT DISTINCT column_name,column_name FROM table_name;
300
What district does Hattie Leary work at?
Anoka Hennepin
300
Adam needs to look at the data in SQL 2008 for a customer. He installs SQL but can't find or use SQL Management Express anywhere after the install. What did he do wrong?
He didn't install SQL Server Express WITH TOOLS.
400
What is the biggest change regarding the ZIS in SIF 3.0?
There is no longer a need for a ZIS.
400
What is the problem/fix to this error: [SIFEventsQueue Reader] INFO com.pearson.powerschool.pisa.PisaFactory - PISA server URL: 'http://example.powerschool.com:80/pisa/'
The PISA server is not responding. Write backs will not work.
400
What are the three types of databases the ZIS can use in the database configuration settings?
Embedded SQL Derby
400
How many Premium customers do we currently have?
48
400
How do you access a hidden network share?
\\ Server Address \ Drive Letter $
500
In Oklahoma there are three graduation fields. How is each one different from the other?
Scheduled Graduation year: When a student will graduate if they graduate on time. Projected Graduation year: When a student will actually graduate. OK Graduation Date: A custom field for graduation the Wave uses to determine actual graduation.
500
What is the path of for the adapter jar file?
%:\Program Files\PowerSchool\application\components\powerschool-core-[version number]\WEB-INF\lib\bundles\ext
500
Which of the three are real SQL tables for SDM? SifSchools SifStudentPersonal SifStudentRefIds SifEnrollment ADEventData SDMEventData
SifSchools SifEnrollment ADEventData
500
How do you spell the last name for Carla S. (Iowa DOE state contact)
Schimelfenig
500
What port is used to access the AIR SIF agent console?
7007