Employee

DB Object Name	Object Business Name	Object Description	DB Attribute Name	Attribute Business Name	Ordinal Position	Data Type Name	Data Type Size	Numeric Scale	Is Identity	Is Nullable	Primary Key	Mandatory
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	EMP_COMM_SYS_KEY_C	EMP COMM SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	EMP_COMM_BUS_KEY_C	EMP COMM BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	EMP_SYS_KEY_C	EMP SYS KEY C	3	VARCHAR	16777216		NO	NO	FALSE	TRUE
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	COMM_TYPE_CD_C	COMM TYPE CD C	4	VARCHAR	20		NO	YES	FALSE	FALSE
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	COMM_VAL_TXT_C	COMM VAL TXT C	5	VARCHAR	255		NO	YES	FALSE	FALSE
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	COMM_RANK_C	COMM RANK C	6	VARCHAR	4		NO	YES	FALSE	FALSE
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	ACTV_IND_C	ACTV IND C	7	VARCHAR	1		NO	YES	FALSE	FALSE
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	SYS_CRT_DTT_C	SYS CRT DTT C	8	DATE			NO	YES	FALSE	FALSE
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	SYS_CRT_BY_C	SYS CRT BY C	9	VARCHAR	255		NO	YES	FALSE	FALSE
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	SYS_EFF_DTT_C	SYS EFF DTT C	10	DATE			NO	YES	FALSE	FALSE
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	SYS_UPDT_DTT_C	SYS UPDT DTT C	11	DATE			NO	YES	FALSE	FALSE
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	SYS_UPDT_BY_C	SYS UPDT BY C	12	VARCHAR	255		NO	YES	FALSE	FALSE
EMP_COMM_MHSM_C	Employee MHSM Communication	Employee MHSM Communication	SYS_END_DTT_C	SYS END DTT C	13	DATE			NO	YES	FALSE	FALSE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	EMP_HIER_SYS_KEY_C	EMP HIER SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	EMP_HIER_BUS_KEY_C	EMP HIER BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	PRNT_EMP_SYS_KEY_C	PRNT EMP SYS KEY C	3	VARCHAR	16777216		NO	NO	FALSE	TRUE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	PRNT_EMP_TYPE_CD_C	PRNT EMP TYPE CD C	4	VARCHAR	20		NO	YES	FALSE	FALSE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	CHLD_EMP_SYS_KEY_C	CHLD EMP SYS KEY C	5	VARCHAR	16777216		NO	NO	FALSE	TRUE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	CHLD_EMP_TYPE_CD_C	CHLD EMP TYPE CD C	6	VARCHAR	20		NO	YES	FALSE	FALSE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	EMP_HIER_ROLE_TYPE_CD_C	EMP HIER ROLE TYPE CD C	7	VARCHAR	20		NO	YES	FALSE	FALSE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	CTRY_CD_C	CTRY CD C	8	VARCHAR	20		NO	YES	FALSE	FALSE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	SYS_CRT_DTT_C	SYS CRT DTT C	9	DATE			NO	YES	FALSE	FALSE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	SYS_CRT_BY_C	SYS CRT BY C	10	VARCHAR	255		NO	YES	FALSE	FALSE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	SYS_EFF_DTT_C	SYS EFF DTT C	11	DATE			NO	YES	FALSE	FALSE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	SYS_UPDT_DTT_C	SYS UPDT DTT C	12	DATE			NO	YES	FALSE	FALSE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	SYS_UPDT_BY_C	SYS UPDT BY C	13	VARCHAR	255		NO	YES	FALSE	FALSE
EMP_HIER_C	Employee Hierarchy	Employee Hierarchy	SYS_END_DTT_C	SYS END DTT C	14	DATE			NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	EMP_SYS_KEY_C	EMP SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
EMP_REF_C	Employee Reference	Employee Reference	EMP_BUS_KEY_C	EMP BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
EMP_REF_C	Employee Reference	Employee Reference	SRC_SYS_CD_C	SRC SYS CD C	3	VARCHAR	20		NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	CTRY_CD_C	CTRY CD C	4	VARCHAR	20		NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	EMP_FRST_NM_C	EMP FRST NM C	5	VARCHAR	100		NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	EMP_MID_NM_C	EMP MID NM C	6	VARCHAR	100		NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	EMP_LST_NM_C	EMP LST NM C	7	VARCHAR	100		NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	EMP_FULL_NM_C	EMP FULL NM C	8	VARCHAR	300		NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	EMP_TITL_TXT_C	EMP TITL TXT C	9	VARCHAR	100		NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	GNDR_CD_C	GNDR CD C	10	VARCHAR	20		NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	BRTH_DT_C	BRTH DT C	11	DATE			NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	BRTH_YR_C	BRTH YR C	12	NUMERIC	38	0	NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	DTH_DT_C	DTH DT C	13	DATE			NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	DTH_YR_C	DTH YR C	14	NUMERIC	38	0	NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	ACTV_IND_C	ACTV IND C	15	VARCHAR	1		NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	SYS_CRT_DTT_C	SYS CRT DTT C	16	DATE			NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	SYS_CRT_BY_C	SYS CRT BY C	17	VARCHAR	255		NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	SYS_EFF_DTT_C	SYS EFF DTT C	18	DATE			NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	SYS_UPDT_DTT_C	SYS UPDT DTT C	19	DATE			NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	SYS_UPDT_BY_C	SYS UPDT BY C	20	VARCHAR	255		NO	YES	FALSE	FALSE
EMP_REF_C	Employee Reference	Employee Reference	SYS_END_DTT_C	SYS END DTT C	21	DATE			NO	YES	FALSE	FALSE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	EMP_XREF_SYS_KEY_C	EMP XREF SYS KEY C	1	VARCHAR	16777216		NO	NO	TRUE	TRUE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	EMP_XREF_BUS_KEY_C	EMP XREF BUS KEY C	2	VARCHAR	16777216		NO	NO	FALSE	TRUE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	EMP_SYS_KEY_C	EMP SYS KEY C	3	VARCHAR	16777216		NO	NO	FALSE	TRUE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	EMP_XREF_SRC_NM_C	EMP XREF SRC NM C	4	VARCHAR	100		NO	YES	FALSE	FALSE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	EMP_XREF_SRC_CD_C	EMP XREF SRC CD C	5	VARCHAR	20		NO	YES	FALSE	FALSE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	EMP_XREF_SRC_VAL_C	EMP XREF SRC VAL C	6	VARCHAR	20		NO	YES	FALSE	FALSE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	EMP_XREF_SRC_ACTV_IND_C	EMP XREF SRC ACTV IND C	7	VARCHAR	1		NO	YES	FALSE	FALSE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	SYS_CRT_DTT_C	SYS CRT DTT C	8	DATE			NO	YES	FALSE	FALSE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	SYS_CRT_BY_C	SYS CRT BY C	9	VARCHAR	255		NO	YES	FALSE	FALSE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	SYS_EFF_DTT_C	SYS EFF DTT C	10	DATE			NO	YES	FALSE	FALSE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	SYS_UPDT_DTT_C	SYS UPDT DTT C	11	DATE			NO	YES	FALSE	FALSE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	SYS_UPDT_BY_C	SYS UPDT BY C	12	VARCHAR	255		NO	YES	FALSE	FALSE
EMP_XREF_C	Employee Cross Reference	Employee Cross Reference	SYS_END_DTT_C	SYS END DTT C	13	DATE			NO	YES	FALSE	FALSE

