CV19_CAMPAIGN_EXCLUSIONS
Description
Synonyms
SDSNZP05_BANK..CBP_CV19_CAMPAIGN_EXCLUSIONS
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | GCIS_ID | CHARACTER VARYING(9) | 9 |
| 2 | OCH_ID | CHARACTER VARYING(60) | 60 |
| 3 | FULL_NAME | CHARACTER VARYING(250) | 250 |
| 4 | NUM_LOANS | INTEGER | 4 |
| 5 | LOAN_1 | CHARACTER VARYING(40) | 40 |
| 6 | LOAN_2 | CHARACTER VARYING(40) | 40 |
| 7 | LOAN_3 | CHARACTER VARYING(40) | 40 |
| 8 | LOAN_4 | CHARACTER VARYING(40) | 40 |
| 9 | LOAN_5 | CHARACTER VARYING(40) | 40 |
| 10 | LOAN_6 | CHARACTER VARYING(40) | 40 |
| 11 | LOAN_7 | CHARACTER VARYING(40) | 40 |
| 12 | LOAN_8 | CHARACTER VARYING(40) | 40 |
| 13 | LOAN_9 | CHARACTER VARYING(40) | 40 |
| 14 | LOAN_10 | CHARACTER VARYING(40) | 40 |
| 15 | CASE_ID_1 | CHARACTER VARYING(10) | 10 |
| 16 | CASE_ID_2 | CHARACTER VARYING(10) | 10 |
| 17 | CASE_ID_3 | CHARACTER VARYING(10) | 10 |
| 18 | CASE_ID_4 | CHARACTER VARYING(10) | 10 |
| 19 | CASE_ID_5 | CHARACTER VARYING(10) | 10 |
| 20 | CASE_ID_6 | CHARACTER VARYING(10) | 10 |
| 21 | CASE_ID_7 | CHARACTER VARYING(10) | 10 |
| 22 | CASE_ID_8 | CHARACTER VARYING(10) | 10 |
| 23 | CASE_ID_9 | CHARACTER VARYING(10) | 10 |
| 24 | CASE_ID_10 | CHARACTER VARYING(10) | 10 |
| 25 | NUMBER_OF_LOANS | INTEGER | 4 |
| 26 | JOBSEEKER_JOBKEEPER_FLAG | CHARACTER VARYING(1) | 1 |
| 27 | INCOME_30PER_FLAG | CHARACTER VARYING(1) | 1 |
| 28 | GT_5_LOANS | CHARACTER VARYING(1) | 1 |
| 29 | NO_GCIS_ID | CHARACTER VARYING(1) | 1 |
| 30 | NO_OCID | CHARACTER VARYING(1) | 1 |
| 31 | INVALID_MOBILE_NO | CHARACTER VARYING(1) | 1 |
| 32 | NO_EMAIL_ADDR | CHARACTER VARYING(1) | 1 |
| 33 | BUSINESS_OR_TRUST_FLAG | CHARACTER VARYING(1) | 1 |
| 34 | DPD_OVER_90DAYS | CHARACTER VARYING(1) | 1 |
| 35 | SMALL_BUS_CONNECTION | CHARACTER VARYING(1) | 1 |
| 36 | PREVIOUSLY_CONTACTED | CHARACTER VARYING(1) | 1 |
| 37 | RUN_DATE | CHARACTER VARYING(10) | 10 |
| 38 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 39 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 40 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 41 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |