數(shù)據(jù)接入管理平臺(tái)-有關(guān)人口的表

1、表匯總1，2，4【公積金】一、局（一）戶籍人口信息(gaj_qzj_rk_czrk)數(shù)據(jù)結(jié)構(gòu)（二）信息(GAJ_QZJ_RK_CZRK_ZP)數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典BHNUMBER(18)主鍵字段名字段含義字段類型校驗(yàn)方式字典BHNUMBER(10)主鍵SFZH號(hào)CHAR(18)非空、XMCHAR(30)非空XBCHAR(1)非空表 1-MZ民族CHAR(2)表 1-民族CSRQ出生日期CHAR(8)QU區(qū)CHAR(6)表 1-區(qū)劃PCS派出所CHAR(3)表 1-派出所ROAD街路巷CHAR(6)表 1-街路巷QFRQ簽發(fā)日期CHAR(8)YXQX有效期限CHAR(1)B

2、DYY變動(dòng)原因CHAR(3)表 1-變動(dòng)BDSJ變動(dòng)時(shí)間CHAR(8)SWZX注銷CHAR(8)GXRQ更新日期DATE非空（三）暫住人口信息(GAJ_QZJ_RK_ZZRK)數(shù)據(jù)結(jié)構(gòu)（四）常駐信息 GONGAN_0704_JWCZRYXX數(shù)據(jù)結(jié)構(gòu)（五）戶籍人口(帶戶號(hào)) GAJ_QZJ_RK_CZRK_J字段名字段含義字段類型校驗(yàn)方式字典BH主鍵VARCHAR2(20)主鍵XMVARCHAR2(30)非空YWX英文姓VARCHAR2(40)非空YWM英文名VARCHAR2(40)非空GJDQ國(guó)籍地區(qū)CHAR(3)非空ZJZL證件種類CHAR(3)非空ZJHM證件號(hào)碼VARCHAR2(20)非

3、空TLYXQ停留有效期VARCHAR2(8)FWCS服務(wù)處所VARCHAR2(60)非空XZZXZ現(xiàn)住址詳址VARCHAR2(100)非空CZSJ操作時(shí)間VARCHAR2(14)非空字段名字段含義字段類型校驗(yàn)方式字典BDBH主鍵VARCHAR2(20)主鍵RYBHVARCHAR2(20)非空SFZH號(hào)CHAR(18)XMCHAR(30)XBCHAR(1)MZ民族CHAR(2)CSRQ出生日期CHAR(8)QU區(qū)CHAR(6)JWZRQCHAR(12)ROAD街路巷CHAR(6)FZRQ發(fā)證日期CHAR(8)YXQX有效期限CHAR(1)SWRQ日期CHAR(8)GXRQ更新日期DATESFZH

4、號(hào)CHAR(18)XMCHAR(30)ZPBLOBZPLX類型CHAR(1)GXRQ更新日期VARCHAR2(20)T_STAMP時(shí)間戳DATE數(shù)據(jù)結(jié)構(gòu)二、人社局（一）就業(yè)失業(yè)登記信息RENSHE_ZS_10013、數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典XH序號(hào)NUMBER主鍵字段名字段含義字段類型校驗(yàn)方式字典RYBHVARCHAR2(20)主鍵XMVARCHAR2(30)GMSFHM公民號(hào)碼VARCHAR2(18)CSRQ出生日期CHAR(8)XB-CHAR(1)MZ民族-民族CHAR(2)HJQH戶籍區(qū)劃- 行政區(qū)劃CHAR(6)HJZRQ戶籍責(zé)任區(qū)-社區(qū)責(zé)任區(qū)VARCHAR2(12)

5、HJXZ戶籍詳址VARCHAR2(100)HKLX戶口類型- 戶口類別CHAR(1)HH戶號(hào)VARCHAR2(9)YHZGX與戶主關(guān)系-家庭關(guān)系VARCHAR2(3)FQ_GMSFHM父親號(hào)VARCHAR2(18)FQ_XM父親VARCHAR2(30)MQ_GMSFHM母親號(hào)VARCHAR2(18)非空MQ_XM母親VARCHAR2(30)BDSJ變動(dòng)時(shí)間CHAR(8)BDYY變動(dòng)原因- 變動(dòng)原因CHAR(3)RBKSJ入本庫時(shí)間VARCHAR2(14)DJDW登記VARCHAR2(200)DJSJ登記時(shí)間VARCHAR2(14)ZXBS注銷標(biāo)識(shí)CHAR(1)HDQR何地遷入- 行政區(qū)劃CHA

6、R(6)HXZQR何詳址遷入VARCHAR2(100)（二）五險(xiǎn)信息LDJ_QZJ_T_SC_LDJ_RKJBXX數(shù)據(jù)結(jié)構(gòu)（三）市民卡發(fā)卡信息LDJ_QZJ_T_SC_LDJ_RKJBXX數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典SMK_SC_RYBHNUMBER(18)主鍵ZJLX證件類型VARCHAR2(6)無SFZJHM號(hào)碼VARCHAR2(18)非空，XMVARCHAR2(50)非空字段名字段含義字段類型校驗(yàn)方式字典LD_SC_RYBHNUMBER(18)主鍵ZJLX證件類型VARCHAR2(6)無SFZJHM號(hào)碼VARCHAR2(18)非空，XMVARCHAR2(20)非空XBNUM

