Skip to content

Data Profile: sap_anlagehist

Generated: 2025-11-27 00:23:53.313999 Schema: raw_results.sap_anlagehist Total Rows: 346,150 Columns: 10 Completeness: 100.00%

Source Files

File Rows Size
sap_anlagehist.csv 346,150 42.8 MB
Total 346,150 42.8 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 OBJECTID integer INTEGER No 0.00% 0
2 recz integer INTEGER No 0.00% 0
3 anlage integer INTEGER No 0.00% 0
4 bis timestamp TIMESTAMP No 0.00% 0
5 ab timestamp TIMESTAMP No 0.00% 0
6 aklasse integer INTEGER No 0.00% 0
7 tariftyp string VARCHAR(12) No 0.00% 0
8 branche string VARCHAR(7) No 0.00% 0
9 MD_prozessiert timestamp TIMESTAMP No 0.00% 0
10 ableseeinheit string VARCHAR(12) No 0.00% 0

Detailed Column Profiles

1. OBJECTID

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 346,150
Non-null 346,150 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 346,150 - Parse Success: 346,150 / 346,150

Sample Values: 

548, 592, 440, 448, 462

2. recz

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 346,150
Non-null 346,150 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 346,150 - Parse Success: 346,150 / 346,150

Sample Values: 

548, 592, 440, 448, 462

3. anlage

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 346,150
Non-null 346,150 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 346,150 - Parse Success: 346,150 / 346,150

Sample Values: 

1000081, 1000022, 2047427, 2047417, 2047418

4. bis

Type: timestamp → TIMESTAMP
Nullable: No

Metric Value
Total Rows 346,150
Non-null 346,150 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 346,150 - Parse Success: 346,150 / 346,150

Sample Values: 

9999-12-31 00:00:00, 2024-09-30 00:00:00, 2021-03-31 00:00:00, 2019-03-31 00:00:00, 2019-12-31 00:00:00

5. ab

Type: timestamp → TIMESTAMP
Nullable: No

Metric Value
Total Rows 346,150
Non-null 346,150 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 346,150 - Parse Success: 346,150 / 346,150

Sample Values: 

2024-10-01 00:00:00, 2021-04-01 00:00:00, 2019-04-01 00:00:00, 2020-01-01 00:00:00, 2016-10-01 00:00:00

6. aklasse

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 346,150
Non-null 346,150 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 346,150 - Parse Success: 346,150 / 346,150

Sample Values: 

100, 130, 300, 600, 700

7. tariftyp

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 346,150
Non-null 346,150 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 346,150 - Parse Success: 346,150 / 346,150

Sample Values: 

EH.BXX, EH, EWP.B25, EH.B30, EH.B25

8. branche

Type: string → VARCHAR(7)
Nullable: No

Metric Value
Total Rows 346,150
Non-null 346,150 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 5
Avg Length 0.0
Buffered Length 7 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 346,150 - Parse Success: 346,150 / 346,150

Sample Values: 

KO, HEWA, HEKOW, KOWA, HE

9. MD_prozessiert

Type: timestamp → TIMESTAMP
Nullable: No

Metric Value
Total Rows 346,150
Non-null 346,150 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 346,150 - Parse Success: 346,150 / 346,150

Sample Values: 

2025-11-09 00:00:00

10. ableseeinheit

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 346,150
Non-null 346,150 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 346,150 - Parse Success: 346,150 / 346,150

Sample Values: 

QSG-01, QDG-01, JSG-05, JSG-11, JSG-02

PostgreSQL DDL

See sap_anlagehist_schema.sql

Generated by process-csv-to-postgres v1.0.0