Special Checklist Fields

Keystyle Support Team -

 

Job Name:  The checklist field must be named Job Name.  The value should be the KeyID on JCJM.  The normal lookup for this field is below:

Select Distinct CAST(j.KeyID as varchar(10)) as ChoiceShortName, j.Job + ' - ' + j.[Description] as ChoiceLongName
FROM kJCJM j
WHERE j.JobStatus = 1 and JCCo = 1
Order by ChoiceLongName

 

Employee: The checklist field must be named Employee.  The value should be the KeyID on HRRM.  The normal lookup for this field is below:

select cast(kHRRM.KeyID as varchar(10)) as ChoiceShortName, ltrim(rtrim(LastName)) + case when Suffix is Null then '' else ' ' + ltrim(rtrim(Suffix)) end + ', ' + ltrim(rtrim(FirstName)) + ' ' + ltrim(rtrim(isnull(MiddleName,''))) as ChoiceLongName
from kHRRM
where HRCo = 1
and ActiveYN = 'Y'
Order by ChoiceLongName

 

Equipment: The checklist field must be named Equipment.  The value should be the KeyID on EMEM.  The normal lookup for this field is below:

Select Distinct CAST(kEMEM.KeyID as varchar(10)) as ChoiceShortName, kEMEM.Equipment + ' - ' + kEMEM.[Description] as ChoiceLongName
FROM kEMEM
WHERE kEMEM.EMCo = 1
Order by ChoiceShortName

 

Project Manager: The checklist field must be named JCMP.  The value should be the ProjectMgr on JCMP.  The normal lookup for this field is below:

select cast(kJCMP.ProjectMgr as varchar(10)) as ChoiceShortName, cast(LTRIM(kJCMP.ProjectMgr) as varchar(10)) + ' - ' + kJCMP.Name as ChoiceLongName
FROM kJCMP
WHERE kJCMP.JCCo = 1
ORDER BY ChoiceShortName

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk