Certica Products

Provisioning CertifyCALPADS

Updated Mar 24, 2021

Provisioning CertifyCALPADS 

Provision CertifyCALPADS by selecting the CertifyCALPADS project in Certify California Instance for districts that are in CA.   Use an existing district as a model for names and descriptions of observation schedules, notification groups, and notification definitions.

1. In Certify NextGen, Enable the CertifyCALPADS Project and the following Observations:

CertifyCALPADS End of Year - District Validation

CertifyCALPADS End of Year - School Validation

CertifyCALPADS Staff Records Validation

CertifyCALPADS Student Course - District Validation

CertifyCALPADS Student Course - School Validation

CertifyCALPADS Student Records - District Validation

CertifyCALPADS Student Records - School Validation

Optionally, you may also enable:

CertifyCALPADS Student Records - School Validation (No SPRG)

CertifyCALPADS Student Records - School Validation (No SPRG, No SELA)

CertifyCALPADS English Language Learner (ELL)

CertifyCALPADS Special Education

2. Add district’s NCES_LEA_ID, District and individual School values to Reporting Configuration using School document.

    a. Administration>Report Configuration. Set Select Project: to CertifyCALPADS.  Set Variable to: NCES LEA ID.  

    b. Click Add.   Enter the district's NCES LEA ID into Value, and the district name into Description.  Click the green checkmark to save.

    c. Set Variable to: District

    d. Click Add.   Enter the district's ID (see step 1 above) into Value, and the district name into Description.  Click the green checkmark to save.

    To add the schools manually:

    e. Select the new NCES LEA ID row in the first list.  In the second list, set Variable: to School

    f. Click Add.  Enter the school code in Value, and the school name in Description

    g. Repeat for each school

    Optionally, to add the schools from the database, run this script (skip steps e-g above):

--this inserts the schools and the ALL - All district schools

    declare @vNcesleaid varchar(7) = '0625770' --district's ncesleaid

    select * from REPORT_CONFIG_VAR_MAPPING r 

    where r.PROJECT_ID = (select ID from CA_CertifyRepository..PROJECTS where NAME like 'CertifyCALPADS%' and STATUS = 1)

    and r.VARIABLE_ID = (select ID from CA_CertifyRepository..VARIABLES where project_id = (select ID from CA_CertifyRepository..PROJECTS where NAME like 'CertifyCALPADS%' and STATUS = 1) 

    and name = 'Var_SCH')

    and r.PARENT_ID = (select ID from REPORT_CONFIG_VAR_MAPPING where project_id = (select ID from CA_CertifyRepository..PROJECTS where NAME like 'CertifyCALPADS%' and STATUS = 1)  

    and variable_value = @vNcesleaid) 

    begin tran

    --insert schools

    INSERT INTO REPORT_CONFIG_VAR_MAPPING (PROJECT_ID,VARIABLE_ID,VARIABLE_VALUE,VARIABLE_LABEL,PARENT_ID) 

    SELECT PROJECT_ID=(select ID from CA_CertifyRepository..PROJECTS where NAME like 'CertifyCALPADS%' and STATUS = 1),

        VARIABLE_ID=(select ID from CA_CertifyRepository..VARIABLES where project_id = (select ID from CA_CertifyRepository..PROJECTS where NAME like 'CertifyCALPADS%' and STATUS = 1) and name = 'Var_SCH'),

        VARIABLE_VALUE=right(s.cdscode,7), VARIABLE_LABEL=s.School,

        PARENT_ID=(select ID from REPORT_CONFIG_VAR_MAPPING where project_id = (select ID from CA_CertifyRepository..PROJECTS where NAME like 'CertifyCALPADS%' and STATUS = 1) and variable_value = @vNcesleaid)

    from CertifyCALPADS..CDE_PUBLIC_SCHOOLS s

    where s.NCESDist = @vNcesleaid

    and statustype = 'active'

    and school is not null

    --insert ALL - All district Schools

    INSERT INTO REPORT_CONFIG_VAR_MAPPING (PROJECT_ID,VARIABLE_ID,VARIABLE_VALUE,VARIABLE_LABEL,PARENT_ID) 

    SELECT PROJECT_ID=(select ID from CA_CertifyRepository..PROJECTS where NAME like 'CertifyCALPADS%' and STATUS = 1),

        VARIABLE_ID=(select ID from CA_CertifyRepository..VARIABLES where project_id = (select ID from CA_CertifyRepository..PROJECTS where NAME like 'CertifyCALPADS%' and STATUS = 1) and name = 'Var_SCH'),

        VARIABLE_VALUE='ALL', VARIABLE_LABEL='All District Schools',

        PARENT_ID=(select ID from REPORT_CONFIG_VAR_MAPPING where project_id = (select ID from CA_CertifyRepository..PROJECTS where NAME like 'CertifyCALPADS%' and STATUS = 1) and variable_value = @vNcesleaid)

    --commit

    --rollback

3. Create data upload folder on DB server for district

    a. RDP into PROD-CRL-DB (10.0.1.25)

    b. Create a new folder at path D:\CALPADS\Uploaded Files using the district’s NCESLEAID 

    c. Save a notepad file in the new folder with the district’s name

    d. Log onto CertifyCALPADS File Loader with Certify Admin account at URL -https://www.certifymydata.com/CALPADSLoader/ 

    e. Users>Edit Set your test account with the new district's NCESLEAID.  Click Update User

    f. Log out and log back in with test account.

    g. Upload New Files>Browse to select upload files sent by district.  Click Upload Files. Files uploaded will appear on Uploaded File List page

    h. Review results when email notification arrives (usually in about 15 min.)

4. Upload sample files and review results.

5. Add the District (and possibly school) users when survey returned

    a. Review provisioning document.

    b. In Certify NextGen, update any existing users with CALPADS variables that they want to receive notifications now

    c. Add new Certify users with CALPADS variables that they want to receive notifications now

    d. Add the users approved to upload files on survey for to Certify CALPADS File Loader

        i. Log onto CertifyCALPADS File Loader with Certify Admin account at URL: https://www.ca-admin.certifymydata.com/CALPADSLoader/ 

        ii. Select Users link on the home screen

        iii. Select desired user to add to loader from User drop down list

        iv. Edit user to change default NCESLEAID value to the district’s NCESLEAID value

Previous Article Playbook for when a Certify Administrator leaves
Next Article Re-run ETL Process