Fetch Contract
These function can be used to get the Contract ID, Contract Type and other corresponding below listed column values.
Contract identifier can be retrieved using the Contract and Account relationship. 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(SA[COLUMN_NAME,PER_ID_NBR,ID_TYPE_CD,ACCT_REL_TYPE_CD,ACCT_NBR,
ACCT_NBR_TYPE_CD,SA_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 |
| SA_TYPE_CD | Contract Type | SA (Service Agreement) |
| 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 |
| ACCT_ID | Account ID | Account |
| CIS_DIVISION | Division of an Account | Account |
| CURRENCY_CD | Currency Code of an Account | Account |
| PER_ID | Person ID (Returned only when PER_ID_NBR is passed as an function input) | Person Identifier |
| SA_ID | Contract ID | SA (Service Agreement) |
| ACCT_REL_TYPE_CD | Account Relationship Type (Returned only when PER_ID_NBR is passed as an function input) | Account Person Relationship |
| ACCT_NBR_TYPE_CD | Account Identifier Type | Maintains External Account Numbers |
| SA_TYPE_CD | Contract Type | SA (Service Agreement) |
| ACCT_USAGE_FLG | Account Usage | Account |
| VERSION | Version | Account |