DW_ASG_RESPONSIBILITY_D

It stores information about assignments responsibility.

Details

Module:

Key Columns

ASG_RESPONSIBILITY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ASG_RESPONSIBILITY_ID NUMBER 38 0 True System generated primary key column.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier with asg_responsibility_id
ASSIGNMENT_CATEGORY VARCHAR2 32 The assignment types that fall under this responsibility
ASSIGNMENT_ID NUMBER 38 0 The (parent) assignment which this is for
AUTO_PROVISION_FLAG VARCHAR2 32 Indicates whether an AOR record is created manually or by auto provision
BARGAINING_UNIT VARCHAR2 32 The Union for which this responsibility applies
BENEFIT_GROUP_ID NUMBER 38 0 The Benefit Group for which this responsibility applies
BUSINESS_UNIT_ID NUMBER 38 0 The business unit for which this responsibility applies
COUNTRY VARCHAR2 32 The country for which this responsibility applies. Implies all Locations within the specified country.
DEPARTMENT_HIERARCHY_ID VARCHAR2 64 The department hierarchy for which this responsibility applies.
DEPARTMENT_TREE_CODE VARCHAR2 32 Tree code of the department tree
END_DATE DATE The end date of the responsibility
ENTERPRISE_ID NUMBER 38 0 Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
GRADE_ID NUMBER 38 0 The Grade for which this responsibility applies
HIERARCHY_LEVELS NUMBER 38 0 The number of levels down the hierarchy to walk.
HIERARCHY_TYPE VARCHAR2 32 The hierarchy type for which this responsibility applies.
INCLUDE_TOP_HIER_NODE VARCHAR2 32 Indicates whether the top node of the chosen hierarchy is included or not
JOB_FAMILY_ID NUMBER 38 0 Job Family For Areas of Responsibility Scope
JOB_FUNCTION_CODE VARCHAR2 32 Job Function for Areas of Responsibility Scope
JOB_ID NUMBER 38 0 The Job for which this responsibility applies DW_JOB_D JOB_ID
LAST_NAME_END VARCHAR2 32 Ending letter for a range of Last Names
LAST_NAME_START VARCHAR2 32 Starting letter for a range of Last Names
LEGAL_ENTITY_ID NUMBER 38 0 The legal employer for which this responsibility applies
LEGISLATIVE_DATA_GROUP_ID NUMBER 38 0 The Legislative Data Group for which this responsibility applies
LOCATION_ID NUMBER 38 0 The Location for which this responsibility applies
ORGANIZATION_HIERARCHY_ID VARCHAR2 64 The organization hierarchy for which this responsibility applies.
ORGANIZATION_ID NUMBER 38 0 The Department for which this responsibility applies
ORGANIZATION_TREE_CODE VARCHAR2 32 Tree code of the organization tree
PAYROLL_ID NUMBER 38 0 The payroll for which this responsibility applies
PAYROLL_STAT_UNIT_ID NUMBER 38 0 The payroll statutory unit for which this responsibility applies
PERSON_ID NUMBER 38 0 Person for whom this responsibility is recorded.
POSITION_HIERARCHY_ID VARCHAR2 64 The position hierarchy for which this responsibility applies
POSITION_ID NUMBER 38 0 The Position for which this responsibility applies
POSITION_TREE_CODE VARCHAR2 32 Tree code of the position tree
RECRUITING_LOC_HIERARCHY_ID NUMBER 38 0 Recruiting Location Hierarchy for Areas of Responsibility scope
RECRUITING_ORG_HIERARCHY_ID NUMBER 38 0 Recruiting Org Hierarchy for Areas of Responsibility
RECRUITING_ORG_TREE_CODE VARCHAR2 999 Stores the tree code
RECRUITING_ORG_TREE_VER VARCHAR2 999 Stores the tree version
RECRUITING_TYPE_CODE VARCHAR2 32 Recruiting Type for Areas of Responsibility
RESPONSIBILITY_NAME VARCHAR2 256 Responsibility Name
RESPONSIBILITY_TYPE VARCHAR2 32 The responsibility type for which this record is holding the criteria
START_DATE DATE The start date of the responsibility
STATUS VARCHAR2 32 Indicates whether this responsibility is active or not. Can use to find when a person has responsibilities that should be assigned to someone else prior to end-dating.
TAX_REPORTING_UNIT_ID NUMBER 38 0 The tax reporting unit for which this responsibility applies
TEMPLATE_ID NUMBER 38 0 The template for which this responsibility is created from
TOP_DEPARTMENT_ID NUMBER 38 0 The top department for which this responsibility applies
TOP_MANAGER_ID NUMBER 38 0 The top manager for which this responsibility applies
TOP_ORGANIZATION_ID NUMBER 38 0 The top organization of the hierarchy for which this responsibility applies
TOP_POSITION_ID NUMBER 38 0 The top position for which this responsibility applies
WORK_CONTACTS_FLAG VARCHAR2 32 Indicates whether to include this row in work contacts evaluation