NAME: Database Column Names
NUMBER: 01783
FILES/TABLES: DEF DOM
DEFINITION: The Column Names of the Data Elements in the SUPERS Database.
TABLE VALUES:
ACC_DEPT_CIP - 01013 - ACCTCIP
ACC_DEPT_NBR_COM - 01749 - ACCT
ACC_DEPT_NBR_EMP - 01199 - ACCTEMP
ACC_DEPT_NBR_POS - 01198 - ACCTPOS
ACC_DEPT_PGM_PCS - 01245 - PCS
ACT_CD_POS - 01684 - ACTCDPOS
ACT_CODE_EMP_PRI - 01642 - ACTCDEM1
ACT_CODE_EMP_SEC - 01756 - ACTCDEM2
ACT_DATE_EMP_PRI - 01643 - ACTDTEM1
ACT_DATE_EMP_SEc - 01757 - ACTDTEM2
ACT_DT_POS - 01683 - ACTDTPOS
Adj_BASE_RATE - 01186 - ADJRATE
ADMIN_CD_PRI - 01409 - ADMCd1
ADMIN_CD_SEC - 01416 - ADMCd2
AGENCY_HIRE_DATE - 01019 - INSTDT
APPROP_CAT_POS - 01743 - CAT
APPT_BUD_WKS_ACT - 01785 - BUDWKSAP
APPT_STAT_ADMIN_1 - 01697 - APSTAT1
APPT_STAT_ADMIN_2 - 01654 - APSTAT2
APPT_STAT_CLASS - 01696 - APSTATCL
BASE_RATE - 01040 - BRATE
BRG_DATE_APPT - 01753 - BEGDTAP
BEG_DATE_RES_COM - 01750 - BEGDTCOM
BUD_ENT_ABBR - 01734 - BUDENT
BUD_ENT_CODE - 01007 - BUDENTCD
BUD_WKS_ACTIVITY - 01236 - BUDWKS
BUDGET_IND - 01724 - IBI
CAD_IND_USPS - 01673 - CADIND
CAMPUS_CD_POS - 01608 - CAMPCD
CITIZ - 01619 - CITZ
CLASS_CODE - 01014 - CLCD
COLL_BARG_UNIT_CD - 01041 - CBUCD
COLL_BARG_UNIT_ELG - 01049 - CBUPRT
COMMIT_NUMBER - 01748 - COMNO
COMMIT_TYPE - 01747 - COMTYP
CONT_ST_SER_DT - 01612 - CNTSVCDT
COUNTY_OF_EMP - 01016 - CNTYE
COUNTY_OF_RES - 01055 - CNTYRES
CURR_YEAR_RATE - 01017 - CRATE
CURRENT_STATUS - 01761 - CURSTAT
DATE_OF_RANK_FAC - 01182 - DTRANK
DEDUCT_CODE - 01614 - DEDCD
DEG_HIGHEST_HELD - 01170 - DEGHI
DEG_YR_OF_HIGHEST - 01194 - DEGYRHI
DT_EMPLOYED_CUR_CL - 01018 - DTEMPCLS
DT_OF_BIRTH - 01024 - DTBIRTH
END_DATE_APPT - 01754 - ENDDTAP
END_DATE_RES_COM - 01751 - ENDDTCOM
END_HRS_WORKED - 01624 - EHRWRK
END_RATE_PAY - 01626 - ERATEPAY
END_RATE_TYPE - 01625 - ERATETYP
FALL_TRM_FLG - 01178 - FLGFA
FIN_DIS_IND - 01628 - FDIND
FIRST_NAME - 01620 - FNAME
FTE - 01004 - FTE
GAAFR_FND_TYPE - 01311 - GFND
GENDER - 01630 - SEX
HLTH_INS_OPT_CD - 01668 - HLINSOPT
HLTH_INS_PROV_CD - 01669 - HLINSPRV
INFO_CHG_DATE - 01609 - CHGDT
LAST_NAME - 01622 - LNAME
LAW_ENF_ANN_DT - 01677 - LAWANNDT
LEAD_WRK_IND_USPS - 01678 - LDWRKIND
LIFE_INS_PART_CD - 01635 - LFINSPRT
MAR_STAT - 01686 - MARSTAT
MEDICAL_EXAM_POS - 01758 - MEDEXPOS
MIDDLE_INIT - 01621 - MINIT
MONTHS_COMMITTED - 01752 - MONCOM
OCC_ACT_CAT_PRI - 01617 - OCCACT
OVERLAP_FLAG - 01737 - OVLAPFLG
PAY_GRD - 01035 - PG
PAY_PLAN_ABBR - 01733 - PAYPLN
PAY_PLAN_PRI_POS - 01719 - PAYPLN1
PERSON_ID_NO_PREV - 01427 - SSNPREV
PERSON_ID_NUMBER - 01029 - SSN
PERSON_YEARS - 01176 - PERYR
POS_DATE_VACANT - 01645 - POSTDTVAC
POS_SHARED_IND - 01647 - POSSHR
POS_TYPE_CODE - 01181 - POSTYPCD
POS_WORK_SCHED - 01652 - WRKSCHED
POS_WORK_SHIFT - 01653 - WRKSFT
POSITION_NUMBER - 01039 - POSNO
PRIOR_YEAR_ADD - 01184 - PYRADD
PROG_COMP - 01315 - PGCMP
RACIAL_ETHNIC_GRP - 01655 - RACE
RANK_FAC - 01028 - RANK
REPT_INST - 01045 - UNIV
REST_ACC_IND - 01611 - RESTIND
RETIRE_CD_EMP - 01047 - RETCD
SAL_CHG_AMOUNT - 01658 - SCAMT
SAL_CHG_SFF_DATE - 01659 - SCEFFDT
SAL_CHG_HOURS - 01755 - SCHR
SAL_CHG_TYPE - 01657 - SCTYP
SALARY_DOLLARS - 01034 - SALDOL
SAMAS_FND_ID_POS - 01742 - SAMFID
SECUR_FLG - 01665 - SECFLG
SEP_CODE - 01666 - SEPCD
SEP_DATE_INST - 01699 - SEPDT
SEQ_POS - 01646 - SEQPOS
SPRING_TRM_FLG - 01180 - FLGSP
STATE_FND_TYPE - 01314 - STFND
STATUS_COMMIT - 01760 - COMSTAT
STEP_NUMBER USPS - 01281 - STEPNP
SUMMER_TRM_FLG - 01177 - FLGSU
TEN_EARN_DT_UNIV - 01672 - TENERNDT
TEN_PERM_STAT_DT - 01238 - TENDT
TEN_PERM_STATUS - 01671 - TENSTAT
TENURE_CIP - 01738 - TENCIP
TOT_ANN_EFF_EMP - 01618 - ANNEFFEM
TOT_ANN_SAL_RT - 01759 - ANNSALRT
USPS_APPR_EFF_DT - 01675 - APPRDT
USPS_APPR_TYPE - 01676 - APPRTYP
YEAR_FISCAL - 01629 - FISYR
DATABASE INFORMATION: PHYSICAL DESCRIPTION: X(15) COLUMN NAME: DATABASE_COL_NAME SHORT NAME: DBCOLNM
CREATE-CHANGE DATE: 04/21/95