|
|
PLANMASTER FILE
Time Accrual Plan
Contains the time accrual plan information.
REFERENCED BY
AC550 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
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR36.1 PR530 PR80.1 PR80.2 TA05.1
TA125 TA145 TA146 TA147 TA148 TA170
TA175 TA180 TA181 TA198 TA220 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 PR160 PR180 TA195 TA196
UPDATED BY
TA199 TA20.1 TA20.2 TA20.3 TA20.4 TA20.5
TA40.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLM-COMPANY Numeric 4 TA20.1 TA20.2
Element: Company Contains the number that represents an TA20.3 TA20.4
established company. TA20.5 TA40.1
PLM-PLAN-NAME Alpha 10 TA20.1 TA20.2
Element: From Plan NameContains the plan name. This is TA20.3 TA20.4
verified in the Time Accrual Plan file. TA20.5 TA40.1
PLM-PLAN-CLASS Alpha 3 TA20.1 TA40.1
Element: Plan Class Contains the plan class that groups
plans for printing balance information
on payments. This is verified in the
Plan Class file.
PLM-DESCRIPTION Alpha 30 (Lower Case) TA20.1 TA40.1
Element: Description Contains the plan description.
PLM-HRS-PAY-CL Alpha 3 TA20.1
Element: Hours Pay ClasContains the pay class that tracks
spent hours. This is verified in the Pay
Class file.
PLM-GROUP-NAME Alpha 10 TA20.1 TA40.1
Element: Group Name Contains the employee group. Only
employees in this employee group can
enroll in the plan.
PLM-BEG-EFF-DATE Numeric 8 (yyyymmdd) TA20.1 TA40.1
Beginning Effective Contains the date the plan begins
Date accruing.
PLM-END-EFF-DATE Numeric 8 (yyyymmdd) TA20.1 TA40.1
Element: Z Contains the date the plan stops
accruing.
PLM-BEG-ENR-DATE Numeric 8 (yyyymmdd) TA20.1 TA40.1
Beginning Contains the first date an employee can
Enrollment Date enroll in the plan.
PLM-END-ENR-DATE Numeric 8 (yyyymmdd) TA20.1 TA40.1
Element: End EnrollmentContains the last date an employee can
enroll in the plan.
PLM-ACR-ELIG-CD Alpha 1 TA20.1
Accrual Eligible Contains the value that indicates
Code whether eligible hours equal accrual
hours.
N = Hours Not Immediately Eligible
Y = Hours Immediately Eligible
PLM-AUTO-CREATE Alpha 1 TA20.1 TA40.1
Element: Auto Create 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
PLM-ACR-DIST-CO Numeric 4 TA20.1 TA40.1
Element: Acr Dist Co
PLM-ACR-ACCT-UNIT Alpha 15 TA20.1 TA40.1
Accrual Accounting Contains the accrual accounting unit.
Unit This is verified in the General Ledger
Account Master file.
PLM-ACR-ACCOUNT Numeric 6 TA20.1 TA40.1
Accrual Account Contains the accrual account. This is
Number verified in the General Ledger Account
Master file.
PLM-ACR-SUB-ACCT Numeric 4 TA20.1 TA40.1
Accrual Subaccount Contains the accrual subaccount. This
Number is verified in the General Ledger
Account Master file.
PLM-EXP-DIST-CO Numeric 4 TA20.1 TA40.1
Element: Exp Dist Co
PLM-EXP-ACCT-UNIT Alpha 15 TA20.1 TA40.1
Element: Accounting UniContains the expense accounting unit.
This is verified in the General Ledger
Account Master file.
PLM-EXP-ACCOUNT Numeric 6 TA20.1 TA40.1
Element: Account Contains the expense account. This is
verified in the General Ledger Account
Master file.
PLM-EXP-SUB-ACCT Numeric 4 TA20.1 TA40.1
Element: Subaccount Contains the expense subaccount. This
is verified in the General Ledger
Account Master file.
PLM-GL-TRANS Alpha 1 TA20.1 TA40.1
General Ledger Contains the value that indicates
Transaction 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
PLM-LIABILITY Alpha 1 TA20.1
Element: Liability Contains the value that determines the
basis of the liability.
B = Accrued and Eligible hours
E = Eligible hours
N = No liability
PLM-LOS-UNITS Numeric 5 TA20.1
Length of Service Contains the number of units required
Units 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.
PLM-LOS-UOT Alpha 1 TA20.1
Length of Service Contains the unit of time in which the
Unit of Time length of service is measured.
D = Days
H = Hours
M = Months
S = Semimonths
W = Weeks
PLM-LOS-DT-CD Alpha 2 TA20.1
Length of Service Contains the value that indicates when
Date Code the service requirement begins.
AJ = Adjusted hire
HI = Hire
PLM-LOS-PAY-CL Alpha 3 TA20.1
Length of Service If the length of service unit is Hours,
Pay Class this field contains the pay class that
represents the hours that count toward
the eligibility requirement. This is
verified in the Pay Class file.
PLM-ENTRY-CD Alpha 1 TA20.1
Element: Entry Code Contains the nearest entry point at
which an employee can enroll in the
plan.
A = After meeting length service
P = Prior meeting length service
PLM-ENTRY-DAYS Numeric 4 (mmdd) Occurs 13 Times TA20.1
Element: Entry Days Contains the entry points employees can
enroll in the plan.
PLM-AS-CYCLE Alpha 2 TA20.2
Accrual Schedule Contains the unit of time for each
Cycle accrual cycle.
AN = Annually
BW = Biweekly
MO = Monthly
QT = Quarterly
SA = Semiannually
SM = Semimonthly
WK = Weekly
PLM-AS-FRM-DT-IND Alpha 2 TA20.2
Accrual Schedule Contains the date accruals begin.
From Date Ind AJ = Adjusted hire date
HI = Hire date
PE = Plan Entry date
PLM-AS-TO-PR Alpha 1 TA20.2
Accrual Schedule to Contains the value that indicates
Payroll whether the accrual cycle adjusts to the
payroll cycle.
N = Do not adjust to payroll cycl
Y = Adjust to payroll cycle
PLM-EP-LOS-UNITS Numeric 5 TA20.4
Entry Point LOS Contains the number of units required
Units 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.
PLM-EP-LOS-UOT Alpha 1 TA20.4
Entry Point LOS Contains the unit of time in which the
Unit Of Time service requirement for transferring
accrued hours is measured.
D = Days
H = Hours
M = Months
S = Semimonths
W = Weeks
PLM-EP-LOS-DT-CD Alpha 2 TA20.4
Entry Point LOS Contains the value that indicates when
Date Code the length of service begins.
AJ = Adjusted hire date
HI = Hire date
PLM-EP-LOS-PAY-CL Alpha 3 TA20.4
Entry Point LOS Pay Contains the pay class used to track
Class hours for the service requirement. This
is verified in the Pay Class file.
PLM-EP-ENTRY-CD Alpha 1
Entry Point Entry Contains the nearest entry point at
Code which employees can transfer accrued
hours to eligible hours.
A = After meeting LOS requirement
P = Prior to meeting LOS require
PLM-EP-ENTRY-DAYS Numeric 4 (mmdd) Occurs 13 Times TA20.4
Entry Point Entry Contains the entry points at which
Days employees can transfer accrued accrued
hours to eligible hours.
PLM-EP-TO-PR Alpha 1 TA20.4
Entry Point To Contains the value that indicates
Payroll whether the transfer date matches the
payroll cycle.
N = Do not adjust to Payroll cycle
Y = Adjust to Payroll cycle
PLM-EP-CYCLE-IND Alpha 2 TA20.4
Entry Point Cycle Contains the value that indicates how
Ind often accrued hours transfer to eligible
hours.
AN = Annually
BW = Biweekly
MO = Monthly
QT = Quarterly
SA = Semiannually
SM = Semimonthly
WK = Weekly
PLM-COMPLETE-FLG1 Alpha 1 TA20.1
Element: Complete Flag1Contains the value that indicates if
form TA20.1 (Plan) is complete.
* = TA20.1 (Plan) is complete
" "
PLM-COMPLETE-FLG2 Alpha 1 TA20.2
Element: Complete Flag2Contains the value that indicates if
TA20.2 (Accrual Schedule) is complete.
* = TA20.2 is complete
" "
PLM-COMPLETE-FLG3 Alpha 1 TA20.1 TA20.2
Element: Complete Flag3Contains the value that indicates if TA20.4
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
" "
PLM-ALIMIT-CYCLE Alpha 1 TA20.3
Cycle to Apply Contains the value that indicates how
Accrual Limits often accrual limits are applied.
A = Annually
E = Everytime
M = Monthly
Q = Quarterly
S = Semiannually
PLM-AAPPLY-LIMIT Alpha 1 TA20.3
Element: Apply Accrual Contains the value that indicates how
often accrual limits are checked.
C = Cyclical
R = Request
PLM-AONE-TIME-LIM Alpha 1 TA199 TA20.3
Apply Accrual Contains the value that indicates if
Limits Next Run the system checks Accrual limits during
the next time accrual cycle.
N = No, One time limit
Y = Yes, limits are checked
PLM-ELIMIT-CYCLE Alpha 1 TA20.5
Cycle to Apply Contains the value that indicates how
Eligible Limits often the system applies eligible
limits.
A = Annually
E = Everytime
M = Monthly
Q = Quarterly
S = Semiannually
PLM-EAPPLY-LIMIT Alpha 1 TA20.5
Apply Eligible Contains the value that indicates how
Limits the system checks eligible limits.
C = Cyclical
R = Request
PLM-EONE-TIME-LIM Alpha 1 TA199 TA20.5
Apply Eligible Contains the value that indicates if
Limits Next Run the system checks eligible limits during
the next time accrual cycle.
N = No, One time limit
Y = Yes, limits are checked
PLM-WEB-AVAILABLE Alpha 1
Element: Web Available
PLM-WEB-AVAIL-SUPV Alpha 1
Element: Web Avail Supv
PLM-WEB-DESC Alpha 15 (Lower Case)
Element: Web Desc
PLM-COUNTRY-CODE Alpha 2 TA40.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PLM-PLAN-BASIS Numeric 2 TA40.1
Element: Plan Basis 00 = n/a
01 = Hours
02 = Date
PLM-ACCRUAL-TYPE Numeric 2 TA40.1
Element: Accrual Type 00 = n/a
01 = No Accrual/Vac Pay only
02 = Accrual-Dollars Only
03 = Accrual-Dollars and Hours
04 = Accrual-User Calc
PLANMASTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLMSET1 COMPANY AC550 BN138
PLAN-NAME 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
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR80.1
TA05.1 TA125
...
PLMSET2 COMPANY KeyChange PR160 PR180
PLAN-CLASS PR80.2
PLAN-NAME
PLMSET3 COMPANY TA125 TA145
COUNTRY-CODE TA195 TA196
PLAN-NAME TA199 TA20.1
TA20.2 TA20.3
TA20.4 TA20.5
TA220 TA40.1
PLMSET4 COMPANY KeyChange
COUNTRY-CODE
PLAN-CLASS
PLAN-NAME
PLANMASTER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
Transfer Limit ACTRLIMIT Delete Cascades
PLM-COMPANY -> ATL-COMPANY
PLM-PLAN-NAME -> ATL-PLAN-NAME
"E" -> ATL-LIMIT-TYPE
ATL-THRU-LIM-CYC
|
