• Home
  • Table: EMPLOYEE_VACANTS - EVAC

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--
5SUB_TYP01726Submission TypeVARCHAR210--
6BE_CD01007Budget Entity Code, SUSVARCHAR21--
7ST_FUND_TYP01314State Fund TypeVARCHAR21--
8FUND_ID_EMPL_RES01742University Fund Identifier - Employment ResourceVARCHAR26--
9BE_CD801297Budget Entity CodeVARCHAR28--
10IBI01724Internal Budget IndicatorVARCHAR22--
11APPROP_CAT01743Appropriation Category - Employment ResourceVARCHAR26--
12DEPT_ID01796Department IdentifierVARCHAR29-201307
12DEPT_ID01796Department IdentifierVARCHAR210--
13UNIV_BUD_ID01798University Budget IdentifierVARCHAR210--
14PAY_PLAN_NBR01037Pay Plan, SUSVARCHAR22--
15UNIV_POSITION01039University PositionVARCHAR28--
16HLTH_INS_OPT_CD01668Health Insurance Option Code, StateVARCHAR22--
17LIFE_INS_PART_CD01635Life Insurance Participation Code, StateVARCHAR21--
18RETIRE_CD_EMP01047Retirement Code, Employment ResourceVARCHAR22--
19COUNTY_OF_EMP01016County of EmploymentVARCHAR24--
20CLASS_CD01014Classification CodeVARCHAR24--
21ADMIN_CD_PRI01409Administrative Code - Faculty and otherVARCHAR22--
22CAMPUS_CD01608Campus Code - Employment ResourceVARCHAR24--
23CIP_ACCT_DEPT01013Account/Department CIPVARCHAR26--
24ST_PRO_COMP_CD01639State Program Component CodeVARCHAR210--
25PROG_COMP01315Program Component, SUSVARCHAR26--
26PCS_DEPT_ID01245Account/Department Program (PCS)VARCHAR22--
27SALARY_DOLLARS01034Salary DollarsNUMBER2299999999.99-
28CURR_YR_RATE01017Current Year Rate, SUSNUMBER2299999999.99-
29FTE01004Full Time Equivalent (FTE) EffortNUMBER2299.9999-
30BUD_WKS_POS01236Budgeted Weeks of Activity, Employment ResourceNUMBER2299.99-
31SR_MGMT_BFT_FLG01020Senior Management Benefit SwitchVARCHAR21--
32ANP_FLG01038A & P IndicatorVARCHAR21-201907
33EMPR_TYP_CD01181Employment Resource Type Code, SUSVARCHAR21--
34CLASS_TITLE01807Classification TitleVARCHAR250--
35U_RESV_102003University Filler Field 1VARCHAR250--
37BOG_JOB_STRUCT_CAT02087BOG Job Structure CategoryVARCHAR22--
39PERYRS01176Person YearsNUMBER22999999.9999-
  • 1 - 38

Included in Submissions

SubmissionTable Required
Salary Category Detail (SCD)Y