DFT Load Temp Position Table for Verification

Property	Value
Name	DFT Load Temp Position Table for Verification
Description	Data Flow Task
Precedence Executables	none
Contrained Executables	none
ID	0749aec0-9d73-46bf-a2ee-5d715616e929
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

Name	Type	Description
DER Stub Fields	12	Updates column values using expressions
OLE_DEST Load Verification table Position Operations	10	OLE DB Destination
OLE_SRC Verification Temp table from POSITION_A Staging	9	OLE DB Source

Component	Input Column	Destination Column
DER Stub Fields
OLE_DEST Load Verification table Position Operations
OLE DB Destination Input
	Budgeted [?]	Budgeted
	CountOfActiveAssignments [?]	CountOfActiveAssignments
	CountOfInactiveAssignments [?]	CountOfInactiveAssignments
	DateEstablished [?]	DateEstablished
	DateInactivated [?]	DateInactivated
	ExempStatus [?]	ExemptStatus
	FulltimeEquivalent [?]	FulltimeEquivalent
	FunctionCode [?]	FunctionCode
	FunctionDescription [?]	FunctionDescription
	InactiveReason [?]	InactiveReason
	InactiveReasonCode [?]	InactiveReasonCode
	InactiveVacantDateRange [?]	InactiveVacantDateRange
	JobClassCode [?]	JobClassCode
	JobGroup [?]	JobGroup
	JobGroupCode [?]	JobGroupCode
	Location [?]	Location
	LocationCode [?]	LocationCode
	MultipleFunds [?]	MultipleFunds
	PayBasis [?]	PayBasis
	PooledIndicator [?]	PooledIndicator
	PositionAK [?]	PositionAK
	PositionCode [?]	PositionCode
	PositionFulltimeParttime [?]	PositionFulltimeParttime
	PositionStatus [?]	PositionStatus
	PositionTitle [?]	PositionTitle
	PositionType [?]	PositionType
	PositionTypeCode [?]	PositionTypeCode
	PrimarySalaryAccountNumber [?]	PrimarySalaryAccountNumber
	RegularTemporary [?]	RegularTemporary
	RowIsDuplicate [?]	RowIsDuplicate
	RowIsSelected [?]	RowIsSelected
	WeeklyAuthorizedHours [?]	WeeklyAuthorizedHours

Name	Value	Description
User::IncrementalBeginDtTm	May 14 2014 1:03PM	The IncrementalBeginDtTm setting will contain the start date and time for which updates will be extracted. This is a configuration setting from SSIS_Configurations that are set in the Control Package.