• Elements
  • Element: Employment Resource Type Code, SUS - 01181

Page Name

A code to indicate the type of information reported for this employment resource, portion of an employment resource, or rate reserve.

Faculty employment resources will normally be classified as authorized but not established when they do not have an encumbent.

Coding a "T" will exclude the information on the record from being included in the rate reporting. It should be used for positions that are being filled with replacements. This coding will keep the rate from being overstated.

Reserve (O,P,R) and Temporary (T) coded records should only be reported on the Operating Budget submission.

Summer Reserve (X) coded records may be reported on any SCD submission (SUB_TYP 01726=O,J,L,S).




ELEMENT

192001

11-SEP-2008


Allowed Values

'EEFilled Employee Resource Record
Employee Resources
'OOOther Rate Reserve
Reserves
'VVVacant Employee Resource Record
Employee Resources
'XXSummer Person Year/Rate/Salary Reserve
Reserves

Edit Values

Submission CodeAscending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
EMPLEMPLOYEE_DEMO0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
EMPLEMPLOYEE_DEMO4126Frequency of Values for EMPLOYEE_DEMO.EMPR_TYP_CD0Frequency Distribution: not an indication of an error
EMPLEMPLOYEE_DEMO5417Employment Resource Type Code, SUS (01181) must equal 'E' for non-OPS records.9Critical Error: may cause submission to be rejected
SCDEMPLOYEE_DEMO0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
SCDEMPLOYEE_DEMO4126Frequency of Values for EMPLOYEE_DEMO.EMPR_TYP_CD0Frequency Distribution: not an indication of an error
SCDEMPLOYEE_VACANTS0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
SCDEMPLOYEE_VACANTS4127Frequency of Values for EMPLOYEE_VACANTS.EMPR_TYP_CD0Frequency Distribution: not an indication of an error
SCDEMPLOYEE_VACANTS6046EMPR_TYP_CD is nulled if EMPLOYEE_VACANTS.PAY_PLAN_NBR IN ('09', '06', '05', '02', '01', '00')1Generated or Modified during SUDS Edit Process
  • 1 - 8

Prior Database Information:

VARCHAR2(1)
EMPRTYCD
EMPR_TYP_CODE