QRM_BBM_HIERARCHY_MR
Description
Synonyms
SDSNZP02_BANK..BNKNIC_QRM_BBM_HIERARCHY_MR
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | L9_UNUMBER | CHARACTER VARYING(10) | 10 |
| 2 | L8_UNUMBER | CHARACTER VARYING(10) | 10 |
| 3 | L7_UNUMBER | CHARACTER VARYING(10) | 10 |
| 4 | L6_UNUMBER | CHARACTER VARYING(10) | 10 |
| 5 | L5_UNUMBER | CHARACTER VARYING(10) | 10 |
| 6 | L4_UNUMBER | CHARACTER VARYING(10) | 10 |
| 7 | L3_UNUMBER | CHARACTER VARYING(10) | 10 |
| 8 | L2_UNUMBER | CHARACTER VARYING(10) | 10 |
| 9 | L1_UNUMBER | CHARACTER VARYING(10) | 10 |
| 10 | L9_BUSINESSUNIT | CHARACTER VARYING(255) | 255 |
| 11 | L8_BUSINESSUNIT | CHARACTER VARYING(255) | 255 |
| 12 | L7_BUSINESSUNIT | CHARACTER VARYING(255) | 255 |
| 13 | L6_BUSINESSUNIT | CHARACTER VARYING(255) | 255 |
| 14 | L5_BUSINESSUNIT | CHARACTER VARYING(255) | 255 |
| 15 | L4_BUSINESSUNIT | CHARACTER VARYING(255) | 255 |
| 16 | L3_BUSINESSUNIT | CHARACTER VARYING(255) | 255 |
| 17 | L2_BUSINESSUNIT | CHARACTER VARYING(255) | 255 |
| 18 | L1_BUSINESSUNIT | CHARACTER VARYING(255) | 255 |
| 19 | L9_DEPARTMENT | CHARACTER VARYING(255) | 255 |
| 20 | L8_DEPARTMENT | CHARACTER VARYING(255) | 255 |
| 21 | L7_DEPARTMENT | CHARACTER VARYING(255) | 255 |
| 22 | L6_DEPARTMENT | CHARACTER VARYING(255) | 255 |
| 23 | L5_DEPARTMENT | CHARACTER VARYING(255) | 255 |
| 24 | L4_DEPARTMENT | CHARACTER VARYING(255) | 255 |
| 25 | L3_DEPARTMENT | CHARACTER VARYING(255) | 255 |
| 26 | L2_DEPARTMENT | CHARACTER VARYING(255) | 255 |
| 27 | L1_DEPARTMENT | CHARACTER VARYING(255) | 255 |
| 28 | L9_DIVISION | CHARACTER VARYING(255) | 255 |
| 29 | L8_DIVISION | CHARACTER VARYING(255) | 255 |
| 30 | L7_DIVISION | CHARACTER VARYING(255) | 255 |
| 31 | L6_DIVISION | CHARACTER VARYING(255) | 255 |
| 32 | L5_DIVISION | CHARACTER VARYING(255) | 255 |
| 33 | L4_DIVISION | CHARACTER VARYING(255) | 255 |
| 34 | L3_DIVISION | CHARACTER VARYING(255) | 255 |
| 35 | L2_DIVISION | CHARACTER VARYING(255) | 255 |
| 36 | L1_DIVISION | CHARACTER VARYING(255) | 255 |
| 37 | L9_LOCATION | CHARACTER VARYING(255) | 255 |
| 38 | L8_LOCATION | CHARACTER VARYING(255) | 255 |
| 39 | L7_LOCATION | CHARACTER VARYING(255) | 255 |
| 40 | L6_LOCATION | CHARACTER VARYING(255) | 255 |
| 41 | L5_LOCATION | CHARACTER VARYING(255) | 255 |
| 42 | L4_LOCATION | CHARACTER VARYING(255) | 255 |
| 43 | L3_LOCATION | CHARACTER VARYING(255) | 255 |
| 44 | L2_LOCATION | CHARACTER VARYING(255) | 255 |
| 45 | L1_LOCATION | CHARACTER VARYING(255) | 255 |
| 46 | L9_POSITIONTITLE | CHARACTER VARYING(255) | 255 |
| 47 | L8_POSITIONTITLE | CHARACTER VARYING(255) | 255 |
| 48 | L7_POSITIONTITLE | CHARACTER VARYING(255) | 255 |
| 49 | L6_POSITIONTITLE | CHARACTER VARYING(255) | 255 |
| 50 | L5_POSITIONTITLE | CHARACTER VARYING(255) | 255 |
| 51 | L4_POSITIONTITLE | CHARACTER VARYING(255) | 255 |
| 52 | L3_POSITIONTITLE | CHARACTER VARYING(255) | 255 |
| 53 | L2_POSITIONTITLE | CHARACTER VARYING(255) | 255 |
| 54 | L1_POSITIONTITLE | CHARACTER VARYING(255) | 255 |
| 55 | L9_FIRSTNAME | CHARACTER VARYING(255) | 255 |
| 56 | L8_FIRSTNAME | CHARACTER VARYING(255) | 255 |
| 57 | L7_FIRSTNAME | CHARACTER VARYING(255) | 255 |
| 58 | L6_FIRSTNAME | CHARACTER VARYING(255) | 255 |
| 59 | L5_FIRSTNAME | CHARACTER VARYING(255) | 255 |
| 60 | L4_FIRSTNAME | CHARACTER VARYING(255) | 255 |
| 61 | L3_FIRSTNAME | CHARACTER VARYING(255) | 255 |
| 62 | L2_FIRSTNAME | CHARACTER VARYING(255) | 255 |
| 63 | L1_FIRSTNAME | CHARACTER VARYING(255) | 255 |
| 64 | L9_SURNAME | CHARACTER VARYING(255) | 255 |
| 65 | L8_SURNAME | CHARACTER VARYING(255) | 255 |
| 66 | L7_SURNAME | CHARACTER VARYING(255) | 255 |
| 67 | L6_SURNAME | CHARACTER VARYING(255) | 255 |
| 68 | L5_SURNAME | CHARACTER VARYING(255) | 255 |
| 69 | L4_SURNAME | CHARACTER VARYING(255) | 255 |
| 70 | L3_SURNAME | CHARACTER VARYING(255) | 255 |
| 71 | L2_SURNAME | CHARACTER VARYING(255) | 255 |
| 72 | L1_SURNAME | CHARACTER VARYING(255) | 255 |
| 73 | L9_PREFERREDNAME | CHARACTER VARYING(255) | 255 |
| 74 | L8_PREFERREDNAME | CHARACTER VARYING(255) | 255 |
| 75 | L7_PREFERREDNAME | CHARACTER VARYING(255) | 255 |
| 76 | L6_PREFERREDNAME | CHARACTER VARYING(255) | 255 |
| 77 | L5_PREFERREDNAME | CHARACTER VARYING(255) | 255 |
| 78 | L4_PREFERREDNAME | CHARACTER VARYING(255) | 255 |
| 79 | L3_PREFERREDNAME | CHARACTER VARYING(255) | 255 |
| 80 | L2_PREFERREDNAME | CHARACTER VARYING(255) | 255 |
| 81 | L1_PREFERREDNAME | CHARACTER VARYING(255) | 255 |
| 82 | L9_TERMINATEDFLAG | CHARACTER VARYING(1) | 1 |
| 83 | L8_TERMINATEDFLAG | CHARACTER VARYING(1) | 1 |
| 84 | L7_TERMINATEDFLAG | CHARACTER VARYING(1) | 1 |
| 85 | L6_TERMINATEDFLAG | CHARACTER VARYING(1) | 1 |
| 86 | L5_TERMINATEDFLAG | CHARACTER VARYING(1) | 1 |
| 87 | L4_TERMINATEDFLAG | CHARACTER VARYING(1) | 1 |
| 88 | L3_TERMINATEDFLAG | CHARACTER VARYING(1) | 1 |
| 89 | L2_TERMINATEDFLAG | CHARACTER VARYING(1) | 1 |
| 90 | L1_TERMINATEDFLAG | CHARACTER VARYING(1) | 1 |
| 91 | L9_SECTION | CHARACTER VARYING(255) | 255 |
| 92 | L8_SECTION | CHARACTER VARYING(255) | 255 |
| 93 | L7_SECTION | CHARACTER VARYING(255) | 255 |
| 94 | L6_SECTION | CHARACTER VARYING(255) | 255 |
| 95 | L5_SECTION | CHARACTER VARYING(255) | 255 |
| 96 | L4_SECTION | CHARACTER VARYING(255) | 255 |
| 97 | L3_SECTION | CHARACTER VARYING(255) | 255 |
| 98 | L2_SECTION | CHARACTER VARYING(255) | 255 |
| 99 | L1_SECTION | CHARACTER VARYING(255) | 255 |
| 100 | L9_SUBSECTION | CHARACTER VARYING(255) | 255 |
| 101 | L8_SUBSECTION | CHARACTER VARYING(255) | 255 |
| 102 | L7_SUBSECTION | CHARACTER VARYING(255) | 255 |
| 103 | L6_SUBSECTION | CHARACTER VARYING(255) | 255 |
| 104 | L5_SUBSECTION | CHARACTER VARYING(255) | 255 |
| 105 | L4_SUBSECTION | CHARACTER VARYING(255) | 255 |
| 106 | L3_SUBSECTION | CHARACTER VARYING(255) | 255 |
| 107 | L2_SUBSECTION | CHARACTER VARYING(255) | 255 |
| 108 | L1_SUBSECTION | CHARACTER VARYING(255) | 255 |
| 109 | L9_TEAM | CHARACTER VARYING(255) | 255 |
| 110 | L8_TEAM | CHARACTER VARYING(255) | 255 |
| 111 | L7_TEAM | CHARACTER VARYING(255) | 255 |
| 112 | L6_TEAM | CHARACTER VARYING(255) | 255 |
| 113 | L5_TEAM | CHARACTER VARYING(255) | 255 |
| 114 | L4_TEAM | CHARACTER VARYING(255) | 255 |
| 115 | L3_TEAM | CHARACTER VARYING(255) | 255 |
| 116 | L2_TEAM | CHARACTER VARYING(255) | 255 |
| 117 | L1_TEAM | CHARACTER VARYING(255) | 255 |
| 118 | L9_COSTCENTRE | CHARACTER VARYING(4) | 4 |
| 119 | L8_COSTCENTRE | CHARACTER VARYING(4) | 4 |
| 120 | L7_COSTCENTRE | CHARACTER VARYING(4) | 4 |
| 121 | L6_COSTCENTRE | CHARACTER VARYING(4) | 4 |
| 122 | L5_COSTCENTRE | CHARACTER VARYING(4) | 4 |
| 123 | L4_COSTCENTRE | CHARACTER VARYING(4) | 4 |
| 124 | L3_COSTCENTRE | CHARACTER VARYING(4) | 4 |
| 125 | L2_COSTCENTRE | CHARACTER VARYING(4) | 4 |
| 126 | L1_COSTCENTRE | CHARACTER VARYING(4) | 4 |
| 127 | CHARACTER VARYING(255) | 255 | |
| 128 | BDMCODE | NUMERIC(6,0) | 19 |
| 129 | TITLE | CHARACTER VARYING(6) | 6 |
| 130 | BDMCODE_TEXT | CHARACTER VARYING(10) | 10 |
| 131 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 132 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 133 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 134 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |