Skip to main content

Apply
Impact of the CSU
The CSU System
Resource Center

Apply
Donate
News
Careers
Contact

Apply
Donate
News
Careers
Contact

Total Amount Used

Home
- The CSU System
  - Administration
    - Systemwide Human Resources
      - Data Element Dictionary
        /
        Total Amount Used

PC3

PCW

Total Amount Used

PTOC

Fieldname:	XX:TOTUSED
Format:	P8.3 9999.999
Definition:	The total amount of benefits used.
Coding Values:	Example: 7.500
Available Files:	LB Leave Balance Information

PTWCO

Publishing Top Two Column 2

Publishing Top Two Column 3

Publishing Top Two Column 4

Publishing Top Three Column 1

Publishing Top Three Column 2

PTTCT

Publishing Middle One Column

Publishing Middle Two Column 1

Publishing Middle Two Column 2

Publishing Middle Two Column 3

Publishing Middle Two Column 4

Publishing Middle Three Column 1

Publishing Middle Three Column 2

Publishing Middle Three Column 3

Publishing Bottom One Column

Publishing Bottom Two Column 1

Publishing Bottom Two Column 2

Publishing Bottom Two Column 3

Publishing Bottom Two Column 4

PBTCO

PBTCW

PBTCT

Search

Introduction Contents List Support User Tips How To Use The DED

Frequently Used Files Employment Data Files Comparison Leave Data Files Comparison Payment Data Files Comparison Joins (Pre-Programmed)

Active Current Status (AC) Annual Current Status (AN)A54 Transaction Data (A54)Campus Header (CH) Employment History Extract (EH)Job Code (JC)Leave Balance Information (LB)Leave Benefit Information (LD)Leave Employee History Information (LH)Leave Transaction Information (LR)State Service Balance and Transactions (LS)Leave Employee Specific Information (LV)Leave Accounting Summary (LX)Payment History Data (PH)Payment History Summary (PHS)Payment History Extract (PY)Separated Current Status (SP)Student Assistant (ST)Transaction Data (TR)Unemployment Insurance Costs (UI)

Systemwide Active Current Status (SAC)Systemwide Annual Current Status (SAN)Systemwide Pay Scales (PS)Systemwide Transaction Data (STR)

Cross-Referenced Files Overview Agency/Campus/Fund Budget Function Campus Address Collective Bargaining Id Dental ID Employee Category Affirmative Action Group Budget Occupational Code Department Degree Level Higher Education General Info. Survey Occupational Index School

Payment History Extract - Decentralized Format Payment History Extract - PC Edit Format Payment History Extract - SCO Production Format Systemwide Pay Scales - Production Format

Academic Year Class Accounts Receivable Code Accounts Receivable Dock Time Code Accounts Receivable Number Accounts Receivable Payment Type Accounts Receivable Taxable Gross Accounts Receivable Type Accrual Rate Accrual Rate Indicator Activity Indicator Address Withheld Indicator Adjustment Code Affirmative Action Code Age Agency and Unit Key Agency Code All Campuses Amount Due Anniversary Date Annual Salary Rate Appointment Expiration Date Appointment Type Leave Code Assigned Salary Rate Audit Information Balance Indicator Base Class Base Class And Range Base Pay Base Range Basic Life Agency Code Basic Life CBID Basic Life Reporting Unit Basic Life State Share Amount Begin Balance Begin Days, Leave Begin Fraction, Leave Begin Hours, Leave Begin Total Benefit Out-of-Service Flag Benefit Quarter Birthdate Budget Function Code Budget Function Name Budget Occupational Code Budget Occupational Code Name Business Year Campus Address, City, State and Zip Campus Address, Street Campus Alpha Code Campus Numeric Code / SSA Campus Name, Abbreviated Campus Name, Full Campus Numeric Code Claim Begin Date Claim End Date CLAS Class and Range Key Class Code Class Code Status Class Established Date Class Title, Abbreviated Class Title, Full Clearance Number Clearance Type Collective Bargaining Id, Code Collective Bargaining Id, Abbreviated Name Collective Bargaining Id, Full Name Computational Factor, Annual Credit Indicator Cruise Indicator CTO FLSA Indicator CTO Maximum Hours CTO Regular Indicator Cycle Cycle Date Data as of Date Data Overflow Indicator Data Overflow Indicator - More Info Days Paid Days Worked, Leave Deduction Amount Deduction Code Deduction Code Name Deduction Id Deduction Pay Period Date Deduction Pay Period Type Deduction Tax Gross Indicator Deduction Type Deduction Type - Character 1 Deduction Type - Character 2 Degree, Education Level Code Degree, Highest Degree Date Degree, Institute Code Degree, Name Dental Carrier Name Department Code Department Name Detail Transaction Code Disability Status Disability Status Code Disability Status Factors Dock Days Dock Hours Document Processing Number Duration Of Appointment Code

