Description of Data Element 01783





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                                                   



Return to Data Dictionary Main Page