University of Washington
Home   Search
 

Staff & Faculty Database

Data Table Definitions

The five (5) core data tables in the Staff Database are:


STAFF_Employee_Appt

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 EMPLOYEE_KEY                              NOT NULL CHAR(9)
 APPT_SEQUENCE_NUMBER                      NOT NULL CHAR(2)
 APPT_ORG_DEPT                                      CHAR(7)
 APPT_BEGIN_DATE                                    DATE
 APPT_END_DATE                                      DATE
 APPT_ENTRY_DATE                                    DATE
 APPT_STATUS                                        CHAR(1)
 JOB_CLASS                                          CHAR(6)
 PERCENT_FULL_TIME                                  NUMBER(5,2)
 PAY_RATE                                           NUMBER(9,3)
 RATE_CODE                                          CHAR(1)
 APPT_TERM                                          NUMBER(4,1)
 WORK_STUDY_IND                                     CHAR(1)
 JOB_STEP                                           CHAR(3)
 ACTIVE_ON_CENSUS                                   CHAR(1)
 CENSUS_DIST_REG_PAY                                NUMBER(9,3)
 CENSUS_DIST_REG_PERCENT                            NUMBER(5,2)
 PRIMARY_APPT_SEQ_NO                                CHAR(2)
 FULL_TIME_AMT                                      NUMBER(9,3)


STAFF_Employee_Dist

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 EMPLOYEE_KEY                              NOT NULL CHAR(9)
 APPT_SEQUENCE_NUMBER                      NOT NULL CHAR(2)
 DIST_INDEX                                NOT NULL CHAR(1)
 DIST_BUDGET_NUMBER                                 CHAR(6)
 DIST_START_DATE                                    DATE
 DIST_STOP_DATE                                     DATE
 OBJECT_SUBOBJECT_CODE                              CHAR(4)
 SUB_SUBOBJECT_CODE                                 CHAR(2)
 POSITION_NUMBER                                    CHAR(6)
 EARNINGS_TYPE                                      CHAR(3)
 DIST_PERCENT_TIME                                  NUMBER(5,2)
 DIST_AMOUNT                                        NUMBER(9,3)
 ACTIVE_ON_CENSUS                                   CHAR(1)

[Return To Table List]

STAFF_Employee_Perm
 
 EMPLOYEE_KEY                              NOT NULL CHAR(9)
 EMPLOYMENT_DATE                                    DATE
 EMPLOYMENT_STATUS                                  CHAR(1)
 SEPARATE_REASON                                    CHAR(2)
 EMPLOYMENT_TYPE                                    CHAR(1)
 EDUCATION_LEVEL                                    CHAR(2)

 

[Return To Table List]


STAFF_Employee_Term

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 EMPLOYEE_KEY                              NOT NULL CHAR(9)
 HOME_ORG_DEPT                                      CHAR(7)
 PART_FULL                                          CHAR(1)
 PERM_TEMP                                          CHAR(1)
 TENURE_ELIG                                        CHAR(1)
 UW_SERVICE_PERIOD                                  NUMBER(3,1)
 STUDENT_ID                                         CHAR(9)
 CITY                                               CHAR(16)
 STATE                                              CHAR(2)
 ZIP                                                CHAR(10)
 WORK_COUNTY                                        CHAR(2)
 ACAD_HOME_ORG_DEPT                                 CHAR(7)

[Return To Table List]


STAFF_Faculty_Degrees

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 EMPLOYEE_KEY                              NOT NULL CHAR(9)
 DEGREE_CODE                               NOT NULL CHAR(3)
 DEGREE_YEAR                               NOT NULL CHAR(4)
 DEGREE_INSTIT                             NOT NULL CHAR(6)

[Return To Table List]

Staff and Faculty Database
Lookup and Helper Table Definitions
For Use With Staff Database Data Tables

