/
Newly PO'd

Newly PO'd

Owned by Kaitlyn Niemann (Unlicensed), created
Last updated: Apr 09, 2024 by Albert Saludaga
1 min read

Requirements and Purpose

Report provides overview of recently created inventory by pricer.

Report Definition

  1. Stakeholders

    1. @Kaitlyn Niemann (Unlicensed)

    2. Derek Swinford

  2. Author

    1. @Kaitlyn Niemann (Unlicensed)

  3. Subject matter expert(s)

    1. Derek Swinford

  4. Presentation Medium

    1. SSRS

  5. Fields (data)

    1. Pricer

    2. PONumber

    3. ShareSTatus

    4. ListPrice

    5. eEvent

    6. eVenue

    7. eDate

    8. eQuantity

    9. eSec

    10. eRow

    11. eSeats

    12. InternalNote

    13. ExternalNote

Data source(s)

The data gathered in this report are from the Eibo-215 Database and STG Database. Using the stored procedure sr_GetNewlyPOd.

  1. eiboxoffice.dbo

    1. TicketGroup

    2. Event

    3. Venue

    4. BuyOrderTicketGroup

    5. BuyOrder

    6. def_ShareType

  2. stg.Users

    1. PricerEvents

    2. Users

Calculations

Column Name

Data Type

Calculation

Description

Column Name

Data Type

Calculation

Description

N/a

Datetime

= CONVERT(datetime,bo.CreatedDateTime) BETWEEN
CASE
WHEN @range = 1
THEN DATEADD(DAY,-7,DATEFROMPARTS(YEAR(GETDATE()),MONTH(GETDATE()),DAY(GETDATE())))
WHEN @range = 0
THEN DATEADD(DAY,-1,DATEFROMPARTS(YEAR(GETDATE()),MONTH(GETDATE()),DAY(GETDATE())))
END AND GETDATE())

Determines daterange to run

Parameters

  1. Filters

    1. @pricers

      1. multiple values available

      2. defaults to all values

      3. populates from other query

    2. @range

      1. Last week

        1. Looks at pos from the last week

      2. Yesterday

        1. looks at pos from yesterday

  2. Grouping

    1. PONumber

  3. Intentions for printing vs. online viewing

    1. The report is delivered via SSRS

    2. This report can be accessed here: SSRS → Asset → Newly PO'd

  4. Intended delivery mechanism (run on demand vs. delivered by subscription)

    1. On demand

  5. Future maintenance tasks or manually maintained items

    1. None

Results

  1. Data Accuracy

    1. QA

      1. Validate against po report

      2. No PO's with DNE notes should be included in results set.

  2. Limitations

    1. n/a

Change Log

  1. https://ticketboat.atlassian.net/browse/SP-290

  2. https://ticketboat.atlassian.net/browse/SP-292

  3. https://ticketboat.atlassian.net/browse/SP-302

  4. https://ticketboat.atlassian.net/browse/SP-308

Images



Related content