7、BER(1)JYQK經(jīng)營(yíng)情況VARCHAR2(20)DWMC名稱VARCHAR2(100)ZZJGDM組織機(jī)構(gòu)代碼VARCHAR2(80)無LDBZZH勞動(dòng)保障證號(hào)VARCHAR2(80)ZCDZ地址VARCHAR2(100)JYDZ經(jīng)營(yíng)地址VARCHAR2(100)YLBXJ養(yǎng)老保險(xiǎn)金NUMBER(8,2)YILBXJ醫(yī)療保險(xiǎn)金NUMBER(8,2)SYBXJ失業(yè)保險(xiǎn)金NUMBER(8,2)GSBXJ工傷保險(xiǎn)金NUMBER(8,2)SHYBXJ保險(xiǎn)金NUMBER(8,2)BMSCSJ部門上傳時(shí)間VARCHAR2(20)SJSYZT數(shù)據(jù)使用狀態(tài)VARCHAR2(10)JHSJ交換時(shí)間TIMES

8、TAMP(6)無JGDM機(jī)構(gòu)代碼（空）VARCHAR2(30)DWMCH名稱VARCHAR2(100)ZBM就業(yè)失業(yè)證編碼VARCHAR2(30)非空SHBZH件號(hào)VARCHAR2(20)XMVARCHAR2(50)DJQH登記區(qū)號(hào)VARCHAR2(20)表 1-區(qū)劃CZRQ常駐日期DATE（四）市民卡信息 t_sc_smk_ryzp3、數(shù)據(jù)結(jié)構(gòu)（五）人口參保狀態(tài) GAJ_QZJ_RK_CZRK_CB數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典BHNUMBER(10)主鍵SFZH號(hào)CHAR(18)非空、XMCHAR(30)非空XBCHAR(1)非空表 1-MZ民族CHAR(2)表 1-民族CSR

9、Q出生日期CHAR(8)QU區(qū)CHAR(6)表 1-區(qū)劃PCS派出所CHAR(3)表 1-派出所ROAD街路巷CHAR(6)表 1-街路巷QFRQ簽發(fā)日期CHAR(8)YXQX有效期限CHAR(1)BDYY變動(dòng)原因CHAR(3)表 1-變動(dòng)BDSJ變動(dòng)時(shí)間CHAR(8)字段名字段含義字段類型校驗(yàn)方式字典SMK_SC_RYBHNUMBER(18)主鍵SFZJHM號(hào)碼VARCHAR2(18)ZPBLOBBMSCSJ部門上傳時(shí)間VARCHAR2(20)XBVARCHAR2(1)CSRQ出生日期VARCHAR2(20)MZ民族VARCHAR2(14)JZD居住地VARCHAR2(100)SMKH市民V

10、ARCHAR2(24)SLZT設(shè)立狀態(tài)NUMBER(1)SLRQ設(shè)立日期VARCHAR2(8)CZLX操作類型NUMBER(1)BMSCSJ部門上傳時(shí)間VARCHAR2(20)SJSYZT數(shù)據(jù)使用狀態(tài)VARCHAR2(10)B級(jí)別VARCHAR2(4)YHZH用戶證號(hào)VARCHAR2(32)TXTZVARCHAR2(3)JHSJ交換時(shí)間TIMESTAMP(6)三、南京編辦（一）組織機(jī)構(gòu)信息 NJBB_ANIZATION數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典ID機(jī)構(gòu)NVARCHAR2(250)PARENTID機(jī)構(gòu)NVARCHAR2(250)NODEPATH機(jī)構(gòu)層次NVARCHAR2(250)

11、B0105機(jī)構(gòu)名稱NVARCHAR2(250)N0103機(jī)構(gòu)其他名稱NVARCHAR2(250)B0106成立批準(zhǔn) 文號(hào)NVARCHAR2(250)B0107組織機(jī)構(gòu)代碼NVARCHAR2(250)B0108批準(zhǔn)內(nèi)設(shè)機(jī)構(gòu) 數(shù)NUMBERB0109級(jí)別NVARCHAR2(250)B0110類別NVARCHAR2(250)B0111性質(zhì)NVARCHAR2(250)B0112成立批準(zhǔn) 時(shí)間DATEB0114主管名稱NVARCHAR2(250)B0117成立文件NVARCHAR2(250)B0118地址NVARCHAR2(250)B0119NVARCHAR2(250)B0120NVARCHAR2(25

12、0)B0121傳真NVARCHAR2(250)B0122聯(lián)系人NVARCHAR2(250)B0123事業(yè)法人登記 證號(hào)NVARCHAR2(250)B0124機(jī)構(gòu)編制管理 證NVARCHAR2(250)B2001編制總數(shù)NUMBERB2012在職總數(shù)NUMBERD2213相關(guān)文件NVARCHAR2(250)D2220事業(yè)編制實(shí)有 總數(shù)NUMBERSWZX注銷CHAR(8)GXRQ更新日期DATE非空CBZT參保狀態(tài)VARCHAR2(10)（二）編內(nèi)信息NJBB_數(shù)據(jù)結(jié)構(gòu)（三）編外信息 NJBW_數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典BASEKEY主鍵NVARCHAR2(100)非空DWNVA

