平台跟踪文档（Platform tracking document）.docVIP

平台跟踪文档（Platform tracking document） [automatic data collection sector number, select related_bsc project status] project_state, count, cnt_sector (*) from ne_sector_c where city_id in (12502) and time_stamp =to_date (2012-03-29,YYYY-MM-DD) group by related_bsc, project_state [manual maintenance of data base station number, engineering status] select, related_bsc, project_state, count (*), cnt_curbts, from, necur_bts_c, where, city_id, in (12502), and, oid, in (select, related_bts) From ne_sector_c Where city_id in (12502) And, time_stamp = to_date (2012-03-29,YYYY-MM-DD)) group, by, related_bsc, project_state [manual maintenance of data sector number, engineering status] select, related_bsc, project_state, count (*), cnt_cursector, from, necur_sector_c, where, city_id, in (12502), group, by, related_bsc, project_state [manual maintenance of data base station number, engineering status] select, related_bsc, project_state, count (*) cnt_bts From ne_bts_c Where city_id in (12502) And time_stamp = to_date (2012-03-29,YYYY-MM-DD) And oid in (select related_bts) From ne_sector_c Where city_id in (12502) And time_stamp = to_date (2012-03-29,YYYY-MM-DD) Group, by, related_bsc, project_state [automatic data acquisition (base station)] select oid as OID,time_stamp as 时间戳,city_id as 城市,district_id as 行政归属,TOWNSHIP as 乡镇,geo_area as 地理归属,site_code as 基站站号,omc_siteid as 基站BTSID,lc_name as 基站中文名,py_name as 基站拼音,alias_name as 基站别名,ext_oid as 基站外部OID,omc_cellid as 扇区CellID,longitude as 基站经度,latitude as 基站纬度,site_type as 基站类型,is_indoor as 是否室内,site_level as 基站等级,r_capacity_d as 设计无线容量(Erl),related_omc as OMCOID,related_msc as MSCOID,related_mgw as MGWOID,related_bsc as BSCOID,lac as LAC,reg_zone as REG_ZONE,sid as SID,nid as NID,related_period as 归属工期,project_state as 工程状态,bi Rth_date as station opened date work_state as running, to_char (work_state_timeyyyy-MM-dd HH:mm:ss) as operation to determine the time, vendor_id as version_id as, the manufacturer name bts_model as software ver