FactPriorEnrollmentSnapshotLoad
 DFT Load FactPriorEnrollment Staging Table (Data Flow Task)
  DataFlow Screenshot
  Properties
Property Value
Name DFT Load FactPriorEnrollment Staging Table
Description Data Flow Task
Precedence Executables none
Contrained Executables none
ID 3bdca31f-a873-4fa3-ba35-1b6e7027c5da
BLOB Temp Storage Path
Buffer Temp Storage Path
Default Buffer Max Rows 10000
Default Buffer Size 10485760
Run In Optimized Mode True
Locale ID English (United States)
Logging Mode UseParentSetting
Forced Execution Value 0
Force Execution Value False
Delay Validation False
Disable False
Disable Event Handlers False
Fail Package On Failure False
Fail Parent On Failure False
Maximum Error Count 1
Isolation Level Serializable
Suspend Required False
Transaction Option Supported
  Components
Name Type Description
12
Updates column values using expressions
10
OLE DB Destination
9
OLE DB Source
  Column Mappings
Component Input Column   Destination Column
DER Add Additional Fields
OLE DB Prior Enrollment Staging
   OLE DB Destination Input
 
ActiveTerm [?]
ActiveTerm
 
EFF_TRM [?]
EFF_TRM
 
Enrolled [?]
Enrolled
 
EnrollmentDate [?]
EnrollmentDate
 
PaidEnrollment [?]
PaidEnrollment
 
PriorRelativeDay [?]
RelativeDay
 
REF_NUM [?]
REF_NUM
 
STDNT_ID [?]
STDNT_ID
  Variables
Name Value Description
Powered by BI Documenter