FM_BENEFIT_LINES

This table stores the individual lines of information per benefit type category over time. The benefit lines have a many-to-one relationship with 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

FM_USER_DATA

USER_DATA_ID

USER_DATA_ID

WP_USER_DATA

USER_DATA_ID

USER_DATA_ID

Column Descriptions

Column Name

Null?

Data Type

Description

BENEFIT_LINE_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

Used for hibernate versioning

BENEFIT_ID

NULLABLE

NUMBER

ID of the benefit that this benefit line belongs to.

BENEFIT_TYPE_CODE

NOT NULL

VARCHAR2(30)

Benefit type

CATEGORY_CODE

NULLABLE

VARCHAR2(40)

Category associated with the type

USER_DATA_ID

NULLABLE

NUMBER

User data associated with this benefit line

SYNC_SOURCE_FLAG

NULLABLE

VARCHAR2(10)

If the line is synchronized, describes the source. If the line is not a synchronized line, the value is "N". Listed in FSUtil.java, possible values are: "SP" - Staffing Profile, "P" - Project, "A" - Asset, "PR" - Proposal, "FSR" - Financial Summary Rollup.

Indexes

Index Name

Index Type

Sequence

Column Name

FM_BENEFIT_LINES_PK

UNIQUE

1

BENEFIT_LINE_ID

FM_BL_BENEFIT_ID_IDX

NONUNIQUE

1

BENEFIT_ID

Sequences

Sequence Name

Sequence Type

FM_BENEFIT_LINES_S

BENEFIT_LINE_ID