Bookshelf Home | Contents | Index | PDF     

Oracle® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Workforce Analytics >

Domain Values and CSV Worksheet Files for Oracle Workforce Analytics

Table 87 lists the CSV worksheet files and the domain values for Oracle Workforce Analytics in the $pmserver\LkpFiles folder.

For more information on configuring domain values with CSV worksheet files, see About Domain Values and Configuring the Domain Value Set with CSV Worksheet Files.

Table 87. Domain Values and CSV Worksheet Files for Oracle Human Resources Analytics
Worksheet File Name
Domain Value Table - Column
Description
Session

domainValues_Employee_Ethnic_Group_Code_ora11i.csv

W_EMPLOYEE_D.W_ETHNIC_GRP_CODE

Lists the Ethnic codes and their corresponding domain values of "Ethnic Group Code" for the Oracle 11i Application.

SDE_ORA_EmployeeDimension, SDE_ORA_EmployeeDimension_Full

domainValues_Employee_Sex_MF_ora11i.csv

W_EMPLOYEE_D.W_SEX_MF_CODE

Lists the Sex codes and their corresponding domain values of "Sex Code" for the Oracle 11i Application.

SDE_ORA_EmployeeDimension, SDE_ORA_EmployeeDimension_Full

domainValues_Employee_Veteran_Status_Code_ora11i.csv

W_EMPLOYEE_D.W_VETERAN_STATUS_CODE

Lists the Veteran codes and their corresponding domain values of "Veteran Status Code" for the Oracle 11i Application.

SDE_ORA_EmployeeDimension, SDE_ORA_EmployeeDimension_Full

domainValues_Employment_Cat_ora11i.csv

W_EMPLOYMENT_D.W_EMPLOYEE_CAT_CODE

Lists the User Person Types and their corresponding domain values of "Employment Category Code" for the Oracle 11i Application.

SDE_ORA_EmploymentDimension, SDE_ORA_EmploymentDimension_Full

domainValues_Employment_Exempt_Flg_ora11i.csv

W_EMPLOYMENT_D.W_EXEMPT_FLG

Lists the FLSA Statuses and their corresponding domain values of "Exempt Flag" for the Oracle 11i Application.

SDE_ORA_EmploymentDimension, SDE_ORA_EmploymentDimension_Full

domainValues_Employment_Full_Time_Flg_ora11i.csv

W_EMPLOYMENT_D.W_FULL_TIME_FLG

Lists the Employment Categories and their corresponding domain values of "Full Time Flag" for the Oracle 11i Application.

SDE_ORA_EmploymentDimension, SDE_ORA_EmploymentDimension_Full

domainValues_Employment_Status_ora11i.csv

W_EMPLOYMENT_D.W_EMPLOYMENT_STAT_CODE

Lists the Per System Statuses and their corresponding domain values of "Employment Status" for the Oracle 11i Application.

SDE_ORA_EmploymentDimension, SDE_ORA_EmploymentDimension_Full

domainValues_EventTypes_ora11i.csv

W_EVENT_TYPE_D.W_EVENT_CLASS, W_EVENT_TYPE_D.W_EVENT_GRP_CODE, W_EVENT_TYPE_D.W_EVENT_REASON_CODE, W_EVENT_SUBG_CODE

Lists the Event Types, Event Codes and Meanings and their corresponding domain values of "Event Group", "Event Sub-Group" and "Event Reason" for the Oracle 11i Application.

SDE_ORA_EventTypeDimension_AbsenceAttendance, SDE_ORA_EventTypeDimension_AbsenceAttendance_Full, SDE_ORA_EventTypeDimension_AdditionalEvents_FromFile, SDE_ORA_EventTypeDimension_OtherHREvents, SDE_ORA_EventTypeDimension_OtherHREvents_Full

domainValues_HRPosition_Active_Pos_Flg_ora11i.csv

W_HR_POSITION_D.W_ACTIVE_POSITION_FLG

