Updating Staff Records from Employee Forms

Data can be pulled from the questions in the Web Form attached to an Employee Form directly into a staff member's Record.   Various built-in fields can be updated based on the Question's Answer Type.  This scheme results in the direct updating of staff record fields based on the staff member's "raw" responses to the questions.  

The Answer Types that can have linked built-in fields that can be updated include:

• Check - Single checkmarks
• Date - Single Dates
• Generic Codes - Selecting a Generic Code Set (i.e. a Codes table)
• Text Box - Capturing a line of text

Each of these Answer Types has a fixed, hardwired set of built-in fields that it is possible to pull answers into. 

These Questions MUST have a "CODE" specified in their CODE field.  For existing Questions, their Code field is found on the Setup→Web Forms→Modify Web Form→Questions screen:

When adding a new Question, the Code field appear as the second field on the "Add Question" dialog:

Note that the Code is updated only when the Question is first added or on the Questions screen.  It does not appear on the inner "Modify Question" screen.

Check Answer Type

The following set of built-in Boolean (true/false) fields is selectable from the "Store Result when form is complete in this Staff field" drop down when "Check" is the selected Answer Type:

• applicant
• approveAdminGoalFormDirectEntry
  
• approvesAdminGoalForm
  
• approveSGOForms
  
• approveSGOFormsDirectEntry
  
• budgetLogFundsExempt
  
• bugetManager
  
• canViewHistoricalObservations
  
• certificationStatus
  
• directEntryOwnSGOForms
  
• dontCalcYearsinLEAFromContrStart
  
• editPDPMassCreates
  
• emailSuperObserver
  
• enterSSPinPortal
  
• ethnicity
  
• evalAdmin
  
• evalAdminOnlyForSchool
  
• excludeFromAttendanceImport
  
• excludeFromPayroll
  
• exlcudeFromThirdParty
  
• fillsAdminGoalForm
  
• fillsSGOForm
  
• flag504Coordinator
  
• flagAdministrator
  
• flagAide
  
• flagCaseManager
  
• flagCounselor
  
• flagDisciplinarian
  
• flagLibraryAdministrator
  
• flagLongTermSubstitute
  
• flagNurse
  
• flagOtherStaff
  
• flagPrincipal
  
• flagRelatedServiceProvider
  
• flagResigned
  
• flagResourceTeacher
  
• flagRetired
  
• flagSecretary
  
• flagSubstitute
  
• flagSuperintendent
  
• flagSupervisor
  
• flagTeacher
  
• flagVicePrincipal
  
• giftedAndTalented
  
• includeinactiveinNJSMART
  
• includeinNJSMART
  
• listObservationsAcross
  
• massAssignHoursOnlySchool
  
• massSignObsAsDirector
  
• massSignObsAsPrincipal
  
• massSignObsAsSuperintendent
  
• massSignPDPsAsPrincipal
  
• massSignPDPsSupervisor
  
• newHire
  
• observationMaintenanceAccess
  
• observationStatusAccess
  
• observer
  
• observerStatusAccess
  
• onlyUnsignUntilStaffSigns
  
• overrideSummativeRating
  
• payrollVerified
  
• pdWorkshopAdministrator
  
• raceAmericanIndian
  
• raceAsian
  
• raceBlack
  
• racePacific
  
• raceWhite
  
• seeOtherRubricScoresWhileScoring
  
• showCertifications
  
• subBudgetManager
  
• submitRequisitionWithoutAccounts
  
• superObserver
  
• thirdPartyContractee
  
• unsignAdminGoals
  
• unsignObservations
  
• unsignObservationsNotProcessAdmin
  
• unsignSGOs
  
• viewNJSMART
  
•  volunteer

Date Answer Type

When the Date Answer Type is selected, the "Store Result when form is complete in this Staff field" drop down is populated with the following possible built-in date fields:

• alienExpirationDate
  
• boeAppointedDate
  
• contractualEndDate
  
• dateOfBirth
  
• dateOfHire
  
• dateOfHireChatper44
  
• dateofPermAppointed
  
• dateofReHire
  
• dateOfTempAppointed
  
• fingerPrintsCertified
  
• fingerPrintsTaken
  
• nationalBoardAward
  
• onboardingOpenUntil
  
• outsideDistrictDateofHire
  
• projectedTenureDate

Text Box Answer Type

These are the fields that can be updated via the Text Box Answer Type (i.e. the contents of the "Store Result when form is complete in this Staff field" when Text Box is the answer type):

• citizenStatusCode
  
• createdByGenAssistName
  
• createdBySessionId
  
• createdByTaskCode
  
• createdip
  
• currentAttendanceCalendar
  
• eeo5ClassCode
  
• employmentStatus
  
• evaluationOfStaff
  
• exceptionalSalary
  
• extraData
  
• firstName
  
• formerName
  
• genderCode
  
• genderCodeNJSMART
  
• highestLevelOfEducationCompleted
  
• jobTitleCode
  
• langaugeSpokenByTeacher
  
• lastName
  
• lastUpdatedGenAssistName
  
• lastUpdatedip
  
• lastUpdatedSessionId
  
• lastUpdatedTaskCode
  
• LEPInstructorCredentialType
  
• longevityCategoryCode
  
• maritalStatusCode
  
• MEPSessionType
  
• middlename
  
• migrantEducationProgramStaffCategory
  
• ssid
  
• ssn
  
• staffid
  
• StatIDNumber
  
• SufficCode
  
• swipeId
  
• title
  
• titleProgramStaffCategory 
• unionEligibleCode

Generic Code Answer Type

Populating a Codes Table-Linked Staff Record Field

• alternateRouteProgram
  
• categoryCode
  
• categoryCode2
  
• citizenStatusCode
  
• eeo5ClassCode
  
• employmentStatus
  
• evalutionOfStaff
  
• exceptionalSalary
  
• genderCode
  
• genderCodeNJSMART
  
• highestLevelOfEducationCompleted
  
• jobTitleCode
  
• langaugeSpokenByTeacher
  
• LEPInstructorCredentialType
  
• maritalStatusCode
  
• MEPSessionType
  
• migrantEducationProgramStaffCategory
  
• prevfixCode
  
• prepProgram
  
• SEProgramContractedServicesCategory
  
• suffixCode
  
• title1ProgramStaffCategory
  
• unionEligibleCode