BNACAIRSDP

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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPJ-COMPANY
Element: Company Hr		Numeric 4
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-YEAR
Element: Payroll Year		Numeric 4
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-EMPLOYEE
Element: Employee		Numeric 9
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-PARTICIPNT
Element: Participnt		Numeric 9
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-DEPENDENT
Element: Dependent		Numeric 4
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-TYPE
Element: Alphadata1		Alpha 1

1 = Employee
2 = Retiree
3 = Cobra
4 = Resource
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-COVR-MONTH
Element: Alphadata1		Alpha 1 Occurs 13 Times
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-FIRST-NAME
Element: First Name		Alpha 15 (Lower Case)
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-MIDDLE-INIT
Element: Middle Init		Alpha 1
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-LAST-NAME
Element: Last Name		Alpha 30 (Lower Case)
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-NAME-SUFFIX
Element: Name Suffix		Alpha 4 (Lower Case)
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-FICA-NBR
Element: Fica Nbr		Alpha 20
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-BIRTH-DATE
Element: Birth Date		Numeric 8 (yyyymmdd)
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
BN597 BN95.2
BN96.1 BN990
BN991 BN996
PPJ-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN597 BN95.2
BN96.1 BN990
BN991 BN996


BNACAIRSDP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPJSET1 COMPANY
YEAR
TYPE
EMPLOYEE
PARTICIPNT
DEPENDENT
BN297 BN299
BN597 BN95.1
BN95.2 BN96.1
BN99.2 BN99.3
BN99.4 BN99.6
BN990 BN991
BN996
PPJSET2 COMPANY
TYPE
EMPLOYEE
PARTICIPNT
YEAR
DEPENDENT
BN990 BN991
BN996


BNACAIRSDP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
PPJ-COMPANY->BNC-COMPANY
Employee EMPLOYEE Required
When PPJ-TYPE ="1"
OrPPJ-TYPE ="2"
PPJ-COMPANY->EMP-COMPANY
PPJ-EMPLOYEE->EMP-EMPLOYEE
Participnt PARTICIPNT Required
When PPJ-TYPE ="3"
PPJ-COMPANY->PAR-COMPANY
PPJ-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.