BNACAIRSDT

REFERENCED BY
BN255


UPDATED BY
BN99.1 BN990 BN991 BN996 BN290 BN297
BN299 BN96.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PP1-COMPANY
Element: Company Hr		Numeric 4
BN990 BN991
PP1-YEAR
Element: Payroll Year		Numeric 4
BN990 BN991
PP1-EMPLOYEE
Element: Employee		Numeric 9
BN990 BN991
PP1-PARTICIPNT
Element: Participnt		Numeric 9
BN990 BN991
PP1-TYPE
Element: Alphadata1		Alpha 1

1 = Employee
2 = Retiree
3 = Cobra
4 = Resource
BN990 BN991
PP1-ACA-FORM
Element: Alphadata1		Alpha 1

B = 1095 B
C = 1095 C
BN990 BN991
PP1-FORM-CREATE
Element: Alphadata1		Alpha 1

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

1 = No; Do not print
2 = Yes; Print
BN99.1
PP1-HM-PROCESS-LEV
Element: Process Lev Hr		Alpha 5
BN990 BN991
PP1-ACA-OFFER
Element: Aca Code		Alpha 2 Occurs 13 Times
BN990 BN991
BN996
PP1-ACA-SAFEHARBOR
Element: Aca Code		Alpha 2 Occurs 13 Times
BN990 BN991
BN996
PP1-ACA-EMP-COST
Element: Emp Pre Cont		Signed 11.2 Occurs 13 Times
BN990 BN991
BN996
PP1-REPORT-ENTITY
Element: Report Entity		Alpha 5 Occurs 13 Times
BN990 BN991
BN996
PP1-RPT-ENT-SOURCE
Element: Alphadata1		Alpha 1 Occurs 13 Times

1 = Home RE
2 = HR History RE
3 = ACA Hours RE
4 = Override
BN990 BN991
BN996
PP1-HIRE-DATE
Element: Date Hired		Numeric 8 (yyyymmdd)
BN990 BN991
PP1-TERM-DATE
Element: Term Date		Numeric 8 (yyyymmdd)
BN990 BN991
PP1-ACA-BN-STATUS
Element: Alphadata1		Alpha 1 Occurs 12 Times
BN990 BN991
PP1-BEN-ENROLL
Element: Alphadata1		Alpha 1 Occurs 12 Times
BN990 BN991
PP1-BEN-PLAN-CODE
Element: Plan Code		Alpha 4 Occurs 12 Times
BN990 BN991
PP1-BEN-START-DT
Element: Start Date		Numeric 8 (yyyymmdd) Occurs 12 Times
BN990 BN991
PP1-BEN-STOP-DT
Element: Stop Date		Numeric 8 (yyyymmdd) Occurs 12 Times
BN990 BN991
PP1-OFR-PRIORITY
Element: Aca Priority		Numeric 5 Occurs 12 Times
BN990 BN991
PP1-OFR-OFFER-CODE
Element: Aca Code		Alpha 2 Occurs 12 Times
BN990 BN991
PP1-OFR-SAFEHARBOR
Element: Aca Code		Alpha 2 Occurs 12 Times
BN990 BN991
PP1-OFR-SELF-INS
Element: Alphadata1		Alpha 1 Occurs 12 Times
BN990 BN991
PP1-OFR-EMP-COST
Element: Emp Pre Cont		Signed 11.2 Occurs 12 Times
BN990 BN991
PP1-OFR-ENTRY-DT
Element: Start Date		Numeric 8 (yyyymmdd) Occurs 12 Times
PP1-OFR-START-DT
Element: Start Date		Numeric 8 (yyyymmdd) Occurs 12 Times
PP1-OFR-PLAN-CD
Element: Plan Code		Alpha 4 Occurs 12 Times
BN990 BN991
PP1-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN990 BN991
PP1-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
BN990 BN991
PP1-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN990 BN991
PP1-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN99.1 BN990
BN991 BN996
PP1-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
BN99.1 BN990
BN991 BN996
PP1-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN99.1 BN990
BN991 BN996


BNACAIRSDT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PP1SET1 COMPANY
YEAR
TYPE
EMPLOYEE
PARTICIPNT
BN255 BN290
BN297 BN299
BN96.1 BN99.1
BN990 BN991
BN996
PP1SET2 COMPANY
TYPE
EMPLOYEE
PARTICIPNT
YEAR


BNACAIRSDT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
PP1-COMPANY->BNC-COMPANY (BNCSET1)
Employee EMPLOYEE Required
When PP1-TYPE ="1"
OrPP1-TYPE ="2"
PP1-COMPANY->EMP-COMPANY
PP1-EMPLOYEE->EMP-EMPLOYEE
Participnt PARTICIPNT Required
When PP1-TYPE ="3"
PP1-COMPANY->PAR-COMPANY
PP1-PARTICIPNT->PAR-PARTICIPNT


BNACAIRSDT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Bnacairs BNACAIRSHR
PP1-COMPANY->PP2-COMPANY
PP1-YEAR->PP2-YEAR
PP1-TYPE->PP2-TYPE
PP1-EMPLOYEE->PP2-EMPLOYEE
PP1-PARTICIPNT->PP2-PARTICIPNT
  PP2-REPORT-ENTITY
Bnacairsdp BNACAIRSDP
PP1-COMPANY->PPJ-COMPANY
PP1-YEAR->PPJ-YEAR
PP1-TYPE->PPJ-TYPE
PP1-EMPLOYEE->PPJ-EMPLOYEE
PP1-PARTICIPNT->PPJ-PARTICIPNT
  PPJ-DEPENDENT
Bnacairshr BNACAIRSHR
PP1-COMPANY->PP2-COMPANY
PP1-YEAR->PP2-YEAR
PP1-TYPE->PP2-TYPE
PP1-EMPLOYEE->PP2-EMPLOYEE
PP1-PARTICIPNT->PP2-PARTICIPNT
  PP2-REPORT-ENTITY

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

Home
Contact Us



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