Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACTIVE_HOLD_IND
|
Indicaters whether the hold is active or not.
|
VARCHAR2(1)
|
CALCULATION
|
SYSDATE BETWEEN SPRHOLD_FROM_DATE AND SPRHOLD_TO_DATE
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
APPLICATION_HOLD_IND
|
Indicates if this hold restriction prevents the creation of an admissions application.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_APPLICATION_HOLD_IND
|
NO
|
NO
|
AR_HOLD_IND
|
Indicates if this is an accounts receivable hold and all activity is prohibited to the account.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_AR_HOLD_IND
|
NO
|
NO
|
COMPLIANCE_HOLD_IND
|
Indicates if this hold restriction prevents the degree requirement compliance process being performed.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_COMPLIANCE_HOLD_IND
|
NO
|
NO
|
ENRL_VERIFICATION_HOLD_IND
|
Indicates if this hold restriction prohibits the release of an enrollment verification.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_ENV_HOLD_IND
|
NO
|
NO
|
GRADE_REPORT_HOLD_IND
|
Indicates if this hold restriction prohibits the release of grades.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_GRADE_HOLD_IND
|
NO
|
NO
|
GRADUATION_HOLD_IND
|
Indicates if this hold restriction prohibits graduation.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_GRAD_HOLD_IND
|
NO
|
NO
|
HOLD
|
Code for the type of hold associated with this record.
|
VARCHAR2(63)
|
SPRHOLD
|
SPRHOLD_HLDD_CODE
|
NO
|
NO
|
HOLD_AMOUNT
|
Amount associated with hold.
|
NUMBER
|
SPRHOLD
|
SPRHOLD_AMOUNT_OWED
|
NO
|
NO
|
HOLD_DESC
|
Hold description.
|
VARCHAR2(255)
|
STVHLDD
|
STVHLDD_DESC
|
NO
|
NO
|
HOLD_EXPLANATION
|
User specified free form explanation for the hold.
|
VARCHAR2(2000)
|
SPRHOLD
|
SPRHOLD_REASON
|
NO
|
NO
|
HOLD_FROM_DATE
|
Effective begin date of hold.
|
DATE
|
SPRHOLD
|
SPRHOLD_FROM_DATE
|
NO
|
NO
|
HOLD_ORIGINATING_OFFICE
|
Office/department that originated the hold.
|
VARCHAR2(63)
|
SPRHOLD
|
SPRHOLD_ORIG_CODE
|
NO
|
NO
|
HOLD_ORIGINATING_OFFICE_DESC
|
Description of the originating office/department.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
HOLD_RELEASE_IND
|
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
|
NO
|
NO
|
HOLD_TO_DATE
|
End date when the hold expires.
|
DATE
|
SPRHOLD
|
SPRHOLD_TO_DATE
|
NO
|
NO
|
HOLD_USER_CREATOR
|
System ID of the user who created the hold.
|
VARCHAR2(30)
|
SPRHOLD
|
SPRHOLD_USER
|
NO
|
NO
|
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
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SPRHOLD
|
SPRHOLD_PIDM
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
REGISTRATION_HOLD_IND
|
Indicates if this hold restriction prohibits registration activity.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_REG_HOLD_IND
|
NO
|
NO
|
TRANSCRIPT_HOLD_IND
|
Indicates if this hold restriction prohibits the release of an official academic transcript.
|
VARCHAR2(1)
|
STVHLDD
|
STVHLDD_TRANS_HOLD_IND
|
NO
|
NO
|