Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CITY	Address city, town or municipality.	VARCHAR2(63)	ADDRESS ETL GENERATED INSTITUTION	CITY NA CITY	NO NO NO	NO	PROSPECTIVE STUDENT  ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT  INSTITUTION
COUNTY	County code.	VARCHAR2(63)	ADDRESS ADMISSIONS_APPLICATION INSTITUTION	COUNTY COUNTY_ADMIT COUNTY	NO NO NO	NO	ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT  ADMISSIONS APPLICATION  INSTITUTION
COUNTY_LD	Long description for the county.	VARCHAR2(255)	ADDRESS ADMISSIONS_APPLICATION INSTITUTION	COUNTY_DESC COUNTY_DESC_ADMIT COUNTY_DESC	NO NO NO	NO	ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT  ADMISSIONS APPLICATION  INSTITUTION
COUNTY_SD	Short description for the county.	VARCHAR2(255)	ADDRESS ADMISSIONS_APPLICATION INSTITUTION	COUNTY_DESC COUNTY_DESC_ADMIT COUNTY_DESC	NO NO NO	NO	ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT  ADMISSIONS APPLICATION  INSTITUTION
NATION	Nation code.	VARCHAR2(63)	ADDRESS ADMISSIONS_APPLICATION	NATION NATION_ADMIT	NO NO	NO	ADMISSIONS RECRUITMENT  ADMISSIONS APPLICATION, INSTITUTION, PROSPECTIVE STUDENT
NATION_LD	Long description for the nation.	VARCHAR2(255)	ADDRESS ADMISSIONS_APPLICATION INSTITUTION	NATION_DESC NATION_DESC_ADMIT NATION_DESC	NO NO NO	NO	ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT  ADMISSIONS APPLICATION  INSTITUTION
NATION_SD	Short description for the nation.	VARCHAR2(255)	ADDRESS ADMISSIONS_APPLICATION INSTITUTION	NATION_DESC NATION_DESC_ADMIT NATION_DESC	NO NO NO	NO	ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT  ADMISSIONS APPLICATION  INSTITUTION
POSTAL_CODE	Address postal code.	VARCHAR2(63)	ADDRESS ADMISSIONS_APPLICATION INSTITUTION	POSTAL_CODE POSTAL_CODE_ADMIT POSTAL_CODE	NO NO NO	NO	ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT  ADMISSIONS APPLICATION  INSTITUTION
POSTAL_KEY	Key of the postal dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, INSTITUTION, PROSPECTIVE STUDENT
STATE_PROVINCE	State or province code.	VARCHAR2(63)	ADDRESS ADMISSIONS_APPLICATION INSTITUTION	STATE_PROVINCE STATE_ADMIT STATE_PROVINCE	NO NO NO	NO	ADMISSIONS RECRUITMENT, PROSPECTIVE STUDENT  ADMISSIONS APPLICATION  INSTITUTION
STATE_PROVINCE_LD	Long description for the state or province.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, INSTITUTION, PROSPECTIVE STUDENT
STATE_PROVINCE_SD	Short description for the state or province.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, INSTITUTION, PROSPECTIVE STUDENT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, INSTITUTION, PROSPECTIVE STUDENT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, INSTITUTION, PROSPECTIVE STUDENT

Ver: 8.1