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