子系统:薪酬业务流程

数据表:T_PA_ACCTOBJ(子核算对象表)

T_PA_ACCTOBJ(子核算对象表):描述

名称

T_PA_ACCTOBJ(子核算对象表)

代码

T_PA_ACCTOBJ

注释

 

模型

PA

主键

PK_PA_ACCTOBJ


T_PA_ACCTOBJ(子核算对象表):列规格定义

名称

代码

数据类型

长度

强制

注释

分录内码

FENTRYID

int

 

TRUE

 

薪酬计算期次内码

FID

int

 

TRUE

 

主核算对象内码

FPAYOBJID

int

 

TRUE

 

薪酬分配内码

FFEEALLOCATEID

int

 

FALSE

 

年+期+次

FPERIODTIME

int

 

FALSE

期次的年+期+次组合而成的int值,只要用于期间端的数据查询

人员内码

FPERSONID

int

 

TRUE

 

员工内码

FSTAFFID

int

 

TRUE

 

hr人事管理中心

FMGRCENTERID

int

 

FALSE

 

审核状态

FAUDITSTATUS

char(1)

1

TRUE

0:未审核
1:已审核

发放状态

FPROVIDESTATUS

char(1)

1

TRUE

A:未发放
B:进入发放
C:已生成发放
D:已发放

费用分配状态

FFEEALCSTATUS

char(1)

1

TRUE

0:未分配
1:已分配

发放内码

FSALARID

int

 

FALSE

 

任职职位

FHRPOSTID

int

 

FALSE

 

工作组织单元

FUNITID

int

 

FALSE

 

工作组织

FORGID

int

 

FALSE

 

组织人员ID

FEMPINFOID

int

 

FALSE

 


T_PA_ACCTOBJ(子核算对象表):脚本代码

if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('T_PA_ACCTOBJ') and o.name = 'FK_T_PA_ACC_FK_T_PA_A_T_PA_FEE')
alter table T_PA_ACCTOBJ
drop constraint FK_T_PA_ACC_FK_T_PA_A_T_PA_FEE
go

if exists (select 1
from sysindexes
where id = object_id('T_PA_ACCTOBJ')
and name = 'IDX_PA_ACCTOBJ_FSTAFFID'
and indid > 0
and indid < 255)
drop index T_PA_ACCTOBJ.IDX_PA_ACCTOBJ_FSTAFFID
go

if exists (select 1
from sysindexes
where id = object_id('T_PA_ACCTOBJ')
and name = 'IDX_PA_ACCTOBJ_FSALARY'
and indid > 0
and indid < 255)
drop index T_PA_ACCTOBJ.IDX_PA_ACCTOBJ_FSALARY
go

if exists (select 1
from sysindexes
where id = object_id('T_PA_ACCTOBJ')
and name = 'IDX_PA_ACCTOBJ_FKFID'
and indid > 0
and indid < 255)
drop index T_PA_ACCTOBJ.IDX_PA_ACCTOBJ_FKFID
go

if exists (select 1
from sysindexes
where id = object_id('T_PA_ACCTOBJ')
and name = 'IDX_PA_ACCTOBJ_PERSONID'
and indid > 0
and indid < 255)
drop index T_PA_ACCTOBJ.IDX_PA_ACCTOBJ_PERSONID
go

if exists (select 1
from sysindexes
where id = object_id('T_PA_ACCTOBJ')
and name = 'IDX_PA_ACCTOBJ_PAYOBJID'
and indid > 0
and indid < 255)
drop index T_PA_ACCTOBJ.IDX_PA_ACCTOBJ_PAYOBJID
go

if exists (select 1
from sysobjects
where id = object_id('T_PA_ACCTOBJ')
and type = 'U')
drop table T_PA_ACCTOBJ
go

