Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_PERIOD	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	VARCHAR2(63)	STUDENT	ACADEMIC_PERIOD	NO	NO	STUDENT, STUDENT PROGRESS
ACADEMIC_PERIOD_LD	Long description defined in the cleansing process.	VARCHAR2(255)	STUDENT	ACADEMIC_PERIOD_DESC	NO	NO	STUDENT, STUDENT PROGRESS
ACADEMIC_PERIOD_SD	Short description defined in the cleansing process.	VARCHAR2(255)	STUDENT	ACADEMIC_PERIOD_DESC	NO	NO	STUDENT, STUDENT PROGRESS
RETENTION_PERIOD_LIKE	Identifies the academic periods that is the next like academic period for the academic period in this row using the last two characters of the academic period code to match like. For example Fall year 2 is a like for the Fall year 1.	VARCHAR2(150)	ETL GENERATED	NA	NO	NO	STUDENT, STUDENT PROGRESS
RETENTION_PERIOD_SEQUENTIAL	Using the institution defined rules about academic periods that are sequential provides the specific sequential academic period for the academic period in this row. For example Fall is followed by Spring or Spring is followed by Fall.	VARCHAR2(150)	ETL GENERATED	NA	NO	NO	STUDENT, STUDENT PROGRESS
RETENTION_TIME_KEY	Key for the retention time dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT PROGRESS
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	STUDENT, STUDENT PROGRESS  STUDENT PROGRESS
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	STUDENT, STUDENT PROGRESS  STUDENT PROGRESS

Ver: 9.0