| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| TBBCSTU_ACTIVITY_DATE |
TSACONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT |
CONTRACT_ACTIVITY_DATE |
NO |
NA |
| TBBCSTU_AUTH_IND |
TSACONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT |
AUTHORIZED_IND |
NO |
NA |
| TBBCSTU_AUTH_NUMBER |
TSACONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT |
AUTHORIZED_NUMBER |
NO |
NA |
| TBBCSTU_CONTRACT_NUMBER |
TSICONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT |
CONTRACT_NUMBER |
NO |
NA |
| TBBCSTU_CONTRACT_PRIORITY |
TSICONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT |
CONTRACT_PRIORITY |
NO |
NA |
| TBBCSTU_DATA_ORIGIN |
TSACONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT |
CONTRACT_DATA_ORIGIN |
NO |
|
| TBBCSTU_MAX_STUDENT_AMOUNT |
TSACONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT AT_CONTRACT AT_CONTRACT |
MAX_AMOUNT_FROM_THIRD_PARTY PERSON_MAX_AMOUNT_PAID PERSON_MAX_AMOUNT_AUTHORIZED |
NO NO NO |
NA |
| TBBCSTU_SPONSOR_REF_NUMBER |
TSACONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT |
SPONSOR_REFERENCE_NUMBER |
NO |
NA |
| TBBCSTU_STUDENT_CONT_ROLL_IND |
TSACONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT |
STUDENT_CONTRACT_ROLL_IND |
NO |
NA |
| TBBCSTU_STU_PIDM |
NA |
NO |
COMPOSITE VIEW |
AT_CONTRACT AS_ACTIVE_TERMS |
PERSON_UID PERSON_UID |
NO NO |
NA |
| TBBCSTU_TERM_CODE |
TSACONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT AS_ACTIVE_TERMS |
ACADEMIC_PERIOD ACADEMIC_PERIOD |
NO NO |
NA |
| TBBCSTU_TERM_CODE_EXPIRATION |
TSACONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT |
PERSON_EXP_ACAD_PERIOD |
NO |
NA |
| TBBCSTU_USER_ID |
TSACONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT |
USER_ID |
NO |
NA |