TCS DB2 File Layouts
Below are the data elements, by DB2 table, contained in the base tables of the Title Code System. This information is from the DDL members contained in the PRO.MNT.DDLLIB MVS library. The Title Code System includes audit tables as well as "base" tables -- the audit tables are used to record online changes made to the base tables, for the purposes of producing audit reports of online changes. Only data elements from the base tables are listed below.
Note: This information was copied from the members of the PRO.MNT.DDLLIB library on August 14, 1998.
Common Information Table (TCSTCIB) - Academic and Non-Academic Titles
Key fields: CIB_TITLE
CIB_TITLE CHAR (0004) CIB_USE CHAR (0001) CIB_SHIFT_USE CHAR (0001) CIB_ONCALL_USE CHAR (0001) CIB_RESTRICTED CHAR (0001) CIB_PERPGM CHAR (0001) CIB_SUPVFLAG CHAR (0001) CIB_FULLNAME CHAR (0150) CIB_TNAME CHAR (0030) CIB_CTO CHAR (0003) CIB_FOCSUB CHAR (0002) CIB_SOC CHAR (0003) CIB_RETIRE CHAR (0001) CIB_SAFETY CHAR (0001) CIB_REVIEWDT DATE CIB_GRADE_FLAG CHAR (0001) CIB_UPDTMSTP TIMESTAMP CIB_UPDID CHAR (0008)
Campus Table (TCSTCCB) - Non-Academic Titles
Key fields: CCB_TITLE, CCB_CAMPUS
Relationships to other tables: CCB_TITLE in TCSTCCB is related to CIB_TITLE in TCSTCIB
CCB_TITLE CHAR (0004) CCB_CAMPUS CHAR (0002) CCB_BYAGREE CHAR (0001) CCB_TUC CHAR (0002) CCB_STND_HRS DEC (0005,02) CCB_LINKAGE CHAR (0003) CCB_APS_HEALTH CHAR (0001) CCB_APS_GRADE CHAR (0002) CCB_OVRTM_EXMPT CHAR (0001) CCB_SIXMTH CHAR (0001) CCB_ABOL_DATE DATE CCB_FRZN_DATE DATE CCB_ALL CHAR (0001) CCB_ONCALL_FLG CHAR (0001) CCB_SHIFT_FLG CHAR (0001) CCB_UPDTMSTP TIMESTAMP CCB_UPDID CHAR (0008) CCB_GRDLKUP_COV CHAR (0001) (added 1996) CCB_GRDLKUP_UNC CHAR (0001) (added 1996)
Staff Rate Set Table (TCSTSSB) - Non-Academic Titles
Key fields: SSB_TITLE, SSB_CAMPUS, SSB_PAYREP, SSB_EFFDATE_BGN, SSB_EFFDATE_END
Relationships to other tables: SSB_TITLE and SSB_CAMPUS in TCSTSSB are related to CCB_TITLE and CCB_CAMPUS in TCSTCCB.
SSB_TITLE CHAR (0004) SSB_CAMPUS CHAR (0002) SSB_PAYREP CHAR (0003) SSB_EFFDATE_BGN DATE SSB_EFFDATE_END DATE SSB_RNGADJID CHAR (0012) SSB_NO_STEPS DEC (0002) SSB_NO_PAY_INT DEC (0003) SSB_STF_EXCEPT CHAR (0001) SSB_PAYSCALE CHAR (0001) SSB_UPDTMSTP TIMESTAMP SSB_UPDID CHAR (0008) SSB_MEMO_GRADE CHAR (0002) (added in 1996) SSB_MERIT CHAR (0001) (added in 1996)
Staff Rates Table (TCSTSRB) - Non-Academic Titles
Key Fields: SRB_TITLE, SRB_CAMPUS, SRB_PAYREP, SRB_EFFDATE_BGN, SRB_EFFDATE_END, SRB_PAY_INT
Relationships to other tables: SRB_TITLE, SRB_CAMPUS, SRB_PAYREP, SRB_EFFDATE_BGN and SRB_EFFDATE_END in TCSTSRB relate to the corresponding fields in TCSTSSB
SRB_TITLE CHAR (0004) SRB_CAMPUS CHAR (0002) SRB_PAYREP CHAR (0003) SRB_EFFDATE_BGN DATE SRB_EFFDATE_END DATE SRB_PAY_INT DEC SRB_RATE DEC SRB_UPDTMSTP TIMESTAMP SRB_UPDID CHAR (0008)
Shift Differential Rates (TCSTDFB) - Non-Academic Titles
Key Fields: DFB_TITLE, DFB_CAMPUS, DFB_PAYREP, DFB_EFFDATE_BGN, DFB_EFFDATE_END
Relationships with other tables: DFB_TITLE and DFB_CAMPUS in TCSTDFB are related to the corresponding fields in TCSTCCB
DFB_TITLE CHAR (0004) DFB_CAMPUS CHAR (0002) DFB_PAYREP CHAR (0003) DFB_EFFDATE_BGN DATE DFB_EFFDATE_END DATE DFB_RNGADJID CHAR (0012) DFB_RATE_DY DEC (0005,02) DFB_RATE_EV DEC (0005,02) DFB_RATE_NT DEC (0005,02) DFB_RATE_SP DEC (0005,02) DFB_RATE_WD DEC (0005,02) DFB_RATE_WE DEC (0005,02) DFB_RATE_WN DEC (0005,02) DFB_UPDTMSTP TIMESTAMP DFB_UPDID CHAR (0008)
On-Call Rates (TCSTOCB) - Non-Academic Titles
Key Fields: OCB_TITLE, OCB_CAMPUS, OCB_PAYREP, OCB_EFFDATE_BGN, OCB_EFFDATE_END
Relationships with other tables: OCB_TITLE and OCB_CAMPUS in TCSTOCB are related to the corresponding fields in TCSTCCB
OCB_TITLE CHAR (0004) OCB_CAMPUS CHAR (0002) OCB_PAYREP CHAR (0003) OCB_EFFDATE_BGN DATE OCB_EFFDATE_END DATE OCB_TYPE_CD1 CHAR (0001) OCB_RATE1 DEC (0005,02) OCB_TYPE_CD2 CHAR (0001) OCB_RATE2 DEC (0005,02) OCB_TYPE_CD3 CHAR (0001) OCB_RATE3 DEC (0005,02) OCB_UPDTMSTP TIMESTAMP OCB_UPDID CHAR (0008)
Standard Grade Table (formerly APS Grade Table) (TCSTPGD) - Non-Academic
Key Fields: PGD_APS_GRADE, PGD_PAYREP
PGD_APS_GRADE CHAR (0002) PGD_PAYREP CHAR (0003) PGD_MIN_RATE DEC (0013,04) PGD_MID_RATE DEC (0013,04) PGD_MAX_RATE DEC (0013,04) PGD_UPDTMSTP TIMESTAMP PGD_UPDDT DATE PGD_UPDTM TIME PGD_UPDID CHAR (0008)
Academic Common Information (TCSTACB) - Academic Titles
Key Fields: ACB_TITLE
Relationships with other tables: ACB_TITLE in TCSTACB is related to CIB_TITLE in TCSTCIB
ACB_TITLE CHAR (0004) ACB_CAMPUS CHAR (0002) ACB_RANK CHAR (0001) ACB_APPTBAS CHAR (0001) ACB_APPTYPE CHAR (0001) ACB_PAYPER CHAR (0001) ACB_SABB CHAR (0001) ACB_SICK CHAR (0001) ACB_SERVLMT DEC (0002) ACB_HSCP CHAR (0001) ACB_OFFSCALE CHAR (0001) ACB_ALL CHAR (0001) ACB_BYAGREE CHAR (0001) ACB_TUC CHAR (0002) ACB_ABOL_DATE DATE ACB_FRZN_DATE DATE ACB_RAEFDATE_COV DATE ACB_RNGADJID_COV CHAR (0012) ACB_RAEFDATE_UNC DATE ACB_RNGADJID_UNC CHAR (0012) ACB_UPDTMSTP TIMESTAMP ACB_UPDID CHAR (0008)
Academic Rates (TCSTARB) - Academic Titles
Key Fields: ARB_TITLE, ARB_PAYREP, ARB_COMPGRP, ARB_STEPID
Relationships with other tables:
* ARB_TITLE in TCSTARB is related to CIB_TITLE in TCSTCIB * ARB_COMPGRP and ARB_STEPID are related to the corresponding fields in TCSTGRB
ARB_TITLE CHAR (0004) ARB_PAYREP CHAR (0003) ARB_COMPGRP CHAR (0003) ARB_COLID CHAR (0001) ARB_STEPID CHAR (0003) ARB_UPDTMSTP TIMESTAMP ARB_UPDID CHAR (0008)
Academic Compensation Group Table (TCSTGTB) - Academic
Key Fields: GTB_COMPGRP
GTB_COMPGRP CHAR (0003) GTB_CGDESCR CHAR (0050) GTB_CGRATETYPE CHAR (0001) GTB_ROUNDCALC CHAR (0003) GTB_COL1ID CHAR (0001) GTB_COL2ID CHAR (0001) GTB_DIFF DEC (0008,04) GTB_DIFFTYPE CHAR (0001) GTB_UPDTMSTP TIMESTAMP GTB_UPDID CHAR (0008)
Academic Compensation Group Rates (TCSTGRB) - Academic
Key Fields: GRB_COMPGRP, GRB_STEPID
Relationships with other tables: GRB_COMPGRP in TCSTGRB relates to the corresponding field in TCSTGTB
GRB_COMPGRP CHAR (0003) GRB_STEPID CHAR (0003) GRB_RATECOL1 DEC (0011,02) GRB_RATECOL2 DEC (0011,02) GRB_UPDTMSTP TIMESTAMP GRB_UPDID CHAR (0008)