Data Dictionary 6.1

Thanks for clearing this up for me!


M. Manasa Reddy
ERP Systems Specialist
Crestview Aerospace Corporation
Email: mmreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Chris Robisch
Sent: Friday, January 27, 2006 10:22 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Data Dictionary 6.1


The D stands for descending as Todd guessed.

The number of minutes is since 10/30/1953. We had to know
this to create Labor Adjustments for Overtime:

ClockInMinute = (payrolldate - 10/30/1953) * 1440
ClockOutMinute = ClockInMinute

Data Collection entries obviously add the appropriate
minutes since midnight.

----- Original Message -----
From: "Manasa Reddy" <mmreddy@...>
To: <vantage@yahoogroups.com>
Sent: Friday, January 27, 2006 7:04 AM
Subject: RE: [Vantage] Data Dictionary 6.1


It was just an example, but yes to your question....there
is
a
base date which something in the 1950s.....it is one of
the
original
programmer's birthday, if I remember correctly.

M. Manasa Reddy
ERP Systems Specialist
Crestview Aerospace Corporation
Email: mmreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Clint
Muhlestein
Sent: Friday, January 27, 2006 8:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Data Dictionary 6.1


I believe this means that the minutes start from a
specific date and
time such as Jan 1 1960 ?

-----Original Message-----
From: Manasa Reddy
[mailto:mmreddy@...]
Sent: Friday, January 27, 2006 6:15 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Data Dictionary 6.1

In the 6 years I have used Vantage this is the first
time
I
have noticed this.

Wondering if anyone out there knows what this is:

If you look in the Data Dictionary, under the Labor Dtl
table, look at the Indexes for Workcenter.
The last Index is this: ClockInMInute <D>

Does anyone know what the <D> is for?


TIA,


M. Manasa Reddy
ERP Systems Specialist
Crestview Aerospace Corporation
Email: mmreddy@...
Phone: (850) 682-2746 x 272


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address to a
yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other 'goodies',
please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services
goto: http://groups.yahoo.com/group/vantage/links



------------------------------------------------------------
------------------
YAHOO! GROUPS LINKS

a.. Visit your group "vantage" on the web.

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.


------------------------------------------------------------
------------------



[Non-text portions of this message have been removed]
In the 6 years I have used Vantage this is the first time I
have noticed this.

Wondering if anyone out there knows what this is:

If you look in the Data Dictionary, under the Labor Dtl
table, look at the Indexes for Workcenter.
The last Index is this: ClockInMInute <D>

Does anyone know what the <D> is for?


TIA,


M. Manasa Reddy
ERP Systems Specialist
Crestview Aerospace Corporation
Email: mmreddy@...
Phone: (850) 682-2746 x 272




[Non-text portions of this message have been removed]
I believe this means that the minutes start from a specific date and
time such as Jan 1 1960 ?

-----Original Message-----
From: Manasa Reddy [mailto:mmreddy@...]
Sent: Friday, January 27, 2006 6:15 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Data Dictionary 6.1

In the 6 years I have used Vantage this is the first time I
have noticed this.

Wondering if anyone out there knows what this is:

If you look in the Data Dictionary, under the Labor Dtl
table, look at the Indexes for Workcenter.
The last Index is this: ClockInMInute <D>

Does anyone know what the <D> is for?


TIA,


M. Manasa Reddy
ERP Systems Specialist
Crestview Aerospace Corporation
Email: mmreddy@...
Phone: (850) 682-2746 x 272




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.clearswift.com
**********************************************************************
I played with the Data Dictionary tool in Progress Explorer. Never did this before. Very interesting. The viewer inside Vantage won't allow viewing triggers or hidden tables but the Dictionary tool will (in read only mode).

Looks like it is related to how the field is stored within the index. If you bwose to the index level there is a column denoted as: A(SC)/D(esc) I have no clue (so far) what this means but all the <D> fields in indexes are D in this column. Also...some fields like QuoteNum (in QuoteDtl) are sometimes A in the index and sometimes D. This is defintely what controls the <D> (I guess A is assumed) but what does it mean?

