社保卡鉴权就是把卡管系统的数据信息通过中间库同步到要同步的数据库中，详细流程如下：
1把参保人az01表的aaz007字段和aac001字段以及baz361=1字段插入card_ckk_add_todo表中
Insert into card_ckk_add_todo select aaz007, aac001 ,’1’,”,”,”,”,”,” from az01 where
Aac001 in (seelct aac001 from ac01 where aac002 =’'430603195503173013'’)
2.查询基础库人员信息表，包括aac002 ,aac003,aac006,aae006,aac060,aae550信息
select * from jck_ac47@hnjck Where aac002 ='430603195503173013'
3.修改 基础库人员信息
<DATAEXCHANGE>
0003-S-01|st_card_pow|24809CDD0E9FB9275FFE07E751BC1D85
<HEADER>
V1.0|43000060120190219180204097|430000601|430000001|430000601|43000060120190219180204097|002|1|20190219180204|20190219|
180204|0
<PSINF>
101087288693|430523196812240042|170803021034
<CHANGEINF>
AAC060|2|1
<END>
4.注销基础库人员信息
<DATAEXCHANGE>
0005-S-01|st_card_pow|24809CDD0E9FB9275FFE07E751BC1D85
<HEADER>
V1.0|43000060120190129000004099|430000601|430000000|430000601|43000060120190129000004099|003|1|20190129151117|20190129|
151117|0
<PSINF>
100929075342|440221194311291611|任邦才|其他
<END>
5.查询基础库卡信息表，包括aaz500,aaz501,aaz507,baz361,aaz002,baz362信息
Select * From jck_az20@hnjck Where aac001 In(select aac001 from jck_ac47@hnjck Where aac002 ='430603195503173013' )
6.修改 基础库卡信息
update jck_az20@hnjck set baz361 ='0',aaz002 =null,baz362= null where aac001 In(select aac001 from jck_ac47@hnjck
Where aac002 ='430603195503173013' )
7.注销基础库卡信息
<DATAEXCHANGE>
1003-S-01|st_card_pow|24809CDD0E9FB9275FFE07E751BC1D85
<HEADER>
V1.0|43000060120190219000004099|430000601|430000000|430000601|43000060120190219000004099|005|1|20190219145520|20190219|
145520|0
<CARDMODIFY>
J45058511|431100D15600000524D1D6B73A9CAB75|100430690816|431100|20190219181501|2|9
<END>
8，持卡库人员新增查询,包括az361,aaz002,baz362字段
select * from jck_ac17@hnjck where aac001 In(select aac001 from jck_ac47@hnjck
Where aac002 ='430603195503173013' )
9，持卡库人员新增
insert into jck_ac17@hnjck select * from jck_ac17_temp_finish@hnjck where aac001 in (select aac001 from
jck_ac47@hnjck Where aac002 ='430603195503173013')
10持卡库人员新增修改
update jck_ac17@hnjck set baz361 = '1',aaz002='',baz362='' where aac001 In(select aac001 from jck_ac47@hnjck
Where aac002 ='430603195503173013' )
11..查询持卡库人员信息表，包括aac998,aac003,aae006,aac060,aae550，aae006信息
Select * From ac47@ckk Where aac002 ='430603195503173013'
12.修改 持卡库人员信息
<DATAEXCHANGE>
0003-S-01|st_card_pow|24809CDD0E9FB9275FFE07E751BC1D85
<HEADER>
V1.0|43000000120190219180204097|430000001|430000001|430000001|43000000120190219180204097|002|1|20190219180204|20190219|
180204|0
<PSINF>
101087288693|430523196812240042|170803021034
<CHANGEINF>
AAC060|2|1
<END>
13.注销持卡库人员信息
<DATAEXCHANGE>
0005-S-01|st_card_pow|24809CDD0E9FB9275FFE07E751BC1D85
<HEADER>
V1.0|43000000120190129000004099|430000001|430000000|430000001|43000000120190129000004099|003|1|20190129151117|20190129|
151117|0
<PSINF>
100929075342|440221194311291611|任邦才|其他
<END>
14.查询基础库卡信息表，包括aaz007，aac998，aaz500,aaz502,aaz507,aac003信息
Select * From az20@ckk Where aac998 In (Select aac998 From ac47@ckk Where aac002 ='430603195503173013' )
15.注销持卡库卡信息
基础库卡信息注销后，持卡库卡信息会同步注销
