act_advisories_flat

Identifier for the recreational resource associated with the advisory.

Unique number assigned to each advisory for a given resource.

Title of the advisory, summarizing the issue or situation being reported.

Detailed description of the advisory, providing more context about the issue, its impact, and any relevant information for users.

Name of the individual who submitted the advisory, providing accountability and a point of contact for further information.

Name of the access status associated with the advisory, indicating the current level of access to the resource (e.g. Open, Closed, Restricted).

Group label for the access status, categorizing the status into broader groups (e.g. Open, Closed, Restricted).

Detailed description of the access status, providing more information about what the status means for users and any specific conditions or restrictions that apply.

Type of event that triggered the advisory, such as a natural disaster, maintenance work, or safety concern.

Level of urgency associated with the advisory, indicating how quickly users should respond to the information (e.g. Low, Medium, High).

Current status of the advisory, such as Active, Resolved, or Expired.

Indicates whether the advisory affects reservations for the resource, providing important information for users planning to visit.

Indicates whether the advisory date should be displayed to users, allowing for flexibility in how information is presented.

Indicates whether the effective date of the advisory should be displayed to users, providing context about when the advisory takes effect.

Indicates whether the end date of the advisory should be displayed to users, providing information about when the advisory is expected to be resolved.

Indicates whether the updated date of the advisory should be displayed to users, allowing for transparency about when information was last modified.

Date when the advisory was created or submitted, providing a timeline for the advisory.

Date when the advisory takes effect, indicating when users should start following the advisory information.

Date when the advisory is expected to end or be resolved, providing users with an expectation for how long the advisory will be in place.

Date when the advisory expires and is no longer relevant, allowing for automatic cleanup of outdated advisories.

Date when the advisory was last updated, allowing users to see how current the information is.

Date when the advisory was published and made visible to users, indicating when the information became available for public consumption.

Rank for ordering advisories in listings, calculated based on urgency, access status, and event type to ensure the most critical advisories are displayed prominently.

Sequence number for the urgency level associated with the advisory.

Precedence level for the access status associated with the advisory.

Precedence level for the event type associated with the advisory.