Target Column	Business Definition	Database Data Type	Source Name	Source Column
BANNER_ACCT		VARCHAR2(6)
BANNER_INDEX		VARCHAR2(6)
COMMENTS		VARCHAR2(200)
EFFECTIVE_DATE		DATE
EMPLOYMENT_TERM		VARCHAR2(6)
FRS_SUBCODE		VARCHAR2(4)
KWRTWAV_ID		VARCHAR2(9)
LAST_ELIGIBLE_TERM		VARCHAR2(6)
LAST_STATUS		VARCHAR2(2)
LOAD_DATE		DATE
ORIGINAL_ID		VARCHAR2(9)
RECIPIENT_BANNER_ID		VARCHAR2(4000)
RECIPIENT_BIRTH_DATE		DATE
RECIPIENT_FIRST_NAME		VARCHAR2(15)
RECIPIENT_LAST_NAME		VARCHAR2(60)
RECIPIENT_MI		VARCHAR2(15)
RECIPIENT_UID		VARCHAR2(4000)
SPONSOR_CAMPUS		VARCHAR2(3)
SPONSOR_FIRST_NAME		VARCHAR2(15)
SPONSOR_HIRE_DATE		DATE
SPONSOR_LAST_NAME		VARCHAR2(60)
SPONSOR_MI		VARCHAR2(15)
SPONSOR_ORGN_CODE		VARCHAR2(6)
SPONSOR_UID		NUMBER
STATUS_DATE		DATE
TERM		VARCHAR2(6)
TUITION_WAIVER_CODE		VARCHAR2(4)
WF_ID		NUMBER(38)

Ver: