Fetch Parent Person

These function can be used to get the root parent person from the person hierarchy

Account identifier can be retrieved for either the given PER_​ID_​NBR i.e. with reference to the defined relationship between Person and Account in “Account Person Relationship” table or ACCT_​NBR i.e. with reference to the relationship defined in the “Maintains External Account Numbers” table.

Only input parameters PER_​ID_​NBR and ID_​TYPE_​CD are optional and remaining are mandatory for this function.

Function:

FETCH(PARENT_PER[COLUMN_NAME,PER_ID_NBR,ID_TYPE_CD,PER_REL_TYPE_CD,
ACCT_REL_TYPE_CD,ACCT_NBR,ACCT_NBR_TYPE_CD,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_​ID_​NBR Person Id Number Person Identifier
ID_​TYPE_​CD Person Identifier Type Person Identifier
PER_​REL_​TYPE_​CD Person Relationship Type Code Person Identifier
ACCT_​REL_​TYPE_​CD Account Relationship Type Account Person Relationship
ACCT_​NBR Account Identifier Maintains External Account Numbers
ACCT_​NBR_​TYPE_​CD Account Identifier Type Maintains External Account Numbers
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:

Output Parameter Description Table Description
PER_​ID Person ID (Returned only when PER_​ID_​NBR is passed as an function input) Person Identifier
PER_​ID_​NBR Person Id Number Person Identifier
ID_​TYPE_​CD Person Identifier Type Person Identifier
PRIM_​SW Primary ID switch Person Identifier
VERSION Version Person Identifier