B - Production Support » Agrobank Support » IBAM

BIB Registration Report
SELECT
BIB_USER.USER_ID AS BIB_USER_USER_ID,
BIB_USER.USER_ALIAS AS BIB_USER_USER_ALIAS,
BIB_USER.USER_NAME AS BIB_USER_USER_NAME,
BIB_USER.CREATION_DATE AS BIB_USER_CREATION_DATE,
BIB_COMPANY.CIF AS BIB_COMPANY_CIF
FROM
DBO.BIB_USER BIB_USER INNER JOIN DBO.BIB_COMPANY BIB_COMPANY ON BIB_USER.COMPANY_ID = BIB_COMPANY.COMPANY_ID
WHERE
$P{FROM_DATE} <= BIB_USER."CREATION_DATE"
AND BIB_USER."CREATION_DATE" < $P{TO_DATE}

BIB Dynamic Registration Report
SELECT dbo.BIB_USER_ACTIVITY.TRNX_DATE, dbo.BIB_USER_ACTIVITY.TRNX_TYPE, dbo.BIB_USER_ACTIVITY.TRNX_ID, dbo.BIB_COMPANY.HOME_BRANCH, dbo.BIB_COMPANY.COMPANY_NAME,
dbo.IB_BANK_BRANCH_ML.BRANCH_NAME, dbo.IB_CONTENT_CATEGORY_ML.CATEGORY_NAME
FROM dbo.BIB_USER_ACTIVITY INNER JOIN
dbo.BIB_USER ON dbo.BIB_USER.USER_ID = dbo.BIB_USER_ACTIVITY.USER_ID INNER JOIN
dbo.BIB_COMPANY ON dbo.BIB_USER.COMPANY_ID = dbo.BIB_COMPANY.COMPANY_ID LEFT OUTER JOIN
dbo.IB_BANK_BRANCH ON dbo.IB_BANK_BRANCH.BRANCH_CODE = dbo.BIB_COMPANY.HOME_BRANCH LEFT OUTER JOIN
dbo.IB_BANK_BRANCH_ML ON dbo.IB_BANK_BRANCH_ML.BRANCH_ID = dbo.IB_BANK_BRANCH.OID LEFT OUTER JOIN
dbo.IB_CONTENT_CATEGORY ON dbo.IB_BANK_BRANCH.CONTENT_CATEGORY_ID = dbo.IB_CONTENT_CATEGORY.OID LEFT OUTER JOIN
dbo.IB_CONTENT_CATEGORY_ML ON dbo.IB_CONTENT_CATEGORY.PARENT_ID = dbo.IB_CONTENT_CATEGORY_ML.CONTENT_CATEGORY_ID
WHERE (dbo.BIB_USER_ACTIVITY.TRNX_TYPE = 'Create New BIB user') AND (dbo.IB_BANK_BRANCH_ML.LOCALE = N'en' OR
dbo.IB_BANK_BRANCH_ML.LOCALE IS NULL) AND (dbo.IB_CONTENT_CATEGORY_ML.LOCALE = N'en' OR
dbo.IB_CONTENT_CATEGORY_ML.LOCALE IS NULL) AND (dbo.BIB_USER_ACTIVITY.STATUS = 'Successful')

RIB Registration Report
SELECT
IB_USER."USER_ALIAS" AS IB_USER_USER_ALIAS,
IB_CUST_PROFILE."USER_NAME" AS IB_CUST_PROFILE_USER_NAME,
IB_CUST_PROFILE."USER_ACCESS_NO" AS IB_CUST_PROFILE_USER_ACCESS_NO,
IB_USER."CREATION_DATE" AS IB_USER_CREATION_DATE,
IB_CUST_PROFILE."CREATION_DATE" AS IB_CUST_PROFILE_CREATION_DATE,
IB_CUST_PROFILE."USER_EMAIL" AS IB_CUST_PROFILE_USER_EMAIL,
IB_CUST_PROFILE."USER_TYPE" AS IB_CUST_PROFILE_USER_TYPE,
IB_CUST_PROFILE."USER_POSTCODE" AS IB_CUST_PROFILE_USER_POSTCODE,
IB_USER."USER_ID" AS IB_USER_USER_ID,
IB_CUST_PROFILE."USER_ID" AS IB_CUST_PROFILE_USER_ID
FROM
"dbo"."IB_USER" IB_USER INNER JOIN "dbo"."IB_CUST_PROFILE" IB_CUST_PROFILE ON IB_USER."USER_ID" = IB_CUST_PROFILE."USER_ID"
WHERE
$P{FROM_DATE} <= IB_USER."CREATION_DATE"
AND IB_USER."CREATION_DATE" < $P{TO_DATE}
ORDER BY
IB_USER."CREATION_DATE" DESC

RIB Dynamic Registration Report
SELECT dbo.IB_CUST_PROFILE.USER_GENDER, dbo.IB_CUST_PROFILE.USER_AGE_RANGE, dbo.IB_CUST_PROFILE.BRANCH_NO, dbo.IB_CUST_PROFILE.STAFF_ID_NO, dbo.IB_CUST_PROFILE.USER_ID,
dbo.IB_CUST_PROFILE.STAFF_FLAG, dbo.IB_USER_ACTIVITY.TRNX_DATE, dbo.IB_CUST_PROFILE.USER_NAME, dbo.IB_BANK_BRANCH.BRANCH_CODE, dbo.IB_CONTENT_CATEGORY_ML.CATEGORY_NAME,
dbo.IB_CONTENT_CATEGORY_ML.LOCALE, dbo.IB_BANK_BRANCH_ML.BRANCH_NAME
FROM dbo.IB_USER_ACTIVITY INNER JOIN
dbo.IB_CUST_PROFILE ON dbo.IB_USER_ACTIVITY.USER_ID = dbo.IB_CUST_PROFILE.USER_ID INNER JOIN
dbo.IB_USER ON dbo.IB_USER.USER_ID = dbo.IB_USER_ACTIVITY.USER_ID LEFT OUTER JOIN
dbo.IB_BANK_BRANCH ON dbo.IB_CUST_PROFILE.BRANCH_NO = dbo.IB_BANK_BRANCH.BRANCH_CODE LEFT OUTER JOIN
dbo.IB_BANK_BRANCH_ML ON dbo.IB_BANK_BRANCH.OID = dbo.IB_BANK_BRANCH_ML.BRANCH_ID LEFT OUTER JOIN
dbo.IB_CONTENT_CATEGORY ON dbo.IB_BANK_BRANCH.CONTENT_CATEGORY_ID = dbo.IB_CONTENT_CATEGORY.OID LEFT OUTER JOIN
dbo.IB_CONTENT_CATEGORY_ML ON dbo.IB_CONTENT_CATEGORY.PARENT_ID = dbo.IB_CONTENT_CATEGORY_ML.CONTENT_CATEGORY_ID
WHERE (dbo.IB_USER_ACTIVITY.TRNX_TYPE = 'Registration') AND (dbo.IB_BANK_BRANCH_ML.LOCALE = N'en' OR
dbo.IB_BANK_BRANCH_ML.LOCALE IS NULL) AND (dbo.IB_CONTENT_CATEGORY_ML.LOCALE = N'en' OR
dbo.IB_CONTENT_CATEGORY_ML.LOCALE IS NULL) AND (dbo.IB_USER_ACTIVITY.STATUS = 'Successful')