Skip to end of metadata
Go to start of metadata

JOB_POSITION
This view contains information as listed in USPSCN/JOBSCN and USPSCN/POSSCN.

Field Name

 

SSN

 

TRUE_SSN

 

EMPLOYEE_ID

 

EMIS_EMPID

 

FULL_NAME

 

LAST_NAME

 

FIRST_NAME

 

MIDDLE_NAME

 

MID_INITIAL

 

STREET

 

CITY

 

STATE

 

ZIP_CODE

 

PHONE

 

DATE_OF_BIRTH

 

SEX

 

OSDI_DISTRICT_CODE

 

DIRECT_DEPOSIT

 

CHECK_DISTRIBUTION

 

ETHNICITY_HISP_LAT

 

RACE

 

RACE_WHITE

 

RACE_BLACK

 

RACE_ASIAN

 

RACE_AI_AN

 

RACE_NH_PI

 

DEGREE_TYPE

 

DEGREE_TYPE_DESC

 

SEMESTER_HOURS

 

AUTHORIZED_EXPERERIENCE_YEARS

 

TOTAL_YEARS_OF_EXPERIENCE

 

HIRE_DATE

 

ODHS_HIRE_DATE

 

EMPLOYEE_REPORT_TO_EMIS

 

JOB_NO

 

JOB_STATUS

 

DATE_HIRED

 

DATE_TERMINATED

 

UNIT_AMOUNT

 

PAY_UNIT

 

PAY_UNIT_DESC

 

PAY_PLAN

 

PAY_PLAN_DESC

 

HOURS_IN_DAY

 

DAYS_IN_PERIOD

 

SERVICE_DAYS_IN_PAY_PERIOD

 

CALENDAR_START_DATE

 

ADVANCE_FLAG

 

PERSONNEL_CONTRACT

 

SERVICE_DAYS

 

JOB_TITLE

 

BUILDING_AND_DEPARTMENT

 

BUILDING

 

BUILDING_DESC

 

BUILDING_IRN

 

DEPARTMENT

 

DEPARTMENT_DESC

 

CONTRACTUAL_OBLIGATION

 

ELIGIBLE_FOR_SICK_LEAVE

 

ELIGIBLE_FOR_VACATION

 

ELIGIBLE_FOR_PERSONAL

 

RAISE_DATE

 

CONTRACT_AMOUNT

 

ACCRUED_WAGES

 

WORK_DAYS_IN_CONTRACT

 

CONTRACT_DAYS_WORKED

 

PAYS_IN_CONTRACT

 

NUMBER_OF_PAYS_PAID

 

APPOINTMENT_TYPE

 

APPOINTMENT_TYPE_DESC

 

EQUAL_PAYS

 

MULTIPLE_MUNICIPALITIES

 

DOCK_FROM_NEXT_PAY

 

CONTRACT_START_DATE

 

CONTRACT_STOP_DATE

 

RETIREMENT_CODE

 

RETIREMENT_CODE_DESC

 

PAY_PER_PERIOD

 

CONTRACT_AMOUNT_PAID

 

CONTRACT_AMOUNT_DOCKED

 

YTD_REGULAR_PAY

 

YTD_OVERTIME_PAY

 

YTD_MISC_PAY

 

YTD_GROSS_PAY

 

YTD_REGULAR_PAY_UNITS

 

YTD_OVERTIME_PAY_UNITS

 

YTD_MISC_PAY_UNITS

 

YTD_DOCKED_PAY

 

YTD_DOCKED_UNITS

 

YTD_SHIFT_PREMIUM

 

QTD_REGULAR_PAY

 

QTD_SHIFT_PREMIUM

 

QTD_OVERTIME_PAY

 

QTD_MISC_PAY

 

QTD_GROSS_PAY

 

QTD_DOCKED_AMOUNT

 

FYTD_REGULAR_PAY

 

FYTD_SHIFT_PREMIUM

 

FYTD_OVERTIME_PAY

 

FYTD_MISC_PAY

 

FYTD_GROSS_PAY

 

FYTD_DOCKED_AMOUNT

 

CONTRACT_TO_DATE_REGULAR_PAY

 

CONTRACT_TO_DATE_OVERTIME_PAY

 

CONTRACT_TO_DATE_MISC_PAY

 

CONTRACT_TO_DATE_GROSS_PAY

 

CONTRACT_TO_DATE_REGULAR_UNITS

 

CONTRACT_TO_DATE_OVERTIME_UNITS

 

CONTRACT_TO_DATE_MISC_PAY_UNITS

 

CONTRACT_TO_DATE_DOCKED_PAY

 

CONTRACT_TO_DATE_DOCKED_UNITS

 

CONTRACT_TO_DATE_SHIFT_PREMIUM

 

PAY_GROUP

 

CONTRACT_AMOUNT_EARNED

 

RETRO_NEXT_PAY

 

SALARY_SCHEDULE_ID

 

SALARY_SCHEDULE_COLUMN

 

SALARY_SCHEDULE_STEP

 

NON_CASH_PER_PAY

 

NON_CASH_YTD

 

NON_CASH_MAXIMUM

 

USER_MONEY_1

 

USER_MONEY_2

 

USER_CODE_1

 

USER_CODE_2

 

USER_TEXT

 

USER_DATE

 

PRSL_USER_MONEY_1

 

PRSL_USER_MONEY_2

 

PRSL_USER_CODE_1

 

PRSL_USER_CODE_2

 

PRSL_USER_TEXT

 

PRSL_USER_DATE

 

POSITION_CODE

 

POSITION_FTE

 

FUND_SOURCE_PERCNET_1

 

FUND_SOURCE_CODE_1

 

APPROVED_PERCENT_1

 

FUND_SOURCE_PERCENT_2

 

FUND_SOURCE_CODE_2

 

APRROVED_PERCENT_2

 

FUND_SOURCE_PERCENT_3

 

FUND_SOURCE_CODE_3

 

APPROVED_PERCENT_3

 

POSITION_TYPE

 

POSITION_STATUS

 

EXPERIENCE_CURRENT_CLASS

 

EXTENDED_SERVICE

 

ASSIGNMENT_AREA_1

 

ASSIGNMENT_AREA_2

 

ASSIGNMENT_AREA_3

 

SEPARATION_REASON

 

EMIS_APPOINTMENT_TYPE

 

JOB_REPORT_TO_EMIS

 

CONTRACT_TYPE

 

EMIS_HOURS_IN_DAY

EMIS_HOURS_IN_DAY_CALC

 

EMIS_CONTRACT_AMOUNT

 

EMIS_WORK_DAYS_IN_CONTRACT

 

EMIS_FTE_UNIT

 

CALENDAR_TYPE

 

CHECK_STUB_DESCRIPTION

 

OVERTIME_RATE

 

CALENDAR_STOP_DATE

 

PAY_CODE

 

JOB_TYPE

 

LOW_GRADE

 

HIGH_GRADE

 

LAST_PAID_DATE

 

HIGH_QUALITY_PROF_DEVELOP

 

PARPROFESSIONAL

 

SEPARATION_DATE

 

PARAPROF_HIRE_DATE

 

CONCEAL_EMPLOYEE

 

SUPERVISOR_ID

 

RETIRE_HOURS

 

EMIS_SPEC_ED_FTE

 

  • No labels