GetMSOCorpParams

Input XML Tags

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

 

Output XML Tags

XML Tag

Column Name

Data Type

Nullable

Definition

msocp_acctcorp

ACCTCORP

INT UNSIGNED

N

Home account corp number. Valid Values: All 5 digits of the corp number

msocp_mso

MSO

CHAR(3)

N

MSO code OR Company number.

Msocp_active

ACTIVE

SMALLINT UNSIGNED

N

Active parameter flag. Valid Values: 1 = active 0 = inactive

msocp_description

DESCRIPTION

CHAR(20)

N

Name of the TANDEM.

Msocp_qtdstartmonth

QTDSTARTMONTH

SMALLINT UNSIGNED

N

Starting month of the 1st quarter/each quarter will have 3 months.. Valid Values: Jan =1 Feb=2 etc.If 1st quarter is not Jan, then the last quarter will always span years

msocp_msocontrol

MSOCONTROL

INT UNSIGNED

N

1 = MSO Control option.. Valid Values: 0 or 1

msocp_tandemnumber

TANDEMNUMBER

SMALLINT UNSIGNED

N

Logical Tandem number identifier. Valid Values: 1 – 999

 

Source Tables