ORACLE
EBS Data Intelligence Analytics
Table Documentation / DW_EB_X_EBS_PROJECTS_W_JOB_D

DW_EB_X_EBS_PROJECTS_W_JOB_D

HEADER: $Header: $DESCRIPTION:DW_EB_X_EBS_PROJECTS_W_JOB_D dimension table describes different jobs (not positions) in an organization and also is used for EEO reporting. For example, Manager is a job as opposed to Senior Manager Sales Western Region San Jose Office, which is a position. Jobs define the role that an employee can perform in the business group, and they are normally independent of specific organizations.The grain of this dimension table is at a single 'Job' level. Examples of some attribute this table stores includes Job Name, Job Family, Fair Labor Standards Act (FLSA) Status, EEO Job Category and so on. This table is designed to be a slowly/moderately changing dimension that supports Type-2 changes out of the box.

Details

Module: Projects (EBS_PROJECTS)

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
NameDatatypeLengthPrecisionNot NullCommentsReferred Table
ROW_WIDNUMBER38TrueSurrogate key to uniquely identify a record.
AAP_JOB_CAT_CODEVARCHAR2255 CHARAffirmative Action Plan Classification Code pre-determined by government
ACTIVE_FLGVARCHAR238 CHARIdentifies whether the record is Active/Enabled in the source
APPROVAL_AUTHORITYVARCHAR250 CHAR
ASG_LEG_FLGVARCHAR230 CHAR
AUX1_CHANGED_ON_DTTIMESTAMP6Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX2_CHANGED_ON_DTTIMESTAMP6Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX3_CHANGED_ON_DTTIMESTAMP6Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX4_CHANGED_ON_DTTIMESTAMP6Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
BENCHMARK_JOB_FLGVARCHAR230 CHAR
BENCHMARK_JOB_IDNUMBER20
CHANGED_BY_WIDNUMBER38This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system.DW_EB_X_EBS_COMMON_W_USER_D
CHANGED_ON_DTTIMESTAMP6Identifies the date and time when the record was last modified in the source system.
CREATED_BY_WIDNUMBER38This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system.DW_EB_X_EBS_COMMON_W_USER_D
CREATED_ON_DTTIMESTAMP6Identifies the date and time when the record was initially created in the source system.
CRITICALITYNUMBER10
CURRENT_FLGVARCHAR230 CHARThis is a flag for marking dimension records as "Y" in order to represent the current state of a dimension entity. This flag is typically critical for Type II slowly-changing dimensions, as records in a Type II situation tend to be numerous.
C_JOB_FAMILY_CODEVARCHAR2255 CHAR
C_JOB_FUNCTION_CODEVARCHAR2255 CHAR
DATASOURCE_NUM_IDNUMBER10This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances.
DELETE_FLGVARCHAR230 CHARThis flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active.
EEO_JOB_CAT_CODEVARCHAR2255 CHAR
EFFECTIVE_FROM_DTTIMESTAMP6This column stores the date from which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
EFFECTIVE_TO_DTTIMESTAMP6This column stores the date up to which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
ETL_PROC_WIDNUMBER38Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data.
FLSA_STAT_CODEVARCHAR2255 CHAR
FULL_PART_TIME_CODEVARCHAR230 CHAR
GLOBAL_FLAGVARCHAR21 CHAR
INTEGRATION_IDVARCHAR280 CHARThis column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts.
JOB_ATTR10_CHARVARCHAR2255 CHARJOB_ATTR10_CHAR
JOB_ATTR10_DATETIMESTAMP6JOB_ATTR10_DATE
JOB_ATTR10_NUMNUMBER20,4JOB_ATTR10_NUM
JOB_ATTR11_CHARVARCHAR2255 CHARJOB_ATTR11_CHAR
JOB_ATTR11_NUMNUMBER20,4JOB_ATTR11_NUM
JOB_ATTR12_CHARVARCHAR2255 CHARJOB_ATTR12_CHAR
JOB_ATTR12_NUMNUMBER20,4JOB_ATTR12_NUM
JOB_ATTR13_CHARVARCHAR2255 CHARJOB_ATTR13_CHAR
JOB_ATTR13_NUMNUMBER20,4JOB_ATTR13_NUM
JOB_ATTR14_CHARVARCHAR2255 CHARJOB_ATTR14_CHAR
JOB_ATTR14_NUMNUMBER20,4JOB_ATTR14_NUM
JOB_ATTR15_CHARVARCHAR2255 CHARJOB_ATTR15_CHAR
JOB_ATTR15_NUMNUMBER20,4JOB_ATTR15_NUM
JOB_ATTR16_CHARVARCHAR2255 CHARJOB_ATTR16_CHAR
JOB_ATTR16_NUMNUMBER20,4JOB_ATTR16_NUM
JOB_ATTR17_CHARVARCHAR2255 CHARJOB_ATTR17_CHAR
JOB_ATTR17_NUMNUMBER20,4JOB_ATTR17_NUM
JOB_ATTR18_CHARVARCHAR2255 CHARJOB_ATTR18_CHAR
JOB_ATTR18_NUMNUMBER20,4JOB_ATTR18_NUM
JOB_ATTR19_CHARVARCHAR2255 CHARJOB_ATTR19_CHAR
JOB_ATTR19_NUMNUMBER20,4JOB_ATTR19_NUM
JOB_ATTR1_CHARVARCHAR2255 CHARJOB_ATTR1_CHAR
JOB_ATTR1_DATETIMESTAMP6JOB_ATTR1_DATE
JOB_ATTR1_NUMNUMBER20,4JOB_ATTR1_NUM
JOB_ATTR20_CHARVARCHAR2255 CHARJOB_ATTR20_CHAR
JOB_ATTR20_NUMNUMBER20,4JOB_ATTR20_NUM
JOB_ATTR21_CHARVARCHAR2255 CHARJOB_ATTR21_CHAR
JOB_ATTR22_CHARVARCHAR2255 CHARJOB_ATTR22_CHAR
JOB_ATTR23_CHARVARCHAR2255 CHARJOB_ATTR23_CHAR
JOB_ATTR24_CHARVARCHAR2255 CHARJOB_ATTR24_CHAR
JOB_ATTR25_CHARVARCHAR2255 CHARJOB_ATTR25_CHAR
JOB_ATTR26_CHARVARCHAR2255 CHARJOB_ATTR26_CHAR
JOB_ATTR27_CHARVARCHAR2255 CHARJOB_ATTR27_CHAR
JOB_ATTR28_CHARVARCHAR2255 CHARJOB_ATTR28_CHAR
JOB_ATTR29_CHARVARCHAR2255 CHARJOB_ATTR29_CHAR
JOB_ATTR2_CHARVARCHAR2255 CHARJOB_ATTR2_CHAR
JOB_ATTR2_DATETIMESTAMP6JOB_ATTR2_DATE
JOB_ATTR2_NUMNUMBER20,4JOB_ATTR2_NUM
JOB_ATTR30_CHARVARCHAR2255 CHARJOB_ATTR30_CHAR
JOB_ATTR3_CHARVARCHAR2255 CHARJOB_ATTR3_CHAR
JOB_ATTR3_DATETIMESTAMP6JOB_ATTR3_DATE
JOB_ATTR3_NUMNUMBER20,4JOB_ATTR3_NUM
JOB_ATTR4_CHARVARCHAR2255 CHARJOB_ATTR4_CHAR
JOB_ATTR4_DATETIMESTAMP6JOB_ATTR4_DATE
JOB_ATTR4_NUMNUMBER20,4JOB_ATTR4_NUM
JOB_ATTR5_CHARVARCHAR2255 CHARJOB_ATTR5_CHAR
JOB_ATTR5_DATETIMESTAMP6JOB_ATTR5_DATE
JOB_ATTR5_NUMNUMBER20,4JOB_ATTR5_NUM
JOB_ATTR6_CHARVARCHAR2255 CHARJOB_ATTR6_CHAR
JOB_ATTR6_DATETIMESTAMP6JOB_ATTR6_DATE
JOB_ATTR6_NUMNUMBER20,4JOB_ATTR6_NUM
JOB_ATTR7_CHARVARCHAR2255 CHARJOB_ATTR7_CHAR
JOB_ATTR7_DATETIMESTAMP6JOB_ATTR7_DATE
JOB_ATTR7_NUMNUMBER20,4JOB_ATTR7_NUM
JOB_ATTR8_CHARVARCHAR2255 CHARJOB_ATTR8_CHAR
JOB_ATTR8_DATETIMESTAMP6JOB_ATTR8_DATE
JOB_ATTR8_NUMNUMBER20,4JOB_ATTR8_NUM
JOB_ATTR9_CHARVARCHAR2255 CHARJOB_ATTR9_CHAR
JOB_ATTR9_DATETIMESTAMP6JOB_ATTR9_DATE
JOB_ATTR9_NUMNUMBER20,4JOB_ATTR9_NUM
JOB_CODEVARCHAR2255 CHARJob Code identifier assigned by the source organization
JOB_FAMILY_CODEVARCHAR2255 CHARIdentifies the Code that combines related jobs into one family
JOB_FAMILY_FUNCTION_WIDNUMBER38JOB_FAMILY_FUNCTION_WID
JOB_FMLY_ADDL_INT_IDVARCHAR280 CHAR
JOB_FMLY_ADDL_WIDNUMBER38
JOB_FUNCTION_CODEVARCHAR2255 CHAR
JOB_IDVARCHAR280 CHAR
JOB_LEVELVARCHAR2255 CHARIdentifies different level within the same job
LEGISLATION_CODEVARCHAR230 CHAR
MED_CHECKUP_REQVARCHAR230 CHAR
PROJ_JOB_LEVELVARCHAR2255 CHAR
REGULAR_TEMP_CODEVARCHAR230 CHAR
SCD1_WIDNUMBER38Initially TYPE1_ROW_WID
SET_IDVARCHAR230 CHARThis column represents a unique identifier used by source systems for the purpose of data sharing, reducing redundancies and minimizing system maintenance tasks, or even to drive data visibility. From a datawarehouse standpoint, the intended use of this column is to drive dimensional data security, primarily.
SRC_EFF_FROM_DTTIMESTAMP6This column stores the date from which the source record (in the Source system) is effective. The value is extracted from the source (whenever available)
SRC_EFF_TO_DTTIMESTAMP6This column stores the date up to which the source record (in the Source system) is effective. The value is extracted from the source (whenever available)
TENANT_IDVARCHAR280 CHARThis column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model.
W_CRITICALITY_LEVELVARCHAR280 CHAR
W_CRITICAL_FLGVARCHAR230 CHAR
W_EEO_JOB_CAT_CODEVARCHAR2255 CHAREmployment Equal Opportunity Job Category Code pre-determined by government
W_EXEMPT_FLGVARCHAR230 CHAR
W_FLSA_STAT_CODEVARCHAR2255 CHARFair Labor Standard Act Code - Status. This job is exempt from EEO reporting.
W_JOB_FULL_TIME_FLGVARCHAR230 CHAR
W_JOB_REGULAR_FLGVARCHAR230 CHAR
X_CUSTOMVARCHAR210 CHARThis column is used as a generic field for customer extensions.
W$_INSERT_DTTIMESTAMP6
W$_UPDATE_DTTIMESTAMP6