[CON Devel] tribal_code default

[John Haasbeek]

The tribal code is currently defined as four characters with a default
value of 0000.  In the near future, tribal code will most likely change
to 5 characters with a default of 00000.  Some of the rpo cross
reference files are already formatted for the 5-character tribal code,
with the default value of 00000.  CONCEPT adheres to the 4-character
standard.  After import, each of the other modules executes a qa routine
which includes a script named set_mmmm_defaults.sql where mmmm is the
module name.  This routine sets the default values for non-null fields
that contain obviously incorrect values (e.g., tribal codes of '0' are
set to '0000') - it is in these scripts that the rpo_sr tribal codes are
changed from '00000' to '0000'.

Since we don't know which modules and in which order a given user will
execute, we set these defaults in each module.  It is time-consuming for
large files, but only for the first module - subsequent modules make the
calls but don't need to update and records (except tables specific to
that module).

In the QA step for your module, you should follow the same structure as
the other modules, including the set_mmmm_defaults script just in case
yours is the only (or the first) module that is called.

Hope that clears things up,

John H.

-----Original Message-----
From: devel-bounces at conceptmodel.org
[mailto:devel-bounces at conceptmodel.org] On Behalf Of Mike Masonjones
Sent: Wednesday, March 09, 2005 11:43 AM
To: 'devel at conceptmodel.org'
Subject: [CON Devel] tribal_code default

I have noticed a problem that is now causing me some trouble.  The
xref.rpo_sr table has a tribal_code field in it, which is importing
correctly as '00000' (five zeroes) from the rpo directory that comes
with
the beta3 version.  Somewhere in the install after the initial import,
the
field is getting changed to its default value of '0000' (only four
zeroes).
This causes problems with my joins, since no match can be made on the
bad
values. Can anyone offer me an explanation of this.  Are the rpo tables
regenerated during one of these concept functions: import_control,
run_grid_definition_model, import_nei, qa_nei_area, qa_nei_point?  If
so, is
it just a matter of filling in the default correctly?  Who has control
of
the code that sets the default for the xref.rpo_sr.tribal_code field?

Michael C. Masonjones
Senior Consultant, Engineering/IT
ENVIRON International Corporation
10150 Highland Manor Dr #440
Tampa, FL 33610

813-628-4325 - phone
813-628-4983 - fax
mmasonjones at environcorp.com

_______________________________________________
Devel mailing list
Devel at conceptmodel.org
http://lists.conceptmodel.org/mailman/listinfo/devel



This message contains information that may be confidential, privileged or otherwise protected by law from disclosure. It is intended for the exclusive use of the Addressee(s). Unless you are the addressee or authorized agent of the addressee, you may not review, copy, distribute or disclose to anyone the message or any information contained within. If you have received this message in error, please contact the sender by electronic reply to email at environcorp.com and immediately delete all copies of the message.