Input Attributes for Workforce Management Fast Formulas
You can use these input attributes from the HWM_TM_ATRB_FLDS_VL table and elsewhere in workforce management fast formulas.
INPUT (ATTRIBUTE NAME) |
Description | Data Type |
---|---|---|
LayerGroupType |
Type of time card Value is either 'REPORTED_TIME_CARD_MISSING' or Null |
Text |
OraHwmHeaderComment | Header comment | Text |
OraHwmTcRowStatus | Indicates whether the row was modified or not. Valid values are 'MODIFIED' or Null | Text |
You can use any attribute listed in the HWM_TM_ATRB_FLDS_VL table as an input for fast
formula. To get a complete list from your time repository data dictionary, use this SQL:
(SELECT NAME,DISPLAY_NAME, ATTRIBUTE_TYPE FROM
HWM_TM_ATRB_FLDS_VL)
INPUT (ATTRIBUTE NAME) |
Display Name | Description |
---|---|---|
Measure | Hours | Time duration in Hours |
StartTime | Start Time | Time that the entry started |
StopTime | Stop Time | Time that the entry ended |
UnitOfMeasure | Unit Of Measure | Unit of measure for the time entry, either Hours or Units |
StartGmtOffset | Start GMT Offset | Number of hours to add to GMT to match the zone of the start time for the entry |
StartTimeZoneCode | Start TimeZone Code | Zone code for the time that the entry ended |
ZoneType | Zone Type | Time Zone Type ( Time zone code or Offset) |
TimeRecordType | Record Type | Type of Record 'RANGE' (Start/stop time was used to calculate time duration) or 'MEASURE' (Time duration was entered without start/stop time |
CostSegment | Cost Segment | Payroll cost segment associated with the time entry |
LDG_ID | Legislative Data Group | Identifier for partitioned payroll and related data |
PJC_PROJECT_ID | Project | Project time attribute associated with the time entry |
PJC_TASK_ID | Task | Task time attribute associated with the time entry |
PayrollTimeType | Payroll Time Type | Payroll time type attribute associated with the time entry |
Location | State | Top level of the geographical hierarchy of state, county, and city in the United States |