RESTRANS FILE
Spending Account Transactions
The Spending Account Transactions file contains reimbursement records for
spending accounts. These transactions are maintained in BN59.1 (Spending
Account Transactions).
REFERENCED BY
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
UPDATED BY
BN430 BN59.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTR-COMPANY Numeric 4 BN59.1
Company Contains the company number.
RTR-START-DATE Numeric 8 (yyyymmdd) BN59.1
Start Date Contains the start date for an
employee's spending account benefit. It
is equal to the BEN-START-DATE in the
BENEFIT file.
RTR-EMPLOYEE Numeric 9 BN59.1
Employee Contains the employee number.
RTR-PLAN-CODE Alpha 4 BN59.1
Plan Contains the user-defined plan code
tied to a plan type of "RS" (Spending
Account).
RTR-DATE Numeric 8 (yyyymmdd) BN59.1
Date Contains a date equal or later than
RTR-START-DATE.
RTR-CHECK-NBR Numeric 8 BN59.1
Payment Number Contains a check number tied to the
employee's reimbursement of expenses.
RTR-TRANS-AMT Signed 11.2 BN59.1
Transaction Amount 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.
RTR-DESC Alpha 30 (Lower Case) BN59.1
Description Contains a description of the
transaction. It can be a description of
services provided.
RESTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTRSET1 COMPANY BN232 BN258
START-DATE BN430
EMPLOYEE
PLAN-CODE
DATE
CHECK-NBR
RTRSET2 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
PLAN-CODE BN105 BN259
START-DATE BN31.1 BN31.2
DATE BN32.1 BN32.2
CHECK-NBR 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 RELATED
NAME 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
|