The following "Helper" tables assist the user in determining which are the most recent quarters and/or years, which helps the user to create more effiecient queries: The various "Lookup" tables associate descriptions with corresponding codes as they appear in HEPPS and in the Staff Database:

Staff Database Table Definitions
STAFF_Degree_Code

This table provides the description associated with each Degree_Code.

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 DEGREE_CODE                               NOT NULL CHAR(3)
 SHORT_DESCRIP                             NOT NULL CHAR(27)
 LONG_DESCRIP                              NOT NULL CHAR(35)

[Return To Table List]

STAFF_EEO6_Code

This table provides the description associated with each EEO6_Code.

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 EEO6_CODE                                 NOT NULL CHAR(3)
 SHORT_DESCRIP                             NOT NULL CHAR(26)
 LONG_DESCRIP                              NOT NULL CHAR(42)

STAFF_Ethnic_Code

This table provides the description associated with each Ethnic_Code.

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 ETHNIC_CODE                               NOT NULL CHAR(3)
 SHORT_DESCRIP                             NOT NULL CHAR(24)
 LONG_DESCRIP                              NOT NULL CHAR(50)

[Return To Table List]

STAFF_Hispanic_Code

This lookup table provides the description for each Hispanic_Code.

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 HISPANIC_CODE                             NOT NULL CHAR(3)
 SHORT_DESCRIP                             NOT NULL CHAR(20)
 LONG_DESCRIP                              NOT NULL CHAR(50)

[Return To Table List]

STAFF_Institution_Code

This table provides the name of the institution at which a faculty member received a degree.

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 INSTITUTION_CODE                          NOT NULL CHAR(6)
 SHORT_DESCRIP                             NOT NULL CHAR(40)

[Return To Table List]

STAFF_Job_Class

This table provides the description associated with each Job_Class Code.

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 JOB_CLASS                                 NOT NULL CHAR(6)
 TITLE                                              CHAR(40)
 ABBREVIATED_TITLE                                  CHAR(20)
 MINIMUM_SALARY                                     NUMBER(9,3)
 MAXIMUM_SALARY                                     NUMBER(9,3)
 GRADE                                              CHAR(3)
 PAY_SCALE                                          CHAR(2)
 STATUS                                             CHAR(1)
 OFM_CATEGORY                                       CHAR(2)
 BUDGET_STEP                                        CHAR(3)
 OBJECT_SUBOBJECT_CODE                              CHAR(4)
 MINIMUM_STEP                                       CHAR(3)
 MAXIMUM_STEP                                       CHAR(3)
 PERSONNEL_TYPE                                     CHAR(2)
 FAC_REP_CLASS                                      CHAR(3)
 TENURE                                             CHAR(1)
 TENURE_TRACK                                       CHAR(1)
 PROMOTION_REQUIRED                                 CHAR(1)
 IPEDS_REPORTED                                     CHAR(1)
 AAUDE_REPORTED                                     CHAR(1)
 REPORTING_RANK                                     CHAR(1)
 EEO6_CODE                                          CHAR(3)

[Return To Table List]

STAFF_Race_Code

This table provides the description associated with each one-digit Race_Code.

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 RACE_CODE                                 NOT NULL CHAR(1)
 DESCRIPTION                               NOT NULL CHAR(40)

[Return To Table List]

STAFF_Separation_Code

This table provides the description associated with each Separation_Code.

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 SEPARATION_CODE                           NOT NULL CHAR(3)
 SHORT_DESCRIP                             NOT NULL CHAR(35)
 LONG_DESCRIP                              NOT NULL CHAR(45)

[Return To Table List]

STAFF_Veteran_Code

This lookup table provides the description for each Veteran_Code.

 YEAR                                      NOT NULL CHAR(4)
 QUARTER                                   NOT NULL CHAR(1)
 VETERAN_CODE                              NOT NULL CHAR(1)
 SHORT_DESCRIP                             NOT NULL CHAR(40)
 LONG_DESCRIP                              NOT NULL CHAR(100)

[Return To Table List]