The percentage of time and salary at which an employee is appointed to work at a particular job title for a range of dates within a given department. The appointment end date may be specified or indefinite. The entity includes job title, bargaining unit, percentage of time, beginning and ending dates and annualized salary information. The data originates from the Employee Data Base (EDB) and contains recently-expired, current and future appointments.
Although the business rule is that an appointment must be funded through one or more associated distributions, there is no data validation that removes appointments whose distributions have ended or no longer exist. The home department code at the appointment level is also not validated and is not generally used. The home department code at the appointment level is originally derived from the first or largest percentage of time active distribution-level home department which is itself derived from the related org that the account is associated with in DaFIS.
The data warehouse update process compares the records in the local copy of the data
base with the copy of the EDBAPP table at UCOP. Records that are found to be different
(added, changed or deleted) are flagged with the appropriate action code (A=add, C=change,
D=deleted) and the date in the two UCD-created fields: UCD_ADC_CODE and UCD_ADC_DATE.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| ACAD_SERV_FALL | ACADEMIC SERVICE - FALL | VARCHAR2(1) | UNUSED FIELD |
| ACAD_SERV_SPRING | ACADEMIC SERVICE - SPRING | VARCHAR2(1) | UNUSED FIELD |
| ACAD_SERV_SUMMER | ACADEMIC SERVICE - SUMMER | VARCHAR2(1) | UNUSED FIELD |
| ACAD_SERV_WINTER | ACADEMIC SERVICE - WINTER | VARCHAR2(1) | UNUSED FIELD |
| ACADEMIC_BASIS | ACADEMIC SERVICE MONTHS | VARCHAR2(2) | 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) |
| APPT_ADC_CODE | ADD/DELETE/CHANGE FLAG | VARCHAR2(1) | The code indicating the type of action taken on an appointment. (values are A=add a new appointment, C=change an already existing appointment, or D=delete an existing appointment) |
| APPT_BEGIN_DATE | APPOINTMENT BEGIN DATE | DATE | The date on which an individuals appointment is effective. |
| APPT_DEPT | APPOINTMENT DEPARTMENT CODE | VARCHAR2(6) | 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_DURATION | APPOINTMENT DURATION | VARCHAR2(1) | The code indicating the expected duration of an appointment. (values are A=acting executive, E=no specific end date, I=indefinite, N=non-tenure, S=security of employment, T=tenure, V=for visa purposes only or BLANK=none of the above) |
| APPT_END_DATE | APPOINTMENT END DATE | DATE | The date on which an appointment ended or is expected to end. |
| APPT_NUM | APPOINTMENT NUMBER | NUMBER(5) | The unique number used to identify an appointment. (primary key) |
| APPT_OFF_SCALE | APPOINTMENT ABOVE/OFF SCALE | VARCHAR2(1) | 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) | 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) | 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_SPCL_HNDLG | SPECIAL HANDLING CODE | VARCHAR2(1) | The code indicating the special handling required for a title for collective bargaining purposes. (values are BLANK=No special handling) |
| APPT_STEP | APPOINTMENT STEP | VARCHAR2(4) | Obsolete. Some employee types have a GRADE instead of a STEP. GRADE continues to be maintained at the appointment level while the STEP is actually maintained at the distribution (EDBDIS) table - DIST_STEP. |
| APPT_TYPE | APPOINTMENT TYPE CODE | VARCHAR2(1) | 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_WOS_IND | WITHOUT SALARY APPOINTMENT FLAG | VARCHAR2(1) | The code indicating whether an appointment is without salary. (values are Y=yes, without salary or N=no, not without salary) |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. (primary key) |
| FIXED_VAR_CODE | FIXED/VARIABLE TIME CODE | VARCHAR2(1) | 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) | The salary grade associated with the appointment. |
| LEAVE_ACRUCODE | LEAVE ACCRUAL RATE CODE | VARCHAR2(1) | The code indicating the vacation and sick leave eligibility, accrual rates, and accrual maximums associated with the appointment. (translation in DVTLVC table) |
| PAY_RATE | PAY RATE | NUMBER(10,4) | The full time rate of pay (annual, hourly or by-agreement amount) associated with the appointment. |
| PAY_SCHEDULE | PAYMENT SCHEDULE CODE | VARCHAR2(2) | 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) | The percentage of the budgeted position which the distribution represents. |
| PERSONNEL_PGM | PERSONNEL PROGRAM CODE | VARCHAR2(1) | The code identifying the personnel program under which the appointment is held. (values are A=academic, 1=SSP-support staff and professionals, 2=MSP-management and senior professionals) |
| RATE_CODE | PAY RATE CODE | VARCHAR2(1) | The code indicating the nature of the rate of pay for the appointment. (values are A=annual, H=hourly, or B=by-agreement) |
| RETIREMENT_CODE | RETIREMENT CODE | VARCHAR2(1) | The code indicating whether an appointment is eligible for special retirement contribution. |
| TIME_REPT_CODE | TIME REPORTING CODE | VARCHAR2(1) | The code indicating the method for reporting time worked in an appointment. (values are A=positive time by fau, P=positive by dept, S=positive by special timesheet, C=postive by dept, special, N=positive, timesheet not required, Z=positive by on-line, R=exception time by on-line, T=exception by fau, L=exception by dept - for leave accounting usage), E=exception, timesheet not required, W=without salary, no timesheet, Blank=none of the above) |
| TITLE_CODE | JOB TITLE CODE | VARCHAR2(4) | The code indicating the position classification associated with an appointment. (translation in CTLTCI table) |
| TITLE_UNIT_CODE | TITLE/BARGAINING UNIT CODE | VARCHAR2(2) | The code indicating the collective bargaining unit to which a title code belongs. (translation in CTLBUT table) |
| UCD_ADC_CODE | UCD ADD/DELETE/CHANGE FLAG | VARCHAR2(1) | The UCD-created flag that indicates the most recent update activity applied to the appointment record (values are A=add, C=change, D=delete). The code will stay set for 7 days after the update at which time the 'D' records will be deleted and the codes on the added and changed records will be blanked out. |
| UCD_ADC_DATE | UCD ADD/DELETE/CHANGE DATE | DATE | The UCD-set date of the most recent update activity on the PPS Data Warehouse. Similar to the UCD_ADC_CODE, this date will be blanked out after 7 days. |
| WORK_STUDY_PGM | WORK STUDY PROGRAM CODE | VARCHAR2(1) | The code indicating the type of work study program associated with the appointment. (translation in CTLWSP table) |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data Warehouse
Support
Last Updated: June 29, 2005