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 |