Skip to main content

DBO function to return resource contact information from assignment id and the resource code

DBO.EQ_STD_WEBPART_ASSIGNMENT_COORDINATOR(Parameter1, Parameter2) This function will accept ([Assignment: ID], ‘EQ_Code’) to return all the resource contact information (including photo) based on the

Updated over 2 weeks ago

DBO.EQ_STD_WEBPART_ASSIGNMENT_COORDINATOR(Parameter1, Parameter2)

This function will accept ([Assignment: ID], ‘EQ_Code’) to return all the resource contact information (including photo) based on the corresponding EQ_Code.

This is useful in displaying all resource contact information in widgets.

mceclip0.png

Parameter(s)

Parameter1: [Assignment: ID]

Parameter2:'EQ_Code' - the available codes are as follows:

  • EQRJRELOCO - Relocation Coordinator

  • EQRJAACCTG - Accounting Coordinator

  • EQASMADR01 - Assignment Additional Resource #1

  • EQASMADR02 - Assignment Additional Resource #2

  • EQASMADR03 - Assignment Additional Resource #3

  • EQASMADR04 - Assignment Additional Resource #4

  • EQASMADR05 - Assignment Additional Resource #5

  • EQASMADR06 - Assignment Additional Resource #6

  • EQASMADR07 - Assignment Additional Resource #7

  • EQASMADR08 - Assignment Additional Resource #8

  • EQASMADR09 - Assignment Additional Resource #9

  • EQASMADR10 - Assignment Additional Resource #10

  • EQASMADR11 - Assignment Additional Resource #11

  • EQASMADR12 - Assignment Additional Resource #12

  • EQASMADR13 - Assignment Additional Resource #13

  • EQASMADR14 - Assignment Additional Resource #14

  • EQASMADR15 - Assignment Additional Resource #15

  • EQASMADR16 - Assignment Additional Resource #16

  • EQASMADR17 - Assignment Additional Resource #17

  • EQASMADR18 - Assignment Additional Resource #18

  • EQASMADR19 - Assignment Additional Resource #19

  • EQASMADR20 - Assignment Additional Resource #20

  • EQASMADR21 - Assignment Additional Resource #21

  • EQASMADR22 - Assignment Additional Resource #22

  • EQASMADR23 - Assignment Additional Resource #23

  • EQASMADR24 - Assignment Additional Resource #24

  • EQASMADR25 - Assignment Additional Resource #25

  • EQASMADR26 - Assignment Additional Resource #26

  • EQASMADR27 - Assignment Additional Resource #27

  • EQASMADR28 - Assignment Additional Resource #28

  • EQASMADR29 - Assignment Additional Resource #29

  • EQASMADR30 - Assignment Additional Resource #30

Example(s)

Example 1: Return the Relocation Coordinator's contact information from the resource table including photo if it exists.

  • DBO.EQ_STD_WEBPART_ASSIGNMENT_COORDINATOR([Assignment: ID], 'EQRJRELOCO')

Related Articles
DBO function to return account taxability from account id and country
DBO function to return dependent details from assignment id and date
DBO function to return dependent details codes from assignment id and date
DBO function to return segment lookup code from segment display value, segment level and company id
DBO function to return segment lookup code from assignment id, segment level and value of 'FROM'/'TO'
Did this answer your question?