| Name | Data type | Not Null? | Primary key? | Default | Comment |
|---|---|---|---|---|---|
| year | character(1) | Yes | Yes | Period fiscal year identifier; L = Last year T = This year N = Next year | |
| period | smallint | Yes | Yes | Period number 1 - 13 for each for year | |
| end_date | date | No | No | Period end date | |
| start_date | date | No | No | Period start date | |
| year_end | date | No | No | Fiscal Year End date for this period | |
| locked | boolean | Yes | No | false | Period locked flag; FALSE = Period is not locked TRUE = Period is locked |
| Name | Type | Definition | Comment |
|---|---|---|---|
| gl_periods_pkey | Primary key | (year, period) |