员工基本信息.docVIP

  • 1
  • 0
  • 约小于1千字
  • 约 1页
  • 2024-09-27 发布于北京
  • 举报

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

文档评论(0)

1亿VIP精品文档

相关文档