Tnemhcatta
Tnemhcatta
Tnemhcatta
Hierarchy
Top level Object Level 2 objects Description File Discriminator
An element entry holds the actual payroll element and benefits granted to a worker. These may be ongoing recurring
Element Entry entries, for example, salary, or single period non-recurring entries such as a bonus. ElementEntry
Element entry values are the individual values that are contained in the input values for an element entry. They can be
Element Entry Value defaulted or entered by a user. ElementEntryValue
Component Element Entry An element entry holds the actual payroll element and benefits granted to a worker. These may be ongoing recurring
Discriminator ElementEntry entries, for example, salary, or single period non-recurring entries such as a bonus.
File Name ElementEntry.dat
Date Type Date Effective
Hiearchy Level Top
Component Element Entry An element entry holds the actual payroll element and benefits granted to a worker. These may be ongoing recurring
Discriminator ElementEntry entries, for example, salary, or single period non-recurring entries such as a bonus.
File Name ElementEntry.dat
Date Type Date Effective
Hiearchy Level Top
ElementEntryId Surrogate ID
EffectiveEndDate
EffectiveStartDate
MultipleEntryCount
AssignmentId Foreign Surrogate ID
AssignmentNumber User Key Needs additional annotation
BatchActionId
BatchId
CreatorId
CreatorType
DateEarned
ElementTypeId Foreign Surrogate ID
ElementName User Key
LegislativeDataGroupId Foreign Surrogate ID
LegislativeDataGroupName User Key Needs additional annotation
EntryType
PersonId
Reason
RelationshipId
ReservedInputValueId Foreign Surrogate ID
Subpriority
TargetEntryId
BalanceAdjustmentCostFlag
TerminationId
GUID Fusion GUID A Fusion wide globally unique identifer for the record.
SourceSystemOwner Source System Key ** The name of the source system the record originated from.
SourceSystemId Source System Key ** The unique identifier for this record from the source system.
Customer specified reference for information purposes only. Do not supply values for this attribute, just a
SourceRefTableName=<source-table-name> name for the source system table.
SourceRef001=<source-column-001> Customer specified reference for information purposes only.
SourceRef002=<source-column-002> Customer specified reference for information purposes only.
SourceRef003=<source-column-003> Customer specified reference for information purposes only.
SourceRef004=<source-column-004> Customer specified reference for information purposes only.
SourceRef005=<source-column-005> Customer specified reference for information purposes only.
SourceRef006=<source-column-006> Customer specified reference for information purposes only.
Business Object: Element Entry Component: Element Entry Page 5 of 7
Component Element Entry Value Element entry values are the individual values that are contained in the input values for an element entry. They can be
Discriminator ElementEntryValue defaulted or entered by a user.
File Name ElementEntry.dat
Date Type Date Effective
Hiearchy Level 2
Parent Component Element Entry
Primary
Attribute Name Key Type Alternate User Key attribute for surrogate Ids Integration Object Name Data Type Length Scale Key Mandatory
LegislativeDataGroupName, ElementName,
AssignmentNumber, InputValueName,
ElementEntryValueId Surrogate ID MultipleEntryCount ElementEntryValue Number Yes Yes*
LegislativeDataGroupName, ElementName,
ElementEntryId Parent Surrogate ID AssignmentNumber, MultipleEntryCount ElementEntry Number Yes*
MultipleEntryCount User key
EffectiveEndDate Date Yes Yes
EffectiveStartDate Date Yes Yes
LegislativeDataGroupName, ElementName,
InputValueId Foreign Surrogate ID InputValueName ElementEntry Number
InputValueName User key String
ScreenEntryValue String
PersonId Foreign Surrogate ID AssignmentNumber not integration enabled String
AssignmentNumber User key String
ElementTypeId Foreign Surrogate ID ElementName, LegislativeDataGroupName not integration enabled String
ElementName User key String
LegislativeDataGroupId Foreign Surrogate ID LegislativeDataGroupName not integration enabled String
LegislativeDataGroupName User key String
LegislationCode String
GUID Fusion GUID Raw 16
SourceSystemOwner Source System Key ** String 256
SourceSystemId Source System Key ** String 2000
ElementEntryValueId Surrogate ID