General Ledger (GL) Calendar Dates

The following columns represent the General Ledger calendar:

• GL_ACCT_START_DT_WID

• GL_ACCT_END_DT_WID

• GL_PERIOD_WID

For budgets that are time-phased using the General Ledger (GL) Calendar, the GL_ACCT_START_DT_WID and GL_ACCT_END_DT_WID columns are populated directly from the START_DATE and END_DATE of the budget line, while GL_PERIOD_WID identifies the corresponding GL accounting period.

For budgets with Time Phase set to Project Accounting (P), No Time Phase (N), or Date Range (R):

• GL_ACCT_START_DT_WID and GL_PERIOD_WID are derived using the START_DATE of the budget line.

• The ETL resolves these values by selecting the GL accounting period that contains the budget line START_DATE, based on the associated GL Calendar identified by GL_MCAL_CAL_WID.