• Home
  • Table: EMPLOYEE_DATA - EDAT

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--
7BE_CD01007Budget Entity Code, SUSVARCHAR21--
8ST_FUND_TYP01314State Fund TypeVARCHAR21--
9FUND_ID_EMPL_RES01742University Fund Identifier - Employment ResourceVARCHAR26--
10BE_CD801297Budget Entity CodeVARCHAR28--
11IBI01724Internal Budget IndicatorVARCHAR22--
12APPROP_CAT01743Appropriation Category - Employment ResourceVARCHAR26--
13DEPT_ID01796Department IdentifierVARCHAR29-201307
13DEPT_ID01796Department IdentifierVARCHAR210--
14UNIV_BUD_ID01798University Budget IdentifierVARCHAR210--
15PAY_PLAN_NBR01037Pay Plan, SUSVARCHAR22--
16OPS_SEQ01797SequenceVARCHAR21--
17UNIV_POSITION01039University PositionVARCHAR28--
18COUNTY_OF_EMP01016County of EmploymentVARCHAR24--
19CLASS_CD01014Classification CodeVARCHAR24--
20EMPLOYED_CUR_CL_DT01018Date Employed in Current ClassificationDATE7YYYYMMDD-
21COLL_BARG_UNIT_CD01041Collective Bargaining Unit CodeVARCHAR24--
22COLL_BARG_UNIT_ELG01049Collective Bargaining Unit Eligibility, SUSVARCHAR21--
23ADMIN_CD_PRI01409Administrative Code - Faculty and otherVARCHAR22--
24CAMPUS_CD01608Campus Code - Employment ResourceVARCHAR24--
25APPT_STAT_CLASS01696Appointment Status - ClassVARCHAR21--
26CIP_ACCT_DEPT01013Account/Department CIPVARCHAR26--
27ST_PRO_COMP_CD01639State Program Component CodeVARCHAR210--
28PROG_COMP01315Program Component, SUSVARCHAR26--
29PCS_DEPT_ID01245Account/Department Program (PCS)VARCHAR22--
30SALARY_DOLLARS01034Salary DollarsNUMBER2299999999.99-
31CURR_YR_RATE01017Current Year Rate, SUSNUMBER2299999999.99-
32FTE01004Full Time Equivalent (FTE) EffortNUMBER2299.9999-
33BUD_WKS_POS01236Budgeted Weeks of Activity, Employment ResourceNUMBER2299.99-
34COMMIT_TYP01747Commitment TypeVARCHAR22--
35RATE_TYP01625Rate TypeVARCHAR21--
36UT_WORKED01624Units WorkedNUMBER22999.99-
37CLASS_TITLE01807Classification TitleVARCHAR250--
38U_RESV_102003University Filler Field 1VARCHAR250--
39OPS_TERM_AMOUNT02083OPS Term AmountNUMBER2299999999.99-
40BOG_JOB_STRUCT_CAT02087BOG Job Structure CategoryVARCHAR22--
41UNIV_ID01095University IdentifierVARCHAR215--
42SALARY_CAP_EXEMPT10081Salary Cap ExemptionVARCHAR26--
43PAY_GRADE01035Pay GradeVARCHAR23--
44STEP_NBR01281Step Number - USPSVARCHAR23--
45PERYRS01176Person YearsNUMBER22999999.9999-
  • 1 - 46

Included in Submissions