RPT_DIM_TM_TIME_SHEET_LINES

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

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

TIME_SHEET_LINE_ID

NOT NULL

NUMBER

ID derived from the PPM TM_TIME_SHEET_LINES table

TIME_SHEET_ID

NOT NULL

VARCHAR2(260)

Foreign key to the Time Sheet ID from RPT_DIM_TM_TIME_SHEETS table

STATE

NULLABLE

NUMBER

Time Sheet Line state.

WORK_ITEM_TYPE

NULLABLE

VARCHAR2(255)

Indicates the type of item derived from the PPM TM_TIME_SHEET_LINES table. Valid values are REQUEST, PACKAGE, TASK, PROJECT, and MISC

WORK_ITEM_SET_TYPE

NULLABLE

VARCHAR2(12)

Indicates the type of item set. Valid values are REQUEST_TYPE, WORKFLOW, PROJECT, and MISC

WORK_ITEM_ID

NULLABLE

VARCHAR2(255)

Identifies the item that this line represents derived from the PPM TM_TIME_SHEET_LINES table. Valid values represent Request IDs, Package IDs, Task IDs, and Miscellaneous Items

WORK_ITEM_SET_ID

NULLABLE

VARCHAR2(255)

Identifies the parent type of the item derived from the PPM TM_TIME_SHEET_LINES table. Valid values represent Request Types, Workflows, Projects, and Miscellaneous Items

TASK_ID

NULLABLE

VARCHAR2(255)

Identifies the PPM Task against which time is logged for this line

REQUEST_ID

NULLABLE

VARCHAR2(255)

Identifies the PPM Request against which time is logged for this line

PACKAGE_ID

NULLABLE

VARCHAR2(255)

Identifies the PPM Package against which time is logged for this line

MISC_CODE

NULLABLE

VARCHAR2(255)

Identifies the name of the PPM Miscellaneous Item against which time is logged for this line

REQUEST_TYPE_ID

NULLABLE

VARCHAR2(255)

Identifies the PPM request type for the request work item, if it exists for the line

MASTER_PROJECT_ID

NULLABLE

VARCHAR2(255)

Identifies the PPM Project for the Task or Project Work Item, if it exists for the line

ACTUAL_APPROVER_USER_ID

NULLABLE

VARCHAR2(40)

Identifies the PPM Resource who approved this line. This is a foreign key into the RPT_DIM_RM_RESOURCES table

USER_DATA1-20

NULLABLE

VARCHAR2(255)

User data segment

VISIBLE_USER_DATA1-20

NULLABLE

VARCHAR2(255)

User data segment

WORK_ITEM_NAME

NULLABLE

VARCHAR2(300)

Name of the work item entity against which time is logged for this line

WORK_ITEM_SET_NAME

NULLABLE

VARCHAR2(300)

Name of the parent entity against which time is logged for this line

REQUEST_TYPE_NAME

NULLABLE

VARCHAR2(80)

PPM Request Type against which time is logged for this line, the WORK_ITEM_TYPE is 'REQUEST'

TASK_NAME

NULLABLE

VARCHAR2(300)

PPM Task Name against which time is logged for this line, the WORK_ITEM_TYPE is 'TASK' or 'PROJECT'

PROJECT_NAME

NULLABLE

VARCHAR2(300)

PPM Project Name against which time is logged for this line, the WORK_ITEM_TYPE is 'TASK' or 'PROJECT'

PACKAGE_NUMBER

NULLABLE

VARCHAR2(40)

PPM Package Number against which time is logged for this line, the WORK_ITEM_TYPE is 'PACKAGE'

CHARGE_CODE_ID

NULLABLE

NUMBER

Foreign key to RPT_DIM_TM_CHARGE_CODES_MV

CHARGE_PERCENT

NULLABLE

FLOAT

Percentage for Charge code

MISC_NAME

NULLABLE

VARCHAR2(150)

PPM Miscellaneous Name against which time is logged for this line when WORK_ITEM_TYPE is 'MISC'

ACTUAL_APPROVER_FIRST_NAME

NULLABLE

VARCHAR2(80)

First Name of the PPM Resource who approved the line

ACTUAL_APPROVER_LAST_NAME

NULLABLE

VARCHAR2(80)

Last Name of the PPM Resource who approved the line

NLS_STATUS

NULLABLE

VARCHAR2(150)

Status of the Time Sheet Line in the PPM definition language

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_DIM_TM_TIME_SHEET_LIN_1

NONUNIQUE

1

TIME_SHEET_ID

RPT_DIM_TM_TIME_SHEET_LIN_1

NONUNIQUE

2

STATE

Sequences

This table uses no sequences.