PLANMASTER

Time Accrual Plan

Contains the time accrual plan information.

REFERENCED BY
BN138 BN15.1 BN215 HR11.1 HR170 HR511
HR70.1 PA100 PA52.4 PR130 TA146 TA147
TA148 TA170 TA175 TA180 TA181 TA198
TA241 TA242 TA260 TA265 TA270 TA290
TA310 TA341 TA42.1 TA50.1 TA542 TA570
TA60.1 TA65.1 TA65.2 TA65.3 TA70.1 TA70.2
TA80.1 TA81.1


UPDATED BY
TA199 TA20.1 TA20.2 TA20.3 TA20.4 TA20.5
TA40.1 HPLM.1 HR55.1 HR55.2 HR55.3 PR134
PR135 PR32.2 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR35.9
PR36.1 PR530 PR80.1 PR80.4 PR80.2 TA05.1
TA125 TA145 TA220 PR160 PR180 TA195
TA196

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLM-COMPANY
Element: Company Hr
Numeric 4
Contains the number that represents an established company.
TA20.1 TA20.2
TA20.3 TA20.4
TA20.5 TA40.1
PLM-PLAN-NAME
Element: Plan Name
Alpha 10
Contains the plan name. This is verified in the Time Accrual Plan file.
TA20.1 TA20.2
TA20.3 TA20.4
TA20.5 TA40.1
PLM-PLAN-CLASS
Element: Plan Class
Alpha 3
Contains the plan class that groups plans for printing balance information on payments. This is verified in the Plan Class file.
TA20.1 TA40.1
PLM-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
Contains the plan description.
TA20.1 TA40.1
PLM-HRS-PAY-CL
Element: Hrs Pay Cl
Alpha 3
Contains the pay class that tracks spent hours. This is verified in the Pay Class file.
TA20.1
PLM-GROUP-NAME
Element: Group Name
Alpha 10
Contains the employee group. Only employees in this employee group can enroll in the plan.
TA20.1 TA40.1
PLM-BEG-EFF-DATE
Element: Beg Eff Date
Numeric 8 (yyyymmdd)
Contains the date the plan begins accruing.
TA20.1 TA40.1
PLM-END-EFF-DATE
Element: End Eff Date
Numeric 8 (yyyymmdd)
Contains the date the plan stops accruing.
TA20.1 TA40.1
PLM-BEG-ENR-DATE
Element: Beg Enr Date
Numeric 8 (yyyymmdd)
Contains the first date an employee can enroll in the plan.
TA20.1 TA40.1
PLM-END-ENR-DATE
Element: End Enr Date
Numeric 8 (yyyymmdd)
Contains the last date an employee can enroll in the plan.
TA20.1 TA40.1
PLM-ACR-ELIG-CD
Element: Acr Elig Cd
Alpha 1
Contains the value that indicates whether eligible hours equal accrual hours.
N = Hours Not Immediately Eligible
Y = Hours Immediately Eligible
TA20.1
PLM-AUTO-CREATE
Element: Auto Create
Alpha 1
Contains the value that Indicates whether employees enroll in the plan when they are added in HR11.1 (Employee).
N = No,do not add employee to plan
Y = Yes,enter New employee in Plan
TA20.1 TA40.1
PLM-ACR-DIST-CO
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
TA20.1 TA40.1
PLM-ACR-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the accrual accounting unit. This is verified in the General Ledger Account Master file.
TA20.1 TA40.1
PLM-ACR-ACCOUNT
Element: Account
Numeric 6
Contains the accrual account. This is verified in the General Ledger Account Master file.
TA20.1 TA40.1
PLM-ACR-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the accrual subaccount. This is verified in the General Ledger Account Master file.
TA20.1 TA40.1
PLM-EXP-DIST-CO
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
TA20.1 TA40.1
PLM-EXP-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the expense accounting unit. This is verified in the General Ledger Account Master file.
TA20.1 TA40.1
PLM-EXP-ACCOUNT
Element: Account
Numeric 6
Contains the expense account. This is verified in the General Ledger Account Master file.
TA20.1 TA40.1
PLM-EXP-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the expense subaccount. This is verified in the General Ledger Account Master file.
TA20.1 TA40.1
PLM-GL-TRANS
Element: Gl Trans
Alpha 1
Contains the value that indicates whether liability amounts for accrued and eligible hours are posted to the general ledger.
N = Do Not Post To General Ledger
Y = Post To General Ledger
TA20.1 TA40.1
PLM-LIABILITY
Element: Liability
Alpha 1
Contains the value that determines the basis of the liability.
B = Accrued and Eligible hours
E = Eligible hours
N = No liability
TA20.1
PLM-LOS-UNITS
Element: Los Units
Numeric 5
Contains the number of units required to meet the length of service requirement for eligibility in the plan. Units are determined by the value in the Length of Service Unit of Time field.
TA20.1
PLM-LOS-UOT
Element: Los Uot
Alpha 1
Contains the unit of time in which the length of service is measured.
D = Days
H = Hours
M = Months
S = Semimonths
W = Weeks
TA20.1
PLM-LOS-DT-CD
Element: Los Dt Cd
Alpha 2
Contains the value that indicates when the service requirement begins.
AJ = Adjusted hire
HI = Hire
TA20.1
PLM-LOS-PAY-CL
Element: Los Pay Cl
Alpha 3
If the length of service unit is Hours, this field contains the pay class that represents the hours that count toward the eligibility requirement. This is verified in the Pay Class file.
TA20.1
PLM-ENTRY-CD
Element: Entry Cd
Alpha 1
Contains the nearest entry point at which an employee can enroll in the plan.
A = After meeting length service
P = Prior meeting length service
TA20.1
PLM-ENTRY-DAYS
Element: Entry Days
Numeric 4 (mmdd) Occurs 13 Times
Contains the entry points employees can enroll in the plan.
TA20.1
PLM-AS-CYCLE
Element: As Cycle
Alpha 2
Contains the unit of time for each accrual cycle.
AN = Annually
BW = Biweekly
MO = Monthly
QT = Quarterly
SA = Semiannually
SM = Semimonthly
WK = Weekly
TA20.2
PLM-AS-FRM-DT-IND
Element: As Frm Dt Ind
Alpha 2
Contains the date accruals begin.
AJ = Adjusted hire date
HI = Hire date
PE = Plan Entry date
TA20.2
PLM-AS-TO-PR
Element: As To Pr
Alpha 1
Contains the value that indicates whether the accrual cycle adjusts to the payroll cycle.
N = Do not adjust to payroll cycl
Y = Adjust to payroll cycle
TA20.2
PLM-EP-LOS-UNITS
Element: Ep Los Units
Numeric 5
Contains the number of units required before an employee can transfer accrued hours to eligible hours. Units are determined by the value in the Entry Point Length of Service Unit of Time field.
TA20.4
PLM-EP-LOS-UOT
Element: Ep Los Uot
Alpha 1
Contains the unit of time in which the service requirement for transferring accrued hours is measured.
D = Days
H = Hours
M = Months
S = Semimonths
W = Weeks
TA20.4
PLM-EP-LOS-DT-CD
Element: Ep Los Dt Cd
Alpha 2
Contains the value that indicates when the length of service begins.
AJ = Adjusted hire date
HI = Hire date
TA20.4
PLM-EP-LOS-PAY-CL
Element: Ep Los Pay Cl
Alpha 3
Contains the pay class used to track hours for the service requirement. This is verified in the Pay Class file.
TA20.4
PLM-EP-ENTRY-CD
Element: Ep Entry Cd
Alpha 1
Contains the nearest entry point at which employees can transfer accrued hours to eligible hours.
A = After meeting LOS requirement
P = Prior to meeting LOS require
PLM-EP-ENTRY-DAYS
Element: Ep Entry Days
Numeric 4 (mmdd) Occurs 13 Times
Contains the entry points at which employees can transfer accrued accrued hours to eligible hours.
TA20.4
PLM-EP-TO-PR
Element: Ep To Pr
Alpha 1
Contains the value that indicates whether the transfer date matches the payroll cycle.
N = Do not adjust to Payroll cycle
Y = Adjust to Payroll cycle
TA20.4
PLM-EP-CYCLE-IND
Element: Ep Cycle Ind
Alpha 2
Contains the value that indicates how often accrued hours transfer to eligible hours.
AN = Annually
BW = Biweekly
MO = Monthly
QT = Quarterly
SA = Semiannually
SM = Semimonthly
WK = Weekly
TA20.4
PLM-COMPLETE-FLG1
Element: Complete Flg1
Alpha 1
Contains the value that indicates if form TA20.1 (Plan) is complete.
* = TA20.1 (Plan) is complete
" "
TA20.1
PLM-COMPLETE-FLG2
Element: Complete Flg2
Alpha 1
Contains the value that indicates if TA20.2 (Accrual Schedule) is complete.
* = TA20.2 is complete
" "
TA20.2
PLM-COMPLETE-FLG3
Element: Complete Flg3
Alpha 1
Contains the value that indicates if the plan setup is complete. If the plan's accrual hours equal eligible hours, the plan is complete after you complete TA20.3 (Accrual Limit). If the plan's accrual hours do not equal eligible hours, the plan is complete after you complete TA20.5 (Eligibility Limit).
* = TA20.3 or TA20.5 is complete
" "
TA20.1 TA20.2
TA20.4
PLM-ALIMIT-CYCLE
Element: Alimit Cycle
Alpha 1
Contains the value that indicates how often accrual limits are applied.
A = Annually
E = Everytime
M = Monthly
Q = Quarterly
S = Semiannually
TA20.3
PLM-AAPPLY-LIMIT
Element: Aapply Limit
Alpha 1
Contains the value that indicates how often accrual limits are checked.
C = Cyclical
R = Request
TA20.3
PLM-AONE-TIME-LIM
Element: Aone Time Lim
Alpha 1
Contains the value that indicates if the system checks Accrual limits during the next time accrual cycle.
N = No, One time limit
Y = Yes, limits are checked
TA199 TA20.3
PLM-ELIMIT-CYCLE
Element: Elimit Cycle
Alpha 1
Contains the value that indicates how often the system applies eligible limits.
A = Annually
E = Everytime
M = Monthly
Q = Quarterly
S = Semiannually
TA20.5
PLM-EAPPLY-LIMIT
Element: Eapply Limit
Alpha 1
Contains the value that indicates how the system checks eligible limits.
C = Cyclical
R = Request
TA20.5
PLM-EONE-TIME-LIM
Element: Eone Time Lim
Alpha 1
Contains the value that indicates if the system checks eligible limits during the next time accrual cycle.
N = No, One time limit
Y = Yes, limits are checked
TA199 TA20.5
PLM-WEB-AVAILABLE
Element: Web Available
Alpha 1
PLM-WEB-AVAIL-SUPV
Element: Web Avail Supv
Alpha 1
PLM-WEB-DESC
Element: Web Desc
Alpha 15 (Lower Case)
PLM-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
TA40.1
PLM-PLAN-BASIS
Element: Plan Basis
Numeric 2