Earnings Id Effective Date (MMDDYYYY)Effective Date (YYYYMMDD)Effective Day Effective End Date Effective Month Effective Year EH Position Out-Of-Service Eligibility Indicator Eligibility Substantiation (Furlough Code)Employee Address, City and State Employee Address, Street Employee Address, Zip Code Employee Category Code Employee Category Name Employee Status Code Employer Account Code Employer Branch Number Employer Identifier Employment Date Employment History Remarks Employment Months Employment Years Ending Balance, Leave End Date, Leave Entry Date Established Date, Leave Ethnic Group Ethnic Group name Ethnic Origin Extension Faculty Hourly Rate Extension Faculty Maximum Rate, Range G Extension Faculty Quarter Rate, Maximum Extension Faculty Semester Rate, Maximum Fair Labor Standards Act Status Federal Tax Gross Federal Tax Withheld Federal Marital Status Federal Tax Exemption File Update Schedule Final Salary Anniversary Date Fiscal Year Ending FLSA CTO Amount Footnote/Trade Rate Code Fractional Amount Fractional Month Activity Full-Time Equivalent Full-Time Equivalent (3 decimal Places)Full-Time Total Fund Name Garnishment Effective Date Garnishment Original Amount Garnishment Termination Date Gross Pay Gross Subject to Retirement Gross Type GSI Amount #1 GSI Amount #2 Header Budget Agency Header CFIS Fiscal Year Header Description Header Description Line Count Header Description Line Number Header Effective Date Header Expiration Date Header Fund Identification Header Last Update Health Benefits Administrative Cost health Benefits Agency Code Health Benefits Party Rate Code Health Benefits Plan Type health Benefits Reporting Unit Health Benefits State Share Amount HEGIS Hours Paid Hours Worked, Leave HR Letter

IDL Offset Amount Injury/Illness Code Injury/Illness Date Invoice Number Issue Date Job Code Job Code / Campus Code Job Code Campus Organization Code Job Code Campus Organization Title Job Code Category Job Category Title Job Code Family Job Code Family Title Job Code Title, Full Job Code Title, Abbreviated Job Family, Affirmative Action Job Family Name, Affirmative Action Job Function Job Function Title Job Group, AA Job Group Sub-Category Name, AA Job Group Category Name, AA Laboratory / Activity Hourly Rate Last Accrued Last Day Physically Worked Last Leave Processing Leave Period Last Update Leave Balance Leave Benefit Category Leave Benefit Name Leave Benefit Type Leave Benefit Measure Leave Non-Standard Rate Leave Period Leave Period End Leave Period Hours Earned Leave Period Hours Used Leave Period Start Leave System Eligible/Ineligible Date Leave System Eligible, Position Count Leave Type Sort Sequence Leave Without Pay Indicator Lecture Hourly Rate Legal Reference Code Legal Reference for Annuitant List Count Lump Sum Pay Period

Management Data Element #1 Management Data Element #2 Management Data Element #3 Maximum Rate health Benefits, Agency Code Medicare Arrears, Employee Gross health Benefits, Reporting Unit Medicare Arrears, Employer Gross Medicare Arrears, Employer Withheld Medicare Arrears - Fiscal Year Medicare Arrears, Issue Year Medicare Arrears, Quarter Medicare Tax Gross, Employee Medicare Tax Gross, Employer Medicare Tax Withheld, Employee Medicare Tax Withheld, Employer Minimum Rate Miscellaneous Indicator, Leave Month Amount MPP AGL Indicator Multiple Hourly Rate Name, First and Middle Initial Name, First Initial Name, Last Name, Middle Initial Name, Whole Net Pay Noncitizen Tax Treaty Country Code Noncitizen Tax Residency Status Noncitizen Status Code Noncitizen Immigration/Visa Category Noncitizen Work Authorization Expiration Date Nonqualifying Pay Period Non-Standard Begin Date Non-Standard End Date Non-Standard Rate Non-Work Leave Period 1 Non-Work Leave Period 2 Non-Work Leave Period 3 No Accrual, Begin Leave Period No Accrual, End Leave Period Number Of Steps Number Of Steps To Advance Occupational Index Name Occupational Index Reference Organization Code Origin Code, Leave Out of Sequence Date Out Of Service Indicator Out Of Service Leave Period Overtime Code Part-Time Total Payment Type Payment Type, Suffix Payroll Status Pay Frequency Pay Letter Number Pay Period, Date Pay Period, Type Pay Plan Indicator Personal Holiday Flag Position Position Flag Position Number Position Sequence Number Position Sequence Post Date Post Date Post Time Premium Amount Premium Overtime Probationary Period Code Probationary Period Ending Date Probationary Period Group Probationary Period/Tenure Track Processing Date Professional License Expiration Date Professional License Type

