| 1 |
CUSTOMER_ID |
CHARACTER VARYING(70) |
70 |
| 2 |
FURTHER_ASSISTANCE_REQUIRED |
CHARACTER VARYING(100) |
100 |
| 3 |
ASSISTANCE_PREFERRED |
CHARACTER VARYING(100) |
100 |
| 4 |
PAYG_EMPLOYEE |
CHARACTER VARYING(5) |
5 |
| 5 |
MAIN_SOURCE_OF_INCOME |
CHARACTER VARYING(100) |
100 |
| 6 |
PAYG_NORMALCY_PERIOD |
CHARACTER VARYING(100) |
100 |
| 7 |
PAYG_COVID19_IMPACT |
CHARACTER VARYING(100) |
100 |
| 8 |
HOUSEHOLD_ADULTS |
CHARACTER VARYING(100) |
100 |
| 9 |
HOUSEHOLD_CHILDREN |
CHARACTER VARYING(100) |
100 |
| 10 |
PERS_ASSET_OWNOCCPROP |
CHARACTER VARYING(20) |
20 |
| 11 |
PERS_ASSET_INVESTPROP |
CHARACTER VARYING(20) |
20 |
| 12 |
PERS_ASSET_VEHPLNTMACH |
CHARACTER VARYING(20) |
20 |
| 13 |
PERS_ASSET_CASHBANKACCTS |
CHARACTER VARYING(20) |
20 |
| 14 |
PERS_ASSET_INVSTMTSSHARES |
CHARACTER VARYING(20) |
20 |
| 15 |
PERS_ASSET_INCPROTNLIFEINS |
CHARACTER VARYING(20) |
20 |
| 16 |
PERS_ASSET_SUPER |
CHARACTER VARYING(20) |
20 |
| 17 |
PERS_ASSET_FURNPERSEFFECTS |
CHARACTER VARYING(20) |
20 |
| 18 |
PERS_ASSET_OTHER |
CHARACTER VARYING(20) |
20 |
| 19 |
PERS_LIAB_SUNHOMELOANS |
CHARACTER VARYING(20) |
20 |
| 20 |
PERS_LIAB_SUNINVSTMTLOANS |
CHARACTER VARYING(20) |
20 |
| 21 |
PERS_LIAB_OTHHOMELOANS |
CHARACTER VARYING(20) |
20 |
| 22 |
PERS_LIAB_BUSLOANS |
CHARACTER VARYING(20) |
20 |
| 23 |
PERS_LIAB_UNSECPERSLOANSLEASES |
CHARACTER VARYING(20) |
20 |
| 24 |
PERS_LIAB_CC_STORECARDS |
CHARACTER VARYING(20) |
20 |
| 25 |
PERS_LIAB_INCOMETAXDEBTS |
CHARACTER VARYING(20) |
20 |
| 26 |
PERS_LIAB_OTHER |
CHARACTER VARYING(20) |
20 |
| 27 |
PERS_INCOME_SALARYWAGES |
CHARACTER VARYING(20) |
20 |
| 28 |
PERS_INCOME_RENTAL |
CHARACTER VARYING(20) |
20 |
| 29 |
PERS_INCOME_OTHER_INVSTMT |
CHARACTER VARYING(20) |
20 |
| 30 |
PERS_INCOME_GOV |
CHARACTER VARYING(20) |
20 |
| 31 |
PERS_EXP_HOMELOAN |
CHARACTER VARYING(20) |
20 |
| 32 |
PERS_EXP_BUSINESSLOAN |
CHARACTER VARYING(20) |
20 |
| 33 |
PERS_EXP_UNSECUREDPERSONALLEASES |
CHARACTER VARYING(20) |
20 |
| 34 |
PERS_EXP_CC_STORECARD |
CHARACTER VARYING(20) |
20 |
| 35 |
PERS_EXP_PAYLATER |
CHARACTER VARYING(20) |
20 |
| 36 |
PERS_EXP_OTHERDEBTS |
CHARACTER VARYING(20) |
20 |
| 37 |
PERS_EXP_RENT |
CHARACTER VARYING(20) |
20 |
| 38 |
PERS_EXP_INSURANCE |
CHARACTER VARYING(20) |
20 |
| 39 |
PERS_EXP_SCHOOL_CHILDCARE |
CHARACTER VARYING(20) |
20 |
| 40 |
PERS_EXP_ELECTRICITY |
CHARACTER VARYING(20) |
20 |
| 41 |
PERS_EXP_GAS |
CHARACTER VARYING(20) |
20 |
| 42 |
PERS_EXP_TELEPHONE_INTERNET |
CHARACTER VARYING(20) |
20 |
| 43 |
PERS_EXP_MEDICAL |
CHARACTER VARYING(20) |
20 |
| 44 |
PERS_EXP_RATES |
CHARACTER VARYING(20) |
20 |
| 45 |
PERS_EXP_CARTRAVEL |
CHARACTER VARYING(20) |
20 |
| 46 |
PERS_EXP_FOOD |
CHARACTER VARYING(20) |
20 |
| 47 |
PERS_EXP_CLOTHING |
CHARACTER VARYING(20) |
20 |
| 48 |
PERS_EXP_ENTERTAINMENT |
CHARACTER VARYING(20) |
20 |
| 49 |
PERS_EXP_PETS |
CHARACTER VARYING(20) |
20 |
| 50 |
PERS_EXP_OTHER |
CHARACTER VARYING(20) |
20 |
| 51 |
BUSINESS_INCOME |
CHARACTER VARYING(10) |
10 |
| 52 |
BUS_REDUCTION |
CHARACTER VARYING(20) |
20 |
| 53 |
BUS_RECOVER |
CHARACTER VARYING(5) |
5 |
| 54 |
BUS_NORMALCY_PERIOD |
CHARACTER VARYING(100) |
100 |
| 55 |
BUS_COVID19_IMPACT |
CHARACTER VARYING(250) |
250 |
| 56 |
BUS_COVID19_ASSISTANCE |
CHARACTER VARYING(10) |
10 |
| 57 |
BUS_ASSET_CASHBANKACCTS |
CHARACTER VARYING(20) |
20 |
| 58 |
BUS_ASSET_INVENTORY |
CHARACTER VARYING(20) |
20 |
| 59 |
BUS_ASSET_PREPAIDEXP |
CHARACTER VARYING(20) |
20 |
| 60 |
BUS_ASSET_CURRENTOTHER |
CHARACTER VARYING(20) |
20 |
| 61 |
BUS_ASSET_LEASEHOLDS |
CHARACTER VARYING(20) |
20 |
| 62 |
BUS_ASSET_PROPLAND |
CHARACTER VARYING(20) |
20 |
| 63 |
BUS_ASSET_FURNEQUIPTOOLS |
CHARACTER VARYING(20) |
20 |
| 64 |
BUS_ASSET_VEHS |
CHARACTER VARYING(20) |
20 |
| 65 |
BUS_ASSET_FIXEDOTHER |
CHARACTER VARYING(20) |
20 |
| 66 |
BUS_LIAB_CCPAYABLE |
CHARACTER VARYING(20) |
20 |
| 67 |
BUS_LIAB_ACCNTSPAYABLE |
CHARACTER VARYING(20) |
20 |
| 68 |
BUS_LIAB_BUSLOANS |
CHARACTER VARYING(20) |
20 |
| 69 |
BUS_LIAB_ACCRUEDWAGES |
CHARACTER VARYING(20) |
20 |
| 70 |
BUS_LIAB_INCOMETAX |
CHARACTER VARYING(20) |
20 |
| 71 |
BUS_LIAB_OTHER |
CHARACTER VARYING(20) |
20 |
| 72 |
BUS_INCOME_TOTALREV |
CHARACTER VARYING(20) |
20 |
| 73 |
BUS_INCOME_GOVASSIST |
CHARACTER VARYING(20) |
20 |
| 74 |
BUS_INCOME_COSTOFGOODS |
CHARACTER VARYING(20) |
20 |
| 75 |
BUS_INCOME_OTHER |
CHARACTER VARYING(20) |
20 |
| 76 |
BUS_EXP_ACCTINGLEGAL |
CHARACTER VARYING(20) |
20 |
| 77 |
BUS_EXP_ADVERTISING |
CHARACTER VARYING(20) |
20 |
| 78 |
BUS_EXP_DEPRECIATION |
CHARACTER VARYING(20) |
20 |
| 79 |
BUS_EXP_ELECTRICITY |
CHARACTER VARYING(20) |
20 |
| 80 |
BUS_EXP_INSURANCE |
CHARACTER VARYING(20) |
20 |
| 81 |
BUS_EXP_RENT |
CHARACTER VARYING(20) |
20 |
| 82 |
BUS_EXP_REPAIRSMAINTCE |
CHARACTER VARYING(20) |
20 |
| 83 |
BUS_EXPENSES_TRAINING |
CHARACTER VARYING(20) |
20 |
| 84 |
BUS_EXP_WAGESSALARIES |
CHARACTER VARYING(20) |
20 |
| 85 |
BUS_EXP_OTHER |
CHARACTER VARYING(20) |
20 |
| 86 |
BUS_IMPACT_PL |
CHARACTER VARYING(250) |
250 |
| 87 |
INDUSTRY |
CHARACTER VARYING(100) |
100 |
| 88 |
OTHER_INFORMATION |
CHARACTER VARYING(5000) |
5000 |
| 89 |
DATA_DATE |
TIMESTAMP |
8 |
| 90 |
LOAD_ID |
INTEGER |
4 |
| 91 |
CDC_SOURCE_SYSTEM_CODE |
CHARACTER VARYING(4) |
4 |
| 92 |
CDC_RECORD_TYPE |
CHARACTER VARYING(16) |
16 |
| 93 |
CDC_COMMIT_TIMESTAMP |
TIMESTAMP |
8 |
| 94 |
CDC_EXTRACT_TIMESTAMP |
TIMESTAMP |
8 |