13、RCHAR2(100)BM部門NVARCHAR2(100)XMNVARCHAR2(100)XBNVARCHAR2(100)AGENUMBER字段名字段含義字段類型校驗(yàn)方式字典IDNVARCHAR2(100)B0001NVARCHAR2(100)B0002部門NVARCHAR2(100)A0101NVARCHAR2(100)A0107NVARCHAR2(100)A0108出生日期DATEA0109號(hào)NVARCHAR2(100)A0110民族NVARCHAR2(100)A0111參加工作時(shí)間DATEA0112最高學(xué)歷NVARCHAR2(100)A0113編制性質(zhì)NVARCHAR2(100)A011

14、6職級(jí)NVARCHAR2(100)A0117職務(wù)名稱NVARCHAR2(100)A0118NVARCHAR2(100)A0120政治面貌NVARCHAR2(100)A0121參加黨派時(shí)間DATEA0125進(jìn)入現(xiàn)時(shí)間DATEA0126進(jìn)入現(xiàn)方式NVARCHAR2(100)A0128上報(bào)部門NVARCHAR2(100)A0129入庫時(shí)間DATEA0130修改時(shí)間DATEA01U02是否比對(duì)成功NVARCHAR2(100)B2227在職員額總數(shù)NUMBERCSRQ出生日期DATESFZH號(hào)NVARCHAR2(100)MZ民族NVARCHAR2(100)JG籍貫NVARCHAR2(100)ZZMM政治

15、面貌NVARCHAR2(100)HKSZD戶口所在地NVARCHAR2(100)LXDH個(gè)人NVARCHAR2(100)ZCNVARCHAR2(100)ZW職務(wù)NVARCHAR2(100)LB類別NVARCHAR2(100)GW崗位NVARCHAR2(100)DQYGXS當(dāng)前用工形式NVARCHAR2(100)SBKH社保NVARCHAR2(100)SFJNWX是否繳納五險(xiǎn)NVARCHAR2(100)SFJNGJJ是否繳納公積金NVARCHAR2(100)DABGD保管地NVARCHAR2(100)GL工齡NUMBERBDWGL本工齡NUMBERRZR入職日DATEQXSJ起薪時(shí)間DATELZ

16、SJ離職時(shí)間DATEGWFB崗位分布NVARCHAR2(100)ZPRYQDHTQK自聘簽訂合同情況NVARCHAR2(100)GZQX工作期限NVARCHAR2(100)GZLY工資來源NVARCHAR2(100)BZ備注NVARCHAR2(100)SHRKBS審核入庫標(biāo)識(shí)NVARCHAR2(100)HTQX合同期限NVARCHAR2(100)HTQSSJ合同起始時(shí)間DATEHTZZSJ合同終止時(shí)間DATEYGXS用工形式NVARCHAR2(100)PQDW派遣NVARCHAR2(100)XL學(xué)歷NVARCHAR2(100)ZY專業(yè)NVARCHAR2(100)XX學(xué)校NVARCHAR2(10

17、0)BYSJ畢業(yè)時(shí)間DATEJYLB教育類別NVARCHAR2(100)XW學(xué)位NVARCHAR2(100)CZR操作人NVARCHAR2(100)BDSJ變動(dòng)時(shí)間DATEBDSM變動(dòng)說明NVARCHAR2(100)YRYK原庫NVARCHAR2(100)YDW原NVARCHAR2(100)YBM原部門NVARCHAR2(100)YXM原NVARCHAR2(100)YXB原NVARCHAR2(100)YAGE原NUMBERYCSRQ原出生日期DATEYSFZH原號(hào)NVARCHAR2(100)YMZ原民族NVARCHAR2(100)YJG原籍貫NVARCHAR2(100)YKHSZD原戶口所在地

18、NVARCHAR2(100)YZZMM原政治面貌NVARCHAR2(100)YZW原職務(wù)NVARCHAR2(100)YZC原NVARCHAR2(100)YGW原崗位NVARCHAR2(100)YLB原類別NVARCHAR2(100)YGRLXDH原個(gè)人聯(lián)系電話NVARCHAR2(100)YYGXS原用工形式NVARCHAR2(100)YSBKH原社保NVARCHAR2(100)YSFJNWX原是否繳納五險(xiǎn)NVARCHAR2(100)YSFJNGJJ原是否繳納公積金NVARCHAR2(100)YDABGD原保管地NVARCHAR2(100)YGL原工齡NUMBERYBDWGL原本工齡NUMBER

19、YRZZ原入職日DATEYLZSJ原離職時(shí)間DATEYBZ原備注NVARCHAR2(100)XRYK現(xiàn)庫NVARCHAR2(100)XDW現(xiàn)NVARCHAR2(100)XBM現(xiàn)部門NVARCHAR2(100)XXM現(xiàn)NVARCHAR2(100)XXB現(xiàn)NVARCHAR2(100)XAGE現(xiàn)NUMBERXCSRQ現(xiàn)出生日期DATEXSFZH現(xiàn)號(hào)NVARCHAR2(100)XMZ現(xiàn)民族NVARCHAR2(100)XJG現(xiàn)籍貫NVARCHAR2(100)XKHSZD現(xiàn)戶口所在地NVARCHAR2(100)XZZMM現(xiàn)政治面貌NVARCHAR2(100)XZC現(xiàn)NVARCHAR2(100)四、智能門戶