00 = n/a
01 = Hours
02 = Date
TA40.1
PLM-ACCRUAL-TYPE
Element: Accrual Type
Numeric 2

00 = n/a
01 = No Accrual/Vac Pay only
02 = Accrual-Dollars Only
03 = Accrual-Dollars and Hours
04 = Accrual-User Calc
TA40.1


PLANMASTER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLMSET1 COMPANY
PLAN-NAME
...
BN138 BN15.1
BN215 HPLM.1
HR11.1 HR170
HR511 HR55.1
HR55.2 HR55.3
HR70.1 PA100
PA52.4 PR130
PR134 PR135
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR530 PR80.1
PLMSET2 COMPANY
PLAN-CLASS
PLAN-NAME
KeyChange
PR160 PR180
PR80.2
PLMSET3 COMPANY
COUNTRY-CODE
PLAN-NAME
TA125 TA145
TA195 TA196
TA199 TA20.1
TA20.2 TA20.3
TA20.4 TA20.5
TA220 TA40.1
PLMSET4 COMPANY
COUNTRY-CODE
PLAN-CLASS
PLAN-NAME
KeyChange


PLANMASTER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accrual Acount GLMASTER Required
When PLM-GL-TRANS ="Y"
PLM-COMPANY->GLM-COMPANY
PLM-ACR-ACCT-UNIT->GLM-ACCT-UNIT
PLM-ACR-ACCOUNT->GLM-ACCOUNT
PLM-ACR-SUB-ACCT->GLM-SUB-ACCOUNT
Company PRSYSTEM Required
PLM-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee Group PERSGROUP Required
When PLM-GROUP-NAME !=Spaces
PLM-COMPANY->PRG-COMPANY
PLM-GROUP-NAME->PRG-GROUP-NAME
Ep Los Pay Cl PAYCLASS Required
When PLM-EP-LOS-UOT ="H"
PLM-COMPANY->PCL-COMPANY
PLM-EP-LOS-PAY-CL->PCL-PAY-CLASS
Exp Account GLMASTER Required
When PLM-GL-TRANS ="Y"
PLM-COMPANY->GLM-COMPANY
PLM-EXP-ACCT-UNIT->GLM-ACCT-UNIT
PLM-EXP-ACCOUNT->GLM-ACCOUNT
PLM-EXP-SUB-ACCT->GLM-SUB-ACCOUNT
Hrs Pay Class PAYCLASS Required
PLM-COMPANY->PCL-COMPANY
PLM-HRS-PAY-CL->PCL-PAY-CLASS
Los Pay Class PAYCLASS Required
When PLM-LOS-UOT ="H"
PLM-COMPANY->PCL-COMPANY
PLM-LOS-PAY-CL->PCL-PAY-CLASS
Plan Class PLANCLASS Required
When PLM-PLAN-CLASS !=Spaces
PLM-COMPANY->PLC-COMPANY
PLM-PLAN-CLASS->PLC-PLAN-CLASS


