RPT_DIM_TM_TIME_SHEETS

This table stores the definition of each Time Sheet within the ETL range derived from the PPM TM_TIME_SHEETS table.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

TIME_SHEET_ID

NOT NULL

NUMBER

ID derived from the PPM TM_TIME_SHEETS table

CREATION_DATE

NOT NULL

DATE

Date on which the time sheet was created.

CREATED_BY

NOT NULL

NUMBER

ID for the user derived who created the time sheet.

RESOURCE_ID

NOT NULL

NUMBER

ID for the user for whom the time sheet was created. This is a foreign key into the RPT_DIM_RM_RESOURCES

DESCRIPTION

NULLABLE

VARCHAR2(650)

Description of the time sheet.

PERIOD_ID

NULLABLE

NUMBER

ID for the period. This is a foreign key to the RPT_DIM_TM_PERIODS_MV

STATUS

NULLABLE

VARCHAR2(150)

Status for the Time Sheet.

TIME_SHEET_NUMBER

NULLABLE

NUMBER

Time Sheet Number.

REQUIRED_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether a time sheet is required for this period based on the Time Sheet Policy for the resource

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_DIM_TM_TIME_SHEETS_1

NONUNIQUE

1

TIME_SHEET_ID

RPT_DIM_TM_TIME_SHEETS_1

NONUNIQUE

2

STATUS

Sequences

This table uses no sequences.