Fetch Person Relationship

These function can be used to get and map the Person to Person relationship with its corresponding column/output values listed below.

Parameter PER_ID_NBR is mandatory input for this function.

Function:

FETCH(PER_RELATION[COLUMN_NAME,PER_ID1,PER_ID2,PER_REL_TYPE_CD,FINAN_REL_SW,
END_DT,SET_OPERATION])

Expected list of input field/column values:

Input Parameter	Description	Table Description
COLUMN_NAME	Column name to be mapped from the returned RESULTSET. i.e. OUTPUT field name
PER_ID1	Person1	Person to Person
PER_ID2	Child Person	Person to Person
PER_REL_TYPE_CD	Relationship Type	Person to Person
FINAN_REL_SW	Financial Relationship	Person to Person
END_DT	End Date (This date will be compared to be greater than or equal to END DATE or retrieved if NULL)	Person to Person
SET_OPERATION	This is a BOOLEAN value. If TRUE - Reset operation configured at service level. If FALSE - Validate the fetch function output i.e. Throws error if returns NULL or multiple records. If NULL – Will do nothing but only throw an error if function return multiple records.

List of output field/column values: