BNACAHOURS

UPDATED BY
BN149 BN54.1 BN54.2 BN554 BN954 PR195
PR197 PR582 PR82.1 PR85.1 BN254 BN255
BN991 BN996

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPH-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
BN149 BN54.1
BN54.2 BN554
BN954 PR195
PR197 PR582
PR82.1 PR85.1
PPH-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number.
BN149 BN54.1
BN54.2 BN554
BN954 PR195
PR197 PR582
PR82.1 PR85.1
PPH-REPORT-ENTITY
Element: Report Entity
Alpha 5
Contains the Report Entity worked from the PRTIME file.
BN149 BN54.1
BN54.2 BN554
BN954 PR195
PR197 PR582
PR82.1 PR85.1
PPH-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
Contains the Process Level worked from the PRTIME file.
BN54.1 BN54.2
BN554 BN954
PR195 PR197
PR582 PR82.1
PR85.1
PPH-HM-PROCESS-LEV
Element: Process Lev Hr
Alpha 5
Contains the Home Process Level from the PRTIME file.
BN54.1 BN54.2
BN554 BN954
PR195 PR197
PR582 PR82.1
PR85.1
PPH-TR-DATE
Element: Tr Date
Numeric 8 (yyyymmdd)
Contains the Time Record Date of the hours worked.
BN54.1 BN54.2
BN554 BN954
PR195 PR197
PR582 PR82.1
PR85.1
PPH-PRTIME-HOURS
Element: Hours
Signed 7.2
Contains the hours worked from the PRTIME table in the ACA pay class found in BN00.5.
BN54.1 BN954
PR195 PR197
PR582 PR82.1
PR85.1
PPH-LOA-HOURS
Element: Hours
Signed 7.2
Contains the Leave Of Absence Hours worked as defined in BN54.2.
BN54.1 BN54.2
BN554
PPH-EXTERNAL-HOURS
Element: Hours
Signed 7.2
Contains the ACA hours imported from an external system and loaded thru BN554 or BN54.
BN54.1 BN554
PPH-ACA-HOURS
Element: Hours
Signed 7.2
Contains the hours that are used for ACA calculation when BN149 is run. If External hours are not = zero, ACA Hours = External Hours + LOA Hours, otherwise ACA Hours = PRTime Hours + LOA Hours.
BN149 BN54.1
PPH-ACA-OBJ-ID
Element: Obj Id
Numeric 12
Contains the ACA Object Id. This ID is generated in BN149 and links the run from BNACAPARM, BNACADATES, and BNACAHOURS.
BN149
PPH-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
Contains the system date of when the record was created.
BN54.1 BN54.2
BN554 BN954
PR195 PR197
PR582 PR82.1
PR85.1
PPH-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was created.
BN54.1 BN54.2
BN554 BN954
PR195 PR197
PR582 PR82.1
PR85.1
PPH-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the User Id of the User who created the record.
BN54.1 BN54.2
BN554 BN954
PR195 PR197
PR582 PR82.1
PR85.1
PPH-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
Contains the System Date the record was updated.
BN149 BN54.1
BN54.2 BN554
BN954 PR195
PR197 PR582
PR82.1 PR85.1
PPH-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN149 BN54.1
BN54.2 BN554
BN954 PR195
PR197 PR582
PR82.1 PR85.1
PPH-USER-ID
Element: User Id
Alpha 10 (Lower Case)
Contains the User Id of the user who made the change.
BN149 BN54.1
BN54.2 BN554
BN954 PR195
PR197 PR582
PR82.1 PR85.1


BNACAHOURS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPHSET1 COMPANY
EMPLOYEE
REPORT-ENTITY
PROCESS-LEVEL
TR-DATE
BN254 BN54.1
BN554 BN954
PR195 PR197
PR582 PR82.1
PR85.1
PPHSET2 COMPANY
EMPLOYEE
TR-DATE
REPORT-ENTITY
PROCESS-LEVEL
BN149 BN255
BN54.1 BN54.2
BN954 BN991
BN996
PPHSET3 COMPANY
REPORT-ENTITY
PROCESS-LEVEL
EMPLOYEE
TR-DATE
PPHSET4 COMPANY
REPORT-ENTITY
PROCESS-LEVEL
TR-DATE
EMPLOYEE
PPHSET5 COMPANY
TR-DATE
EMPLOYEE
REPORT-ENTITY
PROCESS-LEVEL


BNACAHOURS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
PPH-COMPANY->BNC-COMPANY (BNCSET1)
Employee EMPLOYEE Required
PPH-COMPANY->EMP-COMPANY
PPH-EMPLOYEE->EMP-EMPLOYEE


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

Home
Contact Us



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