20、（一）獻(xiàn)血T_ZNMH_BLOODPDF數(shù)據(jù)結(jié)構(gòu)（二）公積金個(gè)人賬號(hào)基本信息T_ZNMH_FUNDLOAN數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典ID主鍵 idVARCHAR2(64)CAPITALOVER余額VARCHAR2(64)字段名字段含義字段類型校驗(yàn)方式字典ID主鍵 idVARCHAR2(64)USERID用戶 idVARCHAR2(64)USERNAME用戶VARCHAR2(64)IDNUMBER號(hào)VARCHAR2(64)REQCONTENT請(qǐng)求內(nèi)容CLOBISEXECPTION是否異常VARCHAR2(2)EXECPTIONCONTENT異常內(nèi)容CLOBCREATETIME創(chuàng)建

21、時(shí)間DATEUPDATETIME修改時(shí)間DATEISPDF是否有獻(xiàn)血VARCHAR2(2)XZW現(xiàn)職務(wù)NVARCHAR2(100)XLB現(xiàn)類別NVARCHAR2(100)XGW現(xiàn)崗位NVARCHAR2(100)XGRLXDH現(xiàn)個(gè)人聯(lián)系電話NVARCHAR2(100)XYGXS現(xiàn)用工形式NVARCHAR2(100)XSBKH現(xiàn)社保NVARCHAR2(100)XSFJNWX現(xiàn)是否繳納五險(xiǎn)NVARCHAR2(100)XSFJNGJJ現(xiàn)是否繳納公積金NVARCHAR2(100)XDABGD現(xiàn)保管地NVARCHAR2(100)XGL現(xiàn)工齡NUMBERXBDWGL現(xiàn)本工齡NUMBERXRZR現(xiàn)入職日DAT

22、EXLZSJ現(xiàn)離職時(shí)間DATEXBZ現(xiàn)備注NVARCHAR2(100)（三）公積金個(gè)人賬號(hào)繳費(fèi)T_ZNMH_FUNDLOANDETAIL數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典ID主鍵 idVARCHAR2(64)BUSINESSDATE交易日期VARCHAR2(64)OVERDUE逾期金額VARCHAR2(64)ACCOUNT個(gè)人賬號(hào)VARCHAR2(64)NUMBERTYPE證件類型VARCHAR2(64)IDNUMBER證件號(hào)碼VARCHAR2(64)SITENUMBER網(wǎng)點(diǎn)號(hào)VARCHAR2(64)LOANTOTAL金額VARCHAR2(64)USERNAMEVARCHAR2(64)

23、LOANRATES利率VARCHAR2(64)LOANSTARTDATE起始日期VARCHAR2(64)CAPITALPAYED已還本金數(shù)VARCHAR2(64)FACTENDDATE實(shí)際終止日期VARCHAR2(64)ERESTPAYED已還利息數(shù)VARCHAR2(64)LOANPAYSTYLE還款方式VARCHAR2(64)PENALTY罰息VARCHAR2(64)REPAYMENTACCOUNT還款賬號(hào)VARCHAR2(64)ACCOUNTSUS帳戶狀態(tài)說明VARCHAR2(64)SHOULDPENALTY應(yīng)收罰息VARCHAR2(64)LASTPAYMONTH最近還款日VARCHAR2

24、(64)SHOULDEREST應(yīng)收利息VARCHAR2(64)LOANSTYLE類型VARCHAR2(64)LOANCLASS種類VARCHAR2(64)HOUSECLASS購(gòu)房種類VARCHAR2(64)NORMALOVERTOTAL正常余額合計(jì)數(shù)VARCHAR2(64)OVERDUETOTAL逾期余額合計(jì)數(shù)VARCHAR2(64)FUNDCARDID公積金VARCHAR2(64)FILEID號(hào)VARCHAR2(64)MATENUMBERTYPE配偶證件類型VARCHAR2(64)MATEIDNUMBER配偶證件號(hào)碼VARCHAR2(64)MATEFUNDCARDID配偶公積金卡號(hào)VARCH

25、AR2(64)MATENAME配偶VARCHAR2(64)LOANENDDATE終止日期VARCHAR2(64)CREATETIME創(chuàng)建時(shí)間DATEUPDATETIME修改時(shí)間DATE（四）公積金賬號(hào)或補(bǔ)貼賬號(hào)基本信息 T_ZNMH_FUNDSUBSIDY數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典ID主鍵 idVARCHAR2(64)UNITACCOUNT公積金/補(bǔ)貼帳號(hào)VARCHAR2(64)SITENUMBER網(wǎng)點(diǎn)號(hào)VARCHAR2(64)ADDR名稱VARCHAR2(200)FUNDID個(gè)人帳號(hào)VARCHAR2(64)FUNDCARDID個(gè)人公積金卡號(hào)VARCHAR2(64)USERNA

