Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
CITY	Address city, town or municipality.	VARCHAR2(63)	TTBTAXN	TTBTAXN_CITY	NO	NO
CORRECTED_IND	Indicates whether this information has been updated.	VARCHAR2(1)	TTBTAXN	TTBTAXN_CORRECTED_IND	NO	NO
COUNTY	County for this address.	VARCHAR2(63)	NA	NULL	NO	NO
COUNTY_DESC	County description.	VARCHAR2(255)	NA	NULL	NO	NO
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	NO	NO
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	NO	NO
ELIGIBLE_CHARGES_BILLED	Total of billed eligible charges.	NUMBER	TTBTAXN	TTBTAXN_AMOUNT_2	NO	NO
ELIGIBLE_SCHOLARSHIP_GRANT	Total amount of eligible scholarships or grants reported.	NUMBER	TTBTAXN	TTBTAXN_AMOUNT_4	NO	NO
FEDERAL_REPORT_STATUS	Federal reporting status.	VARCHAR2(63)	TTBTAXN	TTBTAXN_IRS_REPORT_STATUS	NO	NO
FEDERAL_REPORT_STATUS_DATE	Date the federal report status was set or last updated by the user.	DATE	TTBTAXN	TTBTAXN_IRS_REPORT_DATE	NO	NO
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	NO NO	NO
FIRST_NAME	Person's first or given name.	VARCHAR2(63)	TTBTAXN	TTBTAXN_FIRST_NAME	NO	NO
GRADUATE_STUDENT_IND	Indicates whether the student was exclusively a graduate student for a given tax year.	VARCHAR2(1)	TTBTAXN	TTBTAXN_GRAD_STUD_IND	NO	NO
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	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	TTBTAXN	TTBTAXN_ID	NO	NO
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	NO	NO
LAST_NAME	Last name of the person.	VARCHAR2(63)	TTBTAXN	TTBTAXN_LAST_NAME	NO	NO
LAST_NAME_PREFIX	Last name prefix of the person.	VARCHAR2(63)	TTBTAXN	TTBTAXN_SURNAME_PREFIX	NO	NO
LATEST_IND	Current record that is sent to student for notification and or the federal government for reporting.	VARCHAR2(1)	FUNCTION	TBD??	NO	NO
MIDDLE_NAME	Person's middle name.	VARCHAR2(63)	TTBTAXN	TTBTAXN_MI	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NATION	Nation/country code associated with the address.	VARCHAR2(63)	TTBTAXN	TTBTAXN_NATN_CODE	NO	NO
NATION_DESC	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
NOTIFICATION_STATUS	Student notification status.	VARCHAR2(63)	TTBTAXN	TTBTAXN_STUD_NOTIF_STATUS	NO	NO
NOTIFICATION_STATUS_DATE	Date the student notification status was set or last updated by the user.	DATE	TTBTAXN	TTBTAXN_STUD_NOTIF_DATE	NO	NO
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	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	TTBTAXN	TTBTAXN_PIDM	NO	NO
POSTAL_CODE	Address postal code.	VARCHAR2(63)	TTBTAXN	TTBTAXN_ZIP	NO	NO
PRIOR_YEAR_CHARGES_ADJUSTED	Total reductions to previously reported charges billed in prior years.	NUMBER	CALCULATION	TTBTAXN_AMOUNT_3 * -1	NO	NO
PRIOR_YEAR_PAYMENT_ADJ	Total reductions to previously reported Payment Received.	NUMBER	CALCULATION	TTBTAXN_AMOUNT_6 * -1	NO	NO
PRIOR_YR_SCHOLARSHIP_GRANT_ADJ	Total reductions to previously reported scholarships or grants from prior years.	NUMBER	CALCULATION	TTBTAXN_AMOUNT_5 * -1	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	TTBTAXN	TTBTAXN_STAT_CODE	NO	NO
STATE_PROVINCE_DESC	State or province description.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
STREET_LINE1	First line of the address.	VARCHAR2(255)	TTBTAXN	TTBTAXN_ADDR_LINE1	NO	NO
STREET_LINE2	Second line of the address.	VARCHAR2(255)	TTBTAXN	TTBTAXN_ADDR_LINE2	NO	NO
STREET_LINE3	Third line of the address.	VARCHAR2(255)	TTBTAXN	TTBTAXN_ADDR_LINE3	NO	NO
STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	NA	NULL	NO	NO
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	NO	NO
TAX_ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(63)	TTBTAXN	TTBTAXN_SSN	NO	NO
TAX_NOTIFICATION_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	TTBTAXN	TTBTAXN_ACTIVITY_DATE	NO	NO
TAX_NOTIFICATION_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	TTBTAXN	TTBTAXN_USER_ID	NO	NO
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	NO	NO
TOTAL_PAYMENT_RECEIVED	Total of Payment Received.	NUMBER	TTBTAXN	TTBTAXN_AMOUNT_1	NO	NO
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	NO	NO
VOID_IND	Determines whether this record is incorrect and indicates a new record must be sent.	VARCHAR2(1)	TTBTAXN	TTBTAXN_VOID_IND	NO	NO

Ver: 9.2