CREATE OR REPLACE VIEW SD_HOSPITAL.VW_SF_BLSYXX
 (
 BRBLH0, BRID00, BRXM00, BRXB00, BRCSRQ, BRMZ00, BRHYZK, BRZY00, BRJTDZ, 
CZRQ00, NL0000, NF0000, YF0000, CSRI00, BRSZSF, BRSZS0, BRJTXX, BRDH00, 
BRZJBH, BRYB00, BRLXXM

 )
 AS 
select brblh0,
       brid00,
       brxm00,
       brxb00,
       brcsrq,
       brmz00,
       brhyzk,
       brzy00,
       brjtdz,
       czrq00,
       sf_sf_CsrqToNl(brcsrq),
       substr(brcsrq,1,4), --截止日期年
       substr(brcsrq,5,2), --截止日期月
       substr(brcsrq,7,2), --截止日期日
       BRSZSF,
       BRSZS0,
       BRSZSF||BRSZS0||BRSZZ0,
       BRDH00,
       substr(trim(brzjbh),1,length(trim(brzjbh))-6)||'******' BRZJBH,
       BRYB00,
       BRLXXM
    from bm_brxxb0
/