FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | |
---|---|---|---|
TLV-COMPANY Element: Company Hr | Numeric 4 |
|
|
TLV-PLAN-NAME Element: Plan Name | Alpha 10 This field contains the plan name. |
|
|
TLV-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
|
TLV-EFFECT-DATE Element: Effect Date | Numeric 8 (yyyymmdd) |
|
|
TLV-END-DATE Element: End Date | Numeric 8 (yyyymmdd) The end date for this effort period. |
|
|
TLV-GROUP-NAME Element: Group Name | Alpha 10 |
|
|
TLV-PROC-GROUP Element: Proc Grp Hr | Alpha 10 |
|
|
TLV-ENT-FROM-DATE Element: Ent From Date | Alpha 2 AJ = Adjusted Hire Date AN = Anniversary Date HI = Hire Date SN = Seniority Date X = Custom Calculation |
|
|
TLV-ENT-UNITS Element: Ent Units | Numeric 5 |
|
|
TLV-ENT-UNITS-TYPE Element: Ent Units Type | Alpha 1 H = Hours D = Days W = Weeks M = Months S = Semi-Months |
|
|
TLV-ENT-PAY-CLASS Element: Ent Pay Class | Alpha 3 |
|
|
TLV-ATTEND-CLASS Element: Attend Class | Alpha 10 A user-defined alphanumeric code that represents a group of attendance codes used for reporting and inquiring. Validated in the ATCLASS file. |
|
|
TLV-REM-WAIT-DAYS Element: Rem Wait Days | Numeric 5 |
|
|
TLV-REM-LIMIT-UNIT Element: Rem Limit Unit | Numeric 5 |
|
|
TLV-REM-LIMIT-TYPE Element: Rem Limit Type | Alpha 1 H = Hours D = Days W = Weeks M = Months Y = Years |
|
|
TLV-REM-LMT-PD-UNT Element: Rem Lmt Pd Unt | Numeric 5 |
|
|
TLV-REM-LMT-PD-TYP Element: Rem Lmt Pd Typ | Alpha 1 H = Hours D = Days W = Weeks M = Months Y = Years |
|
|
TLV-REM-LMT-PD-TIM Element: Rem Lmt Pd Tim | Alpha 1 C = Calendar R = Rolling |
|
|
TLV-REM-HOURS-PCD Element: Rem Hours Pcd | Alpha 4 |
|
|
TLV-REM-TYPE Element: Rem Type | Alpha 1 H = Hours D = Days |
|
|
TLV-PLAN-IND Element: Plan Ind | Alpha 1 1 = SSP 2 = OSP 3 = SMP 4 = OMP 5 = HOL 6 = SPP 7 = SAP 8 = SPPA |
|
|
TLV-PLAN-YR-ST-MM Element: Plan Yr St Mm | Numeric 2 |
|
|
TLV-PLAN-YR-ST-DD Element: Plan Yr St Dd | Numeric 2 |
|
|
TLV-PL-STRT-RULES Element: Pl Strt Rules | Alpha 1 1 = zero entlmt if abs spans yrend 2 = dont zero etlmt if spans yrend X = User Exit |
|
|
TLV-PLAN-ST-LIMIT Element: Plan St Limit | Numeric 5 |
|
|
TLV-PL-LIM-TYPE Element: Pl Lim Type | Alpha 1 |
|
|
TLV-DAY-RATE-S Element: Day Rate S | Alpha 1 1 = ANN SAL /260 2 = ANN SAL /260 *FTE 3 = ANN SAL /365 4 = ANN SAL /365 *FTE 5 = ANN SAL / ANN HOURS 6 = ANN SAL / ANN HOURS * FTE X = USER DEFINED |
|
|
TLV-DAY-RATE-H Element: Day Rate H | Alpha 1 1 = PAY RATE*DAY HRS FROM WPT 2 = PAY RATE*DAY HRS FROM WPT*FTE 3 = PAY RATE*ANN HOURS/260 4 = PAY RATE*ANN HOURS/260*FTE 5 = PAY RATE*ANN HOURS/365 6 = PAY RATE*ANN HOURS/365*FTE X = USER DEFINED |
|
|
TLV-RETIRE-MALE Element: Retire Male | Numeric 2 |
|
|
TLV-RETIRE-FEMALE Element: Retire Female | Numeric 2 |
|
|
TLV-EXCL-NQ-PCD Element: Excl Nq Pcd | Alpha 4 |
|
|
TLV-PAY-TYPE Element: Pay Type | Alpha 1 L = LUMP SUM W = WEEKLY N = NORMAL PAY FREQUENCY M = MONTHLY 2 = BI WEEKLY 4 = FOUR WEEKLY |
|
|
TLV-PAYMENT-DAY Element: Payment Day | Alpha 1 1 = SUNDAY 2 = MONDAY 3 = TUESDAY 4 = WEDNESDAY 5 = THURSDAY 6 = FRIDAY 7 = SATURDAY |
|
|
TLV-RECOVER-PCT Element: Recover Pct | Signed 7.2 |
|
|
TLV-MPP-START Element: Mpp Start | Numeric 5 |
|
|
TLV-MPP-END Element: Mpp End | Numeric 5 |
|
|
TLV-SMP-QW Element: Smp Qw | Numeric 5 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
TLVSET1 |
COMPANY PLAN-NAME EFFECT-DATE |
|
| ||||||||
TLVSET2 |
COMPANY ATTEND-CLASS PLAN-NAME EFFECT-DATE |
|
|||||||||
TLVSET3 |
COMPANY PLAN-IND EFFECT-DATE PLAN-NAME |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| ||||||||||||
Group Name | PERSGROUP |
Required
| ||||||||||||
Payclass | PAYCLASS |
Required
| ||||||||||||
Proc Group | PRPROCGRP |
Required
| ||||||||||||
Prpaycode | PRPAYCODE |
Required
| ||||||||||||
Prsystem | PRSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Attend Class | ATCLASS |
Required
| ||||||||||||
Tmempleave | TMEMPLEAVE |
Delete Cascades
| ||||||||||||
Tmleavedtl | TMLEAVEDTL |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.