Home » blog » erica@ensync-corp.com's blog

Accessing the Subsitute field in the Gen_Tables via SOA

Posted August 17th, 2012 by erica@ensync-co...

I am trying to access the "SUBSTITUTE" field in the GEN_TABLES using SOA's but the field name references don't necessarily match the fields in the table.

For example to get information from the GEN_TABLES.CODE is used as "Name" in the following code I have written: 

item.Text= providerItem["Name"]

Luckily Description is the same. Does anyone know what I would use as the field reference in my code to get the information from GEN_TABLES.SUBSTITUTE ? 

 

Thanks in advance,

 

Erica Llaca

erica@ensync-corp.com's blog | login or register to post comments | printer friendly version

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

GeneralReference

On August 20th, 2012 Henry Huey says:

General lookup/validation tables are represented by GeneralReference in SOA, and the data comes from the view vSoaGeneralReference.  There's not an explicit way to get Gen_Tables.SUBSTITUTE (instead of CODE); SOA will return it as the Name if it's non-blank.

For example, for a Gen_Tables entry like this:

TABLE_NAME TITLE
CODE  P
SUBSTITUTE President
DESCRIPTION The President

...vSoaGeneralReference returns:

GeneralReferenceId TITLE:President
Table  TITLE
Name  President
Description The President

The Substitute value is used as the Name, since it's non-blank.  If Gen_Tables.SUBSTITUTE is blank, then Code is used as the Name in SOA.

 

login or register to post comments

That makes sense. I

On August 21st, 2012 erica@ensync-co... says:

That makes sense. I appreciate the feedback, very helpful! Thank you! 

login or register to post comments