Fetch Person Characteristic
These function can be used to get the Person identifier and Characteristics along with its other corresponding field values i.e. below listed column/output values.
Parameters PER_ID_NBR and CHAR_TYPE_CD are mandatory inputs for this function.
Function:
FETCH(PER_CHAR[COLUMN_NAME,PER_ID_NBR,ID_TYPE_CD,CHAR_TYPE_CD,PRIM_SW,
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 |
| CHAR_TYPE_CD | Characteristic Type Code | Account Person Relationship |
| PRIM_SW | Primary ID switch | Person Identifier |
| 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 | Person Identifier |
| ID_TYPE_CD | Person Identifier Type | Person Identifier |
| ACCESS_GRP_CD | Access Group Code | Person |
| PRIM_SW | Primary ID | Person Identifier |
| CHAR_TYPE_CD | Characteristic Type Code | Person Characteristics |
| CHAR_VAL | Characteristic Value | Person Characteristics |
| EFFDT | Effective Date | Person Characteristics |
| CHAR_VAL_FK1 | Characteristic Value FK1 | Person Characteristics |
| CHAR_VAL_FK2 | Characteristic Value FK2 | Person Characteristics |
| CHAR_VAL_FK3 | Characteristic Value FK3 | Person Characteristics |
| CHAR_VAL_FK4 | Characteristic Value FK4 | Person Characteristics |
| CHAR_VAL_FK5 | Characteristic Value FK5 | Person Characteristics |
| VERSION | Version | Person |