DAVE_TIME_SCAN_REC_DTL2 Function
To get detailed information for the selected time card rows, Use the DAVE time scan record DTL2 function.
Parameters
Parameter | Data Type | Comments |
---|---|---|
rpt_rs_key | TEXT | The row set key provided as an output by the DAVE_TIME_SCAN_SET function. |
row_index | NUMBER |
This parameter is optional. Use the row index to loop through by index or select a specific row by index. Values:
|
Outputs
Output | Data Type | Comments |
---|---|---|
status_log | TEXT |
Request status, possible values are:
|
status_log | TEXT | The log file containing detailed information related to the 'FAILED' status and corresponding process data. |
tc_date | DATE | The actual date retrieved. The tc_date matches the eff_date parameter when the function uses the parameter. |
is_use_day_type | TEXT |
Indicate whether the day total should use the reported time card date, overtime date, or earned date. Valid values:
|
Overtime_Date | DATE | Date to use for the time entry when calculating overtime |
Earned_Date | DATE | Date to use when processing the time entry for payment |
measure | NUMBER | The summed time totals for the selected rows. |
uom | TEXT | Unit of measure for the time date in the selected rows, valid values are Hours and Units. |
start_time | DATE | The start time of the time entry. |
stop_time | DATE | The end time of the time entry. |
abs_type | TEXT | The absence type time attribute, which Oracle Fusion Absence Management provides. |
pay_type | TEXT | The payroll time type attribute, which Oracle Fusion Global Payroll provides. |
time_data_type | TEXT |
The type of time data, valid values are: MEASURE and RANGE
|
zone_type | TEXT | The zone type to use when offsetting start and end dates and times. |
start_time_zone_code | TEXT | The zone code to use when offsetting the start date and time. |
stop_time_zone_code | TEXT | The zone code to use when offsetting the stop date and time. |
start_gmt_offset | NUMBER | The Greenwich Mean Time (GMT) to use when offsetting the start date and time. |
stop_gmt_offset | NUMBER | The Greenwich Mean Time (GMT) to use when offsetting the stop date and time. |