Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT [progres_individualid]
- ,[progres_indvidualid]
- ,[progres_registrationgroupid]
- ,[progres_registrationgroupidname]
- ,[progres_isbiometricallyenrolled]
- ,[progres_isbiometricallyenrolledname]
- ,[progres_phonenumber]
- ,[progres_primaryphonenumber]
- ,[progres_relationshiptofp]
- ,[progres_relationshiptofpname]
- ,[progres_refugeestatuscategoryname]
- ,[progres_businessunit]
- ,[progres_businessunitname]
- ,[Progres_ProcessDetail]
- ,[progres_processstatusdate]
- ,[progres_processdetailname]
- ,[progres_lastreentrydate]
- ,[progres_sex]
- ,[progres_sexname]
- ,[statuscode]
- ,[createdby]
- ,[createdbyname]
- ,[createdon]
- ,[modifiedby]
- ,[modifiedbyname]
- ,[modifiedbyyominame]
- ,[modifiedon]
- ,[modifiedonbehalfby]
- ,[modifiedonbehalfbyname]
- ,[modifiedonbehalfbyyominame]
- ,[progres_registrationdate]
- ,[overriddencreatedon]
- ,[progres_familyline]
- ,[progres_familylinename]
- ,[progres_familyname]
- ,[progres_familynamesoundslikeenglish]
- ,[progres_familynamesoundslikefrench]
- ,[progres_fathersname]
- ,[progres_givennamesoundslikeenglish]
- ,[progres_givennamesoundslikefrench]
- ,[progres_concatenatednamesoundslikeenglish]
- ,[progres_concatenatednamesoundslikefrench]
- ,[ownerid]
- ,[owneriddsc]
- ,[owneridname]
- ,[owneridtype]
- ,[owneridyominame]
- ,[owningbusinessunit]
- ,[owningteam]
- ,[owninguser]
- ,[progres_address]
- ,[progres_addresscount]
- ,[progres_addresscount_date]
- ,[progres_addresscount_state]
- ,[progres_addressname]
- ,[progres_age]
- ,[progres_arrivaldate]
- ,[progres_biometricstatus]
- ,[progres_businessowner]
- ,[progres_businessownername]
- ,[progres_closedate]
- ,[progres_coalocationlevel1]
- ,[progres_coalocationlevel1name]
- ,[progres_coalocationlevel2]
- ,[progres_coalocationlevel2name]
- ,[progres_coalocationlevel3]
- ,[progres_coalocationlevel3name]
- ,[progres_coalocationlevel4]
- ,[progres_coalocationlevel4name]
- ,[progres_coalocationlevel5]
- ,[progres_coalocationlevel5name]
- ,[progres_comments]
- ,[progres_comments_displayfield]
- ,[progres_concatenatedname]
- ,[progres_contactdetails]
- ,[progres_contactdetailsname]
- ,[progres_coolocationlevel1]
- ,[progres_coolocationlevel1name]
- ,[progres_coolocationlevel2]
- ,[progres_coolocationlevel2name]
- ,[progres_coolocationlevel3]
- ,[progres_coolocationlevel3name]
- ,[progres_coolocationlevel4]
- ,[progres_coolocationlevel4name]
- ,[progres_coolocationlevel5]
- ,[progres_coolocationlevel5name]
- ,[progres_countryofasylumid]
- ,[progres_countryofasylumidname]
- ,[progres_countryoforiginid]
- ,[progres_countryoforiginidname]
- ,[progres_currentppg]
- ,[progres_currentppgname]
- ,[progres_currentuser]
- ,[progres_currentusername]
- ,[progres_currentuseryominame]
- ,[progres_datatransferrequestid]
- ,[progres_dateofbirth]
- ,[progres_placeofbirthcity]
- ,[progres_placeofbirthid]
- ,[progres_placeofbirthidname]
- ,[progres_deactivationid]
- ,[progres_sequencenumber]
- ,[progres_deceaseddate]
- ,[progres_departureinactivedate]
- ,[progres_deregistrationdate]
- ,[progres_document]
- ,[progres_entitlementcards]
- ,[progres_entrypointinhostcountryid]
- ,[progres_entrypointinhostcountryidname]
- ,[progres_fingerprintstatus]
- ,[progres_fingerprintstatusdate]
- ,[progres_fingerprintstatusname]
- ,[progres_fleddate]
- ,[progres_givenname]
- ,[progres_id]
- ,[progres_individualgovtrefno]
- ,[progres_maidenname]
- ,[progres_maritalstatus]
- ,[progres_maritalstatusname]
- ,[progres_maritalstatusdate]
- ,[progres_registrationreason]
- ,[progres_registrationreasonname]
- ,[progres_middlename]
- ,[progres_mobilenodeid]
- ,[progres_mobilenodeidname]
- ,[progres_mothersname]
- ,[progres_nameid]
- ,[progres_nationality]
- ,[progres_nationalitylookup]
- ,[progres_nationalitylookupname]
- ,[progres_nationalityname]
- ,[progres_statelessnessstatusname]
- ,[progres_v3guid]
- ,[progres_reentrynumber]
- ,[progres_createoraddtoregistrationgroup]
- ,[progres_createoraddtoregistrationgroupname]
- ,[statecode]
- ,[statecodename]
- ,[progres_processstatusdateprevious]
- ,[progres_refugeestatuscategorydate]
- ,[progres_refugeestatus]
- ,[progres_refugeestatusname]
- ,[StatusCodeName]
- ,[progres_refugeestatuscategory]
- ,[progres_originalalphabetname]
- ,[progres_relevantprocedures]
- ,[progres_relevantproceduresname]
- ,[progres_relevantworkexperience]
- ,[progres_relevantworkexperiencename]
- ,[progres_religionid]
- ,[progres_religionidname]
- ,[progres_softfielddate1]
- ,[progres_softfielddate1utc]
- ,[progres_softfielddate2]
- ,[progres_softfielddate2utc]
- ,[progres_softfielddate3]
- ,[progres_softfielddate3utc]
- ,[progres_softfieldflag1]
- ,[progres_softfieldflag1name]
- ,[progres_softfieldflag2]
- ,[progres_softfieldflag2name]
- ,[progres_softfieldflag3]
- ,[progres_softfieldflag3name]
- ,[progres_softfieldtext1]
- ,[progres_softfieldtext2]
- ,[progres_softfieldtext3]
- ,[progres_educationlevel]
- ,[progres_educationlevelname]
- ,[progres_ethnicityid]
- ,[progres_ethnicityidname]
- ,[progres_comments_nonrestrictedstore]
- ,[progres_comments_restrictedstore]
- ,[versionnumber]
- ,[Location]
- ,[progres_legalbasisdate]
- ,[progres_legalbasisname]
- FROM [DWH_V4].[dbo].[Filteredprogres_individual] I
- where I.progres_businessunit in ('7D14DA96-AACC-E811-80C5-00155D1CDD24','5E3738E7-A9CC-E811-80D8-001DD8B71FE5')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
