BNTAEMPBAL

UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN531 BS32.1
LP138 LP34.1 BN15.1 HR11.1 HR511 LP02.1
LP100 LP101 LP102 LP103 LP131 LP180
LP197 LP31.1 LP80.1 PA100 PA52.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BTE-COMPANY
Element: Company Hr
Numeric 4
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-PLAN-CODE
Element: Plan Code
Alpha 4
Contains the user-defined code that represents a benefit plan.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-TA-PLAN
Element: Ta Plan
Alpha 10
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-EMPLOYEE-GROUP
Element: Group Name
Alpha 10
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-STOP-DATE
Element: Stop Date
Numeric 8 (yyyymmdd)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-TA-OBJ-ID
Element: Obj Id
Numeric 12
Ties the record to teh associated BENEFIT record.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-TOTAL-HOURS
Element: Bn Hours
Signed 8.4
Store the total elected number of hours from the benefit.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-PERCENT
Element: Percent
Signed 7.3
Stores the percent of the total hours that apply to this group or position. Used only when there are multiple master records for a TA plan.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
0 = Not Updated
1 = Partial Update
2 = Adjusted
9 = Updated
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP138 LP34.1
BTE-UPDATED-HOURS
Element: Bn Hours
Signed 8.4
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP138 LP34.1
BTE-UPD-THRU-DATE
Element: Upd Date
Numeric 8 (yyyymmdd)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP138 LP34.1
BTE-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.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP138 LP34.1
BTE-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP138 LP34.1
BTE-USER-ID
Element: User
Alpha 10 (Lower Case)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP138 LP34.1


BNTAEMPBAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BTESET1 COMPANY
PLAN-CODE
EMPLOYEE
TA-PLAN
EMPLOYEE-GROUP
POSITION
START-DATE
BN100 BN101
BN102 BN103
BN105 BN15.1
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BS32.1 LP138
LP34.1
BTESET2 COMPANY
TA-PLAN
EMPLOYEE-GROUP
EMPLOYEE
POSITION
PLAN-CODE
START-DATE
HR11.1 HR511
LP02.1 LP100
LP101 LP102
LP103 LP131
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
BTESET3 COMPANY
PLAN-CODE
EMPLOYEE
START-DATE*
EMPLOYEE-GROUP
POSITION
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP138 LP34.1


BNTAEMPBAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Benefit BENEFIT Required
BTE-COMPANY->BEN-COMPANY
"VA"->BEN-PLAN-TYPE
BTE-EMPLOYEE->BEN-EMPLOYEE
BTE-START-DATE->BEN-START-DATE
BTE-PLAN-CODE->BEN-PLAN-CODE
Company PRSYSTEM Required
BTE-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
BTE-COMPANY->EMP-COMPANY
BTE-EMPLOYEE->EMP-EMPLOYEE
Employee Group PERSGROUP Required
BTE-COMPANY->PRG-COMPANY
BTE-EMPLOYEE-GROUP->PRG-GROUP-NAME
Paemployee PAEMPLOYEE Required
BTE-COMPANY->PEM-COMPANY
BTE-EMPLOYEE->PEM-EMPLOYEE
Plan PLAN Required
BTE-COMPANY->PLN-COMPANY
"VA"->PLN-PLAN-TYPE
BTE-PLAN-CODE->PLN-PLAN-CODE
Ta Master TAEEMASTER Required
BTE-COMPANY->TEM-COMPANY
BTE-EMPLOYEE->TEM-EMPLOYEE
BTE-TA-PLAN->TEM-PLAN
BTE-EMPLOYEE-GROUP->TEM-EMPLOYEE-GROUP
BTE-POSITION->TEM-POSITION
Ta Plan TAPLAN Required
BTE-COMPANY->TAP-COMPANY
BTE-TA-PLAN->TAP-PLAN


BNTAEMPBAL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When BTE-POSITION !=Spaces
BTE-COMPANY->POS-COMPANY
BTE-POSITION->POS-POSITION
  POS-EFFECT-DATE
Ta Structure TASTRUCTUR
BTE-COMPANY->TST-COMPANY
BTE-TA-PLAN->TST-PLAN
BTE-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.