Skip to main content

DBO function to return host country 2 character ISO code from assignment id

The DBO.EQ_STD_HOST_COUNTRY_ISO2_FROM_ASSIGNMENT_ID function returns a 2-character ISO code for the host country based on an assignment ID

DBO.EQ_STD_HOST_COUNTRY_ISO2_FROM_ASSIGNMENT_ID(Parameter1)

This function will accept the assignment id and return the 2 character ISO code for the From Country. This same information can also be added to your report using the Assignment Derived Calculations data source, To Country Code (2 Char) field.

Parameter(s)

Parameter1: [Assignment: ID]

Example(s)

Example 1: Return the 2 character ISO code for the host country for an assignment

  • DBO.EQ_STD_HOST_COUNTRY_ISO2_FROM_ASSIGNMENT_ID([Assignment: ID])

Related Articles
DBO function to return account taxability from account id and country
DBO function to return home country 2 character ISO code from assignment Id
DBO function to return 2 letter code for country and state/province from country name and state/province name
DBO function to return 3 character code from country name
DBO function to return dependent details codes from assignment id and date
Did this answer your question?