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 |
|
||||||||||||||
BTE-PLAN-CODE Element: Plan Code | Alpha 4 Contains the user-defined code that represents a benefit plan. |
|
||||||||||||||
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. |
|
||||||||||||||
BTE-TA-PLAN Element: Ta Plan | Alpha 10 |
|
||||||||||||||
BTE-EMPLOYEE-GROUP Element: Group Name | Alpha 10 |
|
||||||||||||||
BTE-POSITION Element: Position | Alpha 12 Contains the user-defined code that represents a position in the company. |
|
||||||||||||||
BTE-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||
BTE-STOP-DATE Element: Stop Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||
BTE-TA-OBJ-ID Element: Obj Id | Numeric 12 Ties the record to teh associated BENEFIT record. |
|
||||||||||||||
BTE-TOTAL-HOURS Element: Bn Hours | Signed 8.4 Store the total elected number of hours from the benefit. |
|
||||||||||||||
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. |
|
||||||||||||||
BTE-STATUS Element: Status | Numeric 1 This field displays the status of the transaction. 0 = Not Updated 1 = Partial Update 2 = Adjusted 9 = Updated |
|
||||||||||||||
BTE-UPDATED-HOURS Element: Bn Hours | Signed 8.4 |
|
||||||||||||||
BTE-UPD-THRU-DATE Element: Upd Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||
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. |
|
||||||||||||||
BTE-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||
BTE-USER-ID Element: User | Alpha 10 (Lower Case) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BTESET1 |
COMPANY PLAN-CODE EMPLOYEE TA-PLAN EMPLOYEE-GROUP POSITION START-DATE |
|
| ||||||||||||||||||||||
BTESET2 |
COMPANY TA-PLAN EMPLOYEE-GROUP EMPLOYEE POSITION PLAN-CODE START-DATE |
|
| ||||||||||||||||||||||
BTESET3 |
COMPANY PLAN-CODE EMPLOYEE START-DATE* EMPLOYEE-GROUP POSITION |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Benefit | BENEFIT |
Required
| |||||||||||||||
Company | PRSYSTEM |
Required
| |||||||||||||||
Employee | EMPLOYEE |
Required
| |||||||||||||||
Employee Group | PERSGROUP |
Required
| |||||||||||||||
Paemployee | PAEMPLOYEE |
Required
| |||||||||||||||
Plan | PLAN |
Required
| |||||||||||||||
Ta Master | TAEEMASTER |
Required
| |||||||||||||||
Ta Plan | TAPLAN |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Position | PAPOSITION |
| |||||||||||||||
Ta Structure | TASTRUCTUR |
|
All trademarks and registered trademarks are the property of their
respective owners.