Please note: this Data Dictionary page is pending a technical review, and may not be up to date.
| TCT1010 | TITLE CODE-TCI | TCI_TITLE_CODE in PPPTCI |
| TCT1020 | COMMON INFORMATION EFFECTIVE DATE | TCI_EFFECTIVE_DATE in PPPTCI |
| TCT1030 | TITLE NAME | TCI_TITLE_NAME in PPPTCI |
| TCT1040 | TITLE NAME ABBREVIATION | TCI_TITLE_NM_ABBRV in PPPTCI |
| TCT1050 | PERSONNEL PROGRAM CODE | TCI_PERSONL_PGM_CD in PPPTCI |
| TCT1060 | STAFF SUPERVISORY TITLE FLAG | TCI_SUPERVISOR_FLG in PPPTCI |
| TCT1070 | CLASS TITLE OUTLINE/OCCUPATIONAL SUBGRP CODE | TCI_CTO_OSC in PPPTCI |
| TCT1080 | FEDERAL OCCUPATIONAL CATEGORY | TCI_FOC in PPPTCI |
| TCT1090 | FOC SUBCATEGORY CODE | TCI_FOC_SUBCAT_CD in PPPTCI |
| TCT1100 | RETIREMENT CODE I | TCI_RETIRE_CODE_1 in PPPTCI |
| TCT1110 | RETIREMENT CODE II | TCI_RETIRE_CODE_2 in PPPTCI |
| TCT1120 | HEALTH CARE FLAG | TCI_HEALTH_FLAG in PPPTCI |
| TCT1130 | DATE TITLE CODE ABOLISHED | TCI_TITLE_ABOL_DT in PPPTCI |
| TCT1140 | LAST CLASSIFICATION REVIEW DATE | TCI_LAST_CLS_RV_DT in PPPTCI |
| TCT1150 | TITLE UNIT CODE | TCI_TITLE_UNIT_CD in PPPTCI |
| TCT1160 | RELATED 99 TITLE UNIT CODE | TCI_RELATED_UNIT in PPPTCI |
| TCT1170 | TITLE SPECIAL HANDLING CODE | TCI_TITLE_SPCL_HND in PPPTCI |
| TCT1180 | STANDARD HOURS PER WEEK | TCI_STND_HR_PER_WK in PPPTCI |
| TCT1190 | BY AGREEMENT TITLE FLAG | TCI_BY_AGREEM_FLAG in PPPTCI |
| TCT1200 | LINKAGE CODE | TCI_LINKG_CD_TITLE in PPPTCI |
| TCT1210 | USE OF TITLE CODE | TCI_USE_OF_TITLE in PPPTCI |
| TCT1220 | RESTRICTED TITLE FLAG | TCI_RESTRIC_TTL_FLG in PPPTCI |
| TCT1230 | DATE TITLE CODE FROZEN | TCI_FRZN_TITLE_DT in PPPTCI |
| TCT1240 | ALL FLAG | TCI_ALL_FLAG in PPPTCI |
| TCT1250 | STANDARD OCCUPATIONAL CLASSIFICATION CODE | TCI_SOC in PPPTCI |
| TCT1260 | UPDATE SOURCE-TCI | TCI_UPDT_SOURCE in PPPTCI |
| TCT1270 | UPDATE TIMESTAMP-TCI | TCI_UPDT_TIMESTAMP in PPPTCI |
| TCT2110 | TITLE CODE-TPA | TPA_TITLE_CODE in PPPTPA |
| TCT2120 | ACADEMIC COMMON INFORMATION EFFECTIVE DATE | TPA_ACAD_CI_EFF_DT in PPPTPA |
| TCT2140 | ACADEMIC RANK CODE | TPA_ACAD_RANK in PPPTPA |
| TCT2150 | SABBATICAL ELIGIBILITY CODE | TPA_ACAD_SB_ELG_CD in PPPTPA |
| TCT2160 | ACADEMIC SERVICE LIMIT | TPA_ACAD_SERV_LMT in PPPTPA |
| TCT2170 | ACADEMIC APPOINTMENT TYPE CODE | TPA_ACAD_APPT_TYPE in PPPTPA |
| TCT2180 | ACADEMIC APPOINTMENT BASIS CODE | TPA_ACAD_APPT_BAS in PPPTPA |
| TCT2190 | ACADEMIC PAY PERIOD CODE | TPA_ACAD_PAY_PERD in PPPTPA |
| TCT2200 | ACADEMIC SICK LEAVE ELIGIBILITY CODE | TPA_ACAD_SICK_ELIG in PPPTPA |
| TCT2210 | HEALTH SCIENCE COMPENSATION PLAN FLAG | TPA_HSCP_FLAG in PPPTPA |
| TCT2220 | OFF-SCALE INDICATOR | TPA_OFF_SCALE_FLAG in PPPTPA |
| TCT2230 | UPDATE SOURCE-TPA | TPA_UPDT_SOURCE in PPPTPA |
| TCT2240 | UPDATE TIMESTAMP-TPA | TPA_UPDT_TIMESTAMP in PPPTPA |
| TCT2310 | TITLE CODE-TPB | TPB_TITLE_CODE in PPPTPB |
| TCT2320 | ACADEMIC RATE SET EFFECTIVE DATE-TPB | TPB_ACAD_RS_EFF_DT in PPPTPB |
| TCT2330 | ACADEMIC RATE SET END DATE-TPB | TPB_ACAD_RS_END_DT in PPPTPB |
| TCT2340 | ACADEMIC PAY REPRESENTATION CODE-TPB | TPB_PAY_REP_CODE in PPPTPB |
| TCT2350 | ACADEMIC RANGE ADJUSTMENT ID CODE-TPB | TPB_RANGE_ADJ_ID in PPPTPB |
| TCT2360 | ACADEMIC NUMBER OF STEPS | TPB_NO_STEPS in PPPTPB |
| TCT2370 | ACADEMIC NUMBER OF PAY INTERVALS | TPB_NO_PAY_INTRVLS in PPPTPB |
| TCT2380 | ACADEMIC COMPENSATION GROUP CODE | TPB_ACAD_COMP_GRP in PPPTPB |
| TCT2390 | UPDATE SOURCE-TPB | TPB_UPDT_SOURCE in PPPTPB |
| TCT2400 | UPDATE TIMESTAMP-TPB | TPB_UPDT_TIMESTAMP in PPPTPB |
| TCT2510 | TITLE CODE-TPC | TPC_TITLE_CODE in PPPTPC |
| TCT2520 | ACADEMIC RATE SET EFFECTIVE DATE-TPC | TPC_ACAD_RS_EFF_DT in PPPTPC |
| TCT2530 | ACADEMIC RATE SET END DATE-TPC | TPC_ACAD_RS_END_DT in PPPTPC |
| TCT2540 | ACADEMIC PAY REPRESENTATION CODE-TPC | TPC_PAY_REP_CODE in PPPTPC |
| TCT2550 | ACADEMIC RANGE ADJUSTMENT ID CODE-TPC | TPC_RANGE_ADJ_ID in PPPTPC |
| TCT2560 | ACADEMIC PAY INTERVAL | TPC_PAY_INTERVAL in PPPTPC |
| TCT2570 | ACADEMIC PAY RATE-MONTHLY FORMAT | TPC_MO_RATE in PPPTPC |
| TCT2580 | ACADEMIC PAY RATE-HOURLY FORMAT | TPC_HR_RATE in PPPTPC |
| TCT2590 | UPDATE SOURCE-TPC | TPC_UPDT_SOURCE in PPPTPC |
| TCT2600 | UPDATE TIMESTAMP-TPC | TPC_UPDT_TIMESTAMP in PPPTPC |
| TCT3310 | TITLE CODE-TSL | TSL_TITLE_CODE in PPPTSL |
| TCT3320 | SUBLOCATION-TSL | TSL_SUB_LOCATION in PPPTSL |
| TCT3330 | PAY REPRESENTATION CODE-TSL | TSL_PAY_REP_CODE in PPPTSL |
| TCT3340 | EFFECTIVE DATE-TSL | TSL_EFFECTIVE_DATE in PPPTSL |
| TCT3350 | FLSA STATUS CODE | TSL_FLSA_STATUS_CD in PPPTSL |
| TCT3360 | OVERTIME EXEMPTION CODE | TSL_OVRTM_EXMPT_CD in PPPTSL |
| TCT3370 | SIX MONTH INCREASE ELIGIBILITY CODE | TSL_SIX_MONTH_CD in PPPTSL |
| TCT3380 | RATE LOOKUP CODE | TSL_RATE_LOOKUP_CD in PPPTSL |
| TCT3390 | JOB GROUP ID | TSL_JOB_GROUP_ID in PPPTSL |
| TCT3400 | UPDATE SOURCE-TSL | TSL_UPDT_SOURCE in PPPTSL |
| TCT3410 | UPDATE TIMESTAMP-TSL | TSL_UPDT_TIMESTAMP in PPPTSL |
| TCT4310 | TITLE CODE-TSB | TSB_TITLE_CODE in PPPTSB |
| TCT4320 | SUBLOCATION-TSB | TSB_SUB_LOCATION in PPPTSB |
| TCT4330 | PAY REPRESENTATION CODE-TSB | TSB_PAY_REP_CODE in PPPTSB |
| TCT4340 | EFFECTIVE DATE-TSB | TSB_EFFECTIVE_DATE in PPPTSB |
| TCT4350 | END DATE-TSB | TSB_END_DATE in PPPTSB |
| TCT4360 | RANGE ADJUSTMENT ID-TSB | TSB_RANGE_ADJ_ID in PPPTSB |
| TCT4370 | NUMBER OF STEPS | TSB_NO_STEPS in PPPTSB |
| TCT4380 | NUMBER OF PAY INTERVALS | TSB_NO_PAY_INTERVALS in PPPTSB |
| TCT4390 | STAFF STEP/SCALE EXCEPTION FLAG | TSB_SSP_SS_EXCPT in PPPTSB |
| TCT4400 | MERIT FLAG | TSB_MERIT_BASED in PPPTSB |
| TCT4410 | MEMO GRADE | TSB_MEMO_GRADE in PPPTSB |
| TCT4420 | UPDATE SOURCE-TSB | TSB_UPDT_SOURCE in PPPTSB |
| TCT4430 | UPDATE TIMESTAMP-TSB | TSB_UPDT_TIMESTAMP in PPPTSB |
| TCT5310 | TITLE CODE-TRR | TRR_TITLE CODE in PPPTRR |
| TCT5320 | SUBLOCATION-TRR | TRR_SUB_LOCATION in PPPTRR |
| TCT5330 | PAY REPRESENTATION CODE-TRR | TRR_PAY_REP_CODE in PPPTRR |
| TCT5340 | EFFECTIVE DATE-TRR | TRR_EFFECTIVE_DATE in PPPTRR |
| TCT5350 | END DATE-TRR | TRR_END_DATE in PPPTRR |
| TCT5360 | RANGE ADJUSTMENT ID-TRR | TRR_RANGE_ADJ_ID in PPPTRR |
| TCT5370 | PAY INTERVAL | TRR_PAY_INTERVAL in PPPTRR |
| TCT5380 | MONTHLY RATE | TRR_MO_RATE in PPPTRR |
| TCT5390 | HOURLY RATE | TRR_HR_RATE in PPPTRR |
| TCT5400 | ALTERNATE RATE | TRR_ALT_RATE in PPPTRR |
| TCT5410 | UPDATE SOURCE-TRR | TRR_UPDT_SOURCE in PPPTRR |
| TCT5420 | UPDATE TIMESTAMP-TRR | TRR_UPDT_TIMESTAMP inn PPPTRR |
| TCT6310 | TITLE CODE-TOR | TOR_TITLE_CODE in PPPTOR |
| TCT6320 | SUBLOCATION-TOR | TOR_SUB_LOCATION in PPPTOR |
| TCT6330 | PAY REPRESENTATION CODE-TOR | TOR_PAY_REP_CODE in PPPTOR |
| TCT6340 | EFFECTIVE DATE-TOR | TOR_EFFECTIVE_DATE in PPPTOR |
| TCT6350 | END DATE-TOR | TOR_END_DATE in PPPTOR |
| TCT6360 | ON CALL CODE | TOR_ON_CALL_CODE in PPPTOR |
| TCT6370 | ON CALL RATE TYPE | TOR_RATE_TYPE in PPPTOR |
| TCT6380 | ON CALL RATE | TOR_ON_CALL_RATE in PPPTOR |
| TCT6390 | UPDATE SOURCE-TOR | TOR_UPDT_SOURCE in PPPTOR |
| TCT6400 | UPDATE TIMESTAMP-TOR | TOR_UPDT_TIMESTAMP in PPPTOR |
| TCT7310 | TITLE CODE-TSR | TSR_TITLE_CODE in PPPTSR |
| TCT7320 | SUBLOCATION-TSR | TSR_SUB_LOCATION in PPPTSR |
| TCT7330 | PAY REPRESENTATION CODE-TSR | TSR_PAY_REP_CODE in PPPTSR |
| TCT7340 | EFFECTIVE DATE-TSR | TSR_EFFECTIVE_DATE in PPPTSR |
| TCT7350 | END DATE-TSR | TSR_END_DATE in PPPTSR |
| TCT7360 | RANGE ADJUSTMENT ID-TSR | TSR_RANGE_ADJ_ID in PPPTSR |
| TCT7370 | SHIFT TYPE | TSR_SHIFT_TYPE in PPPTSR |
| TCT7380 | SHIFT RATE TYPE | TSR_RATE_TYPE in PPPTSR |
| TCT7390 | SHIFT RATE | TSR_SHIFT_RATE in PPPTSR |
| TCT7400 | UPDATE SOURCE-TSR | TSR_UPDT_SOURCE in PPPTSR |
| TCT7410 | UPDATE TIMESTAMP-TSR | TSR_UPDT_TIMESTAMP in PPPTSR |
| TCT8310 | TITLE CODE-TGB | TGB_TITLE_CODE in PPPTGB |
| TCT8320 | SUBLOCATION-TGB | TGB_SUB_LOCATION in PPPTGB |
| TCT8330 | PAY REPRESENTATION CODE-TGB | TGB_PAY_REP_CODE in PPPTGB |
| TCT8340 | EFFECTIVE DATE-TGB | TGB_EFFECTIVE_DATE in PPPTGB |
| TCT8350 | GRADE TYPE-TGB | TGB_GRADE_TYPE in PPPTGB |
| TCT8360 | GRADE-TGB | TGB_GRADE in PPPTGB |
| TCT8370 | UPDATE SOURCE-TGB | TGB_UPDT_SOURCE in PPPTGB |
| TCT8380 | UPDATE TIMESTAMP-TGB | TGB_UPDT_TIMESTAMP in PPPTGB |
| TCT9310 | SUBLOCATION-SGT | SGT_SUB_SUBLOCATION in PPPSGT |
| TCT9320 | PAY REPRESENTATION CODE-SGT | SGT_PAY_REP_CODE in PPPSGT |
| TCT9330 | GRADE TYPE-SGT | SGT_GRADE_TYPE in PPPSGT |
| TCT9340 | GRADE-SGT | SGT_GRADE in PPPSGT |
| TCT9350 | EFFECTIVE DATE-SGT | SGT_EFFECTIVE_DATE in PPPSGT |
| TCT9360 | END DATE-SGT | SGT_END_DATE in PPPSGT |
| TCT9370 | SALARY RANGE-MINIMUM | SGT_SAL_RANGE_MIN in PPPSGT |
| TCT9380 | SALARY RANGE-MIDPOINT | SGT_SAL_RANGE_MID in PPPSGT |
| TCT9390 | SALARY RANGE-MAXIMUM | SGT_SAL_RANGE_MAX in PPPSGT |
| TCT9400 | UPDATE SOURCE-SGT | SGT_UPDT_SOURCE in PPPSGT |
| TCT9410 | UPDATE TIMESTAMP-SGT | SGT_UPDT_TIMESTAMP in PPPSGT |