26、MEVARCHAR2(64)IDNUMBER號(hào)VARCHAR2(64)CREATEDATE日期VARCHAR2(64)PAYMENT月匯繳額VARCHAR2(64)CURRENTBALANCE當(dāng)前余額VARCHAR2(64)LASTPAYMENTDATE最近匯繳年月VARCHAR2(64)PROPORTION個(gè)人繳存比例VARCHAR2(64)UNITPROPORTION繳存比例VARCHAR2(64)UNITCREATEDATE日期VARCHAR2(64)UNITSUS當(dāng)前狀態(tài)說明VARCHAR2(64)SUS個(gè)人當(dāng)前狀態(tài)說明VARCHAR2(64)TYPE0 公積金賬號(hào)VARCHAR2(6

27、4)BUSINESSMONEY交易金額VARCHAR2(64)BUSINESSINFO還款摘明VARCHAR2(200)BUSINESSPER期數(shù)VARCHAR2(64)CURBALANCE余額VARCHAR2(64)LOANACCOUNT賬號(hào)VARCHAR2(64)USERNAMEVARCHAR2(64)IDNUMBER號(hào)VARCHAR2(64)LOANTOTAL總額VARCHAR2(64)OVER剩余還款期數(shù)VARCHAR2(64)LOANSTARTDATE起始日VARCHAR2(64)LOANENDDATE到期日VARCHAR2(64)BUSINESSSTYLE交易種類VARCHAR2(

28、64)LENDERMONEY貸方發(fā)生額VARCHAR2(64)DEBITMONEY借方發(fā)生額VARCHAR2(64)CREATETIME創(chuàng)建時(shí)間DATEUPDATETIME修改時(shí)間DATE（ 五 ） 公 積 金 賬T_ZNMH_FUNDSUBSIDYDETAIL數(shù)據(jù)結(jié)構(gòu)號(hào)或補(bǔ)貼賬號(hào)繳費(fèi)（六）公積金總實(shí)體T_ZNMH_FUNDTOTAL數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典ID主鍵 idVARCHAR2(64)USERNAMEVARCHAR2(50)CUSTOMERID個(gè)人客戶號(hào)VARCHAR2(64)IDNUMBER個(gè)人號(hào)VARCHAR2(64)FUNDCARD個(gè)人VARCHAR2(64)

29、FUNDACCOUNT個(gè)人公積金帳號(hào)VARCHAR2(64)FUNDMONEY公積金余額VARCHAR2(64)SUBSIDYACCOUNT個(gè)人住房補(bǔ)貼帳號(hào)VARCHAR2(64)SUBSIDYMONEY住房補(bǔ)貼余額VARCHAR2(64)LOANACCOUNT個(gè)人帳號(hào)VARCHAR2(64)LOANMONEY本金余額VARCHAR2(64)CREATETIME創(chuàng)建時(shí)間DATE字段名字段含義字段類型校驗(yàn)方式字典ID主鍵 idVARCHAR2(64)FUNDID個(gè)人帳號(hào)VARCHAR2(64)USERNAMEVARCHAR2(64)IDNUMBER號(hào)VARCHAR2(64)UNITACCOUNT

30、帳號(hào)VARCHAR2(64)UNIT名稱VARCHAR2(200)TRANIONDATE交易日期VARCHAR2(64)BIZTYPE業(yè)務(wù)種類VARCHAR2(64)AMOUNT發(fā)生額VARCHAR2(64)BALANCE余額VARCHAR2(64)BIZINFO業(yè)務(wù)信息VARCHAR2(64)TYPE公積金賬號(hào)補(bǔ)貼賬號(hào)VARCHAR2(64)CREATETIME創(chuàng)建時(shí)間DATEUPDATETIME修改時(shí)間DATE1 補(bǔ)貼賬號(hào)CREATETIME創(chuàng)建時(shí)間DATEUPDATETIME修改時(shí)間DATE（七）燃?xì)?T_ZNMH_GASDETAIL_NEW數(shù)據(jù)結(jié)構(gòu)（八）水費(fèi)基礎(chǔ)信息T_ZNMH_WAT

31、ER數(shù)據(jù)結(jié)構(gòu)（九）自來水繳費(fèi)明細(xì)信息 T_ZNMH_WATER_FEE_DETAIL數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典IDIDVARCHAR2(50)CUSTID用戶帳號(hào)VARCHAR2(20)ACCWATERSUM實(shí)收水量VARCHAR2(20)GARBAGEFEE費(fèi)VARCHAR2(20)PENALTY違約金VARCHAR2(20)PREVBALANCE上期結(jié)余VARCHAR2(20)READDATE抄表日期VARCHAR2(20)WATERFEE水費(fèi)VARCHAR2(20)WATERFEEALL總金額VARCHAR2(20)字段名字段含義字段類型校驗(yàn)方式字典ACCOUNT戶號(hào)VA

32、RCHAR2(50)GENDERVARCHAR2(1)WATER_ADDR用戶地址VARCHAR2(200)MOBILE號(hào)VARCHAR2(50)ADDR地址VARCHAR2(200)COMMUNITY_ID社區(qū) IDVARCHAR2(50)字段名字段含義字段類型校驗(yàn)方式字典ID主鍵 IDVARCHAR2(40)READINGTIME抄表日期VARCHAR2(10)LASTREADNUM上次抄表數(shù)VARCHAR2(10)CURRENTREADNUM本次抄表數(shù)VARCHAR2(20)CURRENTCOUNT本次用量VARCHAR2(20)GASMONEY氣費(fèi)(元)VARCHAR2(20)PENA

