job dimension
(PLH_DIM_JOB) No description available.
general ledger star schemas
operating ledger star schemas
monthly snapshots
actual transactions
budget transactions
commitment transactions
individual column descriptions (PLH_DIM_JOB)
| Column Name | Column Description |
|---|---|
| JOB_KEY | No description available. |
| JOB_COAS_CODE | No description available. |
| JOB_COAS_DESC | No description available. |
| JOB_POSITION_CODE | No description available. |
| JOB_SUFFIX | No description available. |
| JOB_BEGIN_DATE | No description available. |
| JOB_END_DATE | No description available. |
| EFF_BEGIN_DATE | No description available. |
| EFF_END_DATE | No description available. |
| JOB_DESC | No description available. |
| STATUS | No description available. |
| JOB_EMPLOYEE_CLASS_CODE | No description available. |
| JOB_EMPLOYEE_CLASS_DESC | No description available. |
| JOB_HOURLY_SALARY_IND | No description available. |
| JOB_PICT_CODE | No description available. |
| JOB_PICT_CODE_DESC | No description available. |
| CONTRACT_TYPE | No description available. |
| CONTRACT_TYPE_DESC | No description available. |
| IPEDS_REPORT_IND | No description available. |
| FACULTY_STATS_CANADIAN_IND | No description available. |
| JOB_SALARY_TABLE_CODE | No description available. |
| JOB_SALARY_GRADE_CODE | No description available. |
| JOB_SALARY_STEP | No description available. |
| JOB_APPOINTMENT_PERCENTAGE | No description available. |
| JOB_FTE | No description available. |
| HOURS_PER_DAY | No description available. |
| HOURS_PER_PAY_PERIOD | No description available. |
| SHIFT_CODE | No description available. |
| PAY_FACTOR | No description available. |
| PAYS_PER_YEAR | No description available. |
| JOB_CHANGE_REASON_CODE | No description available. |
| JOB_CHANGE_REASON_DESC | No description available. |
| PERSONEL_CHANGE_DATE | No description available. |
| DEFFERED_PAYMENT_CODE | No description available. |
| DEFFERED_PAYMENT_DESC | No description available. |
| TIME_SHEET_ORG_CODE | No description available. |
| TIME_SHEET_ORG_DESC | No description available. |
| TIME_SHEET_ORG_FIN_MANAGER | No description available. |
| TIME_ENTRY_METHOD | No description available. |
| TIME_ENTRY_TYPE | No description available. |
| TIME_IN_OUT_IND | No description available. |