My best guess is something to do with how the index is sorted...ascending or descending.

DB gurus?

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Manasa Reddy
Sent: Friday, January 27, 2006 7:15 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Data Dictionary 6.1


In the 6 years I have used Vantage this is the first time I
have noticed this.

Wondering if anyone out there knows what this is:

If you look in the Data Dictionary, under the Labor Dtl
table, look at the Indexes for Workcenter.
The last Index is this: ClockInMInute <D>

Does anyone know what the <D> is for?


TIA,


M. Manasa Reddy
ERP Systems Specialist
Crestview Aerospace Corporation
Email: mmreddy@...
Phone: (850) 682-2746 x 272




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]
It was just an example, but yes to your question....there is
a
base date which something in the 1950s.....it is one of the
original
programmer's birthday, if I remember correctly.

M. Manasa Reddy
ERP Systems Specialist
Crestview Aerospace Corporation
Email: mmreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Clint
Muhlestein
Sent: Friday, January 27, 2006 8:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Data Dictionary 6.1


I believe this means that the minutes start from a
specific date and
time such as Jan 1 1960 ?

-----Original Message-----
From: Manasa Reddy
[mailto:mmreddy@...]
Sent: Friday, January 27, 2006 6:15 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Data Dictionary 6.1

In the 6 years I have used Vantage this is the first time
I
have noticed this.

Wondering if anyone out there knows what this is:

If you look in the Data Dictionary, under the Labor Dtl
table, look at the Indexes for Workcenter.
The last Index is this: ClockInMInute <D>

Does anyone know what the <D> is for?


TIA,


M. Manasa Reddy
ERP Systems Specialist
Crestview Aerospace Corporation
Email: mmreddy@...
Phone: (850) 682-2746 x 272




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must
have already linked your email address to a yahoo id to
enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services
goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links










************************************************************
**********
This email and any files transmitted with it are
confidential and
intended solely for the use of the individual or entity to
whom they
are addressed. If you have received this email in error
please notify
the system manager.

This footnote also confirms that this email message has
been swept by
MIMEsweeper for the presence of computer viruses.

www.clearswift.com

************************************************************
**********




Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address to a
yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other 'goodies',
please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services
goto: http://groups.yahoo.com/group/vantage/links



------------------------------------------------------------
------------------
YAHOO! GROUPS LINKS

a.. Visit your group "vantage" on the web.

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.


------------------------------------------------------------
------------------



[Non-text portions of this message have been removed]
The D stands for descending as Todd guessed.

The number of minutes is since 10/30/1953. We had to know this to create Labor Adjustments for Overtime:

ClockInMinute = (payrolldate - 10/30/1953) * 1440
ClockOutMinute = ClockInMinute

Data Collection entries obviously add the appropriate minutes since midnight.

----- Original Message -----
From: "Manasa Reddy" <mmreddy@...>
To: <vantage@yahoogroups.com>
Sent: Friday, January 27, 2006 7:04 AM
Subject: RE: [Vantage] Data Dictionary 6.1


It was just an example, but yes to your question....there is
a
base date which something in the 1950s.....it is one of the
original
programmer's birthday, if I remember correctly.

M. Manasa Reddy
ERP Systems Specialist
Crestview Aerospace Corporation
Email: mmreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Clint
Muhlestein
Sent: Friday, January 27, 2006 8:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Data Dictionary 6.1


I believe this means that the minutes start from a
specific date and
time such as Jan 1 1960 ?

-----Original Message-----
From: Manasa Reddy
[mailto:mmreddy@...]
Sent: Friday, January 27, 2006 6:15 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Data Dictionary 6.1

In the 6 years I have used Vantage this is the first time
I
have noticed this.

Wondering if anyone out there knows what this is:

If you look in the Data Dictionary, under the Labor Dtl
table, look at the Indexes for Workcenter.
The last Index is this: ClockInMInute <D>

Does anyone know what the <D> is for?


TIA,


M. Manasa Reddy
ERP Systems Specialist
Crestview Aerospace Corporation
Email: mmreddy@...
Phone: (850) 682-2746 x 272


[Non-text portions of this message have been removed]