NameDescriptionTypeAdditional information
OCCUR_PERIOD

Occur Period which is YYYYMM format.

string

None.

FISCAL_YEAR

Fiscal Year contains the concatenated version of the Fiscal Year Begin and the Fiscal Year End July to June.

string

None.

CALENDAR_YEAR

Calendar Year contains the concatenated version of the Calendar Year Begin and the Calendar Year End January to December.

string

None.

FY_YEAR

The 4 digit fiscal year the occur period falls in YYYY

string

None.

CY_YEAR

The 4 digit calendar year the occur period falls in YYYY

string

None.

START_FISCAL_PERIOD

The start of the fiscal period in MMMMDD format that the occur period falls in. (July)

string

None.

END_FISCAL_PERIOD

The end of the fiscal period in MMMMDD format that the occur period falls in. (June)

string

None.

START_CAL_PERIOD

The start of the calendar period in MMMMDD format that the occur period falls in.

string

None.

END_CAL_PERIOD

The end of the calendar period in MMMMDD format that the occur period falls in. (June)

string

None.

FY_YEAR_REP

The fiscal year date formatted for reports YYYY/YYYY

string

None.

OCCUR_PERIOD_MINUS1

The previous occur period

string

None.

OCCUR_PERIOD_MINUS6

The occur period that is 6 months previous

string

None.

OCCUR_PERIOD_REP

The occur period for reports

string

None.

OCCUR_PERIOD_PLUS1

The next occur period

string

None.

FY_YEAR_REP_LONG

The long display date of the fiscal year

string

None.

NO_OF_DAYS

The number of days in the occur period

string

None.

OCCUR_PERIOD_MINUS12

TThe occur period that is 12 months previous

string

None.

OCCUR_PERIOD_MINUS3

TThe occur period that is 3 months previous

string

None.

OCCUR_PERIOD_MINUS9

TThe occur period that is 9 months previous

string

None.