Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Accounts Receivable Reporting View Reports

Banner Operational Data Store
Reporting View Target: STUDENT_TAX_NOTIFICATION

Description Contains student tax information to be reported for federal compliance regarding billed qualifed charges and scholarships or grants. Student name and demographic data sent to the federal government, tax year, person UID, tax ID, student notification status, federal notification status, qualified charges billed, qualified charges adjusted from prior years, scholarship or grant amounts, scholarship or grant amounts adjusted from prior years, and an indicator to denote the latest notification record in existance for a student's tax year.
Key & Frequency One record per person UID per tax year per ID per sequence number
Recommended Search Columns TAX_YEAR, FEDERAL_REPORT_STATUS
TAX_YEAR, NOTIFICATION_STATUS
PERSON_UID, TAX_YEAR, ID,SEQUENCE_NUMBER

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

CITY Address city, town or municipality. VARCHAR2(63)

TTBTAXN

TTBTAXN_CITY

CORRECTED_IND Indicates whether this information has been updated. VARCHAR2(1)

TTBTAXN

TTBTAXN_CORRECTED_IND

COUNTY County for this address. VARCHAR2(63)

NA

NULL

COUNTY_DESC County description. VARCHAR2(255)

NA

NULL

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 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 Total of billed eligible charges. NUMBER

TTBTAXN

TTBTAXN_AMOUNT_2

ELIGIBLE_SCHOLARSHIP_GRANT Total amount of eligible scholarships or grants reported. NUMBER

TTBTAXN

TTBTAXN_AMOUNT_4

FEDERAL_REPORT_STATUS Federal reporting status. VARCHAR2(63)

TTBTAXN

TTBTAXN_IRS_REPORT_STATUS

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 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 Person's first or given name. VARCHAR2(63)

TTBTAXN

TTBTAXN_FIRST_NAME

GRADUATE_STUDENT_IND 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 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 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 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 of the person. VARCHAR2(63)

TTBTAXN

TTBTAXN_LAST_NAME

LAST_NAME_PREFIX Last name prefix of the person. VARCHAR2(63)

TTBTAXN

TTBTAXN_SURNAME_PREFIX

LATEST_IND Current record that is sent to student for notification and or the federal government for reporting. VARCHAR2(1)

FUNCTION

TBD??

MIDDLE_NAME Person's middle name. VARCHAR2(63)

TTBTAXN

TTBTAXN_MI

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NATION Nation/country code associated with the address. VARCHAR2(63)

TTBTAXN

TTBTAXN_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(255)

STVNATN

STVNATN_NATION

NOTIFICATION_STATUS Student notification status. VARCHAR2(63)

TTBTAXN

TTBTAXN_STUD_NOTIF_STATUS

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 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 System generated, unique, internal identification number assigned to this person. NUMBER

TTBTAXN

TTBTAXN_PIDM

POSTAL_CODE Address postal code. VARCHAR2(63)

TTBTAXN

TTBTAXN_ZIP

PRIOR_YEAR_CHARGES_ADJUSTED Total reductions to previously reported charges billed in prior years. NUMBER

CALCULATION

TTBTAXN_AMOUNT_3 * -1

PRIOR_YR_SCHOLARSHIP_GRANT_ADJ Total reductions to previously reported scholarships or grants from prior years. NUMBER

CALCULATION

TTBTAXN_AMOUNT_5 * -1

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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 or province associated with this address. VARCHAR2(63)

TTBTAXN

TTBTAXN_STAT_CODE

STATE_PROVINCE_DESC State or province description. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

STREET_LINE1 First line of the address. VARCHAR2(255)

TTBTAXN

TTBTAXN_ADDR_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(255)

TTBTAXN

TTBTAXN_ADDR_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(255)

TTBTAXN

TTBTAXN_ADDR_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NULL

STUDENT_CREATED_IND 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 Person's tax identification number assigned by their home federal government. VARCHAR2(63)

TTBTAXN

TTBTAXN_SSN

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 Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

TTBTAXN

TTBTAXN_USER_ID

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

UNOFFICIAL_IND 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 Determines whether this record is incorrect and indicates a new record must be sent. VARCHAR2(1)

TTBTAXN

TTBTAXN_VOID_IND



Ver: 9.1