SDW_TSLND_HR_ORG_HIER_TYP2

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_SDW_TSLND_HR_ORG_HIER_TYP2

Columns
# Name Data Type Length
1 HR_ORG_HIERARCHY_TYPE2_SK BIGINT 8
2 SOURCE_SYSTEM_CODE CHARACTER(3) 3
3 PERSONID BIGINT 8
4 PAYROLLNO CHARACTER VARYING(50) 50
5 UNUMBER CHARACTER VARYING(50) 50
6 FIRSTNAME CHARACTER VARYING(100) 100
7 LASTNAME CHARACTER VARYING(100) 100
8 POSITION_ID BIGINT 8
9 POSITION_TITLE CHARACTER VARYING(50) 50
10 BUSINESS_UNIT_NAME CHARACTER VARYING(50) 50
11 DIVISION_NAME CHARACTER VARYING(50) 50
12 DEPARTMENT_NAME CHARACTER VARYING(50) 50
13 SECTION_NAME CHARACTER VARYING(50) 50
14 TEAM_NAME CHARACTER VARYING(50) 50
15 ORGANISATIONAL_UNIT_ID BIGINT 8
16 ORGANISATIONAL_UNIT_NAME CHARACTER VARYING(50) 50
17 ORGANISATIONAL_UNIT_CODE NUMERIC(38,0) 19
18 START_DATE TIMESTAMP 8
19 DSS_START_DATE TIMESTAMP 8
20 DSS_END_DATE TIMESTAMP 8
21 DSS_CURRENT_FLAG CHARACTER(1) 1
22 DSS_VERSION NUMERIC(38,0) 19
23 MDS_STAGE_ACQUISITION_SK NUMERIC(38,0) 19
24 PROC_TS TIMESTAMP 8
25 PUBLISH CHARACTER(1) 1
26 QUERY_CURRENT_FLAG CHARACTER(1) 1
27 INSERT_JOB_ID BIGINT 8
28 DSS_CREATE_TIME TIMESTAMP 8
29 UPDATE_JOB_ID BIGINT 8
30 DSS_UPDATE_TIME TIMESTAMP 8
31 BSN_LOAD_DT TIMESTAMP 8
32 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
33 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
34 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
35 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8