# DW_WRKFRC_SENIORITY_PER_SETUP_D

Person Level Seniority Date Rule Setup Data

## Details

Module: Global Human Resources

## Key Columns

SENIORITY_DATE_SETUP_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SENIORITY_DATE_SETUP_ID | NUMBER | 38 | 0 | True | Transaction system generated primary key column |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier This column contains JOB_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. |  |
SENIORITY_DATE_CODE | VARCHAR2 | 32 |  |  | Seniority Date Code |  |
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business Group Identifier |  |
LEVEL_CODE | VARCHAR2 | 32 |  |  | Level Code | DW_WRKFRC_SENIORITY_LEVEL_D_TL | SENIORITY_LEVEL_CODE
TRIGGERING_FIELD | VARCHAR2 | 32 |  |  | Attribute or Triggering field | DW_WRKFRC_SENIORITY_FIELD_D_TL | SENIORITY_FIELD_CODE
ACTIVE_FLAG | VARCHAR2 | 16 |  |  | Indicates if the Rule is Active |  |
CUMULATIVE_FLAG | VARCHAR2 | 32 |  |  | Cumulative Flag |  |
SENIORITY_VERSION | VARCHAR2 | 32 |  |  | Indicates the Seniority Version |  |
SENIORITY_BASIS | VARCHAR2 | 32 |  |  | Indicates if the Seniority Basis is Days or Hours |  |
SELECT_COLL_AGREEMENT_NAME | VARCHAR2 | 999 |  |  | Stores the filtered values (if any) for Collective Agreement |  |
SELECT_LEGAL_EMPLOYER_NAME | VARCHAR2 | 999 |  |  | Stores the filtered values (if any) for Legal Employer |  |
SELECT_LEGISLATION_CODE | VARCHAR2 | 512 |  |  | Stores the filtered values (if any) for Legislation Code |  |
SELECT_UNION_NAME | VARCHAR2 | 999 |  |  | Stores the filtered values (if any) for Union |  |
SELECT_WORKER_TYPE | VARCHAR2 | 512 |  |  | Stores the filtered values (if any) for Worker Type |  |
LABOUR_UNION_MEMBER_FLAG | VARCHAR2 | 32 |  |  | Labour Union Member Flag |  |

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