Lists the Position Statuses and their corresponding domain values of "Active Position Flag" for the Oracle 11i Application.

SDE_ORA_HRPositionDimension, SDE_ORA_HRPositionDimension

domainValues_HRPosition_Exempt_Flg_ora11i.csv

W_HR_POSITION_D.W_EXEMPT_FLG

Lists the FLSA Statuses and their corresponding domain values of "Exempt Flag" for the Oracle 11i Application.

SDE_ORA_HRPositionDimension, SDE_ORA_HRPositionDimension

domainValues_Job_Eeo_Cat_Code_ora11i.csv

W_JOB_D.W_EEO_JOB_CAT_CODE

Lists the EEO Job Categories and their corresponding domain values of "EEO Job Category" for the Oracle 11i Application.

SDE_ORA_JobDimension, SDE_ORA_JobDimension_Full

domainValues_Job_Flsa_Stat_Code_ora11i.csv

W_JOB_D.W_FLSA_STAT_CODE

Lists the FLSA Statuses and their corresponding domain values of "FLSA Status Code" for the Oracle 11i Application.

SDE_ORA_JobDimension, SDE_ORA_JobDimension_Full

domainValues_Pay_Type_Grp_Code_ora11i.csv

W_PAY_TYPE_D.W_PAY_TYPE_GRP_CODE

Lists the Classification Names, Element Names and their corresponding domain values of "Pay Type Group Code" for the Oracle 11i Application.

SDE_ORA_PayTypeDimension, SDE_ORA_PayTypeDimension_Full

domainValues_Pay_Type_Flg_ora11i.csv

W_PAY_TYPE_D.W_PAY_TYPE_FLG

Lists the Costing Debit or Credit values and their corresponding domain values of "Pay type Flag" for the Oracle 11i Application.

SDE_ORA_PayTypeDimension, SDE_ORA_PayTypeDimension_Full

domainValues_Employee_Ethnic_Group_Code_ora11i.csv

W_EMPLOYEE_D.W_ETHNIC_GRP_CODE

Lists the Ethnic codes and their corresponding domain values of "Ethnic Group Code" for the Oracle 11i Application.

SDE_ORA_EmployeeDimension, SDE_ORA_EmployeeDimension_Full

domainValues_Employee_Sex_MF_ora11i.csv

W_EMPLOYEE_D.W_SEX_MF_CODE

Lists the Sex codes and their corresponding domain values of "Sex Code" for the Oracle 11i Application.

SDE_ORA_EmployeeDimension, SDE_ORA_EmployeeDimension_Full

domainValues_Employee_Veteran_Status_Code_ora11i.csv

W_EMPLOYEE_D.W_VETERAN_STATUS_CODE

Lists the Veteran codes and their corresponding domain values of "Veteran Status Code" for the Oracle 11i Application.

SDE_ORA_EmployeeDimension, SDE_ORA_EmployeeDimension_Full

domainValues_Employment_Cat_ora11i.csv

W_EMPLOYMENT_D.W_EMPLOYEE_CAT_CODE

Lists the User Person Types and their corresponding domain values of "Employment Category Code" for the Oracle 11i Application.

SDE_ORA_EmploymentDimension, SDE_ORA_EmploymentDimension_Full

domainValues_Employment_Exempt_Flg_ora11i.csv

W_EMPLOYMENT_D.W_EXEMPT_FLG

Lists the FLSA Statuses and their corresponding domain values of "Exempt Flag" for the Oracle 11i Application.

SDE_ORA_EmploymentDimension, SDE_ORA_EmploymentDimension_Full

domainValues_Employment_Full_Time_Flg_ora11i.csv

W_EMPLOYMENT_D.W_FULL_TIME_FLG

Lists the Employment Categories and their corresponding domain values of "Full Time Flag" for the Oracle 11i Application.

SDE_ORA_EmploymentDimension, SDE_ORA_EmploymentDimension_Full