33、LTY滯納金VARCHAR2(20)PAYPLACE繳費(fèi)點(diǎn)VARCHAR2(50)CREATETIME創(chuàng)建時(shí)間VARCHAR2(20)GASACCOUNT燃?xì)赓~號(hào)VARCHAR2(20)PAYDATE繳費(fèi)日期VARCHAR2(40)UPDATETIME修改時(shí)間DATEUSERID用戶 idVARCHAR2(64)（十）車輛信息 VEHICLELICENSE_TEMP數(shù)據(jù)結(jié)構(gòu)（十一）駕照信息DRIVINGLICENSE_TEMP數(shù)據(jù)結(jié)構(gòu)（十二）車輛違章 TAKEOUT_TEMP數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典XH主鍵 idVARCHAR2(16)HPHM用戶 idVARCHAR2(15

34、)HPZL用戶VARCHAR2(2)WFSJ號(hào)DATEWFDZ請(qǐng)求內(nèi)容VARCHAR2(128)XWMC是否異常VARCHAR2(166)字段名字段含義字段類型校驗(yàn)方式字典DABHCHAR(12)SFZMHM件號(hào)碼VARCHAR2(18)XMVARCHAR2(30)LJJF累計(jì)扣分NUMBER(3)SYRQ駕照下次年檢時(shí)間DATEOWNER_NUM_SHORT駕照VARCHAR2(30)字段名字段含義字段類型校驗(yàn)方式字典XH序號(hào)CHAR(14)HPHM號(hào)牌號(hào)碼VARCHAR2(15)HPZL號(hào)牌種類CHAR(2)FDJH發(fā)號(hào)VARCHAR2(30)CSYS車身顏色VARCHAR2(5)SFZM

35、HM件號(hào)碼VARCHAR2(18)SYR所有人VARCHAR2(128)QZBFQZ車輛下次年檢時(shí)間DATEZT狀態(tài)VARCHAR2(6)OWNER_NUM_SHORT駕照上的名字VARCHAR2(30)WATERSUM水量VARCHAR2(20)CREATETIME創(chuàng)建時(shí)間VARCHAR2(20)PAYDATE繳費(fèi)時(shí)間VARCHAR2(20)PAYPLACE繳費(fèi)地點(diǎn)VARCHAR2(50)（十三）農(nóng)民工就業(yè)工作經(jīng)歷 ZHUJIANWEI_WORKER_DECLIST數(shù)據(jù)結(jié)構(gòu)（十四）城市居民消費(fèi)價(jià)格指數(shù)TONGJI_DB_TJ_CSJMXFJGZS數(shù)據(jù)結(jié)構(gòu)五、市殘聯(lián)市殘聯(lián)人口基本信息T_DY_

36、SCL_RKJBXX數(shù)據(jù)結(jié)構(gòu)六、民（一）機(jī)動(dòng)車基本信息 HB_VEHICLE_BASE_INFO數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典VEHICLE_SN車輛信息唯一NUMBER(10)主鍵字段名字段含義字段類型校驗(yàn)方式字典CL_DY_RYBHNUMBER(18)XMVARCHAR2(50)SFZJHM件號(hào)碼VARCHAR2(50)CJLB類別VARCHAR2(50)CJDJ等級(jí)VARCHAR2(50)CJZH證號(hào)VARCHAR2(50)ZJLX證件類型VARCHAR2(10)XBVARCHAR2(10)字段名字段含義字段類型校驗(yàn)方式字典TJ_ZBMC指標(biāo)名稱VARCHAR2(50)TJ_

37、BY本月NUMBERTJ_BYZLJ本月增加VARCHAR2(30)SUS狀態(tài)NUMBERBATCH批次VARCHAR2(20)JHSJ交換時(shí)間TIMESTAMP(6)字段名字段含義字段類型校驗(yàn)方式字典WORKERID農(nóng)民工IDVARCHAR2(20)主鍵WORKTYPE工作類型VARCHAR2(20)EMPLOYDATE雇傭時(shí)間NUMBER(4)FKJE_DUT異常內(nèi)容NUMBER(6)七、交通局（一）營(yíng)運(yùn)車輛信息 rt_vehicle數(shù)據(jù)結(jié)構(gòu)序號(hào)SN_CGS車管所序號(hào)VARCHAR2(14)主鍵VEHICLE_TAG_NO車輛序號(hào)VARCHAR2(20)UNDERCARRIAGE_NOVA

38、RCHAR2(30)REGISTER_DATE初次登記日期DATEINSPECT_PERIOD年檢周期（單位：月）NUMBER(2)MANUFACTURE_DATE出廠日期DATEVEHICLE_TYPE車輛類型VARCHAR2(9)VEHICLE_TAG_TYPE號(hào)牌類型VARCHAR2(9)VEHICLE_PURE車輛使用目的VARCHAR2(9)VEHICLE_NATURE車輛使用性質(zhì)VARCHAR2(9)VEHICLE_SUS車輛狀態(tài)VARCHAR2(9)VEHICLE_ZONE所屬行政區(qū)域VARCHAR2(9)INSPECTION_TYPE檢測(cè)方法VARCHAR2(9)VEHICLE

39、_M_SN車型序號(hào)NUMBER(10)MOTO_NO發(fā)號(hào)VARCHAR2(60)PROVIDE_OIL_M供油方式VARCHAR2(9)OIL_TYPE類型VARCHAR2(9)VENT_PIPE_TY排氣管數(shù)量NUMBER(2)TYRE_M輪胎型號(hào)VARCHAR2(30)COURSE_READING行駛里程N(yùn)UMBER(9)LABEL_TYPE標(biāo)志類型VARCHAR2(9)LABEL_SUS標(biāo)志狀態(tài)CHAR(1)IS_OBD是否有OBD 裝置CHAR(1)MASTER_NAME車主VARCHAR2(200)ID_CARD_NOID 卡VARCHAR2(18)SEXVARCHAR2(4)T_N

