1 |
ARCH_OBJECT_ID |
|
REBDAOID |
REBDAOID |
CHAR |
30 |
0 |
Identification of Architectural Object |
|
2 |
ARCH_OBJECT_TYPE |
|
REBDAOTYPE |
REBDAOTYPE |
CHAR |
4 |
0 |
Architectural Object Type |
TIVBDAROBJTYPE |
3 |
PART_ARCH_OBJECT_ID |
|
REBDPARTAOID |
REBDPARTAOID |
CHAR |
30 |
0 |
AOID Code |
|
4 |
ARCH_OBJECT_NUMBER |
|
REBDAONR |
REBDAONR |
CHAR |
13 |
0 |
Number of Architectural Object |
|
5 |
PARENT_ARCH_OBJECT_ID |
|
REBDPARENTAOID |
REBDAOID |
CHAR |
30 |
0 |
Identification of Superordinate Architectural Object |
|
6 |
IDENT_OBJECT_TYPE |
|
RECAIDENTTYPE |
J_OBART |
CHAR |
2 |
0 |
ID Part of Object Type, such as "IS" (Real Estate Contract) |
TBO00 |
7 |
IDENT_KEY |
|
RECAIDENTKEY |
CHAR45 |
CHAR |
45 |
0 |
ID Part Key, for example "1000/123" |
|
8 |
CREATION_USER |
|
RERF |
SYCHAR12 |
CHAR |
12 |
0 |
Entered by |
|
9 |
CREATION_DATE |
|
DERF |
DATUM |
DATS |
8 |
0 |
First Entered on |
|
10 |
CREATION_TIME |
|
TERF |
TIMES |
TIMS |
6 |
0 |
Time of Initial Entry |
|
11 |
LASTCHANGE_USER |
|
RBEAR |
SYCHAR12 |
CHAR |
12 |
0 |
Employee ID |
|
12 |
LASTCHANGE_DATE |
|
DBEAR |
DATUM |
DATS |
8 |
0 |
Last Edited on |
|
13 |
LASTCHANGE_TIME |
|
TBEAR |
TIMES |
TIMS |
6 |
0 |
Last Edited at |
|
14 |
ARCH_OBJECT_TEXT |
|
REBDXAO |
RECAXLDESCRIPTION |
CHAR |
60 |
0 |
Name of Architectural Object |
|
15 |
PART_SEPARATOR |
|
REBDPARTSEPARATOR |
REBDPARTSEPARATOR |
CHAR |
10 |
0 |
AOID Code: Separator |
|
16 |
FUNCTION |
|
REBDAOFUNCTION |
REBDAOFUNCTION |
CHAR |
4 |
0 |
Function of Architectural Object |
TIVBDARFUNC |
17 |
COMMON_USAGE_IND |
|
REBDUSCOMMON |
REBDUSCOMMON |
CHAR |
1 |
0 |
Common Usage |
|
18 |
AUTHORIZATION_GROUP |
|
RECAAUTHGRP |
RECAAUTHGRP |
CHAR |
40 |
0 |
Authorization Group |
|
19 |
MEASUREMENT_STRUCTURE |
|
REBDMEASSTRC |
REBDMEASSTRC |
CHAR |
4 |
0 |
Measurement Structure |
TIVBDMEASSTRC |
20 |
ARCH_OBJECT_SHORT_TEXT |
|
REBDDOORPLT |
REBDDOORPLT |
CHAR |
15 |
0 |
Short description |
|
21 |
MAINTENANCE_AREA |
|
SINSTBEZ |
SINSTBEZ |
NUMC |
5 |
0 |
Maintenance district |
TIV16 |
22 |
TRANSPORT_CONNECTION |
|
SVERKEHR |
SVERKEHR |
CHAR |
1 |
0 |
Transport Connections of Business Entity |
TIV44 |
23 |
LOCATION |
|
SLAGEWE |
SLAGEWE |
NUMC |
4 |
0 |
Business entity location number |
TIV10 |
24 |
DISTRICT_LOCATION |
|
RESOBJLAGE |
RESOBJLAGE |
NUMC |
2 |
0 |
Indicator: District Location of Object |
TIV45 |
25 |
PROPERTY_TYPE |
|
VVSGRART |
VVSGRART |
NUMC |
4 |
0 |
Property type |
TIV56 |
26 |
LOCATION_QUALITY |
|
VVSGRQAL |
VVSGRQAL |
NUMC |
3 |
0 |
Property: Quality of location |
TIV57 |
27 |
GROUND_TYPE |
|
VVSGRFRM |
VVSGRFRM |
NUMC |
3 |
0 |
Property ground type |
TIV58 |
28 |
OVERALL_CONDITION |
|
VVSGRGZS |
VVSGRGZS |
NUMC |
3 |
0 |
Overall condition of property |
TIV59 |
29 |
DEVELOPMENT_PLAN |
|
RBEPLAN |
XMBEZ |
CHAR |
30 |
0 |
Development plan |
|
30 |
DEVELOPMENT_PLAN_DATE |
|
DBEPLAN |
DDAT |
DATS |
8 |
0 |
Date of development plan |
|
31 |
CURRENT_USAGE |
|
XNUTZGRU |
XMBEZ |
CHAR |
30 |
0 |
Current usage of property |
|
32 |
USAGE_TYPE_LAND_USE_MAP |
|
RGRNART |
CHAR2 |
CHAR |
2 |
0 |
Usage Type of Property According to Land Use Map |
|
33 |
USAGE_TYPE_DEVELOPMENT_PLAN |
|
RNBPLAN |
RGRNART |
CHAR |
4 |
0 |
Usage type according to development plan |
|
34 |
MAIN_USAGE_TYPE |
|
VVSUNART |
VVSUNART |
CHAR |
8 |
0 |
Main usage type |
TIV36 |
35 |
MAIN_USAGE_TYPE_IND |
|
VVJUNUTZA |
JANE |
CHAR |
1 |
0 |
Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36 |
|
36 |
PERM_USAGE_SITE_OCCUP_INDEX |
|
NZGRZ |
DEC1_2 |
DEC |
3 |
2 |
Permitted Usage: Site Occupancy Index |
|
37 |
PERM_USAGE_FLOOR_AREA_RATIO |
|
NZGFZ |
DEC2_2 |
DEC |
4 |
2 |
Permitted Usage: Floor Area Ratio |
|
38 |
PERM_USAGE_CONSTRCT_DIM_NO |
|
NZBMZ |
DEC3_2 |
DEC |
5 |
2 |
Permitted Usage: Construction Dimension Number |
|
39 |
ACTL_USAGE_SITE_OCCUP_INDEX |
|
NTGRZ |
DEC1_2 |
DEC |
3 |
2 |
Actual Usage: Site Occupancy Index |
|
40 |
ACTL_USAGE_FLOOR_AREA_RATIO |
|
NTGFZ |
DEC2_2 |
DEC |
4 |
2 |
Actual Usage: Floor Area Ratio |
|
41 |
ACTL_USAGE_CONSTRCT_DIM_NO |
|
NTBMZ |
DEC3_2 |
DEC |
5 |
2 |
Actual Usage: Construction Dimension Number |
|
42 |
HERITABLE_BLDG_RIGHT_IND |
|
JERBBAU |
SOBJERBBAU |
CHAR |
1 |
0 |
Heritable building right indicator |
TDO9 |
43 |
PERMITTED_BUILDING_HEIGHT |
|
REBDALLOWEDHEIGHT |
REBDALLOWEDHEIGHT |
INT2 |
5 |
0 |
Allowed Building Height (as Integer) |
|
44 |
BUILDING_TYPE |
|
RGEBART |
SOBJART |
NUMC |
2 |
0 |
Type of building |
TIV5A |
45 |
BUILDING_CONDITION |
|
RGEBZUST |
VVRZUSTAND |
NUMC |
2 |
0 |
General condition of building |
TIV83 |
46 |
CONSTRUCTION_YEAR |
|
VVYBAUJAHR |
DATUM |
DATS |
8 |
0 |
ConstYr |
|
47 |
CONSTRUCTION_YEAR_AS_YEAR |
|
VVJNURJ |
JANE |
CHAR |
1 |
0 |
Indicator: Only regard construction date in terms of years |
|
48 |
MODERNIZATION_YEAR |
|
VVYMODERN |
DATUM |
DATS |
8 |
0 |
Year of modernization |
|
49 |
RECONSTRUCTION_YEAR |
|
VVYAUFBAU |
DATUM |
DATS |
8 |
0 |
Year of reconstruction |
|
50 |
BEGIN_CONSTRUCTION_YEAR |
|
DBAUBEGI |
DDAT |
DATS |
8 |
0 |
Construction start date |
|
51 |
READY_FOR_OCCUPANCY_DATE |
|
DBEZUGSF |
DDAT |
DATS |
8 |
0 |
Ready for occupancy |
|
52 |
COMPLETION_DATE |
|
DFERTIG |
DDAT |
DATS |
8 |
0 |
Completion |
|
53 |
FINAL_INSPECTION_DATE |
|
DSCHLUSS |
DDAT |
DATS |
8 |
0 |
Final Inspection |
|
54 |
PLANNING_INQUIRY_DATE |
|
DBAUVOR |
DDAT |
DATS |
8 |
0 |
Date of planning inquiry |
|
55 |
PRIOR_NOTICE_DATE |
|
DVORBES |
DDAT |
DATS |
8 |
0 |
Date of prior notice |
|
56 |
BUILDING_PERMIT_APPLIC_DATE |
|
DANTBAU |
DATUM |
DATS |
8 |
0 |
Application for building permit |
|
57 |
BUILDING_PERMIT_DATE |
|
DBAUGENE |
DDAT |
DATS |
8 |
0 |
Building permit |
|
58 |
BUILDING_PERMIT_NOTE |
|
XBAUGENE |
XMBEZ |
CHAR |
30 |
0 |
Note on building permit |
|
59 |
HAS_HIST_SITE_PROTECTION |
|
JDENKMAL |
JANE |
CHAR |
1 |
0 |
Protection of Historical Sites |
|
60 |
PUBLIC_FUNDING_FROM |
|
VVDFRDVON |
DATUM |
DATS |
8 |
0 |
Public funding from |
|
61 |
PUBLIC_FUNDING_TO |
|
VVDFRDBIS |
DATUM |
DATS |
8 |
0 |
Public funding to |
|
62 |
FLOORS |
|
VVBANZGE |
DEC3_1 |
DEC |
4 |
1 |
Number of floors |
|
63 |
BASEMENTS |
|
AUGESCH |
DEC2 |
DEC |
2 |
0 |
Number of basements |
|
64 |
TOP_FLOOR |
|
VVSTCKBIS |
VVSSTOCKW |
NUMC |
3 |
0 |
Uppermost Floor of a Building |
TIV37 |
65 |
ELEVATOR_TO_FLOOR |
|
VVLIFTBIS |
VVSSTOCKW |
NUMC |
3 |
0 |
Elevator to Floor in Building |
TIV37 |
66 |
TOP_FLOOR_BY_ELEVATOR |
|
VVNSTCKLFT |
NUMC3 |
NUMC |
3 |
0 |
Number of highest floor reached by elevator |
|
67 |
OBJECT_VALID_FROM |
|
REBDVALIDFROM |
RECADATEBEG |
DATS |
8 |
0 |
Date: Valid From |
|
68 |
OBJECT_VALID_TO |
|
REBDVALIDTO |
RECADATEEND |
DATS |
8 |
0 |
Date: Valid To |
|
69 |
REAL_VALID_FROM |
|
REBDREALVALIDFROM |
RECADATEBEG |
DATS |
8 |
0 |
Date: Valid from (Effective) |
|
70 |
REAL_VALID_TO |
|
REBDREALVALIDTO |
RECADATEEND |
DATS |
8 |
0 |
Date: Valid to (Effective) |
|
71 |
RESPONSIBLE |
|
RECARESPONSIBLE |
XUBNAME |
CHAR |
12 |
0 |
Person Responsible |
* |
72 |
STAT_PROF |
|
J_STSMA |
J_STSMA |
CHAR |
8 |
0 |
Status Profile |
TJ20 |
73 |
RESERVATION_AREA |
|
REORRSAREA |
REORRSAREA |
CHAR |
10 |
0 |
Reservation Area |
TIVORRSAREA |
74 |
OFFERED_OBJECT_ID |
|
REOROOID |
REOROOID |
CHAR |
20 |
0 |
Offered Object Number |
|
75 |
OFFERED_OBJECT_EXT_ID |
|
REOROOIDEXT |
REOROOIDEXT |
CHAR |
45 |
0 |
External ID of Reservation Object |
|