BN149 | BN549 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
PPA-COMPANY Element: Company Hr | Numeric 4 Contains the Company Number |
|
||
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 |
|
||
PPA-REPORT-ENTITY Element: Report Entity | Alpha 5 Contains the Report Entity used during the BN149 run |
|
||
PPA-PROCESS-LEVEL Element: Process Lev Hr | Alpha 5 Contains the Process Level used during the BN149 run. |
|
||
PPA-EMPLOYEE Element: Employee | Numeric 9 Occurs 4 Times Contains the employees used during the BN149 run. |
|
||
PPA-GROUP-NAME Element: Group Name | Alpha 10 Contains the Group Name used during the BN149 run. |
|
||
PPA-EMP-STATUS Element: Emp Status | Alpha 2 Occurs 8 Times Contains the Employee Status that were used in the BN149 run. |
|
||
PPA-SALARY-CLASS Element: Salary Class | Alpha 1 Contains the Salary Class used during the BN149 run. |
|
||
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 |
|
||
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 |
|
||
PPA-UPDATE-OPTION Element: Alphadata1 | Alpha 1 Contains the Update Option used when BN149 was ran. 1 = Report Only, 2 = Update. |
|
||
PPA-HDA-BEG-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the Hire Date Analysis begin date. |
|
||
PPA-HDA-END-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the Hire Date Analysis End date. |
|
||
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. |
|
||
PPA-NHMP-DURATION Element: Aca Duration | Numeric 3 Contains the New Hire Measurement Period Duration that was used during the BN149 run. |
|
||
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 |
|
||
PPA-NHAP-DURATION Element: Aca Duration | Numeric 3 Contains the New Hire Administrative Period Duration that was used for the BN149 run. |
|
||
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 |
|
||
PPA-NHSP-DURATION Element: Aca Duration | Numeric 3 Contains the the New Hire Stability Period Duration that was used during the BN149 run. |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
PPA-OGMP-BEG-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the On Going Measurement Period begin date that was used during the BN149 run. |
|
||
PPA-OGMP-END-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the On Going Measuremnt Period End Date that was used during the BN149 run. |
|
||
PPA-OGMP-DURATION Element: Aca Duration | Numeric 3 Contains the On Going Measurement Period Duration used in 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 |
|
||
PPA-OGAP-BEG-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the On Going Administrative Period Begin date used in BN149. |
|
||
PPA-OGAP-END-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the On Going Administrative Period End date that was used during 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. |
|
||
PPA-OGSP-END-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the On Going Stability Period End date that was used during 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. |
|
||
PPA-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) Contains the System Date the record was updated. |
|
||
PPA-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||
PPA-USER-ID Element: User | Alpha 10 (Lower Case) Contains the User Id of the user who made the change. |
|
||
PPA-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) Contains the system date of when the record was created. |
|
||
PPA-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was created. |
|
||
PPA-CREATE-USER-ID Element: User | Alpha 10 (Lower Case) Contains the User Id of the User who created the record. |
|
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 |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Company | BNCOMPANY |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.