RESTRANS

Spending Account Transactions

The Spending Account Transactions file contains reimbursement records for spending accounts. These transactions are maintained in BN59.1 (Spending Account Transactions).
UPDATED BY
BN430 BN59.1 BN59.2 BN59.3 BN232 BN258
BN100 BN101 BN102 BN103 BN105 BN259
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN531
BN70.1 BN71.1 BN72.1 BS32.1 HR170 HR70.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTR-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
BN59.1
RTR-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
Contains the start date for an employee's spending account benefit. It is equal to the BEN-START-DATE in the BENEFIT file.
BN59.1
RTR-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number.
BN59.1
RTR-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the user-defined plan code tied to a plan type of "RS" (Spending Account).
BN59.1
RTR-DATE
Element: Date		Numeric 8 (yyyymmdd)
Contains a date equal or later than RTR-START-DATE.
BN59.1
RTR-CHECK-NBR
Element: Check Nbr		Numeric 8
Contains a check number tied to the employee's reimbursement of expenses.
BN59.1
RTR-TRANS-AMT
Element: Trans Amt		Signed 11.2
Contains the eligible expense the employee submitted to the employer for reimbursement from his/her reserve account. If the PLN-PAY-EXP-FLG is equal to "C," the total of the transaction amounts cannot exceed the BEN-YTD-CONT. If the PLN-PAY-EXP-FLG is equal to "A," the total transactions cannot exceed the BEN-EMP-PRE-CONT plus BEN-CMP-FLX-CONT.
BN59.1
RTR-DESC
Element: Description		Alpha 30 (Lower Case)
Contains a description of the transaction. It can be a description of services provided.
BN59.1


RESTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTRSET1 COMPANY
START-DATE
EMPLOYEE
PLAN-CODE
DATE
CHECK-NBR
BN232 BN258
BN430
RTRSET2 COMPANY
EMPLOYEE
PLAN-CODE
START-DATE
DATE
CHECK-NBR
BN100 BN101
BN102 BN103
BN105 BN259
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN59.1 BN59.2
BN59.3 BN70.1
BN71.1 BN72.1
BS32.1 HR170
HR70.1


RESTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Benefit BENEFIT Required
RTR-COMPANY->BEN-COMPANY
"RS"->BEN-PLAN-TYPE
RTR-EMPLOYEE->BEN-EMPLOYEE
RTR-START-DATE->BEN-START-DATE
RTR-PLAN-CODE->BEN-PLAN-CODE
Company BNCOMPANY Required
RTR-COMPANY->BNC-COMPANY
Company Name PRSYSTEM Required
RTR-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
RTR-COMPANY->EMP-COMPANY
RTR-EMPLOYEE->EMP-EMPLOYEE
Plan PLAN Required
RTR-COMPANY->PLN-COMPANY
"RS"->PLN-PLAN-TYPE
RTR-PLAN-CODE->PLN-PLAN-CODE

File created: Wed Jun 08 20:48:09 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.