SGHE Enterprise Data Warehouse
Banner EDW Source: RECEIVABLE_ACCOUNT_DETAIL - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME |
ACADEMIC_PERIOD |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO NO |
| ACADEMIC_YEAR |
NO |
DIMENSION TABLE |
WDT_TIME |
ACADEMIC_YEAR |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO NO |
| ADMINISTRATIVE_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
ADMINISTRATIVE_GROUP |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO |
| AMOUNT |
NO |
FACT TABLE |
WFT_RECEIVABLE_REVENUE |
AMOUNT_DUE |
RECEIVABLE REVENUE |
NO |
| BALANCE |
NO |
FACT TABLE |
WFT_RECEIVABLE_REVENUE |
BALANCE |
RECEIVABLE REVENUE |
NO |
| BILL_DATE |
NO |
DIMENSION TABLE |
WDT_ACCOUNTS_RECEIVABLE |
BILL_DATE_AGING |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO |
| CATEGORY |
NO |
DIMENSION TABLE |
WDT_ACCOUNTS_RECEIVABLE |
CATEGORY |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO |
| CATEGORY_DESC |
NO |
DIMENSION TABLE |
WDT_ACCOUNTS_RECEIVABLE WDT_ACCOUNTS_RECEIVABLE |
CATEGORY_SD CATEGORY_LD |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO NO |
| DETAIL_CODE |
NO |
DIMENSION TABLE |
WDT_ACCOUNTS_RECEIVABLE |
DETAIL_CODE |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO |
| DETAIL_CODE_DESC |
NO |
DIMENSION TABLE |
WDT_ACCOUNTS_RECEIVABLE WDT_ACCOUNTS_RECEIVABLE |
DETAIL_CODE_SD DETAIL_CODE_LD |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO NO |
| EFFECTIVE_DATE |
NO |
DIMENSION TABLE |
WDT_ACCOUNTS_RECEIVABLE |
EFFECTIVE_DATE_AGING |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO |
| FUNCTION |
NO |
FACT TABLE |
WFT_ENROLLMENT |
TUITION_CHARGES |
ENROLLMENT |
NO |
| MULTI_SOURCE |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
MULTI_SOURCE |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO |
| MULTI_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE WDT_MULTI_SOURCE |
MULTI_SOURCE_SD MULTI_SOURCE_LD |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO NO |
| PROCESS_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
PROCESS_GROUP |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO |
| SUB_ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME |
SUB_ACADEMIC_PERIOD |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO |
| SUB_ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
SUB_ACADEMIC_PERIOD_SD SUB_ACADEMIC_PERIOD_LD |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO NO |
| TRANSACTION_DATE |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
CALENDAR_YEAR CALENDAR_MONTH |
RECEIVABLE CUSTOMER, RECEIVABLE REVENUE RECEIVABLE CUSTOMER, RECEIVABLE REVENUE |
NO NO |