Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Accounts Receivable Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AT_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

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
CITY City Address city, town or municipality. VARCHAR2(50)  

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(0)  

NA

NULL

COUNTY_DESC County Description County description. VARCHAR2(0)  

NA

NULL

CURRENT_DATE Current Date System current date (sysdate) or date the data was extracted. DATE  

NA

SYSDATE

DOMAIN_VALUE Domain Value Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)  

NA

NA

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(12,2)  

TTBTAXN

TTBTAXN_AMOUNT_2

ELIGIBLE_SCHOLARSHIP_GRANT Eligible Scholarship Grant Total amount of eligible scholarships or grants reported. NUMBER(12,2)  

TTBTAXN

TTBTAXN_AMOUNT_4

FEDERAL_REPORT_STATUS Federal Report Status Federal reporting status. VARCHAR2(1)  

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

FIRST_NAME First Name Person's first or given name. VARCHAR2(60)  

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(9)  

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(60)  

TTBTAXN

TTBTAXN_LAST_NAME

LAST_NAME_PREFIX Last Name Prefix Last name prefix of the person. VARCHAR2(60)  

TTBTAXN

TTBTAXN_SURNAME_PREFIX

MIDDLE_NAME Middle Name Person's middle name. VARCHAR2(60)  

TTBTAXN

TTBTAXN_MI

MIF_DESC MIF Description Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)  

NA

NA

MIF_VALUE MIF Value Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)  

NA

NA

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

TTBTAXN

TTBTAXN_NATN_CODE

NATION_DESC Nation Description Address nation/country description. VARCHAR2(30)  

STVNATN

STVNATN_NATION

NOTIFICATION_STATUS Notification Status Student notification status. VARCHAR2(1)  

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

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER(8)  

TTBTAXN

TTBTAXN_PIDM

POSTAL_CODE Postal Code Address postal code. VARCHAR2(30)  

TTBTAXN

TTBTAXN_ZIP

PRIOR_YEAR_CHARGES_ADJUSTED Prior Year Charges Adjusted Total reductions to previously reported charges billed in prior years. NUMBER(12,2)  

CALCULATION

TTBTAXN_AMOUNT_3 * -1

PRIOR_YR_SCHOLARSHIP_GRANT_ADJ Prior Year Scholarship Grant Adjustment Total reductions to previously reported scholarships or grants from prior years. NUMBER(12,2)  

CALCULATION

TTBTAXN_AMOUNT_5 * -1

SEQUENCE_NUMBER Sequence Number System-generated one-up number to support tracking current corrected record among the void records for an individual student. NUMBER(3)  

TTBTAXN

TTBTAXN_SEQ_NUM

STATE_PROVINCE State Province State or province associated with this address. VARCHAR2(3)  

TTBTAXN

TTBTAXN_STAT_CODE

STATE_PROVINCE_DESC State Province Description State or province description. VARCHAR2(30)  

STVSTAT

STVSTAT_DESC

STREET_LINE1 Street Line 1 First line of the address. VARCHAR2(75)  

TTBTAXN

TTBTAXN_ADDR_LINE1

STREET_LINE2 Street Line 2 Second line of the address. VARCHAR2(75)  

TTBTAXN

TTBTAXN_ADDR_LINE2

STREET_LINE3 Street Line 3 Third line of the address. VARCHAR2(75)  

TTBTAXN

TTBTAXN_ADDR_LINE3

STREET_LINE4 Street Line 4 Fourth line of the address. VARCHAR2(0)  

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(15)  

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(30)  

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(4)  

TTBTAXN

TTBTAXN_TAX_YEAR

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

ZONE_VALUE Zone Value Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)  

NA

NA



Ver: