|
|
BNTAGROUP FILE
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 Numeric 4 BN15.1 LP02.1
Element: Company Hr
BTG-PLAN-CODE Alpha 4 BN15.1 LP02.1
Element: Plan Code Contains the user-defined code that
represents a benefit plan.
BTG-TA-PLAN Alpha 10 BN15.1 LP02.1
Element: Ta Plan
BTG-EMPLOYEE-GROUP Alpha 10 BN15.1 LP02.1
Element: Group Name
BTG-EMP-GRP-STATUS Numeric 1 BN15.1 LP02.1
Element: Status Allows user to set up a benefit plan and LP15.1
identify which groups within the TAplan
structure are allowed to buy or sell
hours.
1 = Active
2 = Inactive
BTG-DATE-STAMP Numeric 8 (yyyymmdd) BN15.1 LP02.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
BTG-TIME-STAMP Numeric 6 (hhmmss) BN15.1 LP02.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BTG-USER-ID Alpha 10 (Lower Case) BN15.1 LP02.1
Element: User
BNTAGROUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BTGSET1 COMPANY BN100 BN101
PLAN-CODE BN102 BN103
TA-PLAN BN105 BN15.1
EMPLOYEE-GROUP BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BS32.1 LP15.1
BTGSET2 COMPANY LP02.1
TA-PLAN
EMPLOYEE-GROUP
PLAN-CODE
BNTAGROUP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
