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