Skip to content

Data Profile: euitrans

Generated: 2025-11-25 00:44:00.987995 Schema: raw.euitrans Total Rows: 63,905 Columns: 14 Completeness: 92.86%

Source Files

File Rows Size
20251104235844_euitrans_6120.csv 63,905 11.7 MB
Total 63,905 11.7 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 MANDT integer INTEGER No 0.00% 0
2 INT_UI string VARCHAR(33) No 0.00% 0
3 DATETO integer INTEGER No 0.00% 0
4 TIMETO string VARCHAR(9) No 0.00% 0
5 DATEFROM integer INTEGER No 0.00% 0
6 TIMEFROM string VARCHAR(9) No 0.00% 0
7 EXT_UI string VARCHAR(75) No 0.00% 0
8 UISTRUTYP string VARCHAR(3) No 0.00% 0
9 ERDAT string VARCHAR(12) No 0.00% 0
10 ERNAM string VARCHAR(18) No 0.00% 0
11 AEDAT string VARCHAR(12) No 0.00% 0
12 AENAM string VARCHAR(18) No 0.00% 0
13 BEGRU string VARCHAR(6) No 0.00% 0
14 LOEVM string VARCHAR(1) Yes 100.00% 0

Detailed Column Profiles

1. MANDT

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (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: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

100

2. INT_UI

Type: string → VARCHAR(33)
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 22
Avg Length 0.0
Buffered Length 33 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

lMvshVCr7{2ascq1TaMCXG, lMvshVCr7{2baamz3SSCXW, lMvshVCr7{2byrU{dwxCXm, lMvshVCr7{2cessMKUTCYW, lMvshVCr7{2gWQHZF4QCjG

3. DATETO

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (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: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

99991231, 20120629, 20120630, 20120628, 20230131

4. TIMETO

Type: string → VARCHAR(9)
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 6
Avg Length 0.0
Buffered Length 9 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

235959, 055959, 055958

5. DATEFROM

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (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: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

19940101, 20081001, 20101001, 20191101, 20100701

6. TIMEFROM

Type: string → VARCHAR(9)
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 6
Avg Length 0.0
Buffered Length 9 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

000000, 060000, 055959, 140000

7. EXT_UI

Type: string → VARCHAR(75)
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 50
Avg Length 0.0
Buffered Length 75 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

CH7000011234500000000000000068196                 , CH7000011234500000000000000068046                 , CH7000011234500000000000000068049                 , CH7000011234500000000000000068057                 , CH7000011234500000000000000068063

8. UISTRUTYP

Type: string → VARCHAR(3)
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

02

9. ERDAT

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (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: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

00000000, 20191127, 20241024, 20250502, 20250128

10. ERNAM

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

            , ZUPPIGER    , BLESS       , SCHEFER     , JOGGI

11. AEDAT

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (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: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

00000000, 20210621, 20210618, 20210616, 20240305

12. AENAM

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

            , BLESS       , ZUPPIGER    , JOGGI       , MORFT

13. BEGRU

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 63,905
Non-null 63,905 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 63,905 - Parse Success: 63,905 / 63,905

Sample Values:

14. LOEVM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 63,905
Non-null 0 (0.0%)
Null 63,905 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 63,905 - Parse Success: 63,905 / 63,905

Sample Values: 

(no data)

PostgreSQL DDL

See euitrans_schema.sql

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