stParm:
| ACCESSLEVEL |
|
| CATEGORY |
|
| FIELDNAMES |
TYPE,SUBMITGUID,FORMCONTENT,MAX,ACCESSLEVEL,CATEGORY,STATUSNEW,MESSAGE,SUBMIT
|
| FORMCONTENT |
ADDRESSCOUNTY|San Mateo^CHANGECOUNTY|No^COMMENT|These people are tasked with educating young people and this is showing a true lack of ethics that they are teaching our students. As a student, I am around other students and it amazes me that they don't really understand how the system is supposed to work and why these tactics are so reprehensible.^DISTRICTCCD|37^DISTRICTNCES|0632130^EMAIL|dtdiva70@gmail.com^EMPLOYER| ^FORMNAME|MemberApplication^GROUP| ^INTEREST|attend^KEY|0^NAMEFIRST|Rochelle^NAMELAST|Abrams^OCCUPATION|Retired/Disabled/Student^PHONECELL|6502350386^PHONEHOME| ^REASON|I feel that the tax payers were deceived by 2014 San Mateo County Measure H. These funds were used among other things to build a revenue stream for the community college district in the form of an athletic club where they sell memberships to the community and have developed a swim school. This is run under their 'for profit' arm of auxillary services and is nothing more than an effort to launder the bond funds generously provided by the voters and allow them to do as they please with the profits from these ventures. Unfortunately, the mission of the not-for-profit and the for-profit ventures can and will be at odds with one another and I believe that is what I have been seeing.^SKILL|spreadsheet^STATUS| ^SUBMIT1|Submit^SUBMITGUID|FB146369-5FD6-4DDF-817A3729B9FBAFEB^WEEKLYHOUR|5
|
| MAX |
ADDRESSCOUNTY|San Mateo^CHANGECOUNTY|No^COMMENT|These people are tasked with educating young people and this is showing a true lack of ethics that they are teaching our students. As a student, I am around other students and it amazes me that they don't really understand how the system is supposed to work and why these tactics are so reprehensible.^DISTRICTCCD|37^DISTRICTNCES|0632130^EMAIL|dtdiva70@gmail.com^EMPLOYER| ^FORMNAME|MemberApplication^GROUP| ^INTEREST|attend^KEY|0^NAMEFIRST|Rochelle^NAMELAST|Abrams^OCCUPATION|Retired/Disabled/Student^PHONECELL|6502350386^PHONEHOME| ^REASON|I feel that the tax payers were deceived by 2014 San Mateo County Measure H. These funds were used among other things to build a revenue stream for the community college district in the form of an athletic club where they sell memberships to the community and have developed a swim school. This is run under their ""for profit"" arm of auxillary services and is nothing more than an effort to launder the bond funds generously provided by the voters and allow them to do as they please with the profits from these ventures. Unfortunately, the mission of the not-for-profit and the for-profit ventures can and will be at odds with one another and I believe that is what I have been seeing.^SKILL|spreadsheet^STATUS| ^SUBMIT1|Submit^SUBMITGUID|FB146369-5FD6-4DDF-817A3729B9FBAFEB^WEEKLYHOUR|5
|
| MESSAGE |
Hi,
--
Richard Michael
|
| STATUSNEW |
insert
|
| SUBMIT |
Submit
|
| SUBMITGUID |
FB146369-5FD6-4DDF-817A3729B9FBAFEB
|
| TYPE |
action
|
Form:
| ACCESSLEVEL |
|
| CATEGORY |
|
| FIELDNAMES |
TYPE,SUBMITGUID,FORMCONTENT,MAX,ACCESSLEVEL,CATEGORY,STATUSNEW,MESSAGE,SUBMIT
|
| FORMCONTENT |
ADDRESSCOUNTY|San Mateo^CHANGECOUNTY|No^COMMENT|These people are tasked with educating young people and this is showing a true lack of ethics that they are teaching our students. As a student, I am around other students and it amazes me that they don't really understand how the system is supposed to work and why these tactics are so reprehensible.^DISTRICTCCD|37^DISTRICTNCES|0632130^EMAIL|dtdiva70@gmail.com^EMPLOYER| ^FORMNAME|MemberApplication^GROUP| ^INTEREST|attend^KEY|0^NAMEFIRST|Rochelle^NAMELAST|Abrams^OCCUPATION|Retired/Disabled/Student^PHONECELL|6502350386^PHONEHOME| ^REASON|I feel that the tax payers were deceived by 2014 San Mateo County Measure H. These funds were used among other things to build a revenue stream for the community college district in the form of an athletic club where they sell memberships to the community and have developed a swim school. This is run under their 'for profit' arm of auxillary services and is nothing more than an effort to launder the bond funds generously provided by the voters and allow them to do as they please with the profits from these ventures. Unfortunately, the mission of the not-for-profit and the for-profit ventures can and will be at odds with one another and I believe that is what I have been seeing.^SKILL|spreadsheet^STATUS| ^SUBMIT1|Submit^SUBMITGUID|FB146369-5FD6-4DDF-817A3729B9FBAFEB^WEEKLYHOUR|5
|
| MAX |
ADDRESSCOUNTY|San Mateo^CHANGECOUNTY|No^COMMENT|These people are tasked with educating young people and this is showing a true lack of ethics that they are teaching our students. As a student, I am around other students and it amazes me that they don't really understand how the system is supposed to work and why these tactics are so reprehensible.^DISTRICTCCD|37^DISTRICTNCES|0632130^EMAIL|dtdiva70@gmail.com^EMPLOYER| ^FORMNAME|MemberApplication^GROUP| ^INTEREST|attend^KEY|0^NAMEFIRST|Rochelle^NAMELAST|Abrams^OCCUPATION|Retired/Disabled/Student^PHONECELL|6502350386^PHONEHOME| ^REASON|I feel that the tax payers were deceived by 2014 San Mateo County Measure H. These funds were used among other things to build a revenue stream for the community college district in the form of an athletic club where they sell memberships to the community and have developed a swim school. This is run under their ""for profit"" arm of auxillary services and is nothing more than an effort to launder the bond funds generously provided by the voters and allow them to do as they please with the profits from these ventures. Unfortunately, the mission of the not-for-profit and the for-profit ventures can and will be at odds with one another and I believe that is what I have been seeing.^SKILL|spreadsheet^STATUS| ^SUBMIT1|Submit^SUBMITGUID|FB146369-5FD6-4DDF-817A3729B9FBAFEB^WEEKLYHOUR|5
|
| MESSAGE |
Hi,
--
Richard Michael
|
| STATUSNEW |
insert
|
| SUBMIT |
Submit
|
| SUBMITGUID |
FB146369-5FD6-4DDF-817A3729B9FBAFEB
|
| TYPE |
action
|
URL:
Attributes:
| DEBUG |
Yes
|
| PARAMETER |
|
| RETURN |
|
| RETURNTYPE |
action
|
| SERVICENAME |
MemberManager
|
| VERSION |
|
INSERT INTO dbo.BBBTest (
-- BigBadBondsMaster_id
AccessLevel_cd
, AccessPassword_tx
, AddressCounty_tx
, Comment_tx
, DistrictCCD_cd
, DistrictNCES_mv
, Email_tx
, Employer_tx
, Group_mv
, Interest_mv
, NameFirst_tx
, NameLast_tx
, Occupation_tx
, PhoneCell_tx
, PhoneHome_tx
, Reason_tx
, Skill_mv
, Weeklyhour_nb
, ActiveBegin_dt
, ActiveEnd_dt
, CheckSum_nb
, Create_dt
, IPAddress_cd
, Source_cd
, Status_cd
, Update_dt
, LastSignIn_dt
, Category_mv
, StatusDate_dt
)
SELECT
-- BigBadBondsMaster_id
CASE WHEN '' = '' THEN NULL ELSE '' END AS AccessLevel_cd
, NULL AS AccessPassword_tx
, CASE WHEN COL01 = '' THEN NULL ELSE COL01 END AS AddressCounty_tx
, CASE WHEN COL03 = '' THEN NULL ELSE LEFT(COL03, 512) END AS Comment_tx
, CASE WHEN COL04 = '' THEN NULL ELSE COL04 END AS DistrictCCD_cd
, CASE WHEN COL05 = '' THEN NULL ELSE COL05 END AS DistrictNCES_mv
, CASE WHEN COL06 = '' THEN NULL ELSE LOWER(COL06) END AS Email_tx
, CASE WHEN COL07 = '' THEN NULL ELSE COL07 END AS Employer_tx
, CASE WHEN COL09 = '' THEN NULL ELSE LEFT(COL09, 512) END AS Group_mv
, CASE WHEN COL10 = '' THEN NULL ELSE COL10 END AS Interest_mv
, CASE WHEN COL12 = '' THEN NULL ELSE COL12 END AS NameFirst_tx
, CASE WHEN COL13 = '' THEN NULL ELSE COL13 END AS NameLast_tx
, CASE WHEN COL14 = '' THEN NULL ELSE COL14 END AS Occupation_tx
, CASE WHEN COL15 = '' THEN NULL ELSE dbo.f_FormatPhone(COL15, '-') END AS PhoneCell_tx
, CASE WHEN COL16 = '' THEN NULL ELSE dbo.f_FormatPhone(COL16, '-') END AS PhoneHome_tx
, CASE WHEN COL17 = '' THEN NULL ELSE LEFT(COL17, 512) END AS Reason_tx
, CASE WHEN COL18 = '' THEN NULL ELSE COL18 END AS Skill_mv
, CASE WHEN COL22 = '' THEN NULL ELSE COL22 END AS Weeklyhour_nb
, NULL AS ActiveBegin_dt
, NULL AS ActiveEnd_dt
, NULL AS CheckSum_nb
, FS.Create_dt
, FS.IPAddress_cd
, NULL AS Source_cd
, 'Loaded' AS Status_cd --COL19 is null
, NULL AS Update_dt
, NULL AS LastSignIn_dt
, CASE WHEN '' = '' THEN NULL ELSE '' END AS Category_mv
, GETDATE() AS StatusDate_dt
/*
, COL02 AS CHANGECOUNTY
, COL08 AS FORMNAME
, COL11 AS KEY
, COL20 AS SUBMIT1
, COL21 AS SUBMITGUID
SubmitGUID_tx varchar 36 1 36 0 0 U
FormContent_tx varchar 4096 2 4096 0 1 U
FormName_tx varchar 64 3 64 0 1 U
Create_dt smalldatetime 4 4 16 0 0 1 U
IPAddress_cd varchar 16 5 16 0 1 U
Status_cd varchar 24 6 24 0 1 U
StatusUpdate_dt smalldatetime 4 8 16 0 0 1 U
*/
FROM
dbo.f_FormTable('ADDRESSCOUNTY|San Mateo^CHANGECOUNTY|No^COMMENT|These people are tasked with educating young people and this is showing a true lack of ethics that they are teaching our students. As a student, I am around other students and it amazes me that they don''t really understand how the system is supposed to work and why these tactics are so reprehensible.^DISTRICTCCD|37^DISTRICTNCES|0632130^EMAIL|dtdiva70@gmail.com^EMPLOYER| ^FORMNAME|MemberApplication^GROUP| ^INTEREST|attend^KEY|0^NAMEFIRST|Rochelle^NAMELAST|Abrams^OCCUPATION|Retired/Disabled/Student^PHONECELL|6502350386^PHONEHOME| ^REASON|I feel that the tax payers were deceived by 2014 San Mateo County Measure H. These funds were used among other things to build a revenue stream for the community college district in the form of an athletic club where they sell memberships to the community and have developed a swim school. This is run under their ''for profit'' arm of auxillary services and is nothing more than an effort to launder the bond funds generously provided by the voters and allow them to do as they please with the profits from these ventures. Unfortunately, the mission of the not-for-profit and the for-profit ventures can and will be at odds with one another and I believe that is what I have been seeing.^SKILL|spreadsheet^STATUS| ^SUBMIT1|Submit^SUBMITGUID|FB146369-5FD6-4DDF-817A3729B9FBAFEB^WEEKLYHOUR|5', '^', '|', 30) AS JS
LEFT JOIN dbo.FormSubmit AS FS
ON JS.[COL21] = FS.SubmitGUID_tx
WHERE
1 = 1
AND FS.SubmitGUID_tx = 'FB146369-5FD6-4DDF-817A3729B9FBAFEB'