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

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 Definition Database Data Type Source Name Source Column
CITY Address city, town or municipality. VARCHAR2(50)

TTBTAXN

TTBTAXN_CITY

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

TTBTAXN

TTBTAXN_CORRECTED_IND

COUNTY County for this address. VARCHAR2(0)

NA

NULL

COUNTY_DESC County description. VARCHAR2(0)

NA

NULL

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

NA

SYSDATE

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

NA

NA

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

TTBTAXN

TTBTAXN_AMOUNT_2

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

TTBTAXN

TTBTAXN_AMOUNT_4

FEDERAL_REPORT_STATUS Federal reporting status. VARCHAR2(1)

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

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

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

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

TTBTAXN

TTBTAXN_LAST_NAME

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

TTBTAXN

TTBTAXN_SURNAME_PREFIX

MIDDLE_NAME Person's middle name. VARCHAR2(60)

TTBTAXN

TTBTAXN_MI

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

NA

NA

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

NA

NA

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

TTBTAXN

TTBTAXN_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(30)

STVNATN

STVNATN_NATION

NOTIFICATION_STATUS Student notification status. VARCHAR2(1)

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

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

TTBTAXN

TTBTAXN_PIDM

POSTAL_CODE Address postal code. VARCHAR2(30)

TTBTAXN

TTBTAXN_ZIP

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

CALCULATION

TTBTAXN_AMOUNT_3 * -1

PRIOR_YEAR_PAYMENT_ADJ Total reductions to previously reported Payment Received. NUMBER(12,2)

CALCULATION

TTBTAXN_AMOUNT_6 * -1

PRIOR_YR_SCHOLARSHIP_GRANT_ADJ Total reductions to previously reported scholarships or grants from prior years. NUMBER(12,2)

CALCULATION

TTBTAXN_AMOUNT_5 * -1

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

TTBTAXN

TTBTAXN_STAT_CODE

STATE_PROVINCE_DESC State or province description. VARCHAR2(30)

STVSTAT

STVSTAT_DESC

STREET_LINE1 First line of the address. VARCHAR2(75)

TTBTAXN

TTBTAXN_ADDR_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(75)

TTBTAXN

TTBTAXN_ADDR_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(75)

TTBTAXN

TTBTAXN_ADDR_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(0)

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

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

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

TTBTAXN

TTBTAXN_TAX_YEAR

TOTAL_PAYMENT_RECEIVED Totals of Payments Received. NUMBER(12,2)

TTBTAXN

TTBTAXN_AMOUNT_1

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

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

NA

NA



Ver: