| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
CITY
|
City
|
Address city, town or municipality.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_CITY
|
|
CORRECTED_IND
|
Corrected Indicator
|
Indicates whether this information has been updated.
|
VARCHAR2(1)
|
TTBTAXN
|
TTBTAXN_CORRECTED_IND
|
|
COUNTY
|
County
|
County for this address.
|
VARCHAR2(63)
|
NA
|
NULL
|
|
COUNTY_DESC
|
County Description
|
County description.
|
VARCHAR2(255)
|
NA
|
NULL
|
|
DO_NOT_SEND_DATE
|
Do Not Send Date
|
Date the do not send (remove notification) indicator was set or last updated by the user.
|
DATE
|
TTBTAXN
|
TTBTAXN_REMOVE_NOTIF_DATE
|
|
DO_NOT_SEND_IND
|
Do Not Send Indicator
|
Indicates whether the user no longer wants either a student or a federal notification going out for a student.
|
VARCHAR2(1)
|
TTBTAXN
|
TTBTAXN_REMOVE_NOTIF_IND
|
|
ELIGIBLE_CHARGES_BILLED
|
Eligible Charges Billed
|
Total of billed eligible charges.
|
NUMBER
|
TTBTAXN
|
TTBTAXN_AMOUNT_2
|
|
ELIGIBLE_SCHOLARSHIP_GRANT
|
Eligible Scholarship Grant
|
Total amount of eligible scholarships or grants reported.
|
NUMBER
|
TTBTAXN
|
TTBTAXN_AMOUNT_4
|
|
FEDERAL_REPORT_STATUS
|
Federal Report Status
|
Federal reporting status.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_IRS_REPORT_STATUS
|
|
FEDERAL_REPORT_STATUS_DATE
|
Federal Report Status Date
|
Date the federal report status was set or last updated by the user.
|
DATE
|
TTBTAXN
|
TTBTAXN_IRS_REPORT_DATE
|
|
FEDERAL_REPORT_STATUS_DESC
|
Federal Report Status Description
|
Federal reporting status description.
|
VARCHAR2(255)
|
CALCULATION FUNCTION
|
CASE WHEN TAX_NOTIFICATION_STATUS SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_NOTIFICATION_STATUS' AND VALUE = FEDERAL_REPORT_STATUS
|
|
FIRST_NAME
|
First Name
|
Person's first or given name.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_FIRST_NAME
|
|
GRADUATE_STUDENT_IND
|
Graduate Student Indicator
|
Indicates whether the student was exclusively a graduate student for a given tax year.
|
VARCHAR2(1)
|
TTBTAXN
|
TTBTAXN_GRAD_STUD_IND
|
|
HALF_TIME_ENROLLMENT_IND
|
Half Time Enrollment Indicator
|
Indicates whether the student per the instituion's rules was at least a half time status during a given tax year.
|
VARCHAR2(1)
|
TTBTAXN
|
TTBTAXN_HALF_TIME_ENRL_IND
|
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_ID
|
|
INCLUDES_FUTURE_IND
|
Includes Future Indicator
|
Indicates whether charges billed include amount from terms beginning in the first 3 months of the following tax year.
|
VARCHAR2(1)
|
TTBTAXN
|
TTBTAXN_FUTURE_IND
|
|
LAST_NAME
|
Last Name
|
Last name of the person.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_LAST_NAME
|
|
LAST_NAME_PREFIX
|
Last Name Prefix
|
Last name prefix of the person.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_SURNAME_PREFIX
|
|
LATEST_IND
|
Latest Indicator
|
Current record that is sent to student for notification and or the federal government for reporting.
|
VARCHAR2(1)
|
FUNCTION
|
TBD??
|
|
MIDDLE_NAME
|
Middle Name
|
Person's middle name.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_MI
|
|
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
|
|
NATION
|
Nation
|
Nation/country code associated with the address.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_NATN_CODE
|
|
NATION_DESC
|
Nation Description
|
Address nation/country description.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
|
NOTIFICATION_STATUS
|
Notification Status
|
Student notification status.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_STUD_NOTIF_STATUS
|
|
NOTIFICATION_STATUS_DATE
|
Notification Status Date
|
Date the student notification status was set or last updated by the user.
|
DATE
|
TTBTAXN
|
TTBTAXN_STUD_NOTIF_DATE
|
|
NOTIFICATION_STATUS_DESC
|
Notification Status Description
|
Student notification status description.
|
VARCHAR2(255)
|
FUNCTION
|
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_NOTIFICATION_STATUS' AND VALUE = NOTIFICATION_STATUS
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
TTBTAXN
|
TTBTAXN_PIDM
|
|
POSTAL_CODE
|
Postal Code
|
Address postal code.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_ZIP
|
|
PRIOR_YEAR_CHARGES_ADJUSTED
|
Prior Year Charges Adjusted
|
Total reductions to previously reported charges billed in prior years.
|
NUMBER
|
CALCULATION
|
TTBTAXN_AMOUNT_3 * -1
|
|
PRIOR_YEAR_PAYMENT_ADJ
|
Prior Year Payment Adjustment
|
Total reductions to previously reported Payment Received.
|
NUMBER
|
CALCULATION
|
TTBTAXN_AMOUNT_6 * -1
|
|
PRIOR_YR_SCHOLARSHIP_GRANT_ADJ
|
Prior Year Scholarship Grant Adjustment
|
Total reductions to previously reported scholarships or grants from prior years.
|
NUMBER
|
CALCULATION
|
TTBTAXN_AMOUNT_5 * -1
|
|
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
|
System-generated one-up number to support tracking current corrected record among the void records for an individual student.
|
NUMBER
|
TTBTAXN
|
TTBTAXN_SEQ_NUM
|
|
STATE_PROVINCE
|
State Province
|
State or province associated with this address.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_STAT_CODE
|
|
STATE_PROVINCE_DESC
|
State Province Description
|
State or province description.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
|
STREET_LINE1
|
Street Line 1
|
First line of the address.
|
VARCHAR2(255)
|
TTBTAXN
|
TTBTAXN_ADDR_LINE1
|
|
STREET_LINE2
|
Street Line 2
|
Second line of the address.
|
VARCHAR2(255)
|
TTBTAXN
|
TTBTAXN_ADDR_LINE2
|
|
STREET_LINE3
|
Street Line 3
|
Third line of the address.
|
VARCHAR2(255)
|
TTBTAXN
|
TTBTAXN_ADDR_LINE3
|
|
STREET_LINE4
|
Street Line 4
|
Fourth line of the address.
|
VARCHAR2(255)
|
NA
|
NULL
|
|
STUDENT_CREATED_IND
|
Student Created Indicator
|
Indicates whether the student was created in the TSATAXN form while having no accounts receivable records.
|
VARCHAR2(1)
|
TTBTAXN
|
TTBTAXN_CREATED_STUD_IND
|
|
TAX_ID
|
Tax ID
|
Person's tax identification number assigned by their home federal government.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_SSN
|
|
TAX_NOTIFICATION_ACTIVITY_DATE
|
Tax Notification Activity Date
|
Date that information for this record in the table was entered or last updated.
|
DATE
|
TTBTAXN
|
TTBTAXN_ACTIVITY_DATE
|
|
TAX_NOTIFICATION_USER_ID
|
Tax Notification User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
TTBTAXN
|
TTBTAXN_USER_ID
|
|
TAX_YEAR
|
Tax Year
|
Tax year the transaction is reported for qualified tuition and related expenses to be sent to the student and government. Example: informaiton that would be used to populate the United States 1098-t form or the Austrailian CAN form.
|
NUMBER
|
TTBTAXN
|
TTBTAXN_TAX_YEAR
|
|
TOTAL_PAYMENT_RECEIVED
|
Total Payment Received
|
Total of Payment Received.
|
NUMBER
|
TTBTAXN
|
TTBTAXN_AMOUNT_1
|
|
UNOFFICIAL_IND
|
Unofficial Indicator
|
Indicates whether this record was populated by a test run (Y)es, or an official run (N)o.
|
VARCHAR2(1)
|
TTBTAXN
|
TTBTAXN_TEST_MODE_IND
|
|
VOID_IND
|
Void Indicator
|
Determines whether this record is incorrect and indicates a new record must be sent.
|
VARCHAR2(1)
|
TTBTAXN
|
TTBTAXN_VOID_IND
|