lcc:logPath lccFERFireworksData-log lcc:method create registration status codes lcc:method create enrollment status codes lcc:flag enableDebugFile YES lcc:flag manual stop before read file YES lcc:flag trackingStatusCodesPath trackingStatusCodes.txt lcc:flag Load source file line processing heartbeat 10000 lcc:flag Status Code Label Earlier:Earlier:True lcc:flag Status Code Label Same:Same:True lcc:flag Status Code Label Later:Later:True lcc:flag Status Code Label Dropped:Dropped:True lcc:flag Status Code Label Dropped Later:Dropped Later:False lcc:flag Term Session Dates Padding Forward Days 3 lcc:flag Audit EMPLID Path auditEMPLID.txt lcc:flag Simulate Date Now 12/30/2022 lcc:maxRecords 200 lcc:termMinusRange 20 lcc:termPlusRange 20 lcc:auditEMPLID ... lcc:statusCodeLabel Earlier Earlier:True lcc:statusCodeLabel Same Same:True lcc:statusCodeLabel Later Later:True lcc:statusCodeLabel Dropped Dropped:True lcc:statusCodeLabel Dropped Later Dropped Later:False lcc:studentEnrollmentStatusCode D Inactive:Dropped lcc:studentEnrollmentStatusCode E Active:Enrolled lcc:studentEnrollmentStatusCode W Inactive:Waiting lcc:studentEnrollmentReasonCode ADRP Inactive:Administrative Drop lcc:studentEnrollmentReasonCode ALIM Inactive:Appointment Limit Exceeded lcc:studentEnrollmentReasonCode CANC Inactive:Dropped (class cancelled) lcc:studentEnrollmentReasonCode CREQ Inactive:Co-Requisite Enrollment lcc:studentEnrollmentReasonCode DROP Inactive:Dropped (was enrolled) lcc:studentEnrollmentReasonCode DRWL Inactive:Dropped (was wait listed) lcc:studentEnrollmentReasonCode ENRL Active:Enrolled lcc:studentEnrollmentReasonCode EWAT Active:Enrolled from Wait List lcc:studentEnrollmentReasonCode FULL Inactive:Section is Full lcc:studentEnrollmentReasonCode RCAP Inactive:Reserve Slots Full lcc:studentEnrollmentReasonCode RCMP Inactive:Related Component lcc:studentEnrollmentReasonCode SLIM Inactive:Session Limit Exceeded lcc:studentEnrollmentReasonCode TIME Inactive:Time Conflict Exsists lcc:studentEnrollmentReasonCode TIMR Inactive:Time Conflict Resolved lcc:studentEnrollmentReasonCode TLIM Inactive:Term Limit Exceeded lcc:studentEnrollmentReasonCode WDRW Inactive:Withdrawn from Class lcc:studentEnrollmentDetailStatusCode ... ... lcc:studentEnrollmentDetailStatusCodeFromPath \\your server\your share$\your folder\FER-fireworks\exports\dataLinkStaging-export-CS-FER-fireworks-ENRL_REQ_ACTION_BE-export.txt lcc:fileSetId file - read term sesssion table lcc:fileSetSkip YES lcc:fileSetEnrollmentProfile NO lcc:fileSetType source lcc:fileSetMethod read term sesssion table lcc:fileSetMode create registration status codes lcc:fileSetMode create enrollment status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath \\your server\your share$\your folder\FER-fireworks\exports\dataLinkStaging-export-CS-FER-fireworks-PS_SESSION_TBL-export.txt lcc:fileSetFlag Column Headers Included YES lcc:fileSetFlag Skip Header Row YES lcc:fileSetFlag maxLinesRead 100 lcc:fileSetSourceColumnNamePrimary STRM lcc:fileSetSourceColumnName STRM lcc:fileSetSourceColumnName SESS_BEGIN_DT lcc:fileSetSourceColumnName CENSUS_DT lcc:fileSetSourceColumnName SIXTY_PCT_DT lcc:fileSetSourceColumnName SESS_END_DT lcc:fileSetId file - read trackingStatusCodes lcc:fileSetSkip YES lcc:fileSetEnrollmentProfile YES lcc:fileSetType source lcc:fileSetMethod read trackingStatusCodes lcc:fileSetMode create registration status codes lcc:fileSetMode create enrollment status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath trackingStatusCodes.txt lcc:fileSetFlag Empty File OK YES lcc:fileSetFlag Column Headers Included YES lcc:fileSetFlag Skip Header Row YES lcc:fileSetFlag maxLinesRead 100 lcc:fileSetSourceColumnNamePrimary EMPLID lcc:fileSetSourceColumnName EMPLID lcc:fileSetSourceColumnName SET DATE lcc:fileSetSourceColumnName SET TIME lcc:fileSetSourceColumnName SCOPE lcc:fileSetSourceColumnName TERM lcc:fileSetSourceColumnName STATUS CODE lcc:fileSetSourceColumnName NUMBER lcc:fileSetSourceColumnName DATE lcc:fileSetId file - read EBT lcc:fileSetSkip YES lcc:fileSetEnrollmentProfile YES lcc:fileSetType source lcc:fileSetMethod read EBT lcc:fileSetMode create enrollment status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath profiles-EBT.txt lcc:fileSetFlag Empty File OK YES lcc:fileSetFlag Column Headers Included YES lcc:fileSetFlag Skip Header Row YES lcc:fileSetFlag maxLinesRead 100 lcc:fileSetSourceColumnNamePrimary EMPLID lcc:fileSetSourceColumnName CAT lcc:fileSetSourceColumnName EMPLID lcc:fileSetSourceColumnName TERM lcc:fileSetSourceColumnName SCOPE lcc:fileSetSourceColumnName STATUS lcc:fileSetSourceColumnName CODES lcc:fileSetSourceColumnName ENROLLMENTS lcc:fileSetSourceColumnName REASON lcc:fileSetSourceColumnName DATE lcc:fileSetId file - MINEnrlDateByTerm lcc:fileSetSkip YES lcc:fileSetEnrollmentProfile YES lcc:fileSetType source lcc:fileSetMethod read MINEnrlDateByTerm lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath \\your server\your share$\your folder\FER-fireworks\exports\dataLinkStaging-export-CS-FER-fireworks-MINEnrlDateByTerm-export.txt lcc:fileSetFlag Column Headers Included YES lcc:fileSetFlag Skip Header Row YES lcc:fileSetFlag maxLinesRead 100 lcc:fileSetSourceColumnNamePrimary EMPLID lcc:fileSetSourceColumnName EMPLID lcc:fileSetSourceColumnName TERM lcc:fileSetSourceColumnName DATE lcc:fileSetId file - MAXDropDateByTerm lcc:fileSetSkip YES lcc:fileSetEnrollmentProfile YES lcc:fileSetType source lcc:fileSetMethod read MAXDropDateByTerm lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath \\your server\your share$\your folder\FER-fireworks\exports\dataLinkStaging-export-CS-FER-fireworks-MAXDropDateByTerm-export.txt lcc:fileSetFlag Column Headers Included YES lcc:fileSetFlag Skip Header Row YES lcc:fileSetFlag maxLinesRead 100 lcc:fileSetSourceColumnNamePrimary EMPLID lcc:fileSetSourceColumnName EMPLID lcc:fileSetSourceColumnName TERM lcc:fileSetSourceColumnName DATE lcc:fileSetId file - enrollment lcc:fileSetSkip YES lcc:fileSetEnrollmentProfile YES lcc:fileSetType source lcc:fileSetMethod read enrollment lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath \\your server\your share$\your folder\FER-fireworks\exports\dataLinkStaging-export-CS-FER-fireworks-PS_STDNT_ENRL-export.txt lcc:fileSetFlag Column Headers Included YES lcc:fileSetFlag Skip Header Row YES lcc:fileSetFlag maxLinesRead 100 lcc:fileSetSourceColumnNamePrimary EMPLID lcc:fileSetSourceColumnName EMPLID lcc:fileSetSourceColumnName STRM lcc:fileSetSourceColumnName CLASS_NBR lcc:fileSetSourceColumnName STDNT_ENRL_STATUS lcc:fileSetSourceColumnName ENRL_STATUS_REASON lcc:fileSetSourceColumnName ENRL_ACTION_LAST lcc:fileSetSourceColumnName ENRL_ACTN_RSN_LAST lcc:fileSetSourceColumnName ENRL_ACTN_PRC_LAST lcc:fileSetSourceColumnName STATUS_DT lcc:fileSetSourceColumnName ENRL_ADD_DT lcc:fileSetSourceColumnName ENRL_DROP_DT lcc:fileSetSourceColumnName UNT_TAKEN lcc:fileSetSourceColumnName LAST_UPD_DT_STMP lcc:fileSetSourceColumnName LAST_UPD_TM_STMP lcc:fileSetSourceColumnName LAST_ENRL_DT_STMP lcc:fileSetSourceColumnName LAST_ENRL_TM_STMP lcc:fileSetSourceColumnName LAST_DROP_DT_STMP lcc:fileSetSourceColumnName LAST_DROP_TM_STMP lcc:fileSetId file - enrollment detail lcc:fileSetSkip YES lcc:fileSetEnrollmentProfile YES lcc:fileSetType source lcc:fileSetMethod read enrollment detail lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath \\your server\your share$\your folder\FER-fireworks\exports\dataLinkStaging-export-CS-FER-fireworks-PS_ENRL_REQ_DETAIL-export.txt lcc:fileSetFlag Column Headers Included YES lcc:fileSetFlag Skip Header Row YES lcc:fileSetFlag maxLinesRead 100 lcc:fileSetSourceColumnNamePrimary EMPLID lcc:fileSetSourceColumnName EMPLID lcc:fileSetSourceColumnName STRM lcc:fileSetSourceColumnName CLASS_NBR lcc:fileSetSourceColumnName ENRL_REQUEST_ID lcc:fileSetSourceColumnName ENRL_REQ_DETL_SEQ lcc:fileSetSourceColumnName ENRL_REQ_ACTION lcc:fileSetSourceColumnName ENRL_ACTION_DT lcc:fileSetSourceColumnName DTTM_STAMP_SEC lcc:fileSetSourceColumnName UNT_TAKEN lcc:fileSetSourceColumnName ENRL_REQ_DETL_STAT lcc:fileSetId file - student status originals lcc:fileSetSkip YES lcc:fileSetEnrollmentProfile YES lcc:fileSetType source lcc:fileSetMethod read student status originals lcc:fileSetMode create registration status codes lcc:fileSetDelimiter , lcc:fileSetPath \\your server\your share$\your folder\FER-fireworks\exports\dataLinkStaging-export-CS-FER-fireworks-studentStatus-export.csv lcc:fileSetFlag Column Headers Included YES lcc:fileSetFlag Skip Header Row YES lcc:fileSetFlag maxLinesRead 100 lcc:fileSetSourceColumnNamePrimary Person Unique Key lcc:fileSetSourceColumnName Person Unique Key lcc:fileSetSourceColumnName Primary lcc:fileSetSourceColumnName Active lcc:fileSetSourceColumnName Status lcc:fileSetSourceColumnName Comments lcc:fileSetSourceColumnName First Name lcc:fileSetSourceColumnName Last Name lcc:fileSetSourceColumnName Email lcc:fileSetSourceColumnName Email Type lcc:fileSetSourceColumnName Student Type lcc:fileSetSourceColumnName Student Status lcc:fileSetSourceColumnName Entry Term lcc:fileSetSourceColumnName Student Status Date lcc:fileSetId file - student status application general lcc:fileSetSkip YES lcc:fileSetEnrollmentProfile YES lcc:fileSetType source lcc:fileSetMethod read application general lcc:fileSetMode create registration status codes lcc:fileSetDelimiter , lcc:fileSetPath \\your server\your share$\your folder\FER-fireworks\exports\dataLinkStaging-export-CS-FER-fireworks-applicationGeneral-allColumns-export.csv lcc:fileSetFlag Column Headers Included YES lcc:fileSetFlag Skip Header Row YES lcc:fileSetFlag maxLinesRead 100 lcc:fileSetSourceColumnNamePrimary Person Unique Key lcc:fileSetSourceColumnName Person Unique Key lcc:fileSetSourceColumnName ADM_APPL_DT lcc:fileSetSourceColumnName Primary lcc:fileSetSourceColumnName Active lcc:fileSetSourceColumnName Application Entry Term lcc:fileSetSourceColumnName Application Type lcc:fileSetSourceColumnName Application Status lcc:fileSetSourceColumnName Application Number lcc:fileSetSourceColumnName ADM_APPL_NBR lcc:fileSetSourceColumnName Application Started lcc:fileSetSourceColumnName EFFDT lcc:fileSetSourceColumnName EFFSEQ lcc:fileSetSourceColumnName APPL_PROG_NBR lcc:fileSetSourceColumnName Application Source lcc:fileSetSourceColumnName Academic Program lcc:fileSetSourceColumnName Academic Plan lcc:fileSetSourceColumnName Career Pathway lcc:fileSetSourceColumnName Concentration lcc:fileSetSourceColumnName Completion Date lcc:fileSetSourceColumnName Application Component lcc:fileSetSourceColumnName Application Processed Date lcc:fileSetSourceColumnName First Name lcc:fileSetSourceColumnName Last Name lcc:fileSetSourceColumnName Email lcc:fileSetSourceColumnName Email Type lcc:fileSetSourceColumnName Student Type lcc:fileSetSourceColumnName Student Status lcc:fileSetSourceColumnName Entry Term lcc:fileSetSourceColumnName Student Status Date lcc:fileSetId file - regBeforeRange lcc:fileSetSkip YES lcc:fileSetEnrollmentProfile YES lcc:fileSetType source lcc:fileSetMethod read reg before range lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath \\your server\your share$\your folder\FER-fireworks\exports\dataLinkStaging-export-CS-FER-fireworks-regBeforeRange-export.txt lcc:fileSetFlag Column Headers Included YES lcc:fileSetFlag Skip Header Row YES lcc:fileSetFlag maxLinesRead 100 lcc:fileSetSourceColumnNamePrimary EMPLID lcc:fileSetSourceColumnName EMPLID lcc:fileSetSourceColumnName Scope_Reg lcc:fileSetSourceColumnName Scope_Before lcc:fileSetSourceColumnName Scope_Range lcc:fileSetSourceColumnName STRM lcc:fileSetSourceColumnName ACAD_CAREER lcc:fileSetSourceColumnName UNT_TERM_TOT lcc:fileSetSourceColumnName UNT_TRNSFR lcc:fileSetSourceColumnName UNT_TAKEN_PRGRSS lcc:fileSetSourceColumnName UNT_INPROG_GPA lcc:fileSetSourceColumnName UNT_INPROG_NOGPA lcc:fileSetSourceColumnName ADMIT_TERM lcc:fileSetSourceColumnName ADM_APPL_NBR lcc:fileSetSourceColumnName APPL_PROG_NBR lcc:fileSetSourceColumnName EFFDT lcc:fileSetSourceColumnName EFFSEQ lcc:fileSetSourceColumnName PROG_ACTION lcc:fileSetId file - profiles lcc:fileSetSkip YES lcc:fileSetEnrollmentProfile YES lcc:fileSetType target lcc:fileSetMethod profiles lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath \lccSQLDataExports\FER-fireworks\exports\profiles.txt lcc:fileSetId file - upload lcc:fileSetSkip YES lcc:fileSetEnrollmentProfile YES lcc:fileSetType target lcc:fileSetMethod upload lcc:fileSetMode create registration status codes lcc:fileSetPath lccFERFireworksData-studentStatus-upload.csv lcc:fileSetDelimiter , lcc:fileSetTargetColumnName Person Unique Key lcc:fileSetTargetColumnName Primary lcc:fileSetTargetColumnName Active lcc:fileSetTargetColumnName Status lcc:fileSetTargetColumnName Comments lcc:fileSetTargetColumnName First Name lcc:fileSetTargetColumnName Last Name lcc:fileSetTargetColumnName Email lcc:fileSetTargetColumnName Email Type lcc:fileSetTargetColumnName Student Type lcc:fileSetTargetColumnName Student Status lcc:fileSetTargetColumnName Entry Term lcc:fileSetTargetColumnName Student Status Date lcc:fileSetId file - profiles - ABT lcc:fileSetSkip YES lcc:fileSetType target lcc:fileSetMethod profiles-ABT lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath profiles-ABT.txt lcc:fileSetId file - profiles - ASSC lcc:fileSetSkip YES lcc:fileSetType target lcc:fileSetMethod profiles-ASSC lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath profiles-ASSC.txt lcc:fileSetId file - profiles - AG lcc:fileSetSkip YES lcc:fileSetType target lcc:fileSetMethod profiles-AG lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath profiles-AG.txt lcc:fileSetId file - profiles - EBT lcc:fileSetSkip YES lcc:fileSetType target lcc:fileSetMethod profiles-EBT lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath profiles-EBT.txt lcc:fileSetId file - profiles - EDBT lcc:fileSetSkip YES lcc:fileSetType target lcc:fileSetMethod profiles-EDBT lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath profiles-EDBT.txt lcc:fileSetId file - profiles - ENRL lcc:fileSetSkip YES lcc:fileSetType target lcc:fileSetMethod profiles-ENRL lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath profiles-ENRL.txt lcc:fileSetId file - profiles - PRF lcc:fileSetSkip YES lcc:fileSetType target lcc:fileSetMethod profiles-PRF lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath profiles-PRF.txt lcc:fileSetId file - profiles - RBR lcc:fileSetSkip YES lcc:fileSetType target lcc:fileSetMethod profiles-RBR lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath profiles-RBR.txt lcc:fileSetId file - profiles - SSO lcc:fileSetSkip YES lcc:fileSetType target lcc:fileSetMethod profiles-SSO lcc:fileSetMode create registration status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath profiles-SSO.txt lcc:fileSetId file - profiles - TRK lcc:fileSetSkip YES lcc:fileSetType target lcc:fileSetMethod profiles-TRK lcc:fileSetMode create registration status codes lcc:fileSetMode create enrollment status codes lcc:fileSetDelimiter [tab] lcc:fileSetPath profiles-TRK.txt lcc:reportStatsPath report-stats.txt