40、OVARCHAR2(6)ADDRESS地址VARCHAR2(200)PHONE_NO號(hào)碼VARCHAR2(40)MOBILE移動(dòng)號(hào)碼VARCHAR2(12)REMARK備注VARCHAR2(200)字段名字段含義字段類型校驗(yàn)方式字典VEHICLEID車輛 IdVARCHAR2(32)主鍵VEHICLENUM車輛(掛車)號(hào)牌VARCHAR2(20)PLATECOLOR車牌顏色代碼VARCHAR2(2)VEHICLETYPE車輛類型 (代碼)VARCHAR2(2)SPECIFICATION規(guī)格VARCHAR2(10)STRUCTURE結(jié)構(gòu)VARCHAR2(20)TRANSTYPE車輛行業(yè)類別EGE

41、R10.道路旅客20.道路普通貨物運(yùn)輸30.道路危險(xiǎn)貨物運(yùn)輸50.機(jī)動(dòng)車駕駛員培訓(xùn) (車)70:國(guó)際道路80. 運(yùn)輸90.出租運(yùn)輸100. 汽車 租賃VEHICLECOLOR車身顏色VARCHAR2(10)BRAND廠牌VARCHAR2(50)VEHICLEM型號(hào)VARCHAR2(50)ENGINEM發(fā)型號(hào)VARCHAR2(20)ENGINENUM發(fā)號(hào)碼VARCHAR2(50)ENGINEER發(fā)功率NUMBER(5,1)VIN車輛識(shí)別 VIN 碼VARCHAR2(17)DRIVINGREGDATE行駛證初領(lǐng)日期TIMESTAMP(6)REGCERTNUM車輛登記證號(hào)VARCHAR2(20)RE

42、GCERTREGDATE登記證登記日期TIMESTAMP(6)REGCERTIEDATE登記證發(fā)證日期TIMESTAMP(6)SEATS核定座位數(shù)EGERFUELTYPE類型代碼EGERVEHICLETECLEVEL車輛技術(shù)等級(jí)EGERFACTORYDATE出廠日期TIMESTAMP(6)PURCHASEDATE購(gòu)車日期TIMESTAMP(6)SETTLEDDATE落戶日期TIMESTAMP(6)WHEELBASE軸距EGERVEHILENGTH車長(zhǎng)EGERVEHIHIGH車高EGERVEHIWIDTH車寬EGERAXLENUM車軸數(shù)EGERREALLEAFSPRINGPIECE后軸鋼板彈數(shù)E

43、GERSUSPENFORM懸架形式VARCHAR2(20)ISENTRY是否出入境EGERARCHIVENUM號(hào)VARCHAR2(20)TRANLICENSEWORD道路證字VARCHAR2(5)TRANLICENSESEQNO道路證號(hào)VARCHAR2(15)TRANLICENSENUM道路證字號(hào)VARCHAR2(20)VERIFYCODE證件VARCHAR2(10)LICENSEDATE證件初領(lǐng)日期TIMESTAMP(6)LICENSESTARTDATE證件有效期起TIMESTAMP(6)LICENSEENDDATE證件有效期止TIMESTAMP(6)IENAME證件日期VARCHAR2(5

44、0)TERMMANUFACTURER車載終端廠家VARCHAR2(50)TERMM車載終端型號(hào)VARCHAR2(20)TERMNUM車載終端編號(hào)VARCHAR2(20)TERMINSTALLDATE終端安裝日期TIMESTAMP(6)TERMJTSTANDARD符合交通部794,808 標(biāo)準(zhǔn)EGER0:不符合1:符合TERMDB32STANDARD符合安監(jiān) DB32 標(biāo)準(zhǔn)EGER0:不符合1:符合DRIVINGRECORDERM行駛儀型號(hào)VARCHAR2(20)DRIVINGRECORDERNUM行駛儀VARCHAR2(20)ISINSTALL是否安裝視頻設(shè)備EGERCOMMUNNAME配備的

45、通訊工具VARCHAR2(20)COMMUNNUM通訊工具號(hào)碼VARCHAR2(30)OWNERID業(yè)戶 IdVARCHAR2(32)ID管轄機(jī)構(gòu) IdVARCHAR2(32)BUSISCOPENAMES經(jīng)營(yíng)范圍名稱VARCHAR2(500)BUSISCOPECODES經(jīng)營(yíng)范圍代碼VARCHAR2(200)AREACODE行政區(qū)劃編碼VARCHAR2(6)COUNTY隸屬區(qū)縣代碼VARCHAR2(9)CREATOR創(chuàng)建人VARCHAR2(20)CREATETIME創(chuàng)建時(shí)間TIMESTAMP(6)MODIFIER修改人VARCHAR2(20)MODIFYTIME修改時(shí)間TIMESTAMP(6)C

46、ERTSE證件狀態(tài)EGER1:有效2:無效OPERSE營(yíng)運(yùn)狀態(tài)EGER10 營(yíng)運(yùn)停運(yùn)掛失遷出-過戶遷出-轉(zhuǎn)籍報(bào)廢歇業(yè)80 注銷90 其他INSURANCEID保險(xiǎn) IdVARCHAR2(32)（二）從業(yè)信息 rt_practitioner數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典PRACID從業(yè) VARCHAR2(32)主鍵ISBEIDOU是否北斗兼容EGERCOMMENTS備注VARCHAR2(500)ISFACTORYINSTALL車載設(shè)備是否出廠預(yù)裝EGERVEHICLEUSE車輛使用用途EGER1:經(jīng)營(yíng)性2: 非經(jīng)營(yíng) 性LICENSEIEDATE證件日期TIMESTAMP(6)ANNU

