GetCode95

Input XML Tags

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

table_number

Table number of code 95 table

c95_code

Legal values; 1 - 95, blank = full table request

 

Output XML Tags

XML Tag

Column Name

Data Type

Nullable

Definition

c95_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

c95_tabl

TABL

CHAR(3)

N

Table number

c95_required

REQUIRED

CHAR(1)

N

Y = Entry required

code95group

   

Beginning code95group delimiter

code

   

Beginning code delimiter

c95_code

CODE

CHAR(2)

N

Valid code from the table (1 – 95)

c95_desc

DESCRIPTION

CHAR(13)

N

Equals long description if long description is 13 characters or less, otherwise equals short description; NOT RETURNED IF "INPUT" INCLUDES SPECIFIC CODE95 CODE

c95_shortdes

SHORTDES

CHAR(8)

N

Short Description, not returned on full table request

c95_longdesc

LONGDESC

CHAR(20)

N

Long Description; not returned on full table request

c95_wrkpnts

WRKPNTS

CHAR(2)

N

Work points tied to this task; not returned on full table request

c95_socgrp

SOCGRP

CHAR(2)

N

Social group tied to the cluster code; not returned on full table request

c95_countoutage

COUNTOUTAGE

CHAR(1)

N

Count this type as an outage type N = no, Y = yes; not returned on full table request

c95_nctexempt

NCTEXEMPT

CHAR(1)

N

Identifies this task code as a custom type task; Y = custom type task, N = not custom; not returned on full table request

c95_msocode

MSOCODE

CHAR(1)

N

Code to use in MSO reporting (1 – 95); not returned on full table request

/code

   

Ending code delimiter

/code95group

   

Ending code95group delimiter

 

Source Tables

 

Usage

c95_code thru c95_msocode are repeatable for each code in the database.

 

Associated XML Documents