Skip to end of metadata
Go to start of metadata

NEW_CONTRACTS
This view contains information found in the NEWCNT maintenance program.


Field Name

 

SSN

 

EMPLOYEE_ID

 

FULL_NAME

 

FIRST_NAME

 

LAST_NAME

 

SUFFIX_NAME

 

MID_INITIAL

 

FULL_LAST_NAME

 

STREET

 

STREET2

 

CITY

 

STATE

 

ZIP_CODE

 

PHONE

 

PROVINCE

 

POSTAL_CODE

 

COUNTRY

 

FOREIGN_ADDRESS

 

DATE_OF_BIRTH

 

CHECK_DISTRIBUTION

 

DIRECT_DEPOSIT

 

DEGREE_TYPE

 

DEGREE_TYPE_DESC

 

SEMESTER_HOURS

 

HANDICAP_STATUS

 

AUTHORIZED_EXPERIENCE_YEARS

 

TOTAL_YEARS_OF_EXPERIENCE

 

EMAIL_ADDRESS

 

HIRE_DATE:EMPLOYEES_REC

 

JBN

 

NEW_UNIT_AMOUNT

 

NEW_PAY_UNIT

 

NEW_HOURS_IN_DAY

 

NEW_CONTRACT_AMOUNT

 

DAYS_SINCE_RAISE

 

NEW_WORK_DAYS_IN_CONTRACT

 

NEW_CONTRACT_DAYS_WORKED

 

NEW_PAYS_IN_CONTRACT

 

NEW_NUMBER_OF_PAYS_PAID

 

NEW_APPOINTMENT_TYPE

 

NEW_EQUAL_PAYS

 

NEW_PAY_GROUP

 

NEW_CALENDAR_TYPE

 

NEW_CONTRACT_START_DATE

 

NEW_CONTRACT_STOP_DATE

 

NEW_CONTRACT_RENEW_DATE

 

NEW_CONTRACT_EXP_DATE

 

NEW_RETIREMENT_CODE

 

NEW_CONTRACT_AMOUNT_PAID

 

NEW_PAY_PER_PERIOD

 

NEW_ACCRUED_WAGES

 

NEW_CONTRACTUAL_OBLIGATION

 

NEW_CONTRACT_TYPE

 

NEW_CONTRACT_AMOUNT_DOCKED

 

AMOUNT_EARNED

 

LUMP_SUM_RETRO

 

NEW_DOCK_NEXT_PAY

 

SICK_LEAVE_BALANCE

 

VACATION_LEAVE_BALANCE

 

PERSONAL_LEAVE_BALANCE

 

PERSONAL_DAYS_BEGINNING_BALANCE

 

RESET_PERSONAL_LEAVE

 

RESET_VACATION_LEAVE

 

RESET_SICK_ADV

 

ADD_VACATION_UNITS

 

NEW_CALENDAR_START_DATE

 

NEW_CALENDAR_STOP_DATE

 

NEW_EXTENDED_SERVICE

 

NEW_EMIS_HOURS_IN_DAY

 

NEW_EMIS_HOURS_IN_DAY_CALC

NEW_EMIS_CONTRACT_AMOUNT

 

NEW_EMIS_WORK_DAYS_IN_CONTRACT

 

NEW_EMIS_FTE

 

ACCT_COUNTER

 

ACCOUNT

 

RATE_TYPE

 

PERCENT

 

START_DATE

 

STOP_DATE

 

MAXIMUM

 

STATUS

 

BOARD_BENEFITS

 

LEAVE_PROJECT

 

UNIT_AMOUNT

 

PAY_UNIT

 

JOB_TITLE

 

BUILDING_AND_DEPARTMENT

 

USER_CONTRACT_TYPE

 

CONTRACT_AMOUNT

 

PAY_PER_PERIOD

 

POSITION_FTE

 

EXPERIENCE_CURRENT_CLASS

 

PAY_PLAN_DESC

 

NEW_JOB_TITLE

 

NEW_JOB_STATUS

 

BUILDING_DEPARTMENT

 

BUILDING

 

DEPARTMENT

 

NEW_CHECK_DIST

 

NEW_POSITION_CODE

 

NEW_BUILDING_IRN

 

NEW_SALARY_SCHED_ID

 

NEW_SALARY_SCHED_COLUMN

 

NEW_SALARY_SCHED_STEP

 

SICK_UNITS_ACCUMULATED_MONTHLY

 

SICK_MAXIMUM_ADVANCE_DAYS

 

VACATION_UNITS_ACCUMULATED_MONTHLY

 

MAXIMUM_SICK_UNITS

 

MAXIMUM_VACATION_UNITS

 

PERSONAL_LEAVE_MAXIMUM

 

UNIT_FLAG

 

HIRE_DATE:USPNEWEMP_REC

 

RETIRE_HOURS

 

EMIS_SPED_FTE

 


  • No labels