/*==============================================================*/
/* Table: T_PA_ACCTOBJ */
/*==============================================================*/
create table T_PA_ACCTOBJ (
FENTRYID int not null default 0,
FID int not null default 0,
FPAYOBJID int not null default 0,
FFEEALLOCATEID int null default 0,
FPERIODTIME int null,
FPERSONID int not null default 0,
FSTAFFID int not null default 0,
FMGRCENTERID int null,
FAUDITSTATUS char(1) not null default '0',
FPROVIDESTATUS char(1) not null default 'A',
FFEEALCSTATUS char(1) not null default '0',
FSALARID int null default 0,
FHRPOSTID int null default 0,
FUNITID int null default 0,
FORGID int null default 0,
FEMPINFOID int null default 0,
constraint PK_PA_ACCTOBJ primary key (FENTRYID)
)
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'期次的年+期+次组合而成的int值,只要用于期间端的数据查询',
'user', @CurrentUser, 'table', 'T_PA_ACCTOBJ', 'column', 'FPERIODTIME'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'0:未审核
1:已审核',
'user', @CurrentUser, 'table', 'T_PA_ACCTOBJ', 'column', 'FAUDITSTATUS'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'A:未发放
B:进入发放
C:已生成发放
D:已发放',
'user', @CurrentUser, 'table', 'T_PA_ACCTOBJ', 'column', 'FPROVIDESTATUS'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'0:未分配
1:已分配
',
'user', @CurrentUser, 'table', 'T_PA_ACCTOBJ', 'column', 'FFEEALCSTATUS'
go

/*==============================================================*/
/* Index: IDX_PA_ACCTOBJ_PAYOBJID */
/*==============================================================*/
create index IDX_PA_ACCTOBJ_PAYOBJID on T_PA_ACCTOBJ (
FPAYOBJID ASC
)
go

/*==============================================================*/
/* Index: IDX_PA_ACCTOBJ_PERSONID */
/*==============================================================*/
create index IDX_PA_ACCTOBJ_PERSONID on T_PA_ACCTOBJ (
FPERSONID ASC
)
go

/*==============================================================*/
/* Index: IDX_PA_ACCTOBJ_FKFID */
/*==============================================================*/
create index IDX_PA_ACCTOBJ_FKFID on T_PA_ACCTOBJ (
FID ASC
)
go

/*==============================================================*/
/* Index: IDX_PA_ACCTOBJ_FSALARY */
/*==============================================================*/
create index IDX_PA_ACCTOBJ_FSALARY on T_PA_ACCTOBJ (
FSALARID ASC
)
go

/*==============================================================*/
/* Index: IDX_PA_ACCTOBJ_FSTAFFID */
/*==============================================================*/
create index IDX_PA_ACCTOBJ_FSTAFFID on T_PA_ACCTOBJ (
FSTAFFID ASC
)
go

alter table T_PA_ACCTOBJ
add constraint FK_T_PA_ACC_FK_T_PA_A_T_PA_FEE foreign key (FFEEALLOCATEID)
references T_PA_FEEALLOCATE (FFEEALLOCATEID)
go


T_PA_ACCTOBJ(子核算对象表):键值定义

名称

代码

主要的

PK_PA_ACCTOBJ

PK_PA_ACCTOBJ

TRUE


T_PA_ACCTOBJ(子核算对象表):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_PA_ACCTOBJ_PAYOBJID

IDX_PA_ACCTOBJ_PAYOBJID

FALSE

FALSE

FALSE

TRUE

FALSE

T_PA_ACCTOBJ(子核算对象表)

IDX_PA_ACCTOBJ_PERSONID

IDX_PA_ACCTOBJ_PERSONID

FALSE

FALSE

FALSE

FALSE

FALSE

T_PA_ACCTOBJ(子核算对象表)

IDX_PA_ACCTOBJ_FKFID

IDX_PA_ACCTOBJ_FKFID

FALSE

FALSE

FALSE

TRUE

FALSE

T_PA_ACCTOBJ(子核算对象表)

IDX_PA_ACCTOBJ_FSALARY

IDX_PA_ACCTOBJ_FSALARY

FALSE

FALSE

FALSE

FALSE

FALSE

T_PA_ACCTOBJ(子核算对象表)

IDX_PA_ACCTOBJ_FSTAFFID

IDX_PA_ACCTOBJ_FSTAFFID

FALSE

FALSE

FALSE

FALSE

FALSE

T_PA_ACCTOBJ(子核算对象表)