Banner Operational Data Store
Composite View Source: TTBTAXN - NULL
Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
TTBTAXN_ACTIVITY_DATE |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
TAX_NOTIFICATION_ACTIVITY_DATE |
NO |
|
TTBTAXN_ADDR_LINE1 |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
STREET_LINE1 |
NO |
|
TTBTAXN_ADDR_LINE2 |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
STREET_LINE2 |
NO |
|
TTBTAXN_ADDR_LINE3 |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
STREET_LINE3 |
NO |
|
TTBTAXN_AMOUNT_1 |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
TOTAL_PAYMENT_RECEIVED |
NO |
|
TTBTAXN_AMOUNT_2 |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
ELIGIBLE_CHARGES_BILLED |
NO |
|
TTBTAXN_AMOUNT_4 |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
ELIGIBLE_SCHOLARSHIP_GRANT |
NO |
|
TTBTAXN_CITY |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
CITY |
NO |
|
TTBTAXN_CORRECTED_IND |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
CORRECTED_IND |
NO |
|
TTBTAXN_CREATED_STUD_IND |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
STUDENT_CREATED_IND |
NO |
|
TTBTAXN_FIRST_NAME |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
FIRST_NAME |
NO |
|
TTBTAXN_FUTURE_IND |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
INCLUDES_FUTURE_IND |
NO |
|
TTBTAXN_GRAD_STUD_IND |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
GRADUATE_STUDENT_IND |
NO |
|
TTBTAXN_HALF_TIME_ENRL_IND |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
HALF_TIME_ENROLLMENT_IND |
NO |
|
TTBTAXN_ID |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
ID |
NO |
|
TTBTAXN_IRS_REPORT_DATE |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
FEDERAL_REPORT_STATUS_DATE |
NO |
|
TTBTAXN_IRS_REPORT_STATUS |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
FEDERAL_REPORT_STATUS |
NO |
|
TTBTAXN_LAST_NAME |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
LAST_NAME |
NO |
|
TTBTAXN_MI |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
MIDDLE_NAME |
NO |
|
TTBTAXN_NATN_CODE |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
NATION |
NO |
|
TTBTAXN_PIDM |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
PERSON_UID |
NO |
|
TTBTAXN_REMOVE_NOTIF_DATE |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
DO_NOT_SEND_DATE |
NO |
|
TTBTAXN_REMOVE_NOTIF_IND |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
DO_NOT_SEND_IND |
NO |
|
TTBTAXN_SEQ_NUM |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
SEQUENCE_NUMBER |
NO |
|
TTBTAXN_SSN |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
TAX_ID |
NO |
|
TTBTAXN_STAT_CODE |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
STATE_PROVINCE |
NO |
|
TTBTAXN_STUD_NOTIF_DATE |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
NOTIFICATION_STATUS_DATE |
NO |
|
TTBTAXN_STUD_NOTIF_STATUS |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
NOTIFICATION_STATUS |
NO |
|
TTBTAXN_SURNAME_PREFIX |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
LAST_NAME_PREFIX |
NO |
|
TTBTAXN_TAX_YEAR |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
TAX_YEAR |
NO |
|
TTBTAXN_TEST_MODE_IND |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
UNOFFICIAL_IND |
NO |
|
TTBTAXN_USER_ID |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
TAX_NOTIFICATION_USER_ID |
NO |
|
TTBTAXN_VOID_IND |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
VOID_IND |
NO |
|
TTBTAXN_ZIP |
TSATAXN, TSP1098 |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
POSTAL_CODE |
NO |
|