FCT_HMMS_NROD_ACCOUNT_TYPE2

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_HMMS_NROD_ACCOUNT_TYPE2_V

Columns
# Name Data Type Length
1 ACCOUNT_SOURCE_UNIQUE_ID CHARACTER VARYING(27) 27
2 ACCOUNT_SOURCE_REF_ID CHARACTER VARYING(23) 23
3 CUSTOMER_SOURCE_UNIQUE_ID CHARACTER VARYING(9) 9
4 ACCOUNT_NAME CHARACTER(25) 25
5 DATE_OPENED CHARACTER VARYING(200) 200
6 DATE_CLOSED CHARACTER VARYING(200) 200
7 CUSTOMER_ROLE CHARACTER VARYING(3) 3
8 ROLE_DESC NATIONAL CHARACTER VARYING(20) 20
9 ACCOUNT_STATUS_CODE CHARACTER VARYING(13) 13
10 CREDIT_DEBIT_CODE CHARACTER VARYING(1) 1
11 CURRENCY_CODE CHARACTER VARYING(3) 3
12 ACCOUNT_BALANCE INTEGER 4
13 OVERDRAFT_LIMIT INTEGER 4
14 PERIODIC_LOAN_AMOUNT CHARACTER VARYING(1) 1
15 LIFE_INS_CONTRACT_DURATION CHARACTER VARYING(1) 1
16 BRANCH_ID CHARACTER VARYING(3) 3
17 RELATIONSHIP_MGR_ID CHARACTER VARYING(3) 3
18 IBAN CHARACTER VARYING(1) 1
19 BIC CHARACTER VARYING(1) 1
20 FROZEN_OVERRIDE_DATE CHARACTER VARYING(1) 1
21 PRODUCT_SOURCE_TYPE_CODE CHARACTER VARYING(5) 5
22 CREDIT_LIMIT CHARACTER VARYING(1) 1
23 RISK_SCORE CHARACTER VARYING(1) 1
24 ACCOUNT_SEGMENT NATIONAL CHARACTER VARYING(250) 250
25 DORMANT_STATUS_FLAG CHARACTER VARYING(1) 1
26 FROZEN_STATUS_FLAG CHARACTER VARYING(1) 1
27 CREDIT_GRADE CHARACTER VARYING(1) 1
28 REF_DEBT_COL_FLAG CHARACTER VARYING(1) 1
29 BALANCE_DATE CHARACTER VARYING(1) 1
30 COMMENTS CHARACTER VARYING(1) 1
31 ORG_UNIT_CODE CHARACTER VARYING(7) 7
32 ISSUE_DATE CHARACTER VARYING(1) 1
33 PAYMENT_FREQ CHARACTER VARYING(1) 1
34 INST_PREMIUM_AMT CHARACTER VARYING(1) 1
35 ANN_PREMIUM_AMT CHARACTER VARYING(1) 1
36 SINGLE_PREMIUM_TOTAL CHARACTER VARYING(1) 1
37 SUM_INSURED CHARACTER VARYING(1) 1
38 PAYMENT_METHOD CHARACTER VARYING(1) 1
39 BENEFICIARY_FLAG CHARACTER VARYING(1) 1
40 GROSS_PREM_TTD CHARACTER VARYING(1) 1
41 CASH_SURR_VALUE CHARACTER VARYING(1) 1
42 DEATH_BENEFIT_AMT CHARACTER VARYING(1) 1
43 CUSTOMER_INITIATED_CLOSURE CHARACTER VARYING(1) 1
44 DELAYED_ACCOUNT_FLAG CHARACTER VARYING(1) 1
45 LANGUAGE_PREF_CODE CHARACTER VARYING(1) 1
46 SETTLEMENT_BANK_NAME CHARACTER VARYING(1) 1
47 DELIVERY_INSTRUCTIONS CHARACTER VARYING(1) 1
48 SETTLEMENT_TYPE CHARACTER VARYING(1) 1
49 RISK_CATEGORY CHARACTER VARYING(1) 1
50 BLOCKED_TYPE CHARACTER VARYING(1) 1
51 BLOCKED_REASON CHARACTER VARYING(1) 1
52 PRIMARY_CARD_ID CHARACTER VARYING(1) 1
53 ADDRESS CHARACTER VARYING(1) 1
54 ZONE CHARACTER VARYING(1) 1
55 CITY CHARACTER VARYING(1) 1
56 POSTAL_CODE CHARACTER VARYING(1) 1
57 COUNTRY_CODE CHARACTER VARYING(1) 1
58 ADDRESS_VALID_FROM CHARACTER VARYING(1) 1
59 ADDRESS_VALID_TO CHARACTER VARYING(1) 1
60 CREDIT_TURNOVER CHARACTER VARYING(1) 1
61 DEBIT_TRUNOVER CHARACTER VARYING(1) 1
62 TURNOVER_FROM_DATE CHARACTER VARYING(1) 1
63 TURNOVER_TO_DATE CHARACTER VARYING(1) 1
64 HOLDING_BANK_NAME CHARACTER VARYING(1) 1
65 SALARY_LODGED_FLAG CHARACTER VARYING(1) 1
66 ACCOUNT_ON_HOLD_FLAG CHARACTER VARYING(1) 1
67 SENT_CORRESPONDENCE_FLAG CHARACTER VARYING(1) 1
68 ACCOUNT_PURPOSE CHARACTER VARYING(1) 1
69 PRIMARY_CUSTOMER_CATEGORY_CODE CHARACTER VARYING(1) 1
70 COLLECTED_BALANCE CHARACTER VARYING(1) 1
71 OTHER_HOLD_AMOUNT CHARACTER VARYING(1) 1
72 REPORTING_REGION CHARACTER VARYING(1) 1
73 EFFECTIVE_STRT_DT TIMESTAMP 8
74 EFFECTIVE_END_DATE TIMESTAMP 8