This view comes from the CTLHME table containing the description of home department including the name, address, location (campus, field station, UCDMC) and school/division. The data originates from the Payroll Control Table (CTL). The view has the department name and department addresses swapped for handling addresses. The view also has a location code and description, division and division name and modified department name. Note: The Payroll system does not force the validation of the Home Department Code, so employees will occasionally have a department code that will not have a corresponding Department entry.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| HME_ABRV_DEPT_NAME | ABBREVIATED NAME | VARCHAR2(15) | The abbreviated name of the department. |
| HME_CAMPUS_DATA | CAMPUS-SPECIFIC DATA | VARCHAR2(25) | The first digit indicates department name/address formatting instructions (1=use address then the name, 0 or BLANK=use name then address). The second digit indicates the location of the department (0=campus, 1=UCDMC, 2=School of Medicine at UCDMC, 9=field stations). |
| HME_CNTL_POINT | CONTROL POINT | VARCHAR2(6) | UNUSED. |
| HME_DEPT_ADDRESS | DEPARTMENT ADDRESS | VARCHAR2(30) | The address of the department. (reformatted by the view) |
| HME_DEPT_LOC_CODE | DEPARTMENT LOCATION CODE | VARCHAR2(2) | UNUSED. |
| HME_DEPT_MAIL_CODE | MAIL CODE/BOUC | VARCHAR2(5) | The mail code assigned to the department. The first two digits of the mail code identify which college/school the department is assigned to. (translation in DVTSCH table) |
| HME_DEPT_NAME | DEPARTMENT NAME | VARCHAR2(30) | The complete name of the department. (reformatted by the view) |
| HME_DEPT_NO | DEPARTMENT CODE | VARCHAR2(6) | The code indicating the department. (primary key) |
| HME_LAST_ACTION | LAST ACTION CODE | VARCHAR2(1) | The code indicating the most recent action. (values are A=added, C=changed, D=deleted) |
| HME_LAST_ACTION_DT | LAST ACTION DATE | DATE | The effective date of the most recent action. |
| HME_LAYOFF_UNIT_CD | LAYOFF UNIT CODE | VARCHAR2(6) | UNUSED. |
| HME_ONLY_ADDRESS | ADDRESS-ONLY FLAG | VARCHAR2(1) | The code indicating whether this department is just for address purposes. |
| HME_ORG_UNIT_CD | ORGANIZATIONAL UNIT CODE | VARCHAR2(4) | UNUSED. |
| HME_PICKUP_MAIL | MAIL PICKUP FLAG | VARCHAR2(1) | The code indicating whether checks are to be mailed (M) or Picked up (P). |
| UCD_DEPT_NAME | DEPARTMENT NAME | VARCHAR2(35) | A modified department name which includes some special edits (i.e. UCDMC: added to medical center department names). |
| UCD_DIVISION_DESCRIPTION | SCHOOL/COLLEGE/DIVISION | VARCHAR2(25) | The name of the college, school or division that this department belongs to. (added by the view) |
| UCD_LOCATION_CODE | DEPT LOCATION CODE | VARCHAR2(1) | A code indicating the geographic location of the department. See UCD_LOCATION_DESCRIPTION for a translation of these codes. (added by the view) |
| UCD_LOCATION_DESCRIPTION | DEPT LOCATION DESCRIPTION | VARCHAR2(1) | A description of the geographic location of the department. (values are campus, field station, ucdmc, school of medicine at ucdmc) (added by the view) |
| UCD_SCHOOL_DIVISION | DIVISION CODE | VARCHAR2(2) | The code indicating which school, college, division that the department belongs to. See UCD_DIVISION_DESCRIPTION for code translation. (added by the view) |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data
Warehouse Support
Last Updated: October 14, 1999