PJS_UDB_RES_ALLOC_DTLS

Stores the allocation details of projects for Unified Dashboard.

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
RECORD_TYPE VARCHAR2 30 Yes RECORD_TYPE
PROJECT_ID NUMBER 18 PROJECT_ID
PROJECT_NAME VARCHAR2 240 PROJECT_NAME
RESOURCE_ID NUMBER 18 RESOURCE_ID
RESOURCE_NAME VARCHAR2 240 RESOURCE_NAME
WEEK_1_VARIANCE NUMBER WEEK_1_VARIANCE
WEEK_2_VARIANCE NUMBER WEEK_2_VARIANCE
WEEK_3_VARIANCE NUMBER WEEK_3_VARIANCE
WEEK_4_VARIANCE NUMBER WEEK_4_VARIANCE
WEEK_5_VARIANCE NUMBER WEEK_5_VARIANCE
WEEK_6_VARIANCE NUMBER WEEK_6_VARIANCE
WEEK_7_VARIANCE NUMBER WEEK_7_VARIANCE
WEEK_8_VARIANCE NUMBER WEEK_8_VARIANCE
WEEK_9_VARIANCE NUMBER WEEK_9_VARIANCE
WEEK_10_VARIANCE NUMBER WEEK_10_VARIANCE
WEEK_11_VARIANCE NUMBER WEEK_11_VARIANCE
WEEK_12_VARIANCE NUMBER WEEK_12_VARIANCE
TOTAL_VARIANCE_WK_1_4 NUMBER TOTAL_VARIANCE_WK_1_4
TOTAL_VARIANCE_WK_5_8 NUMBER TOTAL_VARIANCE_WK_5_8
TOTAL_VARIANCE_WK_9_12 NUMBER TOTAL_VARIANCE_WK_9_12
WEEK_1_ALLOC_HRS NUMBER WEEK_1_ALLOC_HRS
WEEK_2_ALLOC_HRS NUMBER WEEK_2_ALLOC_HRS
WEEK_3_ALLOC_HRS NUMBER WEEK_3_ALLOC_HRS
WEEK_4_ALLOC_HRS NUMBER WEEK_4_ALLOC_HRS
WEEK_5_ALLOC_HRS NUMBER WEEK_5_ALLOC_HRS
WEEK_6_ALLOC_HRS NUMBER WEEK_6_ALLOC_HRS
WEEK_7_ALLOC_HRS NUMBER WEEK_7_ALLOC_HRS
WEEK_8_ALLOC_HRS NUMBER WEEK_8_ALLOC_HRS
WEEK_9_ALLOC_HRS NUMBER WEEK_9_ALLOC_HRS
WEEK_10_ALLOC_HRS NUMBER WEEK_10_ALLOC_HRS
WEEK_11_ALLOC_HRS NUMBER WEEK_11_ALLOC_HRS
WEEK_12_ALLOC_HRS NUMBER WEEK_12_ALLOC_HRS
WEEK_1_ASSIGN_HRS NUMBER WEEK_1_ASSIGN_HRS
WEEK_2_ASSIGN_HRS NUMBER WEEK_2_ASSIGN_HRS
WEEK_3_ASSIGN_HRS NUMBER WEEK_3_ASSIGN_HRS
WEEK_4_ASSIGN_HRS NUMBER WEEK_4_ASSIGN_HRS
WEEK_5_ASSIGN_HRS NUMBER WEEK_5_ASSIGN_HRS
WEEK_6_ASSIGN_HRS NUMBER WEEK_6_ASSIGN_HRS
WEEK_7_ASSIGN_HRS NUMBER WEEK_7_ASSIGN_HRS
WEEK_8_ASSIGN_HRS NUMBER WEEK_8_ASSIGN_HRS
WEEK_9_ASSIGN_HRS NUMBER WEEK_9_ASSIGN_HRS
WEEK_10_ASSIGN_HRS NUMBER WEEK_10_ASSIGN_HRS
WEEK_11_ASSIGN_HRS NUMBER WEEK_11_ASSIGN_HRS
WEEK_12_ASSIGN_HRS NUMBER WEEK_12_ASSIGN_HRS
PROJECT_SORT_ORDER NUMBER PROJECT_SORT_ORDER
ALLOC_SORT_ORDER NUMBER ALLOC_SORT_ORDER
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CAL_ACTIVITY_FLAG_WK_1 VARCHAR2 1 CAL_ACTIVITY_FLAG_WK_1
CAL_ACTIVITY_FLAG_WK_2 VARCHAR2 1 CAL_ACTIVITY_FLAG_WK_2
CAL_ACTIVITY_FLAG_WK_3 VARCHAR2 1 CAL_ACTIVITY_FLAG_WK_3
CAL_ACTIVITY_FLAG_WK_4 VARCHAR2 1 CAL_ACTIVITY_FLAG_WK_4
CAL_ACTIVITY_FLAG_WK_5 VARCHAR2 1 CAL_ACTIVITY_FLAG_WK_5
CAL_ACTIVITY_FLAG_WK_6 VARCHAR2 1 CAL_ACTIVITY_FLAG_WK_6
CAL_ACTIVITY_FLAG_WK_7 VARCHAR2 1 CAL_ACTIVITY_FLAG_WK_7
CAL_ACTIVITY_FLAG_WK_8 VARCHAR2 1 CAL_ACTIVITY_FLAG_WK_8
CAL_ACTIVITY_FLAG_WK_9 VARCHAR2 1 CAL_ACTIVITY_FLAG_WK_9
CAL_ACTIVITY_FLAG_WK_10 VARCHAR2 1 CAL_ACTIVITY_FLAG_WK_10
CAL_ACTIVITY_FLAG_WK_11 VARCHAR2 1 CAL_ACTIVITY_FLAG_WK_11
CAL_ACTIVITY_FLAG_WK_12 VARCHAR2 1 CAL_ACTIVITY_FLAG_WK_12

Indexes

Index Uniqueness Tablespace Columns
PJS_UDB_RES_ALLOC_DTLS_N1 Non Unique FUSION_TS_TX_IDX PROJECT_ID
PJS_UDB_RES_ALLOC_DTLS_U1 Unique Default RECORD_TYPE, PROJECT_ID, RESOURCE_ID