Issue with a field in a extract
Summary
Pull up the Action type codeContent
Hi,
I have this fast formula
DEFAULT FOR DATA_ELEMENTS IS EMPTY_TEXT_TEXT
INPUTS ARE DATA_ELEMENTS (TEXT_TEXT)
L_****_ID = DATA_ELEMENTS['ASSIGNMENT_ID']
L_EFF1_DATE = TO_DATE(DATA_ELEMENTS['Effective_Date'],'YYYY/MM/DD')
L_ACTION_REASON_CODE = 'NULL'
L_ACTION_REASON_CODE = GET_VALUE_SET('TEST_GET_ACTION_REASON_CODE_VS'
,'|=P_ASSIGNMENT_ID='''||L_****_ID||''''||'|L_EFF_DT='''||TO_CHAR(L_EFF1_DATE)||''''
)
RULE_VALUE = L_ACTION_REASON_CODE
RETURN RULE_VALUE
that reads this VS
AND pav.action_code = paam.action_code
Tagged:
0