Skip to content

Instantly share code, notes, and snippets.

@nifl

nifl/gist:4112911

Created November 19, 2012 19:02
Show Gist options
  • Save nifl/4112911 to your computer and use it in GitHub Desktop.
Save nifl/4112911 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
<!---
Name: intake_xml.cfm
Author: Gernot Bartels
Description: Intake Application cfsavecontent object
Returns new record or update data.
History: Created
Usage: Surveys, Intake,
Created: 2012-09-05
Updated: 2012-10-15
--->
<cfsavecontent variable="qb_xml">
<cfoutput>
<qdbapi>
<cfswitch expression="#access#">
<cfcase value="intake_new">
<field fid="11">#created_on#</field>
<field fid="352">#ace_id#</field><!--- Related Student --->
<field fid="#college_fid#">#college_id#</field><!--- Related College --->
<field fid="13">#FORM.term#</field>
<field fid="322">#FORM.version#</field>
<field fid="#uField#">#FORM.response_id#</field><!--- query --->
<!--- ACEID fields --->
<field fid="211">#FORM.college#</field>
<field fid="14"><![CDATA[#FORM.first_name#]]></field>
<field fid="16"><![CDATA[#FORM.last_name#]]></field>
<field fid="32">#birth_date#</field>
<field fid="34">#FORM.gender#</field>
<!--- Cohort --->
<field fid="307">#FORM.cohort#</field>
<field fid="342"><![CDATA[#FORM.cohortOther#]]></field>
</cfcase>
<cfcase value="intake_update1" >
<!--- BEthnicity --->
<field fid="35"><![CDATA[#FORM.ethnicity#]]></field>
<field fid="343"><![CDATA[#FORM.otherEthnicity#]]></field>
<field fid="36">#FORM.isEng1stLang#</field>
<field fid="37"><![CDATA[#FORM.langFirst#]]></field>
<field fid="38"><![CDATA[#FORM.langFather#]]></field>
<field fid="39"><![CDATA[#FORM.langMother#]]></field>
<!--- CParents --->
<field fid="40">#FORM.isParAgWorker#</field>
<field fid="41">#agFather#</field> <!--- checkbox --->
<field fid="42"><![CDATA[#FORM.jobFather#]]></field>
<field fid="43">#agMother#</field> <!--- checkbox --->
<field fid="44"><![CDATA[#FORM.jobMother#]]></field>
<field fid="45">#FORM.isParImmi#</field>
<field fid="46"><![CDATA[#FORM.countryFather#]]></field>
<field fid="47"><![CDATA[#FORM.countryMother#]]></field>
<!--- DFamily --->
<field fid="48">#FORM.marital#</field>
<field fid="49">#FORM.isPreg#</field>
<field fid="50">#FORM.isChildren#</field>
<field fid="51"><![CDATA[#FORM.numChildren#]]></field>
<!--- EGoals --->
<field fid="52"><![CDATA[#FORM.reasEnroll#]]></field>
<field fid="53"><![CDATA[#FORM.edGoal#]]></field>
<field fid="54"><![CDATA[#FORM.jobGoal#]]></field>
<field fid="344"><![CDATA[#FORM.otherEdGoal#]]></field>
<field fid="345"><![CDATA[#FORM.otherJobGoal#]]></field>
<!--- FEducationalHistory --->
<field fid="55">#FORM.isReentry#</field>
<field fid="56">#FORM.isAttendColl#</field>
<field fid="57">#FORM.whenAttend#</field>
<field fid="58">#FORM.isCurrent#</field>
<field fid="59">#FORM.isAcadProbation#</field>
<!--- CurrentSchool --->
<field fid="60"><![CDATA[#FORM.currSchLvl#]]></field>
<field fid="347"><![CDATA[#FORM.otherSchLvl#]]></field>
<field fid="61"><![CDATA[#FORM.currSchLoc#]]></field>
<!--- Timeawayfromschool --->
<field fid="62">#FORM.schTimeAway#</field>
<field fid="64">#FORM.isHSGrad#</field>
<field fid="65"><![CDATA[#FORM.hsName#]]></field>
<field fid="66"><![CDATA[#FORM.yearGrad#]]></field>
<field fid="67"><![CDATA[#FORM.schLastYear#]]></field>
<field fid="69">#FORM.schGrade#</field>
<field fid="68"><![CDATA[#FORM.schName#]]></field>
<field fid="70">#FORM.isGed#</field>
<field fid="71">#FORM.IsCAHSEEtake#</field>
<field fid="72">#FORM.IsCAHSEEpass#</field>
<field fid="73"><![CDATA[#FORM.yesGed#]]></field>
<field fid="331"><![CDATA[#FORM.noGed#]]></field>
<field fid="74">#FORM.isAltHs#</field>
<field fid="75"><![CDATA[#FORM.altHsName#]]></field>
<field fid="76"><cfif isDate(FORM.altFrom)>#altFrom#</cfif></field>
<field fid="77"><cfif isDate(FORM.altTo)>#altTo#</cfif></field>
<field fid="78">#FORM.isMigEd#</field>
<field fid="79">#FORM.isSpecEd#</field>
<field fid="80">#FORM.isDiffLearn#</field>
<field fid="81">#FORM.isDisLearn#</field>
<!--- ParentsEducation --->
<field fid="82">#fatherEle#</field>
<field fid="83">#fatherJH#</field>
<field fid="84">#fatherHS#</field>
<field fid="85">#fatherColl#</field>
<field fid="86">#fatherNS#</field>
<field fid="87">#motherEle#</field>
<field fid="88">#motherJH#</field>
<field fid="89">#motherHS#</field>
<field fid="90">#motherColl#</field>
<field fid="91">#motherNS#</field>
<field fid="92">#FORM.isFamGrad#</field>
<field fid="311">#gradFather#</field>
<field fid="312">#gradMother#</field>
<field fid="313">#gradSister#</field>
<field fid="314">#gradBrother#</field>
<field fid="315">#gradOther#</field>
<field fid="346"><![CDATA[#FORM.otherFamGrad#]]></field>
<field fid="336">#FORM.degFather#</field>
<field fid="337">#FORM.degMother#</field>
<field fid="338">#FORM.degSister#</field>
<field fid="339">#FORM.degBrother#</field>
<field fid="340">#FORM.degOther#</field>
</cfcase>
<cfcase value="intake_update2" >
<!--- GEmployment --->
<field fid="93"><![CDATA[#FORM.currOcc#]]></field>
<field fid="94">#FORM.occHrs#</field>
<field fid="95">#FORM.isEmployed#</field>
<field fid="96"><![CDATA[#FORM.occupation#]]></field>
<field fid="348"><![CDATA[#FORM.otherOcc#]]></field>
<field fid="97">#FORM.workHrs#</field>
<field fid="98">#FORM.isFlexHrs#</field>
<field fid="234">#workMornings#</field>
<field fid="235">#workDays#</field>
<field fid="236">#workEvenings#</field>
<field fid="239">#workNights#</field>
<!--- HHealthandWellness --->
<field fid="100">#FORM.isMed#</field>
<field fid="101"><![CDATA[#FORM.medCond#]]></field>
<field fid="102">#FORM.isMent#</field>
<field fid="103"><![CDATA[#FORM.mentCond#]]></field>
<field fid="104">#FORM.isFamMed#</field>
<field fid="105"><![CDATA[#FORM.famSupport#]]></field>
<field fid="106">#FORM.famHrs#</field>
<!--- IConfidentialResearchInformation --->
<field fid="107">#FORM.foster#</field>
field fid="108">#FORM.homeless#</field>
<field fid="109">#FORM.unstableHome#</field>
<field fid="110">#FORM.domViolence#</field>
<field fid="111">#FORM.childAbuse#</field>
<field fid="112">#FORM.gangInv#</field>
<field fid="113">#FORM.gangRel#</field>
<field fid="114">#FORM.drugs#</field>
<field fid="115">#FORM.arrested#</field>
<field fid="116">#FORM.jail#</field>
<field fid="117">#FORM.convict#</field>
<field fid="118">#FORM.prison#</field>
<field fid="119">#FORM.prvProbation#</field>
<field fid="120">#FORM.curProbation#</field>
<field fid="121">#FORM.govBenefit#</field>
<field fid="210">#FORM.freeLunch#</field>
<field fid="122">#FORM.discuss#</field>
<!--- JIncome --->
<field fid="123">#FORM.income#</field>
<field fid="124">#FORM.parIncome#</field>
<field fid="125">#FORM.recSupport#</field>
<!--- KAcademyAwareness --->
<field fid="126">#friend#</field>
<field fid="127"><![CDATA[#FORM.friendName#]]></field>
<field fid="128">#student#</field>
<field fid="129"><![CDATA[#FORM.studentName#]]></field>
<field fid="130">#tv#</field>
<field fid="131"><![CDATA[#FORM.tvName#]]></field>
<field fid="132">#flyer#</field>
<field fid="133"><![CDATA[#FORM.flyerName#]]></field>
<field fid="134">#newsletter#</field>
<field fid="135"><![CDATA[#FORM.newsletName#]]></field>
<field fid="136">#newsPaper#</field>
<field fid="137"><![CDATA[#FORM.newspapName#]]></field>
<field fid="138">#teacher#</field>
<field fid="139"><![CDATA[#FORM.teacherName#]]></field>
<field fid="140">#class#</field>
<field fid="141"><![CDATA[#FORM.className#]]></field>
<field fid="142">#referred#</field>
<field fid="143"><![CDATA[#FORM.referredBy#]]></field>
<field fid="327">#presentation#</field>
<field fid="328"><![CDATA[#FORM.presLoc#]]></field>
<field fid="329">#phoneCall#</field>
<field fid="330"><![CDATA[#FORM.phoneWhom#]]></field>
<field fid="144">#other#</field>
<field fid="145"><![CDATA[#FORM.otherSpec#]]></field>
<!--- Referrals --->
<field fid="146">#FORM.isReferral#</field>
<field fid="232"><![CDATA[#FORM.refName#]]></field>
<field fid="233"><![CDATA[#FORM.refPhone#]]></field>
<field fid="317">#FORM.refOK#</field>
<field fid="319">#FORM.acadDiscover#</field>
<field fid="320">#FORM.acadEnroll#</field>
<field fid="147">#agree#</field>
</cfcase>
</cfswitch>
</qdbapi>
</cfoutput>
</cfsavecontent>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment