Table that holds system and user-defined folders that house reports/financial statements/letters.["BR"]The last record has 999 for the PK value so we have a reserve int padding for future system defined folders. |
report_folder_KEY | int (4) | NOT NULL | Primary Key for this table. |
report_folder_type_KEY | int (4) | NOT NULL | Designates what kind category this folder will be stored under. |
is_system_defined_folder | bit (1) | NOT NULL | Was this a user-defined or system-defined folder? |
sequence_number_sbpr | int (4) | NOT NULL | Determines sort order among sibling folders. Since this sequence number value may not ["BR"]be unique across sibling folders, never sort by this column alone; always include the report_folder_KEY column as a secondary sort criteria |
description | nvarchar (300) | NOT NULL | Name of user-defined or system-defined folder. |
sequence_number_non_sbpr | int (4) | NOT NULL | Determines sort order among sibling folders for NON-SBPR. Since this sequence number value may not ["BR"]be unique across sibling folders, never sort by this column alone; always include the report_folder_KEY column as a secondary sort criteria |