FM_BENEFIT_PERIOD_SUM

This table stores the period sum values for benefits.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

FM_BENEFITS

BENEFIT_ID

BENEFIT_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

PPM_FISCAL_PERIODS_NLS

FISCAL_PERIOD_ID

PERIOD_ID

Column Descriptions

Column Name

Null?

Data Type

Description

BENEFIT_PERIOD_SUM_ID

NOT NULL

NUMBER

System-generated identifier

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

VERSION

NOT NULL

NUMBER

Hibernate versioning

ACTUAL_VALUE_BSE

NULLABLE

NUMBER

Base value of actual

ACTUAL_VALUE_LCL

NULLABLE

NUMBER

Local value of actual

BENEFIT_ID

NOT NULL

NUMBER

Benefit ID associated with this period sum

FISCAL_PERIOD_ID

NOT NULL

NUMBER

Fiscal period associated with this period sum

PLANNED_VALUE_BSE

NULLABLE

NUMBER

Base planned value

PLANNED_VALUE_LCL

NULLABLE

NUMBER

Local planned value

PROJECTED_TOTAL

NULLABLE

NUMBER

Projected total

SEQ

NOT NULL

NUMBER

Order of the periods

Indexes

Index Name

Index Type

Sequence

Column Name

FK_FM_BPS_BENEFIT_I

NONUNIQUE

1

BENEFIT_ID

FK_FM_BPS_PERIOD_I

NONUNIQUE

1

FISCAL_PERIOD_ID

FK_FM_BPS_SEQ_I

NONUNIQUE

1

SEQ

SYS_C005201513

UNIQUE

1

BENEFIT_PERIOD_SUM_ID

Sequences

Sequence Name

Sequence Type

FM_BENEFIT_PERIOD_SUM_S

BENEFIT_PERIOD_SUM_ID