DW_EB_X_EBS_PROJECTS_W_HOLIDAY_PRJ_CONTEXT_G
The objective of the context table is for calendar wid resolution.Resolving calendar using the resource_wid.
Details
Module: Projects (EBS_PROJECTS)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| DATASOURCE_NUM_ID | NUMBER | 38 | Datasource Numeric Identifier. | |||
| PERSON_ID | VARCHAR2 | 80 CHAR | Person Identifier sourced from OLTP | |||
| END_DT | TIMESTAMP | 6 | End Date of the assignment relation to Resource Id. | |||
| HOLIDAY_CAL_ID | VARCHAR2 | 80 CHAR | Holiday calendar Identifier. | |||
| HOLIDAY_CAL_WID | NUMBER | 38 | Holiday Calendar Wid. | |||
| RESOURCE_ID | VARCHAR2 | 80 CHAR | Resourced Identifier sourced from OLTP. | |||
| RESOURCE_SCD_WID | NUMBER | 38 | Resource Wid of the Employee. | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| START_DT | TIMESTAMP | 6 | Start date of the assignment relation to Resource Id. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |