Overview of Payroll Interface Inbound Record Information Component

The Payroll Interface Inbound Record Information component holds the details of payroll data processed by third-party payroll providers, such as earning, deductions, and messages.

Use the PayrollInterfaceInboundRecordInfo discriminator to load Payroll Interface Inbound Record Information records.

When loading a new inbound information record, you supply these PayrollInterfaceInboundRecordInfo attributes.

Attribute

What It's

SourceSystemId / SourceSystemOwner

A unique reference for the record. Supply either a source key or one of these user key attributes: RecordType, PayrollName, LegislativeDataGroupName, PeriodName, BatchCode, FunctionalCategory, SourceType, EntityIdentifier, and IriInformationContext

FLEX:ORA_HRY_PI_INBD_RECORDS_INFO_EFF

The context code for the category of data being loaded.

EFF_CATEGORY_CODE

The code for the EFF Category. For third party payslip information, enter ORA_HRY_INBD_PAYSLIP. For other context, enter ORA_HRY_INBD_PAYROLL.

FunctionalCategory

The functional category of the inbound record. The ORA_HRY_INBD_FUNCTIONAL_CATG lookup validates this category. This value must match up with the parent record's functional category.

RecordType

The type of inbound record. This value must match up with the parent record's record type.

BatchCode

The batch or file identifier. This value must match up with parent record's batch code.

SourceType

The type of entity. Valid source types are Person, Payroll Terms, Payroll Assignment, and Payroll Relationship. This value must match up with the parent record's source type. When supplying the Payslip data, supply Payroll Relationship.

EntityIdentifier

The number or name of the entity. Enter the value depending upon the SourceType.

LegislativeDataGroupName

The name of the legislative data group. This value must match up with the parent record's legislative data group name.

PayrollName

The record's payroll name. This value must match up with the parent record's payroll name.

StartDate

The start date of the Inbound Record. The format is yyyy-mm-dd. Note that this format is different from that of the parent record.

PeriodName

The period name of the record. This value must match up with the parent record's period name.

IriInformationContext

The context code for the category of data. This value is the same as for the FLEX:ORA_HRY_PI_INBD_RECORDS_INFO_EFF attribute.

When loading payment information, you must enter these extensible flexfield attributes:

Attribute

What It's

PaymentType(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYMENT_INFO)

The type of payment, such as cash, check, or electronic funds transfer.

CheckNumber(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYMENT_INFO)

The check number issued to the employee.

BankName(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYMENT_INFO)

The employee's bank name to transfer electronic funds payments.

BranchName(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYMENT_INFO)

The employee's branch name to transfer electronic funds payments.

AccountName(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYMENT_INFO)

The employee's bank account name to transfer electronic funds payments.

AccountNumber(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYMENT_INFO)

The employee's bank account number to transfer electronic funds payments.

IBAN(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYMENT_INFO)

The international bank account number to facilitate the communication and processing of cross-border transactions.

Amount(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYMENT_INFO)

The amount paid to the employee.

Currency(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYMENT_INFO)

The currency of the payment.

PaymentDate(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYMENT_INFO)

The date the instruction was given to transfer the payment from the source bank account to the employee's bank account.

PayrollRunType(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYROLL_INFO)

The type of payroll run, such as regular or supplemental.

PayrollRunSequence(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYROLL_INFO)

The order in which payroll run type is processed.

ElementClassification(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYROLL_INFO)

The primary element classification, such as Standard Earnings or Supplemental Earnings.

ElementName(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYROLL_INFO)

The name of the element.

CostCenter(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYROLL_INFO)

The cost center for employee payments.

CurrentAmount(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYROLL_INFO)

The total amount for the element in the current payroll period.

QuarterToDateAmount(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYROLL_INFO)

The total amount for the element in the current quarter.

YearToDateAmount(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYROLL_INFO)

The total amount for the element in the current financial year.

Currency(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYROLL_INFO)

The currency of the payment.

GeneralLedgerCreditAccount(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYROLL_INFO)

The code of the General Ledger account to credit earnings or deductions.

GeneralLedgerDebitAccount(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_PAYROLL_INFO)

The code of the General Ledger account to debit earnings or deductions.

When loading third-party payslip information, you must enter these extensible flexfield attributes:

Attribute

What It's

NetPayment(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_THIRD_PARTY_PAYSLIP)

The net payment amount.

PayslipViewDate(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_THIRD_PARTY_PAYSLIP)

When loading absence information, you must enter these extensible flexfield attributes:

Attribute

What It's

AbsenceName(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_LEAVE_INFO)

The name of the absence for the employee.

AbsenceBalance(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_LEAVE_INFO)

The balance of hours or days remaining for the balance.

AbsenceUnit(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_LEAVE_INFO)

The total number of absence units.

AbsenceUnitOfMeasure(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_LEAVE_INFO)

The type of unit of measure, such as day or hour.

AbsenceMessage(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_LEAVE_INFO)

The message from the third-party payroll provider containing absence information, such as remaining balance for the employee.

When loading message information, you must enter these extensible flexfield attributes.

Attribute

What It's

MessageType(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_MESSAGE_INFO)

The severity level of the message.

MessageId(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_MESSAGE_INFO)

A short code for the message received from the third-party payroll provider.

MessageText(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_MESSAGE_INFO)

The message from the third-party payroll provider containing information about any errors that occurred during file upload.

OutboundFileName(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_MESSAGE_INFO)

The name of the file sent to the third-party payroll provider.

OutboundFileReceivedDate(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_MESSAGE_INFO)

The date when the outbound file was received by the third-party payroll provider.