This is a locally-developed table combining key data fields from the Person-related table (EDBPER), the
Payroll-related table (EDBPAY),
the Job Appointment-related table (EDBAPP) and the Pay Distribution-related table (EDBDIS). In addition
to combining the related records, this table has two additional business rules - it ignores any separated employees
and only contains current
and future job appointments and pay distributions. The source table for each data field is identified in the Description.
Note: There are some differences between views of this table - the fields below are all accessible through the
basic view: UCDAPTDIS_V.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| ACADEMIC | ACADEMIC EMPLOYEE FLAG | VARCHAR2(1) | EDBPER: The UCD-created flag indicating whether the employee has one or more appointments (EDBAPP) entries with a personnel program code of academic. (values are Y or N) |
| ACADEMIC_BASIS | ACADEMIC SERVICE MONTHS | VARCHAR2(2) | EDBAPP: The code indicating the service period on which an appointment is based. (values are 9=9 months, 10=10 months, 11=11 months or 12=12 months) |
| ADMIN_SCH_DIV | ADMIN DEPT SCHOOL/DIVISION | VARCHAR2(2) | EDBPER: The UCD-derived field identifying the School/College/Division associated with the employee's administrative or primary home department (UCD_ADMIN_DEPT). (translation in DVTSCH table) |
| ALT_HOME_DEPT | UCD ALTERNATE HOME DEPARTMENT | VARCHAR2(6) | EDBPER: The code indicating the department other than the primary where an employee works or would like their mail sent. May be blank. (translation in CTLHME table) |
| APPT_BEGIN_DATE | APPOINTMENT BEGIN DATE | DATE | EDBAPP: The date on which an individuals appointment is effective. |
| APPT_DEPT | APPOINTMENT DEPARTMENT CODE | VARCHAR2(6) | EDBAPP: The code indicating the department or other administrative unit associated with the appointment. This dept number is not frequently used, instead the dept number on the distribution is more accurate. (translation in CTLHME table) |
| APPT_END_DATE | APPOINTMENT END DATE | DATE | EDBAPP: The date on which an appointment ended or is expected to end. |
| APPT_FLSA_IND | APPOINTMENT FLSA | VARCHAR2(1) | EDBAPP: A code indicating whether the appointment title code is exempt or non-exempt from the Fair Labor Standards Act (0=Non-exempt,1=Except,blank=not applicable). |
| APPT_NUM | APPOINTMENT NUMBER | NUMBER(5) | EDBAPP: The unique number used to identify an appointment. (primary key) |
| APPT_OFF_SCALE | APPOINTMENT ABOVE/OFF SCALE | VARCHAR2(1) | EDBAPP: The code indicating the relationship of pay rate to the step and salary range for the title code of the appointment. (values are A=academic above scale, B=academic above scale - red circled and BLANK=on scale) |
| APPT_PAID_OVER | APPOINTMENT MONTHS PAID OVER FLAG | VARCHAR2(2) | EDBAPP: The code indicating the number of months during the year over which the individuals salary for the appointment is paid. |
| APPT_REP_CODE | APPOINTMENT REPRESENTED CODE | VARCHAR2(1) | EDBAPP: The code indicating whether an appointment is eligible to be represented, for collective bargaining purposes. (values are C=covered, S=supervisor-uncovered, or U=uncovered) |
| APPT_REP_CODE_NAME | APPT REPRESENTED CODE TRANSLATED | VARCHAR2(9) | DERIVED: The translation of the code indicating whether an appointment is eligible to be represented, for collective bargaining purposes. |
| APPT_TYPE | APPOINTMENT TYPE CODE | VARCHAR2(1) | EDBAPP: The code indicating the type of appointment. (values are 1=contract, 2=regular/career, 3=limited (formerly casual), 4=casual/restricted - students, 5=academic, 6=per diem, or 7=regular/career partial year, 8=floater) |
| APPT_TYPE_NAME | APPT TYPE CODE NAME | VARCHAR2(1) | DERIVED: The translation of the code indicating the type of appointment. |
| APPT_WOS_IND | WITHOUT SALARY APPOINTMENT FLAG | VARCHAR2(1) | EDBAPP: The code indicating whether an appointment is without salary. (values are Y=yes, without salary or N=no, not without salary) |
| BIRTH_DATE | BIRTH DATE | DATE | EDBPER: The date on which the employee was born. |
| CITIZEN_CODE | CITIZENSHIP CODE | VARCHAR2(1) | EDBPAY: The code indicating an individuals citizenship status with respect to the United States. (translation in DVTCTZ table) |
| COUNTRY_ORIGIN | COUNTRY OF ORIGIN CODE | VARCHAR2(2) | EDBPAY: The code indicating the country of residency of a visa holder. (translation in CTLFCT table) |
| DIST_DEPT_CODE | DERIVED DEPARTMENT CODE | VARCHAR2(6) | EDBDIS: The code indicating the department or other administrative unit associated with the account number for a distribution. (translation in CTLHME table) |
| DIST_DOS | DESCRIPTION OF SERVICE CODE | VARCHAR2(3) | EDBDIS: The code indicating the type of service or type of pay associated with the appointment. (translation in CTLDOS table) |
| DIST_FTE | DISTRIBUTION FULL TIME EQUIVALENT | NUMBER(3,2) | EDBDIS: The percentage of the budgeted position which the distribution represents. |
| DIST_NUM | DISTRIBUTION NUMBER | NUMBER(5) | EDBDIS: The number uniquely identifying a payroll distribution associated with an appointment. (key) |
| DIST_PAYRATE | DISTRIBUTION PAY RATE | NUMBER(9,4) | EDBDIS: The full-time hourly rate, pay period amount, or by agreement amount associated with the distribution. |
| DIST_PERCENT | DISTRIBUTION PERCENT TIME | NUMBER(5,4) | EDBDIS: The anticipated time which is chargeable to the distribution. |
| DIST_STEP | STEP | VARCHAR2(3) | EDBDIS: The level, within a pay range, of the associated distribution pay rate. |
| Campus Email Address | VARCHAR2(40) | EDBPER: The employee's campus email address. The campus alias, if available, is used - "imlastname@ucdavis.edu". Extracted from the Mothra system. Will be blank if the employee has asked that their Email address not be released. | |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | EDBPER: The unique employee identification number. (primary key) |
| EMP_NAME | EMPLOYEE NAME | VARCHAR2(26) | EDBPER: The employee's name, in "Last,First M" format. |
| EMP_ORG_ADDR_RLSE | EMPLOYEE ORGANIZATION HOME ADDRESS DISCLOSE CODE | VARCHAR2(1) | EDBPER: The code indicating whether the individual has authorized the University to release his/her home address to employee organizations (i.e. bargaining unions). (values are Blank=default, release home address; Y=yes, release home address; and N=no, do not release home address.) |
| EMP_ORG_PHONE_RLSE | EMPLOYEE ORGANIZATION HOME PHONE DISCLOSURE CODE | VARCHAR2(1) | EDBPER: The code indicating whether the individual has authorized the University to release his or her home telephone number to employee organizations (i.e. bargaining unions). (Value are: Blank=default, release home phone number; Y=yes, release the home phone number; and N=no, do not release the home number.) |
| EMP_REL_CD_NAME | EMPLOYEE RELATIONS CODE NAME | VARCHAR2(30) | DERIVED: The translation of the code indicating the supervisory/confidential designation of an individual for purposes of collective bargaining. |
| EMP_REL_CODE | EMPLOYEE RELATIONS CODE | VARCHAR2(1) | EDBPER: The code indicating the supervisory/confidential designation of an individual for purposes of collective bargaining. (translation in DVTREL table) NOTE: Only those who are not confidential or supervisors are eligible for coverage by an employee relations unit. |
| EMP_REP_CODE | EMPLOYEE RELATIONS CODE | VARCHAR2(1) | EDBPER: The code indicating whether the predominant appointment of an individual is eligible to be represented, for collective bargaining purposes. (values are C=covered, S=supervisor-uncovered, U=uncovered, ?=indeterminate, or *=to be determined) |
| EMP_STATUS | EMPLOYMENT STATUS | VARCHAR2(1) | EDBPER: The code indicating the individuals university employment status. (values are A=active, I=inactive, N=leave without pay, P=leave with pay, S=separated) |
| FAU_ACCT | ACCOUNT NUMBER | VARCHAR2(7) | EDBDIS: Organization chosen identifier used to classify financial resources for accounting and reporting purposes. (translation in COAACR table) |
| FAU_CHART | CHART OF ACCOUNTS NUMBER | VARCHAR2(1) | EDBDIS: Identifer of a Chart of Accounts. (translation in COACRT table) |
| FAU_OBJECT | OBJECT NUMBER | VARCHAR2(4) | EDBDIS: Identifier used to classify accounting transactions by type. Examples are academic salaries, in-state travel, Reg Fee income.(translation in COAOBJ table) |
| FAU_OP_FUND | UCD/OP FUND NUMBER | VARCHAR2(6) | EDBDIS: UCD pre-DAFIS fund number for reporting to Office of the President. |
| FAU_ORG_CD | ORGANIZATION CODE | VARCHAR2(4) | EDBDIS: The identifier of an organization. |
| FAU_ORG_CD_LEVEL1 | ORGANIZATION CODE LEVEL 1 | VARCHAR2(4) | DERIVED: The top or level 1 identifier of the organization associated with the chart/account. (added from DaFIS tables) |
| FAU_ORG_CD_LEVEL2 | ORGANIZATION CODE LEVEL 2 | VARCHAR2(4) | DERIVED: The next highest or level 2 identifier of the DaFIS organization. (added from DaFIS tables) |
| FAU_PROJECT | PROJECT NUMBER | VARCHAR2(10) | EDBDIS: The code used to track and accumulate transactions across multiple charts, accounts and fund groups. (translation in COAPRJ table) |
| FAU_SUBACCT | SUB ACCOUNT NUMBER | VARCHAR2(5) | EDBDIS: Allows an account to be broken down in more detail (Cost Center) in order to better track detail transactions. The sub account takes on the attributes of the account it reports, including account manager, fund group and function code. Assigned by account manager. (created from FAU field during update/load process) (translation in COASAC table) |
| FAU_SUBOBJ | SUB OBJECT NUMBER | VARCHAR2(3) | EDBDIS: Provides for an object code to be broken down into greater detail. Assigned by account manager. (created from FAU field during update/load process) (translation in COASOB table) |
| FIXED_VAR_CODE | FIXED/VARIABLE TIME CODE | VARCHAR2(1) | EDBDIS: The code indicating whether the amount of time to be worked in an appointment is fixed or variable for each pay period. (values are F=fixed or V=variable) |
| GRADE | APPOINTMENT GRADE | VARCHAR2(1) | EDBAPP: The salary grade associated with the appointment. |
| HIRE_DATE | MOST CURRENT HIRED DATE | DATE | EDBPER: The date on which the most recent employment period commenced. |
| HOME_DEPT | ADMINISTRATIVE HOME DEPARTMENT | VARCHAR2(6) | EDBPER: The code indicating the administrative or primary department responsible for coordinating the employees employment and/or pay disposition. This field should not be blank. (translation in CTLHME table) |
| HOME_PHONE | HOME PHONE | VARCHAR2(10) | EDBPER: The individual's telephone number at place of residence. |
| LEAVE_ACRUCODE | LEAVE ACCRUAL RATE CODE | VARCHAR2(1) | EDBAPP: The code indicating the vacation and sick leave eligibility, accrual rates, and accrual maximums associated with the appointment. (translation in DVTLVC table) |
| LOCATION | LOCATION | VARCHAR2(6) | EDBPER: future use |
| NEXT_SALARY_REV | NEXT SALARY REVIEW CODE | VARCHAR2(1) | EDBPER: The code indicating the type of salary review for which a staff appointment is due or eligible on the next salary review date. (values are 1=Elig for 6-month review, 2=Elig for merit increase, 3=Elig for Special Performance Award - career staff at maximum, 4=Elig for trainee increase, 5=No salary review, at maximum, blank) |
| NEXT_SALREV_DATE | NEXT SALARY REVIEW DATE | DATE | EDBPER: The date on which the staff employees next salary review is to occur. |
| PAY_BEGIN_DATE | PAY BEGIN DATE | DATE | EDBDIS: The date on which an appointment commences to be charged against an associated distribution. |
| PAY_END_DATE | PAY ENDING DATE | DATE | EDBDIS: The date on which an appointment ceases to be charged against an associated distribution. For pay distributions with indefinite ending dates (99/99/99), this field is null. |
| PAY_RATE | PAY RATE | NUMBER(10,4) | EDBAPP: The full time rate of pay (annual, hourly or by-agreement amount) associated with the appointment. |
| PAY_SCHEDULE | PAYMENT SCHEDULE CODE | VARCHAR2(2) | EDBAPP: The code indicating the pay schedule on which the appointment is paid. (values are BW=bi-weekly, MO=monthly current) |
| PERCENT_FULLTIME | PERCENT OF TIME CODE | NUMBER(3,2) | EDBAPP: The maximum time expected to be worked in a given appointment. |
| PERSONNEL_PGM | PERSONNEL PROGRAM CODE | VARCHAR2(1) | EDBAPP: The code identifying the personnel program under which the appointment is held. It is derived based on the job title code. (values are A=academic, 1=SSP-support staff and professionals, 2=MSP-management and senior professionals) |
| PERSONNEL_PGM_NAME | PERSONNEL PROGRAM CODE NAME | VARCHAR2(7) | DERIVED: The translation of the code identifying the personnel program under which the appointment is held. |
| RATE_CODE | PAY RATE CODE | VARCHAR2(1) | EDBAPP: The code indicating the nature of the rate of pay for the appointment. (values are A=annual, H=hourly, or B=by-agreement) |
| SEPARATE_DATE | SEPARATION DATE | DATE | EDBPER: The date on which an individuals employment affiliation with the university ends. For most individuals, this is the last day for which compensation is received. |
| SOC_SEC_NUM | SOCIAL SECURITY NUMBER | VARCHAR2(9) | EDBPAY: The number assigned to an individual by the Social Security Administration. |
| STEP_GRADE | STEP OR GRADE CODE | VARCHAR2(4) | EDBAPP/EDBDIS: The field containing either the Step indicating the level within a pay range of the associated distribution pay rate (staff and academics) or the salary Grade associated with the title of the appointment (sr mgmt, management and APS). There is either one or the other, never both. |
| TITLE_CODE | JOB TITLE CODE | VARCHAR2(4) | EDBAPP: The code indicating the position classification associated with an appointment. (translation in CTLTCI table) |
| TITLE_NAME_ABBRV | JOB TITLE NAME | VARCHAR2(30) | DERIVED: The translation of the code indicating the position classification associated with an appointment from the CTLTCI table. |
| TITLE_UNIT_CODE | TITLE/BARGAINING UNIT CODE | VARCHAR2(2) | EDBAPP: The code indicating the collective bargaining unit to which a title code belongs. (translation in CTLBUT table) |
| UCD_ADMIN_DEPT | UCD ADMINISTRATIVE HOME DEPARTMENT | VARCHAR2(6) | EDBPER: The derived code indicating the administrative or primary department responsible for coordinating the employees employment and/or pay disposition based on business rules. If the HOME_DEPT field is used more as a grouping mechanism (i.e. such as at UCDMC or Vet Med Teaching Hospital), this UCD_ADMIN_DEPT field contains the alternate or more detailed department number. (translation in CTLHME table) |
| UCD_WORK_DEPT | UCD WORK HOME DEPARTMENT | VARCHAR2(6) | EDBPER: The derived code indicating the department where the employee works (or wishes to get their mail). Additional business rules have been applied. If the employee has just a HOME_DEPT field and no ALT_HOME_DEPT, this UCD_WORK_DEPT will have the same value as the UCD_ADMIN_DEPT. (translation in CTLHME table) |
| VISA_TYPE | VISA TYPE | VARCHAR2(2) | EDBPAY: The code indicating the type of visa held by an individual. (translation in DVTVSA table) |
| WORK_SCH_DIV | WORK DEPT SCHOOL/DIVISION | VARCHAR2(2) | EDBPER: The UCD-derived field identifying the School/College/Division associated with the employee's work or alternate home department (UCD_WORK_DEPT). (translation in DVTSCH table) |
| WORK_STUDY_PGM | WORK STUDY PROGRAM CODE | VARCHAR2(1) | EDBAPP: The code indicating the type of work study program associated with the appointment. (translation in CTLWSP table) |
| WOSEMP | WITHOUT SALARY EMPLOYEE FLAG | VARCHAR2(1) | EDBPER: The UCD-created flag indicating whether the employee has one or more without salary appointment/distributions in addition to a regularly paid appointment. (values are Y=WOSEMP or N) |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data Warehouse
Support
Last Updated: May 15, 2006