EMP_COMM_MHSM_C

Employee MHSM Communication

EMP_COMM_SYS_KEY_C

EMP COMM SYS KEY C

1

VARCHAR

16777216

NO

TRUE

EMP_COMM_MHSM_C

Employee MHSM Communication

EMP_COMM_BUS_KEY_C

EMP COMM BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

EMP_COMM_MHSM_C

Employee MHSM Communication

EMP_SYS_KEY_C

EMP SYS KEY C

3

VARCHAR

16777216

NO

FALSE

TRUE

EMP_COMM_MHSM_C

Employee MHSM Communication

COMM_TYPE_CD_C

COMM TYPE CD C

4

VARCHAR

20

NO

YES

FALSE

EMP_COMM_MHSM_C

Employee MHSM Communication

COMM_VAL_TXT_C

COMM VAL TXT C

5

VARCHAR

255

NO

YES

FALSE

EMP_COMM_MHSM_C

Employee MHSM Communication

COMM_RANK_C

COMM RANK C

6

VARCHAR

4

NO

YES

FALSE

EMP_COMM_MHSM_C

Employee MHSM Communication

ACTV_IND_C

ACTV IND C

7

VARCHAR

1

NO

YES

FALSE

EMP_COMM_MHSM_C

Employee MHSM Communication

