Data Elements in the Personnel Data Warehouse Ttl_Title_Rates Table
Click on data element name for data dictionary information
Data Element Title Code System DB2 Name Comments Title Code CIB_TITLE Location 1 CCB_CAMPUS Sub Location CSB_SUBLOC Currently used only at UCLA Pay Rep CSB_PAYREP UNC or COV Pay Interval SRB_PAY_INT Salary Step All Flag CCB_ALL Y - rate applies to both COV and UNC pay reps
N - rate does not pertain to bothAps Health Flag CCB_APS_HEALTH Bargaining Type CSB_BARGAIN C - Bargained centrally
L - Bargained locally
N - Not currently bargainedBenchmark Flag CCB_BENCHMARK By Agreement Code CCB_BYAGREE Class Ttl Outl Code CIB_CTO Class Ttl Outl Name Translation of Class Title Outline Code Focsub CIB_FOCSUB Focsub Name Translation of Focsub code Frozen Date CCB_FRZN_DATE Title cannot be assigned to an employee after it is frozen, but existing employees can retain the title Job Group Code CSB_JOBGRPCD Not currently used Journey Flag CCB_JOURNEY Linkage Code CCB_LINKAGE Location 1 Title Translation of Location 1 code Overtime Exempt Status Code CSB_OVRTM_EXMPT Perdiem Flag CCB_PERDIEM Personnel Program CIB_PERPGM Rate Lookup Flag CSB_RATE_LKUP S - Stepped rates
M - Rates are merit-based (open range)
G - Open range rates which reside in grade table
X - No ratesRelated 99 Tuc CCB_REL99 Indicates the bargaining unit with which a related 99 title is associated Representation Flag CCB_REPIND Y - title is represented
N - title is not representedRestricted Title Flag CIB_RESTRICTED Retirement Code1 CIB_RETIRE Y - UCRS membership required
N - UCRS membership is electiveRetirement Code2 CIB_SAFETY Review Date CIB_REVIEWDT Salary Grade Flag CIB_GRADE_FLAG Y or N - does the title have salary grades? Six Month Flag CSB_SIXMTH Standard Hours CCB_STND_HRS Standard Occup Class Code CIB_SOC Standard Occup Class Name Translation of Standard Occup Class Code Sub Location Name Supervisory Flag CIB_SUPVFLAG Title Full Name CIB_FULLNAME Title Name CIB_TNAME Title Unit Code CCB_TUC Bargaining unit code Title Unit Name Translation of Title Unit Code Use Flag CIB_USE T - title attributes apply systemwide
L = title attributes apply locallyWildcard Flag CCB_WILDCARD Y - Rate applies to all sublocs
N - Rate does not pertain to all sublocsDiff Day Rate DFB_RATE_DY If Shift Differential Type = DA Diff Day Type Code DFB_TYPE_CDDY If Shift Differential Type = DA Diff Eve Rate DFB_RATE_EV If Shift Differential Type = EV Diff Eve Type Code DFB_TYPE_CDEV If Shift Differential Type = EV Diff Night Rate DFB_RATE_NT If Shift Differential Type = NT Diff Night Type Code DFB_TYPE_CDNT If Shift Differential Type = NT Diff Split Rate DFB_RATE_SP If Shift Differential Type = SP Diff Split Type Code DFB_TYPE_CDSP If Shift Differential Type = SP Diff Wknd Day Rate DFB_RATE_WD If Shift Differential Type = WD Diff Wknd Day Type Code DFB_TYPE_CDWD If Shift Differential Type = WD Diff Wknd Eve Rate DFB_RATE_WE If Shift Differential Type = WE Diff Wknd Eve Type Code DFB_TYPE_CDWE If Shift Differential Type = WE Diff Wknd Night Rate DFB_RATE_WN If Shift Differential Type = WN Diff Wknd Night Type Code DFB_TYPE_CDWN If Shift Differential Type = WN Eff Begin Date SSB_EFFBGN Staff rate set effective begin date Eff Begin Date Oc OCB_EFFBGN On-call rate effective begin date Eff Begin Date Shft DFB_EFFBGN Shift Differential rate effective begin date Number Of Pay Intervals SSB_NO_PAY_INT Number Of Whole Steps SSB_NO_STEPS Maxstep Calculated based on CSB_RATE_LKUP and SSB_STF_EXCEPT If Rate Lookup Flag = S, this is the maximum step for the title. Used in conjunction with appointment data to check whether an individual employee's appointment is at the maximum step On Call Code1 OCB_TYPE_CD1 Rate type for first on-call rate
D - Dollar
P - PercentageOn Call Code2 OCB_TYPE_CD2 Rate type for second on-call rate
D - Dollar
P - PercentageOn Call Code3 OCB_TYPE_CD3 Rate type for third on-call rate
D - Dollar
P - PercentageOn Call Rate1 OCB_RATE1 First on-call rate On Call Rate2 OCB_RATE2 Second on-call rate On Call Rate3 OCB_RATE3 Third on-call rate Pay Scale Code SSB_PAYSCALE A - Annual
H - Hourly
M - MonthlyStaff Step Scale Except Flag SSB_STF_EXCEPT Pay Rate Annual Calculated based on SSB_PAYSCALE, CCB_STND_HRS, and SRB_RATE Pay Rate Hourly Calculated based on SSB_PAYSCALE, CCB_STND_HRS, and SRB_RATE Pay Rate Hourly Rnd Pay Rate Hourly rounded to 2 decimal places Pay Rate Monthly Calculated based on SSB_PAYSCALE, CCB_STND_HRS, and SRB_RATE Salary Grade TGB_GRADE Salary Grade Type TGB_GRADE_TYPE Salary Range Maximum PGD_MAX_RATE Salary Range Midpoint PGD_MID_RATE Salary Range Minimum PGD_MIN_RATE
Last Updated: July 17, 2008
Return to Personnel Data
Warehouse Description of Tables