BNTAGROUP

Holds records identifying which employee groups within a plan will allow hours to be bought or sold. When an employee enrolls in a vacation buy/sell benefit plan, the TA master records will be checked to ensure that a valid plan-group combination exists for the employee.

REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN531 BS32.1
ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3


UPDATED BY
BN15.1 LP02.1 LP15.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BTG-COMPANY
Element: Company Hr		Numeric 4
BN15.1 LP02.1
BTG-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the user-defined code that represents a benefit plan.
BN15.1 LP02.1
BTG-TA-PLAN
Element: Ta Plan		Alpha 10
BN15.1 LP02.1
BTG-EMPLOYEE-GROUP
Element: Group Name		Alpha 10
BN15.1 LP02.1
BTG-EMP-GRP-STATUS
Element: Status		Numeric 1
Allows user to set up a benefit plan and identify which groups within the TAplan structure are allowed to buy or sell hours.
1 = Active
2 = Inactive
BN15.1 LP02.1
LP15.1
BTG-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN15.1 LP02.1
BTG-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN15.1 LP02.1
BTG-USER-ID
Element: User		Alpha 10 (Lower Case)
BN15.1 LP02.1


BNTAGROUP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BTGSET1 COMPANY
PLAN-CODE
TA-PLAN
EMPLOYEE-GROUP
BN100 BN101
BN102 BN103
BN105 BN15.1
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 LP15.1
BTGSET2 COMPANY
TA-PLAN
EMPLOYEE-GROUP
PLAN-CODE
LP02.1


BNTAGROUP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Bn Plan PLAN Required
BTG-COMPANY->PLN-COMPANY
"VA"->PLN-PLAN-TYPE
BTG-PLAN-CODE->PLN-PLAN-CODE
Company PRSYSTEM Required
BTG-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee Group PERSGROUP Required
BTG-COMPANY->PRG-COMPANY
BTG-EMPLOYEE-GROUP->PRG-GROUP-NAME
Ta Plan TAPLAN Required
BTG-COMPANY->TAP-COMPANY
BTG-TA-PLAN->TAP-PLAN


BNTAGROUP FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Ta Structure TASTRUCTUR
BTG-COMPANY->TST-COMPANY
BTG-TA-PLAN->TST-PLAN
BTG-EMPLOYEE-GROUP->TST-EMPLOYEE-GROUP
  TST-BEGIN-DATE

File created: Thu Jun 09 11:19:36 2016

Home
Contact Us



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