BNACAIRSHR

UPDATED BY
BN996 BN99.5 BN990 BN991

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PP2-COMPANY
Element: Company Hr		Numeric 4
BN996
PP2-YEAR
Element: Payroll Year		Numeric 4
BN996
PP2-EMPLOYEE
Element: Employee		Numeric 9
BN996
PP2-PARTICIPNT
Element: Participnt		Numeric 9
BN996
PP2-REPORT-ENTITY
Element: Report Entity		Alpha 5
BN996
PP2-TYPE
Element: Alphadata1		Alpha 1

1 = Employee
2 = Retiree
3 = Cobra
4 = Resource
BN996
PP2-TOTAL-HOURS
Element: Hours		Signed 7.2 Occurs 12 Times
BN996
PP2-PRINT-BOX
Element: Alphadata1		Alpha 1 Occurs 12 Times
BN996
PP2-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN996
PP2-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
BN996
PP2-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN996
PP2-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN996
PP2-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
BN996
PP2-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN996


BNACAIRSHR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PP2SET1 COMPANY
YEAR
TYPE
EMPLOYEE
PARTICIPNT
REPORT-ENTITY
BN99.5 BN990
BN991 BN996
PP2SET2 COMPANY
TYPE
EMPLOYEE
PARTICIPNT
YEAR
REPORT-ENTITY
PP2SET3 COMPANY
YEAR
REPORT-ENTITY
TYPE
EMPLOYEE
PARTICIPNT


BNACAIRSHR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Bnacairs BNACAIRS Required
PP2-COMPANY->PPI-COMPANY (PPISET1)
PP2-YEAR->PPI-YEAR
PP2-TYPE->PPI-TYPE
PP2-EMPLOYEE->PPI-EMPLOYEE
PP2-PARTICIPNT->PPI-PARTICIPNT
PP2-REPORT-ENTITY->PPI-REPORT-ENTITY
Company BNCOMPANY Required
PP2-COMPANY->BNC-COMPANY
Employee EMPLOYEE Required
When PP2-TYPE ="1"
OrPP2-TYPE ="2"
PP2-COMPANY->EMP-COMPANY
PP2-EMPLOYEE->EMP-EMPLOYEE
Participnt PARTICIPNT Required
When PP2-TYPE ="3"
PP2-COMPANY->PAR-COMPANY
PP2-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.