employee dimension
(PLH_DIM_EMPLOYEE) No description available.
general ledger star schemas
operating ledger star schemas
monthly snapshots
actual transactions
budget transactions
commitment transactions
individual column descriptions (PLH_DIM_EMPLOYEE)
| Column Name | Column Description |
|---|---|
| EMP_KEY | No description available. |
| EMP_EFF_BEGIN_DATE | No description available. |
| EMP_EFF_END_DATE | No description available. |
| EMPLOYEE_STATUS_CODE | No description available. |
| EMPLOYEE_STATUS_DESC | No description available. |
| LAST_NAME | No description available. |
| FIRST_NAME | No description available. |
| MI | No description available. |
| FULL_NAME | No description available. |
| SSN | No description available. |
| BIRTH_DATE | No description available. |
| ETHNICITY | No description available. |
| MARITAL_STATUS | No description available. |
| GENDER | No description available. |
| CITIZENSHIP_TYPE | No description available. |
| LEGACY_IND | No description available. |
| DECEASED_IND | No description available. |
| DECEASED_DATE | No description available. |
| CONFIDENTIAL_IND | No description available. |
| EMPLOYEE_HOURLY_SALARY_IND | No description available. |
| EMPLOYEE_CLASS_CODE | No description available. |
| EMPLOYEE_CLASS_DESC | No description available. |
| LEAVE_CATEGORY_CODE | No description available. |
| LEAVE_CATEGORY_DESC | No description available. |
| BENEFIT_CATEGORY_CODE | No description available. |
| BENEFIT_CATEGORY_DESC | No description available. |
| FIRST_HIRE_DATE | No description available. |
| CURRENT_HIRE_DATE | No description available. |
| ADJ_SERVICE_DATE | No description available. |
| SENIORITY_DATE | No description available. |
| LEAVE_REASON_CODE | No description available. |
| LEAVE_REASON_DESC | No description available. |
| LEAVE_BEGIN_DATE | No description available. |
| LEAVE_END_DATE | No description available. |
| TERMINATION_REASON_CODE | No description available. |
| TERMINATION_REASON_DESC | No description available. |
| TERMINATION_DATE | No description available. |
| EMP_HOME_PORTFOLIO | No description available. |
| EMP_HOME_PORTFOLIO_DESC | No description available. |
| EMP_HOME_PORTFOLIO_FINMGR | No description available. |
| EMP_HOME_DEPARTMENT | No description available. |
| EMP_HOME_DEPARTMENT_DESC | No description available. |
| EMP_HOME_DEPARTMENT_FINMGR | No description available. |
| EMP_HOME_UNIT | No description available. |
| EMP_HOME_UNIT_DESC | No description available. |
| EMP_HOME_UNIT_FINMGR | No description available. |
| EMP_HOME_SECTION | No description available. |
| EMP_HOME_SECTION_DESC | No description available. |
| EMP_HOME_SECTION_FINMGR | No description available. |
| EMP_HOME_ORG | No description available. |
| EMP_HOME_ORG_DESC | No description available. |
| EMP_HOME_ORG_FINMGR | No description available. |
| EMP_HOME_ORG_STATUS | No description available. |
| EMP_HOME_ORG_TERM_DATE | No description available. |
| EMP_HOME_ORG_TYPE | No description available. |
| EMP_HOME_ORG_EFFECTIVE_DATE | No description available. |
