| CALENDARYEAR |
smallint |
yes |
|
Calendar year, format "YYYY". |
| CALENDARHALF |
smallint |
yes |
|
Calendar half year number, values 1 or 2. |
| CALENDARHALFNAME |
char(2) |
yes |
|
Calendar half year name, values H1 or H2. |
| CALENDARYEARHALF |
int |
yes |
|
Calendar year and half number, format "YYYYnn" (nn is 01 or 02). |
| CALENDARHALFYEARNAME |
nvarchar(8) |
yes |
|
Calendar year and half name, format "nn YYYY" (nn is H1 or H2). |
| CALENDARFULLHALFYEARNAME |
nvarchar(15) |
yes |
|
Calendar year and half name, format "nn CY YYYY" (n is H1 or H2). |
| CALENDARQUARTER |
smallint |
yes |
|
Calendar quarter number, values 1, 2, 3 or 4. |
| CALENDARQUARTERNAME |
char(2) |
yes |
|
Calendar quarter name, values Q1, Q2, Q3 or Q4. |
| CALENDARYEARQUARTER |
int |
yes |
|
Calendar year and quarter number, format "YYYYnn" (nn is 01, 02, 03 or 04). |
| CALENDARQUARTERYEARNAME |
nvarchar(8) |
yes |
|
Calendar year and quarter name, format "nn YYYY" (nn is Q1, Q2, Q3 or Q4). |
| CALENDARFULLQUARTERYEARNAME |
nvarchar(15) |
yes |
|
Calendar year and quarter name, format "nn CY YYYY" (nn is Q1, Q2, Q3 or Q4). |
| CALENDARMONTH |
smallint |
yes |
|
Calendar month number, values 1 through 12. |
| CALENDARMONTHNAME |
nvarchar(12) |
yes |
|
Calendar month full name. |
| CALENDARWEEK |
smallint |
yes |
|
Calendar week number, values 1 through 54. |
| CALENDARYEARWEEK |
int |
yes |
|
Calendar year and week number, format "YYYYnn" (nn is value 01 through 54). |
| CALENDARWEEKYEARNAME |
nvarchar(15) |
yes |
|
Calendar year and week name, format "Wnn YYYY" (nn is value 01 through 54). |
| CALENDARFULLWEEKYEARNAME |
nvarchar(20) |
yes |
|
Calendar year and week name, format "Wnn CY YYYY" (nn is value 01 through 54). |
| CALENDARDAYOFYEAR |
smallint |
yes |
|
Calendar day of year number, values 1 through 366. |
| CALENDARYEARMONTH |
int |
yes |
|
Calendar year and month number, format "YYYYnn" (nn is value 01 through 12). |
| CALENDARMONTHYEARNAME |
nvarchar(15) |
yes |
|
Calendar year and month name, format "nn YYYY" (nn is value 01 through 12). |
| CALENDARFULLMONTHYEARNAME |
nvarchar(20) |
yes |
|
Calendar year and month name, format "nn CY YYYY" (nn is value 01 through 12). |
| FISCALYEAR |
smallint |
yes |
|
Fiscal year, format "YYYY". |
| FISCALHALF |
smallint |
yes |
|
Fiscal half year number, values 1 or 2. |
| FISCALYEARHALF |
int |
yes |
|
Fiscal year and half number, format "YYYYnn" (nn is 01 or 02). |
| FISCALHALFNAME |
char(2) |
yes |
|
Fiscal half year name, values H1 or H2. |
| FISCALHALFYEARNAME |
nvarchar(8) |
yes |
|
Fiscal year and half name, format "nn YYYY" (nn is H1 or H2). |
| FISCALFULLHALFYEARNAME |
nvarchar(15) |
yes |
|
Fiscal year and half name, format "nn YYYY" (nn is H1 or H2). |
| FISCALQUARTER |
smallint |
yes |
|
Fiscal quarter number, values 1, 2, 3 or 4. |
| FISCALQUARTERNAME |
char(2) |
yes |
|
Fiscal quarter name, values Q1, Q2, Q3 or Q4. |
| FISCALYEARQUARTER |
int |
yes |
|
Fiscal year and quarter number, format "YYYYnn" (nn is 01, 02, 03 or 04). |
| FISCALQUARTERYEARNAME |
nvarchar(8) |
yes |
|
Fiscal year and quarter name, format "nn YYYY" (nn is Q1, Q2, Q3 or Q4). |
| FISCALFULLQUARTERYEARNAME |
nvarchar(15) |
yes |
|
Fiscal year and quarter name, format "nn FY YYYY" (nn is Q1, Q2, Q3 or Q4). |
| FISCALPERIOD |
smallint |
yes |
|
Fiscal period as an Integer |
| FISCALPERIODYEARNAME |
nvarchar(15) |
yes |
|
Full name of Year and Period - e.g. Period 7 2009 |
| FISCALYEARPERIOD |
int |
yes |
|
Integer representation of the Fiscal Year and Period of format YYYYnn, e.g. 200702 for 2007 Fiscal Period 2 |
| FISCALMONTH |
smallint |
yes |
|
Fiscal month number, values 1 through 12. |
| FISCALMONTHNAME |
nvarchar(12) |
yes |
|
Fiscal month full name. e.g. March, April |
| FISCALYEARMONTH |
int |
yes |
|
Fiscal year and month number, format "YYYYnn" (nn is value 01 through 12). |
| FISCALMONTHYEARNAME |
nvarchar(15) |
yes |
|
Fiscal year and month name, format "nn YYYY" (nn is value 01 through 12). |
| FISCALFULLMONTHYEARNAME |
nvarchar(20) |
yes |
|
Fiscal year and month name, format "nn FY YYYY" (nn is value 01 through 12). |
| FISCALWEEK |
smallint |
yes |
|
Fiscal week number, values 1 through 54. |
| FISCALYEARWEEK |
int |
yes |
|
Fiscal year and week number, format "YYYYnn" (nn is value 01 through 54). |
| FISCALWEEKYEARNAME |
nvarchar(15) |
yes |
|
Fiscal year and week name, format "Wnn YYYY" (nn is value 01 through 54). |
| FISCALFULLWEEKYEARNAME |
nvarchar(20) |
yes |
|
Fiscal year and week name, format "Wnn FY YYYY" (nn is value 01 through 54). |
| FISCALDAYOFYEAR |
smallint |
yes |
|
Fiscal day of year number, values 1 through 366. |
| DAYOFMONTH |
smallint |
yes |
|
Number for the day in the month, e.g. 10 for March 10th |
| DAYOFWEEK |
smallint |
yes |
|
Number depicting day of week starting with Sunday as 1, Monday as 2, etc |
| DAYNAME |
nvarchar(12) |
yes |
|
Full Day name like Monday, Tuesday, etc |
| ISWEEKEND |
bit |
yes |
|
Flagged true if days are Sat-Sun |
| ISWEEKDAY |
bit |
yes |
|
Flagged true if days are Mon-Fri |
| ISHOLIDAY |
bit |
yes |
|
Flagged true if a holiday, e.g. Christmas Day |
| ISLEAPYEAR |
bit |
yes |
|
Flag to show whether a year is in a leap year (true) or not (false) |
| ISCURRENTDATE |
bit |
yes |
|
Flags the current date to be true, the other dates are false |
| ISCURRENTFISCALWEEK |
bit |
yes |
|
Set to true for every date in the current fiscal week |
| ISCURRENTCALENDARWEEK |
bit |
yes |
|
Set to true for every date in the current calendar week |
| ISCURRENTMONTH |
bit |
yes |
|
Set to true for every date in the current month |
| ISCURRENTPERIOD |
bit |
yes |
|
Set to true for every date in the current period |
| ISCURRENTFISCALQUARTER |
bit |
yes |
|
Set to true for every date in the current fiscal quarter |
| ISCURRENTCALENDARQUARTER |
bit |
yes |
|
Set to true for every date in the current calendar quarter |
| ISCURRENTFISCALYEAR |
bit |
yes |
|
Set to true for every date in the current fiscal year |
| ISCURRENTCALENDARYEAR |
bit |
yes |
|
Set to true for every date in the current calendar year |
| INFYSTARTTOCURRENT |
bit |
yes |
|
Set to true for every Calendar year up to the current date |
| INCYSTARTTOCURRENT |
bit |
yes |
|
Set to true for every Fiscal year from the start of each fiscal year up to the current date. |
| ISCLOSED |
bit |
yes |
|
Custom field used for accounting periods |
| ISLASTCLOSEDDATE |
bit |
yes |
|
Custom field used to flag end of last accounting close date |
| FILTER |
bit |
yes |
|
Custom filter |
| HOLIDAYNAME |
nvarchar(100) |
yes |
|
Name of holiday such as Christmas Day |
| ACTUALDATE |
datetime |
yes |
|
Date using datetime data type |
| ACTUALDATESTRING |
nvarchar(20) |
yes |
|
Date string, format "YYYY.MM.DD". |
| ACTUALDATESTRINGDMY |
nvarchar(25) |
yes |
|
Date string, format "DD MMM YYYY". |
| ACTUALDATESTRINGMDY |
nvarchar(25) |
yes |
|
Date string, format "MMM DD YYYY". |
| FISCALYEARSTARTDATE |
datetime |
yes |
|
Date when the Fiscal year starts for the date |
| FISCALYEARENDDATE |
datetime |
yes |
|
Date when the Fiscal year ends for the date |
| FISCALQUARTERSTARTDATE |
datetime |
yes |
|
Date when the Fiscal quarter starts for the date |
| FISCALQUARTERENDDATE |
datetime |
yes |
|
Date when the Fiscal quarter ends for the date |
| FISCALWEEKSTARTDATE |
datetime |
yes |
|
Date when the Fiscal week starts for the date |
| FISCALWEEKENDDATE |
datetime |
yes |
|
Date when the Fiscal week ends for the date |
| CALENDARQUARTERSTARTDATE |
datetime |
yes |
|
Date when the Calendar quarter starts for the date |
| CALENDARQUARTERENDDATE |
datetime |
yes |
|
Date when the Calendar quarter ends for the date |
| CALENDARWEEKSTARTDATE |
datetime |
yes |
|
Date when the Calendar week starts for the date |
| CALENDARWEEKENDDATE |
datetime |
yes |
|
Date when the Calendar week ends for the date |
| PERIODSTARTDATE |
datetime |
yes |
|
Date of the start of the month/period |
| PERIODENDDATE |
datetime |
yes |
|
Date of the end of the month/period. |
| MONSEQUENCE |
smallint |
yes |
|
Sequence number for the Monday in the Month, 0 is not Monday |
| TUESEQUENCE |
smallint |
yes |
|
Sequence number for the Tuesday in the Month, 0 is not Tuesday |
| WEDSEQUENCE |
smallint |
yes |
|
Sequence number for the Wednesday in the Month, 0 is not Wednesday |
| THUSEQUENCE |
smallint |
yes |
|
Sequence number for the Thursday in the Month, 0 is not Thursday |
| FRISEQUENCE |
smallint |
yes |
|
Sequence number for the Friday in the Month, 0 is not Friday |
| SATSEQUENCE |
smallint |
yes |
|
Sequence number for the Saturday in the Month, 0 is not Saturday |
| SUNSEQUENCE |
smallint |
yes |
|
Sequence number for the Sunday in the Month, 0 is not Sunday |
| DAYSSINCE |
int |
yes |
|
Number of days from the date to the current date |
| WEEKSSINCE |
int |
yes |
|
Number of weeks from the date to the current date |
| MONTHSSINCE |
int |
yes |
|
Number of months from the date to the current date |
| YEARSSINCE |
int |
yes |
|
Number of 12 month periods from the current date |
| SEQUENCE |
int |
|
|
Sequence number showing order of dates from 1-nn |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
| GLFISCALYEAR |
nvarchar(12) |
yes |
|
[dbo].[GLFISCALYEAR].[YEARID] |
| GLFISCALYEARDESCRIPTION |
nvarchar(60) |
yes |
|
[dbo].[GLFISCALYEAR].[DESCRIPTION] |
| GLFISCALYEARSTATUS |
nvarchar(10) |
yes |
|
[dbo].[GLFISCALYEAR].[STATUS] |
| GLFISCALPERIOD |
int |
yes |
|
[dbo].[GLFISCALPERIOD].[SEQUENCE] |
| GLFISCALPERIODCLOSED |
bit |
yes |
|
[dbo].[GLFISCALPERIOD].[CLOSED] |
| GLFISCALYEARSTARTDATE |
datetime |
yes |
|
The first [dbo].[GLFISCALYEAR].[STARTDATE] for the GL fiscal year |
| GLFISCALYEARENDDATE |
datetime |
yes |
|
The last [dbo].[GLFISCALPERIOD].[ENDDATE] for the GL fiscal year |
| GLFISCALYEARSEQUENCE |
int |
yes |
|
[dbo].[GLFISCALPERIOD].[SEQUENCE] |
| GLFISCALPERIODSINYEAR |
int |
yes |
|
[dbo].[GLFISCALYEAR].[FISCALPERIODSINYEAR] |
| GLFISCALPERIODSEQUENCE |
int |
yes |
|
Sequence for GL fiscal periods defined |
| GLFISCALPERIODSTARTDATE |
datetime |
yes |
|
[dbo].[GLFISCALPERIOD].[STARTDATE] |
| GLFISCALPERIODENDDATE |
datetime |
yes |
|
[dbo].[GLFISCALPERIOD].[ENDDATE] |
| ISCURRENTGLFISCALYEAR |
bit |
yes |
|
Set to true for every date in the current GL fiscal year |
| ISCURRENTGLFISCALPERIOD |
bit |
yes |
|
Set to true for every date in the current GL fiscal period |
| GLFISCALYEARSSINCE |
int |
yes |
|
Number of GL fiscal years from the current date |
| GLFISCALPERIODSSINCE |
int |
yes |
|
Number of GL fiscal periods from the current date |
| QUARTERSSINCE |
int |
yes |
|
Number of quarters from the current date |
| CALENDARYEARSSINCE |
int |
yes |
|
Number of calendar years from the current date |