sln_facility_parties

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 sln_facility_parties_hiid bigint 64
2 action_code character varying 3
3 facility_id character varying 60
4 gcis_id character varying 72
5 party_type character varying 72
6 first_name character varying 96
7 last_name character varying 96
8 organisation_name character varying 240
9 anzsic_code character varying 180
10 anzsic_desc character varying 180
11 party_role_code character varying 180
12 employment_status character varying 180
13 loan_limit_type character varying 180
14 loan_limit_amount numeric 13
15 loan_limit_percentage numeric 6
16 gross_annual_income numeric 13
17 income_verification character varying 3
18 months_in_business numeric 22
19 no_credit_defaults numeric 6
20 bankruptcy_flag character varying 3
21 last_credit_discharge_date timestamp without time zone
22 credit_score_provider character varying 12
23 credit_score numeric 10
24 servicibility_metric character varying 150
25 servicibility_score numeric 1
26 bus_cash_from_ops_2yrprior numeric 13
27 bus_cash_from_ops_1yrprior numeric 13
28 bus_cash_from_ops_currentyr numeric 13
29 delta_type character varying 3
30 effective_strt_dt timestamp without time zone
31 effective_end_dt timestamp without time zone