PLANMASTER FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accrual Limit ACTRLIMIT Delete Cascades
PLM-COMPANY->ATL-COMPANY
PLM-PLAN-NAME->ATL-PLAN-NAME
"A"->ATL-LIMIT-TYPE
  ATL-THRU-LIM-CYC
Formula TAFORMULA Required
PLM-COMPANY->TAF-COMPANY
  TAF-CALC-NAME
Pgemployee PGEMPLOYEE
PLM-COMPANY->PGE-COMPANY
  PGE-GROUP-NAME
  PGE-EMPLOYEE
Pgselect PGSELECT
PLM-COMPANY->PGS-COMPANY
  PGS-GROUP-NAME
  PGS-EMPLOYEE
  PGS-SEQ-NBR
Plan Employees EMTAMASTR Delete Restricted
PLM-COMPANY->ETM-COMPANY
PLM-PLAN-NAME->ETM-PLAN-NAME
  ETM-EMPLOYEE
Schedule ACCRSCHED Delete Cascades
PLM-COMPANY->ACS-COMPANY
PLM-PLAN-NAME->ACS-PLAN-NAME
  ACS-THRU-CYCLE
Taeemaster TAEEMASTER
PLM-COMPANY->TEM-COMPANY
  TEM-EMPLOYEE
  TEM-PLAN
  TEM-EMPLOYEE-GROUP
  TEM-POSITION
Transfer Limit ACTRLIMIT Delete Cascades
PLM-COMPANY->ATL-COMPANY
PLM-PLAN-NAME->ATL-PLAN-NAME
"E"->ATL-LIMIT-TYPE
  ATL-THRU-LIM-CYC


File created: Wed Jun 08 20:51:41 2016

Home
Contact Us



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