BNACALOA

UPDATED BY
BN54.2 BN554

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPL-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
BN54.2 BN554
PPL-REPORT-ENTITY
Element: Report Entity
Alpha 5
Contains the Report Entity of the process level.
BN54.2 BN554
PPL-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
Contains the process level inputed in BN54.2.
BN54.2 BN554
PPL-HM-PROCESS-LEV
Element: Process Lev Hr
Alpha 5
Contains the Home Process Level of the employee.
BN54.2 BN554
PPL-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number.
BN54.2 BN554
PPL-SEQ-NBR
Element: Seq Nbr
Numeric 4
Contains the sequence number. The sequence number is incremented by one each time a Leave of Absence is entered for an employee.
BN54.2 BN554
PPL-LOA-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the Leave of Absence date inputed in BN54.2.
BN54.2 BN554
PPL-LOA-HOURS
Element: Hours
Signed 7.2
Contains the Leave of Absence hours inputed from BN54.2.
BN54.2 BN554
PPL-REASON1
Element: Reason
Alpha 10
Contains the LR Reason code inputed from BN54.2
BN54.2 BN554
PPL-REASON2
Element: Reason
Alpha 10
Contains the LR Reason Code inputed from BN54.2.
BN54.2 BN554
PPL-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
Contains the system date of when the record was created.
BN54.2 BN554
PPL-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was created.
BN54.2 BN554
PPL-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the User Id of the User who created the record.
BN54.2 BN554
PPL-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
Contains the System Date the record was updated.
BN54.2 BN554
PPL-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN54.2 BN554
PPL-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the User Id of the user who made the change.
BN54.2 BN554


BNACALOA FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPLSET1 COMPANY
EMPLOYEE
SEQ-NBR
BN54.2 BN554
PPLSET2 COMPANY
EMPLOYEE
LOA-DATE*
PROCESS-LEVEL
SEQ-NBR
BN54.2 BN554


BNACALOA FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
PPL-COMPANY->BNC-COMPANY
Employee EMPLOYEE Required
PPL-COMPANY->EMP-COMPANY
PPL-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.