SNS database changes - Database version 6.1
following WRC07 decisions for AP30B
28 July 2009
Tables Deleted
c2i_aggr
c2i_se
carrier_fr
sps_a30b_results
Table Modified
Table |
Element |
Format |
Item in AP4 |
Description |
Remark |
|
pl_strap |
|
|
|
|
|
|
|
ntc_id |
9(9) |
|
unique identifier of the notice |
PK |
|
|
freq_dn | 9(6).9(5) | D.1.A.4 | assigned frequency of the downlink forming part of the strap | PK |
|
|
freq_up | 9(6).9(5) | D.1.A.3 | assigned frequency of the uplink forming part of the strap | PK |
|
|
grp_id_dn |
9(9) |
|
unique identifier of the group downlink |
PK |
|
|
grp_id_up |
9(9) |
|
unique identifier of the group uplink |
PK |
|
|
pbeam_name |
X(8) |
|
designation of the satellite antenna beam (plan) |
New field |
|
|
multibeam_set |
9(4) |
|
Multibeam code |
New field |
| exop_set | 9(4) | Exclusive operation code | New field | ||
| f_victim_op | X | 'Y' for old historical victims, not mentioned in the RR (no relation with Art.6 part A), 'N' for the rest. (No 'new' victims are expected to be added in the future.) | New field | ||
| agg_tolerance | 9.99 | 0.05 there applied for LIST. For the rest can be NULL and software will apply 0.25 dB for the LIST and 0.05 for the PLAN | New field |
New tables
Table |
Element |
Format |
Item in AP4 |
Description |
Remark |
|
ap30b_ref_agg |
|
|
|
|
|
|
|
grp_id_dn |
9(9) |
|
unique identifier of the group downlink |
PK |
|
|
grp_id_up |
9(9) |
|
unique identifier of the group uplink |
PK |
| seq_pt | 9(4) | test point sequential number | PK | ||
|
|
freq_band |
X(8) |
|
"6/4", "13/10", "13/11", "13/10-11" |
PK |
|
|
c2i |
S9(3).9(6) |
|
reference aggregated C/I value for this test point |
Table |
Element |
Format |
Item in AP4 |
Description |
Remark |
|
ap30b_ref_se |
|
|
|
|
|
|
|
grp_id_a |
9(9) |
|
unique identifier of the affected group |
PK |
|
|
grp_id_i |
9(9) |
|
unique identifier of the interfering group |
PK |
| seq_pt | 9(4) | test point sequential number | PK | ||
| emi_rcp | X | (E) for downlink or (R) for uplink SE values | |||
|
|
c2i |
S9(3).9(6) |
|
reference aggregated C/I value for this test point |
|
|
|
agree_st |
X |
|
(I)mplicitly or (E)xplicitely agreed value |
|
Table |
Element |
Format |
Item in AP4 |
Description |
Remark |
|
ap30b_tr_res |
|
|
|
|
|
|
|
ntc_id |
9(9) |
|
Notice ID of the analyzed network |
PK |
|
|
freq_band |
x(8) |
|
"6/4", "13/10", "13/11", "13/10-11" |
PK |
|
|
ntc_id_a |
9(9) |
|
Notice ID of the affected network |
PK |
| plan_status_a | X(4) | Status of entries of a network considered to be affected (either assignment = LIST or allotment = PLAN) | PK | ||
|
|
ntc_id_i |
9(9) |
|
Notice ID of the interfering network |
PK |
| se_dn_tp_degr_max | 9(3).9(4) | Maximum downlink single-entry C/I degradation on test points | |||
| se_dn_gp_degr_max | 9(3).9(4) | Maximum downlink single-entry C/I degradation on grid points | |||
| se_up_degr_max | 9(3).9(4) | Maximum uplink single-entry C/I degradation | |||
|
|
agg_degr_max |
9(3).9(4) |
|
Maximum aggregate C/I degradation |
SNS database changes
following WRC07 decisions
1 June 2008
Tables Modified
Table |
Element |
Format |
Item in AP4 |
Description |
Remark |
|
notice |
|
|
|
|
|
|
|
f_rs46 |
X |
|
Flag used to indicate processing under res46 |
New field If value in f_aa_type = ‘R’ it should be moved to this field |
|
|
f_val_cat |
X |
|
Flag indicating validation category |
New field To be used by SpaceVal instead of f_mod_type |
|
geo |
|
|
|
|
|
|
|
|
|
|
|
To be suppressed
|
|
|
|
|
|
|
To be suppressed
|
|
s_beam |
|
|
|
|
|
|
|
sr_type |
X |
BR |
symbol indicating the type of the sensor A – active, P - passive |
New field
|
|
grp |
|
|
|
|
|
|
|
bdwdth |
9(9) |
C.3.a/ C.5.d.2 |
assigned frequency band expressed in kHz/receiver noise bandwidth for active sensors |
Format changed from 9(8) to 9(9) |
|
|
sr_type |
X |
BR |
symbol indicating the type of the sensor A – active, P - passive |
New field
|
|
|
sensitivity |
999.99 |
C.16.b.1 |
Sensitivity threshold , in kelvins |
New field For passive sensors |
|
|
|
S99.9 |
C.8.f.1/C.8.f.2 |
The space station’s /associated space station’s nominal equivalent isotropically radiated power(s) (e.i.r.p) on the beam axis |
Field name change Required only for a space-to space link |
|
|
f_ap30b_art6 |
X |
A.19.a |
a commitment that the use of assignment shall not cause unacceptable interference to, nor claim protection from, those assignments for which agreement still need to be obtained (§6.25 of Art. 6 of App 30B) |
New field Required if the notice is submitted under 6.25 of Article 6 of Appendix 30B |
|
|
plan_categ |
X(4) |
|
Category within the Plan (Plan or List) where the group of assignments or allotments is registered |
New field
|
|
|
plan_status |
X(4) |
|
Symbol indicating the status of the group of assignments or allotments within its category |
New field TBD in a Reference table |
Table |
Element |
Format |
Item in AP4 |
Description |
Remark |
|
mod_char |
|
|
|
|
|
|
|
i_nrgy_dsp_typ |
9(4) |
C.9.a.7 |
the type of energy dispersal, if other forms of modulation than FM are used |
Field name change/format change |
|
|
|
|
|
|
suppress |
|
emiss |
|
S99.9 |
C.8.a.1/C.8.b.1/C.8.b.3.a |
the maximum/mean value of the peak envelope power, in dBW, supplied to the input of the antenna for each carrier type |
Field name change/ description change |
|
|
pwr_ds_max |
S99.9 |
c.8.a.2/C.8.b.2/C.8.b.3.b |
the maximum/mean power density, in dB(W/Hz), supplied to the input of the antenna for each carrier type |
Description change |
|
|
pep_min |
S99.9 |
C.8.c.1 |
Minimum peak envelope power in dBW |
Field name change |
|
|
pwr_ctrl |
99.99 |
C.8.i |
If power control is used the maximum range of power control , in dB |
New field
|
|
|
pulse_length |
9(4).99 |
C.16.a.1 |
The pulse length in ms |
New field For active sensors |
|
|
pulse_rep |
9(6).9(5) |
C.16.a.2 |
The pulse repetition frequency in kHz |
New field For active sensors |
|
res49_sel |
|
|
|
Resolution 49 download table |
Data downloaded from SNS for filing RS49 |
|
|
sat_name |
x(20) |
A.1.a |
name of the space station |
|
|
|
long_nom |
S999.99 |
A.4.a.1 |
nominal longitude of space station |
|
|
|
ntf_rsn |
X |
|
category of notification |
|
|
|
adm |
x(3) |
A.1.f.1 |
notifying administration |
|
|
|
ntwk_org |
x(3) |
A.1.f.3 |
intergovernmental satellite organization |
|
|
|
d_inuse |
9(8) |
A.2.a |
date of bringing into use |
|
|
|
ntc_id |
9(9) |
|
BR notice id of the filing |
|
|
|
st_cur |
Xx |
|
processing status of the filing |
|
|
|
d_prot_eff |
9(8) |
|
date of protection of the freq. group |
|
|
|
freq_min |
9(6).9(5) |
C.1.a |
lower bound of the frequency range |
|
|
|
freq_max |
9(6).9(5) |
C.1.b |
upper bound of the frequency range |
|
|
|
wic_no |
9(4) |
|
IFIC publication number of the group |
|
|
|
d_wic |
9(8) |
|
date of the IFIC publication |
|
|
|
act_code |
X |
|
action-code |
|
|
|
grp_id |
9(9) |
|
group id number |
No primary key |
|
|
ntc_type |
X |
A.1.e.1 |
type of notice indicator (G, N) |
|
|
|
beam_name |
x(4) |
B.1.a |
satellite beam designation |
|
|
|
emi_rcp |
X |
B.2 |
satellite beam emission/reception code |
|
|
|
d_reg_g |
9(8) |
|
end of the regulatory period |
Based on API filing or d_rev field in fdg_rev |
Presently page_no field in the grp table is used for Res.49 filings to link the seq_no field in the cmr_syst table to the Res.49 group. To allow many-to-many relationship between the two tables a new table cmr_grp_lnk is suggested:
New table
Table |
Element |
Format |
Item in AP4 |
Description |
Remark |
|
cmr_grp_lnk |
|
|
|
To link cmr_syst to grp |
|
|
|
ntc_id |
9(9) |
|
unique identifier of the notice |
PK, FK |
|
|
seq_cmr |
9(4) |
|
sequence number of the commercial system pertaining to the network submitted on the notice |
PK, FK |
|
|
grp_id |
9(9) |
|
unique identifier of the group (Res49) |
PK, |