Body
Additional Details -
Brief Summary:
UW Extended Campus (Formerly UW Extension) works with all 26 University of Wisconsin System campuses to support their continuing education efforts. UW-Platteville offers many of the UW Extended Campus Collaborative Degree Programs (CDP). UW-Platteville is a host campus for students where student will apply and enroll in our Student Information System in which this integration will send the data needed up to UW Extended Campus to manage the student information in a central location for all UW Extended Campus Degrees.
Name:
UW-Extended Campus - https://ce.uwex.edu/campus-partnerships/
PASS Navigation and UW-Platteville URL:
UWP Satellite System > Manage Distance Learning > Report > CDP Extract
Population Selection:
Admissions Data - Based on a start term (from run control), will select all applications where term is equal to or greater than start term using admission application records, and program status is in (Applicant, Active in Program, Admitted, Cancelled, Prematic) , and Academic Plan is one of the following: (APC_XUG, HCA_XGR, ABT_XGR, CYB_XGR, GCABI_XGR, GCSLSL_XGR)
Registration Data - Based on a start term (from run control), will select all students where term is equal to or greater than start term using student career record, student program, plan record and enrollment record, and program status is not (Discontinued, Completed, Dismissed) , and Academic Plan Type is not a Minor, and Class Session is CPA, and Subject is in (APC, HCA, and ABT, and CYB).
Full Population is selected and used for each run. (Not delta)
Application Level:
PASS Process Scheduler - Application Engine (DLH017)
Interface Type:
Two flat comma separated file
File name "ADM_PLT_YYYY_MM_DD.csv" and "REG_PLT_YYYY_MM_DD.csv", YYYY = Year, MM = Month, DD = Day
Stored locally at psdata1:PSDropBox\Extracts\cdp\data\
Frequency/Recurrence:
PASS to psdata1 - Weekdays 9pm
SFTP from psdata1 to UW-Extension - Weekdays 9:45pm
Backup - Past 7 files Weekly - Weekdays 9:45pm
Owner:
Continuing Education
Functional Support Contact Name:
Randy Mentz
Technical Details:
Flat file contains the following fields:
Admissions file fields:
INSTITUTION = Hard coded to "PLT"
PROGRAM = Student Plan conversion: APC_XUG=BSAPC, HCA_XGR=MSHCA, ABT_XGR=MSABT, CYB_XGR=MSCYB, GCABI_XGR=GCABI, GCSLSL_XGR=GCSLSL
CAMPUS_ID = EMPLID
LAST_NAME = Primary First Name
FIRST_NAME = Primary Last Name
MIDDLE_NAME = Not set/sent
BIRTH_DATE = Date of Birth
HOME_STREET_1 = Home Address Line 1
HOME_STREET_2 = Home Address Line 2
HOME_CITY = Home City
HOME_STATE_PROVINCE = Home State
HOME_POSTAL_CODE = Home Postal Code
HOME_COUNTRY_CODE = Home Country Code
LOCAL_STREET_1 = Local Address Line 1
LOCAL_STREET_2 = Local Address Line 2
LOCAL_CITY = Local City
LOCAL_STATE_PROVINCE = Local State
LOCAL_POSTAL_CODE = Local Postal Code
LOCAL_COUNTRY_CODE = Local Country Code
CAMPUS_EMAIL_ADDRESS = Campus Email Address
OTHER_EMAIL_ADDRESS = Home Email Address
HOME_PHONE = Home Phone formatted 999-999-9999
CELL_PHONE = Cell Phone formatted 999-999-9999
ADMISSION_STATUS = From PS_ADM_APPL_PROG.PROG_STATUS. Converted to: AP = Applicant or AC, AD, PM = Admitted or CN.WADM, CN.WAPP = Not Interested or CN.DENY = Denied
ADMISSION_DATE = From PS_ADM_APPL_PROG.ACTION_DT where Program Status = AD or AC.
ADMISSION_TERM = From PS_ADM_APPL_PROG.ADMIT_TERM, shortened to first two characters of the term name and name ex. FA2018
APPL_ID = From PS_ADM_APPL_PROG.ADM_APPL_NBR
PROGRAM_ACTION = Blank/Empty
ACTION_REASON_CODE = Blank/Empty
ADVISOR_NAME = Blank/Empty
ADVISING_HOLD = Blank/Empty
Registration file fields:
INSTITUTION = Hard coded to "PLT"
PROGRAM = Student Plan conversion: APC_XUG=BSAPC, HCA_XGR=MSHCA, ABT_XGR=MSABT, CYB_XGR=MSCYB, Otherwise use Academic Plan Code
CAMPUS_ID = EMPLID
LAST_NAME = Primary First Name
FIRST_NAME = Primary Last Name
MIDDLE_NAME = Not set/sent
BIRTH_DATE = Date of Birth
HOME_STREET_1 = Home Address Line 1
HOME_STREET_2 = Home Address Line 2
HOME_CITY = Home City
HOME_STATE_PROVINCE = Home State
HOME_POSTAL_CODE = Home Postal Code
HOME_COUNTRY_CODE = Home Country Code
LOCAL_STREET_1 = Local Address Line 1
LOCAL_STREET_2 = Local Address Line 2
LOCAL_CITY = Local City
LOCAL_STATE_PROVINCE = Local State
LOCAL_POSTAL_CODE = Local Postal Code
LOCAL_COUNTRY_CODE = Local Country Code
CAMPUS_EMAIL_ADDRESS = Campus Email Address
OTHER_EMAIL_ADDRESS = Home Email Address
HOME_PHONE = Home Phone formatted 999-999-9999
CELL_PHONE = Cell Phone formatted 999-999-9999
COURSE_REGISTRATION_TERM = From PS_STDNT_CAR_TERM.STRM, shortened to first two characters of the term name and name ex. FA2018
COURSE_SUBJECT_CODE = From PS_CLASS_TBL_SE_VW.SUBJECT
COURSE_CATALOG_NUMBER = From PS_CLASS_TBL_SE_VW.CATALOG_NBR
COURSE_REGISTRATION_DATE = From PS_CLASS_TBL_SE_VW.ENRL_ADD_DT
COURSE_DROP_DATE = From PS_CLASS_TBL_SE_VW.ENRL_DROP_DT
GENDER = Sex
VETERAN = Blank/Empty
HISPANIC_LATINO = Blank/Empty
CUBAN = Blank/Empty
MEXICAN = Blank/Empty
PUERTO_RICAN = Blank/Empty
OTHER_HISPANIC_LATINO = Blank/Empty
AFRICAN_AMERICAN = Blank/Empty
AM_INDIAN_AK_NATIVE = Blank/Empty
HAWAIIAN_PAC_ISLAND = Blank/Empty
CAMBODIAN = Blank/Empty
HMONG = Blank/Empty
LAOTIAN = Blank/Empty
VIETNAMESE = Blank/Empty
OTHER_ASIAN = Blank/Empty
WHITE = Blank/Empty
ADVISOR_NAME = Blank/Empty
ECCP_STUDENT = Blank/Empty