Share this page

# RPT_FCT_TM_COMPLIANCE

This table stores time-sheet compliance information.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
COMPLIANCE_ID | NOT NULL | NUMBER | System-generated identifier by the sequence RPT_FCT_TM_COMPLIANCE_S
RESOURCE_ID | NOT NULL | NUMBER | ID of the Resource who submitted this Timesheet.
TIME_SHEET_ID | NULLABLE | NUMBER | ID of the Timesheet represented by this row.
PERIOD_ID | NULLABLE | NUMBER | ID of the Period for which this Timesheet was submitted.
FIRST_SUBMIT_OFFSET | NULLABLE | NUMBER | Difference (in days) between the date on which the time sheet was first submitted and the end date of the time-sheet period. A value of 0 (zero) indicates that it was submitted on the final day of the period. A negative value indicates that the time sheet was submitted before the end of the period. A positive value indicates that the time sheet was submitted after the end of the period.
FIRST_SUBMIT_DATE | NULLABLE | DATE | Date on which the time sheet was first submitted.
LAST_SUBMIT_OFFSET | NULLABLE | NUMBER | Difference (in days) between the date on which the time sheet was last submitted and the end date of the time sheet period. A value of 0 indicates that the time sheet was submitted on the final day of the period. A negative value indicates that the time sheet was submitted before the end of the period. A positive value indicates that the time sheet was submitted after the period ended.
LAST_SUBMIT_DATE | NULLABLE | DATE | Date on which the time sheet was last submitted.
SUBMIT_COUNT | NULLABLE | NUMBER | Number of times the resource submitted this time sheet.
FIRST_REWORK_OFFSET | NULLABLE | NUMBER | Difference (in days) between the date on which the time sheet was first moved to rework status and the end date of the time-sheet period. A value of 0 indicates that the time sheet was reworked on the final day of the period. A negative value indicates that the time sheet was reworked before the end of the period. A positive value indicates that the time sheet was reworked after the period ended.
FIRST_REWORK_DATE | NULLABLE | DATE | Date on which the time sheet was first reworked.
LAST_REWORK_OFFSET | NULLABLE | NUMBER | Difference (in days) between the date on which the time sheet was last moved to rework status and the end date of the time-sheet period. A value of 0 indicates that the time sheet was reworked on the final day of the period. A negative value indicates that the time sheet was reworked before the end of the period. A positive value indicates that the time sheet was reworked after the period ended.
LAST_REWORK_DATE | NULLABLE | DATE | Date on which the time sheet was last reworked.
REWORK_COUNT | NULLABLE | NUMBER | Number of times the resource reworked the time sheet.
FIRST_APPROVAL_OFFSET | NULLABLE | NUMBER | Difference (in days) between the date on which the time sheet was first approved and the end date of the time-sheet period. A value of 0 indicates that the time sheet was approved on the final day of the period. A negative value indicates that the time sheet was approved before the end of the period. A positive value indicates that the time sheet was approved after the period ended.
FIRST_APPROVAL_DATE | NULLABLE | DATE | Date on which the time sheet was first approved.
LAST_APPROVAL_OFFSET | NULLABLE | NUMBER | Difference (in days) between the date on which the time sheet was last approved and the end date of the time-sheet period. A value of 0 indicates that the time sheet was approved on the final day of the period. A negative value indicates that the time sheet was approved before the end o f the period. A positive value indicates that the time sheet was approved after the period ended.
LAST_APPROVAL_DATE | NULLABLE | DATE | Date on which the time sheet was last approved.
APPROVAL_COUNT | NULLABLE | NUMBER | Number of times the time sheet was approved.
FROZEN_OFFSET | NULLABLE | NUMBER | Difference (in days) between the date on which the time sheet was froze n and the end date of the time-sheet period. A value of 0 indicates that t he time sheet was frozen on the final day of the period. A negative value indicates that the time sheet was frozen before the end of the period. A positive value indicates that the time sheet was frozen after the period ended.
FROZEN_DATE | NULLABLE | DATE | Date on which the time sheet was frozen.
FROZEN_COUNT | NULLABLE | NUMBER | Number of times the time sheet was frozen.
CLOSED_OFFSET | NULLABLE | NUMBER | Difference (in days) between the date on which the time sheet was close d and the end date of the time-sheet period. A value of 0 indicates that the time sheet was closed on the final day of the period. A negative value indicates that the time sheet was closed before the end of the period. A positive value indicates that the time sheet was closed after the period ended.
CLOSED_DATE | NULLABLE | DATE | Date on which the time sheet was closed.
CLOSED_COUNT | NULLABLE | NUMBER | Number of times the time sheet was closed.
NLS_STATUS | NULLABLE | VARCHAR2(150) | Time Sheet status including the missing status in NLS

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RPT_FCT_TM_COMPLIANCE_B1 | NONUNIQUE | 1 | PERIOD_ID
RPT_FCT_TM_COMPLIANCE_B2 | NONUNIQUE | 1 | TIME_SHEET_ID
RPT_FCT_TM_COMPLIANCE_B3 | NONUNIQUE | 1 | RESOURCE_ID
SYS_C003624092 | UNIQUE | 1 | COMPLIANCE_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
RPT_FCT_TM_COMPLIANCE_S | COMPLIANCE_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: