One record exists for each employee and contains personnel-type (Personnel Data Form - PDF form) information: employment status, service credit, ethnicity, sex, bargaining unit representation and student/units information. Each employee record contains a primary/administrative home department and a secondary/work location home department which may or may not be the same department. The record will remain for employees separated within the calendar year (for W2-producing purposes). The data originates from the Employee Data Base (EDB).
Additional indicator flags have been added to each record identifying employee type, confidentiality, work location, supervisory status, primary appointment number and primary distribution number. These flags and numbers are derived from a variety of EDB data fields. While the business rule would consider that an employee must be employed by one or more departments, there is no validation on the department code so some employees have department codes that are invalid or have yet to be added to the DEPARTMENT entity/table. The UCD_Mailid field included in this record is extracted from the UCDavis Mothra data base. It identifies the "Email alias@ucdavis.edu" that this employee can be reached at. This field may be blank as some employees either don't have an Email address or have identified in the Mothra system that their Email address should not be made public.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| AASEL | OFFICE OF THE PROVOST SELECTION FLAG | VARCHAR2(1) | The UCD-created code that indicates whether the employee is considered one of the select academic titles the Office of the Provost extracts. |
| ACADEMIC | ACADEMIC EMPLOYEE FLAG | VARCHAR2(1) | 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 FEDERATION | ACADEMIC FEDERATION FLAG | VARCHAR2(1) | The UCD-created flag to indicate an employee whose academic appointment title is eligible for membership in the Academic Federation (bargaining unit IX) per the definition of Office of the Provost. Eligibility for the Academic Senate supersedes the Academic Federation - can't be a member of both. (values are Y or N) |
| ACADEMIC_SENATE | ACADEMIC SENATE FLAG | VARCHAR2(1) | The UCD-created flag to indicate an employee who's appointment title is eligible for membership in the Academic Senate (bargaining unit=A3). The 2nd digit of the job group id (JGD_ID) or class title outline (CTO) equals 1. (values are Y or N) |
| ADDR_DISCLOSURE1 | HOME ADDRESS DISCLOSURE FLAG | VARCHAR2(1) | OBSOLETE. See HOME_ADDR_RLSE. |
| ADDR_DISCLOSURE2 | HOME PHONE DISCLOSURE FLAG | VARCHAR2(1) | OBSOLETE. See HOME_PHONE_RLSE. |
| ALT_DEPT_CD | ALTERNATE DEPARTMENT CODE | VARCHAR2(6) | The code indicating the department other than the primary one (department code-appointment) which may update the employees payroll/personnel record. May be blank - this field is used in PPS when one department is giving another department access to an employee's records. (translation in CTLHME table) |
| ALT_HOME_DEPT | UCD ALTERNATE HOME DEPARTMENT | VARCHAR2(6) | The code indicating the department other than the primary where an employee works or would like their mail sent. May be blank. As of 12/2006 this code is identified on the PPS Screens as "Mail Alt Dep." (translation in CTLHME table) |
| BIRTH_DATE | BIRTH DATE | DATE | The date on which the employee was born. |
| CONFIDENTIAL | CONFIDENTIAL EMPLOYEE FLAG | VARCHAR2(1) | The UCD-created confidential flag pertains to collective bargaining. If EDBPER. EMP_REL_CODE=[B,D,F] then Y otherwise N. |
| CREDIT_DATE | SABBATICAL CREDIT DATE | DATE | The month and year in which the sabbatical begins. |
| CREDIT_FROM_DATE | SERVICE CREDIT FROM DATE | DATE | The date from which the employee employment credit months begin to accumulate. |
| CREDIT_THRU_DATE | SABBATICAL THROUGH DATE | DATE | The date through which sabbatical credits have been accrued. |
| CREDIT_USED | SABBATICAL CREDIT USED | NUMBER(5) | The number of sabbatical credits required for a requested leave. |
| CUR_SPECIALTY_1 | AREA OF SPECIALIZATION - 1 | VARCHAR2(4) | NOT USED. The code indicating the employees current area of specialization. |
| CUR_SPECIALTY_2 | AREA OF SPECIALIZATION - 2 | VARCHAR2(4) | NOT USED. The code indicating the employees additional area of specialization. |
| CUR_SPECIALTY_3 | AREA OF SPECIALIZATION - 3 | VARCHAR2(4) | NOT USED. The code indicating the employees additional area of specialization. |
| CUT_CAP_ELIG_IND | CUT-CAP PROGRAM ELIGIBILITY INDICATOR | VARCHAR2(1) | The code indicating the employees eligibility for the Capital Accumulation Plan (CAP) benefit associated with the 1993-94 salary reduction. (values are A=UCRP member eligible for CAP because of salary reduction, B=UCRP member eligible for CAP because of TRIP participation or casual/restricted appointment, N=Not eligible for CAP, or BLANK) |
| DEGREE_INST | DEGREE FROM INSTITUTION | VARCHAR2(3) | The code indicating the institution at which the employees highest level of education was attained. |
| EDU_LEVEL | EDUCATION LEVEL | VARCHAR2(1) | The code indicating the highest level of education attained by the employee. (values are N=no credentials, H=high school diploma or equivalent, T=trade or craft certificate, A=associate degree, B=bacholor's degree, M=master's degree, P=professional degree, D=doctorate and BLANK=no information) |
| EDU_LEVEL_YR | EDUCATION LEVEL YEAR | VARCHAR2(2) | The year in which the employees highest level of education was attained. |
| EMPLMT_CREDIT | LEAVE ACCRUAL SERVICE CREDIT | NUMBER(5) | The total number of qualifying months of employment service at the university, its DOE laboratories, and the State of California. (UCRS Retirement Service Credit is calculated at UCOP. This is for determining leave accrual rates - totals are updated during Monthly Maintenance.) |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. (primary key) |
| EMP_CBUC | COLLECTIVE BARGAINING UNIT | VARCHAR2(2) | The code indicating the primary collective bargaining unit of an individual derived from the predominant appointment. (translation in CTLBUT table) |
| EMP_CHANGED_AT | EMPLOYEE RECORD CHANGED DATE | DATE | The date and time of the last update of the employees record on the employee data base (EDB). The timestamp does not reflect updates resulting from the payroll compute process. |
| EMP_CHANGED_BY | EMPLOYEE RECORD CHANGED BY USERCODE | VARCHAR2(8) | The code indicating the source of the update to the employee record on the employee data base (EDB) associated with the last update timestamp. |
| EMP_DIST_UNIT_CODE | DISTRIBUTION UNIT CODE | VARCHAR2(1) | The code indicating the distribution unit code of the predominant distribution of the predominant appointment of an individual for collective bargaining purposes. (values are BLANK=no predominant distribution unit code, ?=Indeterminate, or *=To be determined) |
| EMP_NAME | EMPLOYEE NAME - COMBINED | VARCHAR2(26) | The name of the employee. Format: Last name comma First name space middle initial. Example: Doe,John A |
| EMP_ORGAN_DISCLO | EMPLOYEE ORGANIZATION HOME ADDRESS DISCLOSE CODE | VARCHAR2(1) | OBSOLETE. See EMP_ORG_ADDR_RLSE and EMP_ORG_PHONE_RLSE. |
| EMP_ORG_ADDR_RLSE | EMPLOYEE ORGANIZATION HOME ADDRESS DISCLOSE CODE | VARCHAR2(1) | 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) | 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_PRIOR_NAME | EMPLOYEE PRIOR NAME | VARCHAR2(26) | The former name of the individual. Format is last,first m. |
| EMP_REL_CODE | EMPLOYEE RELATIONS CODE | VARCHAR2(1) | 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_REL_UNIT | EMPLOYEE RELATIONS UNIT | VARCHAR2(2) | The code indicating the employee relations unit of an individual. (translation in CTLBUT table) NOTE: Originally used for Labor Relations reporting, however reports now must show all units that the employee is eligible to be covered by - see the TITLE_UNIT_CODE at the appointment level. |
| EMP_REP_CODE | EMPLOYEE RELATIONS CODE | VARCHAR2(1) | 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_SPEC_HAND | SPECIAL HANDLING CODE | VARCHAR2(1) | The code indicating the title special handling code of the predominant appointment of an individual for collective bargaining purposes. (values are BLANK=no predominant title special handling code, ?=indeterminate, or *=to be determined) |
| EMP_STATUS | EMPLOYMENT STATUS | VARCHAR2(1) | The code indicating the individuals university employment status. (values are A=active, I=inactive, N=leave without pay, P=leave with pay, S=separated) |
| EMP_STATUS_CHG_DT | EMPLOYMENT STATUS CHANGE DATE | DATE | The date that the employee's employment status code last changed. |
| ETHNIC_ID | ETHNICITY ID CODE | VARCHAR2(1) | The code indicating the ethnic background of the employee. (translation in DVTETH table) |
| FIRST_NAME | FIRST NAME - EMPLOYEE | VARCHAR2(30) | The first name of the employee. NOTE: Field size different from former field UCD_FIRST_NAME.. |
| FUTURE_INST | FUTURE INSTITUTION CODE | VARCHAR2(3) | The code indicating the college or university which will be the employees next employer. |
| GRAD_STUDENT | GRADUATE STUDENT EMPLOYEE FLAG | VARCHAR2(1) | A UCD-created flag indicating whether the employee is a graduate student. (Values are Y=graduate student or N=not a graduate student) |
| HANDICAP_STAT | HANDICAPPED STATUS CODE | VARCHAR2(1) | The code indicating whether an individual is handicapped. (Values are H=handicapped, N or BLANK=not) |
| HIGH_DEGREE | HIGHEST DEGREE ACHIEVED | VARCHAR2(4) | The code indicating the field of study in which the employees highest level of education was attained. |
| HIRE_DATE | MOST CURRENT HIRED DATE | DATE | The date on which the most recent employment period commenced. |
| HOME_ADDR_RLSE | HOME ADDRESS RELEASE CODE | VARCHAR2(1) | The code indicating whether the individual has authorized the University to release his or her home for normal campus business purposes. (Value are: Blank=default, release home information; Y=yes, release the home information; and N=no, do not release the home information.) |
| HOME_DEPT | ADMINISTRATIVE HOME DEPARTMENT | VARCHAR2(6) | 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) | The individuals telephone number at place of residence. |
| HOME_PHONE_RLSE | HOME PHONE RELEASE CODE | VARCHAR2(1) | The code indicating whether the individual has authorized the University to release his or her home telephone number to employee organization. (Value are: Blank=default, release home phone number; Y=yes, release the home phone number; and N=no, do not release the home number.) |
| INACTIVE_DATE | INACTIVE DATE | DATE | The effective date employment status is changed to inactive for the employee. |
| JOB_GROUP_ID | PRIMARY JOB GROUP ID | VARCHAR2(3) | The code indicating the affirmative action job group associated with the primary title code. (translation in CTLJGD table) |
| LADDER_RANK | LADDER RANK AND EQUIVALENT FACULTY FLAG. | VARCHAR2(1) | The UCD-created flag indicating an employee whose academic appointment title is ladder-rank or equivalent to professor level. Without salary appointments are excluded. (values are Y=yes and N=no) |
| LAST_ACTION | LAST ACTION CODE | VARCHAR2(2) | The code indicating the 1st most recent, highest priority, personnel action to be applied to the employee record. (translation in DVTACT table) |
| LAST_ACTION_DATE | LAST CHANGE DATE | DATE | The effective date of the most recent, highest priority, personnel action. |
| LAST_ACTION_OTHER | LAST ACTION CODE (4) | VARCHAR2(8) | The code indicating the 2nd-5th most recent, highest priority, personnel actions to be applied to the employee record. (translation in DVTACT table) |
| LAST_CHG_DATE | LAST CHANGE DATE | DATE | The date of the last change to the individuals records. |
| LAST_CREDIT_ACC | CREDIT ACCRUED SINCE LAST SABBATICAL | NUMBER(5) | The number of sabbatical credits accrued by the individual since the last sabbatical leave. |
| LAST_CREDIT_BAL | SABBATICAL CREDIT BALANCE | NUMBER(5) | The remaining sabbatical credits carried forward after a planned leave usage is subtracted from the individual total accrued sabbatical credits. |
| LAST_DAY_ON_PAY | LAST DAY ON PAY DATE | DATE | The last date the employee is to receive salary payment. |
| LAST_NAME | LAST NAME - EMPLOYEE | VARCHAR2(30) | The last name of the employee. NOTE: Field size change from former field UCD_LAST_NAME. |
| LOA_BEGIN_DATE | LEAVE OF ABSENCE BEGIN DATE | DATE | The date on which an employee begins a leave of absence. |
| LOA_RETURN_DATE | LEAVE OF ABSENCE RETURN DATE | DATE | The date on which an employee is expected to return from a leave of absence. |
| LOA_STATUS_IND | LEAVE OF ABSENCE STATUS CODE | VARCHAR2(1) | The code indicating whether a leave of absence is with or without pay. (values are P=leave with pay, N=leave without pay) |
| LOA_TYPE_CODE | LEAVE OF ABSENCE TYPE CODE | VARCHAR2(2) | The code indicating the type of leave taken by the employee. (translation in DVTLOA table) |
| MERIT_PERCENT | MERITED PERCENTAGE | NUMBER(4,2) | The appointment percent change in a staff appointments pay rate due to a merit increase. |
| MIDDLE_NAME | MIDDLE NAME - EMPLOYEE | VARCHAR2(30) | The middle name or initial of the employee. NOTE: Field size change from former field UCD_MIDDLE_NAME. |
| MSP | MANAGEMENT (MAP/EXEC) FLAG | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 2. (values are Y=MSP appointment or N) |
| MSP_CAREER | MANAGEMENT CAREER FLAG | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 2 and a type code of 2. (values are Y=MSP career or N) |
| MSP_CAREER_PARTIALYR | MANAGEMENT CAREER/PARTIAL YEAR | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 2 and a type code of 7. (values are Y=MSP career partial year or N) |
| MSP_CASUAL | MANAGEMENT CASUAL | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 2 and a type code of 3. (values are Y=MSP casual or N) |
| MSP_CONTRACT | MANAGEMENT CONTRACT | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 2 and a type code of 1. (values are Y=MSP contract or N) |
| MSP_SENIOR_MGMT | SENIOR MANAGEMENT (EXECS) | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 2 and a title code between 0000 and 0200. (values are Y=MSP senior management or N) |
| NAMESUFFIX | EMPLOYEE NAME SUFFIX | VARCHAR2(4) | The suffix appended to an employees name. |
| NET_ID | NET ID | VARCHAR2(10) | NOT USED YET. The universal ID number assigned by the Office of the President to each staff and student across entire university system. |
| NEXT_SALARY_REV | NEXT SALARY REVIEW CODE | VARCHAR2(1) | 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 | The date on which the staff employees next salary review is to occur. |
| OATH_SIGN_DATE | OATH SIGNED DATE | DATE | The date the employee signed the State of California Oath of Allegiance. |
| ORIG_HIRE_DATE | ORIGINAL HIRE DATE | DATE | The date on which the first employment affiliation commenced. |
| OVER50_TIME | S/Q/MONTHS >50% GENERAL FUND | NUMBER(5) | NOT USED. The number of quarters or semesters (for academic year-based appointments) or the number of months (for fiscal year-based appointments) of service accrued in a title or in the titles Professor in Residence, Adjunct Professor, Professor of Clinical ______ Series and supported on 19900 (state) funds for more than 50 percent time. |
| OVER50_TIME_TYPE | S/Q/M ON OVER50 TYPE CODE | VARCHAR2(1) | NOT USED. The code indicating whether the associated state funded above 50 percent-time amount represents quarters, semesters, or months of service. (values are Q=quarters, S=semesters, or M=months) |
| PAF_GEN_NUM | PERSONNEL ACTION FORM GENERATION NUMBER | NUMBER(5) | The sequential number identifying the most recently-created Personnel Action Form (PAF). |
| PARK_PERMIT | PARKING PERMIT NUMBER | VARCHAR2(6) | The parking number associated with the employee. The information may not necessary be available or may be out of date. |
| PAY_RATE_CHG | PAY RATE CHANGED FLAG | VARCHAR2(1) | Under research. |
| PER_CURR_STUD_FLAG | CURRENT STUDENT FLAG | VARCHAR2(1) | The code indicating whether the individual was classified as a student according to the financial aid definitions during the current fiscal year. (values are Y=student or BLANK) |
| PRIMARY_APPT_NUM | PRIMARY APPOINTMENT NUMBER | VARCHAR2(2) | The appointment number associated with the predominate appointment for the employee. (derived at UCD during update process by comparing percentage of time, primary job title, begin date,... - under review) |
| PRIMARY_DIST_NUM | PRIMARY DISTRIBUTION NUMBER | VARCHAR2(2) | The distribution number associated with the predominate appointment for the employee. (derived at UCD during update process by comparing percentage of time, primary_title_code, funding, begin date, DOS code,... - under review) |
| PRIMARY_TITLE | PRIMARY JOB TITLE CODE | VARCHAR2(4) | The title code associated with the predominate appointment for the employee, based on a specified set of criteria. (translation in CTLTCI table) |
| PRIOR_SERVICE_CODE | PRIOR SERVICE CODE | VARCHAR2(1) | The code indicating the individuals service status prior to the most recent university employment. |
| PRIOR_SERVICE_MTHS | PRIOR MONTHS OF SERVICE | NUMBER(5) | The total number of months of prior service with the university. |
| PRIOR_SERV_INST | PRIOR SERVICE INSTITUTION CODE | VARCHAR2(3) | The code indicating the college or university which was the employees most recent previous employer. |
| PROB_END_DATE | PROBATION END DATE | DATE | The date on which the employees probationary period of employment is expected to end. |
| RECLASS_TYPE | RECLASS TYPE | VARCHAR2(1) | Under research. |
| REGISTERD_UNITS | REGISTERED STUDENT UNITS | NUMBER(3,1) | The code indicating the number of UC class units in which an employee who is a UC student is registered. (values are 00.0=Not registered for class unit, 00.1-50.0=number of UC class units for which registered, 88.8=Graduate student enrolled and registered for dissertation advisement only, 99.9=Number of UC class units for which registered not available) |
| SCHOOL_DIVISION | SCHOOL/DIVISION (BOUC) CODE | VARCHAR2(2) | The UCD-created code that indicates the school/division to which the work home department belongs. If the work or alternate home department was blank, the primary home department was used to calculate the school/division. (translation in DVTSCH table) |
| SEPARATE_DATE | SEPARATION DATE | DATE | 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. |
| SEPARATE_DESTIN | SEPARATION DESTINATION CODE | VARCHAR2(1) | The code indicating an individuals service status after separation from the university. |
| SEPARATE_REASON | SEPARATION REASON CODE | VARCHAR2(2) | The code indicating the reason for an employees separation from the university. |
| SEXCODE | SEX CODE | VARCHAR2(1) | The code identifying the employee as male or female. |
| SKL_ACCR_THRU_DATE | DATE | Description under research. | |
| SPOUSE_DISC_IND | SPOUSE DISCLOSURE FLAG | VARCHAR2(1) | OBSOLETE. See SPOUSE_NAME_RLSE. |
| SPOUSE_NAME | SPOUSE NAME | VARCHAR2(25) | The name of the individual's spouse. |
| SPOUSE_NAME_RLSE | SPOUSE NAME RELEASE CODE | VARCHAR2(1) | The code indicating whether the individual has authorized the University to release his or her spouse's name for normal campus business purposes. (Value are: Blank=Default (No, do not release Spouse Name); Y=Yes, release Spouse Name; and N=No, do not release Spouse Name.) |
| SSP | STAFF (APS/STAFF) FLAG | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 1. (values are Y=SSP appointment or N) |
| SSP_CAREER | STAFF CAREER FLAG | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 1 and a type code of 2. (values are Y=SSP career or N) |
| SSP_CAREER_PARTIALYR | STAFF CAREER/PARTIAL YEAR | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 1 and a type code of 7. (values are Y=SSP career partial year or N) |
| SSP_CASUAL | STAFF CASUAL FLAG | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 1 and a type code of 3. (values are Y=SSP casual or N) |
| SSP_CASUAL_RESTRICTED | STAFF CASUAL RESTRICTED | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 1 and a type code of 4. (values are Y=SSP casual restricted or N - most often students) |
| SSP_CONTRACT | STAFF CONTRACT FLAG | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 1 and a type code of 1. (values are Y=SSP contract or N) |
| SSP_PER_DIEM | STAFF PER DIEM FLAG | VARCHAR2(1) | The UCD-created flag indicating whether the employee has one or more appointments entries with a personnel program code of 1 and a type code of 6. (values are Y=SSP per diem or N) |
| STAFF_SALARY_REV | STAFF SALARY REVIEW CODE | VARCHAR2(1) | OBSOLETE. The code used to generate salary augmentation amounts - not actively used by the new payroll system. |
| STAFF_SALREV_DATE | STAFF SALARY REVIEW DATE | DATE | OBSOLETE. This field was used for statistical and other reports in the old payroll system. It is not actively used by the new payroll system. |
| STAFF_SALREV_STAT | STAFF SALARY REVIEW STATUS | VARCHAR2(1) | OBSOLETE. This field was used to generate augmentation amounts and to perform statistical reports in the old payroll system. It is not actively used by the new payroll system. |
| STRIKE_IND | ON STRIKE INDICATOR | VARCHAR2(1) | The code indicating the employees strike status in relation to the university. |
| STUDENT_STATUS | STUDENT STATUS CODE | VARCHAR2(1) | The code indicating whether the employee is a UC student. (values are 1=not registered, 2=not registered - graduate degree candidate, 3=undergraduate student, 4=graduate student, 5=not registered - graduate degree candidate at another UC campus, 6=undergraduate student at another UC campus, 7=graduate student at another UC campus) |
| SUPERVISOR | SUPERVISORY EMPLOYEE FLAG | VARCHAR2(1) | The UCD-created flag indicating whether the employee is a supervisor. (values are Y=supervisor or N) |
| TA_AS_OF_TERM | TEACHING ASST TERM | VARCHAR2(5) | FUTURE. The academic term and calendar year associated with QTR/SEM as teaching assistant. (values are F=fall, W=winter, or S=spring) |
| TA_TIME | SEM/QTR AS TEACHING ASST | NUMBER(5) | FUTURE. The number of quarters or semesters of service accrued in the titles teaching assistant, associated, and teaching fellow toward the service limitation established by policy for students. |
| TA_TIME_TYPE | SEM/QTR TA TYPE CODE | VARCHAR2(1) | FUTURE. The code indicating whether the associated teaching assistant-time amount represents quarters or semesters of services. (values are Q=quarters or S=semesters) |
| TEACHING_FACULTY | TEACHING FACULTY FLAG | VARCHAR2(1) | The UCD-created flag to indicate an employee whose academic appointment title is identified as a teaching position. Without salary appointments are excluded. (values are Y or N) |
| TERM_COMP_TIME | COMP TIME AT TERMINATION | NUMBER(5,2) | The number of hours of compensatory time paid to the employee at the time of separation. |
| TERM_SICK_LEAVE | SICK LEAVE AT TERMINATION | NUMBER(7,2) | The number of hours of sick leave on record for the employee at the time of separation. |
| TERM_VAC_LEAVE | VACATION LEAVE AT TERMINATION | NUMBER(5,2) | The number of hours of accrued vacation leave paid to the employee at the time of separation. |
| TOT_CREDIT_BAL | SABBATICAL TOTAL CREDIT | NUMBER(5) | The remaining sabbatical credit balance after current accrual and usage have been recorded. |
| TRIP_BEGIN_DATE | TRIP PROGRAM BEGIN DATE | DATE | OBSOLETE. The date the employee reduction in time worked begins under the time reduction incentive plan (TRIP). |
| TRIP_DURATION | TRIP PROGRAM MONTHS DURATION | NUMBER(5) | OBSOLETE. The number of months during which the employee time worked is reduced under the time reduction incentive plan (TRIP). |
| TRIP_PERCENT | TRIP PROGRAM PERCENT | NUMBER(5) | OBSOLETE. The percent by which the employees time worked is reduced under the time reduction incentive plan (TRIP). |
| UCD_ADC_CODE | UCD ADD/DELETE/CHANGE CODE | VARCHAR2(1) | The UCD-created code indicating the most update activity applied to the employee. The code will stay set for 7 days after the ppsdw update at which time the 'D' records will be deleted and the codes on the added and changed records will be blanked out. (values are A=add, C=change, D=delete) |
| UCD_ADC_DATE | UCD ADD/DELETE/CHANGE DATE | DATE | The UCD-set date of the most recent update activity. |
| UCD_ADMIN_DEPT | UCD ADMINISTRATIVE DEPT | VARCHAR2(6) | The UCD-derived field identifying the administrative or home department for the employee. For most campus employees this will be the same as the HOME_DEPT field however for others including the UCDHS staff employees where the HOME_DEPT field is a "grouping" mechanism, the ALT_HOME_DEPT is used as the "true" administrative department. |
| UCD_WORK_DEPT | UCD WORK DEPT | VARCHAR2(6) | The UCD-derived field identifying the work location for the employee. For most employees this will be the same as their alternate/work department (ALT_HOME_DEPT) field however if they do not have an alternate, this field will be set to their administrative HOME_DEPT. |
| UCD_FIRSTNAME | UCD EMPLOYEE FIRST NAME | VARCHAR2(20) | OBSOLETE. See FIRST_NAME. |
| UCD_LASTNAME | UCD EMPLOYEE LAST NAME | VARCHAR2(30) | OBSOLETE. See LAST_NAME. |
| UCD_MAILID | UCD EMAIL ADDRESS | VARCHAR2(32) | The campus electronic mail address of the employee from the Mothra database. BLANK means no email address or employee indicated not to release this information. Append "@ucdavis.edu" to the UCD_MAILID address when using to send Email. |
| UCD_MIDNAME | UCE EMPLOYEE MIDDLE NAME | VARCHAR2(20) | OBSOLETE. See MIDDLE_NAME. |
| UNIT18_TIME | SEM/QTRS AS U18 TITLE | NUMBER(5) | FUTURE. The number of quarters or semesters of service accrued in the titles designated under unit 18 for collective bargaining purposes. |
| UNIT18_TIME_TYPE | SEM/QTR U18 TYPE CODE | VARCHAR2(1) | FUTURE. The code indicating whether the associated unit 18-time amount (EDB 0727) represents quarters or semesters of services. (values are Q=quarters or S=semesters) |
| VET_DISAB_STAT | DISABLED VETERAN STATUS CODE | VARCHAR2(1) | FUTURE. The code indicating whether an individual is a special disabled veteran. (values are BLANK, N or S) |
| VET_STATUS | VIETNAM VETERAN STATUS CODE | VARCHAR2(1) | The code indicating whether an individual is a Vietnam era veteran. (values are BLANK, N or V) |
| VISA_END_DATE | VISA END DATE | DATE | The date on which an individuals Visa, work permit or coverage under a tax treaty is expected to expire. |
| WORK_LOC | WORK LOCATION | VARCHAR2(1) | The UCD-created flag that indicates where the alternate home department is located. If the department does not exist on the home department control table or the location field on the CTLHME is BLANK, the flag will be set to NULL. (values are C=campus-based, U=UCDMC-based, M=Sch of Med at UCDMC, F=field Station) |
| WOSEMP | WITHOUT SALARY EMPLOYEE FLAG | VARCHAR2(1) | 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) |
| YEAR8_EXT | INSTR ASST EXTENTION | NUMBER(5) | FUTURE. The number of quarters, semesters, or months of additional time added to the 8-year service limitation. |
| YEAR8_EXT_TYPE | INSTR ASST EXTENSION TYPE | VARCHAR2(1) | FUTURE. The code indicating whether the associated 8 year rule extension-time amount represents quarters, semesters, or months of services. (values are Q=quarters, S=semesters, or M=months) |
| YEAR8_TIME | SEM/QTRS AS INSTR ASST | NUMBER(5) | FUTURE. The number of quarters, semesters, or months of service accrued in the titles instructor, assistant professor, or equivalent titles toward the 8-year service limitation. |
| YEAR8_TIME_TYPE | SEM/QTRS IA TYPE CODE | VARCHAR2(1) | FUTURE. The code indicating whether the associated 8 year rule-time amount represents quarters, semesters, or months of services. (values are Q=quarters, S=semesters, or M=months) |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to PPS Data Warehouse Support at: paysys-support@ucdavis.edu
Last Updated: Dec 1, 2006