Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACTIVE_HOLD_IND
|
Active Hold Indicator
|
Indicaters whether the hold is active or not.
|
VARCHAR2(1)
|
CALCULATION
|
SYSDATE BETWEEN SPRHOLD_FROM_DATE AND SPRHOLD_TO_DATE
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
APPLICATION_HOLD_IND
|
Application Hold Indicator
|
Indicates if this hold restriction prevents the creation of an admissions application.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_APPLICATION_HOLD_IND
|
AR_HOLD_IND
|
Ar Hold Indicator
|
Indicates if this is an accounts receivable hold and all activity is prohibited to the account.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_AR_HOLD_IND
|
COMPLIANCE_HOLD_IND
|
Compliance Hold Indicator
|
Indicates if this hold restriction prevents the degree requirement compliance process being performed.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_COMPLIANCE_HOLD_IND
|
ENRL_VERIFICATION_HOLD_IND
|
Enrl Verification Hold Indicator
|
Indicates if this hold restriction prohibits the release of an enrollment verification.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_ENV_HOLD_IND
|
GRADE_REPORT_HOLD_IND
|
Grade Report Hold Indicator
|
Indicates if this hold restriction prohibits the release of grades.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_GRADE_HOLD_IND
|
GRADUATION_HOLD_IND
|
Graduation Hold Indicator
|
Indicates if this hold restriction prohibits graduation.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_GRAD_HOLD_IND
|
HOLD
|
Hold
|
Code for the type of hold associated with this record.
|
VARCHAR2(63)
|
SPRHOLD
|
SPRHOLD_HLDD_CODE
|
HOLD_AMOUNT
|
Hold Amount
|
Amount associated with hold.
|
NUMBER
|
SPRHOLD
|
SPRHOLD_AMOUNT_OWED
|
HOLD_DESC
|
Hold Description
|
Hold description.
|
VARCHAR2(255)
|
STVHLDD
|
STVHLDD_DESC
|
HOLD_EXPLANATION
|
Hold Explanation
|
User specified free form explanation for the hold.
|
VARCHAR2(2000)
|
SPRHOLD
|
SPRHOLD_REASON
|
HOLD_FROM_DATE
|
Hold From Date
|
Effective begin date of hold.
|
DATE
|
SPRHOLD
|
SPRHOLD_FROM_DATE
|
HOLD_ORIGINATING_OFFICE
|
Hold Originating Office
|
Office/department that originated the hold.
|
VARCHAR2(63)
|
SPRHOLD
|
SPRHOLD_ORIG_CODE
|
HOLD_ORIGINATING_OFFICE_DESC
|
Hold Originating Office Description
|
Description of the originating office/department.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
HOLD_RELEASE_IND
|
Hold Release Indicator
|
A 'Y' indicates that a release may only be performed by the hold creator. An 'N' indicates that any user may release the hold.
|
VARCHAR2(1)
|
SPRHOLD
|
SPRHOLD_RELEASE_IND
|
HOLD_TO_DATE
|
Hold To Date
|
End date when the hold expires.
|
DATE
|
SPRHOLD
|
SPRHOLD_TO_DATE
|
HOLD_USER_CREATOR
|
Hold User Creator
|
System ID of the user who created the hold.
|
VARCHAR2(30)
|
SPRHOLD
|
SPRHOLD_USER
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NAME
|
Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SPRHOLD
|
SPRHOLD_PIDM
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
REGISTRATION_HOLD_IND
|
Registration Hold Indicator
|
Indicates if this hold restriction prohibits registration activity.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_REG_HOLD_IND
|
TRANSCRIPT_HOLD_IND
|
Transcript Hold Indicator
|
Indicates if this hold restriction prohibits the release of an official academic transcript.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_TRANS_HOLD_IND
|