SYS_CRT_DTT_C

SYS CRT DTT C

8

DATE

NO

YES

FALSE

EMP_COMM_MHSM_C

Employee MHSM Communication

SYS_CRT_BY_C

SYS CRT BY C

9

VARCHAR

255

NO

YES

FALSE

EMP_COMM_MHSM_C

Employee MHSM Communication

SYS_EFF_DTT_C

SYS EFF DTT C

10

DATE

NO

YES

FALSE

EMP_COMM_MHSM_C

Employee MHSM Communication

SYS_UPDT_DTT_C

SYS UPDT DTT C

11

DATE

NO

YES

FALSE

EMP_COMM_MHSM_C

Employee MHSM Communication

SYS_UPDT_BY_C

SYS UPDT BY C

12

VARCHAR

255

NO

YES

FALSE

EMP_COMM_MHSM_C

Employee MHSM Communication

SYS_END_DTT_C

SYS END DTT C

13

DATE

NO

YES

FALSE

EMP_HIER_C

Employee Hierarchy

EMP_HIER_SYS_KEY_C

EMP HIER SYS KEY C

1

VARCHAR

16777216

NO

TRUE

EMP_HIER_C

Employee Hierarchy

EMP_HIER_BUS_KEY_C

EMP HIER BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

EMP_HIER_C

Employee Hierarchy

PRNT_EMP_SYS_KEY_C

PRNT EMP SYS KEY C

3

VARCHAR

16777216

NO

FALSE

TRUE

EMP_HIER_C

Employee Hierarchy

PRNT_EMP_TYPE_CD_C

PRNT EMP TYPE CD C

4

VARCHAR

20

NO

YES

FALSE

EMP_HIER_C

Employee Hierarchy

CHLD_EMP_SYS_KEY_C

CHLD EMP SYS KEY C

5

VARCHAR

16777216

NO

FALSE

TRUE

EMP_HIER_C

Employee Hierarchy

CHLD_EMP_TYPE_CD_C

CHLD EMP TYPE CD C

6

VARCHAR

20

NO

YES

FALSE

EMP_HIER_C

Employee Hierarchy

EMP_HIER_ROLE_TYPE_CD_C

EMP HIER ROLE TYPE CD C

7

VARCHAR

20

NO

YES

FALSE

EMP_HIER_C

Employee Hierarchy

CTRY_CD_C

CTRY CD C

8

VARCHAR

20

NO

YES

FALSE

EMP_HIER_C

Employee Hierarchy

SYS_CRT_DTT_C

SYS CRT DTT C

9

DATE

NO

YES

FALSE

EMP_HIER_C

Employee Hierarchy

SYS_CRT_BY_C

SYS CRT BY C

10

VARCHAR

255

NO

YES

FALSE

EMP_HIER_C

Employee Hierarchy

SYS_EFF_DTT_C

SYS EFF DTT C

11

DATE

NO

YES

FALSE

EMP_HIER_C

Employee Hierarchy

SYS_UPDT_DTT_C

SYS UPDT DTT C

12

DATE

NO

YES

FALSE

EMP_HIER_C

Employee Hierarchy

SYS_UPDT_BY_C

SYS UPDT BY C

13

VARCHAR

255

NO

YES

FALSE

EMP_HIER_C

Employee Hierarchy

SYS_END_DTT_C

SYS END DTT C

14

DATE

NO

YES

FALSE

EMP_REF_C

Employee Reference

EMP_SYS_KEY_C

EMP SYS KEY C

1

VARCHAR

16777216

NO

TRUE

EMP_REF_C

Employee Reference

EMP_BUS_KEY_C

EMP BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

EMP_REF_C

Employee Reference

SRC_SYS_CD_C

SRC SYS CD C

3

VARCHAR

20

NO

YES

FALSE

EMP_REF_C

Employee Reference

CTRY_CD_C

CTRY CD C

4

VARCHAR

20

NO

YES

FALSE

EMP_REF_C

Employee Reference

EMP_FRST_NM_C

EMP FRST NM C

5

VARCHAR

100

NO

YES

FALSE

EMP_REF_C

Employee Reference

EMP_MID_NM_C

EMP MID NM C

6

VARCHAR

100

NO

YES

FALSE

EMP_REF_C

Employee Reference

EMP_LST_NM_C

