DBO.EQ_STD_DEPENDENT_BASIC_INFO_CODES(Parameter1, Parameter2)
This function requires the assignment id and a date. It will display dependent information for an assignment, including: first & last name, gender Client Code if one exists else Code, date of birth, age, primary citizenship three character ISO code, and status Client Code if one exists, else Code. 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: Display the dependent information for an assignment, including: first & last name, gender Client Code if one exists else Code, date of birth, age as of today's date, primary citizenship three character ISO code, and status Client Code if one exists, else Code.
DBO.EQ_STD_DEPENDENT_BASIC_INFO_CODES([Assignment: ID], GETDATE())
Example 2: Display the dependent information for an assignment, including: first & last name, gender Client Code if one exists else Code, date of birth, age as on a given date, primary citizenship three character ISO code, and status Client Code if one exists, else Code.
DBO.EQ_STD_DEPENDENT_BASIC_INFO([Assignment: ID], '2019-01-01')
Example of field output
System Lookup Maintenance by Gender screen
System Lookup Maintenance by Dependent Status screen
