Brug for hjælp?
Skriv til data@sa.dk og få hjælp til at:

finde det, du søger
forstå det, du har fundet

Søgning » Arbejdsmarkedsportalen » TTCommonBooking

Arbejdsmarkedsportalen

Tabeloversigt ?

tblBonus
AllCompanies
tblBlnktForslagJobplan
tblBlnktAaJobplanLedig
tblForlobAkt
tblForlob
tblBPORegisteredLeave
TTCommonPersonAddress
ActivityBooking
tblBlnktAaMeddelelseJobplan
tblBlnktAaMeddelelseUdeblivelse
TTExternalOperatorSubContract
tblPersonStatusAbsenceHistory
CourseBasicData
JobOrder
tblPersonStatusClientInterviewHistory
TTCommonPerson
tblPersonStatusClientInterview
tblPersonStatusAbsence
tblKommunal
TTVisitationRegistrationHistory
TTExternalOperatorFrameContract
TTVisitationConsent
tblBlnktAaStatusKontaktforloeb
tblLabourMarketBalance
tblPersonStatusEnrollment
tblUnemploymentFundMembershipChangeLog
D_Time
TTVisitationCode
tblCprTemporaryAddressForeignHistory
tblUnemploymentFundMembershipArchive
JobplanVersion
F_MaalOpfoelgning
TTCommonAuthority
TTExternalOperatorPaymentModel
tblMinimumskrav
TTVisitationCV
TTVisitationRegistrationContactHistory
TTVisitationText
tblCprTemporaryAddressForeign
F_KommuneMaal
tblLogbogKontakt
tblSygperuger
TTCommonBookingTimeHistory
tblPersonStatusCivicConsent
tblPersonStatusCivicConsentHistory
tblPersonStatusContactGroup
tblPersonStatusContactGroupHistory
tblAlleKontaktData
TTCommonBookingTime
tblPersonGroupMarking
tblPersonGroupMarkingHistory
tblPersonStatusGroupProject
tblPersonStatusGroupProjectHistory
tblPersonStatusHealthLimitation
tblPersonStatusHealthLimitationHistory
tblPersonStatusMatch
tblPersonStatusMatchHistory
F_Indsatsliste_Historik
tblStamVirk
TTCommonAccessSubContractor
TTCommonBookingHistory
TTExternalOperatorLocation
TTExternalOperatorResultBonus
tblUsers
TTCommonBooking
TTCommonPersonAdditional
tblPersonStatusEnrollmentWarningDates
tblPersonStatusEnrollmentWarningDatesHistory
tblPersonStatusIllnessBenefit
tblPersonStatusIllnessBenefitHistory
tblUnemploymentFundMembership
tblIndplaceringsdato
TLAndenAktoerEffekt
TTCommonAuthorityToAuthority
TTCommonTargetGroup
TTExternalOperatorPersonReferral
TTExternalOperatorResultBonusMileStoneValue
TTVisitationInterviewType
tblInterviewLocationDetail
tblPersonStatusComment
tblPersonStatusProfessionCollection
Authority
ClassCourse
tblDurugeled
TLAmforaFleks
TTCommonPersonBelongsToAuthority
TTExternalOperatorAdditionalBonus
TTExternalOperatorEditStatus
TTExternalOperatorReferralAction
TTVisitationCase
ActivityStatus
JobOrderActivityType
TLKontaktUger
TLPeriod
TLPeriodHist
TTCommonCompanyRelation
TTExternalOperatorFrameContractValidPeriod
TTExternalOperatorMaximumBonusValue
tblBPORegisteredLeaveComment
tblLogbogKontaktMaal
tblNap
TTCommonCostType
TTCommonPersonTargetGroup
TTExternalOperatorAdditionalBonusIntervalValue
TTExternalOperatorExcludeExternalOperator
TTExternalOperatorPaymentGroupBonus
TTExternalOperatorReferral
TTExternalOperatorReferralPersonList
TTExternalOperatorResultBonusPlanedDurationValue
TTExternalOperatorStandardPaymentValue
tblBPORegisteredLeaveLog
tblCprTemporaryAddressHistory
JobDescription
F_Resultatloen
tblAkasseCvSamtaler
tblAmandaAktivering
tblFerieugeled
tblKontakt3mdr
TTCommonAMUCode
TTExternalOperatorPaymentGroup
TTExternalOperatorPaymentGroupPrice
TTExternalOperatorPaymentModelService
TTExternalOperatorResultBonusDropValue
TTExternalOperatorService
TTExternalOperatorStandardPayment
SA_Relation_mellem_Myndighed_CVR
tblAuthorityUnemploymentFundBranches
tblAuthorityUnemploymentFunds
tblCprTemporaryAddress
tblOccupationName
tblPersonStatusAuthorityMove
tblPersonStatusAuthorityMoveHistory
ActivityClientPaymentType
ActivityType
AuthorityCanUseCourse
JobplanVersionActivityShowing
tblBistand
tblPeriod
tblPersonStatusTemporaryResidence
tblRegioner
tblSygdom
tblSygperdage
TLKontaktUgeKalender
TTCommonAuthorityRelationType
TTCommonBookingSeatsBooked
TTCommonCountry
TTCommonInterval
TTCommonPeriodicalConditionType
TTCommonTargetGroupRange
TTExternalOperatorAdditionalBonusInterval
TTExternalOperatorPeriodType
TTExternalOperatorSubContractService
TTVisitationCodeType
tblOccupation
tblPersonStatusSocialAid
tblPersonStatusSustenanceHistory
ActivityBookingCategory
ActivityBookingCourseCategory
ActivityStatusCause
BottleneckAreas
Caseowner
CourseType
HMLIClassSeatBalance
Jobplan
D_BorgerAlderInterval
D_Myndighed
SA_AMP_Relation_mellem_Myndighed_CVR
tblAfBistandsLedper
tblEfterloen
tblFerieLedper
tblLedper
tblOpgorelser
tblSu
TTCommonCompany
TTCommonEthnicType
TTCommonInterviewTypeMapping
TTCommonTargetGroupBoolean
TTCommonTargetGroupParameter
TTExternalOperatorContactPerson
TTExternalOperatorFutureReferringAuthority
TTExternalOperatorReferralPersonListCPR
TTExternalOperatorSubcontractor
tblDiscoCodes
tblDUNAMUCodes
ActivityRule
AuthorityType
MinisterArea
D_Borger
D_Koen
D_MatchKategori
F_ResultatloenSum
tblAfKontor
tblAkassekontor
tblAkasser
TLPeriodTypeMinor
TTCommonContactPerson
TTCommonIntervalType
TTCommonPersonForsikringskategoriType
TTCommonPersonKoenType
TTCommonPostNr
TTExternalOperatorAgreementModel
TTExternalOperatorCriteriaType
TTExternalOperatorEffort
TTExternalOperatorEffortAllowedPeriodType
TTExternalOperatorPartialAgreement
TTExternalOperatorPlannedIntervalType
TTExternalOperatorReferralCPRTransfer
TTExternalOperatorReferralPartialAgreementRelation
TTVisitationRegistration
TTVisitationRegistrationContact
TTVisitationTextType
SA_Relation_TTCommonPerson
tblInterviewContactInformationDetail
D_Halvaar
D_Proveniens
SA_Kode_afgodkend
SA_Kode_Bit_Nej_Ja
SA_Kode_forskat
SA_Kode_klient
SA_Kode_Nej_Ja
SA_Kode_tblAfbistandsugeled_ars_l
SA_Kode_tblAlleKontaktData_aktiveringsmarkering
SA_Kode_tblAlleKontaktData_akttype
SA_Kode_tblAlleKontaktData_arstatus
SA_Kode_tblAlleKontaktData_kilde
SA_Kode_tblAlleKontaktData_modetyp
SA_Kode_tblAlleKontaktData_modftyp
SA_Kode_tblAlleKontaktData_nulst
SA_Kode_tblAlleKontaktData_samtmyndtype
SA_Kode_tblAmandaAktivering_akttype
SA_Kode_tblBistand_beregn
SA_Kode_tblBistand_bevil
SA_Kode_tblBonus_andaktor
SA_Kode_tblBonus_EFFEKTPER
SA_Kode_tblBonus_EFFEKTTYPE
SA_Kode_tblBonus_RESTFOR
SA_Kode_tblBonus_status
SA_Kode_tblFerieugeled_ars_l
SA_Kode_tblForlob_status
SA_Kode_tblIndplaceringsdato_dato
SA_Kode_tblIndplaceringsdato_kalenderuger_fmt
SA_Kode_tblIndplaceringsdato_ledighed_1aar_fmt
SA_Kode_tblIndplaceringsdato_refper_fmt
SA_Kode_tblIndplaceringsdato_tilmeldt
SA_Kode_tblKommunal_status
SA_Kode_tblKommunal_stforuaff
SA_Kode_tblKontakt3mdr_aktiveringsmarkering
SA_Kode_tblKontakt3mdr_ledighedsstatus
SA_Kode_tblKontakt3mdr_status
SA_Kode_tblKontakt3mdr_type
SA_Kode_tblKontakt3mdr_ydelfmt
SA_Kode_tblKontaktcv_cvsamtaleoverholdt
SA_Kode_tblKontaktcv_tilmeldfmt
SA_Kode_tblKontaktcv_type
SA_Kode_tblMinimumskrav_aldersgruppe
SA_Kode_tblMinimumskrav_ancfmt
SA_Kode_tblMinimumskrav_ancienni
SA_Kode_tblMinimumskrav_beskudd
SA_Kode_tblMinimumskrav_nulstil
SA_Kode_tblMinimumskrav_pasyddfmt
SA_Kode_tblMinimumskrav_status
SA_Kode_tblOpgorelser_aktivperiodedato
SA_Kode_tblOpgorelser_faldet
SA_Kode_tblOpgorelser_indplaceringsdato
SA_Kode_tblOpgorelser_tilmeldekategori
SA_Kode_tblPeriod_PERTID
SA_Kode_tblSygdom_sagsmk
SA_Kode_tblUsers_brugertype
SA_Kode_TTCommonAuthority_Active
SA_Kode_TTCommonBookingTime_Active
SA_Kode_TTCommonPersonAddress_Adressebeskyttelse
SA_Kode_TTExternalOperatorAdditionalBonus_BonusCeling
SA_Kode_TTExternalOperatorAdditionalBonus_DependingOnEffectType
SA_Kode_TTExternalOperatorAdditionalBonus_DependingOnTargetGroup
SA_Kode_TTExternalOperatorAdditionalBonus_GroupBonusValue
SA_Kode_TTExternalOperatorFrameContract_NationalTender
SA_Kode_TTExternalOperatorFrameContract_Priceindexregulate
SA_Kode_TTExternalOperatorFrameContract_ReturnVisitation
SA_Kode_TTExternalOperatorFrameContract_ReturnVisitationType
SA_Kode_TTExternalOperatorPaymentModel_AdditionalBonusExist
SA_Kode_TTExternalOperatorPaymentModel_DependingOnDuration
SA_Kode_TTExternalOperatorPaymentModel_ResultBonusExist
SA_Kode_TTExternalOperatorPaymentModel_SpiltOnParticipant
SA_Kode_TTExternalOperatorPaymentModel_SpiltOnTargetGroup
SA_Kode_TTExternalOperatorPaymentModelService_AdditionalService
SA_Kode_TTExternalOperatorPeriodType_NationalType
SA_Kode_TTExternalOperatorReferralAction_Approved
SA_Kode_TTExternalOperatorResultBonus_BonusDeclineExist
SA_Kode_TTExternalOperatorResultBonus_BonusDeclineType
SA_Kode_TTExternalOperatorResultBonus_BounusCeling
SA_Kode_TTExternalOperatorResultBonus_CeiteriaDependingOnEffectType
SA_Kode_TTExternalOperatorResultBonus_DependingOnDuration
SA_Kode_TTExternalOperatorResultBonus_DependingOnEffectType
SA_Kode_TTExternalOperatorSubContract_CallResponsibility
SA_Kode_TTVisitationCode_Active
SA_Kode_TTVisitationConsent_ConsentGiven
SA_Kode_TTVisitationInterviewType_InterviewInitiateType
SA_Kode_TTVisitationRegistrationHistory_IsFirstInContact
tblBeskfmt
tblCVSamtalestatus
tblDreamKoder
tblKommuner
tblKontaktcv
tblKursusRelation
tblLogbogKontaktHovedgrupper
tblPeriode
TLAmforaydelsestype
TLAndenAktoerEffektType
TLForanstaltning
TLKontaktForloebStatus
TLPeriodTypeMajor
TLRetTilBonus
TLRetTilDriftbetaling
TTCommonAuthorityType
TTCommonBookingStatus
TTCommonCompanyRelationStatus
TTCommonConsumerType
TTCommonCostAllocation
TTCommonPeriodUnitType
TTCommonPersonAddressType
TTCommonPersonAFTilmeldeStatus
TTCommonPersonAldersformatType
TTCommonPersonAuthorityRelationType
TTCommonPersonCivilstandType
TTCommonPersonHerkomst
TTCommonPersonKlientType
TTCommonPersonLandegruppe
TTCommonPersonPopulationType
TTCommonResourceType
TTCommonTargetGroupAkasse
TTCommonTargetGroupEthnicType
TTCommonTargetGroupInsuranceCategory
TTCommonTargetGroupParameterType
TTCommonTargetGroupType
TTExternalOperatorAdditionalBonusType
TTExternalOperatorAdditionalServiceType
TTExternalOperatorBillingStartType
TTExternalOperatorBonusCelingEffectType
TTExternalOperatorBookingModelType
TTExternalOperatorChosenInSubContract
TTExternalOperatorContractStatus
TTExternalOperatorContractType
TTExternalOperatorEffectType
TTExternalOperatorFrameContractTargetGroup
TTExternalOperatorIncludedInFrameContract
TTExternalOperatorPaymentModelEffectType
TTExternalOperatorPaymentModelPeriodType
TTExternalOperatorPaymentModelTargetGroup
TTExternalOperatorProcurement
TTExternalOperatorProcurementTargetGroup
TTExternalOperatorProgramType
TTExternalOperatorReferralActionType
TTExternalOperatorResultBonusPlannedIntervalType
TTExternalOperatorServiceType
TTExternalOperatorStandardPaymentType
TTExternalOperatorSubContractTargetGroup
TTVisitationConsentType
TTVisitationContactType
tblOccupationArea
tblOccupationGroup
SA_Kode_AbsenceTypeIdentifier
SA_KODE_Boolean
SA_KODE_BPOStatusId
SA_KODE_BPOType
SA_Kode_CauseTypeIdentifier
SA_Kode_ClientCategoryTypeIdentifier
SA_Kode_ContactGroupTypeIdentifier
SA_Kode_CurrentUnemploymentStatusTypeIdentifier
SA_Kode_IllnessBenefitCategoryTypeIdentifier
SA_Kode_InterviewContactTypeIdentifier
SA_Kode_InterviewTypeIdentifier
SA_Kode_MatchCategoryTypeIdentifier
SA_KODE_MembershipEndCause
SA_Kode_PeriodicCircumstanceTypeIdentifier
SA_KODE_PersonCaseStatus
SA_Kode_PersonGroupProjectTypeIdentifier
SA_Kode_SustenanceHistoryClassificationTypeIdentifer
SA_Kode_UnemploymentInsuranceCategoryTypeIdentifier
tblBPORegistrationType
tblJobOrderStatus
tblUnemploymentRegistrationType
SA_Kode_Bit_Boolean
SA_Kode_Int_Boolean
tblBPOLeavePopulation

Tabel

TTCommonBooking

Beskrivelse ?

The information on referral. Entry is inserted when referral is created. Keeps the current valid rows for a booking.

Størrelse (Antal rækker) ?

556593

Indhold (Kolonner/variable) ?

Navn	Indhold
TTCommonBookingID	primary key
ResourceID	subcontract ident
TTCommonResourceTypeID	The ressource the Consumer is booked to (Delaftaler)
ConsumerID	CPR nummer
TTCommonConsumerTypeID	The type of what or who that is booked til the resource (Person)
TTCommonBookingStatusID	id of Booking status
Created	Created timestamp
tblUsersID	user who created
TimeStamp	Created timestamp
LastModified	TimeStamp for last modification of data in DVR
TransactionID	GUID is same across TTCommonBooking, TTCommonBookingHistory, TTCommonBookingTime, TTCommonBookingTimeHistory and TTExternalOperatorReferralAction tables to identify rows created together.