EMP LST NM C

7

VARCHAR

100

NO

YES

FALSE

EMP_REF_C

Employee Reference

EMP_FULL_NM_C

EMP FULL NM C

8

VARCHAR

300

NO

YES

FALSE

EMP_REF_C

Employee Reference

EMP_TITL_TXT_C

EMP TITL TXT C

9

VARCHAR

100

NO

YES

FALSE

EMP_REF_C

Employee Reference

GNDR_CD_C

GNDR CD C

10

VARCHAR

20

NO

YES

FALSE

EMP_REF_C

Employee Reference

BRTH_DT_C

BRTH DT C

11

DATE

NO

YES

FALSE

EMP_REF_C

Employee Reference

BRTH_YR_C

BRTH YR C

12

NUMERIC

38

0

NO

YES

FALSE

EMP_REF_C

Employee Reference

DTH_DT_C

DTH DT C

13

DATE

NO

YES

FALSE

EMP_REF_C

Employee Reference

DTH_YR_C

DTH YR C

14

NUMERIC

38

0

NO

YES

FALSE

EMP_REF_C

Employee Reference

ACTV_IND_C

ACTV IND C

15

VARCHAR

1

NO

YES

FALSE

EMP_REF_C

Employee Reference

SYS_CRT_DTT_C

SYS CRT DTT C

16

DATE

NO

YES

FALSE

EMP_REF_C

Employee Reference

SYS_CRT_BY_C

SYS CRT BY C

17

VARCHAR

255

NO

YES

FALSE

EMP_REF_C

Employee Reference

SYS_EFF_DTT_C

SYS EFF DTT C

18

DATE

NO

YES

FALSE

EMP_REF_C

Employee Reference

SYS_UPDT_DTT_C

SYS UPDT DTT C

19

DATE

NO

YES

FALSE

EMP_REF_C

Employee Reference

SYS_UPDT_BY_C

SYS UPDT BY C

20

VARCHAR

255

NO

YES

FALSE

EMP_REF_C

Employee Reference

SYS_END_DTT_C

SYS END DTT C

21

DATE

NO

YES

FALSE

EMP_XREF_C

Employee Cross Reference

EMP_XREF_SYS_KEY_C

EMP XREF SYS KEY C

1

VARCHAR

16777216

NO

TRUE

EMP_XREF_C

Employee Cross Reference

EMP_XREF_BUS_KEY_C

EMP XREF BUS KEY C

2

VARCHAR

16777216

NO

FALSE

TRUE

EMP_XREF_C

Employee Cross Reference

EMP_SYS_KEY_C

EMP SYS KEY C

3

VARCHAR

16777216

NO

FALSE

TRUE

EMP_XREF_C

Employee Cross Reference

EMP_XREF_SRC_NM_C

EMP XREF SRC NM C

4

VARCHAR

100

NO

YES

FALSE

EMP_XREF_C

Employee Cross Reference

EMP_XREF_SRC_CD_C

EMP XREF SRC CD C

5

VARCHAR

20

NO

YES

FALSE

EMP_XREF_C

Employee Cross Reference

EMP_XREF_SRC_VAL_C

EMP XREF SRC VAL C

6

VARCHAR

20

NO

YES

FALSE

EMP_XREF_C

Employee Cross Reference

EMP_XREF_SRC_ACTV_IND_C

EMP XREF SRC ACTV IND C

7

VARCHAR

1

NO

YES

FALSE

EMP_XREF_C

Employee Cross Reference

SYS_CRT_DTT_C

SYS CRT DTT C

8

DATE

NO

YES

FALSE

EMP_XREF_C

Employee Cross Reference

SYS_CRT_BY_C

SYS CRT BY C

9

VARCHAR

255

NO

YES

FALSE

EMP_XREF_C

Employee Cross Reference

SYS_EFF_DTT_C

SYS EFF DTT C

10

DATE

NO

YES

FALSE

EMP_XREF_C

Employee Cross Reference

SYS_UPDT_DTT_C

SYS UPDT DTT C

11

DATE

NO

YES

FALSE

EMP_XREF_C

Employee Cross Reference

SYS_UPDT_BY_C

SYS UPDT BY C

12

VARCHAR

255

NO

YES

FALSE

EMP_XREF_C

Employee Cross Reference

SYS_END_DTT_C

SYS END DTT C

13

DATE

NO

YES

FALSE