Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACCOUNTS_RECEIVABLE_KEY	Key for the accounts receivable dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
BILL_DATE_AGING	Date used for aging the details on the receivable account that specifies when the detail was billed to the person or entity.	VARCHAR2(63)	RECEIVABLE_ACCOUNT_DETAIL	BILL_DATE	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
BILL_DATE_AGING_LD	Long description for the bill date aging.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
BILL_DATE_AGING_SD	Short description for the bill date aging.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
CATEGORY	Category used to group types of detail code transactions for reporting. For example, registration tuition and fees, deposits, contracts, etc..	VARCHAR2(63)	RECEIVABLE_ACCOUNT_DETAIL	CATEGORY	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
CATEGORY_LD	Long description for the category code.	VARCHAR2(255)	RECEIVABLE_ACCOUNT_DETAIL	CATEGORY_DESC	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
CATEGORY_SD	Short description for the category code.	VARCHAR2(255)	RECEIVABLE_ACCOUNT_DETAIL	CATEGORY_DESC	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
DETAIL_CODE	Identifier for every charge or payment recorded on a receivable account.	VARCHAR2(63)	RECEIVABLE_ACCOUNT_DETAIL	DETAIL_CODE	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
DETAIL_CODE_LD	Long text description for the detail code that describes the charge or payment.	VARCHAR2(255)	RECEIVABLE_ACCOUNT_DETAIL	DETAIL_CODE_DESC	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
DETAIL_CODE_SD	Short text description for the detail code that describes the charge or payment.	VARCHAR2(255)	RECEIVABLE_ACCOUNT_DETAIL	DETAIL_CODE_DESC	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
EFFECTIVE_DATE_AGING	Date used for aging the details on the receivable account that specifies when the detail was entered as effective for billing purposes.	VARCHAR2(63)	RECEIVABLE_ACCOUNT_DETAIL	EFFECTIVE_DATE	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
EFFECTIVE_DATE_AGING_LD	Long description for the effective date aging.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
EFFECTIVE_DATE_AGING_SD	Short description for the effective date aging.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

Ver: 9.0