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 |