RE: Dumb SQL question

As someone earlier mentioned, looks like primary keys.

Take a look at this and look for articles by Kent Milligan for more info.

http://www.centerfieldtechnology.com/publications/archive/Feb-Mar09.pdf


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Nelson
Sent: Wednesday, October 26, 2011 11:23 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Dumb SQL question

Using SQL, and prompting for the fields:

Seq Field File Text
HRTEMPID HRTEMP HRTEMP Record Id
STATUSCODE HRTEMP Status Code
SRCCNCID HRTEMP Src SYTCNC Id
COMPANYNUMBER HRTEMP Src Com
DIVISIONNUMBER HRTEMP Srd Div
EMPCNCID HRTEMP Emp SYTCNC Id
EMPLOYEECOMPANY HRTEMP Emp Com
EMPLOYEEDIVISIO > HRTEMP Emp Div
CHGCNCID HRTEMP Chg SYTCNC Id
CHGCOMPANYNO HRTEMP Chg Com
CHGDIVISIONNO HRTEMP Chg Div
SOCIALSECNO HRTEMP Soc/EI No
PRTMSTID HRTEMP PRTMST Rec Id
EMPLOYEENUMBER HRTEMP Empl No

This is the HR module employee master. PRTMST is the employee master in the
actual payroll system. This also has the old DDS field names when I toggle.

Paul Nelson
Office 512-392-2577
Cell 708-670-6978
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, October 26, 2011 12:03 PM
To: Midrange Systems Technical Discussion
Subject: Re: Dumb SQL question

I would need to see a sample. I have some guesses as to what's going on
but I'm withholding them until I see examples.


Rob Berendt