Report Description

A new Ready to Package report is requested based on the RTP process logic. The new report should be run by date range (based on status date). 

Report Parameters / Filters

• Enterprise

• Institution (multi-select)

• Campus (multi-select)

• Site (multi-select)

• Student is Active?

• Billing Cycle Start Date

• Billing Cycle End Date

• Year Exported

• Month Exported

Output Columns

• PID

• externalId2

• ProgramID

• CampusID

• FAY

• ISIRTranNum

• OrigSSN

• CurrSSN

• LastName

• FirstName (new field)

• OriginalNameID

• VerStatus

• Verified (Indicator of the active ISIR verification status - 'verified' or 'not verified')

• PackageStatus

• SeqInd

• StatusDate

• Primary SAI