PJO_CPY_PERIODS_GT

Global temporary table used when copying projects. If period dates change when periods are copied from source to target plan versions, then period data is temporarily stored here until it is moved into the target version.

Details

Schema: FUSION
Object owner: PJO
Object type: TABLE

Columns

Name
PA_PERIOD_NAMEVARCHAR230YesName of the period if the plan version uses a project accounting calendar. GL_PERIOD_NAMEVARCHAR230YesName of the period if the plan version uses an accounting calendar. PERIOD_NAMEVARCHAR230YesName of the period in the new plan version after dates are shifted based on shift days. START_DATEDATEYesStart date of the period in the new plan version after dates have been shifted based on shift days. END_DATEDATEYesEnd date of the period in the new plan version after dates have been shifted based on shift days.

Name

PA_PERIOD_NAMEVARCHAR230YesName of the period if the plan version uses a project accounting calendar.

GL_PERIOD_NAMEVARCHAR230YesName of the period if the plan version uses an accounting calendar.

PERIOD_NAMEVARCHAR230YesName of the period in the new plan version after dates are shifted based on shift days.

START_DATEDATEYesStart date of the period in the new plan version after dates have been shifted based on shift days.

END_DATEDATEYesEnd date of the period in the new plan version after dates have been shifted based on shift days.