domainValues_Employment_Status_ora11i.csv

W_EMPLOYMENT_D.W_EMPLOYMENT_STAT_CODE

Lists the Per System Statuses and their corresponding domain values of "Employment Status" for the Oracle 11i Application.

SDE_ORA_EmploymentDimension, SDE_ORA_EmploymentDimension_Full

domainValues_EventTypes_ora11i.csv

W_EVENT_TYPE_D.W_EVENT_CLASS, W_EVENT_TYPE_D.W_EVENT_GRP_CODE, W_EVENT_TYPE_D.W_EVENT_REASON_CODE, W_EVENT_SUBG_CODE

Lists the Event Types, Event Codes and Meanings and their corresponding domain values of "Event Group", "Event Sub-Group" and "Event Reason" for the Oracle 11i Application.

SDE_ORA_EventTypeDimension_AbsenceAttendance, SDE_ORA_EventTypeDimension_AbsenceAttendance_Full, SDE_ORA_EventTypeDimension_AdditionalEvents_FromFile, SDE_ORA_EventTypeDimension_OtherHREvents, SDE_ORA_EventTypeDimension_OtherHREvents_Full

domainValues_HRPosition_Active_Pos_Flg_ora11i.csv

W_HR_POSITION_D.W_ACTIVE_POSITION_FLG

Lists the Position Statuses and their corresponding domain values of "Active Position Flag" for the Oracle 11i Application.

SDE_ORA_HRPositionDimension, SDE_ORA_HRPositionDimension

domainValues_HRPosition_Exempt_Flg_ora11i.csv

W_HR_POSITION_D.W_EXEMPT_FLG

Lists the FLSA Statuses and their corresponding domain values of "Exempt Flag" for the Oracle 11i Application.

SDE_ORA_HRPositionDimension, SDE_ORA_HRPositionDimension

domainValues_Job_Eeo_Cat_Code_ora11i.csv

W_JOB_D.W_EEO_JOB_CAT_CODE

Lists the EEO Job Categories and their corresponding domain values of "EEO Job Category" for the Oracle 11i Application.

SDE_ORA_JobDimension, SDE_ORA_JobDimension_Full

domainValues_Job_Flsa_Stat_Code_ora11i.csv

W_JOB_D.W_FLSA_STAT_CODE

Lists the FLSA Statuses and their corresponding domain values of "FLSA Status Code" for the Oracle 11i Application.

SDE_ORA_JobDimension, SDE_ORA_JobDimension_Full

domainValues_Pay_Type_Grp_Code_ora11i.csv

W_PAY_TYPE_D.W_PAY_TYPE_GRP_CODE

Lists the Classification Names, Element Names and their corresponding domain values of "Pay Type Group Code" for the Oracle 11i Application.

SDE_ORA_PayTypeDimension, SDE_ORA_PayTypeDimension_Full

domainValues_Pay_Type_Flg_ora11i.csv

W_PAY_TYPE_D.W_PAY_TYPE_FLG

Lists the Costing Debit or Credit values and their corresponding domain values of "Pay type Flag" for the Oracle 11i Application.

SDE_ORA_PayTypeDimension, SDE_ORA_PayTypeDimension_Full

domainValues_Employee_Ethnic_Group_Code_ora11i.csv

W_EMPLOYEE_D.W_ETHNIC_GRP_CODE

Lists the Ethnic codes and their corresponding domain values of "Ethnic Group Code" for the Oracle 11i Application.

SDE_ORA_EmployeeDimension, SDE_ORA_EmployeeDimension_Full

domainValues_Employee_Sex_MF_ora11i.csv

W_EMPLOYEE_D.W_SEX_MF_CODE

Lists the Sex codes and their corresponding domain values of "Sex Code" for the Oracle 11i Application.

SDE_ORA_EmployeeDimension, SDE_ORA_EmployeeDimension_Full

  
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.