BCS Data Elements

Data Element Name:

Annual_Amount

Long Name:

Annual Amount

Type:

NUMERIC

Length:

17

Format:

N/A

General Description:

Amount of the annual salary for a provision, determined at the distribution level as follows:

For a regular provision: (Monthly rate X FTE) X 12
For a stipend provision: Monthly rate X 12
For a group provision : From input source document

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Annual_Rate

Long Name:

Annual Rate

Type:

NUMERIC

Length:

17

Format:

N/A

General Description:

The annual gross salary rate for an employee

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

CTO_Code

Long Name:

CTO_Code

Type:

ALPHANUMERIC

Length:

3

Format:

N/A

General Description:

Code indicating the primary occupation group to which an employee's primary title is assigned for reporting purposes. For staff titles, this element is known as the Occupational Subgroup Code. For academic titles, the component characters of the CTO have been assigned specific values.

Code Interpretation:

See CTO/Occupational Sub Group Code in Personnel Data Warehouse Data Elements

Comments:

Revision Date:

Data Element Name:

CTO_Name

Long Name:

CTO_Name

Type:

ALPHANUMERIC

Length:

60

Format:

N/A

General Description:

Name indicating the primary occupation group to which an employee's primary title is assigned for reporting purposes. For staff titles, this element is known as the Occupational Subgroup. For academic titles, the component characters of the CTO have been assigned specific values.

Code Interpretation:

See CTO/Occupational Sub Group Code in Personnel Data Warehouse Data Elements

Comments:

Revision Date:

Data Element Name:

Distribution_No

Long Name:

Distribution Number

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Number uniquely identifying a payroll distribution associated with an employee's appointment

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

DOS_Code_CPS

Long Name:

Description of Service Code

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the type of service provided by the employee for which payment is to be made.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Employee_Initials

Long Name:

Employee's Initials

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

First and middle initials of the employee's name

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Employee_Last_Name

Long Name:

Employee's Last Name

Type:

ALPHANUMERIC

Length:

16

Format:

N/A

General Description:

Employee's last name

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Employee_Number

Long Name:

Employee Number

Type:

ALPHANUMERIC

Length:

9

Format:

N/A

General Description:

The unique employee identification number

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

FTE

Long Name:

FTE

Type:

NUMERIC

Length:

8

Format:

N/A

General Description:

Budgeted positions expressed as a decimal fraction of full time appointments (1.00 = full time appointment).

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

FTE_Employee

Long Name:

FTE for Employee

Type:

NUMERIC

Length:

4

Format:

N/A

General Description:

Budgeted positions expressed as a decimal fraction of full time appointments (1.00 = full time appointment).

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Provision_Description

Long Name:

Provision Description

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

Descriptive information about an unfilled position. The word "provision" or “prov” should appear in the description to clearly identify provision records when displayed in a report

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Provision_ID

Long Name:

Provision ID

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

Unique number identifying a provision record within title code, account/fund/sub-account, sub-campus, Systemwide Administrative Unit (SAU), and location

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Provision_Type

Long Name:

Provision Type

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the category to which an unfilled position belongs

Code Interpretation:

'B'        By Agreement

'G'        Group Provision

'R'        Regular Provision

'S'        Stipend Provision

Comments:

Revision Date:

Data Element Name:

SAU_Description

Long Name:

SYSTEMWIDE ADMINISTRATIVE UNIT Description(SAU)

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name of he particular systemwide unit responsible for administering a systemwide account.

Code Interpretation:

'4'         Division of Agricultural & Natural Resources

'5'         Universitywide Academic Program

'6'         Office of the President

'7'         Regents Officers

'8'         University Programs

'9'         University Provisions

'0'         Other Programs

Comments:

Revision Date:

Data Element Name:

Source

Long Name:

Source

Type:

ALPHANUMERIC

Length:

9

Format:

N/A

General Description:

Indicates whether the record source is "Payroll" or "Provision"

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Sub_Campus_ID

Long Name:

Sub_Campus_ID

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Defines major organizational units within the University

Code Interpretation:

Code   Title

'1'         General Campus

'2'         Health Sciences

'3'         Marine Sciences

Comments:

Revision Date:

Data Element Name:

Sub-Campus ID Code

Long Name:

Sub-Campus ID Code

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating a University organizational category.

Code Interpretation:

'1' - General campus
'2' - Health sciences
'3'- Marine sciences

Comments:

Revision Date:

Data Element Name:

Title_Code

Long Name:

Title Code

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

Code indicating an appointment of the employee

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Title_Name

Long Name:

Title_Name

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

The abbreviated name of the position associated with a title code.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

TUC

Long Name:

Title Unit Code

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the collective bargaining unit to which a title code belongs.

Code Interpretation:

See TUC in Personnel Data Warehouse Data Elements

Comments:

Revision Date: