SNS Database changes – Database version 7

Following WRC12 Decisions

All Notice processing Tables

New timestamp column called change_ts

Attch

Name	Type	Size	Action
ntc_id	Long Integer	4
attch_no	Integer	2
attch_type	Text	1
file_name	Text	255	Mod
extension	Text	3	Del
text_info	Text	255
change_ts	Date/Time	8	add

Carrier_fr new table

Name	Type	Size
grp_id	Long Integer	4
seq_emiss	Integer	2
seq_no	Integer	2
freq_carr	Double	8
change_ts	Date/Time	8

Cmr_history new table

Name	Type	Size
ntc_id	Long Integer	4
itu_scraft_id	Long Integer	4
seq_no	Long Integer	4
reg_st	Text	1
d_reg_st	Date/Time	8
rsn_susp	Text	255
wic_no	Integer	2
change_ts	Date/Time	8

Cmr_notice new table

Name	Type	Size
ntc_id	Long Integer	4
itu_scraft_id	Long Integer	4
d_reg_st	Date/Time	8
reg_st	Text	1
rsn_susp	Text	255
change_ts	Date/Time	8

Cmr_syst

Name	Type	Size	Action
ntc_id	Long Integer	4
seq_no	Integer	2
ntwk_name	Text	20
lsp_name	Text	20
vehicle	Text	20
d_exe	Date/Time	8
d_deliv_fr	Date/Time	8
d_deliv_to	Date/Time	8
facility	Text	20
ctry	Text	3	delete
long_deg	Integer	2	delete
long_ew	Text	1	delete
long_min	Integer	2	delete
long_sec	Integer	2	delete
lat_deg	Integer	2	delete
lat_ns	Text	1	delete
lat_min	Integer	2	delete
lat_sec	Integer	2	delete
mfct_name	Text	20
nbr_sat	Integer	2
d_exe_m	Date/Time	8
d_deliv_fr_m	Date/Time	8
d_deliv_to_m	Date/Time	8
long_dec	Single	4	delete
lat_dec	Single	4	delete
change_ts	Date/Time	8	add

Diag_grp new table

Name	Type	Size
grp_id	Long Integer	4
diag_type	Text	5
diag_no	Integer	2
attch_no	Integer	2
change_ts	Date/Time	8

Mask_info

Name	Type	Size	Action
ntc_id	Long Integer	4	add
mask_id	Long Integer	4
freq_min	Double	8
freq_max	Double	8
f_mask	Text	1
f_mask_type	Text	1

E_ant

Name	Type	Size	Action
ntc_id	Long Integer	4
emi_rcp	Text	1
beam_name	Text	8
act_code	Text	1
beam_old	Text	8
bmwdth	Single	4
attch_e	Integer	2	name change from diag_e
attch_e_x	Integer	2	name change from diag_e_x
gain	Single	4
pattern_id	Integer	2
pattern_id_x	Integer	2
ant_diam	Single	4
dgso	Double	8	add
attch_crdn	Integer	2	name change from diag_crdn
f_fdg_reqd	Text	1
cmp_ntc_id	Long Integer	4
cmp_beam	Text	8
f_cmp_str	Text	1
f_cmp_rec	Text	1
change_ts	Date/Time	8	add

E_as_stn

Name	Type	Size	Action
grp_id	Long Integer	4
seq_no	Integer	2
stn_name	Text	20
ctry	Text	3
act_code	Text	1
stn_type	Text	1
long_deg	Integer	2
long_ew	Text	1
long_min	Integer	2
long_sec	Integer	2
lat_deg	Integer	2
lat_ns	Text	1
lat_min	Integer	2
lat_sec	Integer	2
noise_t	Long Integer	4
gain	Single	4
bmwdth	Single	4
attch_e	Integer	2	add
attch_e_x	Integer	2	add
diag_e	Integer	2
diag_e_x	Integer	2
pattern_id	Integer	2
pattern_id_x	Integer	2
stn_old	Text	20
long_dec	Single	4
lat_dec	Single	4
ant_diam	Single	4
ant_alt	Integer	2
clim_zone	Text	1
rcp_type	Text	1
pwr_max	Single	4
bdwdth_aggr	Long Integer	4
dgso	Single	4	add
f_trp_band	Text	1
f_cmp_rec	Text	1
change_ts	Date/Time	8	add

emiss

Name	Type	Size	Action
grp_id	Long Integer	4
seq_no	Integer	2
design_emi	Text	9
pep_max	Single	4
pwr_ds_max	Single	4
pep_min	Single	4
pwr_ds_min	Single	4
c_to_n	Single	4
pwr_ds_nbw	Single	4
pwr_ctrl	Double	8
pulse_length	Double	8
pulse_rep	Double	8
f_emi_type	Text	1
attch_pep	Integer	2
attch_mpd	Integer	2
attch_c2n	Integer	2
pwr_ds_nbc	Single	4	add
f_cmp_rec	Text	1
change_ts	Date/Time	8	add

E_stn

Name	Type	Size	Action
ntc_id	Long Integer	4
stn_name	Text	20
ctry	Text	3
long_deg	Integer	2
long_ew	Text	1
long_min	Integer	2
long_sec	Integer	2
lat_deg	Integer	2
lat_ns	Text	1
lat_min	Integer	2
lat_sec	Integer	2
sat_name	Text	20
long_nom	Single	4
attch_hor	Integer	2	name change from diag_hor
elev_min	Single	4
elev_max	Single	4
azm_fr	Single	4
azm_to	Single	4
ant_alt	Long Integer	4
f_active	Text	1
long_dec	Single	4
lat_dec	Single	4
f_pfd_se	Text	1
change_ts	Date/Time	8

gpub

Name	Type	Size	Action
grp_id	Long Integer	4
seq_no	Integer	2
pub_ref	Text	12
pub_no	Integer	2
ssn_type	Text	1
ssn_rev	Text	1
ssn_rev_no	Integer	2
wic_no	Long Integer	4	add
d_wic	Date/Time	8	add
change_ts	Date/Time	8	add

Grp

Name	Type	Size	Action
grp_id	Long Integer	4
ntc_id	Long Integer	4
emi_rcp	Text	1
beam_name	Text	8
sr_type	Text	1
page_no	Integer	2
act_code	Text	1
adm_resp	Text	2
bdwdth	Long Integer	4
d_inuse	Date/Time	8
noise_t	Long Integer	4
op_agcy	Integer	2
polar_type	Text	2
polar_ang	Single	4
prd_valid	Integer	2
diag_area	Integer	2	delete
diag_spect	Integer	2	delete
attch_mux	Integer	2	delete
attch_reg	Integer	2	delete
remark	Text	30
tgt_grp_id	Long Integer	4
pwr_max	Single	4
bdwdth_aggr	Long Integer	4
f_trp_band	Text	1
area_no	Integer	2
observ_cls	Text	2
reg_op_fr	Long Integer	4
reg_op_to	Long Integer	4
d_upd	Date/Time	8
st_cur	Text	2
d_st_cur	Date/Time	8
wic_no	Integer	2
wic_part	Text	1
d_wic	Date/Time	8
d_prot_eff	Date/Time	8
fdg_reg	Text	2
fdg_plan	Text	2
fdg_tex	Text	2
fdg_observ	Text	4
spl_grp_id	Long Integer	4
comment	Text	30
area_name	Text	20
elev_min	Single	4
gso_sep	Single	4
prov	Text	12
srv_code	Text	6
freq_min	Double	8
freq_max	Double	8
f_no_intfr	Text	1
f_ap30b_art6	Text	1
plan_categ	Text	4
plan_status	Text	4
pfd_pk_7g	Single	4
d_rcv	Date/Time	8
d_rcv_start	Date/Time	8	Add
d_reg_limit	Date/Time	8	Add
st_biu	Text	1	Add
Text	1
ra_stn_type	Text	1
eirp_nom	Single	4
sensitivity	Single	4
f_fdg_reqd	Text	1
cmp_grp_id	Long Integer	4
f_cost_rec	Text	1
f_cmp_str	Text	1
f_cmp_rec	Text	1
f_cmp_freq	Text	1
f_cmp_emi	Text	1
f_cmp_eas	Text	1
f_cmp_prov	Text	1
f_cmp_sas	Text	1
f_cmp_gpub	Text	1
f_cmp_fdg	Text	1
change_ts	Date/Time	8	Add

Non_geo

Name	Type	Size	Action
ntc_id	Long Integer	4
sat_name	Text	20
ref_body	Text	1
nbr_sat_nh	Integer	2
nbr_sat_sh	Integer	2
nbr_plane	Integer	2
nbr_sat_td	Integer	2
density	Double	8	Change format
avg_dist	Single	4
f_x_zone	Text	1
x_zone	Single	4
f_epfd	Text	1
f_active	Text	1
attch_x_zone	Integer	2
f_pfd_lim	Text	1
change_ts	Date/Time	8

Notice

