as516_clms_arlhead

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 id bigint 64
2 action_code character varying 3
3 accountno integer 32
4 status integer 32
5 stdate character varying 30
6 borcode integer 32
7 desc character varying 105
8 product integer 32
9 strtdate timestamp without time zone
10 term integer 32
11 expdate timestamp without time zone
12 coy integer 32
13 branch integer 32
14 mlim integer 32
15 lcat character varying 9
16 lpurp integer 32
17 source integer 32
18 bdmcode integer 32
19 rtype character varying 30
20 primloan integer 32
21 novated character varying 3
22 capityp integer 32
23 purclass integer 32
24 discount numeric 12
25 premium numeric 12
26 expenses numeric 12
27 nogtees integer 32
28 gtcom character varying 90
29 gtinc character varying 3
30 gwaivcde integer 32
31 nosecs integer 32
32 osecs character varying 3
33 seccoms1 character varying 180
34 seccoms2 character varying 180
35 aplicno integer 32
36 appdte timestamp without time zone
37 aprdate timestamp without time zone
38 lead character varying 33
39 cl1date timestamp without time zone
40 clrcode integer 32
41 rrevdte character varying 30
42 rrevcom character varying 90
43 anzsic integer 32
44 underw integer 32
45 mlimcls integer 32
46 watchlist character varying 3
47 rewrite integer 32
48 rewritten integer 32
49 rwcqr character varying 6
50 rwsr character varying 3
51 rwcrc character varying 3
52 crgsdte timestamp without time zone
53 pdlcondte timestamp without time zone
54 tcrates character varying 15
55 lastbab integer 32
56 facrate character varying 15
57 userate character varying 15
58 rollfee character varying 3
59 payoutdate timestamp without time zone
60 lstrtrvwdte timestamp without time zone
61 avgmnthlybal numeric 19
62 oloan integer 32
63 nloan integer 32
64 cl2date timestamp without time zone
65 rpmqno integer 32
66 crgsssv numeric 19
67 facident integer 32
68 facclassn integer 32
69 anclass integer 32
70 fb1class integer 32
71 scorecard integer 32
72 questn19 integer 32
73 questn20 integer 32
74 questn21 integer 32
75 questn22 integer 32
76 totalscore character varying 81
77 totoverall character varying 6
78 orflag integer 32
79 orreason character varying 180
80 orsource character varying 180
81 calcscore character varying 6
82 actlscore character varying 81
83 hstcadsc character varying 300
84 hstcacdrldr character varying 30
85 questn24raw character varying 1500
86 questn25raw character varying 1500
87 questn26raw character varying 1500
88 questn27raw character varying 1500
89 questn28raw character varying 1500
90 devpc integer 32
91 delta_type character varying 3
92 effective_strt_dt timestamp without time zone
93 effective_end_dt timestamp without time zone