员工基本信息.docVIP

EmployeeBasicInformation：ZTS11_EMP_DEF

Field

Type

InitialValue

Key

Decimal

ShortDescription

EMP_NUM

CHAR(10)

NotNull

Y

EmployeeNumber

EMP_NAME

CHAR(20)

Notnull

EmployeeName

TYPE

CHAR(10)

Notnull

Defineittoemployeeorcontractor

EMP_ID_CARD

CHAR(18)

EmployeesIDCard

EMP_BIR

DATS(8)

EmployeesBirthday

EMP_SEX

char(6)

EmployeesSex

email

Char(20)

Employee’semail

MOBILE

NUMC(11)

MobileNumber

TEL

NUMC（12）

TelephoneNumber

START_DATE

DATS(8)

Notnull

EmployeesValidateDate

END_DATE

DATS(8)

EmployeesInvalidateDate

EMP_DEPT

char(30)

EmployeesDepartment

FLAG

Char(1)

Showthisifasamanager

MANAGER_ID

NUMC(10)

Notnull

EmployeesManager

CREATED_DATE

DATS(8)

RecordCreatedDate

CREATED_BY

NUMC(10)

RecordCreatedbyWho

LAST_UPDATED

DATS(8)

RecordLastUpdateDate

LAST_UPDATED_BY

Numc(10)

RecordLastUpdatebyWho

Attribute1

Char(40)

remark