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
masterSlaveUseXPath='true'
masterInputFields=[ancestor::tr/preceding-sibling::tr [1]/@employee_tag] masterDataFields= [emp_id]

Asv Book Off

NSV_BOOKOFF_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'
masterSlaveUseXPath='true' 
masterInputFields= [ancestor::tr/@employee_tag]masterDataFields=[emp_id]

ASV/STC 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' masterInputFields=[EMP_ID]masterDataFields= [emp_id]

STC Inline Details

STC_ACT_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 ORDER BY JOB_NAME' all=false
labelFieldStatus=edit title='LOOKUP_JOB' width=10
masterSlaveUseXPath='true'
masterInputFields=[ancestor::tr/td[1]/span [1]/@wbempid]
masterDataFields=[emp_id]

STC Book Off

MVS_BOOKOFF_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'
masterSlaveUseXPath='true' 
masterInputFields=[ancestor::tr/@employee_tag]masterDataFields=[emp_id]

Relief Calling Area

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)'
masterInputFields=[EMP_ID]
masterDataFields=[emp_id]title='LOOKUP_PROJECT' labelFieldStatus=edit