DW_WRKFRC_SENIORITY_ASG_CRNT_EF (Preview)

This table requires activation of Seniority Dates functional area. Worker Seniority Assignment Enhanced Fact which stores current dimensionality for active assignmnets and last active date dimensionality for inactive assignments

Details

Module: Global Human Resources

Key Columns

ASSIGNMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ASSIGNMENT_ID NUMBER 38 0 True Assignment Identifier    
SOURCE_RECORD_ID VARCHAR2 256     Primary Key consisting of Assignment Identifier  
ANCHOR_DATE DATE       Anchor Date. It stores the current date for all active assignments and last active date for inactive assignments    
ANCHOR_DATE_TYPE VARCHAR2 32     Anchor Date Type. It stores CURRENT_DATE for all active assignments and LAST_ACTIVE_DATE for inactive assignments    
DEPARTMENT_ID NUMBER 38 0   Department Identifier#8 DW_DEPARTMENT_D DEPARTMENT_ID
REPORTING_ESTABLISHMENT_ID NUMBER 38 0   Reporting Establishment Identifier#9 DW_REPORTING_EST_D REPORTING_EST_ID
JOB_ID NUMBER 38 0   Job Identifier#1 DW_JOB_D JOB_ID
JOB_FAMILY_ID NUMBER 38 0   Job Family Identifier#2 DW_JOB_FAMILY_D JOB_FAMILY_ID
LOCATION_ID NUMBER 38 0   Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
POSITION_ID NUMBER 38 0   Position Identifier#3 DW_POSITION_D POSITION_ID
GRADE_ID NUMBER 38 0   Grade Identifier#4 DW_PAY_GRADE_D GRADE_ID
RATE_VALUE_ID NUMBER 38 0   Rate Value Identifier#5 DW_GRADE_RATE_VALUE_D RATE_VALUE_ID
RATE_ID NUMBER 38 0   Rate Identifier#6 DW_GRADE_RATE_D RATE_ID
SALARY_ID NUMBER 38 0   Salary Identifier    
SALARY_BASIS_ID NUMBER 38 0   Salary Basis Identifier DW_SALARY_BASIS_D SALARY_BASIS_ID
LEGAL_EMPLOYER_ID NUMBER 38 0   Legal Employer Identifier#10 DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
BUSINESS_UNIT_ID NUMBER 38 0   Business Unit Identifier#11 DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
PERIOD_OF_SERVICE_ID NUMBER 38 0   Period of Service Identifier DW_SERVICE_PERIOD_D PERIOD_OF_SERVICE_ID
PERSON_ID NUMBER 38 0   Person Identifier#7 DW_PERSON_LEGISLATION_ALL_D PERSON_ID
PERSON_TYPE_ID NUMBER 38 0   Person Type Identifier DW_PERSON_TYPE_D_TL PERSON_TYPE_ID
ASSIGNMENT_STATUS_TYPE_ID NUMBER 38 0   Assignment Status Type Identifier DW_ASSIGNMENT_STATUS_D_TL ASSIGNMENT_STATUS_TYPE_ID
MANAGER_ASSIGNMENT_ID NUMBER 38 0   Manager Assignment Identifier    
MANAGER_ID NUMBER 38 0   Manager Person Identifier DW_PERSON_D PERSON_ID
PERFORMANCE_RATING_LEVEL_ID NUMBER 38 0   Performance rating level id DW_RATING_LEVEL_D RATING_LEVEL_ID
POTENTIAL_RATING_LEVEL_ID NUMBER 38 0   Potential rating level id DW_RATING_LEVEL_D RATING_LEVEL_ID
WORKER_TYPE VARCHAR2 32     Identifies the type of record: either assignment (employee, CWK, applicant, non-workers) or a set of Terms. DW_WORKER_TYPE_D_TL WORKER_TYPE
WORKER_CATEGORY VARCHAR2 32     Employee category example: Blue collar, Civil Servant, etc DW_WORKER_CATEGORY_D_TL WORKER_CATEGORY
ASSIGNMENT_CATEGORY VARCHAR2 32     User defined category. For example Full-Time Permanent or Part-Time Permanent DW_ASSIGNMENT_CATEGORY_D_TL ASSIGNMENT_CATEGORY
LEGISLATION_CODE VARCHAR2 256     Legislation of Assignment DW_LEGISLATION_D_TL LEGISLATION_CODE
COUNTRY VARCHAR2 16     Identifies the Country of the Worker associated with the Assignment DW_COUNTRY_D_TL COUNTRY
SEX VARCHAR2 32     Identifies the Sex of Worker associated with the Assignment DW_SEX_D_TL SEX
MARITAL_STATUS VARCHAR2 32     Identifies the Marital Status of the Worker associated with the Assignment DW_MARITAL_STATUS_D_TL MARITAL_STATUS
HIGHEST_EDUCATION_LEVEL VARCHAR2 32     Identifies the Highest Education Level of the Worker associated with the Assignment DW_HIGHEST_EDUCATION_LEVEL_D_TL HIGHEST_EDUCATION_LEVEL
ETHNICITY VARCHAR2 32     Identifies the Ethnicity of the Worker associated with the Assignment DW_ETHNICITY_D_TL ETHNICITY
RELIGION VARCHAR2 32     Identifies the Religion of the Worker associated with the Assignment DW_RELIGION_D_TL RELIGION
DISABILITY_FLAG VARCHAR2 16     Identifies if the Worker associated with the assignment has disability    
PRIMARY_FLAG VARCHAR2 32     Represents overall Primary assignment    
PRIMARY_ASSIGNMENT_FLAG VARCHAR2 32     Primary assignment Flag    
ASSIGNMENT_NUMBER VARCHAR2 32     Assignment Number    
ASSIGNMENT_NAME VARCHAR2 128     Assignment Name    
SYSTEM_PERSON_TYPE VARCHAR2 32     Person Type in System    
PAY_SYSTEM_STATUS VARCHAR2 32     Payroll status indicating whether the assignment is processed in payroll runs.    
PER_SYSTEM_STATUS VARCHAR2 32     HR status used to determine how the assignment is processed    
DATE_OF_BIRTH DATE       Date of Birth of the Worker associated with the Assignment    
DATE_START DATE       Start Date of the Worker    
ACTUAL_TERMINATION_DATE DATE       Termination Date of the Worker    
MANAGER_IND NUMBER 38 0   Indicates if the Worker in the Assignment is a Manager    
AGE_IN_YEARS NUMBER 38 0   Age in Years of the Worker associated with the Assignment    
AGE_IN_MONTHS NUMBER 38 0   Age in Months of the Worker associated with the Assignment    
TENURE_IN_YEARS NUMBER 38 0   Service Period of the Worker    
TENURE_IN_MONTHS NUMBER 38 0   Person Tenure in Months    
DAYS_SINCE_LATEST_PROMOTION NUMBER 38 0   Number of Days since the last Promotion for the Worker in the Assignment    
COMPUTED_COMPA_RATIO NUMBER       Computed Compa-Ratio of the Worker in the Assignment    
ANNUALIZED_SALARY NUMBER       For future use    
COMPUTED_ANNUALIZED_SALARY NUMBER       Calculated Annual Salary based in the formula Salary*Annualization factor    
CURRENCY_CODE VARCHAR2 16     Currency of Annualized Salary Amount    
FTE NUMBER       FTE Value    
HEADCOUNT NUMBER       Headcount Value    
FULL_PART_TIME_FLAG VARCHAR2 32     Full Part Time Flag    
PERMANENT_TEMPORARY_FLAG VARCHAR2 32     Permanent Temporary Flag    
FREQUENCY VARCHAR2 32     Frequency of normal working hours:week,month,year    
NORMAL_HOURS NUMBER       Normal working hours    
BARGAINING_UNIT_CODE VARCHAR2 32     Bargaining Unit Code    
PROBATION_PERIOD NUMBER       Duration of probation period    
PROBATION_UNIT VARCHAR2 32     Units of probation period duration    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global Currency Code    
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Global currency conversion rate.    
WORK_TERMS_ASSIGNMENT_ID NUMBER 38 0   Work Terms Assignment Identifier    

Notes

#1 DW_JOB_D may contain multiple records for a job. Join should also consider fact calendar date to get the dimension values.

#2 DW_JOB_FAMILY_D may contain multiple records for a job family.

#3 DW_POSITION_D may contain multiple records for a position. Join should also consider fact calendar date to get the dimension values.

#4 DW_PAY_GRADE_D may contain multiple records for a grade. Join should also consider fact calendar date to get the dimension values.

#5 DW_GRADE_RATE_VALUE_D may contain multiple records for a grade rate value. Join should also consider fact calendar date to get the dimension values.

#6 DW_GRADE_RATE_D may contain multiple records for a grade rate. Join should also consider fact calendar date to get the dimension values.

#7 DW_PERSON_LEGISLATION_D may contain multiple records for a person. The person information is also legislation specific. Join should also consider fact calendar date and legislation to get the dimension values.

#8 For getting Organization hierarchy, DEPARTMENT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#9 For getting Organization hierarchy, REPORTING_ESTABLISHMENT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#10 For getting Organization hierarchy, LEGAL_EMPLOYER_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#11 For getting Organization hierarchy, BUSINESS_UNIT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

Copyright © 2019, 2023, Oracle and/or its affiliates.