BNACAPARM

UPDATED BY
BN149 BN549

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPA-COMPANY
Element: Company Hr
Numeric 4
Contains the Company Number
BN149 BN549
PPA-RPT-ENT-OPT
Element: Alphadata1
Alpha 1
Contains the Report Entity Option used to run the BN149 report. Valid options are 0=Process Level, 1=RE Company, 2=RE Process Level, 3=RE All
0 = Process Level
1 = RE Company
2 = RE Process Level
3 = RE All
BN149
PPA-REPORT-ENTITY
Element: Report Entity
Alpha 5
Contains the Report Entity used during the BN149 run
BN149
PPA-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
Contains the Process Level used during the BN149 run.
BN149
PPA-EMPLOYEE
Element: Employee
Numeric 9 Occurs 4 Times
Contains the employees used during the BN149 run.
BN149
PPA-GROUP-NAME
Element: Group Name
Alpha 10
Contains the Group Name used during the BN149 run.
BN149
PPA-EMP-STATUS
Element: Emp Status
Alpha 2 Occurs 8 Times
Contains the Employee Status that were used in the BN149 run.
BN149
PPA-SALARY-CLASS
Element: Salary Class
Alpha 1
Contains the Salary Class used during the BN149 run.
BN149
PPA-DISPLAY-FICA
Element: Alphadata1
Alpha 1
Contains the value used during the BN149 run. Value 1 displays the Employee number, Value 2 displays the Social Security Number on the report.
1 = No
2 = Yes
BN149
PPA-EMPLOYEE-SEQ
Element: Alphadata1
Alpha 1
Contains the employee sequence of which BN149 was run. Option 1 is by Alpha, Option 2 is by employee.
1 = Alpha
2 = Numeric
BN149
PPA-UPDATE-OPTION
Element: Alphadata1
Alpha 1
Contains the Update Option used when BN149 was ran. 1 = Report Only, 2 = Update.
BN149
PPA-HDA-BEG-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the Hire Date Analysis begin date.
BN149
PPA-HDA-END-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the Hire Date Analysis End date.
BN149
PPA-OGIAPO-END-DT
Element: Date
Numeric 8 (yyyymmdd)
Contains the Completion as of date to re-analyze an employee in an Initial Administrative Period equal to or before the date with the ACA Status that is Incomplete.
BN149
PPA-NHMP-DURATION
Element: Aca Duration
Numeric 3
Contains the New Hire Measurement Period Duration that was used during the BN149 run.
BN149
PPA-NHMP-FREQ
Element: Aca Frequency
Alpha 1
Contains the New Hire Measurement Period frequency of either Monthly or Weekly that was used during the BN149 run.
W = Weekly
M = Monthly
BN149
PPA-NHAP-DURATION
Element: Aca Duration
Numeric 3
Contains the New Hire Administrative Period Duration that was used for the BN149 run.
BN149
PPA-NHAP-FREQ
Element: Aca Frequency
Alpha 1
Contains the New Hire Administrative frequency of either Daily, Weekly, or Monthly that was used during the BN149 run.
D = Days
W = Weeks
M = Months
BN149
PPA-NHSP-DURATION
Element: Aca Duration
Numeric 3
Contains the the New Hire Stability Period Duration that was used during the BN149 run.
BN149
PPA-NHSP-FREQ
Element: Aca Frequency
Alpha 1
Contains the New Hire Stability Period Frequency of Daily, Weekly, or Monthly that was used during the BN149 run.
D = Days
W = Weeks
M = Months
BN149
PPA-HIRE-DATE
Element: From Date
Alpha 2
Contains the Hire Date value that was used during the BN149 run. The 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
PPA-FIRST-MONTH
Element: Alphadata1
Alpha 1
Contains the First of Next Month value that was used during the BN149 run. The valid values are Yes or No.
1 = No
2 = Yes
BN149
PPA-OGMP-BEG-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the On Going Measurement Period begin date that was used during the BN149 run.
BN149
PPA-OGMP-END-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the On Going Measuremnt Period End Date that was used during the BN149 run.
BN149
PPA-OGMP-DURATION
Element: Aca Duration
Numeric 3
Contains the On Going Measurement Period Duration used in BN149.
BN149
PPA-OGMP-FREQ
Element: Aca Frequency
Alpha 1
Contains the On Going Measurement Period frequency used for the measuremet period end date.
W = Weeks
M = Months
BN149
PPA-OGAP-BEG-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the On Going Administrative Period Begin date used in BN149.
BN149
PPA-OGAP-END-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the On Going Administrative Period End date that was used during BN149.
BN149
PPA-OGSP-BEG-DATE
Element: Date
Numeric 8 (yyyymmdd)
Calculate the On Going Stability Period begin date that was used during the BN149 run.
BN149
PPA-OGSP-END-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the On Going Stability Period End date that was used during BN149.
BN149
PPA-ACA-WKLY-HOURS
Element: Aca Duration
Numeric 3
Contains the ACA Weekly Hours used in the BN149 run.
PPA-ACA-MTH-HOURS
Element: Aca Duration
Numeric 3
Contains the ACA Monthly Hours used in the BN149 run.
PPA-ACA-OBJ-ID
Element: Obj Id
Numeric 12
Contains the ACA Object Id generated in the BN149 run. This ID links the run from BNACAPARM, BNACADATES, and BNACAHOURS.
BN149 BN549
PPA-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
Contains the System Date the record was updated.
BN149 BN549
PPA-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN149 BN549
PPA-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the User Id of the user who made the change.
BN149 BN549
PPA-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
Contains the system date of when the record was created.
BN149 BN549
PPA-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was created.
BN149 BN549
PPA-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the User Id of the User who created the record.
BN149 BN549


BNACAPARM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPASET1 COMPANY
ACA-OBJ-ID
PPASET2 COMPANY
RPT-ENT-OPT
REPORT-ENTITY
PROCESS-LEVEL
CREATE-DATE
ACA-OBJ-ID


BNACAPARM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
PPA-COMPANY->BNC-COMPANY (BNCSET1)


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

Home
Contact Us



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