Holds Object

The Holds object contains information about holds. The data comes from the PROD table SPRHOLD. This object is not available to all Student Data Warehouse users.

---

Warehouse ID

Warehouse identification code. A unique identifying value for all persons in the Student Data Warehouse.

Data Type: Number

Hold Code

Hold code

Data Type: 2 Characters

From Date

Starting date of hold

Data Type: Date

To Date

End date of hold

Data Type: Date

Release Ind

Release Indicator

Data Type: 1 Character

Reason

Reason

Data Type: 30 Characters

Amount Owed

Amount owed

Data Type: 5 Digit number plus 2 decimal places

Orig Code

Orig Code

Data Type: 4 Characters

Username

Banner user id that updated the information in PROD

Data Type: 30 Characters

Activity Date

Date that the information was updated in PROD

Data Type: Date