DW_HRSR_REFERENCE_ARTICLE_EF (Preview)
This table requires activation of HR Help Desk functional area. This table stores information about reference articles that are provided by agents to resolve the service request
Details
Module:
Key Columns
REFERENCE_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| REFERENCE_ID | NUMBER | 38 | 0 | True | Article Reference ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. System | ||||
| SR_ID | NUMBER | 38 | 0 | Service Request Reference ID | |||
| PRIMARY_CONTACT_PERSON_ID | NUMBER | 38 | 0 | Primary Contact Person ID | |||
| PRIMARY_CONTACT_PER_ASGN_NUM | VARCHAR2 | 64 | Person Contact Person Assignment Number | ||||
| OBJECT_TYPE_CD | VARCHAR2 | 32 | Service Request Object Type Code | ||||
| SUBJECT | VARCHAR2 | 999 | Article Subject | ||||
| CREATION_DATE | TIMESTAMP | Creation Date | |||||
| SERVICE_REQUEST_QUEUE_ID | NUMBER | 38 | 0 | The queue ID the service request is assigned to. | DW_HRSR_QUEUE_D | QUEUE_ID | |
| SERVICE_REQUEST_ASSIGNEE_RESOURCE_ID | NUMBER | 38 | 0 | Assigned to Resource ID | |||
| SERVICE_REQUEST_DELETED_FLAG | VARCHAR2 | 16 | Indicates whether the service request is logically deleted (Y or N). | ||||
| ANCHOR_DATE | DATE | Creation Date | |||||
| ASSIGNMENT_ID | NUMBER | 38 | 0 | Assignment Identifier | |||
| REPORTING_ESTABLISHMENT_ID | NUMBER | 38 | 0 | Workers Reporting Establishment Identifier | DW_REPORTING_EST_D | REPORTING_EST_ID | |
| DEPARTMENT_ID | NUMBER | 38 | 0 | Workers Department Identifier | DW_DEPARTMENT_D | DEPARTMENT_ID | |
| JOB_ID | NUMBER | 38 | 0 | Workers Job Identifier | DW_JOB_D | JOB_ID | |
| LOCATION_ID | NUMBER | 38 | 0 | Workers Location Identifier | DW_WORKER_LOCATION_D | LOCATION_ID | |
| POSITION_ID | NUMBER | 38 | 0 | Workers Position Identifier | DW_POSITION_D | POSITION_ID | |
| GRADE_ID | NUMBER | 38 | 0 | Workers Grade Identifier | DW_PAY_GRADE_D | GRADE_ID | |
| LEGAL_EMPLOYER_ID | NUMBER | 38 | 0 | Workers Legal Employer Identifier | DW_LEGAL_EMPLOYER_D | LEGAL_EMPLOYER_ID | |
| BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Workers Business Unit Identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| PERIOD_OF_SERVICE_ID | NUMBER | 38 | 0 | Workers Period of Service Identifier | DW_SERVICE_PERIOD_D | PERIOD_OF_SERVICE_ID | |
| PERSON_TYPE_ID | NUMBER | 38 | 0 | Workers Person Type Identifier | DW_PERSON_TYPE_D_TL | PERSON_TYPE_ID | |
| ASSIGNMENT_STATUS_TYPE_ID | NUMBER | 38 | 0 | Workers Assignment Status Type Identifier | DW_ASSIGNMENT_STATUS_D_TL | ASSIGNMENT_STATUS_TYPE_ID | |
| ASSIGNMENT_NUMBER | VARCHAR2 | 32 | Workers Assignment Number | ||||
| ASSIGNMENT_NAME | VARCHAR2 | 128 | Workers Assignment Name | ||||
| WORKER_TYPE | VARCHAR2 | 32 | Indicates type of records for worker- assignment or employment terms | DW_WORKER_TYPE_D_TL | WORKER_TYPE | ||
| WORKER_CATEGORY | VARCHAR2 | 32 | Workers category like Blue collar or Civil Servant etc | DW_WORKER_CATEGORY_D_TL | WORKER_CATEGORY | ||
| ASSIGNMENT_CATEGORY | VARCHAR2 | 32 | Workers assignment defined category. For example Full-Time Permanent or Part-Time Permanent | DW_ASSIGNMENT_CATEGORY_D_TL | ASSIGNMENT_CATEGORY | ||
| LEGISLATION_CODE | VARCHAR2 | 256 | Workers Legislation | ||||
| SEX | VARCHAR2 | 32 | Worker Sex | ||||
| ETHNICITY | VARCHAR2 | 32 | Worker Ethnicity | ||||
| PRIMARY_FLAG | VARCHAR2 | 32 | Represents workers overall Primary assignment | ||||
| PRIMARY_ASSIGNMENT_FLAG | VARCHAR2 | 32 | Workers Primary assignment Flag | ||||
| SYSTEM_PERSON_TYPE | VARCHAR2 | 32 | Workers Person Type in System | ||||
| PAY_SYSTEM_STATUS | VARCHAR2 | 32 | Workers Payroll status indicating whether the assignment is processed in payroll runs. | ||||
| PER_SYSTEM_STATUS | VARCHAR2 | 32 | Workers HR status used to determine how the assignment is processed | ||||
| FULL_PART_TIME_FLAG | VARCHAR2 | 32 | Workers Full Part Time Flag | ||||
| PERMANENT_TEMPORARY_FLAG | VARCHAR2 | 32 | Workers Permanent Temporary Flag | ||||
| SUPERVISOR_ASSIGNMENT_ID | NUMBER | 38 | 0 | Workers Line Manager Assignment Identifier | DW_PERSON_D | PERSON_ID | |
| SUPERVISOR_ID | NUMBER | 38 | 0 | Workers Line Manager Person Identifier | DW_PERSON_D | PERSON_ID | |
| HEADCOUNT | NUMBER | Workers Headcount Value | |||||
| FTE | NUMBER | Workers FTE Value | |||||
| AGE_IN_YEARS | NUMBER | 38 | 0 | Workers Age as of doc end Date in Years | |||
| AGE_IN_MONTHS | NUMBER | 38 | 0 | Workers Age as of doc end Date in months | |||
| TENURE_IN_YEARS | NUMBER | 38 | 0 | Workers Tenure as of doc end Date in years | |||
| TENURE_IN_MONTHS | NUMBER | 38 | 0 | Workers Tenure as of doc end Date in Months | |||
| BARGAINING_UNIT_CODE | VARCHAR2 | 32 | Bargaining Unit Code | ||||
| PROBATION_PERIOD | NUMBER | Duration of probation period | |||||
| PROBATION_UNIT | VARCHAR2 | 32 | Units of probation period duration | ||||
| FREQUENCY | VARCHAR2 | 32 | Frequency of normal working hours:week,month,year | ||||
| NORMAL_HOURS | NUMBER | Normal working hours |