Current Subassembly Rev - 8.03.403B

ECOMtl and ECORev are subtables of ECOGroup.

ECO, GroupID, ClosedDate & Effective Date are all ECOGroup columns.
GroupID and PartNum are ECOMtl columns.
GroupID, ParNum, Approved (boolean), CheckedOut (boolean), ECO, Effective Date, RevNum, RevLocked (boolean) are all ECORev columns.

It sounds like all you are saying Revisions for PartRev.PartNum are Approved (boolean true).

Perhaps you can use the three ECO table data to see what your engineering process is resulting in that might allow you to determine the specific Rev that is active (if indeed only one IS active).

If you find nothing definitive, it is probably some unspoken rule that the at highest (most recent) Rev is active (or perhaps the opposite depending upon your processes).

Have fun.

Rob Brown

pvolkert365 <pvolkert@...> wrote:
I am trying to create a report that shows the BOM of a part number
that consists of several subassemblies, each of which has a rev. If
I look at the part using Method Master, it displays the current rev
of each subassembly. It is getting its information from ECOMtl and
ECORev. But I can't figure out how.

Our engineering folks have left all our past revs listed as
Approved. So one approach is to Unapprove all the old revs. But if
Vantage can pick the right revs for the Method Master, why can't I?
I am trying to figure out how they do it. I don't see any field that
specifies which rev of a subassembly should be associated with a
particular rev of the parent part. Perhaps they are just taking the
most recent Approved rev. But that would add a lot of complexity to
a crystal report.

I appreciate the inputs.

-Peter Volkert
Symetrics Industries

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> You want to check PartRev table for Revs that are only Approved
(true).
>
> If multiple approved Revs exist (quite possible in many
environments) use the Effective Date as another criteria. (Revs with
effective dates in the future are NOT allowed to be in use now.)
>
> Hard to provide more suggestions without knowing what you are
actually trying to accomplish.
>
> Rob Brown
>
> pvolkert365 <pvolkert@...> wrote:
> Does anyone know how to decipher what the current rev is
for a part or
> subassembly? I would have thought there would be a field in the
> PartRev table that would indicate which rev is current. I suppose
the
> current one is the most recent one that has been approved, but when
you
> create a crystal report and are trying to link levels in an overall
> assembly, it is hard to make a link like that. Where should I be
> looking?
>
> -Peter Volkert
>
>
>
>
>
>
> ---------------------------------
> Looking for last minute shopping deals? Find them fast with Yahoo!
Search.
>
> [Non-text portions of this message have been removed]
>






---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.

[Non-text portions of this message have been removed]
Does anyone know how to decipher what the current rev is for a part or
subassembly? I would have thought there would be a field in the
PartRev table that would indicate which rev is current. I suppose the
current one is the most recent one that has been approved, but when you
create a crystal report and are trying to link levels in an overall
assembly, it is hard to make a link like that. Where should I be
looking?

-Peter Volkert
Peter, I believe that the "current" status you are looking for is actually a function of whether a revision is A) approved and B) has an effective date greater than or equal to the current date. This is because you can have more than one "current" rev.

Carey


To: vantage@yahoogroups.comFrom: pvolkert@...: Mon, 28 Jan 2008 19:58:41 +0000Subject: [Vantage] Current Subassembly Rev - 8.03.403B




Does anyone know how to decipher what the current rev is for a part or subassembly? I would have thought there would be a field in the PartRev table that would indicate which rev is current. I suppose the current one is the most recent one that has been approved, but when you create a crystal report and are trying to link levels in an overall assembly, it is hard to make a link like that. Where should I be looking?-Peter Volkert






_________________________________________________________________
Helping your favorite cause is as easy as instant messaging. You IM, we give.
http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join

[Non-text portions of this message have been removed]
You want to check PartRev table for Revs that are only Approved (true).

If multiple approved Revs exist (quite possible in many environments) use the Effective Date as another criteria. (Revs with effective dates in the future are NOT allowed to be in use now.)

Hard to provide more suggestions without knowing what you are actually trying to accomplish.

Rob Brown

pvolkert365 <pvolkert@...> wrote:
Does anyone know how to decipher what the current rev is for a part or
subassembly? I would have thought there would be a field in the
PartRev table that would indicate which rev is current. I suppose the
current one is the most recent one that has been approved, but when you
create a crystal report and are trying to link levels in an overall
assembly, it is hard to make a link like that. Where should I be
looking?

-Peter Volkert






---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.

[Non-text portions of this message have been removed]
I am trying to create a report that shows the BOM of a part number
that consists of several subassemblies, each of which has a rev. If
I look at the part using Method Master, it displays the current rev
of each subassembly. It is getting its information from ECOMtl and
ECORev. But I can't figure out how.

Our engineering folks have left all our past revs listed as
Approved. So one approach is to Unapprove all the old revs. But if
Vantage can pick the right revs for the Method Master, why can't I?
I am trying to figure out how they do it. I don't see any field that
specifies which rev of a subassembly should be associated with a
particular rev of the parent part. Perhaps they are just taking the
most recent Approved rev. But that would add a lot of complexity to
a crystal report.

I appreciate the inputs.

-Peter Volkert
Symetrics Industries



--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> You want to check PartRev table for Revs that are only Approved
(true).
>
> If multiple approved Revs exist (quite possible in many
environments) use the Effective Date as another criteria. (Revs with
effective dates in the future are NOT allowed to be in use now.)
>
> Hard to provide more suggestions without knowing what you are
actually trying to accomplish.
>
> Rob Brown
>
> pvolkert365 <pvolkert@...> wrote:
> Does anyone know how to decipher what the current rev is
for a part or
> subassembly? I would have thought there would be a field in the
> PartRev table that would indicate which rev is current. I suppose
the
> current one is the most recent one that has been approved, but when
you
> create a crystal report and are trying to link levels in an overall
> assembly, it is hard to make a link like that. Where should I be
> looking?
>
> -Peter Volkert
>
>
>
>
>
>
> ---------------------------------
> Looking for last minute shopping deals? Find them fast with Yahoo!
Search.
>
> [Non-text portions of this message have been removed]
>
Hi Peter,
> I am trying to create a report that shows the BOM of a part number
> that consists of several subassemblies, each of which has a rev. If
> I look at the part using Method Master, it displays the current rev
> of each subassembly. It is getting its information from ECOMtl and
> ECORev. But I can't figure out how.

Maybe others can correct me, but I think that only MOMs checked out are in the
ECO files (ECOMtl, ECORev, etc.) but the checked-in versions are in PartRev,
PartMtl, etc.

Mark W.
Actually I see basically the same fields and data whether I am
looking in the "ECO" tables or in the "Part" tables.

-Peter


--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> Hi Peter,
> > I am trying to create a report that shows the BOM of a part number
> > that consists of several subassemblies, each of which has a rev.
If
> > I look at the part using Method Master, it displays the current
rev
> > of each subassembly. It is getting its information from ECOMtl and
> > ECORev. But I can't figure out how.
>
> Maybe others can correct me, but I think that only MOMs checked out
are in the
> ECO files (ECOMtl, ECORev, etc.) but the checked-in versions are in
PartRev,
> PartMtl, etc.
>
> Mark W.
>
> Actually I see basically the same fields and data whether I am
> looking in the "ECO" tables or in the "Part" tables.

That's right. The fields are the same but I believe that the ECO tables hold a
copy of the MOM while they are checked out. Look for a BOM or Method for a rev
that is not checked out and see if the records are still in the ECO tables.

Mark W.