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     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