| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Source Name | 
Source Column | 
| 
ACTIVITY_DATE
 | 
Activity Date 
 | 
The date that information in this record was entered or last updated.
 | 
DATE
 | 
 RPRSULA
 
 | 
 RPRSULA_ACTIVITY_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
 
 | 
| 
AID_YEAR
 | 
Financial Aid Year 
 | 
Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.
 | 
VARCHAR2(63)
 | 
 RPRSULA
 
 | 
 RPRSULA_AIDY_CODE
 
 | 
| 
AID_YEAR_DESC
 | 
Financial Aid Year Description 
 | 
Financial aid year name.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
CREATE_DATE
 | 
Create Date 
 | 
The created date and time for the data in this record as received from COD.
 | 
DATE
 | 
 RPRSULA
 
 | 
 RPRSULA_CREATE_DATE
 
 | 
| 
DATA_ORIGIN
 | 
Data Origin 
 | 
The latest source for the data contained in this record.
 | 
VARCHAR2(63)
 | 
 RPRSULA
 
 | 
 RPRSULA_DATA_ORIGIN
 
 | 
| 
DOCUMENT_ID
 | 
Document ID 
 | 
The document identification number for the document in which this information was received from COD.
 | 
VARCHAR2(63)
 | 
 RPRSULA
 
 | 
 RPRSULA_DOCUMENT_ID
 
 | 
| 
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
 
 | 
| 
LOAN_SULA_DATA_SOURCE
 | 
Loan Sula Data Source 
 | 
Indicates the source of the data in this record.
 | 
VARCHAR2(63)
 | 
 RPRSULA
 
 | 
 RPRSULA_SOURCE
 
 | 
| 
LOAN_SULA_DATA_SOURCE_DESC
 | 
Loan Sula Data Source Description 
 | 
Loan sula data source description.
 | 
VARCHAR2(255)
 | 
 RORMVAL
 
 | 
 RORMVAL_DESC
 
 | 
| 
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
 | 
 RPRSULA
 
 | 
 RPRSULA_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
 
 | 
| 
SEQUENCE_NUMBER
 | 
Sequence Number 
 | 
The number assigned to the record when created.
 | 
NUMBER
 | 
 RPRSULA
 
 | 
 RPRSULA_SEQ_NO
 
 | 
| 
SULA_FLAG
 | 
Subsidized Usage Limit Applies Flag 
 | 
Indicates a student is subject to the 150% Subsidized Usage Limit.
 | 
VARCHAR2(1)
 | 
 RPRSULA
 
 | 
 RPRSULA_FLAG
 
 | 
| 
SUM_ACTUAL_NTC_SUP
 | 
Sum Actual NTC Subsidized Usage Periods 
 | 
The sum of all actual non-credential teacher certification program subsidized usage periods for the student.
 | 
NUMBER
 | 
 RPRSULA
 
 | 
 RPRSULA_SUM_ACTUAL_NTC_SUP
 
 | 
| 
SUM_ACTUAL_SUP
 | 
Sum Actual Subsidized Usage Periods 
 | 
The sum of all actual subsidized usage periods for the student, excluding those for Non-Credential Teacher Certification programs.
 | 
NUMBER
 | 
 RPRSULA
 
 | 
 RPRSULA_SUM_ACTUAL_SUP
 
 | 
| 
SURROGATE_ID
 | 
Surrogate ID 
 | 
The surrogate id for this record.
 | 
NUMBER
 | 
 RPRSULA
 
 | 
 RPRSULA_SURROGATE_ID
 
 | 
| 
USER_ID
 | 
User ID 
 | 
The user ID of the person who inserted or last updated this record.
 | 
VARCHAR2(63)
 | 
 RPRSULA
 
 | 
 RPRSULA_USER_ID
 
 |