Fetch User

These function can be used to get and map the User details with its other corresponding column/output values listed below.

Input parameter USER_ID is mandatory to invoke this function.

Function:

FETCH(USER[COLUMN_NAME,USER_ID,EXT_USER_ID,USER_TYPE_FLG,USER_ENABLE_FLG,
OWNER_FLG,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
USER_ID	User ID	User
EXT_USER_ID	External User Id	User
USER_TYPE_FLG	User Type	User
USER_ENABLE_FLG	User Enable	User
OWNER_FLG	Owner	User
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
USER_ID	User ID	User
FIRST_NAME	First Name	User
LAST_NAME	Last Name	User
TNDR_SOURCE_CD	Tender Source	User
DISP_PROF_CD	Display Profile Code	User
TD_ENTRY_AGE_DAYS1	Lower Age Limit for Yellow Bar	User
TD_ENTRY_AGE_DAYS2	Upper Age Limit for Yellow Bar	User
ACCESS_GRP_CD	Access Group	User
EMAILID	Email Address	User
USER_TYPE_FLG	User Type	User
DISP_ALL_PREM_SW	Display All Premises	User
OWNER_FLG	Owner	User
EXT_USER_ID	External User ID	User
TIME_ZONE_CD	Time Zone	User
USER_ENABLE_FLG	User Enable	User
VERSION	Version	User