Fetch Person
These function can be used to get the Person identifier with its corresponding detail field values i.e. below listed column/output values.
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.
Either of the inputs PER_ID_NBR or ACCT_NBR is mandatory input for this function.
Function:
FETCH(PER[COLUMN_NAME,PER_ID_NBR,ID_TYPE_CD,ACCT_REL_TYPE_CD,ACCT_NBR,
ACCT_NBR_TYPE_CD,DIVISION,ACCT_USAGE_FLG,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 |
| 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 |
| DIVISION | Division | Account |
| ACCT_USAGE_FLG | Account Usage | Account |
| 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 (Returned only when PER_ID_NBR is passed as an function input) | Person Identifier |
| ACCESS_GRP_CD | Access Group Code (Returned only when PER_ID_NBR is passed as an function input) | Person |
| PRIM_SW | Primary ID (Returned only when PER_ID_NBR is passed as an function input) | Person Identifier |
| ACCT_ID | Account ID (Returned only when ACCT_NBR is passed as an function input) | Account |
| CIS_DIVISION | Division of an Account (Returned only when ACCT_NBR is passed as an function input) | Account |
| CURRENCY_CD | Currency Code of an Account (Returned only when ACCT_NBR is passed as an function input) | Account |
| ACCT_REL_TYPE_CD | Account Relationship Type (Returned only when ACCT_NBR is passed as an function input) | Account Person Relationship |
| ACCT_NBR_TYPE_CD | Account Identifier Type (Returned only when ACCT_NBR is passed as an function input) | Maintains External Account Numbers |
| ENTITY_NAME | Contract Type (Returned only when ACCT_NBR is passed as an function input) | Person Name |
| ACCT_USAGE_FLG | Account Usage (Returned only when ACCT_NBR is passed as an function input) | Account |
| VERSION | Version | Person |