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. |
|
||||||||||
PPH-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. |
|
||||||||||
PPH-REPORT-ENTITY Element: Report Entity | Alpha 5 Contains the Report Entity worked from the PRTIME file. |
|
||||||||||
PPH-PROCESS-LEVEL Element: Process Lev Hr | Alpha 5 Contains the Process Level worked from the PRTIME file. |
|
||||||||||
PPH-HM-PROCESS-LEV Element: Process Lev Hr | Alpha 5 Contains the Home Process Level from the PRTIME file. |
|
||||||||||
PPH-TR-DATE Element: Tr Date | Numeric 8 (yyyymmdd) Contains the Time Record Date of the hours worked. |
|
||||||||||
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. |
|
||||||||||
PPH-LOA-HOURS Element: Hours | Signed 7.2 Contains the Leave Of Absence Hours worked as defined in BN54.2. |
|
||||||||||
PPH-EXTERNAL-HOURS Element: Hours | Signed 7.2 Contains the ACA hours imported from an external system and loaded thru BN554 or BN54. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
PPH-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) Contains the system date of when the record was created. |
|
||||||||||
PPH-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was created. |
|
||||||||||
PPH-CREATE-USER-ID Element: User | Alpha 10 (Lower Case) Contains the User Id of the User who created the record. |
|
||||||||||
PPH-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) Contains the System Date the record was updated. |
|
||||||||||
PPH-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||
PPH-USER-ID Element: User Id | Alpha 10 (Lower Case) Contains the User Id of the user who made the change. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PPHSET1 |
COMPANY EMPLOYEE REPORT-ENTITY PROCESS-LEVEL TR-DATE |
|
| ||||||||||||||||
PPHSET2 |
COMPANY EMPLOYEE TR-DATE REPORT-ENTITY PROCESS-LEVEL |
|
| ||||||||||||||||
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 |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Company | BNCOMPANY |
Required
| ||||||
Employee | EMPLOYEE |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.