SNS database changes - Database version 6.1

                                                            following WRC07 decisions for AP30B

                                                            28  July 2009

Tables Deleted

 

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

 

 

 

 

 

 

srv_arc_fr

srv_ew_fr

srv_arc_to

srv_ew_to

 

A.4.a.4

limits and directions of the arc of the geostationary satellite orbit within which the space station could provide the required service to its associated earth stations or service areas)

To be suppressed

 

 

pd_arc_fr

pd_ew_fr

pd_arc_to

pd_ew_to

 

 

limits and directions of the predetermined arc of the geostationary satellite orbit

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

 

pwr_nom_eirp
eirp_nom

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

 

 

 

 

 

 

nrg_dsp_type

i_nrgy_dsp_typ

X(10)

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

 

freq_5db

9(5).9(5)

C.8.j

the frequency below which signals peak-to-average ratio < 5dB will be located

suppress

emiss

pwr_tot_pk
pep_max

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

 

pwr_min_pk

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,