DW_CMP_SALARY_SIMPLE_COMPONENT_MONTHLY_SNAPSHOT_F (Preview)

This table requires activation of Salary Basis functional area. This table holds employee's Salary record by simple component As of every Month end along with Employee Demogrpahics data

Details

Module: Compensation

Key Columns

CALENDAR_DATE, SIMPLE_SALARY_COMPONENT_ID, ASSIGNMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ASSIGNMENT_ID NUMBER 38 0 True Assignment Identifier
SIMPLE_SALARY_COMPONENT_ID NUMBER 38 0 True Simple Salary Component identifier
CALENDAR_DATE DATE True Calendar Date DW_DAY_D CALENDAR_DATE
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Primary Key consisting of Assignment Identifier and Calendar Date
SALARY_ID NUMBER 38 0 Salary Identifier DW_CMP_ASG_SALARY_DETAIL_D SALARY_ID
SALARY_BASIS_ID NUMBER 38 0 Salary Basis Identifier DW_SALARY_BASIS_D SALARY_BASIS_ID
SALARY_BASES_SIMPLE_COMPONENT_ID NUMBER 38 0 Salary Basis Simple Component Identifier DW_CMP_SALARY_BASES_SIMPLE_COMPONENT_D SALARY_BASES_SIMPLE_COMPONENT_ID
CAL_MONTH_ID NUMBER 38 0 Month Identifier DW_MONTH_D CAL_MONTH_ID
CAL_QUARTER_ID NUMBER 38 0 Quarter Identifier DW_QUARTER_D CAL_QUARTER_ID
CAL_YEAR_ID NUMBER 38 0 Year Identifier DW_YEAR_D CAL_YEAR_ID
SIMPLE_COMPONENT_AMOUNT NUMBER Simple Component Amount
SIMPLE_COMPONENT_ANNUAL_AMOUNT NUMBER Annual Amount
SIMPLE_COMPONENT_ANNUAL_FT_AMOUNT NUMBER Annualzied Ful Time Salary amount
SIMPLE_COMPONENT_ADJUSTMENT_AMOUNT NUMBER Component Adjustment amount
PREV_AMOUNT NUMBER Previous Component Amount
PREV_ADJUSTMENT_AMOUNT NUMBER Previous Adjustment amount
SIMPLE_COMPONENT_CURRENCY_CODE VARCHAR2 32 Simple component Currency
GLOBAL_SIMPLE_COMPONENT_AMOUNT NUMBER Simple Component Amount in Warehouse Currency
GLOBAL_SIMPLE_COMPONENT_ANNUAL_AMOUNT NUMBER Annual Amount in Warehouse Currency
GLOBAL_SIMPLE_COMPONENT_ANNUAL_FT_AMOUNT NUMBER Annualzied Ful Time Salary amount in Warehouse Currency
GLOBAL_SIMPLE_COMPONENT_ADJUSTMENT_AMOUNT NUMBER Component Adjustment amount in Warehouse Currency
GLOBAL_PREV_AMOUNT NUMBER Previous Component Amount in Warehouse Currency
GLOBAL_PREV_ADJUSTMENT_AMOUNT NUMBER Previous Adjustment amount in Warehouse Currency
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global Currency Code
SIMPLE_COMPONENT_FREQUENCY_CODE VARCHAR2 32 Simple component Frequency
SIMPLE_COMPONENT_PERCENTAGE NUMBER Simple Component Percentage
SIMPLE_COMPONENT_ADJUSTMENT_PERCENTAGE NUMBER Component Adjustment Percentage
PREV_ADJUSTMENT_PERCENT NUMBER Previous Adjustment percentage
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_ID NUMBER 38 0 Rate Identifier#6 DW_GRADE_RATE_D RATE_ID
RATE_VALUE_ID NUMBER 38 0 Rate Value Identifier#5 DW_GRADE_RATE_VALUE_D RATE_VALUE_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_YEARS_ID NUMBER 38 0 Age in Years of the Worker associated with the Assignment.Null stamped with default.
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_YEARS_ID NUMBER 38 0 Service Period of the Worker.Null stamped with default.
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
DAYS_SINCE_LAST_PROMOTION NUMBER 38 0 Days since last promotion or start of assignment information as of Event Date
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_EXCH_RATE NUMBER Global currency conversion rate.
WORK_TERMS_ASSIGNMENT_ID NUMBER 38 0 Work Terms Assignment Identifier
CURRENT_IND NUMBER 38 0 Current date indicator

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