Skip to content

Data Profile: euiinstln

Generated: 2025-11-25 00:43:48.206958 Schema: raw.euiinstln Total Rows: 70,057 Columns: 15 Completeness: 86.67%

Source Files

File Rows Size
20251104235823_euiinstln_6120.csv 70,057 10.4 MB
Total 70,057 10.4 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 ANLAGE string VARCHAR(15) No 0.00% 0
4 DATETO integer INTEGER No 0.00% 0
5 TIMETO integer INTEGER No 0.00% 0
6 DATEFROM integer INTEGER No 0.00% 0
7 TIMEFROM string VARCHAR(9) No 0.00% 0
8 EUIROLE_TECH string VARCHAR(1) Yes 100.00% 0
9 EUIROLE_DEREG string VARCHAR(1) No 0.00% 0
10 ERDAT integer INTEGER No 0.00% 0
11 ERNAM string VARCHAR(18) No 0.00% 0
12 AEDAT string VARCHAR(12) No 0.00% 0
13 AENAM string VARCHAR(18) No 0.00% 0
14 BEGRU string VARCHAR(6) No 0.00% 0
15 LOEVM string VARCHAR(1) Yes 100.00% 0

Detailed Column Profiles

1. MANDT

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

100

2. INT_UI

Type: string → VARCHAR(33)
Nullable: No

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

Sample Values: 

lMvshVCr7{2XuPigaUTCLW, lMvshVCr7{2byrU{dwxCXm, lMvshVCr7{2caJfKFv7CYW, lMvshVCr7{2dkA}VtvUCZW, lMvshVCr7{2dypjwmTpCZm

3. ANLAGE

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 70,057
Non-null 70,057 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 70,057 - Parse Success: 70,057 / 70,057

Sample Values: 

0001022589, 0001022599, 0001022601, 0002036755, 0001022619

4. DATETO

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

99991231

5. TIMETO

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

235959

6. DATEFROM

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

19940101, 20081001, 20131001, 20180101, 20241001

7. TIMEFROM

Type: string → VARCHAR(9)
Nullable: No

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

Sample Values: 

000000

8. EUIROLE_TECH

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 70,057
Non-null 0 (0.0%)
Null 70,057 (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: 70,057 - Parse Success: 70,057 / 70,057

Sample Values: 

(no data)

9. EUIROLE_DEREG

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 70,057
Non-null 70,057 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 70,057 - Parse Success: 70,057 / 70,057

Sample Values: 

X

10. ERDAT

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

20030405, 20081220, 20081219, 20131016, 20241024

11. ERNAM

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values: 

DDIC        , JOBADMIN    , JOGGI       , ZUPPIGER    , VOGEL

12. AEDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

        , 00000000, 20210621, 20210618, 20240305

13. AENAM

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values: 

            , BLESS       , JOGGI       , ZUPPIGER    , SCHEFER

14. BEGRU

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

15. LOEVM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 70,057
Non-null 0 (0.0%)
Null 70,057 (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: 70,057 - Parse Success: 70,057 / 70,057

Sample Values: 

(no data)

PostgreSQL DDL

See euiinstln_schema.sql

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