Quarter Rate, Range B Quarter Rate, Range C Range Code Range Title Reallocation Class Code Reason For Resignation Record Changed Date Record Type Recruitment Location, FICE Code Recruitment Location, Type of School Red Circle Rate (Plus Salary)Registered Warrant Regular CTO Reporting Unit Retired Status Retirement Arrears Account Code Retirement Arrears Adjustment Code Retirement Arrears Agency Code Retirement Arrears Gross Subject to Retirement Retirement Arrears Payment Type Retirement Arrears Reporting Unit Retirement Arrears Retirement Rate Retirement Arrears Salary Rate Retirement Arrears Salary Type Retirement Arrears State Share Amount Retirement Employee Paid Member Contrib.Retirement Membership Effective Date Retirement Rate Retirement System Account Code Retirement System State Share Amount Retirement Withheld Retire Flag Roll Code Rule Indicator Run Date Sabbatical Leave Eligibility Date Safety Member Salary Full Salary Per Salary Plan Salary Rate Salary Step Salary Total (Actual Salary)Salary Type School Code School Name SCO Keyed Flag Segment Count Level Four Segment Count Level Three Segment Count Level Two Semester Rate, Range C Semester Rate, Range B Separation Code Separation Code, Leave Separation Expiration Date/Payroll Return Date Serial Number Settlement Pay Sex Code Shift Differential Sick Leave At Retirement Sick Leave Benefit Established Sick Leave Rate Six Month Increase (SISA)Social Security/Medicare Member Social Security Arrears, Agency Code Social Security Arrears, Employee Gross Social Security Arrears, Employer Gross Social Security Arrears, Employer Withheld Social Security Arrears, Issue Year Social Security Arrears, Quarter Social Security Arrears, Reporting Unit Social Security Arrears, Fiscal Year Social Security Number Social Security Number, Last 4 Digits Social Security Number, Masked Source Identifier Special Pay, Amount Due Special Pay, Days 1 & 2 Special Pay, Hours 1 & 2 Special Pay, Rate 1 & 2 Special Pay, Units 1 & 2 SSA/Position Sequence Key SSI Amount SSI Counter SSI Maximum Counter SSI Maximum Step SSI Rate Social Security Tax Gross, Employee Social Security Tax Gross, Employer Social Security Withheld, Employee Social Security Withheld, Employer State Code 1 & 2 State Itemized Allowances State Marital Status State Service End Days State Service End Fraction State Service End Hours State Service Flag State Service Monthly Balance State Service No Information Flag State Service Out-Of-Service Leave Period State Service Out-Of-Service Indicator State System Eligibility Indicator State Tax Exemptions State Tax Gross - 1 & 2 State Tax Withheld - 1 & 2 Status, No Probation Status, Permanent Status, Probationary Status, Temporary Step 1 Rate - Step 45 Rate Step Maximum Step Minimum Suffix Summarized Employee Summarized Record Summarized Record Criteria Summer Maximum Rate, Range C Summer Minimum, Rate Range C Summer Quarter Rate, Range A Summer Quarter Rate, Range B Summer Semester Rate, Range A Summer Semester Rate, Range B Survivors Benefits Suspended Class Code Tax Year TD/IDL Benefit Date Temporary Separation Begin Temporary Separation End Termination Destination, FICE Code Termination Destination, Location Time Base Time Base Denominator Time Base Numerator Time Worked Days Indicator Time Worked Hours Indicator Total Amount Used Total Credit Amount Total Days Total Fractions Total Hours Total Miscellaneous Track Class Transaction Amount Transaction Code, Name Transaction Code, Personnel Transaction Code, Type Transaction Count Transaction Type, LR Transaction Type, LS Transferred SSA Transfer Leave Type - Abbreviated T-Step Flag T-Step Salary Rate Type Field, E - Extension Faculty Type Field, F - Special Variable Rate Type Field, C-Step Rates Type Field, D - Annual Salary Type Field, G - Substitute Faculty Type Field, H - Summer Session Faculty

Units Paid User Designated Eligibility Date User Designated Eligibility Indicator Use Indicator Vacation Benefit Established Vacation Max Hours Vacation Max Non-Determine Flag Vacation Non-Standard Flag Vacation No Change Flag Vacation Over Max Flag Vacation Rate Vacation Rate Change Date Vacation Rate Change Flag Vacation Rate Code Vacation Rate Max Flag Vacation Rate Next Vacation Rate Next Max Hours Void Date Void Indicator Warrant Number Work Location

Define Expressions Formatting Commands Match Command Sample Report Requests

Appendix III - Budget Occupation Codes Appendix II - Collective Bargaining Id Appendix IV - Footnote/Trade Rate Codes Appendix IX - Job Group AA Appendix I - Campus Codes Appendix VIII - Leave Benefits Appendix VII - Personnel Transactions Appendix VI - Tax Treaty Country Code Appendix V - Occupational Index Reference

EHDB Format Type CLAS

Apply
Impact of the CSU
The CSU System
Resource Center

Apply
Donate
News
Careers
Contact

California State University
Office of the Chancellor

401 Golden Shore
Long Beach CA 90802

(562) 951-4000

Maps and Directions

‹ ›