|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_SRC Check Summary Data |
| Description | OLE DB Source |
| Up Stream Components | none |
| Down Stream Components | |
| ID | 1130 |
| Component Class ID | {BCEFE59B-6819-47F7-A125-63753B33ABB7} |
| Contact Info | OLE DB Source;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7 |
| Identification String | component "OLE_SRC Check Summary Data" (1130) |
| Is Default Locale | True |
| Pipeline Version | 0 |
| Uses Dispositions | True |
| Validate External Metadata | True |
| Version | 7 |
Connections
| Name | Connection Manager | Description |
OleDbConnection |
Custom Properties
| Name | Value |
AccessMode |
2 |
AlwaysUseDefaultCodePage |
False |
CommandTimeout |
0 |
DefaultCodePage |
1252 |
OpenRowset |
|
OpenRowsetVariable |
|
ParameterMapping |
|
SqlCommand |
SELECT CAST(PAY_CHECK_DATE AS DATETIME) AS CheckDateAK ,PERSON_ID AS EmployeeAK ,CAST(ISNULL(PAY_CHECK_ISSUE_DATE, '19000101') AS DATETIME) AS CheckIssuedDateAK ,CAST(ISNULL(PAYROLL_PROCESS_DATE, '19000101') AS DATETIME) AS PayrollProcessedDateAK ,CAST(ISNULL(CHECK_TYPE, 'N/A') AS VARCHAR(3)) AS CheckTypeAK ,CAST(ISNULL(PAY_CHECK_NUMBER, 0) AS INT) AS CheckNumber ,CAST( CASE WHEN UNPROCESSED_IND = 0 THEN 1 ELSE 0 END AS SMALLINT) AS CheckProcessed ,CAST(CHECK_VOID_CANCEL_IND AS SMALLINT) AS CheckVoidedCancelled ,CAST(PAY_BANK_DIRECT_DEPOSIT_IND AS SMALLINT) AS DirectDeposit ,CAST( CASE WHEN REISSUE_IND = 1 OR MANUAL_REISSUE = 1 THEN 1 ELSE 0 END AS SMALLINT) AS CheckReissued ,CAST(ISNULL(TOTAL_NORMAL_HOURS, 0) AS NUMERIC(11,2)) AS HoursNormal ,CAST(ISNULL(TOTAL_OVERTIME_HOURS, 0) AS NUMERIC(11,2)) AS HoursOvertime ,CAST(ISNULL(TOTAL_GROSS, 0) AS NUMERIC(11,2)) AS Gross ,CAST(ISNULL(TOTAL_GROSS_ADJ, 0) AS NUMERIC(11,2)) AS GrossAdjusted ,CAST(ISNULL(TOTAL_GROSS_REG, 0) AS NUMERIC(11,2)) AS GrossRegular ,CAST(ISNULL(TOTAL_GROSS_OT, 0) AS NUMERIC(11,2)) AS GrossOvertime ,CAST(ISNULL(TOTAL_GROSS_REG_ADJ, 0) AS NUMERIC(11,2)) AS GrossRegularAjusted ,CAST(ISNULL(TOTAL_GROSS_OT_ADJ, 0) AS NUMERIC(11,2)) AS GrossOvertimeAdjusted ,CAST(ISNULL(TOTAL_GROSS_MINUS_TAXES, 0) AS NUMERIC(11,2)) AS GrossMinusTaxes ,CAST(ISNULL(TOTAL_BENEFITS, 0) AS NUMERIC(11,2)) AS Benefits ,CAST(ISNULL(TOTAL_BENEFIT_ADJ, 0) AS NUMERIC(11,2)) AS BenefitsAdjusted ,CAST(ISNULL(TOTAL_TAXABLE_BENEFITS, 0) AS NUMERIC(11,2)) AS BenefitsTaxable ,CAST(ISNULL(TOTAL_TAXABLE_BENEFIT_ADJ, 0) AS NUMERIC(11,2)) AS BenefitsTaxableAdjusted ,CAST(ISNULL(TOTAL_PRE_TAX_DEDUCTIONS, 0) AS NUMERIC(11,2)) AS DeductionsPreTax ,CAST(ISNULL(TOTAL_PRE_TAX_DEDUCTION_ADJ, 0) AS NUMERIC(11,2)) AS DeductionsPreTaxAdjustments ,CAST(ISNULL(TOTAL_POST_TAX_DEDUCTIONS, 0) AS NUMERIC(11,2)) AS DeductionsPostTax ,CAST(ISNULL(TOTAL_POST_TAX_DEDUCTION_ADJ, 0) AS NUMERIC(11,2)) AS DeductionsPostTaxAdjustments ,CAST(ISNULL(TOTAL_TAXES, 0) AS NUMERIC(11,2)) AS Taxes ,CAST(ISNULL(TOTAL_TAX_ADJ , 0) AS NUMERIC(11,2)) AS TaxesAdjusted ,CAST(ISNULL(CHECK_NET, 0) AS NUMERIC(11,2)) AS CheckNet FROM CHECK_SUMMARY_A CheckSum WHERE CheckSum.UNPROCESSED_IND = 0 |
SqlCommandVariable |
User::Get_HoursWorked_ReportByDay |
Input Columns
| Name | ID | LineageID |
Output Columns
| Name | ID | LineageID |
Benefits |
2651 |
2651 |
BenefitsAdjusted |
2654 |
2654 |
BenefitsTaxable |
2657 |
2657 |
BenefitsTaxableAdjusted |
2660 |
2660 |
CheckDateAK |
2597 |
2597 |
CheckIssuedDateAK |
2600 |
2600 |
CheckNet |
2681 |
2681 |
CheckNumber |
2609 |
2609 |
CheckProcessed |
2612 |
2612 |
CheckReissued |
2621 |
2621 |
CheckTypeAK |
2606 |
2606 |
CheckVoidedCancelled |
2615 |
2615 |
DeductionsPostTax |
2669 |
2669 |
DeductionsPostTaxAdjustments |
2672 |
2672 |
DeductionsPreTax |
2663 |
2663 |
DeductionsPreTaxAdjustments |
2666 |
2666 |
DirectDeposit |
2618 |
2618 |
EmployeeAK |
2376 |
2376 |
ErrorCode |
1142 |
1142 |
ErrorColumn |
1143 |
1143 |
Gross |
2630 |
2630 |
GrossAdjusted |
2633 |
2633 |
GrossMinusTaxes |
2648 |
2648 |
GrossOvertime |
2639 |
2639 |
GrossOvertimeAdjusted |
2645 |
2645 |
GrossRegular |
2636 |
2636 |
GrossRegularAjusted |
2642 |
2642 |
HoursNormal |
2624 |
2624 |
HoursOvertime |
2627 |
2627 |
PayrollProcessedDateAK |
2603 |
2603 |
Taxes |
2675 |
2675 |
TaxesAdjusted |
2678 |
2678 |
Benefits |
2650 |
2650 |
BenefitsAdjusted |
2653 |
2653 |
BenefitsTaxable |
2656 |
2656 |
BenefitsTaxableAdjusted |
2659 |
2659 |
CheckDateAK |
2596 |
2596 |
CheckIssuedDateAK |
2599 |
2599 |
CheckNet |
2680 |
2680 |
CheckNumber |
2608 |
2608 |
CheckProcessed |
2611 |
2611 |
CheckReissued |
2620 |
2620 |
CheckTypeAK |
2605 |
2605 |
CheckVoidedCancelled |
2614 |
2614 |
DeductionsPostTax |
2668 |
2668 |
DeductionsPostTaxAdjustments |
2671 |
2671 |
DeductionsPreTax |
2662 |
2662 |
DeductionsPreTaxAdjustments |
2665 |
2665 |
DirectDeposit |
2617 |
2617 |
EmployeeAK |
2375 |
2375 |
Gross |
2629 |
2629 |
GrossAdjusted |
2632 |
2632 |
GrossMinusTaxes |
2647 |
2647 |
GrossOvertime |
2638 |
2638 |
GrossOvertimeAdjusted |
2644 |
2644 |
GrossRegular |
2635 |
2635 |
GrossRegularAjusted |
2641 |
2641 |
HoursNormal |
2623 |
2623 |
HoursOvertime |
2626 |
2626 |
PayrollProcessedDateAK |
2602 |
2602 |
Taxes |
2674 |
2674 |
TaxesAdjusted |
2677 |
2677 |
| Powered by BI Documenter |
