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 |
