API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 21st, 2020
162
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.78 KB | None | 0 0
raw download clone embed print report
  1. 16:37:08 ERR] Failed executing DbCommand (788ms) [Parameters=[@__p_1='0', @__p_2='10'], CommandType='"Text"', CommandTimeout='30']
  2. SELECT [t].[Id], [t].[ContentType], [t].[CreatedBy], [t].[CreatedOn], [t].[IsDeleted], [t].[JobId], [t].[Note], [t].[ResumeSubmitInfoId], [t].[StatusId], [t].[TravelerId], [t].[Url], [t].[VendorSubmitId], [t].[Id0], [t].[StatusId0], [t].[StatusName], [t].[StatusTooltip], [t].[UserID], [t].[AcctMgrID], [t].[Address], [t].[Address2], [t].[Address3], [t].[AltPhone], [t].[Application], [t].[AssignStatus], [t].[AvailableDate], [t].[availabledatenote], [t].[CellPhone], [t].[CellPhoneStatus], [t].[ChatAvailability], [t].[checklist_casemanager], [t].[checklist_casemanager_time], [t].[Checklist_Cath_Lab], [t].[Checklist_Cath_Lab_time], [t].[Checklist_cna], [t].[Checklist_cna_time], [t].[Checklist_critical], [t].[Checklist_critical_time], [t].[Checklist_Dialysis], [t].[Checklist_Dialysis_time], [t].[Checklist_emergency], [t].[Checklist_emergency_time], [t].[Checklist_Endoscopy], [t].[Checklist_Endoscopy_time], [t].[Checklist_home], [t].[Checklist_home_time], [t].[Checklist_LDRP], [t].[Checklist_LDRP_time], [t].[checklist_LTC], [t].[checklist_ltc_time], [t].[Checklist_MedTech], [t].[Checklist_MedTech_time], [t].[Checklist_medical], [t].[Checklist_medical_time], [t].[Checklist_newborn], [t].[Checklist_newborn_time], [t].[Checklist_NICU], [t].[Checklist_NICU_time], [t].[Checklist_OccTher], [t].[Checklist_OccTher_time], [t].[Checklist_Oncology], [t].[Checklist_Oncology_time], [t].[Checklist_operating], [t].[Checklist_operating_time], [t].[Checklist_PACU], [t].[Checklist_PACU_time], [t].[Checklist_Pharmacist], [t].[Checklist_Pharmacist_time], [t].[Checklist_PhysTher], [t].[Checklist_PhysTher_time], [t].[Checklist_picu], [t].[Checklist_picu_time], [t].[Checklist_Post_Partum], [t].[Checklist_Post_Partum_time], [t].[Checklist_psychiatric], [t].[Checklist_psychiatric_time], [t].[Checklist_PTAssist], [t].[Checklist_PTAssist_time], [t].[Checklist_Radiology], [t].[Checklist_Radiology_time], [t].[Checklist_rehab], [t].[Checklist_rehab_time], [t].[Checklist_RespTher], [t].[Checklist_RespTher_time], [t].[Checklist_Speech], [t].[Checklist_Speech_time], [t].[Checklist_Surgical], [t].[Checklist_Surgical_time], [t].[Checklist_telemetry], [t].[Checklist_telemetry_time], [t].[City], [t].[ClinicalLiaisonComment], [t].[Comment], [t].[CompactLicensureState], [t].[Contact], [t].[ServExcID], [t].[CurrentAddress], [t].[CurrentCity], [t].[CurrentStateCode], [t].[CurrentZipCode], [t].[DayPhone], [t].[DayPhoneStatus], [t].[defaultPerDiemPhone], [t].[Email], [t].[EmailStatus], [t].[EmergFirstName], [t].[EmergLastName], [t].[EmergPhone], [t].[EmergRelation], [t].[EmploymentType], [t].[EnteredTime], [t].[EveningPhone], [t].[EveningPhoneStatus], [t].[Expertise], [t].[ExpertisePD], [t].[ExpertiseText], [t].[ExpertiseTextPD], [t].[Fax], [t].[FirstName], [t].[Hear], [t].[HearFriendName], [t].[Hot], [t].[InLeadQueue], [t].[InactiveStatusCode], [t].[InactiveStatusText], [t].[InternalRatingCode], [t].[InternalRatingText], [t].[InternalStatusCode], [t].[InternalStatusText], [t].[isFavorite], [t].[IsShiftAppUser], [t].[IsShiftAppUserManuallyChanged], [t].[LastName], [t].[LegalFirstName], [t].[LegalLastName], [t].[LicensureState], [t].[livetime], [t].[LockDown], [t].[MI], [t].[ModifiedTime], [t].[OrigRegistrationFrom], [t].[Pager], [t].[PagerStatus], [t].[PayCompanyID], [t].[payroll_empnum], [t].[pdPaycardAmount], [t].[pdPaycardFreq], [t].[pdPaycardNumber], [t].[pdPayrollMethod], [t].[pdReferralDate], [t].[pdReferralPaid], [t].[pdSchedulerID], [t].[pdStaffingComments], [t].[pdStartDate], [t].[pdTravFollowUp], [t].[pdTravWorkStatusBy], [t].[pdTravWorkStatusDate], [t].[pdhospid], [t].[pdmarketid], [t].[pdtravWorkStatus], [t].[perDiemDocStatus], [t].[perDiemRecruiterID], [t].[perDiemStatusCode], [t].[perdiemdocpct], [t].[Phone], [t].[pickStatus], [t].[preclosed], [t].[ProfessionCode], [t].[promoCode], [t].[Rating], [t].[RecruiterId], [t].[Reference], [t].[ReferenceCheck], [t].[ReferenceCompleted], [t].[ReferenceCompletedBy], [t].[referencePriority], [t].[ReferenceRequestTime], [t].[referenceStandard], [t].[ReferenceStatusCode], [t].[referenceStatusDate], [t].[ReferenceStatusText], [t].[referenceUrgent], [t].[ReferenceUserID], [t].[ReferenceUserName], [t].[referralCode], [t].[referralFriendName], [t].[referralPaid], [t].[Relocation], [t].[RelocationState], [t].[RelocationStateText], [t].[relocationnote], [t].[ResumeText], [t].[scrubSize], [t].[Shift], [t].[ShiftAppUserDate], [t].[ShiftAppUserId], [t].[ShiftAppUserNotes], [t].[SourceCode], [t].[StateCode], [t].[Status], [t].[subscribeBlast], [t].[subscribeJobMatches], [t].[subscribeNewsletter], [t].[subscribePhone], [t].[tAddress1], [t].[tCity1], [t].[tStateCode1], [t].[tZipCode1], [t].[TimeToCall], [t].[WorkStatusCode], [t].[ZipCode], [t].[UserID0], [t].[CompanyID], [t].[CompanyType], [t].[dateOfBirth], [t].[Email0], [t].[FirstName0], [t].[GenderId], [t].[itRole], [t].[LastName0], [t].[Password], [t].[PayrollTeamLeadID], [t].[pdPayrate], [t].[Phone0], [t].[QMRole], [t].[referralCode0], [t].[SSN], [t].[Status0], [t].[UserName], [t].[UserType], [t].[id1], [t].[AccountManagerNote], [t].[CurrentStageId], [t].[DateSubmitted], [t].[JobId0], [t].[Note0], [t].[SubmitedByUserId], [t].[VendorCandidateId], [t].[VendorRate], [t].[Id2], [t].[Address1], [t].[Address20], [t].[AvailableStartDate], [t].[City0], [t].[DOB], [t].[Email1], [t].[FirstName1], [t].[LastName1], [t].[MiddleName], [t].[Note1], [t].[OldUserId], [t].[PreferredShiftTypeId], [t].[ProfessionId], [t].[SSN0], [t].[SellingPoints], [t].[StateId], [t].[Title], [t].[UserId1], [t].[VendorContactId], [t].[VendorId], [t].[ZipCode0], [t].[Id3], [t].[AccountingId], [t].[AchAccountNumber], [t].[AchAccountTypeId], [t].[AchBankId], [t].[AchBeneficiaryName], [t].[AchRoutingNumber], [t].[AchWireRoutingNumber], [t].[AutomaticallyOfferNewFacilities], [t].[BusinessTypeId], [t].[DNBID], [t].[DateEntered], [t].[DateOfIncorporation], [t].[FedTaxID], [t].[GeneralLiabilityAggregrate], [t].[GeneralLiabilityExp], [t].[GeneralLiabilityPerOccurrence], [t].[GeneralLiabilityUmbrellaCoverageRequired], [t].[GeneralLiabilityWaiverOfSubrogation], [t].[IncludeExcludeNotes], [t].[IncorporatedInStateID], [t].[LegalName], [t].[NewFacilityCnt], [t].[OperatingName], [t].[PrimLocation], [t].[ProfecionalLiabilityAggregrate], [t].[ProfecionalLiabilityExp], [t].[ProfecionalLiabilityPerOccurrence], [t].[ProfecionalLiabilityUmbrellaCoverageRequired], [t].[ProfecionalLiabilityWaiverOfSubrogation], [t].[Qualivis1StatusTypeID], [t].[Qualivis2StatusTypeID], [t].[QualivisLocumMspStatusTypeID], [t].[QualivisLocumStatusTypeID], [t].[QualivisOhaStatusTypeId], [t].[StatusTypeId], [t].[SubAgreementExpDate], [t].[SubAgreementSigned], [t].[SubAgreementSignedDate], [t].[SymmetryMSPStatusTypeID], [t].[SymmetryStatusTypeID], [t].[UmbrellaAggregateLimit], [t].[UmbrellaAuto], [t].[UmbrellaCoverageRequired], [t].[AutoExp], [t].[UmbrellaWaiverSubrogation], [t].[UmbrellaCyber], [t].[UmbrellaCyberCoverage], [t].[CyberExp], [t].[UmbrellaCyberWaiverSubrogation], [t].[UmbrellaDOCoverage], [t].[UmbrellaDOCoverageRequired], [t].[DoExp], [t].[UmbrellaDOWaiverSubrogation], [t].[EmployeeCrimeExp], [t].[UmbrellaEmployeeCrimeTheftDishonesty], [t].[UmbrellaCrimeWaiverSubrogation], [t].[UmbrellaExp], [t].[UmbrellaNotes], [t].[UmbrellaPerOccurrence], [t].[UmbrellaRequiredLanguage], [t].[UmbrellaSexualAssaultCoverage], [t].[UmbrellaSexualAssaultCoverageRequired], [t].[SexualAssaultExp], [t].[UmbrellaSexualAssaultWaiverSubrogation], [t].[WorkersCompDisease], [t].[WorkersCompWCAccident], [t].[WorkersCompExp], [t].[WorkersCompLimit], [t].[WorkersCompUmbrellaCoverageRequired], [t].[WorkersCompWaiverOfSubrogation], [t].[submitID], [t].[Accept], [t].[AdditionalInfo], [t].[Anyone], [t].[Choises1], [t].[Choises2], [t].[Choises3], [t].[ColorStatus], [t].[CountInMetrics], [t].[CurrentlyMaking], [t].[DayShift], [t].[DayShiftR], [t].[DeleteReason], [t].[EveningShift], [t].[EveningShiftR], [t].[HospCity], [t].[HospID], [t].[HospName], [t].[HospState], [t].[ImportantFactor], [t].[IsExtension], [t].[Location], [t].[MarketingCandidate], [t].[NightShift], [t].[NightShiftR], [t].[Notes], [t].[Nurse], [t].[Offer], [t].[OfferLocation], [t].[OtherPosition], [t].[PayRate], [t].[PreferShift], [t].[PreferShiftR], [t].[Rate], [t].[Rating0], [t].[ResumeInfoUserId], [t].[Serious], [t].[SeriousR], [t].[Shift0], [t].[Specialty], [t].[SpecialtyUnits1], [t].[SpecialtyUnits2], [t].[SpecialtyUnits3], [t].[SpecialtyYears1], [t].[SpecialtyYears2], [t].[SpecialtyYears3], [t].[Status1], [t].[StatusDate], [t].[Submittime], [t].[SwingShift], [t].[SwingShiftR], [t].[Time1], [t].[Time2], [t].[Time3], [t].[UserID2], [t].[WhichOne], [t].[WorkingWithOther], [t].[WorkingWithOtherR], [t].[JobID1], [t].[AltShift_Fl], [t].[BidMax], [t].[BidMin], [t].[Billingrate], [t].[Billruleid], [t].[BlendedBillRate], [t].[Bonus], [t].[City1], [t].[Duration], [t].[EmploymentTypeCode], [t].[EmploymentTypeText], [t].[EnteredTime0], [t].[Expertise0], [t].[ExpertiseCode], [t].[ExpertiseText0], [t].[HIdeFromVendors], [t].[Hold], [t].[HospID0], [t].[Hot0], [t].[Hours], [t].[HoursAlt], [t].[IsBid], [t].[IsMarginBooster], [t].[IsOnHold], [t].[IsPriority], [t].[IsStar], [t].[JobDescription], [t].[JobEnteredFrom], [t].[JobOpenReasonId], [t].[JobStatusID], [t].[JobStatusText], [t].[ModifiedBy], [t].[ModifiedTime0], [t].[NumView], [t].[PendingDelete], [t].[Positions], [t].[PreCalcContractedBaseRateAfterFees], [t].[PreCalcSpecialBaseRateAfterFees], [t].[ProfessionCode0], [t].[ProfessionText], [t].[Rapidresponse], [t].[Rate0], [t].[Rate2], [t].[Rateeve], [t].[Rateeve2], [t].[Ratenight], [t].[Ratenight2], [t].[RatingId], [t].[RecruiterID0], [t].[Reference0], [t].[ReleaseSchedulingEnabled], [t].[ReleaseStatusId], [t].[ReqCertificateID], [t].[RequirementID], [t].[RequirementText], [t].[SampleMarginId], [t].[ShiftAltH], [t].[ShiftAltM], [t].[ShiftAltToH], [t].[ShiftAltToM], [t].[ShiftCode], [t].[ShiftH], [t].[ShiftHours], [t].[ShiftM], [t].[ShiftStartTime], [t].[ShiftText], [t].[ShiftToH], [t].[ShiftToM], [t].[Shifts], [t].[ShiftsAlt], [t].[SiteID], [t].[Star_bonus], [t].[Star_commission], [t].[Star_position], [t].[Star_typeid], [t].[StartDate], [t].[StateCode0], [t].[StateText], [t].[Status2], [t].[Title0], [t].[UnitId], [t].[UserID3], [t].[VendorRateOverride], [t].[ZipCode1], [t].[hospid1], [t].[accountMgrId], [t].[AccountReviewFrequencyId], [t].[AccountSpecialistId], [t].[acctMgrID0], [t].[ahContractEndDate], [t].[ahContractStartDate], [t].[ahContractStatus], [t].[ahOffered], [t].[benefitProvided], [t].[billadd], [t].[billingMethod], [t].[CCisDecisionMaker], [t].[CNOisDecisionMaker], [t].[callForJobs], [t].[CallsOffFrequently], [t].[cancelChargeAmt], [t].[cancelChargeType], [t].[cancelFeeFreq], [t].[cancelFeeFreqAmt], [t].[cancelFeePct], [t].[cancelPolicy], [t].[cancelPolicyText], [t].[cancelTerms], [t].[chargeRate], [t].[COFreq_10], [t].[COFreq_12], [t].[COFreq_8], [t].[COFreq_A], [t].[COFreqAmt_10], [t].[COFreqAmt_12], [t].[COFreqAmt_8], [t].[COFreqAmt_A], [t].[COHrs_10], [t].[COHrs_12], [t].[COHrs_8], [t].[COHrs_A], [t].[contact0], [t].[contractDueDate], [t].[contractEndDate], [t].[contractEnteredBy], [t].[contractEnteredTime], [t].[contractModifiedBy], [t].[contractModifiedTime], [t].[contractStDate], [t].[contractStartDate], [t].[contractStatus], [t].[convertFeeCont_1], [t].[convertFeeCont_2], [t].[convertFeeCont_3], [t].[convertFeeWeeks_1], [t].[convertFeeWeeks_2], [t].[convertFeeWeeks_3], [t].[convertFees_1], [t].[convertFees_2], [t].[convertFees_3], [t].[creditLastChecked], [t].[csystem], [t].[dateDeleted], [t].[DateM], [t].[DateMBilling], [t].[DateMContract], [t].[dateRFP], [t].[dayot], [t].[discountDays], [t].[discountPct], [t].[EACisDecisionMaker], [t].[editFlag], [t].[editedTime], [t].[email2], [t].[enteredTime1], [t].[exceptionRules], [t].[ExtDiscount], [t].[ExtDiscountType], [t].[extraName], [t].[facilityProfile], [t].[FacilityProfileGroupId], [t].[facility_type], [t].[faxno], [t].[featuredLogo], [t].[fedExApp], [t].[GeoLocation], [t].[GooglePlaceId], [t].[grossReceiptTax], [t].[GUARFreq_10], [t].[GUARFreq_12], [t].[GUARFreq_8], [t].[GUARFreq_A], [t].[GUARFreqAmt_10], [t].[GUARFreqAmt_12], [t].[GUARFreqAmt_8], [t].[GUARFreqAmt_A], [t].[GUARHrs_10], [t].[GUARHrs_12], [t].[GUARHrs_8], [t].[GUARHrs_A], [t].[GuidId], [t].[hospAddress], [t].[hospCancelPhone], [t].[hospCC], [t].[hospCCCelNo], [t].[hospCCContactRank], [t].[hospCCEmail], [t].[hospCCEmailBlastChecked], [t].[hospCCFaxNo], [t].[HospCcLastUpdated], [t].[hospCCTelNo], [t].[hospCity0], [t].[hospCNO], [t].[hospCNOCelNo], [t].[hospCNOContactRank], [t].[hospCNOEmail], [t].[hospCNOEmailBlastChecked], [t].[hospCNOFaxNo], [t].[HospCnoLastUpdated], [t].[hospCNOTelNo], [t].[hospConfirmPhone], [t].[hospEAC], [t].[hospEACCelNo], [t].[hospEACContactRank], [t].[hospEACEmail], [t].[hospEACEmailBlastChecked], [t].[hospEACFaxNo], [t].[HospEacLastUpdated], [t].[hospEACTelNo], [t].[hospHousing], [t].[hospHousingAmt], [t].[hospMRC], [t].[hospMRCCelNo], [t].[hospMRCContactRank], [t].[hospMRCEmail], [t].[hospMRCEmailBlastChecked], [t].[hospMRCFaxNo], [t].[HospMrcLastUpdated], [t].[hospMRCTelNo], [t].[hospName0], [t].[hospNote], [t].[hospNumBeds], [t].[hospOrientation], [t].[hospPDC], [t].[hospPDCCelNo], [t].[hospPDCTelNo], [t].[hospPermNote], [t].[hospPhone], [t].[hospSEC], [t].[hospSECCelNo], [t].[hospSECContactRank], [t].[hospSECEmail], [t].[hospSECEmailBlastChecked], [t].[hospSECFaxNo], [t].[HospSecLastUpdated], [t].[hospSECTelNo], [t].[hospState0], [t].[HospStateId], [t].[hospTNC], [t].[hospTNCCelNo], [t].[hospTNCContactRank], [t].[hospTNCEmail], [t].[hospTNCEmailBlastChecked], [t].[hospTNCFaxNo], [t].[HospTncLastUpdated], [t].[hospTNCTelNo], [t].[hospTotStaffedBeds], [t].[hospType], [t].[hospTypeofcontrol], [t].[hospWebsite], [t].[hospZip], [t].[hospitalSystemCode], [t].[HospitalTypeId], [t].[hospitalreq], [t].[imagePath], [t].[instructions], [t].[isDeleted0], [t].[isMagnet], [t].[isRFP], [t].[isTeaching], [t].[lastEditedBy], [t].[latitude], [t].[LocalTravelerInfo], [t].[longitude], [t].[MRCisDecisionMaker], [t].[manReference], [t].[maxLodging], [t].[maxMeal], [t].[maxMiles], [t].[milesCents], [t].[milesFreq], [t].[milesFreqAmt], [t].[milesPaid], [t].[noContract], [t].[oldHousingAmt], [t].[onCallRate], [t].[OrientDetails], [t].[OrientHours], [t].[originatorID], [t].[paContractEndDate], [t].[paContractStartDate], [t].[paContractStatus], [t].[paOffered], [t].[ParentID], [t].[paybackPct], [t].[payroll], [t].[payrollLiasonId], [t].[pdContractEndDate], [t].[pdContractStartDate], [t].[pdContractStatus], [t].[pdOffered], [t].[pdmarketid0], [t].[pendingDelete0], [t].[perdiemContractStatus], [t].[permContractEndDate], [t].[permContractStartDate], [t].[permContractStatus], [t].[permOffered], [t].[permanentContractStatus], [t].[printInvoices], [t].[prospectorLastContactDate], [t].[prospectorLastContactNoteTypeID], [t].[QBParentObject], [t].[QMSystemCode], [t].[RatingId0], [t].[req1], [t].[req2], [t].[req3], [t].[req4], [t].[req5], [t].[req6], [t].[req7], [t].[requiredTimecard], [t].[rrContractEndDate], [t].[rrContractStartDate], [t].[rrContractStatus], [t].[rrOffered], [t].[SecisDecisionMaker], [t].[SellingPoints0], [t].[showToProspector], [t].[TNCisDecisionMaker], [t].[targetCustomer], [t].[targetMargin], [t].[targetPayRate], [t].[telno], [t].[TherapyAccountManagerId], [t].[title1], [t].[ToughPlaceToWork], [t].[trContractEndDate], [t].[trContractStartDate], [t].[trContractStatus], [t].[trOffered], [t].[TravelersLoveWorkingHere], [t].[weekot], [t].[Id4], [t].[Abbreviation], [t].[Name], [t].[ProfessionTypeId], [t].[SortOrder], [t].[Id5], [t].[CostCenter], [t].[HospId2], [t].[Name0], [t].[UnitDescriptionFormId], [t].[UpdatedBy], [t].[UpdatedDate]
  3. FROM (
  4. SELECT [cv].[Id], [cv].[ContentType], [cv].[CreatedBy], [cv].[CreatedOn], [cv].[IsDeleted], [cv].[JobId], [cv].[Note], [cv].[ResumeSubmitInfoId], [cv].[StatusId], [cv].[TravelerId], [cv].[Url], [cv].[VendorSubmitId], [cv.Status].[Id] AS [Id0], [cv.Status].[StatusId] AS [StatusId0], [cv.Status].[StatusName], [cv.Status].[StatusTooltip], [cv.TravelerResume].[UserID], [cv.TravelerResume].[AcctMgrID], [cv.TravelerResume].[Address], [cv.TravelerResume].[Address2], [cv.TravelerResume].[Address3], [cv.TravelerResume].[AltPhone], [cv.TravelerResume].[Application], [cv.TravelerResume].[AssignStatus], [cv.TravelerResume].[AvailableDate], [cv.TravelerResume].[availabledatenote], [cv.TravelerResume].[CellPhone], [cv.TravelerResume].[CellPhoneStatus], [cv.TravelerResume].[ChatAvailability], [cv.TravelerResume].[checklist_casemanager], [cv.TravelerResume].[checklist_casemanager_time], [cv.TravelerResume].[Checklist_Cath_Lab], [cv.TravelerResume].[Checklist_Cath_Lab_time], [cv.TravelerResume].[Checklist_cna], [cv.TravelerResume].[Checklist_cna_time], [cv.TravelerResume].[Checklist_critical], [cv.TravelerResume].[Checklist_critical_time], [cv.TravelerResume].[Checklist_Dialysis], [cv.TravelerResume].[Checklist_Dialysis_time], [cv.TravelerResume].[Checklist_emergency], [cv.TravelerResume].[Checklist_emergency_time], [cv.TravelerResume].[Checklist_Endoscopy], [cv.TravelerResume].[Checklist_Endoscopy_time], [cv.TravelerResume].[Checklist_home], [cv.TravelerResume].[Checklist_home_time], [cv.TravelerResume].[Checklist_LDRP], [cv.TravelerResume].[Checklist_LDRP_time], [cv.TravelerResume].[checklist_LTC], [cv.TravelerResume].[checklist_ltc_time], [cv.TravelerResume].[Checklist_MedTech], [cv.TravelerResume].[Checklist_MedTech_time], [cv.TravelerResume].[Checklist_medical], [cv.TravelerResume].[Checklist_medical_time], [cv.TravelerResume].[Checklist_newborn], [cv.TravelerResume].[Checklist_newborn_time], [cv.TravelerResume].[Checklist_NICU], [cv.TravelerResume].[Checklist_NICU_time], [cv.TravelerResume].[Checklist_OccTher], [cv.TravelerResume].[Checklist_OccTher_time], [cv.TravelerResume].[Checklist_Oncology], [cv.TravelerResume].[Checklist_Oncology_time], [cv.TravelerResume].[Checklist_operating], [cv.TravelerResume].[Checklist_operating_time], [cv.TravelerResume].[Checklist_PACU], [cv.TravelerResume].[Checklist_PACU_time], [cv.TravelerResume].[Checklist_Pharmacist], [cv.TravelerResume].[Checklist_Pharmacist_time], [cv.TravelerResume].[Checklist_PhysTher], [cv.TravelerResume].[Checklist_PhysTher_time], [cv.TravelerResume].[Checklist_picu], [cv.TravelerResume].[Checklist_picu_time], [cv.TravelerResume].[Checklist_Post_Partum], [cv.TravelerResume].[Checklist_Post_Partum_time], [cv.TravelerResume].[Checklist_psychiatric], [cv.TravelerResume].[Checklist_psychiatric_time], [cv.TravelerResume].[Checklist_PTAssist], [cv.TravelerResume].[Checklist_PTAssist_time], [cv.TravelerResume].[Checklist_Radiology], [cv.TravelerResume].[Checklist_Radiology_time], [cv.TravelerResume].[Checklist_rehab], [cv.TravelerResume].[Checklist_rehab_time], [cv.TravelerResume].[Checklist_RespTher], [cv.TravelerResume].[Checklist_RespTher_time], [cv.TravelerResume].[Checklist_Speech], [cv.TravelerResume].[Checklist_Speech_time], [cv.TravelerResume].[Checklist_Surgical], [cv.TravelerResume].[Checklist_Surgical_time], [cv.TravelerResume].[Checklist_telemetry], [cv.TravelerResume].[Checklist_telemetry_time], [cv.TravelerResume].[City], [cv.TravelerResume].[ClinicalLiaisonComment], [cv.TravelerResume].[Comment], [cv.TravelerResume].[CompactLicensureState], [cv.TravelerResume].[Contact], [cv.TravelerResume].[ServExcID], [cv.TravelerResume].[CurrentAddress], [cv.TravelerResume].[CurrentCity], [cv.TravelerResume].[CurrentStateCode], [cv.TravelerResume].[CurrentZipCode], [cv.TravelerResume].[DayPhone], [cv.TravelerResume].[DayPhoneStatus], [cv.TravelerResume].[defaultPerDiemPhone], [cv.TravelerResume].[Email], [cv.TravelerResume].[EmailStatus], [cv.TravelerResume].[EmergFirstName], [cv.TravelerResume].[EmergLastName], [cv.TravelerResume].[EmergPhone], [cv.TravelerResume].[EmergRelation], [cv.TravelerResume].[EmploymentType], [cv.TravelerResume].[EnteredTime], [cv.TravelerResume].[EveningPhone], [cv.TravelerResume].[EveningPhoneStatus], [cv.TravelerResume].[Expertise], [cv.TravelerResume].[ExpertisePD], [cv.TravelerResume].[ExpertiseText], [cv.TravelerResume].[ExpertiseTextPD], [cv.TravelerResume].[Fax], [cv.TravelerResume].[FirstName], [cv.TravelerResume].[Hear], [cv.TravelerResume].[HearFriendName], [cv.TravelerResume].[Hot], [cv.TravelerResume].[InLeadQueue], [cv.TravelerResume].[InactiveStatusCode], [cv.TravelerResume].[InactiveStatusText], [cv.TravelerResume].[InternalRatingCode], [cv.TravelerResume].[InternalRatingText], [cv.TravelerResume].[InternalStatusCode], [cv.TravelerResume].[InternalStatusText], [cv.TravelerResume].[isFavorite], [cv.TravelerResume].[IsShiftAppUser], [cv.TravelerResume].[IsShiftAppUserManuallyChanged], [cv.TravelerResume].[LastName], [cv.TravelerResume].[LegalFirstName], [cv.TravelerResume].[LegalLastName], [cv.TravelerResume].[LicensureState], [cv.TravelerResume].[livetime], [cv.TravelerResume].[LockDown], [cv.TravelerResume].[MI], [cv.TravelerResume].[ModifiedTime], [cv.TravelerResume].[OrigRegistrationFrom], [cv.TravelerResume].[Pager], [cv.TravelerResume].[PagerStatus], [cv.TravelerResume].[PayCompanyID], [cv.TravelerResume].[payroll_empnum], [cv.TravelerResume].[pdPaycardAmount], [cv.TravelerResume].[pdPaycardFreq], [cv.TravelerResume].[pdPaycardNumber], [cv.TravelerResume].[pdPayrollMethod], [cv.TravelerResume].[pdReferralDate], [cv.TravelerResume].[pdReferralPaid], [cv.TravelerResume].[pdSchedulerID], [cv.TravelerResume].[pdStaffingComments], [cv.TravelerResume].[pdStartDate], [cv.TravelerResume].[pdTravFollowUp], [cv.TravelerResume].[pdTravWorkStatusBy], [cv.TravelerResume].[pdTravWorkStatusDate], [cv.TravelerResume].[pdhospid], [cv.TravelerResume].[pdmarketid], [cv.TravelerResume].[pdtravWorkStatus], [cv.TravelerResume].[perDiemDocStatus], [cv.TravelerResume].[perDiemRecruiterID], [cv.TravelerResume].[perDiemStatusCode], [cv.TravelerResume].[perdiemdocpct], [cv.TravelerResume].[Phone], [cv.TravelerResume].[pickStatus], [cv.TravelerResume].[preclosed], [cv.TravelerResume].[ProfessionCode], [cv.TravelerResume].[promoCode], [cv.TravelerResume].[Rating], [cv.TravelerResume].[RecruiterId], [cv.TravelerResume].[Reference], [cv.TravelerResume].[ReferenceCheck], [cv.TravelerResume].[ReferenceCompleted], [cv.TravelerResume].[ReferenceCompletedBy], [cv.TravelerResume].[referencePriority], [cv.TravelerResume].[ReferenceRequestTime], [cv.TravelerResume].[referenceStandard], [cv.TravelerResume].[ReferenceStatusCode], [cv.TravelerResume].[referenceStatusDate], [cv.TravelerResume].[ReferenceStatusText], [cv.TravelerResume].[referenceUrgent], [cv.TravelerResume].[ReferenceUserID], [cv.TravelerResume].[ReferenceUserName], [cv.TravelerResume].[referralCode], [cv.TravelerResume].[referralFriendName], [cv.TravelerResume].[referralPaid], [cv.TravelerResume].[Relocation], [cv.TravelerResume].[RelocationState], [cv.TravelerResume].[RelocationStateText], [cv.TravelerResume].[relocationnote], [cv.TravelerResume].[ResumeText], [cv.TravelerResume].[scrubSize], [cv.TravelerResume].[Shift], [cv.TravelerResume].[ShiftAppUserDate], [cv.TravelerResume].[ShiftAppUserId], [cv.TravelerResume].[ShiftAppUserNotes], [cv.TravelerResume].[SourceCode], [cv.TravelerResume].[StateCode], [cv.TravelerResume].[Status], [cv.TravelerResume].[subscribeBlast], [cv.TravelerResume].[subscribeJobMatches], [cv.TravelerResume].[subscribeNewsletter], [cv.TravelerResume].[subscribePhone], [cv.TravelerResume].[tAddress1], [cv.TravelerResume].[tCity1], [cv.TravelerResume].[tStateCode1], [cv.TravelerResume].[tZipCode1], [cv.TravelerResume].[TimeToCall], [cv.TravelerResume].[WorkStatusCode], [cv.TravelerResume].[ZipCode], [cv.Traveler].[UserID] AS [UserID0], [cv.Traveler].[CompanyID], [cv.Traveler].[CompanyType], [cv.Traveler].[dateOfBirth], [cv.Traveler].[Email] AS [Email0], [cv.Traveler].[FirstName] AS [FirstName0], [cv.Traveler].[GenderId], [cv.Traveler].[itRole], [cv.Traveler].[LastName] AS [LastName0], [cv.Traveler].[Password], [cv.Traveler].[PayrollTeamLeadID], [cv.Traveler].[pdPayrate], [cv.Traveler].[Phone] AS [Phone0], [cv.Traveler].[QMRole], [cv.Traveler].[referralCode] AS [referralCode0], [cv.Traveler].[SSN], [cv.Traveler].[Status] AS [Status0], [cv.Traveler].[UserName], [cv.Traveler].[UserType], [cv.VendorSubmittal].[id] AS [id1], [cv.VendorSubmittal].[AccountManagerNote], [cv.VendorSubmittal].[CurrentStageId], [cv.VendorSubmittal].[DateSubmitted], [cv.VendorSubmittal].[JobId] AS [JobId0], [cv.VendorSubmittal].[Note] AS [Note0], [cv.VendorSubmittal].[SubmitedByUserId], [cv.VendorSubmittal].[VendorCandidateId], [cv.VendorSubmittal].[VendorRate], [cv.VendorSubmittal.VendorCandidate].[Id] AS [Id2], [cv.VendorSubmittal.VendorCandidate].[Address1], [cv.VendorSubmittal.VendorCandidate].[Address2] AS [Address20], [cv.VendorSubmittal.VendorCandidate].[AvailableStartDate], [cv.VendorSubmittal.VendorCandidate].[City] AS [City0], [cv.VendorSubmittal.VendorCandidate].[DOB], [cv.VendorSubmittal.VendorCandidate].[Email] AS [Email1], [cv.VendorSubmittal.VendorCandidate].[FirstName] AS [FirstName1], [cv.VendorSubmittal.VendorCandidate].[LastName] AS [LastName1], [cv.VendorSubmittal.VendorCandidate].[MiddleName], [cv.VendorSubmittal.VendorCandidate].[Note] AS [Note1], [cv.VendorSubmittal.VendorCandidate].[OldUserId], [cv.VendorSubmittal.VendorCandidate].[PreferredShiftTypeId], [cv.VendorSubmittal.VendorCandidate].[ProfessionId], [cv.VendorSubmittal.VendorCandidate].[SSN] AS [SSN0], [cv.VendorSubmittal.VendorCandidate].[SellingPoints], [cv.VendorSubmittal.VendorCandidate].[StateId], [cv.VendorSubmittal.VendorCandidate].[Title], [cv.VendorSubmittal.VendorCandidate].[UserId] AS [UserId1], [cv.VendorSubmittal.VendorCandidate].[VendorContactId], [cv.VendorSubmittal.VendorCandidate].[VendorId], [cv.VendorSubmittal.VendorCandidate].[ZipCode] AS [ZipCode0], [cv.VendorSubmittal.VendorCandidate.Vendor].[Id] AS [Id3], [cv.VendorSubmittal.VendorCandidate.Vendor].[AccountingId], [cv.VendorSubmittal.VendorCandidate.Vendor].[AchAccountNumber], [cv.VendorSubmittal.VendorCandidate.Vendor].[AchAccountTypeId], [cv.VendorSubmittal.VendorCandidate.Vendor].[AchBankId], [cv.VendorSubmittal.VendorCandidate.Vendor].[AchBeneficiaryName], [cv.VendorSubmittal.VendorCandidate.Vendor].[AchRoutingNumber], [cv.VendorSubmittal.VendorCandidate.Vendor].[AchWireRoutingNumber], [cv.VendorSubmittal.VendorCandidate.Vendor].[AutomaticallyOfferNewFacilities], [cv.VendorSubmittal.VendorCandidate.Vendor].[BusinessTypeId], [cv.VendorSubmittal.VendorCandidate.Vendor].[DNBID], [cv.VendorSubmittal.VendorCandidate.Vendor].[DateEntered], [cv.VendorSubmittal.VendorCandidate.Vendor].[DateOfIncorporation], [cv.VendorSubmittal.VendorCandidate.Vendor].[FedTaxID], [cv.VendorSubmittal.VendorCandidate.Vendor].[GeneralLiabilityAggregrate], [cv.VendorSubmittal.VendorCandidate.Vendor].[GeneralLiabilityExp], [cv.VendorSubmittal.VendorCandidate.Vendor].[GeneralLiabilityPerOccurrence], [cv.VendorSubmittal.VendorCandidate.Vendor].[GeneralLiabilityUmbrellaCoverageRequired], [cv.VendorSubmittal.VendorCandidate.Vendor].[GeneralLiabilityWaiverOfSubrogation], [cv.VendorSubmittal.VendorCandidate.Vendor].[IncludeExcludeNotes], [cv.VendorSubmittal.VendorCandidate.Vendor].[IncorporatedInStateID], [cv.VendorSubmittal.VendorCandidate.Vendor].[LegalName], [cv.VendorSubmittal.VendorCandidate.Vendor].[NewFacilityCnt], [cv.VendorSubmittal.VendorCandidate.Vendor].[OperatingName], [cv.VendorSubmittal.VendorCandidate.Vendor].[PrimLocation], [cv.VendorSubmittal.VendorCandidate.Vendor].[ProfecionalLiabilityAggregrate], [cv.VendorSubmittal.VendorCandidate.Vendor].[ProfecionalLiabilityExp], [cv.VendorSubmittal.VendorCandidate.Vendor].[ProfecionalLiabilityPerOccurrence], [cv.VendorSubmittal.VendorCandidate.Vendor].[ProfecionalLiabilityUmbrellaCoverageRequired], [cv.VendorSubmittal.VendorCandidate.Vendor].[ProfecionalLiabilityWaiverOfSubrogation], [cv.VendorSubmittal.VendorCandidate.Vendor].[Qualivis1StatusTypeID], [cv.VendorSubmittal.VendorCandidate.Vendor].[Qualivis2StatusTypeID], [cv.VendorSubmittal.VendorCandidate.Vendor].[QualivisLocumMspStatusTypeID], [cv.VendorSubmittal.VendorCandidate.Vendor].[QualivisLocumStatusTypeID], [cv.VendorSubmittal.VendorCandidate.Vendor].[QualivisOhaStatusTypeId], [cv.VendorSubmittal.VendorCandidate.Vendor].[StatusTypeId], [cv.VendorSubmittal.VendorCandidate.Vendor].[SubAgreementExpDate], [cv.VendorSubmittal.VendorCandidate.Vendor].[SubAgreementSigned], [cv.VendorSubmittal.VendorCandidate.Vendor].[SubAgreementSignedDate], [cv.VendorSubmittal.VendorCandidate.Vendor].[SymmetryMSPStatusTypeID], [cv.VendorSubmittal.VendorCandidate.Vendor].[SymmetryStatusTypeID], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaAggregateLimit], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaAuto], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaCoverageRequired], [cv.VendorSubmittal.VendorCandidate.Vendor].[AutoExp], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaWaiverSubrogation], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaCyber], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaCyberCoverage], [cv.VendorSubmittal.VendorCandidate.Vendor].[CyberExp], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaCyberWaiverSubrogation], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaDOCoverage], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaDOCoverageRequired], [cv.VendorSubmittal.VendorCandidate.Vendor].[DoExp], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaDOWaiverSubrogation], [cv.VendorSubmittal.VendorCandidate.Vendor].[EmployeeCrimeExp], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaEmployeeCrimeTheftDishonesty], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaCrimeWaiverSubrogation], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaExp], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaNotes], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaPerOccurrence], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaRequiredLanguage], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaSexualAssaultCoverage], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaSexualAssaultCoverageRequired], [cv.VendorSubmittal.VendorCandidate.Vendor].[SexualAssaultExp], [cv.VendorSubmittal.VendorCandidate.Vendor].[UmbrellaSexualAssaultWaiverSubrogation], [cv.VendorSubmittal.VendorCandidate.Vendor].[WorkersCompDisease], [cv.VendorSubmittal.VendorCandidate.Vendor].[WorkersCompWCAccident], [cv.VendorSubmittal.VendorCandidate.Vendor].[WorkersCompExp], [cv.VendorSubmittal.VendorCandidate.Vendor].[WorkersCompLimit], [cv.VendorSubmittal.VendorCandidate.Vendor].[WorkersCompUmbrellaCoverageRequired], [cv.VendorSubmittal.VendorCandidate.Vendor].[WorkersCompWaiverOfSubrogation], [cv.ResumeSubmitInfo].[submitID], [cv.ResumeSubmitInfo].[Accept], [cv.ResumeSubmitInfo].[AdditionalInfo], [cv.ResumeSubmitInfo].[Anyone], [cv.ResumeSubmitInfo].[Choises1], [cv.ResumeSubmitInfo].[Choises2], [cv.ResumeSubmitInfo].[Choises3], [cv.ResumeSubmitInfo].[ColorStatus], [cv.ResumeSubmitInfo].[CountInMetrics], [cv.ResumeSubmitInfo].[CurrentlyMaking], [cv.ResumeSubmitInfo].[DayShift], [cv.ResumeSubmitInfo].[DayShiftR], [cv.ResumeSubmitInfo].[DeleteReason], [cv.ResumeSubmitInfo].[EveningShift], [cv.ResumeSubmitInfo].[EveningShiftR], [cv.ResumeSubmitInfo].[HospCity], [cv.ResumeSubmitInfo].[HospID], [cv.ResumeSubmitInfo].[HospName], [cv.ResumeSubmitInfo].[HospState], [cv.ResumeSubmitInfo].[ImportantFactor], [cv.ResumeSubmitInfo].[IsExtension], [cv.ResumeSubmitInfo].[Location], [cv.ResumeSubmitInfo].[MarketingCandidate], [cv.ResumeSubmitInfo].[NightShift], [cv.ResumeSubmitInfo].[NightShiftR], [cv.ResumeSubmitInfo].[Notes], [cv.ResumeSubmitInfo].[Nurse], [cv.ResumeSubmitInfo].[Offer], [cv.ResumeSubmitInfo].[OfferLocation], [cv.ResumeSubmitInfo].[OtherPosition], [cv.ResumeSubmitInfo].[PayRate], [cv.ResumeSubmitInfo].[PreferShift], [cv.ResumeSubmitInfo].[PreferShiftR], [cv.ResumeSubmitInfo].[Rate], [cv.ResumeSubmitInfo].[Rating] AS [Rating0], [cv.ResumeSubmitInfo].[ResumeInfoUserId], [cv.ResumeSubmitInfo].[Serious], [cv.ResumeSubmitInfo].[SeriousR], [cv.ResumeSubmitInfo].[Shift] AS [Shift0], [cv.ResumeSubmitInfo].[Specialty], [cv.ResumeSubmitInfo].[SpecialtyUnits1], [cv.ResumeSubmitInfo].[SpecialtyUnits2], [cv.ResumeSubmitInfo].[SpecialtyUnits3], [cv.ResumeSubmitInfo].[SpecialtyYears1], [cv.ResumeSubmitInfo].[SpecialtyYears2], [cv.ResumeSubmitInfo].[SpecialtyYears3], [cv.ResumeSubmitInfo].[Status] AS [Status1], [cv.ResumeSubmitInfo].[StatusDate], [cv.ResumeSubmitInfo].[Submittime], [cv.ResumeSubmitInfo].[SwingShift], [cv.ResumeSubmitInfo].[SwingShiftR], [cv.ResumeSubmitInfo].[Time1], [cv.ResumeSubmitInfo].[Time2], [cv.ResumeSubmitInfo].[Time3], [cv.ResumeSubmitInfo].[UserID] AS [UserID2], [cv.ResumeSubmitInfo].[WhichOne], [cv.ResumeSubmitInfo].[WorkingWithOther], [cv.ResumeSubmitInfo].[WorkingWithOtherR], [cv.Job].[JobID] AS [JobID1], [cv.Job].[AltShift_Fl], [cv.Job].[BidMax], [cv.Job].[BidMin], [cv.Job].[Billingrate], [cv.Job].[Billruleid], [cv.Job].[BlendedBillRate], [cv.Job].[Bonus], [cv.Job].[City] AS [City1], [cv.Job].[Duration], [cv.Job].[EmploymentTypeCode], [cv.Job].[EmploymentTypeText], [cv.Job].[EnteredTime] AS [EnteredTime0], [cv.Job].[Expertise] AS [Expertise0], [cv.Job].[ExpertiseCode], [cv.Job].[ExpertiseText] AS [ExpertiseText0], [cv.Job].[HIdeFromVendors], [cv.Job].[Hold], [cv.Job].[HospID] AS [HospID0], [cv.Job].[Hot] AS [Hot0], [cv.Job].[Hours], [cv.Job].[HoursAlt], [cv.Job].[IsBid], [cv.Job].[IsMarginBooster], [cv.Job].[IsOnHold], [cv.Job].[IsPriority], [cv.Job].[IsStar], [cv.Job].[JobDescription], [cv.Job].[JobEnteredFrom], [cv.Job].[JobOpenReasonId], [cv.Job].[JobStatusID], [cv.Job].[JobStatusText], [cv.Job].[ModifiedBy], [cv.Job].[ModifiedTime] AS [ModifiedTime0], [cv.Job].[NumView], [cv.Job].[PendingDelete], [cv.Job].[Positions], [cv.Job].[PreCalcContractedBaseRateAfterFees], [cv.Job].[PreCalcSpecialBaseRateAfterFees], [cv.Job].[ProfessionCode] AS [ProfessionCode0], [cv.Job].[ProfessionText], [cv.Job].[Rapidresponse], [cv.Job].[Rate] AS [Rate0], [cv.Job].[Rate2], [cv.Job].[Rateeve], [cv.Job].[Rateeve2], [cv.Job].[Ratenight], [cv.Job].[Ratenight2], [cv.Job].[RatingId], [cv.Job].[RecruiterID] AS [RecruiterID0], [cv.Job].[Reference] AS [Reference0], [cv.Job].[ReleaseSchedulingEnabled], [cv.Job].[ReleaseStatusId], [cv.Job].[ReqCertificateID], [cv.Job].[RequirementID], [cv.Job].[RequirementText], [cv.Job].[SampleMarginId], [cv.Job].[ShiftAltH], [cv.Job].[ShiftAltM], [cv.Job].[ShiftAltToH], [cv.Job].[ShiftAltToM], [cv.Job].[ShiftCode], [cv.Job].[ShiftH], [cv.Job].[ShiftHours], [cv.Job].[ShiftM], [cv.Job].[ShiftStartTime], [cv.Job].[ShiftText], [cv.Job].[ShiftToH], [cv.Job].[ShiftToM], [cv.Job].[Shifts], [cv.Job].[ShiftsAlt], [cv.Job].[SiteID], [cv.Job].[Star_bonus], [cv.Job].[Star_commission], [cv.Job].[Star_position], [cv.Job].[Star_typeid], [cv.Job].[StartDate], [cv.Job].[StateCode] AS [StateCode0], [cv.Job].[StateText], [cv.Job].[Status] AS [Status2], [cv.Job].[Title] AS [Title0], [cv.Job].[UnitId], [cv.Job].[UserID] AS [UserID3], [cv.Job].[VendorRateOverride], [cv.Job].[ZipCode] AS [ZipCode1], [cv.Job.Hospital].[hospid] AS [hospid1], [cv.Job.Hospital].[accountMgrId], [cv.Job.Hospital].[AccountReviewFrequencyId], [cv.Job.Hospital].[AccountSpecialistId], [cv.Job.Hospital].[acctMgrID] AS [acctMgrID0], [cv.Job.Hospital].[ahContractEndDate], [cv.Job.Hospital].[ahContractStartDate], [cv.Job.Hospital].[ahContractStatus], [cv.Job.Hospital].[ahOffered], [cv.Job.Hospital].[benefitProvided], [cv.Job.Hospital].[billadd], [cv.Job.Hospital].[billingMethod], [cv.Job.Hospital].[CCisDecisionMaker], [cv.Job.Hospital].[CNOisDecisionMaker], [cv.Job.Hospital].[callForJobs], [cv.Job.Hospital].[CallsOffFrequently], [cv.Job.Hospital].[cancelChargeAmt], [cv.Job.Hospital].[cancelChargeType], [cv.Job.Hospital].[cancelFeeFreq], [cv.Job.Hospital].[cancelFeeFreqAmt], [cv.Job.Hospital].[cancelFeePct], [cv.Job.Hospital].[cancelPolicy], [cv.Job.Hospital].[cancelPolicyText], [cv.Job.Hospital].[cancelTerms], [cv.Job.Hospital].[chargeRate], [cv.Job.Hospital].[COFreq_10], [cv.Job.Hospital].[COFreq_12], [cv.Job.Hospital].[COFreq_8], [cv.Job.Hospital].[COFreq_A], [cv.Job.Hospital].[COFreqAmt_10], [cv.Job.Hospital].[COFreqAmt_12], [cv.Job.Hospital].[COFreqAmt_8], [cv.Job.Hospital].[COFreqAmt_A], [cv.Job.Hospital].[COHrs_10], [cv.Job.Hospital].[COHrs_12], [cv.Job.Hospital].[COHrs_8], [cv.Job.Hospital].[COHrs_A], [cv.Job.Hospital].[contact] AS [contact0], [cv.Job.Hospital].[contractDueDate], [cv.Job.Hospital].[contractEndDate], [cv.Job.Hospital].[contractEnteredBy], [cv.Job.Hospital].[contractEnteredTime], [cv.Job.Hospital].[contractModifiedBy], [cv.Job.Hospital].[contractModifiedTime], [cv.Job.Hospital].[contractStDate], [cv.Job.Hospital].[contractStartDate], [cv.Job.Hospital].[contractStatus], [cv.Job.Hospital].[convertFeeCont_1], [cv.Job.Hospital].[convertFeeCont_2], [cv.Job.Hospital].[convertFeeCont_3], [cv.Job.Hospital].[convertFeeWeeks_1], [cv.Job.Hospital].[convertFeeWeeks_2], [cv.Job.Hospital].[convertFeeWeeks_3], [cv.Job.Hospital].[convertFees_1], [cv.Job.Hospital].[convertFees_2], [cv.Job.Hospital].[convertFees_3], [cv.Job.Hospital].[creditLastChecked], [cv.Job.Hospital].[csystem], [cv.Job.Hospital].[dateDeleted], [cv.Job.Hospital].[DateM], [cv.Job.Hospital].[DateMBilling], [cv.Job.Hospital].[DateMContract], [cv.Job.Hospital].[dateRFP], [cv.Job.Hospital].[dayot], [cv.Job.Hospital].[discountDays], [cv.Job.Hospital].[discountPct], [cv.Job.Hospital].[EACisDecisionMaker], [cv.Job.Hospital].[editFlag], [cv.Job.Hospital].[editedTime], [cv.Job.Hospital].[email] AS [email2], [cv.Job.Hospital].[enteredTime] AS [enteredTime1], [cv.Job.Hospital].[exceptionRules], [cv.Job.Hospital].[ExtDiscount], [cv.Job.Hospital].[ExtDiscountType], [cv.Job.Hospital].[extraName], [cv.Job.Hospital].[facilityProfile], [cv.Job.Hospital].[FacilityProfileGroupId], [cv.Job.Hospital].[facility_type], [cv.Job.Hospital].[faxno], [cv.Job.Hospital].[featuredLogo], [cv.Job.Hospital].[fedExApp], [cv.Job.Hospital].[GeoLocation], [cv.Job.Hospital].[GooglePlaceId], [cv.Job.Hospital].[grossReceiptTax], [cv.Job.Hospital].[GUARFreq_10], [cv.Job.Hospital].[GUARFreq_12], [cv.Job.Hospital].[GUARFreq_8], [cv.Job.Hospital].[GUARFreq_A], [cv.Job.Hospital].[GUARFreqAmt_10], [cv.Job.Hospital].[GUARFreqAmt_12], [cv.Job.Hospital].[GUARFreqAmt_8], [cv.Job.Hospital].[GUARFreqAmt_A], [cv.Job.Hospital].[GUARHrs_10], [cv.Job.Hospital].[GUARHrs_12], [cv.Job.Hospital].[GUARHrs_8], [cv.Job.Hospital].[GUARHrs_A], [cv.Job.Hospital].[GuidId], [cv.Job.Hospital].[hospAddress], [cv.Job.Hospital].[hospCancelPhone], [cv.Job.Hospital].[hospCC], [cv.Job.Hospital].[hospCCCelNo], [cv.Job.Hospital].[hospCCContactRank], [cv.Job.Hospital].[hospCCEmail], [cv.Job.Hospital].[hospCCEmailBlastChecked], [cv.Job.Hospital].[hospCCFaxNo], [cv.Job.Hospital].[HospCcLastUpdated], [cv.Job.Hospital].[hospCCTelNo], [cv.Job.Hospital].[hospCity] AS [hospCity0], [cv.Job.Hospital].[hospCNO], [cv.Job.Hospital].[hospCNOCelNo], [cv.Job.Hospital].[hospCNOContactRank], [cv.Job.Hospital].[hospCNOEmail], [cv.Job.Hospital].[hospCNOEmailBlastChecked], [cv.Job.Hospital].[hospCNOFaxNo], [cv.Job.Hospital].[HospCnoLastUpdated], [cv.Job.Hospital].[hospCNOTelNo], [cv.Job.Hospital].[hospConfirmPhone], [cv.Job.Hospital].[hospEAC], [cv.Job.Hospital].[hospEACCelNo], [cv.Job.Hospital].[hospEACContactRank], [cv.Job.Hospital].[hospEACEmail], [cv.Job.Hospital].[hospEACEmailBlastChecked], [cv.Job.Hospital].[hospEACFaxNo], [cv.Job.Hospital].[HospEacLastUpdated], [cv.Job.Hospital].[hospEACTelNo], [cv.Job.Hospital].[hospHousing], [cv.Job.Hospital].[hospHousingAmt], [cv.Job.Hospital].[hospMRC], [cv.Job.Hospital].[hospMRCCelNo], [cv.Job.Hospital].[hospMRCContactRank], [cv.Job.Hospital].[hospMRCEmail], [cv.Job.Hospital].[hospMRCEmailBlastChecked], [cv.Job.Hospital].[hospMRCFaxNo], [cv.Job.Hospital].[HospMrcLastUpdated], [cv.Job.Hospital].[hospMRCTelNo], [cv.Job.Hospital].[hospName] AS [hospName0], [cv.Job.Hospital].[hospNote], [cv.Job.Hospital].[hospNumBeds], [cv.Job.Hospital].[hospOrientation], [cv.Job.Hospital].[hospPDC], [cv.Job.Hospital].[hospPDCCelNo], [cv.Job.Hospital].[hospPDCTelNo], [cv.Job.Hospital].[hospPermNote], [cv.Job.Hospital].[hospPhone], [cv.Job.Hospital].[hospSEC], [cv.Job.Hospital].[hospSECCelNo], [cv.Job.Hospital].[hospSECContactRank], [cv.Job.Hospital].[hospSECEmail], [cv.Job.Hospital].[hospSECEmailBlastChecked], [cv.Job.Hospital].[hospSECFaxNo], [cv.Job.Hospital].[HospSecLastUpdated], [cv.Job.Hospital].[hospSECTelNo], [cv.Job.Hospital].[hospState] AS [hospState0], [cv.Job.Hospital].[HospStateId], [cv.Job.Hospital].[hospTNC], [cv.Job.Hospital].[hospTNCCelNo], [cv.Job.Hospital].[hospTNCContactRank], [cv.Job.Hospital].[hospTNCEmail], [cv.Job.Hospital].[hospTNCEmailBlastChecked], [cv.Job.Hospital].[hospTNCFaxNo], [cv.Job.Hospital].[HospTncLastUpdated], [cv.Job.Hospital].[hospTNCTelNo], [cv.Job.Hospital].[hospTotStaffedBeds], [cv.Job.Hospital].[hospType], [cv.Job.Hospital].[hospTypeofcontrol], [cv.Job.Hospital].[hospWebsite], [cv.Job.Hospital].[hospZip], [cv.Job.Hospital].[hospitalSystemCode], [cv.Job.Hospital].[HospitalTypeId], [cv.Job.Hospital].[hospitalreq], [cv.Job.Hospital].[imagePath], [cv.Job.Hospital].[instructions], [cv.Job.Hospital].[isDeleted] AS [isDeleted0], [cv.Job.Hospital].[isMagnet], [cv.Job.Hospital].[isRFP], [cv.Job.Hospital].[isTeaching], [cv.Job.Hospital].[lastEditedBy], [cv.Job.Hospital].[latitude], [cv.Job.Hospital].[LocalTravelerInfo], [cv.Job.Hospital].[longitude], [cv.Job.Hospital].[MRCisDecisionMaker], [cv.Job.Hospital].[manReference], [cv.Job.Hospital].[maxLodging], [cv.Job.Hospital].[maxMeal], [cv.Job.Hospital].[maxMiles], [cv.Job.Hospital].[milesCents], [cv.Job.Hospital].[milesFreq], [cv.Job.Hospital].[milesFreqAmt], [cv.Job.Hospital].[milesPaid], [cv.Job.Hospital].[noContract], [cv.Job.Hospital].[oldHousingAmt], [cv.Job.Hospital].[onCallRate], [cv.Job.Hospital].[OrientDetails], [cv.Job.Hospital].[OrientHours], [cv.Job.Hospital].[originatorID], [cv.Job.Hospital].[paContractEndDate], [cv.Job.Hospital].[paContractStartDate], [cv.Job.Hospital].[paContractStatus], [cv.Job.Hospital].[paOffered], [cv.Job.Hospital].[ParentID], [cv.Job.Hospital].[paybackPct], [cv.Job.Hospital].[payroll], [cv.Job.Hospital].[payrollLiasonId], [cv.Job.Hospital].[pdContractEndDate], [cv.Job.Hospital].[pdContractStartDate], [cv.Job.Hospital].[pdContractStatus], [cv.Job.Hospital].[pdOffered], [cv.Job.Hospital].[pdmarketid] AS [pdmarketid0], [cv.Job.Hospital].[pendingDelete] AS [pendingDelete0], [cv.Job.Hospital].[perdiemContractStatus], [cv.Job.Hospital].[permContractEndDate], [cv.Job.Hospital].[permContractStartDate], [cv.Job.Hospital].[permContractStatus], [cv.Job.Hospital].[permOffered], [cv.Job.Hospital].[permanentContractStatus], [cv.Job.Hospital].[printInvoices], [cv.Job.Hospital].[prospectorLastContactDate], [cv.Job.Hospital].[prospectorLastContactNoteTypeID], [cv.Job.Hospital].[QBParentObject], [cv.Job.Hospital].[QMSystemCode], [cv.Job.Hospital].[RatingId] AS [RatingId0], [cv.Job.Hospital].[req1], [cv.Job.Hospital].[req2], [cv.Job.Hospital].[req3], [cv.Job.Hospital].[req4], [cv.Job.Hospital].[req5], [cv.Job.Hospital].[req6], [cv.Job.Hospital].[req7], [cv.Job.Hospital].[requiredTimecard], [cv.Job.Hospital].[rrContractEndDate], [cv.Job.Hospital].[rrContractStartDate], [cv.Job.Hospital].[rrContractStatus], [cv.Job.Hospital].[rrOffered], [cv.Job.Hospital].[SecisDecisionMaker], [cv.Job.Hospital].[SellingPoints] AS [SellingPoints0], [cv.Job.Hospital].[showToProspector], [cv.Job.Hospital].[TNCisDecisionMaker], [cv.Job.Hospital].[targetCustomer], [cv.Job.Hospital].[targetMargin], [cv.Job.Hospital].[targetPayRate], [cv.Job.Hospital].[telno], [cv.Job.Hospital].[TherapyAccountManagerId], [cv.Job.Hospital].[title] AS [title1], [cv.Job.Hospital].[ToughPlaceToWork], [cv.Job.Hospital].[trContractEndDate], [cv.Job.Hospital].[trContractStartDate], [cv.Job.Hospital].[trContractStatus], [cv.Job.Hospital].[trOffered], [cv.Job.Hospital].[TravelersLoveWorkingHere], [cv.Job.Hospital].[weekot], [cv.Job.Profession].[Id] AS [Id4], [cv.Job.Profession].[Abbreviation], [cv.Job.Profession].[Name], [cv.Job.Profession].[ProfessionTypeId], [cv.Job.Profession].[SortOrder], [cv.Job.Unit].[Id] AS [Id5], [cv.Job.Unit].[CostCenter], [cv.Job.Unit].[HospId] AS [HospId2], [cv.Job.Unit].[Name] AS [Name0], [cv.Job.Unit].[UnitDescriptionFormId], [cv.Job.Unit].[UpdatedBy], [cv.Job.Unit].[UpdatedDate], ROW_NUMBER() OVER(ORDER BY [cv].[CreatedOn] DESC) AS [__RowNumber__]
  5. FROM [ClientSubmittals] AS [cv]
  6. INNER JOIN [dbo].[ClientSubmittalsStatuses] AS [cv.Status] ON [cv].[StatusId] = [cv.Status].[Id]
  7. LEFT JOIN [ResumeInfo] AS [cv.TravelerResume] ON [cv].[TravelerId] = [cv.TravelerResume].[UserID]
  8. LEFT JOIN [UserInfo] AS [cv.Traveler] ON [cv].[TravelerId] = [cv.Traveler].[UserID]
  9. LEFT JOIN [dbo].[VendorSubmittals] AS [cv.VendorSubmittal] ON [cv].[VendorSubmitId] = [cv.VendorSubmittal].[id]
  10. LEFT JOIN [VendorCandidates] AS [cv.VendorSubmittal.VendorCandidate] ON [cv.VendorSubmittal].[VendorCandidateId] = [cv.VendorSubmittal.VendorCandidate].[Id]
  11. LEFT JOIN [dbo].[Vendors] AS [cv.VendorSubmittal.VendorCandidate.Vendor] ON [cv.VendorSubmittal.VendorCandidate].[VendorId] = [cv.VendorSubmittal.VendorCandidate.Vendor].[Id]
  12. LEFT JOIN [dbo].[ResumeSubmitInfo] AS [cv.ResumeSubmitInfo] ON [cv].[ResumeSubmitInfoId] = [cv.ResumeSubmitInfo].[submitID]
  13. LEFT JOIN [JobInfo] AS [cv.Job] ON [cv].[JobId] = [cv.Job].[JobID]
  14. LEFT JOIN [infoHospital] AS [cv.Job.Hospital] ON [cv.Job].[HospID] = [cv.Job.Hospital].[hospid]
  15. LEFT JOIN [Candidate].[Professions] AS [cv.Job.Profession] ON [cv.Job].[ProfessionCode] = [cv.Job.Profession].[Id]
  16. LEFT JOIN [Units] AS [cv.Job.Unit] ON [cv.Job].[UnitId] = [cv.Job.Unit].[Id]
  17. WHERE (((((([cv].[IsDeleted] = 0) AND [cv].[JobId] IS NOT NULL) AND [cv.Job].[HospID] IS NOT NULL) AND [cv].[Url] IS NOT NULL) AND (([cv].[ResumeSubmitInfoId] IS NULL OR [cv.ResumeSubmitInfo].[Status] IS NULL) OR [cv.ResumeSubmitInfo].[Status] NOT IN (-1, 0))) AND (([cv].[VendorSubmitId] IS NULL OR ([cv.VendorSubmittal].[CurrentStageId] = 0)) OR [cv.VendorSubmittal].[CurrentStageId] IN (1, 2, 3, 4, 5, 14, 16))) AND (([cv].[Id] > 0) AND ([cv.Job].[HospID] IN (38928, 38930, 38931) OR [cv.Job].[UnitId] IN (3179, 3180, 3181, 3182, 3191, 3194, 3199, 3201)))
  18. ) AS [t]
  19. WHERE ([t].[__RowNumber__] > @__p_1) AND ([t].[__RowNumber__] <= (@__p_1 + @__p_2))
  20. System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ResumeInfoUserId'.
  21. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
  22. at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
  23. at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
  24. at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
  25. at System.Data.SqlClient.SqlDataReader.get_MetaData()
  26. at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
  27. at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
  28. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
  29. at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues)
  30. ClientConnectionId:8d0a3774-371e-464b-9723-9bcf9da122a6
  31. Error Number:207,State:1,Class:16
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!