Payroll Personnel System Title Code Table Data Dictionary

Please note: this Data Dictionary page is pending a technical review, and may not be up to date.

TCT1010TITLE CODE-TCITCI_TITLE_CODE in PPPTCI
TCT1020COMMON INFORMATION EFFECTIVE DATETCI_EFFECTIVE_DATE in PPPTCI
TCT1030TITLE NAMETCI_TITLE_NAME in PPPTCI
TCT1040TITLE NAME ABBREVIATIONTCI_TITLE_NM_ABBRV in PPPTCI
TCT1050PERSONNEL PROGRAM CODETCI_PERSONL_PGM_CD in PPPTCI
TCT1060STAFF SUPERVISORY TITLE FLAGTCI_SUPERVISOR_FLG in PPPTCI
TCT1070CLASS TITLE OUTLINE/OCCUPATIONAL SUBGRP CODETCI_CTO_OSC in PPPTCI
TCT1080FEDERAL OCCUPATIONAL CATEGORYTCI_FOC in PPPTCI
TCT1090FOC SUBCATEGORY CODETCI_FOC_SUBCAT_CD in PPPTCI
TCT1100RETIREMENT CODE ITCI_RETIRE_CODE_1 in PPPTCI
TCT1110RETIREMENT CODE IITCI_RETIRE_CODE_2 in PPPTCI
TCT1120HEALTH CARE FLAGTCI_HEALTH_FLAG in PPPTCI
TCT1130DATE TITLE CODE ABOLISHEDTCI_TITLE_ABOL_DT in PPPTCI
TCT1140LAST CLASSIFICATION REVIEW DATETCI_LAST_CLS_RV_DT in PPPTCI
TCT1150TITLE UNIT CODETCI_TITLE_UNIT_CD in PPPTCI
TCT1160RELATED 99 TITLE UNIT CODETCI_RELATED_UNIT in PPPTCI
TCT1170TITLE SPECIAL HANDLING CODETCI_TITLE_SPCL_HND in PPPTCI
TCT1180STANDARD HOURS PER WEEKTCI_STND_HR_PER_WK in PPPTCI
TCT1190BY AGREEMENT TITLE FLAGTCI_BY_AGREEM_FLAG in PPPTCI
TCT1200LINKAGE CODETCI_LINKG_CD_TITLE in PPPTCI
TCT1210USE OF TITLE CODETCI_USE_OF_TITLE in PPPTCI
TCT1220RESTRICTED TITLE FLAGTCI_RESTRIC_TTL_FLG in PPPTCI
TCT1230DATE TITLE CODE FROZENTCI_FRZN_TITLE_DT in PPPTCI
TCT1240ALL FLAGTCI_ALL_FLAG in PPPTCI
TCT1250STANDARD OCCUPATIONAL CLASSIFICATION CODETCI_SOC in PPPTCI
TCT1260UPDATE SOURCE-TCITCI_UPDT_SOURCE in PPPTCI
TCT1270UPDATE TIMESTAMP-TCITCI_UPDT_TIMESTAMP in PPPTCI
TCT2110TITLE CODE-TPATPA_TITLE_CODE in PPPTPA
TCT2120ACADEMIC COMMON INFORMATION EFFECTIVE DATETPA_ACAD_CI_EFF_DT in PPPTPA
TCT2140ACADEMIC RANK CODETPA_ACAD_RANK in PPPTPA
TCT2150SABBATICAL ELIGIBILITY CODETPA_ACAD_SB_ELG_CD in PPPTPA
TCT2160ACADEMIC SERVICE LIMITTPA_ACAD_SERV_LMT in PPPTPA
TCT2170ACADEMIC APPOINTMENT TYPE CODETPA_ACAD_APPT_TYPE in PPPTPA
TCT2180ACADEMIC APPOINTMENT BASIS CODETPA_ACAD_APPT_BAS in PPPTPA
TCT2190ACADEMIC PAY PERIOD CODETPA_ACAD_PAY_PERD in PPPTPA
TCT2200ACADEMIC SICK LEAVE ELIGIBILITY CODETPA_ACAD_SICK_ELIG in PPPTPA
TCT2210HEALTH SCIENCE COMPENSATION PLAN FLAGTPA_HSCP_FLAG in PPPTPA
TCT2220OFF-SCALE INDICATORTPA_OFF_SCALE_FLAG in PPPTPA
TCT2230UPDATE SOURCE-TPATPA_UPDT_SOURCE in PPPTPA
TCT2240UPDATE TIMESTAMP-TPATPA_UPDT_TIMESTAMP in PPPTPA
TCT2310TITLE CODE-TPBTPB_TITLE_CODE in PPPTPB
TCT2320ACADEMIC RATE SET EFFECTIVE DATE-TPBTPB_ACAD_RS_EFF_DT in PPPTPB
TCT2330ACADEMIC RATE SET END DATE-TPBTPB_ACAD_RS_END_DT in PPPTPB
TCT2340ACADEMIC PAY REPRESENTATION CODE-TPBTPB_PAY_REP_CODE in PPPTPB
TCT2350ACADEMIC RANGE ADJUSTMENT ID CODE-TPBTPB_RANGE_ADJ_ID in PPPTPB
TCT2360ACADEMIC NUMBER OF STEPSTPB_NO_STEPS in PPPTPB
TCT2370ACADEMIC NUMBER OF PAY INTERVALSTPB_NO_PAY_INTRVLS in PPPTPB
TCT2380ACADEMIC COMPENSATION GROUP CODETPB_ACAD_COMP_GRP in PPPTPB
TCT2390UPDATE SOURCE-TPBTPB_UPDT_SOURCE in PPPTPB
TCT2400UPDATE TIMESTAMP-TPBTPB_UPDT_TIMESTAMP in PPPTPB
TCT2510TITLE CODE-TPCTPC_TITLE_CODE in PPPTPC
TCT2520ACADEMIC RATE SET EFFECTIVE DATE-TPCTPC_ACAD_RS_EFF_DT in PPPTPC
TCT2530ACADEMIC RATE SET END DATE-TPCTPC_ACAD_RS_END_DT in PPPTPC
TCT2540ACADEMIC PAY REPRESENTATION CODE-TPCTPC_PAY_REP_CODE in PPPTPC
TCT2550ACADEMIC RANGE ADJUSTMENT ID CODE-TPCTPC_RANGE_ADJ_ID in PPPTPC
TCT2560ACADEMIC PAY INTERVALTPC_PAY_INTERVAL in PPPTPC
TCT2570ACADEMIC PAY RATE-MONTHLY FORMATTPC_MO_RATE in PPPTPC
TCT2580ACADEMIC PAY RATE-HOURLY FORMATTPC_HR_RATE in PPPTPC
TCT2590UPDATE SOURCE-TPCTPC_UPDT_SOURCE in PPPTPC
TCT2600UPDATE TIMESTAMP-TPCTPC_UPDT_TIMESTAMP in PPPTPC
TCT3310TITLE CODE-TSLTSL_TITLE_CODE in PPPTSL
TCT3320SUBLOCATION-TSLTSL_SUB_LOCATION in PPPTSL
TCT3330PAY REPRESENTATION CODE-TSLTSL_PAY_REP_CODE in PPPTSL
TCT3340EFFECTIVE DATE-TSLTSL_EFFECTIVE_DATE in PPPTSL
TCT3350FLSA STATUS CODETSL_FLSA_STATUS_CD in PPPTSL
TCT3360OVERTIME EXEMPTION CODETSL_OVRTM_EXMPT_CD in PPPTSL
TCT3370SIX MONTH INCREASE ELIGIBILITY CODETSL_SIX_MONTH_CD in PPPTSL
TCT3380RATE LOOKUP CODETSL_RATE_LOOKUP_CD in PPPTSL
TCT3390JOB GROUP IDTSL_JOB_GROUP_ID in PPPTSL
TCT3400UPDATE SOURCE-TSLTSL_UPDT_SOURCE in PPPTSL
TCT3410UPDATE TIMESTAMP-TSLTSL_UPDT_TIMESTAMP in PPPTSL
TCT4310TITLE CODE-TSBTSB_TITLE_CODE in PPPTSB
TCT4320SUBLOCATION-TSBTSB_SUB_LOCATION in PPPTSB
TCT4330PAY REPRESENTATION CODE-TSBTSB_PAY_REP_CODE in PPPTSB
TCT4340EFFECTIVE DATE-TSBTSB_EFFECTIVE_DATE in PPPTSB
TCT4350END DATE-TSBTSB_END_DATE in PPPTSB
TCT4360RANGE ADJUSTMENT ID-TSBTSB_RANGE_ADJ_ID in PPPTSB
TCT4370NUMBER OF STEPSTSB_NO_STEPS in PPPTSB
TCT4380NUMBER OF PAY INTERVALSTSB_NO_PAY_INTERVALS in PPPTSB
TCT4390STAFF STEP/SCALE EXCEPTION FLAGTSB_SSP_SS_EXCPT in PPPTSB
TCT4400MERIT FLAGTSB_MERIT_BASED in PPPTSB
TCT4410MEMO GRADETSB_MEMO_GRADE in PPPTSB
TCT4420UPDATE SOURCE-TSBTSB_UPDT_SOURCE in PPPTSB
TCT4430UPDATE TIMESTAMP-TSBTSB_UPDT_TIMESTAMP in PPPTSB
TCT5310TITLE CODE-TRRTRR_TITLE CODE in PPPTRR
TCT5320SUBLOCATION-TRRTRR_SUB_LOCATION in PPPTRR
TCT5330PAY REPRESENTATION CODE-TRRTRR_PAY_REP_CODE in PPPTRR
TCT5340EFFECTIVE DATE-TRRTRR_EFFECTIVE_DATE in PPPTRR
TCT5350END DATE-TRRTRR_END_DATE in PPPTRR
TCT5360RANGE ADJUSTMENT ID-TRRTRR_RANGE_ADJ_ID in PPPTRR
TCT5370PAY INTERVALTRR_PAY_INTERVAL in PPPTRR
TCT5380MONTHLY RATETRR_MO_RATE in PPPTRR
TCT5390HOURLY RATETRR_HR_RATE in PPPTRR
TCT5400ALTERNATE RATETRR_ALT_RATE in PPPTRR
TCT5410UPDATE SOURCE-TRRTRR_UPDT_SOURCE in PPPTRR
TCT5420UPDATE TIMESTAMP-TRRTRR_UPDT_TIMESTAMP inn PPPTRR
TCT6310TITLE CODE-TORTOR_TITLE_CODE in PPPTOR
TCT6320SUBLOCATION-TORTOR_SUB_LOCATION in PPPTOR
TCT6330PAY REPRESENTATION CODE-TORTOR_PAY_REP_CODE in PPPTOR
TCT6340EFFECTIVE DATE-TORTOR_EFFECTIVE_DATE in PPPTOR
TCT6350END DATE-TORTOR_END_DATE in PPPTOR
TCT6360ON CALL CODETOR_ON_CALL_CODE in PPPTOR
TCT6370ON CALL RATE TYPETOR_RATE_TYPE in PPPTOR
TCT6380ON CALL RATETOR_ON_CALL_RATE in PPPTOR
TCT6390UPDATE SOURCE-TORTOR_UPDT_SOURCE in PPPTOR
TCT6400UPDATE TIMESTAMP-TORTOR_UPDT_TIMESTAMP in PPPTOR
TCT7310TITLE CODE-TSRTSR_TITLE_CODE in PPPTSR
TCT7320SUBLOCATION-TSRTSR_SUB_LOCATION in PPPTSR
TCT7330PAY REPRESENTATION CODE-TSRTSR_PAY_REP_CODE in PPPTSR
TCT7340EFFECTIVE DATE-TSRTSR_EFFECTIVE_DATE in PPPTSR
TCT7350END DATE-TSRTSR_END_DATE in PPPTSR
TCT7360RANGE ADJUSTMENT ID-TSRTSR_RANGE_ADJ_ID in PPPTSR
TCT7370SHIFT TYPETSR_SHIFT_TYPE in PPPTSR
TCT7380SHIFT RATE TYPETSR_RATE_TYPE in PPPTSR
TCT7390SHIFT RATETSR_SHIFT_RATE in PPPTSR
TCT7400UPDATE SOURCE-TSRTSR_UPDT_SOURCE in PPPTSR
TCT7410UPDATE TIMESTAMP-TSRTSR_UPDT_TIMESTAMP in PPPTSR
TCT8310TITLE CODE-TGBTGB_TITLE_CODE in PPPTGB
TCT8320SUBLOCATION-TGBTGB_SUB_LOCATION in PPPTGB
TCT8330PAY REPRESENTATION CODE-TGBTGB_PAY_REP_CODE in PPPTGB
TCT8340EFFECTIVE DATE-TGBTGB_EFFECTIVE_DATE in PPPTGB
TCT8350GRADE TYPE-TGBTGB_GRADE_TYPE in PPPTGB
TCT8360GRADE-TGBTGB_GRADE in PPPTGB
TCT8370UPDATE SOURCE-TGBTGB_UPDT_SOURCE in PPPTGB
TCT8380UPDATE TIMESTAMP-TGBTGB_UPDT_TIMESTAMP in PPPTGB
TCT9310SUBLOCATION-SGTSGT_SUB_SUBLOCATION in PPPSGT
TCT9320PAY REPRESENTATION CODE-SGTSGT_PAY_REP_CODE in PPPSGT
TCT9330GRADE TYPE-SGTSGT_GRADE_TYPE in PPPSGT
TCT9340GRADE-SGTSGT_GRADE in PPPSGT
TCT9350EFFECTIVE DATE-SGTSGT_EFFECTIVE_DATE in PPPSGT
TCT9360END DATE-SGTSGT_END_DATE in PPPSGT
TCT9370SALARY RANGE-MINIMUMSGT_SAL_RANGE_MIN in PPPSGT
TCT9380SALARY RANGE-MIDPOINTSGT_SAL_RANGE_MID in PPPSGT
TCT9390SALARY RANGE-MAXIMUMSGT_SAL_RANGE_MAX in PPPSGT
TCT9400UPDATE SOURCE-SGTSGT_UPDT_SOURCE in PPPSGT
TCT9410UPDATE TIMESTAMP-SGTSGT_UPDT_TIMESTAMP in PPPSGT

Last Updated on 3/14/05