SLN_OPERATORS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SLN_OPERATORS_HIID BIGINT 8
2 ACTION_CODE CHARACTER(1) 1
3 OPERATOR_ID CHARACTER VARYING(50) 50
4 OPERATOR_NM CHARACTER VARYING(80) 80
5 COST_CENTRE CHARACTER VARYING(20) 20
6 ORGANISATION CHARACTER VARYING(20) 20
7 DIVISION CHARACTER VARYING(20) 20
8 UNIT CHARACTER VARYING(20) 20
9 WORKGROUP CHARACTER VARYING(20) 20
10 REPORTS_TO CHARACTER VARYING(20) 20
11 WORKBASKET CHARACTER VARYING(40) 40
12 DELTA_TYPE CHARACTER VARYING(1) 1
13 EFFECTIVE_STRT_DT TIMESTAMP 8
14 EFFECTIVE_END_DT TIMESTAMP 8
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8