• Home
  • Table: EMPLOYEE_DEMO - EDEM

Page Name

Columns and Elements

Position
Column Name
Element
Element Name
Type
Max Length
Mask
End Term
1UNIV_ROW_ID02002University Row IdentifierVARCHAR28--
2DEMO_TIME_FRAME02041Demo Time FrameVARCHAR28--
3REPT_INST01045Reporting InstitutionVARCHAR24--
4DEMO_DATA_SOURCE02019Demo_Data_SourceVARCHAR28--
5PERSON_ID01029Person Identification NumberVARCHAR29-202207
6SUB_TYP01726Submission TypeVARCHAR210--
7HLTH_INS_OPT_CD01668Health Insurance Option Code, StateVARCHAR22--
8HLTH_INS_PROV_CD01669Health Insurance Provider Code, StateVARCHAR23--
9LIFE_INS_PART_CD01635Life Insurance Participation Code, StateVARCHAR21--
10RETIRE_CD_EMP01047Retirement Code, Employment ResourceVARCHAR22--
11CONT_ST_SVC_DT01612Continuous State Service DateDATE7YYYYMMDD-
12AGENCY_HIRE_DT01019University Hire DateDATE7YYYYMMDD-
13RANK_FAC01028Rank, FacultyVARCHAR22--
14RANK_FAC_DT01182Date of Rank, FacultyDATE7YYYYMMDD-
15DEG_HIGHEST_HELD01112Degree - Highest Level HeldVARCHAR21--
16DEG_YR_OF_HIGHEST01194Degree - Year of HighestVARCHAR24--
17TENURE_STAT01671Tenure StatusVARCHAR21--
18TENURE_STAT_DT01238Tenure Status - Date GrantedDATE7YYYYMMDD-
19CIP_TENURE01738Tenure CIPVARCHAR26--
20OCC_ACT_CAT_EEO601617Occupational Activity CategoryVARCHAR21--
21COUNTY_OF_RES01055County of Residence, SUSVARCHAR24--
22RESTRICT_ACC_FLG01611Restricted Access IndicatorVARCHAR21--
23SR_MGMT_BFT_FLG01020Senior Management Benefit SwitchVARCHAR21--
24ANP_FLG01038A & P IndicatorVARCHAR21-201907
25DROP_ENROLL_DT01690Date of Enrollment - DROPDATE7YYYYMMDD-
26DROP_TERMT_DT01691Date of Termination - DROPDATE7YYYYMMDD-
27EMPR_TYP_CD01181Employment Resource Type Code, SUSVARCHAR21--
28CITIZEN01619CitizenshipVARCHAR21--
29U_RESV_102003University Filler Field 1VARCHAR250--
30UNIV_ID01095University IdentifierVARCHAR215--
31NAME_LAST01033Person Name - LastVARCHAR222--
32NAME_FIRST01091Person Name - FirstVARCHAR214--
33NAME_MI01092Person Name - Middle InitialVARCHAR21--
34SUFFIX02016Person Name - SuffixVARCHAR210--
35GENDER01048GenderVARCHAR21--
36HISPANIC_FLG01491Hispanic or LatinoVARCHAR21--
37AM_IND_ALASKAN_FLG01492American Indian/Alaska NativeVARCHAR21--
38ASIAN_FLG01493AsianVARCHAR21--
39BLACK_AFRICAN_AM_FLG01494Black or African AmericanVARCHAR21--
40NAT_HAWAII_PAC_IS_FLG01495Native Hawaiian or Other Pacific IslanderVARCHAR21--
41WHITE_FLG01496WhiteVARCHAR21--
42NON_RES_ALIEN_FLG02043Non-resident Alien FlagVARCHAR21--
43NO_RACE_REPORT_FLG01497No Race ReportedVARCHAR21--
44IPEDS_RACE_ETHNIC_CD02080IPEDS_RACE_ETHNIC_CDVARCHAR21--
46RANK_FAC_GEN02046Rank, Faculty (Generated)VARCHAR22--
  • 1 - 45

Included in Submissions