PJO_DIS_PERIOD_GT

Global temporary table that stores periodic financial plan data to avoid the need for multiple queries, and hence, enhance application performance.

Details

Schema: FUSION
Object owner: PJO
Object type: TABLE

Primary Key

Name	Columns
PJO_DIS_PERIOD_GT_PK	START_DATE, PERIOD_PROFILE_ID, CURRENT_REPORTING_PERIOD, ORG_ID

Columns

Name
START_DATEDATEYesSTART_DATE PERIOD_PROFILE_IDNUMBER18YesPERIOD_PROFILE_ID CURRENT_REPORTING_PERIODVARCHAR215YesCURRENT_REPORTING_PERIOD ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row. END_DATEDATEEND_DATE FROM_ANCHOR_POSITIONNUMBERFROM_ANCHOR_POSITION PERIOD_PROMPTVARCHAR250The name of the period or grouped period for the resource assignment based on the selected period profile. Example values are, Succeeding Period, Preceding Period, January-15, January-15 to January-16, 2020-Q1 to 2020-Q2, and so on. START_PERIOD_NAMEVARCHAR231START_PERIOD_NAME END_PERIOD_NAMEVARCHAR231END_PERIOD_NAME

Name

START_DATEDATEYesSTART_DATE

PERIOD_PROFILE_IDNUMBER18YesPERIOD_PROFILE_ID

CURRENT_REPORTING_PERIODVARCHAR215YesCURRENT_REPORTING_PERIOD

ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row.

END_DATEDATEEND_DATE

FROM_ANCHOR_POSITIONNUMBERFROM_ANCHOR_POSITION

PERIOD_PROMPTVARCHAR250The name of the period or grouped period for the resource assignment based on the selected period profile. Example values are, Succeeding Period, Preceding Period, January-15, January-15 to January-16, 2020-Q1 to 2020-Q2, and so on.

START_PERIOD_NAMEVARCHAR231START_PERIOD_NAME

END_PERIOD_NAMEVARCHAR231END_PERIOD_NAME

Indexes

Index	Uniqueness	Columns
PJO_DIS_PERIOD_GT_U1	Unique	START_DATE, PERIOD_PROFILE_ID, CURRENT_REPORTING_PERIOD, ORG_ID