position dimension
(PLS_DIM_POSITION) No description available.
general ledger star schemas
operating ledger star schemas
monthly snapshots
actual transactions
budget transactions
commitment transactions
individual column descriptions (PLS_DIM_POSITION)
| Column Name | Column Description |
|---|---|
| POSITION_KEY | No description available. |
| POSITION_COAS_CODE | No description available. |
| POSITION_COAS_DESCRIPTION | No description available. |
| POSITION_CODE | No description available. |
| POSITION_BEGIN_DATE | No description available. |
| POSITION_END_DATE | No description available. |
| POSN_EFF_BEGIN_DATE | No description available. |
| POSN_EFF_END_DATE | No description available. |
| POSITION_TITLE | No description available. |
| POSITION_TYPE_CODE | No description available. |
| POSITION_TYPE_DESCRIPTION | No description available. |
| POSITION_CLASS_CODE | No description available. |
| POSITION_CLASS_DESC | No description available. |
| POSITION_EMPLOYEE_CLASS_CODE | No description available. |
| POSITION_EMPLOYEE_CLASS_DESC | No description available. |
| POSITION_HOURLY_SALARY_IND | No description available. |
| POSITION_GROUP_CODE | No description available. |
| POSITION_GROUP_DESC | No description available. |
| POSITION_STATUS | No description available. |
| POSITION_VACANCY_IND | No description available. |
| POSITION_FUNDING_IND | No description available. |
| SUP_POSITION_CODE | No description available. |
| SUP_POSITION_TITLE | No description available. |
| POSITION_SALARY_TABLE_CODE | No description available. |
| POSITION_SALARY_GRADE_CODE | No description available. |
| POSITION_SALARY_GROUP_CODE | No description available. |
| POSITION_SALARY_STEP | No description available. |
| POSN_APPOINTMENT_PERCENTAGE | No description available. |
| POSITION_ROLL_IND | No description available. |
| PREMIUM_EARNINGS_ROLL_IND | No description available. |
| CALIF_PENSION_CLASS_TYPE | No description available. |
| POSN_HOME_PORTFOLIO | No description available. |
| POSN_HOME_PORTFOLIO_DESC | No description available. |
| POSN_HOME_PORTFOLIO_FINMGR | No description available. |
| POSN_HOME_DEPARTMENT | No description available. |
| POSN_HOME_DEPARTMENT_DESC | No description available. |
| POSN_HOME_DEPARTMENT_FINMGR | No description available. |
| POSN_HOME_UNIT | No description available. |
| POSN_HOME_UNIT_DESC | No description available. |
| POSN_HOME_UNIT_FINMGR | No description available. |
| POSN_HOME_SECTION | No description available. |
| POSN_HOME_SECTION_DESC | No description available. |
| POSN_HOME_SECTION_FINMGR | No description available. |
| POSN_HOME_ORG | No description available. |
| POSN_HOME_ORG_DESC | No description available. |
| POSN_HOME_ORG_FINMGR | No description available. |
| POSN_HOME_ORG_STATUS | No description available. |
| POSN_HOME_ORG_TERM_DATE | No description available. |
| POSN_HOME_ORG_TYPE | No description available. |
| POSN_HOME_ORG_EFFECTIVE_DATE | No description available. |
