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


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 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: Wed Jun 08 20:49:59 2016

Home
Contact Us



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