Lawson - Lawson Software Technical Library - Data File Text for BNACADATES

BNACADATES
UPDATED BY

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY

PPD-COMPANY
Element: Company Hr Numeric 4
Contains the company number.

BN149 BN549

PPD-EMPLOYEE
Element: Employee Numeric 9
Contains the employee number.

BN149 BN549

PPD-REPORT-ENTITY
Element: Report Entity Alpha 5
Contains the Report Entity where the hours were worked.

BN149 BN549

PPD-MP-START-DATE
Element: Date Numeric 8 (yyyymmdd)
Contains the Measurement Period Start Date

BN149 BN549

PPD-MP-STOP-DATE
Element: Date Numeric 8 (yyyymmdd)
Contains the Measurement Period Stop Date.

BN149 BN549

PPD-AP-START-DATE
Element: Date Numeric 8 (yyyymmdd)
Contains the Administrative Period Start Date.

BN149 BN549

PPD-AP-STOP-DATE
Element: Date Numeric 8 (yyyymmdd)
Contains the Administrative Period Stop Date.

BN149 BN255

BN549

PPD-SP-START-DATE
Element: Date Numeric 8 (yyyymmdd)
Contains the Stability Period Start Date.

BN149 BN549

PPD-SP-STOP-DATE
Element: Date Numeric 8 (yyyymmdd)
Contains the Stability Period Stop Date.

BN149 BN549

PPD-ADJ-SP-START
Element: Alphadata1 Alpha 1
Contains the Stability Periods Start value of (Y)es or (N)o. If the Initial Measurement record's Benefit Status = Eligible; and the first Standard Measurement Benefit Status = Not Eligible, then the Stability Period Start date is adjusted.
N = No
Y = Yes

BN149

PPD-TOTAL-HOURS
Element: Hours Signed 7.2
Contains the Total ACA Hours worked during the Measurement Period. The ACA hours pay class hours are defined in BN00.5.

BN149

PPD-AVG-HOURS
Element: Hours Signed 7.2
Contains the Average ACA hours as calculated using Total Hours / Duration.

BN149 BN549

PPD-DURATION-FREQ
Element: Aca Frequency Alpha 1
Contains the Measurement Period Duration Frequency of (W)eeks or (M)onths.
M = Monthly
W = Weekly

BN149 BN549

PPD-DURATION
Element: Aca Duration Numeric 3
Contains the Measurement Period Duration length in either Weeks or Months.

BN149

PPD-ACA-WKLY-HOURS
Element: Aca Duration Numeric 3
Contains the ACA weekly hours found on BN00.5. This value is used to determine whether the employee is eligible or not eligible for benefits.

BN149

PPD-ACA-MNTH-HOURS
Element: Aca Duration Numeric 3
Contains the ACA Monthly Hours found on BN00.5. This value is used to determine whether the employee is eligible or not eligible for benefits.

BN149

PPD-ACA-RCD-TYPE
Element: Alphadata1 Alpha 1
Contains the ACA Record Type of either (I)nitial or (S)tandard. The Initial record is for newly hired employees. Standard records are for employees that that have worked during the full measurement period.
I = Initial
S = Standard

BN149 BN549

PPD-ACA-BN-STATUS
Element: Alphadata1 Alpha 1
Contains the ACA Benefit Status. Valid status are: 1=Eligible 2=Not Eligible 3=Incomplete 4=Terminated
1 = Eligible
2 = Not Eligible
3 = Incomplete
4 = Terminated
5

BN149 BN549

PPD-ACA-HIRE-DATE
Element: From Date Alpha 2
Contains the ACA Hire Date that is used as the starting point for the Initial Measurement Period assessment. Valid values are Hire Date (HI), Adjusted Hire Date (AJ), New Hire Date (NH), Anniversary Date (AN), Seniority Date (SN), Benefit Date 1 (B1), Benefit Date 2 (B2), Benefit Date 3 (B3), Benefit Date 4 (B4), Benefit Date 5 (B5).
HI = Hire Date
AJ = Adjusted Hire Date
NH = New Hire Date
AN = Anniversary Date
SN = Seniority Date
B1 = Benefit Date 1
B2 = Benefit Date 2
B3 = Benefit Date 3
B4 = Benefit Date 4
B5 = Benefit Date 5

BN149 BN549

PPD-NEW-HIRE-DATE
Element: Date Numeric 8 (yyyymmdd)
Contais the employee date of hire using the hire date defined in ACA Hire Date field.

BN149

PPD-TERM-DATE
Element: Date Numeric 8 (yyyymmdd)
Contains the employee's termination date

BN149

PPD-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 BN549

PPD-DATE-STAMP
Element: Date Stamp Numeric 8 (yyyymmdd)
Contains the System Date the record was updated.

BN149 BN549

PPD-TIME-STAMP
Element: Time Stamp Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.

BN149 BN549

PPD-USER-ID
Element: User Alpha 10 (Lower Case)
Contains the User Id of the user who made the change.

BN149 BN549

PPD-CREATE-DATE
Element: Date Stamp Numeric 8 (yyyymmdd)
Contains the system date of when the record was created.

BN149 BN549

PPD-CREATE-TIME
Element: Time Stamp Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was created.

BN149 BN549

PPD-CREATE-USER-ID
Element: User Alpha 10 (Lower Case)
Contains the User Id of the User who created the record.

BN149 BN549