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: