BNACAIRS

UPDATED BY
BN597 BN95.1 BN95.2 BN99.1 BN99.2 BN99.3
BN99.4 BN99.6 BN990 BN991 BN996 BN00.7
BN290 BN297 BN299 BN96.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPI-COMPANY
Element: Company Hr
Numeric 4
BN597 BN95.1
BN990 BN991
BN996
PPI-YEAR
Element: Payroll Year
Numeric 4
BN597 BN95.1
BN990 BN991
BN996
PPI-EMPLOYEE
Element: Employee
Numeric 9
BN597 BN95.1
BN990 BN991
BN996
PPI-PARTICIPNT
Element: Participnt
Numeric 9
BN597 BN95.1
BN990 BN991
BN996
PPI-REPORT-ENTITY
Element: Report Entity
Alpha 5
BN597 BN95.1
BN990 BN991
BN996
PPI-RPT-ENT-OPT
Element: Alphadata1
Alpha 1

1 = Home RE
2 = HR History RE
3 = ACA Hours RE
BN597 BN990
BN991 BN996
PPI-HM-PROCESS-LEV
Element: Process Lev Hr
Alpha 5
BN990 BN991
BN996
PPI-TYPE
Element: Alphadata1
Alpha 1

1 = Employee
2 = Retiree
3 = Cobra
4 = Resource
BN597 BN95.1
BN990 BN991
BN996
PPI-ACA-FORM
Element: Alphadata1
Alpha 1

B = 1095-B
C = 1095-C
BN597 BN95.1
BN990 BN991
BN996
PPI-FORM-CREATE
Element: Alphadata1
Alpha 1

1 = No - System derived
2 = Yes - System derived
3 = No - Parameter override
BN597 BN95.1
BN990 BN991
BN996
PPI-FORM-OVERRIDE
Element: Alphadata1
Alpha 1

1 = No; Do not print
2 = Yes; Print
BN597 BN95.1
BN99.1 BN990
BN991 BN996
PPI-ACA-OFFER
Element: Aca Code
Alpha 2 Occurs 13 Times
BN597 BN95.1
BN990 BN991
BN996
PPI-ACA-SAFEHARBOR
Element: Aca Code
Alpha 2 Occurs 13 Times
BN597 BN95.1
BN990 BN991
BN996
PPI-ACA-EMP-COST
Element: Emp Pre Cont
Signed 11.2 Occurs 13 Times
BN597 BN95.1
BN990 BN991
BN996
PPI-BEN-START-DT
Element: Start Date
Numeric 8 (yyyymmdd)
BN597 BN95.1
BN990 BN991
BN996
PPI-FICA-NBR
Element: Fica Nbr
Alpha 20
BN597 BN95.1
BN990 BN991
BN996
PPI-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
BN597 BN95.1
BN990 BN991
BN996
PPI-MIDDLE-INIT
Element: Middle Init
Alpha 1
BN597 BN95.1
BN990 BN991
BN996
PPI-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
BN597 BN95.1
BN990 BN991
BN996
PPI-NAME-SUFFIX
Element: Name Suffix
Alpha 4 (Lower Case)
BN597 BN95.1
BN990 BN991
BN996
PPI-BIRTH-DATE
Element: Birth Date
Numeric 8 (yyyymmdd)
BN597 BN95.1
BN990 BN991
BN996
PPI-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
BN597 BN95.1
BN990 BN991
BN996
PPI-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
BN597 BN95.1
BN990 BN991
BN996
PPI-CITY
Element: Addr1
Alpha 30 (Lower Case)
BN597 BN95.1
BN990 BN991
BN996
PPI-STATE
Element: State
Alpha 2
BN597 BN95.1
BN990 BN991
BN996
PPI-ZIP
Element: Zip
Alpha 10
BN597 BN95.1
BN990 BN991
BN996
PPI-COUNTRY-CODE
Element: Country Code
Alpha 2
BN597 BN95.1
BN990 BN991
BN996
PPI-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN597 BN95.1
BN990 BN991
BN996
PPI-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN597 BN95.1
BN990 BN991
BN996
PPI-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN597 BN95.1
BN990 BN991
BN996
PPI-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN597 BN95.1
BN99.1 BN990
BN991 BN996
PPI-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
BN597 BN95.1
BN99.1 BN990
BN991 BN996
PPI-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN597 BN95.1
BN99.1 BN990
BN991 BN996
PPI-ACA-RPT-ENT
Element: Report Entity
Alpha 5
PPI-RPT-STRUCTURE
Element: Alphadata1
Alpha 1

B = Benefit Reporting Structure
P = Payroll Reporting Structure
BN990 BN991
BN996


BNACAIRS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPISET1 COMPANY
YEAR
TYPE
EMPLOYEE
PARTICIPNT
REPORT-ENTITY
BN00.7 BN290
BN297 BN299
BN597 BN95.1
BN95.2 BN96.1
BN99.1 BN99.2
BN99.3 BN99.4
BN99.6 BN990
BN991 BN996
PPISET2 COMPANY
TYPE
EMPLOYEE
PARTICIPNT
YEAR
REPORT-ENTITY
PPISET3 COMPANY
YEAR
REPORT-ENTITY
TYPE
EMPLOYEE
PARTICIPNT
BN297 BN299


BNACAIRS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Bnacairshr BNACAIRSHR Required
PPI-COMPANY->PP2-COMPANY
PPI-YEAR->PP2-YEAR
PPI-TYPE->PP2-TYPE
PPI-EMPLOYEE->PP2-EMPLOYEE
PPI-PARTICIPNT->PP2-PARTICIPNT
PPI-REPORT-ENTITY->PP2-REPORT-ENTITY
Company BNCOMPANY Required
PPI-COMPANY->BNC-COMPANY
Employee EMPLOYEE Required
When PPI-TYPE ="1"
OrPPI-TYPE ="2"
PPI-COMPANY->EMP-COMPANY
PPI-EMPLOYEE->EMP-EMPLOYEE
Participnt PARTICIPNT Required
When PPI-TYPE ="3"
PPI-COMPANY->PAR-COMPANY
PPI-PARTICIPNT->PAR-PARTICIPNT


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

Home
Contact Us



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