Table 87. Domain Values and CSV Worksheet Files for Oracle Human Resources Analytics
|
Domain Value Table - Column |
|
|
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 |