47、LEFFECDATE年審有效日期TIMESTAMP(6)COMPMAEFFECDATE二級(jí)有效日期TIMESTAMP(6)TECHLEVELEFFECDATE技術(shù)等級(jí)有效日期TIMESTAMP(6)PASSLEVELEFFECDATE客車等級(jí)有效日期TIMESTAMP(6)PASSENGERLEVEL客車等級(jí)EGERISTRAILER是否掛車EGER0:否1:是APPRLOADMASS核定載質(zhì)量(kg)NUMBER(8,2)ICCARDNUMVARCHAR2(20)ETCCARDNUMVARCHAR2(20)INSPECTDATE年審日期TIMESTAMP(6)GROSSMASS總質(zhì)量(kg)

48、NUMBER(8,2)MOBILE聯(lián)系VARCHAR2(20)DRIVINGCHECKDATE行駛證審驗(yàn)有效期TIMESTAMP(6)UNLOCKMODE年審方式EGERCOMPMAUNLOCKMODE二維方式EGERVEHICLESTOPDATETIMESTAMP(6)VEHICLESTOPPERVARCHAR2(20)TECHLEVELOCKMODEEGERIdAMEVARCHAR2(30)SEXEGERBIRTHDAY出生日期TIMESTAMP(6)NATIONALITY民族代碼VARCHAR2(4)IDCERTTYPE件類型代碼EGERIDCERTNUM件編號(hào)VARCHAR2(20)C

49、OUNTY隸屬區(qū)縣代碼VARCHAR2(6)PHONENUM固定VARCHAR2(20)MOBILE移動(dòng)VARCHAR2(20)IDCERTADDRESS地址VARCHAR2(100)ADDRESS現(xiàn)住地地址VARCHAR2(100)電子郵箱VARCHAR2(20)TCODE住址郵政編碼VARCHAR2(6)EDUCATION學(xué)歷代碼VARCHAR2(4)TECHNICALT專業(yè)技術(shù)VARCHAR2(20)HEALTHSE健康狀況代碼EGERDRIVINGLICENSE駕駛證號(hào)VARCHAR2(20)DRIVINGVEHICLE準(zhǔn)駕車型代碼VARCHAR2(10)DRIVLICEDATE駕照初

50、領(lǐng)日期TIMESTAMP(6)DRIVLITARTDATE駕照有效期始TIMESTAMP(6)DRIVLICE駕照發(fā)證機(jī)關(guān)VARCHAR2(50)ARCHIVENUM號(hào)VARCHAR2(20)PHOTOPATH路徑VARCHAR2(200)PRACTYPENAMES從業(yè)資格名稱VARCHAR2(500)PRACTYPECODES從業(yè)資格代碼VARCHAR2(50)AREACODE行政區(qū)劃代碼VARCHAR2(6)ID機(jī)構(gòu) IdVARCHAR2(32)REGISTERIDIDVARCHAR2(32)CREATETIME創(chuàng)建時(shí)間TIMESTAMP(6)CREATOR創(chuàng)建人VARCHAR2(20)（

51、三）營(yíng)運(yùn)船舶信息 rt_ship數(shù)據(jù)結(jié)構(gòu)字段名字段含義字段類型校驗(yàn)方式字典SHI船舶 IdVARCHAR2(32)主鍵SHIPNAME船舶名稱VARCHAR2(100)BEFORENAME曾用名VARCHAR2(100)SHIPENNAME船舶英文名VARCHAR2(50)ARCHIVENUM號(hào)VARCHAR2(20)SHIPSURVEYNUM船舶登記號(hào)VARCHAR2(20)SHIPREGNUM船舶所登記號(hào)VARCHAR2(20)SHIPTYPE船舶類型VARCHAR2(6)RUNNER經(jīng)營(yíng)人VARCHAR2(100)NATIONCERTNUM船舶國(guó)籍證書號(hào)VARCHAR2(20)LEASE

52、CRETNUM光船租賃登記號(hào)VARCHAR2(20)TEMPNATIONCERTNUM臨時(shí)船舶國(guó)籍號(hào)VARCHAR2(20)CHARGESHIPTYPE計(jì)費(fèi)船型EGERMANAGER船舶管理人VARCHAR2(50)MANAGERLICENSENUM管理人經(jīng)營(yíng)證號(hào)VARCHAR2(40)CAPTAINNAME船長(zhǎng)VARCHAR2(20)MATERIAL船體材質(zhì)VARCHAR2(20)MODIFYTIME修改時(shí)間TIMESTAMP(6)MODIFIER修改人VARCHAR2(20)DRIVLICEENDDATE駕照有效期止TIMESTAMP(6)DRIVLICEPERIOD駕照有效期限(年)EGERTEACHVEHICLEDATE準(zhǔn)教車型初次準(zhǔn)駕日期TIMESTAMP(6)SAFEDRIVING安全駕駛經(jīng))EGERSERVERID服務(wù)器標(biāo)識(shí)VARCHAR2(10)COMMENTS備注VARCHAR2(1000)DRIVARCHIVENUM駕駛證號(hào)VARCHAR2(20)ONJOB是否在崗EGERNOTJOBDATE不在崗時(shí)間TIMESTAMP(6)BUILDDATE建造日期TIMESTAMP(6)PANY造船廠名VARCHAR2(50)BUILDSITE