ALEX_REPORT_PERIOD (Staging table)

Column name	Data type	Required	Default updateable	Data target	Comments
EXTERNAL_KEY**	NVARCHAR (255)	Yes*	No	ALCO_EXTERNAL_KEY.EXTERNAL_KEY	External key - primary key
REPORT_PERIOD_NAME	NVARCHAR (255)	Yes*	Yes	ALTS_REPORT_PERIOD.REPORT_PERIOD_NAME	Stores report period name
REPORT_PERIOD_TYPE_KEY	NVARCHAR (255)	Yes*	Yes	ALTS_REPORT_PERIOD.REPORT_PERIOD_TYPE_ID	Stores the report period type external key
START_DAY	SMALLINT	No	Yes	ALTS_REPORT_PERIOD.START_DAY	Starting day of the period
START_TIME	DATETIME	No	Yes	ALTS_REPORT_PERIOD.START_TIME	Starting time of the period
REF_DATE	DATETIME	No	Yes	ALTS_REPORT_PERIOD.REF_DATE	If the reporting period is weekly or bi-weekly, it is a referencedate for deciding the start date of the reporting period.
REPORT_PERIOD_ACTIVE_STATUS	NUMERIC(5)	Yes*	Yes	ALTS_REPORT_PERIOD.REPORT_PERIOD_ACTIVE_STATUS	Active status
SUBMISSION_CUTOFF	INTEGER	No	Yes	ALTS_REPORT_PERIOD.SUBMISSION_CUTOFF	The number of days after the end of a time period. Thetimesheet is considered delinquent if posted after this date.
PAYROLL_CUTOFF	INTEGER	No	Yes	ALTS_REPORT_PERIOD.PAYROLL_CUTOFF	Number of days past end of reporting period. After this date,payroll does not accept the timesheet through normal process.

* System required field

** Value must be unique