CRA_SUNLOANS_SECURED
Description
Synonyms
SDSNZP02_BANK..BNKNIC_CRA_SUNLOANS_SECURED
SDSNZP02_BANK..EFS_CRA_SUNLOANS_SECURED
SDSNZP02_BANK..NROD_CRA_SUNLOANS_SECURED
SDSNZP02_BANK..UBAR_CRA_SUNLOANS_SECURED
SDSNZP05_BANK..CBP_CRA_SUNLOANS_SECURED
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CRA_SLN_SECURED_ID | BIGINT | 8 |
| 2 | ACCOUNT | BIGINT | 8 |
| 3 | ADDLOANFLAG | CHARACTER VARYING(2) | 2 |
| 4 | AGEOFAPPLICANT1 | BIGINT | 8 |
| 5 | AGGLVR | NUMERIC(15,2) | 19 |
| 6 | APPLICATIONDATE | CHARACTER VARYING(30) | 30 |
| 7 | ARRANGEMENTNUM | CHARACTER VARYING(20) | 20 |
| 8 | ASSETSTOLIABILITIESRATIOALL | NUMERIC(15,2) | 19 |
| 9 | CURRENTCALLTYPE | BIGINT | 8 |
| 10 | FACILITYNUM | BIGINT | 8 |
| 11 | FINALDECISION | CHARACTER VARYING(2) | 2 |
| 12 | FINALDECISION_ORIGDECREASONCODE1 | CHARACTER VARYING(20) | 20 |
| 13 | FINALDECISION_POLICYREASONCODE1 | CHARACTER VARYING(20) | 20 |
| 14 | FINALDECISION_POLICYREASONCODE10 | CHARACTER VARYING(20) | 20 |
| 15 | FINALDECISION_POLICYREASONCODE11 | CHARACTER VARYING(20) | 20 |
| 16 | FINALDECISION_POLICYREASONCODE12 | CHARACTER VARYING(20) | 20 |
| 17 | FINALDECISION_POLICYREASONCODE13 | CHARACTER VARYING(20) | 20 |
| 18 | FINALDECISION_POLICYREASONCODE14 | CHARACTER VARYING(20) | 20 |
| 19 | FINALDECISION_POLICYREASONCODE15 | CHARACTER VARYING(20) | 20 |
| 20 | FINALDECISION_POLICYREASONCODE16 | CHARACTER VARYING(20) | 20 |
| 21 | FINALDECISION_POLICYREASONCODE17 | CHARACTER VARYING(20) | 20 |
| 22 | FINALDECISION_POLICYREASONCODE18 | CHARACTER VARYING(20) | 20 |
| 23 | FINALDECISION_POLICYREASONCODE19 | CHARACTER VARYING(20) | 20 |
| 24 | FINALDECISION_POLICYREASONCODE2 | CHARACTER VARYING(20) | 20 |
| 25 | FINALDECISION_POLICYREASONCODE20 | CHARACTER VARYING(20) | 20 |
| 26 | FINALDECISION_POLICYREASONCODE3 | CHARACTER VARYING(20) | 20 |
| 27 | FINALDECISION_POLICYREASONCODE4 | CHARACTER VARYING(20) | 20 |
| 28 | FINALDECISION_POLICYREASONCODE5 | CHARACTER VARYING(20) | 20 |
| 29 | FINALDECISION_POLICYREASONCODE6 | CHARACTER VARYING(20) | 20 |
| 30 | FINALDECISION_POLICYREASONCODE7 | CHARACTER VARYING(20) | 20 |
| 31 | FINALDECISION_POLICYREASONCODE8 | CHARACTER VARYING(20) | 20 |
| 32 | FINALDECISION_POLICYREASONCODE9 | CHARACTER VARYING(20) | 20 |
| 33 | FULLDECISION_FINALREASONCODE1 | CHARACTER VARYING(20) | 20 |
| 34 | FULLDECISION_FINALREASONCODE10 | CHARACTER VARYING(20) | 20 |
| 35 | FULLDECISION_FINALREASONCODE11 | CHARACTER VARYING(20) | 20 |
| 36 | FULLDECISION_FINALREASONCODE12 | CHARACTER VARYING(20) | 20 |
| 37 | FULLDECISION_FINALREASONCODE13 | CHARACTER VARYING(20) | 20 |
| 38 | FULLDECISION_FINALREASONCODE14 | CHARACTER VARYING(20) | 20 |
| 39 | FULLDECISION_FINALREASONCODE15 | CHARACTER VARYING(20) | 20 |
| 40 | FULLDECISION_FINALREASONCODE16 | CHARACTER VARYING(20) | 20 |
| 41 | FULLDECISION_FINALREASONCODE17 | CHARACTER VARYING(20) | 20 |
| 42 | FULLDECISION_FINALREASONCODE18 | CHARACTER VARYING(20) | 20 |
| 43 | FULLDECISION_FINALREASONCODE19 | CHARACTER VARYING(20) | 20 |
| 44 | FULLDECISION_FINALREASONCODE2 | CHARACTER VARYING(20) | 20 |
| 45 | FULLDECISION_FINALREASONCODE20 | CHARACTER VARYING(20) | 20 |
| 46 | FULLDECISION_FINALREASONCODE3 | CHARACTER VARYING(20) | 20 |
| 47 | FULLDECISION_FINALREASONCODE4 | CHARACTER VARYING(20) | 20 |
| 48 | FULLDECISION_FINALREASONCODE5 | CHARACTER VARYING(20) | 20 |
| 49 | FULLDECISION_FINALREASONCODE6 | CHARACTER VARYING(20) | 20 |
| 50 | FULLDECISION_FINALREASONCODE7 | CHARACTER VARYING(20) | 20 |
| 51 | FULLDECISION_FINALREASONCODE8 | CHARACTER VARYING(20) | 20 |
| 52 | FULLDECISION_FINALREASONCODE9 | CHARACTER VARYING(20) | 20 |
| 53 | FULLSCORE_APPSCORE | INTEGER | 4 |
| 54 | HOGANNUM | CHARACTER VARYING(20) | 20 |
| 55 | LOANAMTORLIMITRQSTD | NUMERIC(15,2) | 19 |
| 56 | LOANPRODUCTTYPE | CHARACTER VARYING(20) | 20 |
| 57 | LOWDOCFLAG | CHARACTER VARYING(20) | 20 |
| 58 | MTHLYPAYTSTOMTHLYINCOMEPCT | NUMERIC(15,2) | 19 |
| 59 | RISKGRADE_FINEAPPRISKGRADE_SCOR | BIGINT | 8 |
| 60 | SYSTEMDECISION | CHARACTER VARYING(2) | 2 |
| 61 | TOTNUMOFDEPENDANTS1 | BIGINT | 8 |
| 62 | TOTTIMEINEMPMTMMM1 | BIGINT | 8 |
| 63 | OCCUPATION1 | CHARACTER VARYING(20) | 20 |
| 64 | TOTREALESTATEASSETS | NUMERIC(15,2) | 19 |
| 65 | EMPLOYMENTSTATUS1 | CHARACTER VARYING(20) | 20 |
| 66 | LOANSUBPURPOSE | CHARACTER VARYING(20) | 20 |
| 67 | RESIDENTIALSTATUS1 | CHARACTER VARYING(2) | 2 |
| 68 | SECUREDORUNSECUREDFLAG | CHARACTER VARYING(2) | 2 |
| 69 | SOURCE_FLAG | CHARACTER VARYING(20) | 20 |
| 70 | BUS_SOURCE | CHARACTER VARYING(20) | 20 |
| 71 | CTR_OUTCOME | NUMERIC(15,2) | 19 |
| 72 | INTEREST_TYPE | CHARACTER VARYING(20) | 20 |
| 73 | LOAN_PURPOSE | CHARACTER VARYING(30) | 30 |
| 74 | RULE | CHARACTER VARYING(50) | 50 |
| 75 | POSTCODE | BIGINT | 8 |
| 76 | STATE | CHARACTER VARYING(10) | 10 |
| 77 | SINGLE_OR_JOINT | CHARACTER VARYING(20) | 20 |
| 78 | TDM_FLAG | CHARACTER VARYING(1) | 1 |
| 79 | LOANCLASS | CHARACTER VARYING(30) | 30 |
| 80 | GROSSINCOME | NUMERIC(15,2) | 19 |
| 81 | OVERRIDE_UID | CHARACTER VARYING(15) | 15 |
| 82 | AOLAPPL | CHARACTER VARYING(2) | 2 |
| 83 | APPLCUSTTYPE | CHARACTER VARYING(30) | 30 |
| 84 | EXISTINGCUSTOMERFLAG1 | CHARACTER VARYING(2) | 2 |
| 85 | LOANREPAYTONETMTHLYINC | NUMERIC(15,2) | 19 |
| 86 | TIMEATCURRENTADDRESSMMM1 | INTEGER | 4 |
| 87 | TIMEINCURRENTEMPMTMMM1 | INTEGER | 4 |
| 88 | OVERRIDE_DECISION | CHARACTER VARYING(1) | 1 |
| 89 | DELTA_TYPE | CHARACTER VARYING(1) | 1 |
| 90 | EFFECTIVE_STRT_DT | TIMESTAMP | 8 |
| 91 | EFFECTIVE_END_DT | TIMESTAMP | 8 |
| 92 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 93 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 94 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 95 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |