RDM_HR_TERMINATION_CLASS_V

Database

SDSNZS01_RDM

Schema

CDCPADM_RDM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ID INTEGER 4
2 MUID CHARACTER VARYING(4000) 4000
3 VERSIONNAME NATIONAL CHARACTER VARYING(50) 50
4 VERSIONNUMBER INTEGER 4
5 VERSION_ID INTEGER 4
6 VERSIONFLAG NATIONAL CHARACTER VARYING(50) 50
7 NAME NATIONAL CHARACTER VARYING(250) 250
8 CODE NATIONAL CHARACTER VARYING(250) 250
9 CHANGETRACKINGMASK INTEGER 4
10 SOURCESYSTEMNAME NATIONAL CHARACTER VARYING(100) 100
11 TERMREASONCODE NATIONAL CHARACTER VARYING(100) 100
12 TERMREASONDESCRIPTION NATIONAL CHARACTER VARYING(100) 100
13 TERMGROUPCODE NATIONAL CHARACTER VARYING(100) 100
14 TERMGROUPDESCRIPTION NATIONAL CHARACTER VARYING(100) 100
15 ENTERDATETIME TIMESTAMP 8
16 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
17 ENTERVERSIONNUMBER INTEGER 4
18 LASTCHGDATETIME TIMESTAMP 8
19 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
20 LASTCHGVERSIONNUMBER INTEGER 4
21 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
22 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
23 CDC_RECORD_TYPE CHARACTER(14) 14
24 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
25 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8