The description of home department includes name, address, location (campus, field station, UCDMC) and school/division. The data originates from the Payroll Control Table (CTL). The school/division that the department belongs to is identified by the first two characters in the Mail Code/BOUC field. The school/division code is translated in the DVTSCH table. The location of the department is coded into the second character of the campus-specific Data field. 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. Likewise, a department should belong to one school/division. However sometimes the Mail Code/BOUC field is left blank.
The first character of the Campus-specific Data field identifies the format of the
department name: if the character is a one (1), the first line of the department name and
address should be the department address line and the second line of the department name
and address should be the department name. Otherwise use the department name first and the
department address second. A view of this table, CTVHME, has the name/address
swap already handled plus additional data fields for the division name, and location of
the department.
| 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. |
| 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. |
| 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) | The organizational unit code which the department is associated. The first two digits of the org unit identify which college/school the department is assigned to, similar to the campus' use of the mail code. (translation in DVTSCH table) |
| HME_PICKUP_MAIL | MAIL PICKUP FLAG | VARCHAR2(1) | The code indicating whether checks are to be mailed (M) or Picked up (P). |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data
Warehouse Support
Last Updated: July 25, 2006