Name in AssignmentPro: Comp Worksheet Line Item Current and Previous Effective (view)
Name in Database: vwEQ_COMP_WORKSHEET_LINE_ITEM_CURRENT_AND_PREVIOUS_EFFECTIVE
Description inc. recommended uses and limitations: This view allows reporting on Compensation Worksheets in any status including reporting on Previous and Current Compensation Worksheet details including amounts, currencies and index rates
Tables used in the view:
ASSIGNMENT
COMP_WORKSHEET
COMP_WORKSHEET_DICTIONARY
COMP_WORKSHEET_DICTIONARY_CATEGORY
COMP_WORKSHEET_DICTIONARY_CATEGORY_COMP_WORKSHEET_DICTIONARY
COMP_WORKSHEET_DICTIONARY_CATEGORY_SET
COMP_WORKSHEET_INPUTS_ECA
COMP_WORKSHEET_INPUTS_ORC
COMP_WORKSHEET_LINE_ITEM
COMP_WORKSHEET_LINE_ITEM_INPUTS_AIRINC
COMP_WORKSHEET_LINE_ITEM_INPUTS_MERCER
PAYROLL_SYSTEM_CALENDAR
vwEQ_ACCOUNT_WITH_OVERRIDES
vwEQ_COMP_WORKSHEET_LINE_ITEM_CURRENT_AND_PREVIOUS_EFFECTIVE_BASE
vwEQ_COMP_WORKSHEET_CURRENT_AND_PREVIOUS_EFFECTIVE
Fields contained in the view:
Begin Date
Category Name
Comp Worksheet Dictionary Caption
Comp Worksheet Dictionary Category Comp Worksheet Dictionary Id
Comp Worksheet Dictionary Category Id
Comp Worksheet Dictionary Category Set Id
Comp Worksheet Id
Comp Worksheet Inputs Eca Id
Comp Worksheet Inputs Orc Id
Comp Worksheet Line Item Id
Comp Worksheet Line Item Inputs Airinc Id
Comp Worksheet Line Item Inputs Mercer Id
Comp Worksheet Template Id
Curr Home Country Currency
Curr Home Country Payment Currency
Curr Home Country Payperiod Home Amount
Curr Home Country Payperiod Pay Amount
Curr Home Country Total Amount
Curr Host Country Currency
Curr Host Country Payment Currency
Curr Host Country Payperiod Host Amount
Curr Host Country Payperiod Pay Amount
Curr Host Country Total Amount
Curr Orc Gs Table Index To Use
Curr Primary Amt To Pymt Exchange Rate To Use
Curr Third Currency Exchange Rate To Use
End Date
Exchange Rate
Line Item Caption
Payroll System Calendar Id
Prev Begin Date
Prev Comp Worksheet Id
Prev Comp Worksheet Line Item Id
Prev Comp Worksheet Template Id
Prev End Date
Prev Exchange Rate
Prev Home Country Currency
Prev Home Country Payment Currency
Prev Home Country Payperiod Home Amount
Prev Home Country Payperiod Pay Amount
Prev Home Country Total Amount
Prev Host Country Currency
Prev Host Country Payment Currency
Prev Host Country Payperiod Host Amount
Prev Host Country Payperiod Pay Amount
Prev Host Country Total Amount
Prev Orc Gs Table Index To Use
Prev Payroll System Calendar Id
Prev Primary Account Id
Prev Primary Account Number
Prev Primary Amt To Pymt Exchange Rate To Use
Prev Secondary Account Id
Prev Secondary Account Number
Prev Third Currency Exchange Rate To Use
Primary Account Id
Primary Account Number
Report Title
Secondary Account Id
Secondary Account Number
Sequence In Category
Sequence In Set
Click here for details on how to create a user report to return all fields for a given name in the database.