TK_Rates_Data

Used as the core source for loading the Timekeeper Rates fact table and the Xchange Timekeeper Rates cube in Planning.  This staging table holds rate information by

  • Year

  • Employee

  • Currency Type

    Idx Field Type Maximum Length Required
    1 Year Alphanumeric 4 Yes
    2 Employee_Code Alphanumeric 20 Yes
    3 Currency_Code Alphanumeric 3 Yes
    4 Local_Rate Money   Yes
    5 Base_Rate Money   No
    Summary

    TK_Rates_Data

    Used as the core source for loading the Timekeeper Rates fact table and the Xchange Timekeeper Rates cube in Planning.

    Columns

     

    Year

    Year associated with the Employee Rate values.   Required.

    Employee_Code

    Employee code associated to the employee; must match entry in EmployeeRequired.

    Currency_Code

    Currency code for value in the Local_Rate column; must match entry in Currency; this is meant to validate the local amount. Required.

    Local_Rate

    The employee billing rate in the local currency of the office of the employee specified by Currency_CodeRequired.

    Base_Rate

    The employee billing rate in the base (or reporting) currency. Optional.

    Documentation

     

    What to Load

    Data should be loaded at least for the current planning year.

    Currency Implementation

    Records must be loaded using a consistent currency theme for either a Single-Currency Implementation or a Multi-Currency Implementation; regardless of the implementation, values are loaded into Local and if desired, converted to Base.

    Sample CSV Load File

    This load file is a small sample of a TK_Rates_Data load.

    Sample CSV Load File

    This load file is a small sample of a TK_Rates_Data load.

    Filename: TK_Rates_Data.csv

    2007,00006,USD,850.00,
    2007,00032,USD,675.00,
    2007,00046,USD,340.00,
    2007,00075,USD,750.00,
    2007,00076,USD,725.00,
    2007,00084,USD,695.00,
    2007,00094,USD,725.00,

    Columns

    Year

    Year varchar(

    4

    ) NOT NULL

    Year associated with the Employee Rate values.   Required.

    Field Load File Format
    Type Alphanumeric
    Maximum Length 4
    Required Yes

     

    Employee_Code

    Employee_Code varchar(

    20

    ) NOT NULL

    Employee code associated to the employee; must match entry in EmployeeRequired.

     

    Field Load File Format
    Type Alphanumeric
    Maximum Length 20
    Required Yes

    Currency_Code

    Currency_Code varchar(

    3

    ) NOT NULL

    Currency code for value in the Local_Rate column; must match entry in Currency; this is meant to validate the local amount. Required.

     

     

    Field Load File Format
    Type Alphanumeric
    Maximum Length 3
    Required Yes

    Local_Rate

    Local_Rate money NOT NULL

    The employee billing rate in the local currency of the office of the employee specified by Currency_CodeRequired.

     

     

    Field Load File Format
    Type Money
    Required Yes

    Base_Rate

    Base_Rate money NULL

    The employee billing rate in the base (or reporting) currency. Optional.

     

     

    Field Load File Format

    Type Money
    Required No

     

    What to Load

    Data should be loaded at least for the current planning year.  Historical information may also be loaded for reporting purposes.

    Rates for employees that do not appear in this table will be defaulted to 0.

    Currency Implementation

    Records must be loaded using a consistent currency theme for either a Single-Currency Implementation or a Multi-Currency Implementation; regardless of the implementation, values are loaded into Local and if desired, converted to Base.

    Single-Currency Implementation

    Only a single currency may appear (and must be the same as the base currency) and all records must have that <Currency_Code>.  Typically for most implementations, base currency will be USD.

    If the base amount is not specified, it will be defaulted to the local amount.

    Multi-Currency Implementations

    The amount is specified in the local currency of the office (the office of the employee).  This amount must also be converted to the base currency.  If the <Currency_Code> is the base currency, any amount not having a base value will be defaulted to the local amount.

     

     

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk