Schedule Offering Field for Status

[sh0wt1me0412]

Hi my business needs a report regarding schedule offering that contains the status of the scheduled offering which I can not find in the data dictionary.

I found NOTACTIVE which contains Y or N.

What the business needs is the field regarding the status if closed or not. This is another field which I did not find. Does anybody know where to find it?

Thanks in advance!

[sh0wt1me0412]

Thanks!

So I think as your replied to the same result there is no explicit field for the status closed as you can see in my screenshot:

Am I right that I need to calculate this field in SQL through different fields:

NOTACTIVE --> If N set status to "active"

NOTACTIVE --> If Y set status to "inactive"

CLOSED_DATE --> If closed date is in the pas set status to "closed"

CANCELLED --> If Y set status to "canceled"

Does this logic makes sense?

[MarcL]

Yes, that is correct.

For the CLOSED_DATE it is easy: If there is a date in the database column, that the Class was closed, if not, then the class is open.

[MarcL]

Hi Daniel,

by running 'select * from PA_SCHED' I found the following columns that you might be intered in:

• NOTACTIVE ( as you mentioned)
• CANCELLED and CANCEL_DTE
• CLOSED_DATE

With the closed date you see, if the Class was closed or not and you can define your output in your SQL command

I hope this helps.

Regards
Marc