Name	Type	Size
ntc_id	Long Integer	4
ntc_type	Text	1
adm_ref_id	Text	20
d_adm	Date/Time	8
prov	Text	12
act_code	Text	1
adm	Text	3
ntwk_org	Text	3
ntf_occurs	Text	1
tgt_ntc_id	Long Integer	4
d_rcv	Date/Time	8
wic_no	Integer	2
wic_part	Text	1
d_wic	Date/Time	8
d_upd	Date/Time	8
f_basic	Text	1
f_int_ext	Text	1
ntf_rsn	Text	1
st_cur	Text	2
d_st_cur	Date/Time	8
st_prv	Text	2
f_spl	Text	1
spl_ntc_id	Long Integer	4
plan_id	Text	5
ntwk_pack	Text	4
f_mod_type	Text	1
f_aa_type	Text	1
f_adm_proxi	Text	1
f_rs46	Text	1	delete
f_val_cat	Text	1
cmp_ntc_id	Long Integer	4
f_cmp_str	Text	1
f_cmp_rec	Text	1
f_cmp_orb	Text	1
f_cmp_strp	Text	1
f_cmp_ngma	Text	1
f_cmp_hori	Text	1
f_cmp_elev	Text	1
f_cmp_pfd	Text	1
f_cmp_oper	Text	1
f_cfex	Text	1
f_val	Text	1
f_mod	Text	1
f_aes_char	Text	1
prov_desc	Text	50	add
change_ts	Date/Time	8	add

Orbit

Name	Type	Size	Action
ntc_id	Long Integer	4
orb_id	Integer	2
nbr_sat_pl	Integer	2
right_asc	Single	4
inclin_ang	Single	4
prd_ddd	Integer	2
prd_hh	Integer	2
prd_mm	Integer	2
apog	Double	8
apog_exp	Integer	2
perig	Double	8
perig_exp	Integer	2
perig_arg	Single	4
op_ht	Double	8	Change format
op_ht_exp	Integer	2
f_stn_keep	Text	1
rpt_prd_dd	Integer	2
rpt_prd_hh	Integer	2
rpt_prd_mm	Integer	2
rpt_prd_ss	Integer	2
f_precess	Text	1
precession	Single	4
long_asc	Single	4
keep_rnge	Single	4
f_cmp_rec	Text	1
f_cmp_pha	Text	1
change_ts	Date/Time	8	add

S_beam

Name	Type	Size	Action
ntc_id	Long Integer	4
emi_rcp	Text	1
beam_name	Text	8
f_steer	Text	1
sr_type	Text	1
act_code	Text	1
ang_alpha	Single	4
ang_beta	Single	4
attch_alpha_beta	Integer	2	add
beam_old	Text	8
attch_e	Integer	2	name change from diag_e
attch_e_x	Integer	2	name change from diag_e_x
attch_elev	Integer	2	name change from diag_elev
attch_gain	Integer	2	name change from diag_gain
attch_orb_e	Integer	2	name change from diag_orb_e
pattern_id	Integer	2
pattern_id_x	Integer	2
gain	Single	4
attch_loss	Integer	2	name change from loss_attch
pnt_acc	Single	4
pwr_max_4k	Single	4
pwr_avg_4k	Single	4
pwr_max_1m	Single	4
pwr_avg_1m	Single	4
beamlet	Single	4
bore_long	Single	4
bore_lat	Single	4
maj_axis	Single	4
min_axis	Single	4
orient	Single	4
rot_acc	Single	4
gain_x	Single	4
prot_ratio	Single	4
attch_gain_x	Integer	2	name change from diag_gainx
freq_min	Double	8
freq_max	Double	8
f_fdg_reqd	Text	1
f_tx_vis	Text	1	add
tx_ang_min	Single	4	add
cmp_ntc_id	Long Integer	4
cmp_beam	Text	8
f_cmp_str	Text	1
f_cmp_rec	Text	1
change_ts	Date/Time	8	add

Scraft cmr_freq new table

Name	Type	Size
itu_scraft_id	Long Integer	4
seq_no	Long Integer	4
freq_min	Double	8
freq_max	Double	8
freq_ sym	Text	1
change_ts	Date/Time	8

Scraft_cmr_syst new table

Name	Type	Size
itu_scraft_id	Long Integer	4
ntwk_name	Text	20
lsp_name	Text	20
vehicle	Text	20
d_exe	Date/Time	8
facility	Text	20
mfct_name	Text	20
nbr_sat	Integer	2
d_exe_m	Date/Time	8
d_deliv	Date/Time	8
d_launch	Date/Time	8
change_ts	Date/Time	8

Tr_aff_ntw - remove primary keys

Name	Type	Size	Action
ntc_id	Long Integer	4
coord_prov	Text	12
agree_st	Text	1
aff_ntc_id	Long Integer	4
adm	Text	3
ntwk_org	Text	3
ctry	Text	3
sat_name	Text	20
long_nom	Single	4
ntf_rsn	Text	1
coord_st	Text	1
st_aff	Text	2
f_cause	Text	1
f_rec	Text	1
d_prot_inc	Date/Time	8	add
wic_no	Integer	2	add
change_ts	Date/Time	8	add

Deleted Reference tables which are also in spacerefdb.mdb

table in sns	table in spacerefdb
adm_addr	not used
adm_info	rf_adm
agency	rf_op_agcy
channels	rf_channels
charact	rf_charact
clscode	rf_srv_cls
country	rf_ctry
facility	rf_facility
natsrv	rf_nat_srv
satsys	rf_sat_org
st_queue	rf_status
vehicle	rf_vehicle