DBO.EQ_STD_DEPENDENT_BASIC_INFO(Parameter1, Parameter2)
This function requires the assignment id and a date. It will display dependent information for an assignment, including: first & last name, gender, date of birth, age, primary citizenship, and status. You can use GetDate() as the date parameter if you’d like to use today’s date. The date is used to calculate the dependent’s age from the given date parameter and the dependent’s birth date.
Parameter(s)
Parameter1: [Assignment: ID]
Parameter2 : Date used to calculate the dependent's age from the given date parameter and the dependent's birth date.
Example(s)
Example 1: Return the dependent information for an assignment, including: first & last name, gender, date of birth, age as today's date, primary citizenship, and status.
DBO.EQ_STD_DEPENDENT_BASIC_INFO([Assignment: ID], GETDATE())
Example 2: Return the dependent information for an assignment, including: first & last name, gender, date of birth, age on a given date, primary citizenship, and status.
DBO.EQ_STD_DEPENDENT_BASIC_INFO([Assignment: ID], '2019-01-01')
Example of field output
