Update 1/24/2023: Upgrade: Added Enrollment Status Codes, many new keys, flags.

Update 1/4/2023: Upgrade: updated Flow Support Information (pseudo code) for new Enrollment Status Codes

Update 12/29/2022: Upgrade: now creates Enrollment Status Codes. Added multiple options on key "lcc:flag". Added keys "lcc:auditEMPLID", "lcc:studentEnrollmentReasonCode", "lcc:fileSetMode", "lcc:fileSetFlag". Added more options on key "lcc:fileSetMethod"

Update 11/3/2022: Upgrade: added support files needed to run .NET Core programs (ex: .dll, .json files)

Update 10/4/2022: Upgrade: added blank column for 'Comments' in upload file.

Update 9/29/2022: Program released.

The program was created to handle the complexity in generating data for the vendor's site's needs.

Topology of the program/process:

• run Queries/ETLs to perform data build, export, transformation, copy for upload, etc.
• run lccFERFireworksData program
• copy data from program to SFTP upload location

The program's logic is as follows (cloud level view):
• create a row for each Term, with a single Application (App) Number (MAX), use App's date
• create a row containing a 'Status Code' for each Term+Application (in level of priority below)
• determine if student is enrolled in active/credited courses for the App's Term, if so use code 'Same', use app date
• if not 'Same', check if dropped all courses in that Term, but enrolled in later Terms, if so use code 'Later', use MIN enrollment date
• if all dropped in courses in that Term, use code 'Dropped', use MAX drop date
• if enrolled in earlier courses, use 'Earlier', use MAX enrollment date
• if enrolled in later courses, use 'Later', use MIN enrollment date

• Screenshot 1: exposing results in web tool
  

• lccFERFireworksData-installation.zip

• lccFERFireworksData-manual.pdf
• Logic File example
• Logic Flow
• Logic Flow - Support Information