Examples of EMP_ID access

These examples show how EMP_ID can be accessed in different parts of MVS.

ASV Inline Details

ESV_INLINE_JOB

multiChoice=false sourceType=SQL source='select j.job_id,
j.job_name, ej.emp_id from employee_job ej, job j where ej.job_id =
j.job_id and ej.emp_id = EMP_ID' orderBy='job_name' all= false
labelFieldStatus=edit title='LOOKUP_JOB' width=10
primarySecondaryUseXPath='true'
primaryInputFields=[ancestor::tr/preceding-sibling::tr [1]/@employee_tag] primaryDataFields= [emp_id]

ASV Book Off

MVS_BOW_CODE

sourceType='SQL' width='7' locale='en' labelFieldStatus=edit
sourceKeyField=JOB_ID sourceLabelField=JOB_NAME source='select
j.job_id, j.job_name, ej.emp_id from employee_job ej, job j where
ej.job_id = j.job_id and ej.emp_id = EMP_ID ORDER BY JOB_NAME'
labelFieldStatus=edit title='LOOKUP_SO_ACTIVITY' resolveType=SQL
resolve='SELECT A.ACT_ID, A.ACT_NAME FROM VL_SO_ACTIVITY A,
ES_ACT_TYPE_MAP ATM WHERE A.ACT_ID = ATM.ACT_ID'
primarySecondaryUseXPath='true' 
primaryInputFields= [ancestor::tr/@employee_tag] primaryDataFields=[emp_id]

ASV Float

MVS_FLOAT_JOB

sourceType=SQL width='10' source='select j.job_id, j.job_name,
ej.emp_id from employee_job ej, job j where ej.job_id = j.job_id
and ej.emp_id = EMP_ID ORDER BY JOB_NAME' labelFieldStatus=edit
title='LOOKUP_JOB' primaryInputFields=[EMP_ID] primaryDataFields=[emp_id]

Employee Call Pop-up

ECP_ESD_ACCT_CODE_ID

width='12' sourceType=SQL source='select PROJ_ID,PROJ_NAME, EMP_ID
FROM PROJECT, EMPLOYEE where PROJ_ID = (EMP_ID % 4)'
primaryInputFields=[EMP_ID]
primaryDataFields=[emp_id]title='LOOKUP_PROJECT' labelFieldStatus=edit