PLAN_VALUE_ID

NOT NULL

NUMBER

System-generated identifier

ENTITY_ID

NOT NULL

NUMBER

Resource ID or position ID

ENTITY_NAME

NOT NULL

VARCHAR2

Resource name or position name

FISCAL_PERIOD_ID

NOT NULL

NUMBER

Refer to FISCAL_PERIOD_ID in PPM_ FISCAL_PERIODS_NLS table

PLAN_VALUE_BSE

NOT NULL

NUMBER

Base plan value

PLAN_VALUE_LCL

NOT NULL

NUMBER

Local plan value

PLAN_VALUE_CUR_LCL

NOT NULL

VARCHAR2

Local currency code of plan value

POSITION_ID

NOT NULL

NUMBER

If entity is position, then POSITION_ID=0;

If entity is resource, then POSITION_ID indicates the resource belongs to.

ENTITY_TYPE

NOT NULL

VARCHAR2

‘position’ or ‘resource’

STAFFING_PROFILE_ID

NOT NULL

NUMBER

Refer to STAFFING_PROFILE_ID in RSC_STAFFING_PROFILES table

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